PREVIEW / etf_1hour / 2002-06-26
file: by_date/etf_1hour/2002/2002-06-26.parquet size: 15 KB rows: 321
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-06-26 09:00:00 | SPY | ETF | 95.2 | 96.5 | 95.19 | 96.5 | 3833100.0 |
| 2002-06-26 10:00:00 | SPY | ETF | 96.5 | 96.79 | 95.69 | 96.04 | 4123000.0 |
| 2002-06-26 11:00:00 | SPY | ETF | 96.02 | 97.57 | 95.95 | 97.48 | 4717300.0 |
| 2002-06-26 12:00:00 | SPY | ETF | 97.46 | 97.54 | 96.67 | 96.75 | 2702200.0 |
| 2002-06-26 13:00:00 | SPY | ETF | 96.71 | 96.78 | 96.01 | 96.12 | 2074800.0 |
| 2002-06-26 14:00:00 | SPY | ETF | 96.18 | 97.0 | 95.6 | 96.39 | 4098200.0 |
| 2002-06-26 15:00:00 | SPY | ETF | 96.4 | 98.15 | 96.2 | 97.62 | 5920300.0 |
| 2002-06-26 16:00:00 | SPY | ETF | 97.65 | 97.81 | 97.38 | 97.75 | 2053600.0 |
| 2002-06-26 17:00:00 | SPY | ETF | 97.9 | 97.9 | 97.63 | 97.7 | 407300.0 |
| 2002-06-26 18:00:00 | SPY | ETF | 97.8 | 97.9 | 97.8 | 97.9 | 9900.0 |
| 2002-06-26 09:00:00 | QQQ | ETF | 24.43 | 24.93 | 24.39 | 24.92 | 20532700.0 |
| 2002-06-26 10:00:00 | QQQ | ETF | 24.91 | 25.13 | 24.57 | 24.82 | 19666800.0 |
| 2002-06-26 11:00:00 | QQQ | ETF | 24.79 | 25.42 | 24.74 | 25.39 | 15149400.0 |
| 2002-06-26 12:00:00 | QQQ | ETF | 25.38 | 25.42 | 24.92 | 24.95 | 12364300.0 |
| 2002-06-26 13:00:00 | QQQ | ETF | 24.95 | 25.07 | 24.72 | 24.78 | 8079000.0 |
| 2002-06-26 14:00:00 | QQQ | ETF | 24.79 | 25.3 | 24.65 | 25.14 | 19101600.0 |
| 2002-06-26 15:00:00 | QQQ | ETF | 25.11 | 25.78 | 25.04 | 25.57 | 24134300.0 |
| 2002-06-26 16:00:00 | QQQ | ETF | 25.57 | 25.74 | 24.99 | 25.56 | 3905100.0 |
| 2002-06-26 17:00:00 | QQQ | ETF | 25.58 | 25.59 | 24.8 | 25.53 | 612300.0 |
| 2002-06-26 18:00:00 | QQQ | ETF | 25.55 | 25.66 | 25.53 | 25.65 | 48500.0 |
| 2002-06-26 09:00:00 | IWM | ETF | 44.0 | 44.315 | 43.95 | 44.315 | 415600.0 |
| 2002-06-26 10:00:00 | IWM | ETF | 44.28 | 44.545 | 44.115 | 44.33 | 163600.0 |
| 2002-06-26 11:00:00 | IWM | ETF | 44.305 | 44.77 | 44.3 | 44.77 | 301000.0 |
| 2002-06-26 12:00:00 | IWM | ETF | 44.875 | 44.92 | 44.63 | 44.73 | 181200.0 |
| 2002-06-26 13:00:00 | IWM | ETF | 44.635 | 44.77 | 44.57 | 44.705 | 4133600.0 |
| 2002-06-26 14:00:00 | IWM | ETF | 44.705 | 45.115 | 44.6 | 44.94 | 525600.0 |
| 2002-06-26 15:00:00 | IWM | ETF | 44.935 | 45.155 | 44.825 | 45.15 | 793800.0 |
| 2002-06-26 16:00:00 | IWM | ETF | 45.145 | 45.15 | 44.985 | 45.025 | 43000.0 |
| 2002-06-26 17:00:00 | IWM | ETF | 44.665 | 44.665 | 44.665 | 44.665 | 110000.0 |
| 2002-06-26 09:00:00 | DIA | ETF | 89.36 | 90.4 | 89.09 | 90.25 | 1307400.0 |
| 2002-06-26 10:00:00 | DIA | ETF | 90.25 | 90.55 | 89.56 | 89.77 | 923300.0 |
| 2002-06-26 11:00:00 | DIA | ETF | 89.88 | 91.04 | 89.67 | 90.92 | 901700.0 |
| 2002-06-26 12:00:00 | DIA | ETF | 90.9 | 90.99 | 90.15 | 90.39 | 332100.0 |
| 2002-06-26 13:00:00 | DIA | ETF | 90.37 | 90.4 | 89.68 | 89.87 | 338900.0 |
| 2002-06-26 14:00:00 | DIA | ETF | 89.75 | 90.64 | 89.25 | 90.18 | 1182700.0 |
| 2002-06-26 15:00:00 | DIA | ETF | 90.11 | 91.99 | 89.95 | 91.41 | 1462300.0 |
| 2002-06-26 16:00:00 | DIA | ETF | 91.44 | 91.5 | 90.1 | 91.35 | 142600.0 |
| 2002-06-26 17:00:00 | DIA | ETF | 91.3 | 91.3 | 91.3 | 91.3 | 100.0 |
| 2002-06-26 18:00:00 | DIA | ETF | 91.29 | 91.29 | 91.29 | 91.29 | 300.0 |
> showing 39 of 321 rows — these rows as CSV