PREVIEW / etf_30min / 2004-08-10
file: by_date/etf_30min/2004/2004-08-10.parquet size: 35 KB rows: 1,155
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-10 08:00:00 | SPY | ETF | 107.23 | 107.3 | 107.2 | 107.29 | 28300.0 |
| 2004-08-10 08:30:00 | SPY | ETF | 107.29 | 107.34 | 107.29 | 107.32 | 36600.0 |
| 2004-08-10 09:00:00 | SPY | ETF | 107.31 | 107.4 | 107.31 | 107.32 | 67300.0 |
| 2004-08-10 09:30:00 | SPY | ETF | 107.31 | 107.47 | 107.26 | 107.36 | 3911000.0 |
| 2004-08-10 10:00:00 | SPY | ETF | 107.35 | 107.55 | 107.33 | 107.55 | 2777000.0 |
| 2004-08-10 10:30:00 | SPY | ETF | 107.52 | 107.78 | 107.5 | 107.77 | 4121600.0 |
| 2004-08-10 11:00:00 | SPY | ETF | 107.77 | 107.84 | 107.71 | 107.8 | 2415200.0 |
| 2004-08-10 11:30:00 | SPY | ETF | 107.81 | 107.9 | 107.74 | 107.75 | 1581600.0 |
| 2004-08-10 12:00:00 | SPY | ETF | 107.77 | 107.82 | 107.7 | 107.75 | 1283700.0 |
| 2004-08-10 12:30:00 | SPY | ETF | 107.77 | 107.83 | 107.7 | 107.82 | 1066900.0 |
| 2004-08-10 13:00:00 | SPY | ETF | 107.81 | 107.85 | 107.71 | 107.78 | 1714900.0 |
| 2004-08-10 13:30:00 | SPY | ETF | 107.78 | 107.86 | 107.74 | 107.8 | 1164500.0 |
| 2004-08-10 14:00:00 | SPY | ETF | 107.81 | 107.9 | 107.45 | 107.45 | 7258100.0 |
| 2004-08-10 14:30:00 | SPY | ETF | 107.5 | 107.95 | 107.35 | 107.84 | 8045500.0 |
| 2004-08-10 15:00:00 | SPY | ETF | 107.83 | 108.27 | 107.77 | 108.08 | 6763000.0 |
| 2004-08-10 15:30:00 | SPY | ETF | 108.07 | 108.4 | 107.95 | 108.37 | 4574900.0 |
| 2004-08-10 16:00:00 | SPY | ETF | 108.36 | 108.43 | 108.13 | 108.16 | 4643300.0 |
| 2004-08-10 16:30:00 | SPY | ETF | 108.15 | 108.38 | 107.93 | 108.02 | 673400.0 |
| 2004-08-10 17:00:00 | SPY | ETF | 108.05 | 108.07 | 107.78 | 107.79 | 750900.0 |
| 2004-08-10 17:30:00 | SPY | ETF | 107.82 | 108.0 | 107.7 | 107.88 | 66000.0 |
| 2004-08-10 18:00:00 | SPY | ETF | 107.9 | 107.95 | 107.9 | 107.92 | 2100.0 |
| 2004-08-10 18:30:00 | SPY | ETF | 107.93 | 107.93 | 107.93 | 107.93 | 800.0 |
| 2004-08-10 19:00:00 | SPY | ETF | 107.93 | 107.93 | 107.92 | 107.92 | 1500.0 |
| 2004-08-10 19:30:00 | SPY | ETF | 107.92 | 107.94 | 107.92 | 107.94 | 500.0 |
| 2004-08-10 08:00:00 | QQQ | ETF | 32.94 | 32.96 | 32.93 | 32.93 | 44500.0 |
| 2004-08-10 08:30:00 | QQQ | ETF | 32.94 | 32.96 | 32.93 | 32.95 | 52700.0 |
| 2004-08-10 09:00:00 | QQQ | ETF | 32.95 | 32.98 | 32.94 | 32.96 | 162800.0 |
| 2004-08-10 09:30:00 | QQQ | ETF | 32.96 | 33.02 | 32.93 | 32.97 | 8922500.0 |
| 2004-08-10 10:00:00 | QQQ | ETF | 32.96 | 33.03 | 32.922 | 33.01 | 5196400.0 |
| 2004-08-10 10:30:00 | QQQ | ETF | 33.01 | 33.145 | 33.009 | 33.14 | 7934600.0 |
| 2004-08-10 11:00:00 | QQQ | ETF | 33.138 | 33.17 | 33.09 | 33.14 | 6106500.0 |
| 2004-08-10 11:30:00 | QQQ | ETF | 33.148 | 33.22 | 33.134 | 33.17 | 4487900.0 |
| 2004-08-10 12:00:00 | QQQ | ETF | 33.17 | 33.21 | 33.13 | 33.16 | 3187100.0 |
| 2004-08-10 12:30:00 | QQQ | ETF | 33.15 | 33.2 | 33.14 | 33.19 | 2211900.0 |
| 2004-08-10 13:00:00 | QQQ | ETF | 33.19 | 33.22 | 33.14 | 33.17 | 1990600.0 |
| 2004-08-10 13:30:00 | QQQ | ETF | 33.171 | 33.2 | 33.155 | 33.19 | 1479100.0 |
| 2004-08-10 14:00:00 | QQQ | ETF | 33.18 | 33.21 | 33.02 | 33.02 | 12385900.0 |
| 2004-08-10 14:30:00 | QQQ | ETF | 33.02 | 33.2 | 32.97 | 33.14 | 11733700.0 |
| 2004-08-10 15:00:00 | QQQ | ETF | 33.15 | 33.41 | 33.12 | 33.33 | 12676000.0 |
| 2004-08-10 15:30:00 | QQQ | ETF | 33.322 | 33.43 | 33.26 | 33.42 | 10577400.0 |
| 2004-08-10 16:00:00 | QQQ | ETF | 33.414 | 33.47 | 33.18 | 33.21 | 9984700.0 |
| 2004-08-10 16:30:00 | QQQ | ETF | 33.21 | 33.22 | 33.061 | 33.12 | 1885400.0 |
| 2004-08-10 17:00:00 | QQQ | ETF | 33.13 | 33.13 | 32.94 | 32.98 | 2344300.0 |
| 2004-08-10 17:30:00 | QQQ | ETF | 32.98 | 33.02 | 32.93 | 33.0 | 526600.0 |
| 2004-08-10 18:00:00 | QQQ | ETF | 33.02 | 33.05 | 33.0 | 33.01 | 83000.0 |
| 2004-08-10 18:30:00 | QQQ | ETF | 33.0 | 33.02 | 33.0 | 33.02 | 5500.0 |
| 2004-08-10 19:00:00 | QQQ | ETF | 33.03 | 33.03 | 33.01 | 33.02 | 9300.0 |
| 2004-08-10 19:30:00 | QQQ | ETF | 33.03 | 33.04 | 33.02 | 33.03 | 23300.0 |
| 2004-08-10 08:30:00 | IWM | ETF | 51.83 | 51.83 | 51.83 | 51.83 | 3000.0 |
| 2004-08-10 09:00:00 | IWM | ETF | 51.83 | 51.83 | 51.83 | 51.83 | 6800.0 |
> showing 50 of 1,155 rows — these rows as CSV