PREVIEW / etf_30min / 2006-10-09
file: by_date/etf_30min/2006/2006-10-09.parquet size: 81 KB rows: 2,908
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-10-09 06:00:00 | SPY | ETF | 134.82 | 134.82 | 134.82 | 134.82 | 25000.0 |
| 2006-10-09 06:30:00 | SPY | ETF | 134.81 | 134.81 | 134.81 | 134.81 | 1000.0 |
| 2006-10-09 07:00:00 | SPY | ETF | 134.9 | 134.9 | 134.72 | 134.75 | 18700.0 |
| 2006-10-09 07:30:00 | SPY | ETF | 134.75 | 134.78 | 134.7 | 134.71 | 136000.0 |
| 2006-10-09 08:00:00 | SPY | ETF | 134.7 | 134.79 | 134.61 | 134.74 | 145300.0 |
| 2006-10-09 08:30:00 | SPY | ETF | 134.74 | 134.81 | 134.72 | 134.81 | 212300.0 |
| 2006-10-09 09:00:00 | SPY | ETF | 134.82 | 134.9 | 134.77 | 134.88 | 289200.0 |
| 2006-10-09 09:30:00 | SPY | ETF | 134.85 | 135.0 | 134.78 | 134.89 | 3724600.0 |
| 2006-10-09 10:00:00 | SPY | ETF | 134.89 | 134.98 | 134.77 | 134.78 | 1509100.0 |
| 2006-10-09 10:30:00 | SPY | ETF | 134.77 | 134.91 | 134.64 | 134.86 | 5632800.0 |
| 2006-10-09 11:00:00 | SPY | ETF | 134.85 | 134.96 | 134.77 | 134.95 | 3228000.0 |
| 2006-10-09 11:30:00 | SPY | ETF | 134.94 | 135.08 | 134.88 | 134.95 | 4399900.0 |
| 2006-10-09 12:00:00 | SPY | ETF | 134.95 | 135.09 | 134.95 | 134.98 | 1037900.0 |
| 2006-10-09 12:30:00 | SPY | ETF | 134.99 | 135.1 | 134.97 | 134.99 | 2590100.0 |
| 2006-10-09 13:00:00 | SPY | ETF | 134.99 | 135.22 | 134.9591 | 135.17 | 3226700.0 |
| 2006-10-09 13:30:00 | SPY | ETF | 135.1709 | 135.2 | 135.01 | 135.02 | 1471500.0 |
| 2006-10-09 14:00:00 | SPY | ETF | 135.02 | 135.27 | 135.0 | 135.23 | 1861500.0 |
| 2006-10-09 14:30:00 | SPY | ETF | 135.23 | 135.3 | 135.11 | 135.2 | 2142100.0 |
| 2006-10-09 15:00:00 | SPY | ETF | 135.2 | 135.24 | 134.95 | 134.98 | 3034000.0 |
| 2006-10-09 15:30:00 | SPY | ETF | 134.98 | 135.16 | 134.97 | 135.06 | 3101800.0 |
| 2006-10-09 16:00:00 | SPY | ETF | 135.05 | 135.12 | 135.01 | 135.1 | 641000.0 |
| 2006-10-09 16:30:00 | SPY | ETF | 135.1 | 135.12 | 135.06 | 135.09 | 135700.0 |
| 2006-10-09 17:00:00 | SPY | ETF | 135.1 | 135.11 | 135.1 | 135.11 | 68400.0 |
| 2006-10-09 17:30:00 | SPY | ETF | 135.06 | 135.06 | 135.03 | 135.03 | 4900.0 |
| 2006-10-09 18:00:00 | SPY | ETF | 135.1 | 135.1 | 135.07 | 135.07 | 500.0 |
| 2006-10-09 18:30:00 | SPY | ETF | 135.02 | 135.02 | 135.01 | 135.01 | 600.0 |
| 2006-10-09 09:30:00 | QQQ | ETF | 41.37 | 41.47 | 41.32 | 41.45 | 7467100.0 |
| 2006-10-09 10:00:00 | QQQ | ETF | 41.46 | 41.48 | 41.39 | 41.39 | 4400800.0 |
| 2006-10-09 10:30:00 | QQQ | ETF | 41.39 | 41.46 | 41.33 | 41.46 | 4342900.0 |
| 2006-10-09 11:00:00 | QQQ | ETF | 41.46 | 41.56 | 41.4 | 41.54 | 4631100.0 |
| 2006-10-09 11:30:00 | QQQ | ETF | 41.53 | 41.65 | 41.52 | 41.58 | 7357900.0 |
| 2006-10-09 12:00:00 | QQQ | ETF | 41.59 | 41.63 | 41.56 | 41.57 | 1855800.0 |
| 2006-10-09 12:30:00 | QQQ | ETF | 41.58 | 41.65 | 41.57 | 41.6 | 2370000.0 |
| 2006-10-09 13:00:00 | QQQ | ETF | 41.59 | 41.71 | 41.58 | 41.69 | 4072600.0 |
| 2006-10-09 13:30:00 | QQQ | ETF | 41.69 | 41.7 | 41.59 | 41.61 | 2272400.0 |
| 2006-10-09 14:00:00 | QQQ | ETF | 41.6 | 41.72 | 41.6 | 41.71 | 2335300.0 |
| 2006-10-09 14:30:00 | QQQ | ETF | 41.7 | 41.74 | 41.66 | 41.69 | 3828400.0 |
| 2006-10-09 15:00:00 | QQQ | ETF | 41.69 | 41.7 | 41.52 | 41.54 | 7870400.0 |
| 2006-10-09 15:30:00 | QQQ | ETF | 41.55 | 41.61 | 41.53 | 41.54 | 4954000.0 |
| 2006-10-09 07:00:00 | IWM | ETF | 73.5 | 73.5 | 73.5 | 73.5 | 100.0 |
| 2006-10-09 07:30:00 | IWM | ETF | 73.3 | 73.3 | 73.3 | 73.3 | 100.0 |
| 2006-10-09 08:00:00 | IWM | ETF | 73.5 | 73.5 | 73.28 | 73.28 | 40800.0 |
| 2006-10-09 08:30:00 | IWM | ETF | 73.25 | 73.28 | 73.22 | 73.27 | 27500.0 |
| 2006-10-09 09:00:00 | IWM | ETF | 73.3 | 73.36 | 73.28 | 73.36 | 79000.0 |
| 2006-10-09 09:30:00 | IWM | ETF | 73.36 | 73.46 | 73.11 | 73.28 | 2512800.0 |
| 2006-10-09 10:00:00 | IWM | ETF | 73.27 | 73.31 | 73.17 | 73.22 | 1195100.0 |
| 2006-10-09 10:30:00 | IWM | ETF | 73.22 | 73.4 | 73.06 | 73.36 | 1310400.0 |
| 2006-10-09 11:00:00 | IWM | ETF | 73.35 | 73.49 | 73.27 | 73.48 | 3149100.0 |
| 2006-10-09 11:30:00 | IWM | ETF | 73.46 | 73.78 | 73.41 | 73.63 | 2603600.0 |
| 2006-10-09 12:00:00 | IWM | ETF | 73.63 | 73.72 | 73.59 | 73.65 | 1015200.0 |
> showing 50 of 2,908 rows — these rows as CSV