PREVIEW / etf_30min / 2007-02-05
file: by_date/etf_30min/2007/2007-02-05.parquet size: 95 KB rows: 3,421
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-05 04:00:00 | SPY | ETF | 144.65 | 144.65 | 144.65 | 144.65 | 15000.0 |
| 2007-02-05 04:30:00 | SPY | ETF | 144.65 | 144.67 | 144.65 | 144.67 | 14900.0 |
| 2007-02-05 06:00:00 | SPY | ETF | 144.63 | 144.65 | 144.63 | 144.65 | 8500.0 |
| 2007-02-05 06:30:00 | SPY | ETF | 144.62 | 144.62 | 144.62 | 144.62 | 7500.0 |
| 2007-02-05 07:00:00 | SPY | ETF | 144.6 | 144.61 | 144.56 | 144.61 | 2900.0 |
| 2007-02-05 07:30:00 | SPY | ETF | 144.57 | 144.61 | 144.54 | 144.54 | 52600.0 |
| 2007-02-05 08:00:00 | SPY | ETF | 144.55 | 144.67 | 144.51 | 144.66 | 235000.0 |
| 2007-02-05 08:30:00 | SPY | ETF | 144.63 | 144.68 | 144.62 | 144.68 | 57700.0 |
| 2007-02-05 09:00:00 | SPY | ETF | 144.67 | 144.73 | 144.64 | 144.69 | 252800.0 |
| 2007-02-05 09:30:00 | SPY | ETF | 144.7 | 144.8 | 144.47 | 144.54 | 7062700.0 |
| 2007-02-05 10:00:00 | SPY | ETF | 144.53 | 144.69 | 144.34 | 144.54 | 5738800.0 |
| 2007-02-05 10:30:00 | SPY | ETF | 144.54 | 144.79 | 144.53 | 144.68 | 4520300.0 |
| 2007-02-05 11:00:00 | SPY | ETF | 144.68 | 144.68 | 144.57 | 144.6599 | 3033600.0 |
| 2007-02-05 11:30:00 | SPY | ETF | 144.66 | 144.74 | 144.62 | 144.66 | 2285600.0 |
| 2007-02-05 12:00:00 | SPY | ETF | 144.66 | 144.68 | 144.59 | 144.66 | 920300.0 |
| 2007-02-05 12:30:00 | SPY | ETF | 144.66 | 144.73 | 144.64 | 144.72 | 1050400.0 |
| 2007-02-05 13:00:00 | SPY | ETF | 144.73 | 144.82 | 144.63 | 144.63 | 2925100.0 |
| 2007-02-05 13:30:00 | SPY | ETF | 144.63 | 144.73 | 144.63 | 144.72 | 1686200.0 |
| 2007-02-05 14:00:00 | SPY | ETF | 144.71 | 144.86 | 144.71 | 144.8 | 2080500.0 |
| 2007-02-05 14:30:00 | SPY | ETF | 144.8 | 144.94 | 144.76 | 144.8899 | 2137800.0 |
| 2007-02-05 15:00:00 | SPY | ETF | 144.88 | 144.88 | 144.73 | 144.78 | 2039300.0 |
| 2007-02-05 15:30:00 | SPY | ETF | 144.77 | 144.8 | 144.63 | 144.69 | 2872800.0 |
| 2007-02-05 16:00:00 | SPY | ETF | 144.68 | 144.9 | 144.68 | 144.85 | 1206700.0 |
| 2007-02-05 16:30:00 | SPY | ETF | 144.84 | 144.87 | 144.78 | 144.84 | 1173700.0 |
| 2007-02-05 17:00:00 | SPY | ETF | 144.85 | 144.89 | 144.85 | 144.88 | 179400.0 |
| 2007-02-05 17:30:00 | SPY | ETF | 144.87 | 144.89 | 144.87 | 144.88 | 2939100.0 |
| 2007-02-05 18:00:00 | SPY | ETF | 144.88 | 144.88 | 144.84 | 144.84 | 2800.0 |
| 2007-02-05 18:30:00 | SPY | ETF | 144.87 | 144.88 | 144.84 | 144.84 | 39100.0 |
| 2007-02-05 19:00:00 | SPY | ETF | 144.82 | 144.82 | 144.82 | 144.82 | 1000.0 |
| 2007-02-05 04:00:00 | QQQ | ETF | 44.14 | 44.14 | 44.14 | 44.14 | 1200.0 |
| 2007-02-05 07:00:00 | QQQ | ETF | 44.12 | 44.15 | 44.12 | 44.15 | 300.0 |
| 2007-02-05 07:30:00 | QQQ | ETF | 44.1 | 44.11 | 44.07 | 44.08 | 33800.0 |
| 2007-02-05 08:00:00 | QQQ | ETF | 44.09 | 44.12 | 44.08 | 44.12 | 45535.0 |
| 2007-02-05 08:30:00 | QQQ | ETF | 44.12 | 44.16 | 44.12 | 44.16 | 234011.0 |
| 2007-02-05 09:00:00 | QQQ | ETF | 44.17 | 44.19 | 44.14 | 44.14 | 85551.0 |
| 2007-02-05 09:30:00 | QQQ | ETF | 44.14 | 44.36 | 44.1 | 44.15 | 14174800.0 |
| 2007-02-05 10:00:00 | QQQ | ETF | 44.15 | 44.18 | 43.96 | 44.1 | 15270100.0 |
| 2007-02-05 10:30:00 | QQQ | ETF | 44.1 | 44.24 | 44.07 | 44.13 | 9147900.0 |
| 2007-02-05 11:00:00 | QQQ | ETF | 44.13 | 44.15 | 44.06 | 44.12 | 4985100.0 |
| 2007-02-05 11:30:00 | QQQ | ETF | 44.11 | 44.19 | 44.08 | 44.16 | 7212800.0 |
| 2007-02-05 12:00:00 | QQQ | ETF | 44.17 | 44.17 | 44.14 | 44.17 | 1865300.0 |
| 2007-02-05 12:30:00 | QQQ | ETF | 44.16 | 44.21 | 44.16 | 44.21 | 2625200.0 |
| 2007-02-05 13:00:00 | QQQ | ETF | 44.21 | 44.24 | 44.14 | 44.15 | 6280600.0 |
| 2007-02-05 13:30:00 | QQQ | ETF | 44.15 | 44.18 | 44.12 | 44.17 | 3947900.0 |
| 2007-02-05 14:00:00 | QQQ | ETF | 44.17 | 44.23 | 44.16 | 44.2 | 3635700.0 |
| 2007-02-05 14:30:00 | QQQ | ETF | 44.2 | 44.27 | 44.15 | 44.24 | 4222500.0 |
| 2007-02-05 15:00:00 | QQQ | ETF | 44.24 | 44.25 | 44.14 | 44.17 | 5211200.0 |
| 2007-02-05 15:30:00 | QQQ | ETF | 44.17 | 44.19 | 44.12 | 44.13 | 9285300.0 |
| 2007-02-05 16:00:00 | QQQ | ETF | 44.12 | 44.18 | 44.1 | 44.13 | 2309510.0 |
| 2007-02-05 16:30:00 | QQQ | ETF | 44.13 | 44.14 | 44.11 | 44.13 | 500326.0 |
> showing 50 of 3,421 rows — these rows as CSV