PREVIEW / etf_30min / 2004-09-17
file: by_date/etf_30min/2004/2004-09-17.parquet size: 34 KB rows: 1,159
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-09-17 08:00:00 | SPY | ETF | 112.97 | 112.97 | 112.88 | 112.9 | 32800.0 |
| 2004-09-17 08:30:00 | SPY | ETF | 112.97 | 113.05 | 112.95 | 112.95 | 84500.0 |
| 2004-09-17 09:00:00 | SPY | ETF | 112.96 | 113.0 | 112.81 | 112.93 | 127900.0 |
| 2004-09-17 09:30:00 | SPY | ETF | 112.95 | 113.09 | 112.84 | 112.87 | 4831000.0 |
| 2004-09-17 10:00:00 | SPY | ETF | 112.87 | 112.92 | 112.69 | 112.9 | 3881400.0 |
| 2004-09-17 10:30:00 | SPY | ETF | 112.9 | 113.36 | 112.85 | 113.3 | 4363800.0 |
| 2004-09-17 11:00:00 | SPY | ETF | 113.3 | 113.32 | 113.11 | 113.15 | 2215300.0 |
| 2004-09-17 11:30:00 | SPY | ETF | 113.15 | 113.23 | 113.09 | 113.13 | 1464400.0 |
| 2004-09-17 12:00:00 | SPY | ETF | 113.13 | 113.24 | 113.02 | 113.19 | 1126500.0 |
| 2004-09-17 12:30:00 | SPY | ETF | 113.2 | 113.24 | 113.14 | 113.16 | 587000.0 |
| 2004-09-17 13:00:00 | SPY | ETF | 113.15 | 113.17 | 113.06 | 113.11 | 769900.0 |
| 2004-09-17 13:30:00 | SPY | ETF | 113.12 | 113.15 | 112.87 | 113.01 | 2121000.0 |
| 2004-09-17 14:00:00 | SPY | ETF | 113.02 | 113.06 | 112.9 | 112.92 | 1190600.0 |
| 2004-09-17 14:30:00 | SPY | ETF | 112.93 | 113.27 | 112.91 | 113.21 | 1687000.0 |
| 2004-09-17 15:00:00 | SPY | ETF | 113.22 | 113.24 | 113.02 | 113.06 | 1428200.0 |
| 2004-09-17 15:30:00 | SPY | ETF | 113.06 | 113.23 | 112.96 | 113.11 | 2217300.0 |
| 2004-09-17 16:00:00 | SPY | ETF | 113.11 | 113.15 | 112.98 | 113.07 | 1827000.0 |
| 2004-09-17 16:30:00 | SPY | ETF | 113.07 | 113.1 | 113.07 | 113.1 | 40100.0 |
| 2004-09-17 17:00:00 | SPY | ETF | 113.12 | 113.15 | 113.12 | 113.15 | 191100.0 |
| 2004-09-17 18:00:00 | SPY | ETF | 113.08 | 113.14 | 113.08 | 113.14 | 900.0 |
| 2004-09-17 08:00:00 | QQQ | ETF | 35.36 | 35.36 | 35.33 | 35.35 | 48000.0 |
| 2004-09-17 08:30:00 | QQQ | ETF | 35.37 | 35.42 | 35.37 | 35.38 | 131700.0 |
| 2004-09-17 09:00:00 | QQQ | ETF | 35.38 | 35.42 | 35.18 | 35.23 | 965500.0 |
| 2004-09-17 09:30:00 | QQQ | ETF | 35.23 | 35.37 | 35.2 | 35.223 | 12230500.0 |
| 2004-09-17 10:00:00 | QQQ | ETF | 35.222 | 35.3 | 35.16 | 35.28 | 7320700.0 |
| 2004-09-17 10:30:00 | QQQ | ETF | 35.298 | 35.52 | 35.28 | 35.49 | 11034400.0 |
| 2004-09-17 11:00:00 | QQQ | ETF | 35.49 | 35.492 | 35.38 | 35.38 | 6385800.0 |
| 2004-09-17 11:30:00 | QQQ | ETF | 35.386 | 35.455 | 35.35 | 35.43 | 3788300.0 |
| 2004-09-17 12:00:00 | QQQ | ETF | 35.429 | 35.44 | 35.37 | 35.402 | 3109800.0 |
| 2004-09-17 12:30:00 | QQQ | ETF | 35.402 | 35.41 | 35.37 | 35.391 | 1649600.0 |
| 2004-09-17 13:00:00 | QQQ | ETF | 35.39 | 35.4 | 35.34 | 35.38 | 2742600.0 |
| 2004-09-17 13:30:00 | QQQ | ETF | 35.39 | 35.41 | 35.3 | 35.36 | 3742300.0 |
| 2004-09-17 14:00:00 | QQQ | ETF | 35.369 | 35.41 | 35.34 | 35.345 | 2435400.0 |
| 2004-09-17 14:30:00 | QQQ | ETF | 35.345 | 35.5 | 35.34 | 35.46 | 5909100.0 |
| 2004-09-17 15:00:00 | QQQ | ETF | 35.45 | 35.474 | 35.38 | 35.4 | 6071200.0 |
| 2004-09-17 15:30:00 | QQQ | ETF | 35.4 | 35.48 | 35.37 | 35.45 | 10509400.0 |
| 2004-09-17 16:00:00 | QQQ | ETF | 35.45 | 35.49 | 35.398 | 35.44 | 4023600.0 |
| 2004-09-17 16:30:00 | QQQ | ETF | 35.44 | 35.44 | 35.42 | 35.43 | 216300.0 |
| 2004-09-17 17:00:00 | QQQ | ETF | 35.43 | 35.45 | 35.43 | 35.45 | 14800.0 |
| 2004-09-17 17:30:00 | QQQ | ETF | 35.45 | 35.45 | 35.43 | 35.43 | 14600.0 |
| 2004-09-17 18:00:00 | QQQ | ETF | 35.43 | 35.43 | 35.43 | 35.43 | 5300.0 |
| 2004-09-17 08:00:00 | IWM | ETF | 57.48 | 57.49 | 57.48 | 57.49 | 1600.0 |
| 2004-09-17 09:00:00 | IWM | ETF | 57.445 | 57.445 | 57.24 | 57.335 | 85400.0 |
| 2004-09-17 09:30:00 | IWM | ETF | 57.3 | 57.44 | 56.885 | 56.89 | 1526200.0 |
| 2004-09-17 10:00:00 | IWM | ETF | 56.89 | 57.05 | 56.775 | 57.05 | 2281000.0 |
| 2004-09-17 10:30:00 | IWM | ETF | 57.095 | 57.29 | 57.04 | 57.265 | 836800.0 |
| 2004-09-17 11:00:00 | IWM | ETF | 57.265 | 57.305 | 57.18 | 57.2 | 538400.0 |
| 2004-09-17 11:30:00 | IWM | ETF | 57.205 | 57.27 | 57.16 | 57.255 | 420400.0 |
| 2004-09-17 12:00:00 | IWM | ETF | 57.26 | 57.29 | 57.205 | 57.22 | 1124600.0 |
| 2004-09-17 12:30:00 | IWM | ETF | 57.235 | 57.29 | 57.18 | 57.18 | 390000.0 |
> showing 50 of 1,159 rows — these rows as CSV