PREVIEW / etf_30min / 2004-08-13
file: by_date/etf_30min/2004/2004-08-13.parquet size: 34 KB rows: 1,147
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-13 08:00:00 | SPY | ETF | 107.22 | 107.35 | 107.21 | 107.34 | 85100.0 |
| 2004-08-13 08:30:00 | SPY | ETF | 107.21 | 107.31 | 106.93 | 106.99 | 51300.0 |
| 2004-08-13 09:00:00 | SPY | ETF | 107.08 | 107.14 | 107.06 | 107.1 | 26200.0 |
| 2004-08-13 09:30:00 | SPY | ETF | 107.1 | 107.34 | 106.99 | 107.21 | 5724000.0 |
| 2004-08-13 10:00:00 | SPY | ETF | 107.21 | 107.24 | 106.77 | 107.05 | 7287800.0 |
| 2004-08-13 10:30:00 | SPY | ETF | 107.06 | 107.28 | 106.99 | 107.08 | 2873600.0 |
| 2004-08-13 11:00:00 | SPY | ETF | 107.07 | 107.34 | 107.07 | 107.15 | 1765100.0 |
| 2004-08-13 11:30:00 | SPY | ETF | 107.16 | 107.35 | 107.06 | 107.16 | 1755400.0 |
| 2004-08-13 12:00:00 | SPY | ETF | 107.16 | 107.19 | 106.85 | 106.9 | 1633500.0 |
| 2004-08-13 12:30:00 | SPY | ETF | 106.92 | 107.01 | 106.72 | 106.87 | 1860900.0 |
| 2004-08-13 13:00:00 | SPY | ETF | 106.87 | 106.98 | 106.85 | 106.91 | 860500.0 |
| 2004-08-13 13:30:00 | SPY | ETF | 106.92 | 107.18 | 106.85 | 107.09 | 909600.0 |
| 2004-08-13 14:00:00 | SPY | ETF | 107.09 | 107.12 | 106.85 | 106.93 | 1447000.0 |
| 2004-08-13 14:30:00 | SPY | ETF | 106.93 | 107.08 | 106.74 | 106.74 | 2418500.0 |
| 2004-08-13 15:00:00 | SPY | ETF | 106.76 | 106.89 | 106.59 | 106.67 | 3838600.0 |
| 2004-08-13 15:30:00 | SPY | ETF | 106.66 | 107.08 | 106.63 | 107.07 | 3624400.0 |
| 2004-08-13 16:00:00 | SPY | ETF | 107.07 | 107.2 | 107.0 | 107.19 | 1972400.0 |
| 2004-08-13 16:30:00 | SPY | ETF | 107.19 | 107.24 | 107.02 | 107.02 | 55900.0 |
| 2004-08-13 17:00:00 | SPY | ETF | 107.05 | 107.05 | 106.97 | 107.0 | 20400.0 |
| 2004-08-13 17:30:00 | SPY | ETF | 107.04 | 107.05 | 107.0 | 107.0 | 2500.0 |
| 2004-08-13 18:00:00 | SPY | ETF | 107.0 | 107.0 | 107.0 | 107.0 | 1700.0 |
| 2004-08-13 08:00:00 | QQQ | ETF | 32.69 | 32.72 | 32.68 | 32.69 | 165600.0 |
| 2004-08-13 08:30:00 | QQQ | ETF | 32.69 | 32.71 | 32.58 | 32.63 | 179300.0 |
| 2004-08-13 09:00:00 | QQQ | ETF | 32.63 | 32.66 | 32.63 | 32.65 | 271700.0 |
| 2004-08-13 09:30:00 | QQQ | ETF | 32.65 | 32.74 | 32.59 | 32.63 | 14813500.0 |
| 2004-08-13 10:00:00 | QQQ | ETF | 32.63 | 32.6375 | 32.45 | 32.536 | 11997900.0 |
| 2004-08-13 10:30:00 | QQQ | ETF | 32.53 | 32.61 | 32.49 | 32.53 | 6055000.0 |
| 2004-08-13 11:00:00 | QQQ | ETF | 32.539 | 32.646 | 32.53 | 32.58 | 4601300.0 |
| 2004-08-13 11:30:00 | QQQ | ETF | 32.58 | 32.65 | 32.56 | 32.611 | 4248700.0 |
| 2004-08-13 12:00:00 | QQQ | ETF | 32.61 | 32.62 | 32.4 | 32.43 | 5157900.0 |
| 2004-08-13 12:30:00 | QQQ | ETF | 32.44 | 32.51 | 32.35 | 32.45 | 8652300.0 |
| 2004-08-13 13:00:00 | QQQ | ETF | 32.45 | 32.5 | 32.43 | 32.47 | 2675500.0 |
| 2004-08-13 13:30:00 | QQQ | ETF | 32.474 | 32.56 | 32.43 | 32.52 | 2952000.0 |
| 2004-08-13 14:00:00 | QQQ | ETF | 32.52 | 32.54 | 32.416 | 32.5 | 3735200.0 |
| 2004-08-13 14:30:00 | QQQ | ETF | 32.504 | 32.543 | 32.42 | 32.43 | 5009800.0 |
| 2004-08-13 15:00:00 | QQQ | ETF | 32.43 | 32.48 | 32.36 | 32.4 | 6673300.0 |
| 2004-08-13 15:30:00 | QQQ | ETF | 32.4 | 32.56 | 32.39 | 32.53 | 8526200.0 |
| 2004-08-13 16:00:00 | QQQ | ETF | 32.537 | 32.573 | 32.498 | 32.54 | 2617100.0 |
| 2004-08-13 16:30:00 | QQQ | ETF | 32.54 | 32.54 | 32.45 | 32.47 | 271600.0 |
| 2004-08-13 17:00:00 | QQQ | ETF | 32.49 | 32.5 | 32.48 | 32.5 | 11400.0 |
| 2004-08-13 17:30:00 | QQQ | ETF | 32.5 | 32.52 | 32.5 | 32.52 | 8800.0 |
| 2004-08-13 18:00:00 | QQQ | ETF | 32.51 | 32.52 | 32.51 | 32.52 | 7700.0 |
| 2004-08-13 18:30:00 | QQQ | ETF | 32.51 | 32.51 | 32.51 | 32.51 | 1000.0 |
| 2004-08-13 19:00:00 | QQQ | ETF | 32.51 | 32.51 | 32.5 | 32.5 | 1900.0 |
| 2004-08-13 19:30:00 | QQQ | ETF | 32.51 | 32.52 | 32.51 | 32.52 | 2000.0 |
| 2004-08-13 08:00:00 | IWM | ETF | 51.8 | 51.8 | 51.8 | 51.8 | 1000.0 |
| 2004-08-13 08:30:00 | IWM | ETF | 51.875 | 51.875 | 51.675 | 51.675 | 6800.0 |
| 2004-08-13 09:00:00 | IWM | ETF | 51.77 | 51.77 | 51.77 | 51.77 | 200.0 |
| 2004-08-13 09:30:00 | IWM | ETF | 51.785 | 52.04 | 51.785 | 51.935 | 1261600.0 |
| 2004-08-13 10:00:00 | IWM | ETF | 51.93 | 51.93 | 51.61 | 51.885 | 996400.0 |
> showing 50 of 1,147 rows — these rows as CSV