PREVIEW / etf_30min / 2004-08-16
file: by_date/etf_30min/2004/2004-08-16.parquet size: 33 KB rows: 1,100
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-16 08:00:00 | SPY | ETF | 107.29 | 107.31 | 107.25 | 107.31 | 28300.0 |
| 2004-08-16 08:30:00 | SPY | ETF | 107.25 | 107.26 | 107.15 | 107.26 | 36500.0 |
| 2004-08-16 09:00:00 | SPY | ETF | 107.22 | 107.23 | 107.15 | 107.15 | 28400.0 |
| 2004-08-16 09:30:00 | SPY | ETF | 107.14 | 107.77 | 107.1 | 107.65 | 5919000.0 |
| 2004-08-16 10:00:00 | SPY | ETF | 107.65 | 108.25 | 107.59 | 108.12 | 5300700.0 |
| 2004-08-16 10:30:00 | SPY | ETF | 108.14 | 108.24 | 108.02 | 108.15 | 2386000.0 |
| 2004-08-16 11:00:00 | SPY | ETF | 108.16 | 108.43 | 108.14 | 108.23 | 2840600.0 |
| 2004-08-16 11:30:00 | SPY | ETF | 108.24 | 108.33 | 108.18 | 108.19 | 1591800.0 |
| 2004-08-16 12:00:00 | SPY | ETF | 108.2 | 108.31 | 108.11 | 108.2 | 2145800.0 |
| 2004-08-16 12:30:00 | SPY | ETF | 108.19 | 108.31 | 108.13 | 108.28 | 2549000.0 |
| 2004-08-16 13:00:00 | SPY | ETF | 108.27 | 108.45 | 108.21 | 108.3 | 2477500.0 |
| 2004-08-16 13:30:00 | SPY | ETF | 108.3 | 108.41 | 108.22 | 108.34 | 1933500.0 |
| 2004-08-16 14:00:00 | SPY | ETF | 108.36 | 108.64 | 108.32 | 108.57 | 3266000.0 |
| 2004-08-16 14:30:00 | SPY | ETF | 108.57 | 108.59 | 108.44 | 108.51 | 1827500.0 |
| 2004-08-16 15:00:00 | SPY | ETF | 108.52 | 108.55 | 108.28 | 108.36 | 3210500.0 |
| 2004-08-16 15:30:00 | SPY | ETF | 108.37 | 108.56 | 108.29 | 108.53 | 4437900.0 |
| 2004-08-16 16:00:00 | SPY | ETF | 108.54 | 108.55 | 108.27 | 108.28 | 2215500.0 |
| 2004-08-16 16:30:00 | SPY | ETF | 108.3 | 108.33 | 108.2 | 108.27 | 333300.0 |
| 2004-08-16 17:00:00 | SPY | ETF | 108.27 | 108.27 | 108.27 | 108.27 | 10000.0 |
| 2004-08-16 17:30:00 | SPY | ETF | 108.28 | 108.28 | 108.23 | 108.23 | 700.0 |
| 2004-08-16 18:00:00 | SPY | ETF | 108.23 | 108.32 | 108.23 | 108.32 | 3900.0 |
| 2004-08-16 19:00:00 | SPY | ETF | 108.31 | 108.31 | 108.31 | 108.31 | 400.0 |
| 2004-08-16 19:30:00 | SPY | ETF | 108.31 | 108.31 | 108.31 | 108.31 | 500.0 |
| 2004-08-16 08:00:00 | QQQ | ETF | 32.67 | 32.7 | 32.67 | 32.67 | 18700.0 |
| 2004-08-16 08:30:00 | QQQ | ETF | 32.65 | 32.7 | 32.65 | 32.69 | 74300.0 |
| 2004-08-16 09:00:00 | QQQ | ETF | 32.68 | 32.68 | 32.61 | 32.62 | 84200.0 |
| 2004-08-16 09:30:00 | QQQ | ETF | 32.61 | 32.87 | 32.586 | 32.809 | 12735800.0 |
| 2004-08-16 10:00:00 | QQQ | ETF | 32.83 | 32.99 | 32.777 | 32.93 | 8593800.0 |
| 2004-08-16 10:30:00 | QQQ | ETF | 32.93 | 32.96 | 32.88 | 32.94 | 5400200.0 |
| 2004-08-16 11:00:00 | QQQ | ETF | 32.93 | 33.09 | 32.91 | 33.04 | 6820800.0 |
| 2004-08-16 11:30:00 | QQQ | ETF | 33.035 | 33.067 | 32.97 | 32.98 | 3027700.0 |
| 2004-08-16 12:00:00 | QQQ | ETF | 32.98 | 33.004 | 32.93 | 32.95 | 3030400.0 |
| 2004-08-16 12:30:00 | QQQ | ETF | 32.95 | 33.02 | 32.94 | 33.02 | 1963600.0 |
| 2004-08-16 13:00:00 | QQQ | ETF | 33.013 | 33.05 | 32.97 | 32.98 | 2620300.0 |
| 2004-08-16 13:30:00 | QQQ | ETF | 32.99 | 33.03 | 32.94 | 33.0206 | 2730500.0 |
| 2004-08-16 14:00:00 | QQQ | ETF | 33.02 | 33.19 | 33.02 | 33.1625 | 7166100.0 |
| 2004-08-16 14:30:00 | QQQ | ETF | 33.17 | 33.17 | 33.06 | 33.12 | 4398500.0 |
| 2004-08-16 15:00:00 | QQQ | ETF | 33.13 | 33.15 | 32.97 | 33.02 | 5807000.0 |
| 2004-08-16 15:30:00 | QQQ | ETF | 33.023 | 33.07 | 32.97 | 32.98 | 6625900.0 |
| 2004-08-16 16:00:00 | QQQ | ETF | 32.983 | 33.0 | 32.83 | 32.99 | 2440000.0 |
| 2004-08-16 16:30:00 | QQQ | ETF | 32.879 | 32.88 | 32.801 | 32.85 | 671500.0 |
| 2004-08-16 17:00:00 | QQQ | ETF | 32.83 | 32.85 | 32.83 | 32.85 | 79300.0 |
| 2004-08-16 17:30:00 | QQQ | ETF | 32.84 | 32.842 | 32.83 | 32.84 | 13200.0 |
| 2004-08-16 18:00:00 | QQQ | ETF | 32.84 | 32.87 | 32.84 | 32.87 | 22400.0 |
| 2004-08-16 18:30:00 | QQQ | ETF | 32.87 | 32.87 | 32.86 | 32.87 | 2700.0 |
| 2004-08-16 19:00:00 | QQQ | ETF | 32.87 | 32.87 | 32.86 | 32.87 | 6500.0 |
| 2004-08-16 19:30:00 | QQQ | ETF | 32.87 | 32.88 | 32.83 | 32.83 | 44400.0 |
| 2004-08-16 08:30:00 | IWM | ETF | 51.725 | 51.725 | 51.725 | 51.725 | 1000.0 |
| 2004-08-16 09:00:00 | IWM | ETF | 51.75 | 51.76 | 51.75 | 51.76 | 4000.0 |
| 2004-08-16 09:30:00 | IWM | ETF | 51.78 | 52.34 | 51.715 | 52.28 | 2698200.0 |
> showing 50 of 1,100 rows — these rows as CSV