PREVIEW / etf_30min / 2004-01-28
file: by_date/etf_30min/2004/2004-01-28.parquet size: 35 KB rows: 1,139
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-28 08:00:00 | SPY | ETF | 115.01 | 115.07 | 115.0 | 115.0 | 19600.0 |
| 2004-01-28 08:30:00 | SPY | ETF | 114.97 | 115.1 | 114.88 | 115.09 | 30300.0 |
| 2004-01-28 09:00:00 | SPY | ETF | 115.09 | 115.09 | 114.94 | 114.95 | 15900.0 |
| 2004-01-28 09:30:00 | SPY | ETF | 114.98 | 115.14 | 114.95 | 115.1 | 2820400.0 |
| 2004-01-28 10:00:00 | SPY | ETF | 115.11 | 115.27 | 114.95 | 115.16 | 2756300.0 |
| 2004-01-28 10:30:00 | SPY | ETF | 115.16 | 115.21 | 115.08 | 115.19 | 1015500.0 |
| 2004-01-28 11:00:00 | SPY | ETF | 115.2 | 115.28 | 115.05 | 115.05 | 1461200.0 |
| 2004-01-28 11:30:00 | SPY | ETF | 115.11 | 115.22 | 115.09 | 115.15 | 821300.0 |
| 2004-01-28 12:00:00 | SPY | ETF | 115.15 | 115.17 | 115.03 | 115.08 | 729300.0 |
| 2004-01-28 12:30:00 | SPY | ETF | 115.08 | 115.13 | 115.02 | 115.08 | 624400.0 |
| 2004-01-28 13:00:00 | SPY | ETF | 115.07 | 115.15 | 115.02 | 115.09 | 889600.0 |
| 2004-01-28 13:30:00 | SPY | ETF | 115.1 | 115.23 | 115.08 | 115.16 | 915300.0 |
| 2004-01-28 14:00:00 | SPY | ETF | 115.14 | 115.2 | 113.9 | 114.18 | 10131700.0 |
| 2004-01-28 14:30:00 | SPY | ETF | 114.18 | 114.23 | 113.46 | 113.89 | 8617400.0 |
| 2004-01-28 15:00:00 | SPY | ETF | 113.9 | 114.03 | 113.35 | 113.35 | 5377300.0 |
| 2004-01-28 15:30:00 | SPY | ETF | 113.35 | 113.44 | 112.94 | 113.23 | 8865800.0 |
| 2004-01-28 16:00:00 | SPY | ETF | 113.23 | 113.4 | 113.15 | 113.3 | 2481400.0 |
| 2004-01-28 16:30:00 | SPY | ETF | 113.3 | 114.185 | 113.29 | 113.35 | 659000.0 |
| 2004-01-28 17:00:00 | SPY | ETF | 113.35 | 113.38 | 113.3 | 113.3 | 311400.0 |
| 2004-01-28 17:30:00 | SPY | ETF | 113.32 | 113.32 | 113.27 | 113.29 | 244100.0 |
| 2004-01-28 18:00:00 | SPY | ETF | 113.29 | 113.29 | 113.19 | 113.27 | 15000.0 |
| 2004-01-28 18:30:00 | SPY | ETF | 113.24 | 113.32 | 113.24 | 113.32 | 4300.0 |
| 2004-01-28 19:00:00 | SPY | ETF | 113.32 | 113.33 | 113.29 | 113.33 | 3700.0 |
| 2004-01-28 19:30:00 | SPY | ETF | 113.34 | 113.37 | 113.34 | 113.35 | 3700.0 |
| 2004-01-28 08:00:00 | QQQ | ETF | 37.95 | 37.96 | 37.91 | 37.92 | 56100.0 |
| 2004-01-28 08:30:00 | QQQ | ETF | 37.92 | 38.01 | 37.85 | 37.98 | 198200.0 |
| 2004-01-28 09:00:00 | QQQ | ETF | 37.99 | 38.0 | 37.91 | 37.94 | 98700.0 |
| 2004-01-28 09:30:00 | QQQ | ETF | 37.94 | 38.0 | 37.86 | 37.92 | 9204000.0 |
| 2004-01-28 10:00:00 | QQQ | ETF | 37.939 | 38.06 | 37.8 | 38.03 | 11694800.0 |
| 2004-01-28 10:30:00 | QQQ | ETF | 38.02 | 38.05 | 37.96 | 38.0 | 3993700.0 |
| 2004-01-28 11:00:00 | QQQ | ETF | 37.99 | 38.05 | 37.92 | 37.93 | 4501700.0 |
| 2004-01-28 11:30:00 | QQQ | ETF | 37.93 | 37.99 | 37.91 | 37.93 | 2459400.0 |
| 2004-01-28 12:00:00 | QQQ | ETF | 37.93 | 37.94 | 37.86 | 37.87 | 4794600.0 |
| 2004-01-28 12:30:00 | QQQ | ETF | 37.88 | 37.9 | 37.82 | 37.894 | 2946800.0 |
| 2004-01-28 13:00:00 | QQQ | ETF | 37.888 | 37.902 | 37.82 | 37.89 | 2475700.0 |
| 2004-01-28 13:30:00 | QQQ | ETF | 37.89 | 37.95 | 37.86 | 37.895 | 3424400.0 |
| 2004-01-28 14:00:00 | QQQ | ETF | 37.89 | 37.96 | 37.39 | 37.55 | 17097400.0 |
| 2004-01-28 14:30:00 | QQQ | ETF | 37.59 | 37.64 | 37.28 | 37.46 | 19138700.0 |
| 2004-01-28 15:00:00 | QQQ | ETF | 37.47 | 37.579 | 37.23 | 37.241 | 9924600.0 |
| 2004-01-28 15:30:00 | QQQ | ETF | 37.24 | 37.26 | 37.01 | 37.156 | 21927200.0 |
| 2004-01-28 16:00:00 | QQQ | ETF | 37.16 | 37.2 | 37.05 | 37.07 | 2852300.0 |
| 2004-01-28 16:30:00 | QQQ | ETF | 37.071 | 37.11 | 37.04 | 37.1 | 626700.0 |
| 2004-01-28 17:00:00 | QQQ | ETF | 37.1 | 37.1 | 37.06 | 37.08 | 359800.0 |
| 2004-01-28 17:30:00 | QQQ | ETF | 37.08 | 37.1 | 37.05 | 37.08 | 380200.0 |
| 2004-01-28 18:00:00 | QQQ | ETF | 37.08 | 37.1 | 37.04 | 37.1 | 78700.0 |
| 2004-01-28 18:30:00 | QQQ | ETF | 37.1 | 37.14 | 37.09 | 37.12 | 15400.0 |
| 2004-01-28 19:00:00 | QQQ | ETF | 37.14 | 37.14 | 37.13 | 37.13 | 13000.0 |
| 2004-01-28 19:30:00 | QQQ | ETF | 37.13 | 37.16 | 37.13 | 37.14 | 13800.0 |
| 2004-01-28 09:00:00 | IWM | ETF | 59.38 | 59.38 | 59.38 | 59.38 | 5000.0 |
| 2004-01-28 09:30:00 | IWM | ETF | 59.597 | 59.67 | 59.345 | 59.38 | 591800.0 |
> showing 50 of 1,139 rows — these rows as CSV