PREVIEW / etf_1hour / 2001-04-11
file: by_date/etf_1hour/2001/2001-04-11.parquet size: 12 KB rows: 232
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-11 09:00:00 | SPY | ETF | 118.78 | 118.99 | 117.3 | 117.47 | 3248300.0 |
| 2001-04-11 10:00:00 | SPY | ETF | 117.35 | 118.0 | 117.03 | 117.3 | 2025500.0 |
| 2001-04-11 11:00:00 | SPY | ETF | 117.35 | 117.55 | 116.4 | 116.72 | 1737900.0 |
| 2001-04-11 12:00:00 | SPY | ETF | 116.88 | 117.07 | 116.35 | 116.8 | 1093800.0 |
| 2001-04-11 13:00:00 | SPY | ETF | 116.9 | 117.43 | 116.8 | 116.92 | 880900.0 |
| 2001-04-11 14:00:00 | SPY | ETF | 116.96 | 117.37 | 116.54 | 116.54 | 1295500.0 |
| 2001-04-11 15:00:00 | SPY | ETF | 116.57 | 116.96 | 116.14 | 116.96 | 1880800.0 |
| 2001-04-11 16:00:00 | SPY | ETF | 116.96 | 117.07 | 116.42 | 116.85 | 355600.0 |
| 2001-04-11 17:00:00 | SPY | ETF | 116.77 | 116.9 | 116.5 | 116.5 | 109100.0 |
| 2001-04-11 18:00:00 | SPY | ETF | 116.7 | 116.75 | 116.7 | 116.7 | 12800.0 |
| 2001-04-11 09:00:00 | QQQ | ETF | 42.16 | 42.5 | 41.6 | 41.68 | 18259700.0 |
| 2001-04-11 10:00:00 | QQQ | ETF | 41.66 | 42.22 | 41.3 | 41.72 | 17890400.0 |
| 2001-04-11 11:00:00 | QQQ | ETF | 41.7 | 41.8 | 40.65 | 40.9 | 13777200.0 |
| 2001-04-11 12:00:00 | QQQ | ETF | 40.89 | 41.05 | 40.45 | 40.85 | 8818800.0 |
| 2001-04-11 13:00:00 | QQQ | ETF | 40.88 | 41.7 | 40.85 | 41.19 | 9102300.0 |
| 2001-04-11 14:00:00 | QQQ | ETF | 41.26 | 41.64 | 40.85 | 40.96 | 7784900.0 |
| 2001-04-11 15:00:00 | QQQ | ETF | 40.96 | 41.2 | 40.5 | 41.15 | 13228400.0 |
| 2001-04-11 16:00:00 | QQQ | ETF | 41.15 | 41.6 | 40.73 | 41.05 | 1239800.0 |
| 2001-04-11 17:00:00 | QQQ | ETF | 41.12 | 41.15 | 41.0 | 41.13 | 269300.0 |
| 2001-04-11 18:00:00 | QQQ | ETF | 41.12 | 41.5 | 41.1 | 41.5 | 56100.0 |
| 2001-04-11 09:00:00 | IWM | ETF | 45.9 | 45.9 | 45.475 | 45.5 | 82400.0 |
| 2001-04-11 10:00:00 | IWM | ETF | 45.45 | 45.525 | 45.375 | 45.375 | 140400.0 |
| 2001-04-11 11:00:00 | IWM | ETF | 45.26 | 45.325 | 44.655 | 44.675 | 190800.0 |
| 2001-04-11 12:00:00 | IWM | ETF | 44.925 | 45.0 | 44.82 | 44.825 | 6800.0 |
| 2001-04-11 13:00:00 | IWM | ETF | 44.77 | 45.05 | 44.7 | 44.855 | 32000.0 |
| 2001-04-11 14:00:00 | IWM | ETF | 44.975 | 45.025 | 44.75 | 44.82 | 22000.0 |
| 2001-04-11 15:00:00 | IWM | ETF | 44.8 | 44.9 | 44.56 | 44.9 | 50000.0 |
| 2001-04-11 09:00:00 | DIA | ETF | 102.49 | 102.5 | 100.6 | 100.65 | 1115800.0 |
| 2001-04-11 10:00:00 | DIA | ETF | 100.75 | 101.25 | 100.45 | 100.5 | 1214200.0 |
| 2001-04-11 11:00:00 | DIA | ETF | 100.5 | 100.88 | 100.01 | 100.3 | 554400.0 |
| 2001-04-11 12:00:00 | DIA | ETF | 100.5 | 100.51 | 99.92 | 100.26 | 534300.0 |
| 2001-04-11 13:00:00 | DIA | ETF | 100.31 | 100.8 | 100.26 | 100.39 | 180100.0 |
| 2001-04-11 14:00:00 | DIA | ETF | 100.31 | 100.59 | 99.94 | 100.03 | 240200.0 |
| 2001-04-11 15:00:00 | DIA | ETF | 99.95 | 100.39 | 99.6 | 100.39 | 711600.0 |
| 2001-04-11 16:00:00 | DIA | ETF | 100.2 | 100.4 | 100.16 | 100.18 | 43400.0 |
> showing 35 of 232 rows — these rows as CSV