PREVIEW / etf_30min / 2003-01-10
file: by_date/etf_30min/2003/2003-01-10.parquet size: 22 KB rows: 640
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-01-10 08:00:00 | SPY | ETF | 93.2 | 93.32 | 93.15 | 93.32 | 14900.0 |
| 2003-01-10 08:30:00 | SPY | ETF | 93.39 | 93.39 | 92.0 | 92.03 | 294200.0 |
| 2003-01-10 09:00:00 | SPY | ETF | 92.0 | 92.01 | 91.88 | 91.92 | 50000.0 |
| 2003-01-10 09:30:00 | SPY | ETF | 91.95 | 92.68 | 91.8 | 92.62 | 6963200.0 |
| 2003-01-10 10:00:00 | SPY | ETF | 92.63 | 93.05 | 92.53 | 93.05 | 4025400.0 |
| 2003-01-10 10:30:00 | SPY | ETF | 93.04 | 93.5 | 93.0 | 93.43 | 5054300.0 |
| 2003-01-10 11:00:00 | SPY | ETF | 93.44 | 93.64 | 93.0 | 93.03 | 2765700.0 |
| 2003-01-10 11:30:00 | SPY | ETF | 93.01 | 93.3 | 92.97 | 93.28 | 1657900.0 |
| 2003-01-10 12:00:00 | SPY | ETF | 93.21 | 93.25 | 92.85 | 92.88 | 1167500.0 |
| 2003-01-10 12:30:00 | SPY | ETF | 92.9 | 92.99 | 92.48 | 92.66 | 1654500.0 |
| 2003-01-10 13:00:00 | SPY | ETF | 92.65 | 92.82 | 92.57 | 92.64 | 989600.0 |
| 2003-01-10 13:30:00 | SPY | ETF | 92.65 | 93.04 | 92.64 | 92.81 | 1527500.0 |
| 2003-01-10 14:00:00 | SPY | ETF | 92.82 | 93.03 | 92.69 | 92.94 | 1174700.0 |
| 2003-01-10 14:30:00 | SPY | ETF | 92.93 | 93.24 | 92.85 | 93.13 | 1637400.0 |
| 2003-01-10 15:00:00 | SPY | ETF | 93.15 | 93.3 | 92.83 | 92.85 | 1390100.0 |
| 2003-01-10 15:30:00 | SPY | ETF | 92.85 | 93.07 | 92.65 | 93.03 | 2432800.0 |
| 2003-01-10 16:00:00 | SPY | ETF | 92.97 | 93.15 | 92.84 | 93.1 | 1596100.0 |
| 2003-01-10 16:30:00 | SPY | ETF | 93.12 | 93.3 | 93.07 | 93.3 | 56800.0 |
| 2003-01-10 17:30:00 | SPY | ETF | 93.23 | 93.24 | 93.19 | 93.19 | 1200.0 |
| 2003-01-10 18:00:00 | SPY | ETF | 93.17 | 93.25 | 93.16 | 93.23 | 1400.0 |
| 2003-01-10 18:30:00 | SPY | ETF | 93.25 | 93.25 | 93.25 | 93.25 | 100.0 |
| 2003-01-10 19:30:00 | SPY | ETF | 93.28 | 93.28 | 93.28 | 93.28 | 600.0 |
| 2003-01-10 08:00:00 | QQQ | ETF | 26.9 | 27.02 | 26.9 | 26.97 | 99600.0 |
| 2003-01-10 08:30:00 | QQQ | ETF | 27.0 | 27.01 | 26.28 | 26.32 | 432200.0 |
| 2003-01-10 09:00:00 | QQQ | ETF | 26.33 | 26.38 | 26.31 | 26.35 | 129900.0 |
| 2003-01-10 09:30:00 | QQQ | ETF | 26.35 | 26.72 | 26.22 | 26.7 | 14387600.0 |
| 2003-01-10 10:00:00 | QQQ | ETF | 26.7 | 26.97 | 26.65 | 26.95 | 8449000.0 |
| 2003-01-10 10:30:00 | QQQ | ETF | 26.95 | 27.19 | 26.9 | 27.18 | 9083100.0 |
| 2003-01-10 11:00:00 | QQQ | ETF | 27.18 | 27.26 | 26.94 | 26.94 | 5517000.0 |
| 2003-01-10 11:30:00 | QQQ | ETF | 26.94 | 27.09 | 26.92 | 27.05 | 3478700.0 |
| 2003-01-10 12:00:00 | QQQ | ETF | 27.05 | 27.08 | 26.92 | 26.94 | 2965600.0 |
| 2003-01-10 12:30:00 | QQQ | ETF | 26.94 | 27.0 | 26.7 | 26.8 | 6595900.0 |
| 2003-01-10 13:00:00 | QQQ | ETF | 26.8 | 26.91 | 26.77 | 26.84 | 3185200.0 |
| 2003-01-10 13:30:00 | QQQ | ETF | 26.85 | 26.99 | 26.83 | 26.91 | 3302400.0 |
| 2003-01-10 14:00:00 | QQQ | ETF | 26.92 | 27.01 | 26.88 | 26.97 | 2321400.0 |
| 2003-01-10 14:30:00 | QQQ | ETF | 27.0 | 27.13 | 26.94 | 27.06 | 3630200.0 |
| 2003-01-10 15:00:00 | QQQ | ETF | 27.05 | 27.13 | 26.94 | 26.95 | 3386900.0 |
| 2003-01-10 15:30:00 | QQQ | ETF | 26.95 | 27.05 | 26.85 | 27.04 | 5750200.0 |
| 2003-01-10 16:00:00 | QQQ | ETF | 27.04 | 27.15 | 27.01 | 27.13 | 1732600.0 |
| 2003-01-10 16:30:00 | QQQ | ETF | 27.15 | 27.2 | 27.11 | 27.15 | 95800.0 |
| 2003-01-10 17:00:00 | QQQ | ETF | 27.1 | 27.16 | 27.1 | 27.16 | 140500.0 |
| 2003-01-10 17:30:00 | QQQ | ETF | 27.16 | 27.17 | 27.13 | 27.14 | 18700.0 |
| 2003-01-10 18:00:00 | QQQ | ETF | 27.13 | 27.16 | 27.13 | 27.16 | 16300.0 |
| 2003-01-10 18:30:00 | QQQ | ETF | 27.15 | 27.16 | 27.13 | 27.14 | 3800.0 |
| 2003-01-10 19:00:00 | QQQ | ETF | 27.16 | 27.16 | 27.13 | 27.16 | 4300.0 |
| 2003-01-10 19:30:00 | QQQ | ETF | 27.14 | 27.17 | 27.14 | 27.17 | 9300.0 |
| 2003-01-10 09:30:00 | IWM | ETF | 38.915 | 39.31 | 38.85 | 39.29 | 281400.0 |
| 2003-01-10 10:00:00 | IWM | ETF | 39.335 | 39.46 | 39.29 | 39.46 | 354000.0 |
| 2003-01-10 10:30:00 | IWM | ETF | 39.46 | 39.59 | 39.46 | 39.56 | 353000.0 |
| 2003-01-10 11:00:00 | IWM | ETF | 39.625 | 39.625 | 39.425 | 39.425 | 281600.0 |
> showing 50 of 640 rows — these rows as CSV