PREVIEW / etf_30min / 2004-08-31
file: by_date/etf_30min/2004/2004-08-31.parquet size: 35 KB rows: 1,149
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-31 08:00:00 | SPY | ETF | 110.59 | 110.66 | 110.59 | 110.63 | 74700.0 |
| 2004-08-31 08:30:00 | SPY | ETF | 110.65 | 110.76 | 110.65 | 110.74 | 18000.0 |
| 2004-08-31 09:00:00 | SPY | ETF | 110.71 | 110.75 | 110.67 | 110.67 | 24300.0 |
| 2004-08-31 09:30:00 | SPY | ETF | 110.7 | 110.92 | 110.65 | 110.83 | 3280200.0 |
| 2004-08-31 10:00:00 | SPY | ETF | 110.83 | 110.84 | 110.45 | 110.54 | 6042700.0 |
| 2004-08-31 10:30:00 | SPY | ETF | 110.53 | 110.65 | 110.36 | 110.43 | 3810200.0 |
| 2004-08-31 11:00:00 | SPY | ETF | 110.41 | 110.43 | 110.24 | 110.35 | 4013800.0 |
| 2004-08-31 11:30:00 | SPY | ETF | 110.34 | 110.39 | 110.2 | 110.27 | 2192300.0 |
| 2004-08-31 12:00:00 | SPY | ETF | 110.21 | 110.39 | 110.16 | 110.38 | 2517800.0 |
| 2004-08-31 12:30:00 | SPY | ETF | 110.37 | 110.44 | 110.26 | 110.29 | 1276100.0 |
| 2004-08-31 13:00:00 | SPY | ETF | 110.29 | 110.31 | 110.11 | 110.26 | 1608100.0 |
| 2004-08-31 13:30:00 | SPY | ETF | 110.25 | 110.35 | 110.17 | 110.3 | 1176500.0 |
| 2004-08-31 14:00:00 | SPY | ETF | 110.29 | 110.31 | 110.1 | 110.26 | 1656800.0 |
| 2004-08-31 14:30:00 | SPY | ETF | 110.25 | 110.83 | 110.23 | 110.78 | 4124100.0 |
| 2004-08-31 15:00:00 | SPY | ETF | 110.78 | 110.8 | 110.51 | 110.69 | 2633200.0 |
| 2004-08-31 15:30:00 | SPY | ETF | 110.69 | 111.08 | 110.63 | 111.07 | 3785200.0 |
| 2004-08-31 16:00:00 | SPY | ETF | 111.07 | 111.18 | 111.01 | 111.08 | 4035700.0 |
| 2004-08-31 16:30:00 | SPY | ETF | 111.1 | 111.16 | 111.07 | 111.16 | 393200.0 |
| 2004-08-31 17:00:00 | SPY | ETF | 111.14 | 111.17 | 111.12 | 111.14 | 43900.0 |
| 2004-08-31 17:30:00 | SPY | ETF | 111.14 | 111.14 | 111.12 | 111.12 | 3300.0 |
| 2004-08-31 18:00:00 | SPY | ETF | 111.13 | 111.15 | 111.11 | 111.15 | 22700.0 |
| 2004-08-31 18:30:00 | SPY | ETF | 111.1 | 111.13 | 111.1 | 111.13 | 2000.0 |
| 2004-08-31 19:00:00 | SPY | ETF | 111.12 | 111.12 | 111.12 | 111.12 | 100.0 |
| 2004-08-31 19:30:00 | SPY | ETF | 111.12 | 111.12 | 111.12 | 111.12 | 2200.0 |
| 2004-08-31 08:00:00 | QQQ | ETF | 33.96 | 34.0 | 33.96 | 34.0 | 14100.0 |
| 2004-08-31 08:30:00 | QQQ | ETF | 34.02 | 34.05 | 34.01 | 34.05 | 31600.0 |
| 2004-08-31 09:00:00 | QQQ | ETF | 34.04 | 34.05 | 34.01 | 34.02 | 82900.0 |
| 2004-08-31 09:30:00 | QQQ | ETF | 34.02 | 34.121 | 33.99 | 34.076 | 8525500.0 |
| 2004-08-31 10:00:00 | QQQ | ETF | 34.079 | 34.08 | 33.85 | 33.9 | 10635900.0 |
| 2004-08-31 10:30:00 | QQQ | ETF | 33.9 | 33.94 | 33.81 | 33.824 | 5265400.0 |
| 2004-08-31 11:00:00 | QQQ | ETF | 33.82 | 33.84 | 33.67 | 33.75 | 10136900.0 |
| 2004-08-31 11:30:00 | QQQ | ETF | 33.741 | 33.76 | 33.69 | 33.72 | 3178600.0 |
| 2004-08-31 12:00:00 | QQQ | ETF | 33.72 | 33.77 | 33.69 | 33.76 | 2636800.0 |
| 2004-08-31 12:30:00 | QQQ | ETF | 33.756 | 33.8 | 33.699 | 33.71 | 3538400.0 |
| 2004-08-31 13:00:00 | QQQ | ETF | 33.71 | 33.75 | 33.68 | 33.74 | 2423000.0 |
| 2004-08-31 13:30:00 | QQQ | ETF | 33.733 | 33.75 | 33.665 | 33.738 | 2649900.0 |
| 2004-08-31 14:00:00 | QQQ | ETF | 33.738 | 33.8 | 33.67 | 33.74 | 3161600.0 |
| 2004-08-31 14:30:00 | QQQ | ETF | 33.735 | 33.97 | 33.73 | 33.93 | 6850300.0 |
| 2004-08-31 15:00:00 | QQQ | ETF | 33.928 | 33.94 | 33.82 | 33.89 | 6091500.0 |
| 2004-08-31 15:30:00 | QQQ | ETF | 33.895 | 34.04 | 33.879 | 33.997 | 9088700.0 |
| 2004-08-31 16:00:00 | QQQ | ETF | 33.99 | 34.04 | 33.8361 | 34.03 | 5195900.0 |
| 2004-08-31 16:30:00 | QQQ | ETF | 34.03 | 34.05 | 34.02 | 34.023 | 128400.0 |
| 2004-08-31 17:00:00 | QQQ | ETF | 34.03 | 34.05 | 34.03 | 34.04 | 42100.0 |
| 2004-08-31 17:30:00 | QQQ | ETF | 34.04 | 34.05 | 34.03 | 34.04 | 14900.0 |
| 2004-08-31 18:00:00 | QQQ | ETF | 34.036 | 34.06 | 34.03 | 34.05 | 85800.0 |
| 2004-08-31 18:30:00 | QQQ | ETF | 34.04 | 34.06 | 34.03 | 34.03 | 13100.0 |
| 2004-08-31 09:00:00 | IWM | ETF | 54.39 | 54.39 | 54.39 | 54.39 | 2000.0 |
| 2004-08-31 09:30:00 | IWM | ETF | 54.4 | 54.75 | 54.33 | 54.64 | 4294600.0 |
| 2004-08-31 10:00:00 | IWM | ETF | 54.65 | 54.655 | 54.255 | 54.31 | 3065200.0 |
| 2004-08-31 10:30:00 | IWM | ETF | 54.31 | 54.4 | 54.13 | 54.18 | 1646000.0 |
> showing 50 of 1,149 rows — these rows as CSV