PREVIEW / etf_30min / 2004-08-06
file: by_date/etf_30min/2004/2004-08-06.parquet size: 38 KB rows: 1,236
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-08-06 08:00:00 | SPY | ETF | 108.6 | 108.76 | 108.58 | 108.58 | 77600.0 |
| 2004-08-06 08:30:00 | SPY | ETF | 108.4 | 108.4 | 107.19 | 107.39 | 833400.0 |
| 2004-08-06 09:00:00 | SPY | ETF | 107.39 | 107.68 | 107.37 | 107.65 | 638200.0 |
| 2004-08-06 09:30:00 | SPY | ETF | 107.63 | 107.965 | 107.5 | 107.6 | 12379600.0 |
| 2004-08-06 10:00:00 | SPY | ETF | 107.6 | 107.92 | 107.3 | 107.79 | 7265200.0 |
| 2004-08-06 10:30:00 | SPY | ETF | 107.79 | 107.88 | 107.5 | 107.51 | 5015000.0 |
| 2004-08-06 11:00:00 | SPY | ETF | 107.51 | 107.84 | 107.38 | 107.82 | 5638000.0 |
| 2004-08-06 11:30:00 | SPY | ETF | 107.82 | 107.83 | 107.41 | 107.58 | 3084400.0 |
| 2004-08-06 12:00:00 | SPY | ETF | 107.58 | 107.8 | 107.49 | 107.64 | 2444500.0 |
| 2004-08-06 12:30:00 | SPY | ETF | 107.64 | 107.7 | 107.43 | 107.51 | 2753800.0 |
| 2004-08-06 13:00:00 | SPY | ETF | 107.52 | 107.71 | 107.4 | 107.63 | 1917200.0 |
| 2004-08-06 13:30:00 | SPY | ETF | 107.63 | 107.67 | 107.27 | 107.41 | 2261800.0 |
| 2004-08-06 14:00:00 | SPY | ETF | 107.42 | 107.56 | 107.19 | 107.56 | 4496300.0 |
| 2004-08-06 14:30:00 | SPY | ETF | 107.54 | 107.58 | 107.02 | 107.1 | 3746100.0 |
| 2004-08-06 15:00:00 | SPY | ETF | 107.11 | 107.15 | 106.72 | 106.74 | 6756600.0 |
| 2004-08-06 15:30:00 | SPY | ETF | 106.74 | 107.09 | 106.62 | 106.83 | 8469300.0 |
| 2004-08-06 16:00:00 | SPY | ETF | 106.83 | 107.04 | 106.7 | 106.85 | 2473800.0 |
| 2004-08-06 16:30:00 | SPY | ETF | 106.85 | 106.88 | 106.72 | 106.72 | 40600.0 |
| 2004-08-06 17:00:00 | SPY | ETF | 106.79 | 106.84 | 106.75 | 106.84 | 13800.0 |
| 2004-08-06 17:30:00 | SPY | ETF | 106.77 | 106.79 | 106.7 | 106.79 | 9800.0 |
| 2004-08-06 18:00:00 | SPY | ETF | 106.72 | 106.72 | 106.6 | 106.6 | 7400.0 |
| 2004-08-06 18:30:00 | SPY | ETF | 106.7 | 106.74 | 106.7 | 106.74 | 400.0 |
| 2004-08-06 19:00:00 | SPY | ETF | 106.78 | 106.78 | 106.78 | 106.78 | 100.0 |
| 2004-08-06 19:30:00 | SPY | ETF | 106.7 | 106.7 | 106.7 | 106.7 | 400.0 |
| 2004-08-06 08:00:00 | QQQ | ETF | 33.68 | 33.75 | 33.68 | 33.7 | 116600.0 |
| 2004-08-06 08:30:00 | QQQ | ETF | 33.7 | 33.7 | 33.18 | 33.26 | 2217300.0 |
| 2004-08-06 09:00:00 | QQQ | ETF | 33.26 | 33.41 | 33.24 | 33.41 | 1101500.0 |
| 2004-08-06 09:30:00 | QQQ | ETF | 33.4 | 33.4 | 33.17 | 33.21 | 23887800.0 |
| 2004-08-06 10:00:00 | QQQ | ETF | 33.21 | 33.36 | 33.11 | 33.31 | 15563900.0 |
| 2004-08-06 10:30:00 | QQQ | ETF | 33.309 | 33.356 | 33.14 | 33.15 | 9724400.0 |
| 2004-08-06 11:00:00 | QQQ | ETF | 33.16 | 33.3 | 33.11 | 33.3 | 9094900.0 |
| 2004-08-06 11:30:00 | QQQ | ETF | 33.29 | 33.3 | 33.16 | 33.22 | 5201300.0 |
| 2004-08-06 12:00:00 | QQQ | ETF | 33.212 | 33.33 | 33.17 | 33.26 | 6815700.0 |
| 2004-08-06 12:30:00 | QQQ | ETF | 33.25 | 33.26 | 33.17 | 33.21 | 6578000.0 |
| 2004-08-06 13:00:00 | QQQ | ETF | 33.213 | 33.234 | 33.14 | 33.22 | 3683800.0 |
| 2004-08-06 13:30:00 | QQQ | ETF | 33.2175 | 33.24 | 33.033 | 33.09 | 5841800.0 |
| 2004-08-06 14:00:00 | QQQ | ETF | 33.09 | 33.14 | 32.99 | 33.14 | 6660600.0 |
| 2004-08-06 14:30:00 | QQQ | ETF | 33.132 | 33.157 | 32.96 | 32.978 | 6628400.0 |
| 2004-08-06 15:00:00 | QQQ | ETF | 32.98 | 33.0 | 32.75 | 32.75 | 15725800.0 |
| 2004-08-06 15:30:00 | QQQ | ETF | 32.75 | 32.85 | 32.66 | 32.73 | 17852900.0 |
| 2004-08-06 16:00:00 | QQQ | ETF | 32.742 | 32.83 | 32.68 | 32.74 | 5969000.0 |
| 2004-08-06 16:30:00 | QQQ | ETF | 32.74 | 32.77 | 32.69 | 32.7 | 170800.0 |
| 2004-08-06 17:00:00 | QQQ | ETF | 32.71 | 32.73 | 32.7 | 32.7 | 97200.0 |
| 2004-08-06 17:30:00 | QQQ | ETF | 32.7 | 32.72 | 32.7 | 32.72 | 24800.0 |
| 2004-08-06 18:00:00 | QQQ | ETF | 32.712 | 32.75 | 32.7 | 32.72 | 19800.0 |
| 2004-08-06 18:30:00 | QQQ | ETF | 32.72 | 32.72 | 32.7 | 32.7 | 2000.0 |
| 2004-08-06 19:00:00 | QQQ | ETF | 32.71 | 32.72 | 32.69 | 32.72 | 4600.0 |
| 2004-08-06 19:30:00 | QQQ | ETF | 32.72 | 32.73 | 32.7 | 32.71 | 1200.0 |
| 2004-08-06 20:00:00 | QQQ | ETF | 32.71 | 32.71 | 32.71 | 32.71 | 500.0 |
| 2004-08-06 08:30:00 | IWM | ETF | 53.065 | 53.065 | 52.04 | 52.11 | 199600.0 |
> showing 50 of 1,236 rows — these rows as CSV