PREVIEW / etf_1hour / 2002-09-11
file: by_date/etf_1hour/2002/2002-09-11.parquet size: 12 KB rows: 220
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-09-11 11:00:00 | SPY | ETF | 92.47 | 93.25 | 92.47 | 92.9 | 2051000.0 |
| 2002-09-11 12:00:00 | SPY | ETF | 92.89 | 93.33 | 92.17 | 92.34 | 8633300.0 |
| 2002-09-11 13:00:00 | SPY | ETF | 92.36 | 92.38 | 91.83 | 92.0 | 3488300.0 |
| 2002-09-11 14:00:00 | SPY | ETF | 91.97 | 92.36 | 91.7 | 92.27 | 4465700.0 |
| 2002-09-11 15:00:00 | SPY | ETF | 92.24 | 92.35 | 91.35 | 91.5 | 4938700.0 |
| 2002-09-11 16:00:00 | SPY | ETF | 91.47 | 91.5 | 91.13 | 91.13 | 1130500.0 |
| 2002-09-11 11:00:00 | QQQ | ETF | 24.12 | 24.3 | 23.92 | 24.3 | 12194500.0 |
| 2002-09-11 12:00:00 | QQQ | ETF | 24.27 | 24.35 | 23.77 | 23.85 | 19783300.0 |
| 2002-09-11 13:00:00 | QQQ | ETF | 23.83 | 23.86 | 23.62 | 23.75 | 11541400.0 |
| 2002-09-11 14:00:00 | QQQ | ETF | 23.77 | 24.0 | 23.66 | 23.94 | 10409800.0 |
| 2002-09-11 15:00:00 | QQQ | ETF | 23.94 | 23.99 | 23.5 | 23.55 | 14570800.0 |
| 2002-09-11 16:00:00 | QQQ | ETF | 23.53 | 23.56 | 23.42 | 23.45 | 998400.0 |
| 2002-09-11 12:00:00 | IWM | ETF | 40.0 | 40.0 | 39.405 | 39.48 | 185000.0 |
| 2002-09-11 13:00:00 | IWM | ETF | 39.43 | 39.44 | 39.22 | 39.375 | 77800.0 |
| 2002-09-11 14:00:00 | IWM | ETF | 39.38 | 39.47 | 39.29 | 39.47 | 53400.0 |
| 2002-09-11 15:00:00 | IWM | ETF | 39.47 | 39.525 | 39.19 | 39.25 | 115200.0 |
| 2002-09-11 16:00:00 | IWM | ETF | 39.15 | 39.15 | 39.125 | 39.15 | 38200.0 |
| 2002-09-11 11:00:00 | DIA | ETF | 87.39 | 87.99 | 87.39 | 87.55 | 159000.0 |
| 2002-09-11 12:00:00 | DIA | ETF | 87.57 | 87.8 | 86.66 | 86.84 | 2475200.0 |
| 2002-09-11 13:00:00 | DIA | ETF | 86.84 | 86.85 | 86.32 | 86.43 | 1179300.0 |
| 2002-09-11 14:00:00 | DIA | ETF | 86.44 | 86.75 | 86.19 | 86.73 | 1278300.0 |
| 2002-09-11 15:00:00 | DIA | ETF | 86.69 | 86.79 | 85.83 | 85.93 | 1344400.0 |
| 2002-09-11 16:00:00 | DIA | ETF | 85.97 | 85.97 | 85.68 | 85.68 | 88100.0 |
| 2002-09-11 11:00:00 | TLT | ETF | 87.0 | 87.0 | 86.75 | 86.8 | 41300.0 |
| 2002-09-11 12:00:00 | TLT | ETF | 86.78 | 87.14 | 86.78 | 87.14 | 100500.0 |
| 2002-09-11 13:00:00 | TLT | ETF | 87.09 | 87.24 | 87.09 | 87.24 | 1800.0 |
| 2002-09-11 14:00:00 | TLT | ETF | 87.26 | 87.29 | 87.24 | 87.29 | 31100.0 |
| 2002-09-11 15:00:00 | TLT | ETF | 87.17 | 87.3 | 87.17 | 87.18 | 2300.0 |
| 2002-09-11 16:00:00 | TLT | ETF | 87.18 | 87.29 | 87.18 | 87.29 | 700.0 |
> showing 29 of 220 rows — these rows as CSV