PREVIEW / etf_30min / 2004-03-08
file: by_date/etf_30min/2004/2004-03-08.parquet size: 37 KB rows: 1,249
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-08 08:00:00 | SPY | ETF | 116.4 | 116.46 | 116.4 | 116.46 | 2600.0 |
| 2004-03-08 08:30:00 | SPY | ETF | 116.43 | 116.46 | 116.4 | 116.44 | 9700.0 |
| 2004-03-08 09:00:00 | SPY | ETF | 116.45 | 116.48 | 116.36 | 116.36 | 54600.0 |
| 2004-03-08 09:30:00 | SPY | ETF | 116.34 | 116.62 | 116.2 | 116.49 | 3242900.0 |
| 2004-03-08 10:00:00 | SPY | ETF | 116.49 | 116.55 | 116.2 | 116.26 | 1781700.0 |
| 2004-03-08 10:30:00 | SPY | ETF | 116.26 | 116.46 | 116.14 | 116.17 | 1677000.0 |
| 2004-03-08 11:00:00 | SPY | ETF | 116.2 | 116.42 | 116.16 | 116.31 | 696200.0 |
| 2004-03-08 11:30:00 | SPY | ETF | 116.33 | 116.44 | 116.24 | 116.43 | 1090300.0 |
| 2004-03-08 12:00:00 | SPY | ETF | 116.43 | 116.46 | 116.26 | 116.35 | 568900.0 |
| 2004-03-08 12:30:00 | SPY | ETF | 116.34 | 116.35 | 116.18 | 116.3399 | 589200.0 |
| 2004-03-08 13:00:00 | SPY | ETF | 116.34 | 116.34 | 116.07 | 116.13 | 2026600.0 |
| 2004-03-08 13:30:00 | SPY | ETF | 116.13 | 116.2 | 115.82 | 115.88 | 3280500.0 |
| 2004-03-08 14:00:00 | SPY | ETF | 115.84 | 115.99 | 115.5 | 115.56 | 3077500.0 |
| 2004-03-08 14:30:00 | SPY | ETF | 115.56 | 115.76 | 115.53 | 115.69 | 4250300.0 |
| 2004-03-08 15:00:00 | SPY | ETF | 115.66 | 115.69 | 115.48 | 115.62 | 3253600.0 |
| 2004-03-08 15:30:00 | SPY | ETF | 115.64 | 115.66 | 115.22 | 115.27 | 3724600.0 |
| 2004-03-08 16:00:00 | SPY | ETF | 115.26 | 115.31 | 114.88 | 114.93 | 2537200.0 |
| 2004-03-08 16:30:00 | SPY | ETF | 114.96 | 115.07 | 114.96 | 115.06 | 57400.0 |
| 2004-03-08 17:00:00 | SPY | ETF | 115.05 | 115.07 | 114.99 | 115.0 | 437900.0 |
| 2004-03-08 17:30:00 | SPY | ETF | 114.99 | 115.01 | 114.99 | 114.99 | 1900.0 |
| 2004-03-08 18:00:00 | SPY | ETF | 115.02 | 115.05 | 115.02 | 115.05 | 6100.0 |
| 2004-03-08 18:30:00 | SPY | ETF | 115.05 | 115.05 | 115.05 | 115.05 | 100.0 |
| 2004-03-08 08:00:00 | QQQ | ETF | 36.71 | 36.72 | 36.67 | 36.72 | 32200.0 |
| 2004-03-08 08:30:00 | QQQ | ETF | 36.71 | 36.73 | 36.7 | 36.73 | 24900.0 |
| 2004-03-08 09:00:00 | QQQ | ETF | 36.74 | 36.74 | 36.68 | 36.68 | 90400.0 |
| 2004-03-08 09:30:00 | QQQ | ETF | 36.688 | 36.82 | 36.64 | 36.75 | 7330700.0 |
| 2004-03-08 10:00:00 | QQQ | ETF | 36.74 | 36.769 | 36.59 | 36.602 | 6745100.0 |
| 2004-03-08 10:30:00 | QQQ | ETF | 36.61 | 36.73 | 36.502 | 36.511 | 7588400.0 |
| 2004-03-08 11:00:00 | QQQ | ETF | 36.51 | 36.63 | 36.49 | 36.59 | 4178400.0 |
| 2004-03-08 11:30:00 | QQQ | ETF | 36.59 | 36.651 | 36.55 | 36.6489 | 2131800.0 |
| 2004-03-08 12:00:00 | QQQ | ETF | 36.64 | 36.66 | 36.55 | 36.57 | 1907100.0 |
| 2004-03-08 12:30:00 | QQQ | ETF | 36.57 | 36.58 | 36.4 | 36.48 | 5501600.0 |
| 2004-03-08 13:00:00 | QQQ | ETF | 36.47 | 36.51 | 36.35 | 36.384 | 6458900.0 |
| 2004-03-08 13:30:00 | QQQ | ETF | 36.385 | 36.43 | 36.11 | 36.12 | 11397300.0 |
| 2004-03-08 14:00:00 | QQQ | ETF | 36.114 | 36.17 | 35.91 | 35.939 | 16115700.0 |
| 2004-03-08 14:30:00 | QQQ | ETF | 35.93 | 36.07 | 35.91 | 35.998 | 13147800.0 |
| 2004-03-08 15:00:00 | QQQ | ETF | 36.0 | 36.0 | 35.86 | 35.98 | 9414400.0 |
| 2004-03-08 15:30:00 | QQQ | ETF | 35.982 | 35.997 | 35.8 | 35.84 | 10283400.0 |
| 2004-03-08 16:00:00 | QQQ | ETF | 35.83 | 36.6212 | 35.71 | 35.74 | 4336200.0 |
| 2004-03-08 16:30:00 | QQQ | ETF | 35.75 | 35.83 | 35.74 | 35.78 | 1309500.0 |
| 2004-03-08 17:00:00 | QQQ | ETF | 35.78 | 35.78 | 35.74 | 35.75 | 275600.0 |
| 2004-03-08 17:30:00 | QQQ | ETF | 35.75 | 35.76 | 35.73 | 35.731 | 70600.0 |
| 2004-03-08 18:00:00 | QQQ | ETF | 35.74 | 35.77 | 35.73 | 35.75 | 59300.0 |
| 2004-03-08 18:30:00 | QQQ | ETF | 35.75 | 35.76 | 35.74 | 35.76 | 6600.0 |
| 2004-03-08 19:00:00 | QQQ | ETF | 35.77 | 35.77 | 35.76 | 35.76 | 1400.0 |
| 2004-03-08 19:30:00 | QQQ | ETF | 35.77 | 35.79 | 35.77 | 35.78 | 9900.0 |
| 2004-03-08 09:00:00 | IWM | ETF | 59.94 | 59.94 | 59.94 | 59.94 | 10000.0 |
| 2004-03-08 09:30:00 | IWM | ETF | 59.905 | 60.16 | 59.87 | 60.085 | 561800.0 |
| 2004-03-08 10:00:00 | IWM | ETF | 59.98 | 60.025 | 59.88 | 59.885 | 491400.0 |
| 2004-03-08 10:30:00 | IWM | ETF | 59.9 | 59.99 | 59.8 | 59.8 | 363400.0 |
> showing 50 of 1,249 rows — these rows as CSV