PREVIEW / etf_30min / 2006-05-19
file: by_date/etf_30min/2006/2006-05-19.parquet size: 68 KB rows: 2,370
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-19 06:30:00 | SPY | ETF | 126.75 | 126.75 | 126.72 | 126.73 | 11100.0 |
| 2006-05-19 07:00:00 | SPY | ETF | 126.72 | 126.79 | 126.68 | 126.78 | 41000.0 |
| 2006-05-19 07:30:00 | SPY | ETF | 126.73 | 126.8 | 126.69 | 126.7 | 106600.0 |
| 2006-05-19 08:00:00 | SPY | ETF | 126.69 | 126.78 | 126.67 | 126.72 | 218000.0 |
| 2006-05-19 08:30:00 | SPY | ETF | 126.71 | 126.98 | 126.71 | 126.91 | 626800.0 |
| 2006-05-19 09:00:00 | SPY | ETF | 126.89 | 127.04 | 126.78 | 126.93 | 1814300.0 |
| 2006-05-19 09:30:00 | SPY | ETF | 126.87 | 127.01 | 126.54 | 126.82 | 11932200.0 |
| 2006-05-19 10:00:00 | SPY | ETF | 126.82 | 126.94 | 126.29 | 126.56 | 9389400.0 |
| 2006-05-19 10:30:00 | SPY | ETF | 126.56 | 126.83 | 126.5 | 126.59 | 7396500.0 |
| 2006-05-19 11:00:00 | SPY | ETF | 126.59 | 126.67 | 125.8 | 126.49 | 17444800.0 |
| 2006-05-19 11:30:00 | SPY | ETF | 126.46 | 126.78 | 126.03 | 126.26 | 6391700.0 |
| 2006-05-19 12:00:00 | SPY | ETF | 126.25 | 126.69 | 126.22 | 126.47 | 5030300.0 |
| 2006-05-19 12:30:00 | SPY | ETF | 126.47 | 127.26 | 126.46 | 126.93 | 13297700.0 |
| 2006-05-19 13:00:00 | SPY | ETF | 126.93 | 127.41 | 126.81 | 127.28 | 7159200.0 |
| 2006-05-19 13:30:00 | SPY | ETF | 127.27 | 127.49 | 127.08 | 127.25 | 6165100.0 |
| 2006-05-19 14:00:00 | SPY | ETF | 127.24 | 127.3 | 127.09 | 127.24 | 4818500.0 |
| 2006-05-19 14:30:00 | SPY | ETF | 127.23 | 127.25 | 126.68 | 126.72 | 7145900.0 |
| 2006-05-19 15:00:00 | SPY | ETF | 126.74 | 127.31 | 126.41 | 126.74 | 10443500.0 |
| 2006-05-19 15:30:00 | SPY | ETF | 126.74 | 127.14 | 126.56 | 126.96 | 8795000.0 |
| 2006-05-19 16:00:00 | SPY | ETF | 126.96 | 127.1 | 126.91 | 126.98 | 1007900.0 |
| 2006-05-19 16:30:00 | SPY | ETF | 127.0 | 127.01 | 126.89 | 126.98 | 174400.0 |
| 2006-05-19 17:00:00 | SPY | ETF | 126.98 | 127.01 | 126.96 | 127.01 | 28400.0 |
| 2006-05-19 17:30:00 | SPY | ETF | 127.01 | 127.01 | 126.97 | 127.0 | 4600.0 |
| 2006-05-19 18:00:00 | SPY | ETF | 126.99 | 126.99 | 126.99 | 126.99 | 100.0 |
| 2006-05-19 18:30:00 | SPY | ETF | 127.01 | 127.01 | 127.0 | 127.01 | 30500.0 |
| 2006-05-19 19:00:00 | SPY | ETF | 127.01 | 127.02 | 127.01 | 127.01 | 600.0 |
| 2006-05-19 19:30:00 | SPY | ETF | 127.03 | 127.08 | 127.03 | 127.08 | 4500.0 |
| 2006-05-19 09:30:00 | QQQ | ETF | 39.19 | 39.27 | 39.12 | 39.19 | 25734700.0 |
| 2006-05-19 10:00:00 | QQQ | ETF | 39.19 | 39.21 | 38.81 | 39.11 | 17158200.0 |
| 2006-05-19 10:30:00 | QQQ | ETF | 39.11 | 39.22 | 39.03 | 39.07 | 11276700.0 |
| 2006-05-19 11:00:00 | QQQ | ETF | 39.08 | 39.08 | 38.75 | 39.04 | 21764000.0 |
| 2006-05-19 11:30:00 | QQQ | ETF | 39.04 | 39.08 | 38.87 | 38.95 | 11937700.0 |
| 2006-05-19 12:00:00 | QQQ | ETF | 38.95 | 39.09 | 38.93 | 39.01 | 7632000.0 |
| 2006-05-19 12:30:00 | QQQ | ETF | 39.03 | 39.29 | 39.02 | 39.18 | 13544800.0 |
| 2006-05-19 13:00:00 | QQQ | ETF | 39.19 | 39.39 | 39.13 | 39.34 | 13655700.0 |
| 2006-05-19 13:30:00 | QQQ | ETF | 39.34 | 39.47 | 39.27 | 39.38 | 10686400.0 |
| 2006-05-19 14:00:00 | QQQ | ETF | 39.38 | 39.43 | 39.34 | 39.43 | 5542700.0 |
| 2006-05-19 14:30:00 | QQQ | ETF | 39.43 | 39.44 | 39.13 | 39.15 | 13541500.0 |
| 2006-05-19 15:00:00 | QQQ | ETF | 39.14 | 39.24 | 39.06 | 39.23 | 9499400.0 |
| 2006-05-19 15:30:00 | QQQ | ETF | 39.24 | 39.41 | 39.19 | 39.34 | 18855900.0 |
| 2006-05-19 07:00:00 | IWM | ETF | 71.27 | 71.27 | 71.25 | 71.25 | 5000.0 |
| 2006-05-19 07:30:00 | IWM | ETF | 71.38 | 71.5 | 71.38 | 71.5 | 7800.0 |
| 2006-05-19 08:00:00 | IWM | ETF | 71.62 | 71.62 | 71.4 | 71.48 | 187000.0 |
| 2006-05-19 08:30:00 | IWM | ETF | 71.49 | 71.64 | 71.49 | 71.57 | 274900.0 |
| 2006-05-19 09:00:00 | IWM | ETF | 71.59 | 71.59 | 71.29 | 71.39 | 1509000.0 |
| 2006-05-19 09:30:00 | IWM | ETF | 71.39 | 71.68 | 71.18 | 71.6 | 8124100.0 |
| 2006-05-19 10:00:00 | IWM | ETF | 71.59 | 71.62 | 70.99 | 71.24 | 6023500.0 |
| 2006-05-19 10:30:00 | IWM | ETF | 71.25 | 71.49 | 71.14 | 71.2 | 4087500.0 |
| 2006-05-19 11:00:00 | IWM | ETF | 71.2001 | 71.25 | 70.58 | 71.06 | 5627800.0 |
| 2006-05-19 11:30:00 | IWM | ETF | 71.07 | 71.12 | 70.74 | 70.83 | 3141100.0 |
> showing 50 of 2,370 rows — these rows as CSV