PREVIEW / etf_30min / 2004-12-01
file: by_date/etf_30min/2004/2004-12-01.parquet size: 40 KB rows: 1,323
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-12-01 08:00:00 | SPY | ETF | 118.0 | 118.1 | 118.0 | 118.08 | 131300.0 |
| 2004-12-01 08:30:00 | SPY | ETF | 118.08 | 118.11 | 118.02 | 118.11 | 79400.0 |
| 2004-12-01 09:00:00 | SPY | ETF | 118.11 | 118.19 | 118.09 | 118.16 | 131400.0 |
| 2004-12-01 09:30:00 | SPY | ETF | 118.16 | 118.67 | 118.1 | 118.58 | 7051700.0 |
| 2004-12-01 10:00:00 | SPY | ETF | 118.59 | 118.72 | 118.41 | 118.57 | 3888300.0 |
| 2004-12-01 10:30:00 | SPY | ETF | 118.57 | 119.2 | 118.54 | 118.94 | 5546400.0 |
| 2004-12-01 11:00:00 | SPY | ETF | 118.99 | 119.05 | 118.89 | 118.99 | 2694800.0 |
| 2004-12-01 11:30:00 | SPY | ETF | 118.99 | 119.16 | 118.96 | 118.97 | 3026500.0 |
| 2004-12-01 12:00:00 | SPY | ETF | 118.97 | 119.21 | 118.94 | 119.1 | 1905900.0 |
| 2004-12-01 12:30:00 | SPY | ETF | 119.1 | 119.31 | 119.09 | 119.17 | 3461700.0 |
| 2004-12-01 13:00:00 | SPY | ETF | 119.17 | 119.26 | 119.13 | 119.16 | 1312200.0 |
| 2004-12-01 13:30:00 | SPY | ETF | 119.16 | 119.21 | 119.03 | 119.09 | 1829200.0 |
| 2004-12-01 14:00:00 | SPY | ETF | 119.09 | 119.2 | 118.99 | 119.09 | 1926400.0 |
| 2004-12-01 14:30:00 | SPY | ETF | 119.09 | 119.3 | 119.08 | 119.28 | 2968800.0 |
| 2004-12-01 15:00:00 | SPY | ETF | 119.27 | 119.41 | 119.26 | 119.33 | 2600400.0 |
| 2004-12-01 15:30:00 | SPY | ETF | 119.33 | 119.47 | 119.32 | 119.47 | 5181000.0 |
| 2004-12-01 16:00:00 | SPY | ETF | 119.48 | 119.5 | 119.23 | 119.32 | 1941400.0 |
| 2004-12-01 16:30:00 | SPY | ETF | 119.3 | 119.5 | 119.23 | 119.24 | 304700.0 |
| 2004-12-01 17:00:00 | SPY | ETF | 119.3 | 119.32 | 119.28 | 119.3 | 3500.0 |
| 2004-12-01 17:30:00 | SPY | ETF | 119.34 | 119.34 | 119.31 | 119.31 | 200.0 |
| 2004-12-01 18:00:00 | SPY | ETF | 119.33 | 119.34 | 119.32 | 119.34 | 8700.0 |
| 2004-12-01 18:30:00 | SPY | ETF | 119.34 | 119.35 | 119.34 | 119.35 | 1000.0 |
| 2004-12-01 19:00:00 | SPY | ETF | 119.36 | 119.36 | 119.34 | 119.34 | 3000.0 |
| 2004-12-01 19:30:00 | SPY | ETF | 119.35 | 119.35 | 119.28 | 119.28 | 6300.0 |
| 2004-12-01 08:00:00 | QQQ | ETF | 39.22 | 39.3 | 39.17 | 39.3 | 267836.0 |
| 2004-12-01 08:30:00 | QQQ | ETF | 39.3 | 39.33 | 39.28 | 39.31 | 161546.0 |
| 2004-12-01 09:00:00 | QQQ | ETF | 39.31 | 39.34 | 39.27 | 39.28 | 532608.0 |
| 2004-12-01 09:30:00 | QQQ | ETF | 39.277 | 39.484 | 39.27 | 39.47 | 11373289.0 |
| 2004-12-01 10:00:00 | QQQ | ETF | 39.47 | 39.53 | 39.36 | 39.485 | 10740185.0 |
| 2004-12-01 10:30:00 | QQQ | ETF | 39.485 | 39.71 | 39.48 | 39.6699 | 15354837.0 |
| 2004-12-01 11:00:00 | QQQ | ETF | 39.66 | 39.72 | 39.64 | 39.71 | 6690057.0 |
| 2004-12-01 11:30:00 | QQQ | ETF | 39.704 | 39.83 | 39.7 | 39.751 | 7049386.0 |
| 2004-12-01 12:00:00 | QQQ | ETF | 39.75 | 39.86 | 39.72 | 39.82 | 6055592.0 |
| 2004-12-01 12:30:00 | QQQ | ETF | 39.81 | 39.86 | 39.8 | 39.817 | 4209372.0 |
| 2004-12-01 13:00:00 | QQQ | ETF | 39.8101 | 39.86 | 39.805 | 39.811 | 2179907.0 |
| 2004-12-01 13:30:00 | QQQ | ETF | 39.811 | 39.83 | 39.73 | 39.78 | 5192699.0 |
| 2004-12-01 14:00:00 | QQQ | ETF | 39.785 | 39.823 | 39.74 | 39.77 | 4515262.0 |
| 2004-12-01 14:30:00 | QQQ | ETF | 39.761 | 39.86 | 39.76 | 39.85 | 4519453.0 |
| 2004-12-01 15:00:00 | QQQ | ETF | 39.85 | 39.88 | 39.82 | 39.87 | 6704852.0 |
| 2004-12-01 15:30:00 | QQQ | ETF | 39.87 | 39.961 | 39.86 | 39.94 | 9111551.0 |
| 2004-12-01 16:00:00 | QQQ | ETF | 39.94 | 39.96 | 39.81 | 39.84 | 5376175.0 |
| 2004-12-01 16:30:00 | QQQ | ETF | 39.85 | 39.86 | 39.81 | 39.84 | 298097.0 |
| 2004-12-01 17:00:00 | QQQ | ETF | 39.84 | 39.88 | 39.84 | 39.85 | 24303.0 |
| 2004-12-01 17:30:00 | QQQ | ETF | 39.88 | 39.9 | 39.88 | 39.88 | 26700.0 |
| 2004-12-01 18:00:00 | QQQ | ETF | 39.88 | 39.89 | 39.87 | 39.89 | 25149.0 |
| 2004-12-01 08:30:00 | IWM | ETF | 63.55 | 63.57 | 63.535 | 63.535 | 12400.0 |
| 2004-12-01 09:00:00 | IWM | ETF | 63.535 | 63.545 | 63.44 | 63.44 | 8600.0 |
| 2004-12-01 09:30:00 | IWM | ETF | 63.405 | 63.84 | 63.34 | 63.805 | 2690600.0 |
| 2004-12-01 10:00:00 | IWM | ETF | 63.825 | 63.92 | 63.71 | 63.865 | 827200.0 |
| 2004-12-01 10:30:00 | IWM | ETF | 63.875 | 64.135 | 63.875 | 64.075 | 2901200.0 |
> showing 50 of 1,323 rows — these rows as CSV