PREVIEW / etf_30min / 2004-03-04
file: by_date/etf_30min/2004/2004-03-04.parquet size: 34 KB rows: 1,159
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-03-04 08:00:00 | SPY | ETF | 115.72 | 115.81 | 115.72 | 115.81 | 28900.0 |
| 2004-03-04 08:30:00 | SPY | ETF | 115.81 | 115.82 | 115.69 | 115.75 | 47300.0 |
| 2004-03-04 09:00:00 | SPY | ETF | 115.75 | 115.75 | 115.71 | 115.73 | 39100.0 |
| 2004-03-04 09:30:00 | SPY | ETF | 115.72 | 115.85 | 115.63 | 115.81 | 2134300.0 |
| 2004-03-04 10:00:00 | SPY | ETF | 115.78 | 115.85 | 115.52 | 115.68 | 1349600.0 |
| 2004-03-04 10:30:00 | SPY | ETF | 115.69 | 115.74 | 115.54 | 115.63 | 1225300.0 |
| 2004-03-04 11:00:00 | SPY | ETF | 115.63 | 115.93 | 115.62 | 115.83 | 1181000.0 |
| 2004-03-04 11:30:00 | SPY | ETF | 115.83 | 115.86 | 115.74 | 115.83 | 1560000.0 |
| 2004-03-04 12:00:00 | SPY | ETF | 115.82 | 115.94 | 115.77 | 115.83 | 1210400.0 |
| 2004-03-04 12:30:00 | SPY | ETF | 115.83 | 116.06 | 115.83 | 116.03 | 1206000.0 |
| 2004-03-04 13:00:00 | SPY | ETF | 116.05 | 116.1 | 115.98 | 116.03 | 1852800.0 |
| 2004-03-04 13:30:00 | SPY | ETF | 116.03 | 116.07 | 115.81 | 115.88 | 1270100.0 |
| 2004-03-04 14:00:00 | SPY | ETF | 115.87 | 116.02 | 115.86 | 115.92 | 1028700.0 |
| 2004-03-04 14:30:00 | SPY | ETF | 115.94 | 116.05 | 115.92 | 115.98 | 634200.0 |
| 2004-03-04 15:00:00 | SPY | ETF | 115.98 | 116.0 | 115.86 | 115.97 | 731600.0 |
| 2004-03-04 15:30:00 | SPY | ETF | 115.97 | 116.08 | 115.88 | 116.04 | 1039400.0 |
| 2004-03-04 16:00:00 | SPY | ETF | 116.05 | 116.07 | 115.65 | 115.88 | 848000.0 |
| 2004-03-04 16:30:00 | SPY | ETF | 115.88 | 116.06 | 115.88 | 116.05 | 163100.0 |
| 2004-03-04 17:00:00 | SPY | ETF | 116.02 | 116.03 | 115.96 | 116.0 | 6100.0 |
| 2004-03-04 17:30:00 | SPY | ETF | 115.97 | 115.97 | 115.9 | 115.97 | 3200.0 |
| 2004-03-04 18:00:00 | SPY | ETF | 115.92 | 115.96 | 115.92 | 115.93 | 7500.0 |
| 2004-03-04 19:00:00 | SPY | ETF | 116.02 | 116.02 | 116.01 | 116.01 | 1500.0 |
| 2004-03-04 19:30:00 | SPY | ETF | 116.01 | 116.01 | 116.01 | 116.01 | 400.0 |
| 2004-03-04 08:00:00 | QQQ | ETF | 36.47 | 36.5 | 36.47 | 36.49 | 25300.0 |
| 2004-03-04 08:30:00 | QQQ | ETF | 36.49 | 36.49 | 36.45 | 36.45 | 69500.0 |
| 2004-03-04 09:00:00 | QQQ | ETF | 36.46 | 36.48 | 36.44 | 36.44 | 158200.0 |
| 2004-03-04 09:30:00 | QQQ | ETF | 36.44 | 36.59 | 36.413 | 36.54 | 6828500.0 |
| 2004-03-04 10:00:00 | QQQ | ETF | 36.53 | 36.574 | 36.4 | 36.51 | 4840600.0 |
| 2004-03-04 10:30:00 | QQQ | ETF | 36.51 | 36.57 | 36.47 | 36.51 | 3397700.0 |
| 2004-03-04 11:00:00 | QQQ | ETF | 36.5 | 36.65 | 36.5 | 36.6 | 4148800.0 |
| 2004-03-04 11:30:00 | QQQ | ETF | 36.6 | 36.61 | 36.53 | 36.602 | 2739400.0 |
| 2004-03-04 12:00:00 | QQQ | ETF | 36.601 | 36.64 | 36.58 | 36.619 | 2760300.0 |
| 2004-03-04 12:30:00 | QQQ | ETF | 36.62 | 36.74 | 36.61 | 36.73 | 3981800.0 |
| 2004-03-04 13:00:00 | QQQ | ETF | 36.73 | 36.82 | 36.73 | 36.793 | 6568700.0 |
| 2004-03-04 13:30:00 | QQQ | ETF | 36.793 | 36.8 | 36.67 | 36.7 | 2957600.0 |
| 2004-03-04 14:00:00 | QQQ | ETF | 36.695 | 36.8 | 36.69 | 36.74 | 3310500.0 |
| 2004-03-04 14:30:00 | QQQ | ETF | 36.739 | 36.81 | 36.73 | 36.76 | 2895500.0 |
| 2004-03-04 15:00:00 | QQQ | ETF | 36.76 | 36.77 | 36.68 | 36.75 | 3273000.0 |
| 2004-03-04 15:30:00 | QQQ | ETF | 36.76 | 36.83 | 36.72 | 36.809 | 4320800.0 |
| 2004-03-04 16:00:00 | QQQ | ETF | 36.82 | 36.83 | 36.58 | 36.59 | 3328100.0 |
| 2004-03-04 16:30:00 | QQQ | ETF | 36.61 | 36.73 | 36.59 | 36.702 | 864600.0 |
| 2004-03-04 17:00:00 | QQQ | ETF | 36.72 | 36.73 | 36.67 | 36.68 | 83100.0 |
| 2004-03-04 17:30:00 | QQQ | ETF | 36.67 | 36.72 | 36.66 | 36.71 | 143900.0 |
| 2004-03-04 18:00:00 | QQQ | ETF | 36.71 | 36.73 | 36.68 | 36.68 | 36700.0 |
| 2004-03-04 18:30:00 | QQQ | ETF | 36.7 | 36.71 | 36.69 | 36.7 | 7700.0 |
| 2004-03-04 19:00:00 | QQQ | ETF | 36.73 | 36.73 | 36.7 | 36.72 | 2500.0 |
| 2004-03-04 19:30:00 | QQQ | ETF | 36.7 | 36.71 | 36.69 | 36.69 | 3300.0 |
| 2004-03-04 09:00:00 | IWM | ETF | 58.94 | 58.94 | 58.91 | 58.91 | 8000.0 |
| 2004-03-04 09:30:00 | IWM | ETF | 58.875 | 59.05 | 58.86 | 59.015 | 508800.0 |
| 2004-03-04 10:00:00 | IWM | ETF | 59.015 | 59.02 | 58.685 | 58.83 | 461400.0 |
> showing 50 of 1,159 rows — these rows as CSV