PREVIEW / etf_1hour / 2002-03-25
file: by_date/etf_1hour/2002/2002-03-25.parquet size: 14 KB rows: 301
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2002-03-25 09:00:00 | SPY | ETF | 115.09 | 115.36 | 114.96 | 115.06 | 1594900.0 |
| 2002-03-25 10:00:00 | SPY | ETF | 115.09 | 115.16 | 114.3 | 114.3 | 3359100.0 |
| 2002-03-25 11:00:00 | SPY | ETF | 114.32 | 114.5 | 114.2 | 114.36 | 1614300.0 |
| 2002-03-25 12:00:00 | SPY | ETF | 114.36 | 114.4 | 114.03 | 114.19 | 1051100.0 |
| 2002-03-25 13:00:00 | SPY | ETF | 114.14 | 114.53 | 114.07 | 114.28 | 2196300.0 |
| 2002-03-25 14:00:00 | SPY | ETF | 114.27 | 114.54 | 114.19 | 114.31 | 1445300.0 |
| 2002-03-25 15:00:00 | SPY | ETF | 114.33 | 114.33 | 113.38 | 113.42 | 5026200.0 |
| 2002-03-25 16:00:00 | SPY | ETF | 113.43 | 114.42 | 113.3 | 113.65 | 1042000.0 |
| 2002-03-25 17:00:00 | SPY | ETF | 113.63 | 113.65 | 113.63 | 113.65 | 1500.0 |
| 2002-03-25 18:00:00 | SPY | ETF | 113.7 | 114.42 | 113.64 | 113.64 | 7600.0 |
| 2002-03-25 09:00:00 | QQQ | ETF | 36.69 | 36.9 | 36.55 | 36.63 | 7016500.0 |
| 2002-03-25 10:00:00 | QQQ | ETF | 36.63 | 36.75 | 36.01 | 36.02 | 13075200.0 |
| 2002-03-25 11:00:00 | QQQ | ETF | 36.02 | 36.13 | 35.9 | 36.0 | 10863900.0 |
| 2002-03-25 12:00:00 | QQQ | ETF | 36.0 | 36.05 | 35.75 | 35.87 | 9426000.0 |
| 2002-03-25 13:00:00 | QQQ | ETF | 35.85 | 36.04 | 35.76 | 35.92 | 7978400.0 |
| 2002-03-25 14:00:00 | QQQ | ETF | 35.92 | 36.2 | 35.89 | 36.02 | 7312800.0 |
| 2002-03-25 15:00:00 | QQQ | ETF | 35.98 | 36.02 | 35.53 | 35.58 | 26356800.0 |
| 2002-03-25 16:00:00 | QQQ | ETF | 35.55 | 35.7 | 35.52 | 35.65 | 4222700.0 |
| 2002-03-25 17:00:00 | QQQ | ETF | 35.65 | 35.66 | 35.6 | 35.64 | 48000.0 |
| 2002-03-25 18:00:00 | QQQ | ETF | 35.63 | 35.64 | 35.62 | 35.63 | 5600.0 |
| 2002-03-25 09:00:00 | IWM | ETF | 50.025 | 50.07 | 49.85 | 49.86 | 166800.0 |
| 2002-03-25 10:00:00 | IWM | ETF | 49.875 | 49.94 | 49.59 | 49.59 | 255400.0 |
| 2002-03-25 11:00:00 | IWM | ETF | 49.59 | 49.605 | 49.41 | 49.465 | 73400.0 |
| 2002-03-25 12:00:00 | IWM | ETF | 49.48 | 49.5 | 49.32 | 49.355 | 552600.0 |
| 2002-03-25 13:00:00 | IWM | ETF | 49.36 | 49.505 | 49.34 | 49.48 | 63600.0 |
| 2002-03-25 14:00:00 | IWM | ETF | 49.41 | 49.56 | 49.41 | 49.56 | 158200.0 |
| 2002-03-25 15:00:00 | IWM | ETF | 49.525 | 49.56 | 49.225 | 49.295 | 569800.0 |
| 2002-03-25 16:00:00 | IWM | ETF | 49.285 | 49.36 | 49.255 | 49.295 | 32400.0 |
| 2002-03-25 09:00:00 | DIA | ETF | 104.19 | 104.59 | 104.19 | 104.39 | 486800.0 |
| 2002-03-25 10:00:00 | DIA | ETF | 104.38 | 104.58 | 103.95 | 103.97 | 595500.0 |
| 2002-03-25 11:00:00 | DIA | ETF | 103.95 | 104.0 | 103.73 | 103.85 | 861200.0 |
| 2002-03-25 12:00:00 | DIA | ETF | 103.85 | 103.85 | 103.51 | 103.55 | 758900.0 |
| 2002-03-25 13:00:00 | DIA | ETF | 103.55 | 103.92 | 103.43 | 103.66 | 869500.0 |
| 2002-03-25 14:00:00 | DIA | ETF | 103.7 | 103.93 | 103.63 | 103.74 | 255400.0 |
| 2002-03-25 15:00:00 | DIA | ETF | 103.68 | 103.68 | 102.84 | 102.9 | 1393200.0 |
| 2002-03-25 16:00:00 | DIA | ETF | 102.86 | 103.0 | 102.85 | 102.9 | 369500.0 |
> showing 36 of 301 rows — these rows as CSV