PREVIEW / etf_30min / 2006-08-24
file: by_date/etf_30min/2006/2006-08-24.parquet size: 76 KB rows: 2,711
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-08-24 07:00:00 | SPY | ETF | 129.85 | 129.91 | 129.81 | 129.91 | 8000.0 |
| 2006-08-24 07:30:00 | SPY | ETF | 129.91 | 129.94 | 129.83 | 129.84 | 110400.0 |
| 2006-08-24 08:00:00 | SPY | ETF | 129.86 | 129.93 | 129.76 | 129.86 | 757800.0 |
| 2006-08-24 08:30:00 | SPY | ETF | 129.87 | 130.03 | 129.76 | 130.01 | 887500.0 |
| 2006-08-24 09:00:00 | SPY | ETF | 130.0 | 130.07 | 129.94 | 129.98 | 1201600.0 |
| 2006-08-24 09:30:00 | SPY | ETF | 129.99 | 130.1 | 129.57 | 129.94 | 7096900.0 |
| 2006-08-24 10:00:00 | SPY | ETF | 129.94 | 130.0 | 129.73 | 129.83 | 6733500.0 |
| 2006-08-24 10:30:00 | SPY | ETF | 129.84 | 129.87 | 129.6 | 129.77 | 4088400.0 |
| 2006-08-24 11:00:00 | SPY | ETF | 129.76 | 129.89 | 129.67 | 129.76 | 2541700.0 |
| 2006-08-24 11:30:00 | SPY | ETF | 129.78 | 129.78 | 129.58 | 129.63 | 2689100.0 |
| 2006-08-24 12:00:00 | SPY | ETF | 129.62 | 129.62 | 129.4 | 129.49 | 4170000.0 |
| 2006-08-24 12:30:00 | SPY | ETF | 129.48 | 129.57 | 129.4 | 129.57 | 2801200.0 |
| 2006-08-24 13:00:00 | SPY | ETF | 129.56 | 129.72 | 129.46 | 129.69 | 1990500.0 |
| 2006-08-24 13:30:00 | SPY | ETF | 129.69 | 129.74 | 129.52 | 129.64 | 2208300.0 |
| 2006-08-24 14:00:00 | SPY | ETF | 129.63 | 129.95 | 129.62 | 129.82 | 4816100.0 |
| 2006-08-24 14:30:00 | SPY | ETF | 129.82 | 129.95 | 129.75 | 129.93 | 2206200.0 |
| 2006-08-24 15:00:00 | SPY | ETF | 129.92 | 129.93 | 129.64 | 129.77 | 5481200.0 |
| 2006-08-24 15:30:00 | SPY | ETF | 129.77 | 129.92 | 129.72 | 129.86 | 4532700.0 |
| 2006-08-24 16:00:00 | SPY | ETF | 129.87 | 129.886 | 129.62 | 129.68 | 2586500.0 |
| 2006-08-24 16:30:00 | SPY | ETF | 129.68 | 129.78 | 129.6699 | 129.6699 | 257200.0 |
| 2006-08-24 17:00:00 | SPY | ETF | 129.71 | 129.71 | 129.67 | 129.67 | 1000.0 |
| 2006-08-24 17:30:00 | SPY | ETF | 129.71 | 129.71 | 129.71 | 129.71 | 700.0 |
| 2006-08-24 18:00:00 | SPY | ETF | 129.74 | 129.74 | 129.71 | 129.71 | 2400.0 |
| 2006-08-24 18:30:00 | SPY | ETF | 129.72 | 129.72 | 129.72 | 129.72 | 200.0 |
| 2006-08-24 19:00:00 | SPY | ETF | 129.67 | 129.67 | 129.66 | 129.66 | 400.0 |
| 2006-08-24 09:30:00 | QQQ | ETF | 38.26 | 38.35 | 38.21 | 38.25 | 9239700.0 |
| 2006-08-24 10:00:00 | QQQ | ETF | 38.25 | 38.3 | 38.08 | 38.19 | 11860200.0 |
| 2006-08-24 10:30:00 | QQQ | ETF | 38.19 | 38.2 | 38.05 | 38.15 | 7770700.0 |
| 2006-08-24 11:00:00 | QQQ | ETF | 38.15 | 38.19 | 38.09 | 38.12 | 3561500.0 |
| 2006-08-24 11:30:00 | QQQ | ETF | 38.12 | 38.13 | 38.02 | 38.03 | 4418700.0 |
| 2006-08-24 12:00:00 | QQQ | ETF | 38.04 | 38.04 | 37.92 | 37.96 | 7086300.0 |
| 2006-08-24 12:30:00 | QQQ | ETF | 37.95 | 38.05 | 37.94 | 38.02 | 4155400.0 |
| 2006-08-24 13:00:00 | QQQ | ETF | 38.02 | 38.12 | 37.95 | 38.1 | 4544800.0 |
| 2006-08-24 13:30:00 | QQQ | ETF | 38.1 | 38.13 | 38.05 | 38.11 | 3012700.0 |
| 2006-08-24 14:00:00 | QQQ | ETF | 38.11 | 38.27 | 38.09 | 38.18 | 5811600.0 |
| 2006-08-24 14:30:00 | QQQ | ETF | 38.18 | 38.25 | 38.16 | 38.25 | 2683900.0 |
| 2006-08-24 15:00:00 | QQQ | ETF | 38.25 | 38.26 | 38.12 | 38.2 | 4801000.0 |
| 2006-08-24 15:30:00 | QQQ | ETF | 38.19 | 38.27 | 38.15 | 38.26 | 6779800.0 |
| 2006-08-24 08:00:00 | IWM | ETF | 69.6 | 69.64 | 69.58 | 69.62 | 22100.0 |
| 2006-08-24 08:30:00 | IWM | ETF | 69.53 | 69.66 | 69.5 | 69.66 | 139400.0 |
| 2006-08-24 09:00:00 | IWM | ETF | 69.63 | 69.74 | 69.63 | 69.72 | 107000.0 |
| 2006-08-24 09:30:00 | IWM | ETF | 69.72 | 69.87 | 69.61 | 69.81 | 4045300.0 |
| 2006-08-24 10:00:00 | IWM | ETF | 69.8 | 69.8 | 69.41 | 69.43 | 4599600.0 |
| 2006-08-24 10:30:00 | IWM | ETF | 69.43 | 69.43 | 69.14 | 69.32 | 2504500.0 |
| 2006-08-24 11:00:00 | IWM | ETF | 69.31 | 69.44 | 69.2 | 69.24 | 2818300.0 |
| 2006-08-24 11:30:00 | IWM | ETF | 69.23 | 69.29 | 69.07 | 69.14 | 2163500.0 |
| 2006-08-24 12:00:00 | IWM | ETF | 69.13 | 69.14 | 68.91 | 69.01 | 3243400.0 |
| 2006-08-24 12:30:00 | IWM | ETF | 69.0 | 69.1 | 68.96 | 69.07 | 1432900.0 |
| 2006-08-24 13:00:00 | IWM | ETF | 69.07 | 69.33 | 68.98 | 69.28 | 1702100.0 |
| 2006-08-24 13:30:00 | IWM | ETF | 69.28 | 69.43 | 69.2 | 69.38 | 965900.0 |
> showing 50 of 2,711 rows — these rows as CSV