PREVIEW / etf_30min / 2006-05-15
file: by_date/etf_30min/2006/2006-05-15.parquet size: 68 KB rows: 2,366
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-15 05:30:00 | SPY | ETF | 129.19 | 129.19 | 129.19 | 129.19 | 5000.0 |
| 2006-05-15 06:30:00 | SPY | ETF | 129.0 | 129.29 | 128.96 | 129.05 | 15500.0 |
| 2006-05-15 07:00:00 | SPY | ETF | 129.11 | 129.11 | 128.9 | 128.97 | 110300.0 |
| 2006-05-15 07:30:00 | SPY | ETF | 129.04 | 129.1 | 129.02 | 129.06 | 23000.0 |
| 2006-05-15 08:00:00 | SPY | ETF | 129.04 | 129.35 | 128.8 | 128.97 | 562600.0 |
| 2006-05-15 08:30:00 | SPY | ETF | 128.98 | 129.01 | 128.88 | 128.94 | 424400.0 |
| 2006-05-15 09:00:00 | SPY | ETF | 128.93 | 128.94 | 128.75 | 128.77 | 2756400.0 |
| 2006-05-15 09:30:00 | SPY | ETF | 128.79 | 129.38 | 128.75 | 129.1 | 10403900.0 |
| 2006-05-15 10:00:00 | SPY | ETF | 129.09 | 129.62 | 128.87 | 129.38 | 12750200.0 |
| 2006-05-15 10:30:00 | SPY | ETF | 129.39 | 129.71 | 129.19 | 129.38 | 9234200.0 |
| 2006-05-15 11:00:00 | SPY | ETF | 129.38 | 129.66 | 129.31 | 129.4 | 4566100.0 |
| 2006-05-15 11:30:00 | SPY | ETF | 129.38 | 129.53 | 129.25 | 129.47 | 2263700.0 |
| 2006-05-15 12:00:00 | SPY | ETF | 129.47 | 129.55 | 129.27 | 129.37 | 1514700.0 |
| 2006-05-15 12:30:00 | SPY | ETF | 129.38 | 129.49 | 129.37 | 129.45 | 1251000.0 |
| 2006-05-15 13:00:00 | SPY | ETF | 129.47 | 129.53 | 128.92 | 129.02 | 4689900.0 |
| 2006-05-15 13:30:00 | SPY | ETF | 129.03 | 129.03 | 128.61 | 128.76 | 6887000.0 |
| 2006-05-15 14:00:00 | SPY | ETF | 128.76 | 129.07 | 128.64 | 129.02 | 5386500.0 |
| 2006-05-15 14:30:00 | SPY | ETF | 129.02 | 129.24 | 128.82 | 128.89 | 5940100.0 |
| 2006-05-15 15:00:00 | SPY | ETF | 128.89 | 129.4 | 128.82 | 129.25 | 5575300.0 |
| 2006-05-15 15:30:00 | SPY | ETF | 129.25 | 129.74 | 129.24 | 129.62 | 7518900.0 |
| 2006-05-15 16:00:00 | SPY | ETF | 129.61 | 129.66 | 129.5 | 129.54 | 621900.0 |
| 2006-05-15 16:30:00 | SPY | ETF | 129.54 | 129.54 | 129.47 | 129.53 | 200900.0 |
| 2006-05-15 17:00:00 | SPY | ETF | 129.53 | 129.53 | 129.49 | 129.49 | 81100.0 |
| 2006-05-15 17:30:00 | SPY | ETF | 129.55 | 129.57 | 129.5 | 129.5 | 7100.0 |
| 2006-05-15 18:00:00 | SPY | ETF | 129.49 | 129.55 | 129.49 | 129.55 | 11100.0 |
| 2006-05-15 18:30:00 | SPY | ETF | 129.52 | 129.55 | 129.52 | 129.55 | 1000.0 |
| 2006-05-15 19:00:00 | SPY | ETF | 129.56 | 129.6 | 129.56 | 129.6 | 4900.0 |
| 2006-05-15 19:30:00 | SPY | ETF | 129.56 | 129.58 | 129.55 | 129.55 | 2800.0 |
| 2006-05-15 09:30:00 | QQQ | ETF | 40.03 | 40.34 | 40.02 | 40.16 | 20229000.0 |
| 2006-05-15 10:00:00 | QQQ | ETF | 40.16 | 40.28 | 39.95 | 40.12 | 17715300.0 |
| 2006-05-15 10:30:00 | QQQ | ETF | 40.12 | 40.23 | 40.05 | 40.07 | 8150200.0 |
| 2006-05-15 11:00:00 | QQQ | ETF | 40.06 | 40.22 | 40.05 | 40.11 | 6212500.0 |
| 2006-05-15 11:30:00 | QQQ | ETF | 40.11 | 40.21 | 40.08 | 40.17 | 4602200.0 |
| 2006-05-15 12:00:00 | QQQ | ETF | 40.18 | 40.21 | 40.11 | 40.13 | 2948500.0 |
| 2006-05-15 12:30:00 | QQQ | ETF | 40.14 | 40.18 | 40.12 | 40.14 | 2160600.0 |
| 2006-05-15 13:00:00 | QQQ | ETF | 40.14 | 40.16 | 40.0 | 40.02 | 4120800.0 |
| 2006-05-15 13:30:00 | QQQ | ETF | 40.03 | 40.03 | 39.79 | 39.85 | 10614100.0 |
| 2006-05-15 14:00:00 | QQQ | ETF | 39.86 | 40.0 | 39.82 | 39.99 | 9271900.0 |
| 2006-05-15 14:30:00 | QQQ | ETF | 39.99 | 40.05 | 39.87 | 39.91 | 9087800.0 |
| 2006-05-15 15:00:00 | QQQ | ETF | 39.91 | 40.1 | 39.89 | 40.03 | 9511300.0 |
| 2006-05-15 15:30:00 | QQQ | ETF | 40.03 | 40.23 | 40.02 | 40.18 | 12061800.0 |
| 2006-05-15 08:00:00 | IWM | ETF | 73.23 | 73.25 | 73.01 | 73.1 | 262300.0 |
| 2006-05-15 08:30:00 | IWM | ETF | 73.1 | 73.11 | 72.75 | 72.79 | 896700.0 |
| 2006-05-15 09:00:00 | IWM | ETF | 72.89 | 72.95 | 72.75 | 72.95 | 336800.0 |
| 2006-05-15 09:30:00 | IWM | ETF | 72.94 | 73.67 | 72.35 | 73.12 | 9267100.0 |
| 2006-05-15 10:00:00 | IWM | ETF | 73.13 | 73.5 | 72.8 | 73.33 | 9562300.0 |
| 2006-05-15 10:30:00 | IWM | ETF | 73.3 | 73.71 | 73.22 | 73.33 | 6328000.0 |
| 2006-05-15 11:00:00 | IWM | ETF | 73.32 | 73.61 | 73.27 | 73.38 | 2676000.0 |
| 2006-05-15 11:30:00 | IWM | ETF | 73.38 | 73.49 | 73.22 | 73.44 | 1987300.0 |
| 2006-05-15 12:00:00 | IWM | ETF | 73.44 | 73.51 | 73.29 | 73.38 | 1142400.0 |
> showing 50 of 2,366 rows — these rows as CSV