PREVIEW / etf_30min / 2004-12-28
file: by_date/etf_30min/2004/2004-12-28.parquet size: 38 KB rows: 1,349
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-28 08:00:00 | SPY | ETF | 120.6 | 120.64 | 120.6 | 120.6 | 8000.0 |
| 2004-12-28 08:30:00 | SPY | ETF | 120.57 | 120.59 | 120.56 | 120.57 | 13400.0 |
| 2004-12-28 09:00:00 | SPY | ETF | 120.59 | 120.63 | 120.59 | 120.59 | 5100.0 |
| 2004-12-28 09:30:00 | SPY | ETF | 120.64 | 120.84 | 120.6 | 120.79 | 2868800.0 |
| 2004-12-28 10:00:00 | SPY | ETF | 120.79 | 121.1 | 120.79 | 121.04 | 4004100.0 |
| 2004-12-28 10:30:00 | SPY | ETF | 121.03 | 121.3 | 121.02 | 121.12 | 2914100.0 |
| 2004-12-28 11:00:00 | SPY | ETF | 121.13 | 121.2 | 121.05 | 121.18 | 1514400.0 |
| 2004-12-28 11:30:00 | SPY | ETF | 121.19 | 121.19 | 120.99 | 121.06 | 847100.0 |
| 2004-12-28 12:00:00 | SPY | ETF | 121.07 | 121.1 | 120.99 | 121.02 | 608800.0 |
| 2004-12-28 12:30:00 | SPY | ETF | 121.03 | 121.07 | 121.0 | 121.06 | 535100.0 |
| 2004-12-28 13:00:00 | SPY | ETF | 121.06 | 121.13 | 120.9 | 120.96 | 1291400.0 |
| 2004-12-28 13:30:00 | SPY | ETF | 120.97 | 121.11 | 120.95 | 121.06 | 1173800.0 |
| 2004-12-28 14:00:00 | SPY | ETF | 121.06 | 121.2 | 121.03 | 121.12 | 1284900.0 |
| 2004-12-28 14:30:00 | SPY | ETF | 121.12 | 121.14 | 120.98 | 121.04 | 659200.0 |
| 2004-12-28 15:00:00 | SPY | ETF | 121.04 | 121.18 | 121.03 | 121.09 | 1083600.0 |
| 2004-12-28 15:30:00 | SPY | ETF | 121.1 | 121.27 | 121.06 | 121.24 | 2269000.0 |
| 2004-12-28 16:00:00 | SPY | ETF | 121.24 | 121.33 | 121.0 | 121.0 | 1112400.0 |
| 2004-12-28 16:30:00 | SPY | ETF | 121.09 | 121.25 | 120.97 | 121.24 | 163500.0 |
| 2004-12-28 17:00:00 | SPY | ETF | 121.26 | 121.28 | 121.24 | 121.28 | 5600.0 |
| 2004-12-28 17:30:00 | SPY | ETF | 121.25 | 121.25 | 121.25 | 121.25 | 200.0 |
| 2004-12-28 18:00:00 | SPY | ETF | 121.27 | 121.27 | 121.25 | 121.25 | 500.0 |
| 2004-12-28 18:30:00 | SPY | ETF | 121.29 | 121.3 | 121.29 | 121.3 | 600.0 |
| 2004-12-28 08:00:00 | QQQ | ETF | 39.64 | 39.67 | 39.64 | 39.65 | 38340.0 |
| 2004-12-28 08:30:00 | QQQ | ETF | 39.65 | 39.66 | 39.642 | 39.648 | 75050.0 |
| 2004-12-28 09:00:00 | QQQ | ETF | 39.65 | 39.68 | 39.62 | 39.67 | 295856.0 |
| 2004-12-28 09:30:00 | QQQ | ETF | 39.671 | 39.704 | 39.61 | 39.663 | 6504238.0 |
| 2004-12-28 10:00:00 | QQQ | ETF | 39.66 | 39.86 | 39.66 | 39.842 | 9992144.0 |
| 2004-12-28 10:30:00 | QQQ | ETF | 39.84 | 40.001 | 39.83 | 39.971 | 8521223.0 |
| 2004-12-28 11:00:00 | QQQ | ETF | 39.96 | 39.997 | 39.88 | 39.921 | 3860319.0 |
| 2004-12-28 11:30:00 | QQQ | ETF | 39.92 | 39.932 | 39.84 | 39.883 | 3195779.0 |
| 2004-12-28 12:00:00 | QQQ | ETF | 39.88 | 39.911 | 39.84 | 39.851 | 2034065.0 |
| 2004-12-28 12:30:00 | QQQ | ETF | 39.851 | 39.9 | 39.85 | 39.9 | 1169290.0 |
| 2004-12-28 13:00:00 | QQQ | ETF | 39.9 | 39.92 | 39.83 | 39.86 | 2823804.0 |
| 2004-12-28 13:30:00 | QQQ | ETF | 39.867 | 39.941 | 39.85 | 39.912 | 2505784.0 |
| 2004-12-28 14:00:00 | QQQ | ETF | 39.913 | 39.956 | 39.9 | 39.924 | 2291395.0 |
| 2004-12-28 14:30:00 | QQQ | ETF | 39.921 | 39.93 | 39.839 | 39.875 | 3432396.0 |
| 2004-12-28 15:00:00 | QQQ | ETF | 39.87 | 39.933 | 39.87 | 39.908 | 4517474.0 |
| 2004-12-28 15:30:00 | QQQ | ETF | 39.907 | 39.976 | 39.9 | 39.97 | 6102534.0 |
| 2004-12-28 16:00:00 | QQQ | ETF | 39.98 | 40.01 | 39.95 | 39.99 | 3169077.0 |
| 2004-12-28 16:30:00 | QQQ | ETF | 39.98 | 40.0 | 39.97 | 39.99 | 320817.0 |
| 2004-12-28 17:00:00 | QQQ | ETF | 40.0 | 40.028 | 39.98 | 40.011 | 32282.0 |
| 2004-12-28 17:30:00 | QQQ | ETF | 40.012 | 40.02 | 40.0 | 40.01 | 10783.0 |
| 2004-12-28 18:00:00 | QQQ | ETF | 40.01 | 40.02 | 40.0 | 40.02 | 33180.0 |
| 2004-12-28 09:00:00 | IWM | ETF | 64.235 | 64.235 | 64.235 | 64.235 | 400.0 |
| 2004-12-28 09:30:00 | IWM | ETF | 64.23 | 64.57 | 64.23 | 64.485 | 1520200.0 |
| 2004-12-28 10:00:00 | IWM | ETF | 64.495 | 64.78 | 64.495 | 64.67 | 1031600.0 |
| 2004-12-28 10:30:00 | IWM | ETF | 64.71 | 64.825 | 64.68 | 64.765 | 465600.0 |
| 2004-12-28 11:00:00 | IWM | ETF | 64.77 | 64.795 | 64.66 | 64.75 | 448000.0 |
| 2004-12-28 11:30:00 | IWM | ETF | 64.745 | 64.745 | 64.605 | 64.71 | 253200.0 |
| 2004-12-28 12:00:00 | IWM | ETF | 64.71 | 64.735 | 64.68 | 64.685 | 363200.0 |
> showing 50 of 1,349 rows — these rows as CSV