PREVIEW / etf_30min / 2004-02-20
file: by_date/etf_30min/2004/2004-02-20.parquet size: 37 KB rows: 1,212
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-02-20 08:00:00 | SPY | ETF | 115.31 | 115.42 | 115.31 | 115.32 | 31300.0 |
| 2004-02-20 08:30:00 | SPY | ETF | 115.27 | 115.3 | 115.16 | 115.3 | 65600.0 |
| 2004-02-20 09:00:00 | SPY | ETF | 115.31 | 115.48 | 115.31 | 115.47 | 272600.0 |
| 2004-02-20 09:30:00 | SPY | ETF | 115.48 | 115.5 | 114.99 | 114.99 | 5556600.0 |
| 2004-02-20 10:00:00 | SPY | ETF | 115.05 | 115.28 | 115.01 | 115.07 | 3116500.0 |
| 2004-02-20 10:30:00 | SPY | ETF | 115.07 | 115.12 | 114.5 | 114.65 | 3906000.0 |
| 2004-02-20 11:00:00 | SPY | ETF | 114.64 | 114.81 | 114.56 | 114.8 | 2116000.0 |
| 2004-02-20 11:30:00 | SPY | ETF | 114.77 | 114.89 | 114.76 | 114.85 | 1497100.0 |
| 2004-02-20 12:00:00 | SPY | ETF | 114.79 | 114.88 | 114.71 | 114.74 | 1010600.0 |
| 2004-02-20 12:30:00 | SPY | ETF | 114.75 | 114.82 | 114.32 | 114.4 | 2687400.0 |
| 2004-02-20 13:00:00 | SPY | ETF | 114.35 | 114.54 | 114.35 | 114.5 | 1677500.0 |
| 2004-02-20 13:30:00 | SPY | ETF | 114.47 | 114.93 | 114.41 | 114.87 | 3874300.0 |
| 2004-02-20 14:00:00 | SPY | ETF | 114.89 | 115.28 | 114.81 | 115.2 | 4489100.0 |
| 2004-02-20 14:30:00 | SPY | ETF | 115.22 | 115.48 | 115.08 | 115.1 | 3623000.0 |
| 2004-02-20 15:00:00 | SPY | ETF | 115.09 | 115.16 | 114.91 | 115.07 | 2117600.0 |
| 2004-02-20 15:30:00 | SPY | ETF | 115.09 | 115.1 | 114.8 | 115.0 | 1843700.0 |
| 2004-02-20 16:00:00 | SPY | ETF | 115.0 | 115.04 | 114.78 | 114.85 | 1956000.0 |
| 2004-02-20 16:30:00 | SPY | ETF | 114.84 | 114.85 | 114.74 | 114.84 | 155300.0 |
| 2004-02-20 17:00:00 | SPY | ETF | 114.74 | 114.9 | 114.74 | 114.9 | 6800.0 |
| 2004-02-20 18:30:00 | SPY | ETF | 114.88 | 114.88 | 114.88 | 114.88 | 300.0 |
| 2004-02-20 19:30:00 | SPY | ETF | 114.88 | 114.88 | 114.88 | 114.88 | 400.0 |
| 2004-02-20 08:00:00 | QQQ | ETF | 36.99 | 37.04 | 36.98 | 37.03 | 74400.0 |
| 2004-02-20 08:30:00 | QQQ | ETF | 37.01 | 37.01 | 36.92 | 36.99 | 153300.0 |
| 2004-02-20 09:00:00 | QQQ | ETF | 36.99 | 37.04 | 36.97 | 37.0 | 443200.0 |
| 2004-02-20 09:30:00 | QQQ | ETF | 37.007 | 37.06 | 36.7 | 36.775 | 17290700.0 |
| 2004-02-20 10:00:00 | QQQ | ETF | 36.771 | 36.99 | 36.75 | 36.814 | 10892100.0 |
| 2004-02-20 10:30:00 | QQQ | ETF | 36.825 | 36.87 | 36.56 | 36.63 | 12739700.0 |
| 2004-02-20 11:00:00 | QQQ | ETF | 36.65 | 36.781 | 36.62 | 36.75 | 6256000.0 |
| 2004-02-20 11:30:00 | QQQ | ETF | 36.76 | 36.83 | 36.75 | 36.8 | 5200500.0 |
| 2004-02-20 12:00:00 | QQQ | ETF | 36.79 | 36.81 | 36.68 | 36.69 | 3088800.0 |
| 2004-02-20 12:30:00 | QQQ | ETF | 36.698 | 36.74 | 36.56 | 36.58 | 4158300.0 |
| 2004-02-20 13:00:00 | QQQ | ETF | 36.59 | 36.66 | 36.55 | 36.64 | 6189000.0 |
| 2004-02-20 13:30:00 | QQQ | ETF | 36.64 | 36.9 | 36.59 | 36.841 | 11027500.0 |
| 2004-02-20 14:00:00 | QQQ | ETF | 36.832 | 37.02 | 36.79 | 36.96 | 11912000.0 |
| 2004-02-20 14:30:00 | QQQ | ETF | 36.96 | 37.14 | 36.94 | 36.96 | 10919200.0 |
| 2004-02-20 15:00:00 | QQQ | ETF | 36.95 | 36.98 | 36.86 | 36.927 | 6302000.0 |
| 2004-02-20 15:30:00 | QQQ | ETF | 36.927 | 36.95 | 36.82 | 36.91 | 10584900.0 |
| 2004-02-20 16:00:00 | QQQ | ETF | 36.91 | 36.94 | 36.85 | 36.88 | 4963000.0 |
| 2004-02-20 16:30:00 | QQQ | ETF | 36.889 | 36.93 | 36.88 | 36.92 | 145100.0 |
| 2004-02-20 17:00:00 | QQQ | ETF | 36.9 | 36.92 | 36.89 | 36.89 | 20300.0 |
| 2004-02-20 17:30:00 | QQQ | ETF | 36.9 | 36.9 | 36.89 | 36.9 | 9300.0 |
| 2004-02-20 18:00:00 | QQQ | ETF | 36.91 | 36.93 | 36.87 | 36.89 | 17100.0 |
| 2004-02-20 18:30:00 | QQQ | ETF | 36.88 | 36.9 | 36.88 | 36.88 | 5200.0 |
| 2004-02-20 19:00:00 | QQQ | ETF | 36.87 | 36.92 | 36.87 | 36.91 | 11700.0 |
| 2004-02-20 19:30:00 | QQQ | ETF | 36.91 | 36.91 | 36.9 | 36.9 | 1400.0 |
| 2004-02-20 08:00:00 | IWM | ETF | 58.0 | 58.0 | 57.96 | 58.0 | 3200.0 |
| 2004-02-20 08:30:00 | IWM | ETF | 57.88 | 57.88 | 57.85 | 57.85 | 22000.0 |
| 2004-02-20 09:00:00 | IWM | ETF | 58.025 | 58.025 | 58.02 | 58.02 | 1600.0 |
| 2004-02-20 09:30:00 | IWM | ETF | 58.07 | 58.075 | 57.535 | 57.605 | 1005200.0 |
| 2004-02-20 10:00:00 | IWM | ETF | 57.56 | 57.825 | 57.55 | 57.565 | 876800.0 |
> showing 50 of 1,212 rows — these rows as CSV