final_project_merge_to_gold(Python)

Loading...

Gold Table Integration - MParker

databaseName_widget = dbutils.widgets.text("database_name", "group5_finalproject", "Database Name")
databaseName = dbutils.widgets.get("database_name") 
 
spark.sql(f"CREATE DATABASE IF NOT EXISTS {databaseName}")
spark.sql(f"use {databaseName}")
Out[47]: DataFrame[]
twitter_df = (spark
              .read
              .format('delta')
              .load('dbfs:/user/hive/warehouse/group5_finalproject.db/twitter_silver'))
twitter_df.createOrReplaceTempView('twitter_df')
display(twitter_df)
 
id
text
QUERY
yfinance_ticker
user_name
result_type
favorite_count
followers_count
retweet_count
created_at
day
hour
minute
sentiment
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1469714424747417608
RT @MalcolmHuntley2: Some great people to talk to if your interested in $ALGO. @Jeff_Malko @dfart2287 @D4Ocrypto @kapturedbykeeg And
@algorand
ALGO-USD
Jeff_Malko
recent
0
1624
1624
2021-12-11T17:03:19.000+0000
12-11-2021
17
15
positive
1469714374176784384
Some great people to talk to if your interested in $ALGO. @Jeff_Malko @dfart2287 @D4Ocrypto @kapturedbykeeg A https://t.co/easF2O23Tg
@algorand
ALGO-USD
MalcolmHuntley2
recent
35
988
988
2021-12-11T17:03:07.000+0000
12-11-2021
17
15
positive
1469714338990731264
@Donut_Daniel_ @technologypoet @21blacky @MichaelGKress @TheSerenation @CryptoTechs @WesleyBKress Have you research https://t.co/PabyP64fFo
@algorand
ALGO-USD
sarajane2004
recent
3
1211
1211
2021-12-11T17:02:59.000+0000
12-11-2021
17
15
positive
1469713660222312451
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
EldarDRM
recent
0
4882
4882
2021-12-11T17:00:17.000+0000
12-11-2021
17
15
negative
1469713530844762114
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
CRYPT0forCHANGE
recent
0
652
652
2021-12-11T16:59:46.000+0000
12-11-2021
17
0
negative
1469713211029012484
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
to_poop
recent
0
241
241
2021-12-11T16:58:30.000+0000
12-11-2021
17
0
negative
1469713058067107847
RT @AlgoFamily: This 18 second clip is making its rounds in the @Algorand circles. Coming to @SmilecoinUS. $SMILE $ALGO. https://t.co/q87
@algorand
ALGO-USD
RadDadMetsFan
recent
0
2039
2039
2021-12-11T16:57:53.000+0000
12-11-2021
17
0
positive
1469712970913517573
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
RealAPEstudent
recent
0
23
23
2021-12-11T16:57:32.000+0000
12-11-2021
17
0
negative
1469712711114231812
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
ElonMucuk
recent
0
3
3
2021-12-11T16:56:30.000+0000
12-11-2021
17
0
negative
1469712639148412934
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
list_loud
recent
0
10
10
2021-12-11T16:56:13.000+0000
12-11-2021
17
0
negative
1469712290622672900
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
aydinogan
recent
0
228
228
2021-12-11T16:54:50.000+0000
12-11-2021
17
0
negative
1469712144908394501
RT @ceoleeparsons: $OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG TERM
@algorand
ALGO-USD
Zalvianss
recent
0
31
31
2021-12-11T16:54:15.000+0000
12-11-2021
17
0
negative
1469711746042581006
$OPUL has a FIVE year vesting schedule. Me, @Brad_Laurie, even @Algorand don't get tokens for 5 years. We are LONG https://t.co/2dXyHEVUZQ
@algorand
ALGO-USD
ceoleeparsons
recent
265
23033
23033
2021-12-11T16:52:40.000+0000
12-11-2021
17
0
negative
1469711634239299588
Once people understand how EASY and CHEAP it is to buy $ALGO on a major exchange, transfer it to the @Algorand wall https://t.co/2DA8sp2IbD
@algorand
ALGO-USD
TheYearofDeFi
recent
3
11
11
2021-12-11T16:52:14.000+0000
12-11-2021
17
0
positive
1469710345585446915
If you don't know about $ALGO check this thread out, click on the links, learn a bit and then the @Algorand family https://t.co/VldQNiPaD1
@algorand
ALGO-USD
Hobbs50131773
recent
21
8
8
2021-12-11T16:47:06.000+0000
12-11-2021
17
0
positive
1469710136537145349
RT @Bmorecmore: So far, I only turned on Twitter Notifications for 4 Accounts: @Algorand @AlgoFoundation @ceoleeparsons @AlgoFamily $
@algorand
ALGO-USD
EPIC35817363
recent
0
233
233
2021-12-11T16:46:17.000+0000
12-11-2021
17
0
negative
1469708382676340741
RT @lukas_trips: Unique edition of my second #NFTs video on the @Algorand blockchain. Avaliable now on @_Dartroom Blum Shub Octopus is
@algorand
ALGO-USD
_Dartroom
recent
0
4914
4914
2021-12-11T16:39:18.000+0000
12-11-2021
16
45
positive

Truncated results, showing first 1000 rows.

financeDF = (spark
              .read
              .format('delta')
              .load('dbfs:/user/hive/warehouse/group5_finalproject.db/pricing_info_raw'))
financeDF.createOrReplaceTempView('financeDF')
display(financeDF)
 
ticker
date
day
hour
minute
open
high
low
close
delta
volume
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
XLM-USD
2021-11-14T00:00:00.000+0000
11-14-2021
00
00
0.3787156641
0.3791258633
0.3775140941
0.379062891
0.09168537
0
XLM-USD
2021-11-14T00:15:00.000+0000
11-14-2021
00
15
0.3789846897
0.3820196688
0.3789846897
0.3819986581
0.7952744661
6135104
XLM-USD
2021-11-14T00:30:00.000+0000
11-14-2021
00
30
0.382071793
0.382071793
0.3799237906
0.3804431259
-0.4262725345
1543520
XLM-USD
2021-11-14T00:45:00.000+0000
11-14-2021
00
45
0.3805024623
0.380641669
0.3798090517
0.3798090517
-0.1822355184
0
XLM-USD
2021-11-14T01:00:00.000+0000
11-14-2021
01
00
0.3801787197
0.3803540766
0.3794460892
0.3794460892
-0.1927068647
652192
XLM-USD
2021-11-14T01:15:00.000+0000
11-14-2021
01
15
0.3793845474
0.3795706331
0.3784240484
0.3784240484
-0.2531729493
250016
XLM-USD
2021-11-14T01:30:00.000+0000
11-14-2021
01
30
0.3782568871
0.3782866001
0.3768002092
0.3772785663
-0.2586392661
770624
XLM-USD
2021-11-14T01:45:00.000+0000
11-14-2021
01
45
0.3771820962
0.3777139782
0.3771820962
0.377326548
0.038297644
0
XLM-USD
2021-11-14T02:00:00.000+0000
11-14-2021
02
00
0.3772118985
0.3772118985
0.3763490617
0.3763490617
-0.2287406206
1157184
XLM-USD
2021-11-14T02:15:00.000+0000
11-14-2021
02
15
0.3763188421
0.3765555918
0.375444293
0.3756209909
-0.1854414668
3489664
XLM-USD
2021-11-14T02:30:00.000+0000
11-14-2021
02
30
0.3756076991
0.3759654164
0.3747685253
0.3747815787
-0.2199423436
1863104
XLM-USD
2021-11-14T02:45:00.000+0000
11-14-2021
02
45
0.3747919797
0.3749218285
0.3740890324
0.3740890324
-0.1875566757
0
XLM-USD
2021-11-14T03:00:00.000+0000
11-14-2021
03
00
0.3739501535
0.3745685517
0.3739501535
0.3744064271
0.1220145389
321376
XLM-USD
2021-11-14T03:15:00.000+0000
11-14-2021
03
15
0.3735640347
0.3744719028
0.3731134533
0.3731657862
-0.1066078093
2924896
XLM-USD
2021-11-14T03:30:00.000+0000
11-14-2021
03
30
0.3731117248
0.3736774623
0.3729177415
0.373455286
0.0920799721
1458400
XLM-USD
2021-11-14T03:45:00.000+0000
11-14-2021
03
45
0.3731119036
0.373660922
0.3725823462
0.3729176819
-0.0520545533
2117856
XLM-USD
2021-11-14T04:00:00.000+0000
11-14-2021
04
00
0.372745037
0.374259144
0.372745037
0.374259144
0.4062044664
302592

Truncated results, showing first 1000 rows.

%sql
 
SELECT
  TDFP.id,
  TDFP.text,
  TDFP.QUERY,
  TDFP.user_name,
  TDFP.followers_count,
  TDFP.retweet_count,
  TDFP.created_at,
  TDFP.sentiment,
  financeDF.ticker,
  financeDF.date,
  financeDF.open,
  financeDF.high,
  financeDF.low,
  financeDF.close,
  financeDF.delta,
  financeDF.volume
FROM
  twitter_df TDFP
JOIN financeDF ON
  TDFP.yfinance_ticker = financeDF.ticker
  AND TDFP.day = financeDF.day
  AND TDFP.hour = financeDF.hour
  AND TDFP.minute = financeDF.minute
  
  
 
id
text
QUERY
user_name
followers_count
retweet_count
created_at
sentiment
ticker
date
open
high
low
close
delta
volume
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1469532425839693828
RT @cryptomafia_id: What is your favorite #Crypto $SOL $ADA $BNB $SOUL @solana @Cardano @binance @PhantasmaChain
@cardano
BryannaDion23
229
229
2021-12-11T05:00:07.000+0000
positive
ADA-USD
2021-12-11T05:15:00.000+0000
1.2438782453
1.245545268
1.2420632839
1.2425876855
-0.1037529013
0
1469544314166513664
RT @cryptomafia_id: What is your favorite #Crypto $SOL $ADA $BNB $SOUL @solana @Cardano @binance @PhantasmaChain
@cardano
mafon221290
176
176
2021-12-11T05:47:21.000+0000
positive
ADA-USD
2021-12-11T06:00:00.000+0000
1.2428263425
1.2551461458
1.2398444414
1.2551207542
0.9892300507
21807360
1469546769084264449
RT @GuardaWallet: There are multiple options to manage #Cardano on Guarda Wallet: Store and #HODL $ADA safely Purchase and swap $ADA S
@cardano
jvsephii
1140
1140
2021-12-11T05:57:07.000+0000
neutral
ADA-USD
2021-12-11T06:00:00.000+0000
1.2428263425
1.2551461458
1.2398444414
1.2551207542
0.9892300507
21807360
1469582760595664900
We are full partners with $DTPT to change the world forever for good. Please support our joint Fund 7 Proposal & VO https://t.co/cJqJ3UzuyY
@cardano
IntenseWebs
1389
1389
2021-12-11T08:20:08.000+0000
positive
ADA-USD
2021-12-11T08:30:00.000+0000
1.2620229721
1.2629565
1.2565938234
1.2617337703
-0.0229157268
11121920
1469585748055650308
#ADAUSDT 1D Chart Update #ADA $ADA #Cardano #CardanoCommunity @Cardano @CardanoStiftung Follow for more........... https://t.co/wgtFqILPk1
@cardano
VestLearn
71
71
2021-12-11T08:32:00.000+0000
positive
ADA-USD
2021-12-11T08:45:00.000+0000
1.2617093324
1.2628859281
1.2556105852
1.2604695558
-0.098261666
10844544
1469586597234499588
We are full partners with $DTPT to change the world forever for good. Please support our joint Fund 7 Proposal & VO https://t.co/CeBjLHUuY5
@cardano
IFFinance
388
388
2021-12-11T08:35:23.000+0000
positive
ADA-USD
2021-12-11T08:45:00.000+0000
1.2617093324
1.2628859281
1.2556105852
1.2604695558
-0.098261666
10844544
1469587696204988417
RT @VestLearn: #ADAUSDT 1D Chart Update #ADA $ADA #Cardano #CardanoCommunity @Cardano @CardanoStiftung Follow for more........... https:/
@cardano
Jigar_jn
1
1
2021-12-11T08:39:45.000+0000
positive
ADA-USD
2021-12-11T08:45:00.000+0000
1.2617093324
1.2628859281
1.2556105852
1.2604695558
-0.098261666
10844544
1469600974473998337
#Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alli https://t.co/6qVY9RT2mf
@cardano
patryk_karter
920
920
2021-12-11T09:32:30.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469601265709633539
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
CryptoJoe101
2346
2346
2021-12-11T09:33:40.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469601345581821960
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
JoriPLevy
3265
3265
2021-12-11T09:33:59.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469602965128425473
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
cuteadasquirrel
838
838
2021-12-11T09:40:25.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469605007968419850
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
FlaCaradonna
72
72
2021-12-11T09:48:32.000+0000
negative
ADA-USD
2021-12-11T10:00:00.000+0000
1.276022911
1.2803144454
1.2709902524
1.2775621414
0.1206271716
2251776
1469607259831676929
RT @GalaxyHeroesGHC: @binance @Cardano Wonder if $GHC will have a bsc bridge to $ADA
@cardano
PauletteGrady4
5
5
2021-12-11T09:57:29.000+0000
positive
ADA-USD
2021-12-11T10:00:00.000+0000
1.276022911
1.2803144454
1.2709902524
1.2775621414
0.1206271716
2251776
1469611996014338052
What Lies Behind The Price Ditch Of Solana (SOL), Cardano (ADA), and Algorand (ALGO)? Wouldnt we all like to know https://t.co/0UrAZcvSlF
@cardano
CrypticStonks
315
315
2021-12-11T10:16:18.000+0000
positive
ADA-USD
2021-12-11T10:30:00.000+0000
1.2769660949
1.2796992063
1.2764433622
1.2795754671
0.2043415364
6592128
1469619702389682176
RT @GalaxyHeroesGHC: @binance @Cardano Wonder if $GHC will have a bsc bridge to $ADA
@cardano
Deborah57415508
6
6
2021-12-11T10:46:55.000+0000
positive
ADA-USD
2021-12-11T11:00:00.000+0000
1.2879171371
1.2978562116
1.2843152284
1.2953426837
0.5765546891
13281152
1469620619671187465
@CryptoDoc2020 @Cardano @streamr Yup $ada and $data are very similar in moving. I don't like them that much on pri https://t.co/UCLb1xTZxo
@cardano
rogerquantrillo
6616
6616
2021-12-11T10:50:34.000+0000
positive
ADA-USD
2021-12-11T11:00:00.000+0000
1.2879171371
1.2978562116
1.2843152284
1.2953426837
0.5765546891
13281152
1469628756675510283
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
BraveHeartStak3
3830
3830
2021-12-11T11:22:54.000+0000
negative
ADA-USD
2021-12-11T11:30:00.000+0000
1.2889671325
1.2889671325
1.2811111211
1.2844227552
-0.3525595969
3170176

Truncated results, showing first 1000 rows.

goldDF = spark.sql("SELECT \
  TDFP.id, \
  TDFP.text, \
  TDFP.QUERY, \
  TDFP.user_name, \
  TDFP.followers_count, \
  TDFP.retweet_count, \
  TDFP.created_at, \
  TDFP.sentiment, \
  financeDF.ticker, \
  financeDF.date, \
  financeDF.open, \
  financeDF.high, \
  financeDF.low, \
  financeDF.close, \
  financeDF.delta, \
  financeDF.volume \
FROM \
  twitter_df TDFP \
JOIN financeDF ON \
  TDFP.yfinance_ticker = financeDF.ticker \
  AND TDFP.day = financeDF.day \
  AND TDFP.hour = financeDF.hour \
  AND TDFP.minute = financeDF.minute")
 
goldDF \
     .write \
     .format('delta') \
     .mode('overwrite') \
     .option("overwriteSchema", "true") \
     .saveAsTable("gold")
 
display(spark.read.table("gold"))
 
id
text
QUERY
user_name
followers_count
retweet_count
created_at
sentiment
ticker
date
open
high
low
close
delta
volume
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1469532425839693828
RT @cryptomafia_id: What is your favorite #Crypto $SOL $ADA $BNB $SOUL @solana @Cardano @binance @PhantasmaChain
@cardano
BryannaDion23
229
229
2021-12-11T05:00:07.000+0000
positive
ADA-USD
2021-12-11T05:15:00.000+0000
1.2438782453
1.245545268
1.2420632839
1.2425876855
-0.1037529013
0
1469544314166513664
RT @cryptomafia_id: What is your favorite #Crypto $SOL $ADA $BNB $SOUL @solana @Cardano @binance @PhantasmaChain
@cardano
mafon221290
176
176
2021-12-11T05:47:21.000+0000
positive
ADA-USD
2021-12-11T06:00:00.000+0000
1.2428263425
1.2551461458
1.2398444414
1.2551207542
0.9892300507
21807360
1469546769084264449
RT @GuardaWallet: There are multiple options to manage #Cardano on Guarda Wallet: Store and #HODL $ADA safely Purchase and swap $ADA S
@cardano
jvsephii
1140
1140
2021-12-11T05:57:07.000+0000
neutral
ADA-USD
2021-12-11T06:00:00.000+0000
1.2428263425
1.2551461458
1.2398444414
1.2551207542
0.9892300507
21807360
1469582760595664900
We are full partners with $DTPT to change the world forever for good. Please support our joint Fund 7 Proposal & VO https://t.co/cJqJ3UzuyY
@cardano
IntenseWebs
1389
1389
2021-12-11T08:20:08.000+0000
positive
ADA-USD
2021-12-11T08:30:00.000+0000
1.2620229721
1.2629565
1.2565938234
1.2617337703
-0.0229157268
11121920
1469585748055650308
#ADAUSDT 1D Chart Update #ADA $ADA #Cardano #CardanoCommunity @Cardano @CardanoStiftung Follow for more........... https://t.co/wgtFqILPk1
@cardano
VestLearn
71
71
2021-12-11T08:32:00.000+0000
positive
ADA-USD
2021-12-11T08:45:00.000+0000
1.2617093324
1.2628859281
1.2556105852
1.2604695558
-0.098261666
10844544
1469586597234499588
We are full partners with $DTPT to change the world forever for good. Please support our joint Fund 7 Proposal & VO https://t.co/CeBjLHUuY5
@cardano
IFFinance
388
388
2021-12-11T08:35:23.000+0000
positive
ADA-USD
2021-12-11T08:45:00.000+0000
1.2617093324
1.2628859281
1.2556105852
1.2604695558
-0.098261666
10844544
1469587696204988417
RT @VestLearn: #ADAUSDT 1D Chart Update #ADA $ADA #Cardano #CardanoCommunity @Cardano @CardanoStiftung Follow for more........... https:/
@cardano
Jigar_jn
1
1
2021-12-11T08:39:45.000+0000
positive
ADA-USD
2021-12-11T08:45:00.000+0000
1.2617093324
1.2628859281
1.2556105852
1.2604695558
-0.098261666
10844544
1469600974473998337
#Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alli https://t.co/6qVY9RT2mf
@cardano
patryk_karter
920
920
2021-12-11T09:32:30.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469601265709633539
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
CryptoJoe101
2346
2346
2021-12-11T09:33:40.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469601345581821960
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
JoriPLevy
3265
3265
2021-12-11T09:33:59.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469602965128425473
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
cuteadasquirrel
838
838
2021-12-11T09:40:25.000+0000
negative
ADA-USD
2021-12-11T09:45:00.000+0000
1.2728588581
1.2769327163
1.2697468996
1.2768757343
0.3155790758
1342848
1469605007968419850
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
FlaCaradonna
72
72
2021-12-11T09:48:32.000+0000
negative
ADA-USD
2021-12-11T10:00:00.000+0000
1.276022911
1.2803144454
1.2709902524
1.2775621414
0.1206271716
2251776
1469607259831676929
RT @GalaxyHeroesGHC: @binance @Cardano Wonder if $GHC will have a bsc bridge to $ADA
@cardano
PauletteGrady4
5
5
2021-12-11T09:57:29.000+0000
positive
ADA-USD
2021-12-11T10:00:00.000+0000
1.276022911
1.2803144454
1.2709902524
1.2775621414
0.1206271716
2251776
1469611996014338052
What Lies Behind The Price Ditch Of Solana (SOL), Cardano (ADA), and Algorand (ALGO)? Wouldnt we all like to know https://t.co/0UrAZcvSlF
@cardano
CrypticStonks
315
315
2021-12-11T10:16:18.000+0000
positive
ADA-USD
2021-12-11T10:30:00.000+0000
1.2769660949
1.2796992063
1.2764433622
1.2795754671
0.2043415364
6592128
1469619702389682176
RT @GalaxyHeroesGHC: @binance @Cardano Wonder if $GHC will have a bsc bridge to $ADA
@cardano
Deborah57415508
6
6
2021-12-11T10:46:55.000+0000
positive
ADA-USD
2021-12-11T11:00:00.000+0000
1.2879171371
1.2978562116
1.2843152284
1.2953426837
0.5765546891
13281152
1469620619671187465
@CryptoDoc2020 @Cardano @streamr Yup $ada and $data are very similar in moving. I don't like them that much on pri https://t.co/UCLb1xTZxo
@cardano
rogerquantrillo
6616
6616
2021-12-11T10:50:34.000+0000
positive
ADA-USD
2021-12-11T11:00:00.000+0000
1.2879171371
1.2978562116
1.2843152284
1.2953426837
0.5765546891
13281152
1469628756675510283
RT @patryk_karter: #Cardano #SPO Column #037: @AdaSquirrel [SQRL] Topics: - Why @Cardano? - What is the @CardanoSPA (Single Pool Alliance)
@cardano
BraveHeartStak3
3830
3830
2021-12-11T11:22:54.000+0000
negative
ADA-USD
2021-12-11T11:30:00.000+0000
1.2889671325
1.2889671325
1.2811111211
1.2844227552
-0.3525595969
3170176

Truncated results, showing first 1000 rows.