PREVIEW / etf_30min / 2006-02-15
file: by_date/etf_30min/2006/2006-02-15.parquet size: 60 KB rows: 2,134
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-02-15 07:00:00 | SPY | ETF | 127.6 | 127.6 | 127.58 | 127.59 | 18100.0 |
| 2006-02-15 07:30:00 | SPY | ETF | 127.59 | 127.66 | 127.59 | 127.6 | 51400.0 |
| 2006-02-15 08:00:00 | SPY | ETF | 127.6 | 127.64 | 127.59 | 127.63 | 84700.0 |
| 2006-02-15 08:30:00 | SPY | ETF | 127.64 | 127.8 | 127.6 | 127.74 | 513200.0 |
| 2006-02-15 09:00:00 | SPY | ETF | 127.71 | 127.73 | 127.61 | 127.69 | 89300.0 |
| 2006-02-15 09:30:00 | SPY | ETF | 127.66 | 127.7 | 127.5 | 127.69 | 4620300.0 |
| 2006-02-15 10:00:00 | SPY | ETF | 127.69 | 128.32 | 127.46 | 128.12 | 17358400.0 |
| 2006-02-15 10:30:00 | SPY | ETF | 128.12 | 128.2 | 127.87 | 127.94 | 4747100.0 |
| 2006-02-15 11:00:00 | SPY | ETF | 127.94 | 127.95 | 127.52 | 127.6 | 10014400.0 |
| 2006-02-15 11:30:00 | SPY | ETF | 127.6 | 127.87 | 127.52 | 127.84 | 3331800.0 |
| 2006-02-15 12:00:00 | SPY | ETF | 127.83 | 127.85 | 127.52 | 127.53 | 2768700.0 |
| 2006-02-15 12:30:00 | SPY | ETF | 127.54 | 127.62 | 127.24 | 127.53 | 6787500.0 |
| 2006-02-15 13:00:00 | SPY | ETF | 127.52 | 127.78 | 127.51 | 127.68 | 4787200.0 |
| 2006-02-15 13:30:00 | SPY | ETF | 127.67 | 128.05 | 127.63 | 127.9788 | 3585200.0 |
| 2006-02-15 14:00:00 | SPY | ETF | 127.97 | 128.11 | 127.75 | 128.09 | 3865100.0 |
| 2006-02-15 14:30:00 | SPY | ETF | 128.1 | 128.19 | 127.96 | 128.16 | 4045000.0 |
| 2006-02-15 15:00:00 | SPY | ETF | 128.16 | 128.17 | 127.85 | 127.97 | 6290300.0 |
| 2006-02-15 15:30:00 | SPY | ETF | 127.97 | 128.18 | 127.97 | 128.14 | 5364100.0 |
| 2006-02-15 16:00:00 | SPY | ETF | 128.14 | 128.23 | 128.06 | 128.2 | 751100.0 |
| 2006-02-15 16:30:00 | SPY | ETF | 128.2 | 128.26 | 128.18 | 128.2 | 2139600.0 |
| 2006-02-15 17:00:00 | SPY | ETF | 128.23 | 128.24 | 128.13 | 128.14 | 101100.0 |
| 2006-02-15 17:30:00 | SPY | ETF | 128.15 | 128.23 | 128.15 | 128.23 | 1100.0 |
| 2006-02-15 18:00:00 | SPY | ETF | 128.15 | 128.17 | 128.15 | 128.17 | 2000.0 |
| 2006-02-15 18:30:00 | SPY | ETF | 128.18 | 128.18 | 128.18 | 128.18 | 200.0 |
| 2006-02-15 09:30:00 | QQQ | ETF | 40.79 | 40.9 | 40.73 | 40.9 | 6791400.0 |
| 2006-02-15 10:00:00 | QQQ | ETF | 40.89 | 41.26 | 40.79 | 41.16 | 16559700.0 |
| 2006-02-15 10:30:00 | QQQ | ETF | 41.16 | 41.2 | 41.08 | 41.09 | 5406200.0 |
| 2006-02-15 11:00:00 | QQQ | ETF | 41.08 | 41.09 | 40.89 | 40.9 | 10965400.0 |
| 2006-02-15 11:30:00 | QQQ | ETF | 40.9 | 41.0 | 40.83 | 40.98 | 5970200.0 |
| 2006-02-15 12:00:00 | QQQ | ETF | 40.97 | 40.98 | 40.88 | 40.9 | 2480800.0 |
| 2006-02-15 12:30:00 | QQQ | ETF | 40.9 | 40.91 | 40.77 | 40.88 | 7124700.0 |
| 2006-02-15 13:00:00 | QQQ | ETF | 40.88 | 41.02 | 40.88 | 40.96 | 4653600.0 |
| 2006-02-15 13:30:00 | QQQ | ETF | 40.97 | 41.11 | 40.94 | 41.09 | 3484600.0 |
| 2006-02-15 14:00:00 | QQQ | ETF | 41.08 | 41.15 | 41.01 | 41.14 | 3244000.0 |
| 2006-02-15 14:30:00 | QQQ | ETF | 41.13 | 41.2 | 41.1 | 41.19 | 5511500.0 |
| 2006-02-15 15:00:00 | QQQ | ETF | 41.19 | 41.19 | 41.04 | 41.06 | 5552100.0 |
| 2006-02-15 15:30:00 | QQQ | ETF | 41.06 | 41.16 | 41.06 | 41.15 | 4516400.0 |
| 2006-02-15 08:00:00 | IWM | ETF | 71.49 | 71.49 | 71.47 | 71.47 | 4100.0 |
| 2006-02-15 08:30:00 | IWM | ETF | 71.48 | 71.54 | 71.48 | 71.52 | 5000.0 |
| 2006-02-15 09:00:00 | IWM | ETF | 71.52 | 71.53 | 71.5 | 71.52 | 31800.0 |
| 2006-02-15 09:30:00 | IWM | ETF | 71.51 | 71.51 | 71.18 | 71.46 | 2755300.0 |
| 2006-02-15 10:00:00 | IWM | ETF | 71.46 | 72.13 | 71.31 | 72.03 | 10778700.0 |
| 2006-02-15 10:30:00 | IWM | ETF | 72.03 | 72.13 | 71.91 | 72.01 | 4189300.0 |
| 2006-02-15 11:00:00 | IWM | ETF | 72.02 | 72.07 | 71.7 | 71.71 | 3750500.0 |
| 2006-02-15 11:30:00 | IWM | ETF | 71.72 | 71.9 | 71.69 | 71.86 | 1726200.0 |
| 2006-02-15 12:00:00 | IWM | ETF | 71.85 | 71.86 | 71.62 | 71.65 | 1503100.0 |
| 2006-02-15 12:30:00 | IWM | ETF | 71.65 | 71.67 | 71.45 | 71.64 | 2712800.0 |
| 2006-02-15 13:00:00 | IWM | ETF | 71.63 | 71.78 | 71.6 | 71.75 | 2164900.0 |
| 2006-02-15 13:30:00 | IWM | ETF | 71.75 | 71.96 | 71.72 | 71.93 | 1200600.0 |
| 2006-02-15 14:00:00 | IWM | ETF | 71.94 | 72.04 | 71.82 | 72.03 | 1766300.0 |
> showing 50 of 2,134 rows — these rows as CSV