PREVIEW / etf_30min / 2006-03-30
file: by_date/etf_30min/2006/2006-03-30.parquet size: 61 KB rows: 2,200
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-03-30 06:00:00 | SPY | ETF | 130.05 | 130.05 | 130.05 | 130.05 | 4000.0 |
| 2006-03-30 07:00:00 | SPY | ETF | 130.13 | 130.17 | 130.13 | 130.15 | 30200.0 |
| 2006-03-30 07:30:00 | SPY | ETF | 130.1 | 130.14 | 130.1 | 130.14 | 3100.0 |
| 2006-03-30 08:00:00 | SPY | ETF | 130.14 | 130.29 | 130.14 | 130.2 | 188500.0 |
| 2006-03-30 08:30:00 | SPY | ETF | 130.19 | 130.22 | 129.97 | 130.05 | 192800.0 |
| 2006-03-30 09:00:00 | SPY | ETF | 130.05 | 130.16 | 130.04 | 130.11 | 562900.0 |
| 2006-03-30 09:30:00 | SPY | ETF | 130.11 | 130.74 | 130.04 | 130.66 | 9150600.0 |
| 2006-03-30 10:00:00 | SPY | ETF | 130.66 | 130.98 | 130.61 | 130.64 | 6678800.0 |
| 2006-03-30 10:30:00 | SPY | ETF | 130.64 | 130.68 | 130.17 | 130.25 | 7453200.0 |
| 2006-03-30 11:00:00 | SPY | ETF | 130.27 | 130.27 | 129.81 | 130.12 | 8691000.0 |
| 2006-03-30 11:30:00 | SPY | ETF | 129.905 | 130.34 | 129.905 | 130.18 | 4494300.0 |
| 2006-03-30 12:00:00 | SPY | ETF | 130.17 | 130.33 | 130.15 | 130.29 | 1423400.0 |
| 2006-03-30 12:30:00 | SPY | ETF | 130.28 | 130.29 | 129.87 | 130.08 | 3321500.0 |
| 2006-03-30 13:00:00 | SPY | ETF | 130.09 | 130.1 | 129.69 | 129.81 | 4109200.0 |
| 2006-03-30 13:30:00 | SPY | ETF | 129.8 | 129.87 | 129.55 | 129.8 | 3490200.0 |
| 2006-03-30 14:00:00 | SPY | ETF | 129.8 | 130.15 | 129.79 | 129.97 | 3048200.0 |
| 2006-03-30 14:30:00 | SPY | ETF | 129.93 | 129.97 | 129.79 | 129.84 | 2443200.0 |
| 2006-03-30 15:00:00 | SPY | ETF | 129.84 | 130.16 | 129.82 | 130.09 | 3757100.0 |
| 2006-03-30 15:30:00 | SPY | ETF | 130.08 | 130.17 | 129.91 | 129.95 | 5151000.0 |
| 2006-03-30 16:00:00 | SPY | ETF | 129.96 | 130.0 | 129.7 | 129.76 | 1324800.0 |
| 2006-03-30 16:30:00 | SPY | ETF | 129.8 | 129.81 | 129.77 | 129.8 | 13000.0 |
| 2006-03-30 17:00:00 | SPY | ETF | 129.94 | 129.94 | 129.79 | 129.88 | 277000.0 |
| 2006-03-30 17:30:00 | SPY | ETF | 129.88 | 129.88 | 129.86 | 129.88 | 300.0 |
| 2006-03-30 18:00:00 | SPY | ETF | 129.87 | 129.87 | 129.87 | 129.87 | 500.0 |
| 2006-03-30 18:30:00 | SPY | ETF | 129.87 | 129.87 | 129.87 | 129.87 | 500.0 |
| 2006-03-30 19:00:00 | SPY | ETF | 129.86 | 129.86 | 129.86 | 129.86 | 1000.0 |
| 2006-03-30 09:30:00 | QQQ | ETF | 41.99 | 42.2 | 41.98 | 42.09 | 18531500.0 |
| 2006-03-30 10:00:00 | QQQ | ETF | 42.09 | 42.3 | 42.07 | 42.09 | 14980900.0 |
| 2006-03-30 10:30:00 | QQQ | ETF | 42.09 | 42.1 | 41.9 | 41.94 | 14925000.0 |
| 2006-03-30 11:00:00 | QQQ | ETF | 41.94 | 42.04 | 41.81 | 42.03 | 11067400.0 |
| 2006-03-30 11:30:00 | QQQ | ETF | 42.03 | 42.08 | 41.9 | 41.99 | 6314300.0 |
| 2006-03-30 12:00:00 | QQQ | ETF | 41.98 | 42.08 | 41.98 | 42.06 | 3131200.0 |
| 2006-03-30 12:30:00 | QQQ | ETF | 42.06 | 42.06 | 41.89 | 41.98 | 5219600.0 |
| 2006-03-30 13:00:00 | QQQ | ETF | 41.97 | 41.98 | 41.79 | 41.89 | 6309900.0 |
| 2006-03-30 13:30:00 | QQQ | ETF | 41.89 | 41.98 | 41.8 | 41.94 | 5902000.0 |
| 2006-03-30 14:00:00 | QQQ | ETF | 41.94 | 42.05 | 41.9 | 41.97 | 5971500.0 |
| 2006-03-30 14:30:00 | QQQ | ETF | 41.97 | 42.0 | 41.91 | 41.98 | 2992700.0 |
| 2006-03-30 15:00:00 | QQQ | ETF | 41.98 | 42.07 | 41.96 | 42.02 | 4214800.0 |
| 2006-03-30 15:30:00 | QQQ | ETF | 42.02 | 42.08 | 41.96 | 42.04 | 6261900.0 |
| 2006-03-30 07:00:00 | IWM | ETF | 76.01 | 76.01 | 76.01 | 76.01 | 100.0 |
| 2006-03-30 07:30:00 | IWM | ETF | 76.03 | 76.03 | 76.03 | 76.03 | 100.0 |
| 2006-03-30 08:00:00 | IWM | ETF | 76.03 | 76.04 | 76.03 | 76.04 | 300.0 |
| 2006-03-30 08:30:00 | IWM | ETF | 75.96 | 75.96 | 75.94 | 75.94 | 4000.0 |
| 2006-03-30 09:00:00 | IWM | ETF | 75.97 | 76.04 | 75.94 | 76.0 | 17200.0 |
| 2006-03-30 09:30:00 | IWM | ETF | 76.0 | 76.2 | 75.95 | 76.09 | 3191700.0 |
| 2006-03-30 10:00:00 | IWM | ETF | 76.1 | 76.24 | 75.91 | 75.93 | 1658100.0 |
| 2006-03-30 10:30:00 | IWM | ETF | 75.92 | 75.95 | 75.63 | 75.69 | 4659600.0 |
| 2006-03-30 11:00:00 | IWM | ETF | 75.68 | 75.69 | 75.33 | 75.61 | 2495900.0 |
| 2006-03-30 11:30:00 | IWM | ETF | 75.61 | 75.89 | 75.56 | 75.78 | 1446500.0 |
| 2006-03-30 12:00:00 | IWM | ETF | 75.79 | 75.9 | 75.76 | 75.85 | 1639300.0 |
> showing 50 of 2,200 rows — these rows as CSV