PREVIEW / etf_1hour / 2002-03-28
file: by_date/etf_1hour/2002/2002-03-28.parquet size: 14 KB rows: 297
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-28 09:00:00 | SPY | ETF | 114.97 | 115.49 | 114.68 | 115.37 | 3129000.0 |
| 2002-03-28 10:00:00 | SPY | ETF | 115.41 | 115.77 | 115.37 | 115.48 | 3922500.0 |
| 2002-03-28 11:00:00 | SPY | ETF | 115.49 | 115.6 | 115.04 | 115.04 | 1862900.0 |
| 2002-03-28 12:00:00 | SPY | ETF | 115.03 | 115.3 | 114.9 | 114.9 | 1380000.0 |
| 2002-03-28 13:00:00 | SPY | ETF | 114.92 | 115.29 | 114.72 | 115.21 | 1696900.0 |
| 2002-03-28 14:00:00 | SPY | ETF | 115.19 | 115.44 | 114.99 | 115.25 | 1279400.0 |
| 2002-03-28 15:00:00 | SPY | ETF | 115.2 | 115.34 | 114.89 | 114.91 | 2551500.0 |
| 2002-03-28 16:00:00 | SPY | ETF | 114.9 | 115.07 | 114.3 | 114.45 | 1542700.0 |
| 2002-03-28 17:00:00 | SPY | ETF | 114.42 | 114.56 | 114.42 | 114.49 | 8900.0 |
| 2002-03-28 09:00:00 | QQQ | ETF | 36.02 | 36.16 | 35.9 | 36.12 | 8649500.0 |
| 2002-03-28 10:00:00 | QQQ | ETF | 36.14 | 36.36 | 36.11 | 36.18 | 14385300.0 |
| 2002-03-28 11:00:00 | QQQ | ETF | 36.17 | 36.3 | 36.07 | 36.08 | 6632100.0 |
| 2002-03-28 12:00:00 | QQQ | ETF | 36.08 | 36.2 | 36.03 | 36.05 | 4619300.0 |
| 2002-03-28 13:00:00 | QQQ | ETF | 36.05 | 36.28 | 35.95 | 36.24 | 5665900.0 |
| 2002-03-28 14:00:00 | QQQ | ETF | 36.24 | 36.37 | 36.14 | 36.27 | 7315100.0 |
| 2002-03-28 15:00:00 | QQQ | ETF | 36.3 | 36.32 | 36.12 | 36.15 | 9734600.0 |
| 2002-03-28 16:00:00 | QQQ | ETF | 36.14 | 36.25 | 36.04 | 36.08 | 1479300.0 |
| 2002-03-28 17:00:00 | QQQ | ETF | 36.07 | 36.16 | 36.01 | 36.06 | 82300.0 |
| 2002-03-28 18:00:00 | QQQ | ETF | 36.05 | 36.09 | 36.03 | 36.04 | 40400.0 |
| 2002-03-28 09:00:00 | IWM | ETF | 50.45 | 50.675 | 50.4 | 50.65 | 202000.0 |
| 2002-03-28 10:00:00 | IWM | ETF | 50.675 | 50.715 | 50.565 | 50.65 | 793000.0 |
| 2002-03-28 11:00:00 | IWM | ETF | 50.635 | 50.68 | 50.445 | 50.46 | 125800.0 |
| 2002-03-28 12:00:00 | IWM | ETF | 50.455 | 50.525 | 50.295 | 50.385 | 128800.0 |
| 2002-03-28 13:00:00 | IWM | ETF | 50.375 | 50.515 | 50.285 | 50.405 | 86600.0 |
| 2002-03-28 14:00:00 | IWM | ETF | 50.395 | 50.565 | 50.395 | 50.49 | 47800.0 |
| 2002-03-28 15:00:00 | IWM | ETF | 50.49 | 50.55 | 50.225 | 50.225 | 187600.0 |
| 2002-03-28 16:00:00 | IWM | ETF | 50.255 | 50.325 | 50.05 | 50.05 | 144600.0 |
| 2002-03-28 09:00:00 | DIA | ETF | 104.6 | 104.87 | 104.24 | 104.78 | 312800.0 |
| 2002-03-28 10:00:00 | DIA | ETF | 104.78 | 105.12 | 104.74 | 104.87 | 515500.0 |
| 2002-03-28 11:00:00 | DIA | ETF | 104.87 | 104.97 | 104.46 | 104.5 | 331200.0 |
| 2002-03-28 12:00:00 | DIA | ETF | 104.5 | 104.65 | 104.25 | 104.3 | 821600.0 |
| 2002-03-28 13:00:00 | DIA | ETF | 104.25 | 104.57 | 104.08 | 104.48 | 512900.0 |
| 2002-03-28 14:00:00 | DIA | ETF | 104.45 | 104.59 | 104.23 | 104.43 | 246400.0 |
| 2002-03-28 15:00:00 | DIA | ETF | 104.43 | 104.53 | 104.08 | 104.12 | 1113700.0 |
| 2002-03-28 16:00:00 | DIA | ETF | 104.08 | 104.26 | 103.7 | 103.75 | 101800.0 |
| 2002-03-28 17:00:00 | DIA | ETF | 103.75 | 103.75 | 103.75 | 103.75 | 1900.0 |
> showing 36 of 297 rows — these rows as CSV