PREVIEW / etf_30min / 2004-12-16
file: by_date/etf_30min/2004/2004-12-16.parquet size: 41 KB rows: 1,370
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-16 08:00:00 | SPY | ETF | 120.85 | 120.87 | 120.78 | 120.78 | 40400.0 |
| 2004-12-16 08:30:00 | SPY | ETF | 120.86 | 120.87 | 120.78 | 120.79 | 40200.0 |
| 2004-12-16 09:00:00 | SPY | ETF | 120.8 | 120.8 | 120.72 | 120.73 | 214300.0 |
| 2004-12-16 09:30:00 | SPY | ETF | 120.72 | 120.87 | 120.51 | 120.79 | 6648200.0 |
| 2004-12-16 10:00:00 | SPY | ETF | 120.79 | 120.84 | 120.57 | 120.76 | 2559000.0 |
| 2004-12-16 10:30:00 | SPY | ETF | 120.76 | 121.05 | 120.7 | 121.02 | 3369700.0 |
| 2004-12-16 11:00:00 | SPY | ETF | 121.02 | 121.08 | 120.82 | 121.07 | 2557200.0 |
| 2004-12-16 11:30:00 | SPY | ETF | 121.07 | 121.14 | 120.95 | 121.05 | 2853300.0 |
| 2004-12-16 12:00:00 | SPY | ETF | 121.05 | 121.24 | 121.0 | 121.04 | 2694600.0 |
| 2004-12-16 12:30:00 | SPY | ETF | 121.03 | 121.15 | 121.01 | 121.07 | 912900.0 |
| 2004-12-16 13:00:00 | SPY | ETF | 121.08 | 121.09 | 120.76 | 120.84 | 3561000.0 |
| 2004-12-16 13:30:00 | SPY | ETF | 120.85 | 120.9 | 120.73 | 120.75 | 1695800.0 |
| 2004-12-16 14:00:00 | SPY | ETF | 120.74 | 120.82 | 120.38 | 120.42 | 5234700.0 |
| 2004-12-16 14:30:00 | SPY | ETF | 120.42 | 120.59 | 120.23 | 120.23 | 4572400.0 |
| 2004-12-16 15:00:00 | SPY | ETF | 120.31 | 120.8 | 120.22 | 120.77 | 5410800.0 |
| 2004-12-16 15:30:00 | SPY | ETF | 120.77 | 120.87 | 120.68 | 120.7 | 4421600.0 |
| 2004-12-16 16:00:00 | SPY | ETF | 120.7 | 120.88 | 120.59 | 120.79 | 2653700.0 |
| 2004-12-16 16:30:00 | SPY | ETF | 120.82 | 120.84 | 120.78 | 120.82 | 123600.0 |
| 2004-12-16 17:00:00 | SPY | ETF | 120.83 | 120.85 | 120.78 | 120.84 | 184300.0 |
| 2004-12-16 17:30:00 | SPY | ETF | 120.79 | 120.79 | 120.79 | 120.79 | 200.0 |
| 2004-12-16 18:00:00 | SPY | ETF | 120.81 | 120.81 | 120.81 | 120.81 | 3600.0 |
| 2004-12-16 18:30:00 | SPY | ETF | 120.79 | 120.79 | 120.79 | 120.79 | 1000.0 |
| 2004-12-16 19:00:00 | SPY | ETF | 120.74 | 120.74 | 120.74 | 120.74 | 400.0 |
| 2004-12-16 19:30:00 | SPY | ETF | 120.73 | 120.74 | 120.73 | 120.74 | 900.0 |
| 2004-12-16 08:00:00 | QQQ | ETF | 40.359 | 40.39 | 40.34 | 40.37 | 79660.0 |
| 2004-12-16 08:30:00 | QQQ | ETF | 40.38 | 40.43 | 40.36 | 40.39 | 157648.0 |
| 2004-12-16 09:00:00 | QQQ | ETF | 40.4 | 40.4 | 40.32 | 40.34 | 461751.0 |
| 2004-12-16 09:30:00 | QQQ | ETF | 40.34 | 40.425 | 40.273 | 40.337 | 8352049.0 |
| 2004-12-16 10:00:00 | QQQ | ETF | 40.34 | 40.38 | 40.22 | 40.28 | 5155752.0 |
| 2004-12-16 10:30:00 | QQQ | ETF | 40.284 | 40.38 | 40.23 | 40.377 | 4797256.0 |
| 2004-12-16 11:00:00 | QQQ | ETF | 40.371 | 40.44 | 40.33 | 40.43 | 3651572.0 |
| 2004-12-16 11:30:00 | QQQ | ETF | 40.421 | 40.44 | 40.351 | 40.38 | 3301326.0 |
| 2004-12-16 12:00:00 | QQQ | ETF | 40.382 | 40.43 | 40.34 | 40.371 | 2789284.0 |
| 2004-12-16 12:30:00 | QQQ | ETF | 40.37 | 40.42 | 40.35 | 40.37 | 1895418.0 |
| 2004-12-16 13:00:00 | QQQ | ETF | 40.36 | 40.38 | 40.23 | 40.27 | 4219084.0 |
| 2004-12-16 13:30:00 | QQQ | ETF | 40.271 | 40.31 | 40.16 | 40.17 | 3837575.0 |
| 2004-12-16 14:00:00 | QQQ | ETF | 40.172 | 40.22 | 39.89 | 39.937 | 13827420.0 |
| 2004-12-16 14:30:00 | QQQ | ETF | 39.936 | 39.99 | 39.84 | 39.846 | 9408311.0 |
| 2004-12-16 15:00:00 | QQQ | ETF | 39.846 | 40.04 | 39.82 | 40.02 | 7796431.0 |
| 2004-12-16 15:30:00 | QQQ | ETF | 40.016 | 40.041 | 39.96 | 40.0 | 10585867.0 |
| 2004-12-16 16:00:00 | QQQ | ETF | 40.0 | 40.131 | 39.925 | 40.06 | 3222152.0 |
| 2004-12-16 16:30:00 | QQQ | ETF | 40.07 | 40.09 | 40.05 | 40.055 | 175691.0 |
| 2004-12-16 17:00:00 | QQQ | ETF | 40.07 | 40.07 | 39.95 | 40.05 | 66827.0 |
| 2004-12-16 17:30:00 | QQQ | ETF | 40.03 | 40.03 | 40.01 | 40.01 | 20335.0 |
| 2004-12-16 18:00:00 | QQQ | ETF | 40.02 | 40.05 | 40.02 | 40.04 | 88755.0 |
| 2004-12-16 08:30:00 | IWM | ETF | 64.705 | 64.705 | 64.705 | 64.705 | 600.0 |
| 2004-12-16 09:00:00 | IWM | ETF | 64.615 | 64.65 | 64.615 | 64.645 | 8400.0 |
| 2004-12-16 09:30:00 | IWM | ETF | 64.625 | 64.715 | 64.585 | 64.66 | 1235800.0 |
| 2004-12-16 10:00:00 | IWM | ETF | 64.685 | 64.705 | 64.48 | 64.48 | 2037000.0 |
| 2004-12-16 10:30:00 | IWM | ETF | 64.48 | 64.51 | 64.355 | 64.49 | 969200.0 |
> showing 50 of 1,370 rows — these rows as CSV