PREVIEW / etf_30min / 2004-12-14
file: by_date/etf_30min/2004/2004-12-14.parquet size: 39 KB rows: 1,357
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-14 08:00:00 | SPY | ETF | 120.23 | 120.32 | 120.23 | 120.3 | 61500.0 |
| 2004-12-14 08:30:00 | SPY | ETF | 120.24 | 120.27 | 120.18 | 120.22 | 53700.0 |
| 2004-12-14 09:00:00 | SPY | ETF | 120.21 | 120.23 | 120.19 | 120.2 | 54500.0 |
| 2004-12-14 09:30:00 | SPY | ETF | 120.18 | 120.45 | 120.18 | 120.41 | 3591400.0 |
| 2004-12-14 10:00:00 | SPY | ETF | 120.4 | 120.46 | 120.21 | 120.24 | 3408700.0 |
| 2004-12-14 10:30:00 | SPY | ETF | 120.24 | 120.43 | 120.23 | 120.32 | 2131300.0 |
| 2004-12-14 11:00:00 | SPY | ETF | 120.32 | 120.4 | 120.26 | 120.32 | 1775300.0 |
| 2004-12-14 11:30:00 | SPY | ETF | 120.33 | 120.39 | 120.28 | 120.31 | 1101700.0 |
| 2004-12-14 12:00:00 | SPY | ETF | 120.32 | 120.51 | 120.28 | 120.39 | 2390800.0 |
| 2004-12-14 12:30:00 | SPY | ETF | 120.38 | 120.45 | 120.31 | 120.44 | 904300.0 |
| 2004-12-14 13:00:00 | SPY | ETF | 120.44 | 120.48 | 120.38 | 120.43 | 1004500.0 |
| 2004-12-14 13:30:00 | SPY | ETF | 120.42 | 120.43 | 120.37 | 120.39 | 913700.0 |
| 2004-12-14 14:00:00 | SPY | ETF | 120.39 | 120.71 | 120.32 | 120.55 | 5418300.0 |
| 2004-12-14 14:30:00 | SPY | ETF | 120.56 | 120.75 | 120.33 | 120.7 | 4673600.0 |
| 2004-12-14 15:00:00 | SPY | ETF | 120.7 | 120.96 | 120.7 | 120.75 | 6576300.0 |
| 2004-12-14 15:30:00 | SPY | ETF | 120.76 | 120.82 | 120.65 | 120.79 | 3737100.0 |
| 2004-12-14 16:00:00 | SPY | ETF | 120.8 | 120.85 | 120.68 | 120.76 | 1849700.0 |
| 2004-12-14 16:30:00 | SPY | ETF | 120.79 | 120.79 | 120.71 | 120.76 | 122200.0 |
| 2004-12-14 17:00:00 | SPY | ETF | 120.7 | 120.7 | 120.66 | 120.68 | 222300.0 |
| 2004-12-14 17:30:00 | SPY | ETF | 120.7 | 120.7 | 120.7 | 120.7 | 1400.0 |
| 2004-12-14 18:00:00 | SPY | ETF | 120.7 | 120.7 | 120.63 | 120.63 | 26700.0 |
| 2004-12-14 08:00:00 | QQQ | ETF | 40.297 | 40.33 | 40.28 | 40.32 | 31827.0 |
| 2004-12-14 08:30:00 | QQQ | ETF | 40.32 | 40.34 | 40.27 | 40.31 | 118169.0 |
| 2004-12-14 09:00:00 | QQQ | ETF | 40.31 | 40.31 | 40.25 | 40.25 | 260853.0 |
| 2004-12-14 09:30:00 | QQQ | ETF | 40.26 | 40.43 | 40.25 | 40.3801 | 8994954.0 |
| 2004-12-14 10:00:00 | QQQ | ETF | 40.38 | 40.4 | 40.27 | 40.279 | 6252049.0 |
| 2004-12-14 10:30:00 | QQQ | ETF | 40.273 | 40.4 | 40.27 | 40.348 | 2901303.0 |
| 2004-12-14 11:00:00 | QQQ | ETF | 40.35 | 40.391 | 40.29 | 40.336 | 2908894.0 |
| 2004-12-14 11:30:00 | QQQ | ETF | 40.335 | 40.39 | 40.32 | 40.39 | 2042276.0 |
| 2004-12-14 12:00:00 | QQQ | ETF | 40.38 | 40.511 | 40.36 | 40.455 | 8408724.0 |
| 2004-12-14 12:30:00 | QQQ | ETF | 40.46 | 40.48 | 40.426 | 40.45 | 2584391.0 |
| 2004-12-14 13:00:00 | QQQ | ETF | 40.451 | 40.46 | 40.42 | 40.42 | 2155926.0 |
| 2004-12-14 13:30:00 | QQQ | ETF | 40.42 | 40.44 | 40.41 | 40.43 | 2501994.0 |
| 2004-12-14 14:00:00 | QQQ | ETF | 40.427 | 40.52 | 40.33 | 40.46 | 11216132.0 |
| 2004-12-14 14:30:00 | QQQ | ETF | 40.46 | 40.53 | 40.34 | 40.484 | 9391444.0 |
| 2004-12-14 15:00:00 | QQQ | ETF | 40.4899 | 40.59 | 40.44 | 40.451 | 11353220.0 |
| 2004-12-14 15:30:00 | QQQ | ETF | 40.46 | 40.48 | 40.38 | 40.45 | 8745491.0 |
| 2004-12-14 16:00:00 | QQQ | ETF | 40.459 | 40.48 | 40.3099 | 40.47 | 4116069.0 |
| 2004-12-14 16:30:00 | QQQ | ETF | 40.46 | 40.48 | 40.43 | 40.45 | 223119.0 |
| 2004-12-14 17:00:00 | QQQ | ETF | 40.44 | 40.45 | 40.43 | 40.448 | 22501.0 |
| 2004-12-14 17:30:00 | QQQ | ETF | 40.45 | 40.47 | 40.44 | 40.47 | 10600.0 |
| 2004-12-14 18:00:00 | QQQ | ETF | 40.45 | 40.46 | 40.44 | 40.45 | 23070.0 |
| 2004-12-14 08:00:00 | IWM | ETF | 63.77 | 63.77 | 63.77 | 63.77 | 600.0 |
| 2004-12-14 08:30:00 | IWM | ETF | 63.74 | 63.74 | 63.74 | 63.74 | 600.0 |
| 2004-12-14 09:00:00 | IWM | ETF | 63.7 | 63.77 | 63.685 | 63.765 | 116600.0 |
| 2004-12-14 09:30:00 | IWM | ETF | 63.73 | 63.93 | 63.7 | 63.91 | 1016600.0 |
| 2004-12-14 10:00:00 | IWM | ETF | 63.905 | 63.91 | 63.76 | 63.79 | 852600.0 |
| 2004-12-14 10:30:00 | IWM | ETF | 63.785 | 63.925 | 63.78 | 63.88 | 466600.0 |
| 2004-12-14 11:00:00 | IWM | ETF | 63.875 | 63.915 | 63.83 | 63.865 | 1104000.0 |
| 2004-12-14 11:30:00 | IWM | ETF | 63.875 | 64.035 | 63.855 | 63.96 | 319400.0 |
> showing 50 of 1,357 rows — these rows as CSV