PREVIEW / etf_30min / 2004-01-15
file: by_date/etf_30min/2004/2004-01-15.parquet size: 35 KB rows: 1,142
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-01-15 08:00:00 | SPY | ETF | 113.31 | 113.38 | 113.25 | 113.38 | 9200.0 |
| 2004-01-15 08:30:00 | SPY | ETF | 113.26 | 113.66 | 113.26 | 113.54 | 45700.0 |
| 2004-01-15 09:00:00 | SPY | ETF | 113.56 | 113.65 | 113.56 | 113.65 | 26800.0 |
| 2004-01-15 09:30:00 | SPY | ETF | 113.57 | 113.69 | 113.11 | 113.15 | 4851200.0 |
| 2004-01-15 10:00:00 | SPY | ETF | 113.15 | 113.24 | 112.73 | 112.9 | 3938500.0 |
| 2004-01-15 10:30:00 | SPY | ETF | 112.9 | 113.05 | 112.83 | 113.02 | 2412300.0 |
| 2004-01-15 11:00:00 | SPY | ETF | 113.02 | 113.13 | 112.93 | 113.01 | 1763000.0 |
| 2004-01-15 11:30:00 | SPY | ETF | 112.98 | 113.5 | 112.98 | 113.37 | 1803300.0 |
| 2004-01-15 12:00:00 | SPY | ETF | 113.39 | 113.68 | 113.26 | 113.59 | 4968600.0 |
| 2004-01-15 12:30:00 | SPY | ETF | 113.58 | 113.87 | 113.52 | 113.78 | 2914900.0 |
| 2004-01-15 13:00:00 | SPY | ETF | 113.77 | 113.88 | 113.65 | 113.83 | 2590500.0 |
| 2004-01-15 13:30:00 | SPY | ETF | 113.81 | 114.06 | 113.8 | 113.91 | 1742500.0 |
| 2004-01-15 14:00:00 | SPY | ETF | 113.89 | 113.93 | 113.6 | 113.82 | 1973300.0 |
| 2004-01-15 14:30:00 | SPY | ETF | 113.8 | 113.85 | 113.47 | 113.6 | 1507200.0 |
| 2004-01-15 15:00:00 | SPY | ETF | 113.6 | 113.61 | 113.28 | 113.53 | 2656900.0 |
| 2004-01-15 15:30:00 | SPY | ETF | 113.53 | 113.61 | 113.4 | 113.53 | 1804800.0 |
| 2004-01-15 16:00:00 | SPY | ETF | 113.55 | 113.8 | 113.5 | 113.75 | 949500.0 |
| 2004-01-15 16:30:00 | SPY | ETF | 113.72 | 113.76 | 113.7 | 113.73 | 41700.0 |
| 2004-01-15 17:00:00 | SPY | ETF | 113.76 | 113.77 | 113.69 | 113.75 | 71200.0 |
| 2004-01-15 17:30:00 | SPY | ETF | 113.72 | 113.82 | 113.72 | 113.82 | 5700.0 |
| 2004-01-15 18:00:00 | SPY | ETF | 113.76 | 113.83 | 113.68 | 113.81 | 17300.0 |
| 2004-01-15 18:30:00 | SPY | ETF | 113.84 | 113.85 | 113.84 | 113.85 | 1100.0 |
| 2004-01-15 19:00:00 | SPY | ETF | 113.85 | 113.85 | 113.85 | 113.85 | 900.0 |
| 2004-01-15 19:30:00 | SPY | ETF | 113.88 | 113.88 | 113.88 | 113.88 | 1000.0 |
| 2004-01-15 08:00:00 | QQQ | ETF | 37.88 | 37.91 | 37.85 | 37.85 | 49100.0 |
| 2004-01-15 08:30:00 | QQQ | ETF | 37.86 | 38.02 | 37.85 | 37.91 | 240400.0 |
| 2004-01-15 09:00:00 | QQQ | ETF | 37.92 | 38.0 | 37.91 | 37.93 | 109600.0 |
| 2004-01-15 09:30:00 | QQQ | ETF | 37.93 | 38.07 | 37.77 | 37.78 | 12224100.0 |
| 2004-01-15 10:00:00 | QQQ | ETF | 37.78 | 37.91 | 37.63 | 37.717 | 11411200.0 |
| 2004-01-15 10:30:00 | QQQ | ETF | 37.712 | 37.8 | 37.663 | 37.77 | 6133000.0 |
| 2004-01-15 11:00:00 | QQQ | ETF | 37.77 | 37.84 | 37.704 | 37.74 | 3820000.0 |
| 2004-01-15 11:30:00 | QQQ | ETF | 37.742 | 38.11 | 37.73 | 38.03 | 6107500.0 |
| 2004-01-15 12:00:00 | QQQ | ETF | 38.02 | 38.28 | 37.9 | 38.2 | 12885900.0 |
| 2004-01-15 12:30:00 | QQQ | ETF | 38.18 | 38.38 | 38.17 | 38.271 | 10363800.0 |
| 2004-01-15 13:00:00 | QQQ | ETF | 38.27 | 38.37 | 38.23 | 38.32 | 4473400.0 |
| 2004-01-15 13:30:00 | QQQ | ETF | 38.31 | 38.46 | 38.31 | 38.359 | 3918800.0 |
| 2004-01-15 14:00:00 | QQQ | ETF | 38.4 | 38.4 | 38.22 | 38.31 | 5563100.0 |
| 2004-01-15 14:30:00 | QQQ | ETF | 38.33 | 38.36 | 38.11 | 38.181 | 5844900.0 |
| 2004-01-15 15:00:00 | QQQ | ETF | 38.18 | 38.23 | 38.02 | 38.14 | 7413400.0 |
| 2004-01-15 15:30:00 | QQQ | ETF | 38.14 | 38.2 | 38.07 | 38.12 | 5971800.0 |
| 2004-01-15 16:00:00 | QQQ | ETF | 38.121 | 38.22 | 38.073 | 38.19 | 2978500.0 |
| 2004-01-15 16:30:00 | QQQ | ETF | 38.19 | 38.19 | 38.14 | 38.18 | 121000.0 |
| 2004-01-15 17:00:00 | QQQ | ETF | 38.173 | 38.23 | 38.17 | 38.23 | 78800.0 |
| 2004-01-15 17:30:00 | QQQ | ETF | 38.2 | 38.34 | 38.2 | 38.3 | 78000.0 |
| 2004-01-15 18:00:00 | QQQ | ETF | 38.3 | 38.35 | 38.24 | 38.29 | 118800.0 |
| 2004-01-15 18:30:00 | QQQ | ETF | 38.29 | 38.31 | 38.29 | 38.31 | 10800.0 |
| 2004-01-15 19:00:00 | QQQ | ETF | 38.31 | 38.31 | 38.3 | 38.31 | 19600.0 |
| 2004-01-15 19:30:00 | QQQ | ETF | 38.29 | 38.31 | 38.29 | 38.31 | 14000.0 |
| 2004-01-15 08:30:00 | IWM | ETF | 58.205 | 58.205 | 58.205 | 58.205 | 2000.0 |
| 2004-01-15 09:00:00 | IWM | ETF | 58.295 | 58.295 | 58.23 | 58.23 | 6200.0 |
> showing 50 of 1,142 rows — these rows as CSV