PREVIEW / etf_30min / 2006-10-16
file: by_date/etf_30min/2006/2006-10-16.parquet size: 82 KB rows: 2,995
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-16 07:00:00 | SPY | ETF | 136.68 | 136.68 | 136.68 | 136.68 | 4000.0 |
| 2006-10-16 07:30:00 | SPY | ETF | 136.69 | 136.69 | 136.64 | 136.65 | 9600.0 |
| 2006-10-16 08:00:00 | SPY | ETF | 136.67 | 136.7 | 136.65 | 136.68 | 909200.0 |
| 2006-10-16 08:30:00 | SPY | ETF | 136.67 | 136.71 | 136.51 | 136.51 | 130500.0 |
| 2006-10-16 09:00:00 | SPY | ETF | 136.52 | 136.56 | 136.49 | 136.51 | 361000.0 |
| 2006-10-16 09:30:00 | SPY | ETF | 136.52 | 136.63 | 136.42 | 136.56 | 5201700.0 |
| 2006-10-16 10:00:00 | SPY | ETF | 136.57 | 136.73 | 136.56 | 136.72 | 5182500.0 |
| 2006-10-16 10:30:00 | SPY | ETF | 136.71 | 136.73 | 136.55 | 136.57 | 3133900.0 |
| 2006-10-16 11:00:00 | SPY | ETF | 136.57 | 136.69 | 136.54 | 136.66 | 1931700.0 |
| 2006-10-16 11:30:00 | SPY | ETF | 136.67 | 136.73 | 136.62 | 136.7 | 1273200.0 |
| 2006-10-16 12:00:00 | SPY | ETF | 136.7 | 136.77 | 136.6 | 136.68 | 1387400.0 |
| 2006-10-16 12:30:00 | SPY | ETF | 136.67 | 136.74 | 136.65 | 136.66 | 2622900.0 |
| 2006-10-16 13:00:00 | SPY | ETF | 136.66 | 136.87 | 136.66 | 136.81 | 2731600.0 |
| 2006-10-16 13:30:00 | SPY | ETF | 136.82 | 136.94 | 136.81 | 136.89 | 2155300.0 |
| 2006-10-16 14:00:00 | SPY | ETF | 136.89 | 136.91 | 136.82 | 136.87 | 1811000.0 |
| 2006-10-16 14:30:00 | SPY | ETF | 136.87 | 136.94 | 136.84 | 136.89 | 2021300.0 |
| 2006-10-16 15:00:00 | SPY | ETF | 136.89 | 137.03 | 136.85 | 137.0 | 1698900.0 |
| 2006-10-16 15:30:00 | SPY | ETF | 136.99 | 137.05 | 136.89 | 136.89 | 4751700.0 |
| 2006-10-16 16:00:00 | SPY | ETF | 136.89 | 136.93 | 136.81 | 136.92 | 1340500.0 |
| 2006-10-16 16:30:00 | SPY | ETF | 136.86 | 136.86 | 136.78 | 136.82 | 189900.0 |
| 2006-10-16 17:00:00 | SPY | ETF | 136.8 | 136.82 | 136.74 | 136.77 | 151200.0 |
| 2006-10-16 17:30:00 | SPY | ETF | 136.8 | 136.8 | 136.8 | 136.8 | 1200.0 |
| 2006-10-16 18:00:00 | SPY | ETF | 136.76 | 136.82 | 136.76 | 136.82 | 200.0 |
| 2006-10-16 18:30:00 | SPY | ETF | 136.79 | 136.79 | 136.75 | 136.75 | 50000.0 |
| 2006-10-16 09:30:00 | QQQ | ETF | 42.43 | 42.52 | 42.4 | 42.46 | 7187900.0 |
| 2006-10-16 10:00:00 | QQQ | ETF | 42.45 | 42.59 | 42.44 | 42.54 | 6796000.0 |
| 2006-10-16 10:30:00 | QQQ | ETF | 42.53 | 42.55 | 42.46 | 42.48 | 5771400.0 |
| 2006-10-16 11:00:00 | QQQ | ETF | 42.49 | 42.52 | 42.47 | 42.49 | 2675600.0 |
| 2006-10-16 11:30:00 | QQQ | ETF | 42.49 | 42.52 | 42.46 | 42.49 | 1839400.0 |
| 2006-10-16 12:00:00 | QQQ | ETF | 42.48 | 42.51 | 42.46 | 42.49 | 2947200.0 |
| 2006-10-16 12:30:00 | QQQ | ETF | 42.49 | 42.5 | 42.46 | 42.48 | 1408900.0 |
| 2006-10-16 13:00:00 | QQQ | ETF | 42.49 | 42.56 | 42.47 | 42.51 | 2752100.0 |
| 2006-10-16 13:30:00 | QQQ | ETF | 42.52 | 42.62 | 42.51 | 42.59 | 4994100.0 |
| 2006-10-16 14:00:00 | QQQ | ETF | 42.6 | 42.6 | 42.49 | 42.5 | 2675400.0 |
| 2006-10-16 14:30:00 | QQQ | ETF | 42.5 | 42.55 | 42.47 | 42.47 | 6586900.0 |
| 2006-10-16 15:00:00 | QQQ | ETF | 42.48 | 42.54 | 42.46 | 42.51 | 3628200.0 |
| 2006-10-16 15:30:00 | QQQ | ETF | 42.51 | 42.53 | 42.45 | 42.46 | 7657600.0 |
| 2006-10-16 08:00:00 | IWM | ETF | 76.02 | 76.06 | 76.01 | 76.01 | 6300.0 |
| 2006-10-16 08:30:00 | IWM | ETF | 76.02 | 76.02 | 75.92 | 75.92 | 25400.0 |
| 2006-10-16 09:00:00 | IWM | ETF | 75.9 | 75.9 | 75.82 | 75.88 | 27800.0 |
| 2006-10-16 09:30:00 | IWM | ETF | 75.88 | 76.09 | 75.69 | 76.04 | 5369500.0 |
| 2006-10-16 10:00:00 | IWM | ETF | 76.04 | 76.43 | 76.03 | 76.4 | 6390300.0 |
| 2006-10-16 10:30:00 | IWM | ETF | 76.4 | 76.41 | 76.15 | 76.19 | 2775300.0 |
| 2006-10-16 11:00:00 | IWM | ETF | 76.17 | 76.36 | 76.16 | 76.3394 | 5471700.0 |
| 2006-10-16 11:30:00 | IWM | ETF | 76.33 | 76.42 | 76.26 | 76.35 | 3377600.0 |
| 2006-10-16 12:00:00 | IWM | ETF | 76.3575 | 76.41 | 76.23 | 76.3 | 1279900.0 |
| 2006-10-16 12:30:00 | IWM | ETF | 76.3 | 76.35 | 76.24 | 76.3 | 1409500.0 |
| 2006-10-16 13:00:00 | IWM | ETF | 76.31 | 76.44 | 76.28 | 76.41 | 2061800.0 |
| 2006-10-16 13:30:00 | IWM | ETF | 76.41 | 76.5 | 76.41 | 76.43 | 2992700.0 |
| 2006-10-16 14:00:00 | IWM | ETF | 76.44 | 76.47 | 76.33 | 76.38 | 1687500.0 |
> showing 50 of 2,995 rows — these rows as CSV