PREVIEW / etf_30min / 2003-12-05
file: by_date/etf_30min/2003/2003-12-05.parquet size: 27 KB rows: 839
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-05 08:00:00 | SPY | ETF | 107.37 | 107.37 | 107.3 | 107.37 | 8400.0 |
| 2003-12-05 08:30:00 | SPY | ETF | 107.31 | 107.31 | 106.95 | 107.0 | 67900.0 |
| 2003-12-05 09:00:00 | SPY | ETF | 107.0 | 107.15 | 107.0 | 107.13 | 35800.0 |
| 2003-12-05 09:30:00 | SPY | ETF | 107.12 | 107.29 | 107.0 | 107.19 | 2451300.0 |
| 2003-12-05 10:00:00 | SPY | ETF | 107.2 | 107.42 | 107.11 | 107.32 | 2340600.0 |
| 2003-12-05 10:30:00 | SPY | ETF | 107.3 | 107.39 | 107.14 | 107.15 | 1398300.0 |
| 2003-12-05 11:00:00 | SPY | ETF | 107.15 | 107.51 | 107.04 | 107.5 | 1741000.0 |
| 2003-12-05 11:30:00 | SPY | ETF | 107.48 | 107.52 | 107.26 | 107.33 | 1308400.0 |
| 2003-12-05 12:00:00 | SPY | ETF | 107.33 | 107.34 | 107.09 | 107.24 | 1146300.0 |
| 2003-12-05 12:30:00 | SPY | ETF | 107.24 | 107.3 | 107.13 | 107.28 | 593900.0 |
| 2003-12-05 13:00:00 | SPY | ETF | 107.3 | 107.32 | 106.91 | 106.91 | 1249300.0 |
| 2003-12-05 13:30:00 | SPY | ETF | 106.96 | 107.01 | 106.65 | 106.73 | 3229700.0 |
| 2003-12-05 14:00:00 | SPY | ETF | 106.72 | 106.82 | 106.62 | 106.71 | 1644500.0 |
| 2003-12-05 14:30:00 | SPY | ETF | 106.7 | 106.89 | 106.68 | 106.8 | 1236100.0 |
| 2003-12-05 15:00:00 | SPY | ETF | 106.8 | 106.96 | 106.65 | 106.93 | 1560100.0 |
| 2003-12-05 15:30:00 | SPY | ETF | 106.92 | 106.94 | 106.62 | 106.81 | 2086200.0 |
| 2003-12-05 16:00:00 | SPY | ETF | 106.79 | 106.94 | 106.76 | 106.85 | 750100.0 |
| 2003-12-05 16:30:00 | SPY | ETF | 106.9 | 106.94 | 106.87 | 106.9 | 9000.0 |
| 2003-12-05 17:00:00 | SPY | ETF | 106.9 | 106.9 | 106.9 | 106.9 | 200.0 |
| 2003-12-05 17:30:00 | SPY | ETF | 106.89 | 106.89 | 106.82 | 106.82 | 12500.0 |
| 2003-12-05 18:00:00 | SPY | ETF | 106.82 | 106.82 | 106.8 | 106.8 | 5100.0 |
| 2003-12-05 18:30:00 | SPY | ETF | 106.8 | 106.83 | 106.8 | 106.83 | 1600.0 |
| 2003-12-05 19:00:00 | SPY | ETF | 106.81 | 106.83 | 106.78 | 106.83 | 3100.0 |
| 2003-12-05 19:30:00 | SPY | ETF | 106.83 | 106.85 | 106.83 | 106.85 | 400.0 |
| 2003-12-05 08:00:00 | QQQ | ETF | 35.39 | 35.41 | 35.35 | 35.4 | 179400.0 |
| 2003-12-05 08:30:00 | QQQ | ETF | 35.41 | 35.41 | 35.18 | 35.2 | 359100.0 |
| 2003-12-05 09:00:00 | QQQ | ETF | 35.22 | 35.29 | 35.2 | 35.27 | 133400.0 |
| 2003-12-05 09:30:00 | QQQ | ETF | 35.27 | 35.37 | 35.16 | 35.322 | 9146500.0 |
| 2003-12-05 10:00:00 | QQQ | ETF | 35.32 | 35.46 | 35.23 | 35.41 | 5385700.0 |
| 2003-12-05 10:30:00 | QQQ | ETF | 35.41 | 35.5 | 35.3 | 35.306 | 5334200.0 |
| 2003-12-05 11:00:00 | QQQ | ETF | 35.31 | 35.479 | 35.23 | 35.451 | 4499500.0 |
| 2003-12-05 11:30:00 | QQQ | ETF | 35.45 | 35.46 | 35.32 | 35.35 | 3718400.0 |
| 2003-12-05 12:00:00 | QQQ | ETF | 35.35 | 35.35 | 35.232 | 35.3 | 2986600.0 |
| 2003-12-05 12:30:00 | QQQ | ETF | 35.31 | 35.35 | 35.24 | 35.31 | 1478300.0 |
| 2003-12-05 13:00:00 | QQQ | ETF | 35.31 | 35.32 | 35.14 | 35.16 | 2958400.0 |
| 2003-12-05 13:30:00 | QQQ | ETF | 35.17 | 35.18 | 34.98 | 35.0 | 9173000.0 |
| 2003-12-05 14:00:00 | QQQ | ETF | 35.0 | 35.09 | 34.96 | 35.02 | 4920800.0 |
| 2003-12-05 14:30:00 | QQQ | ETF | 35.03 | 35.15 | 35.0 | 35.06 | 4253100.0 |
| 2003-12-05 15:00:00 | QQQ | ETF | 35.07 | 35.19 | 34.97 | 35.165 | 5946400.0 |
| 2003-12-05 15:30:00 | QQQ | ETF | 35.15 | 35.17 | 34.96 | 35.05 | 6578100.0 |
| 2003-12-05 16:00:00 | QQQ | ETF | 35.04 | 35.09 | 35.01 | 35.05 | 3479500.0 |
| 2003-12-05 16:30:00 | QQQ | ETF | 35.06 | 35.08 | 35.04 | 35.08 | 25200.0 |
| 2003-12-05 17:00:00 | QQQ | ETF | 35.07 | 35.1 | 35.06 | 35.061 | 63600.0 |
| 2003-12-05 17:30:00 | QQQ | ETF | 35.06 | 35.061 | 35.0 | 35.0 | 110200.0 |
| 2003-12-05 18:00:00 | QQQ | ETF | 35.0 | 35.001 | 34.99 | 35.0 | 26400.0 |
| 2003-12-05 18:30:00 | QQQ | ETF | 35.01 | 35.02 | 35.01 | 35.02 | 1300.0 |
| 2003-12-05 19:00:00 | QQQ | ETF | 35.03 | 35.05 | 35.03 | 35.05 | 3100.0 |
| 2003-12-05 19:30:00 | QQQ | ETF | 35.04 | 35.08 | 35.04 | 35.08 | 8400.0 |
| 2003-12-05 08:30:00 | IWM | ETF | 54.075 | 54.11 | 54.025 | 54.025 | 3200.0 |
| 2003-12-05 09:00:00 | IWM | ETF | 54.025 | 54.025 | 54.025 | 54.025 | 600.0 |
> showing 50 of 839 rows — these rows as CSV