PREVIEW / etf_5min / 2007-04-27
file: by_date/etf_5min/2007/2007-04-27.parquet size: 291 KB rows: 14,036
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-04-27 06:35:00 | SPY | ETF | 149.42 | 149.42 | 149.42 | 149.42 | 1000.0 |
| 2007-04-27 06:50:00 | SPY | ETF | 149.4 | 149.4 | 149.38 | 149.38 | 2000.0 |
| 2007-04-27 06:55:00 | SPY | ETF | 149.36 | 149.36 | 149.33 | 149.33 | 13000.0 |
| 2007-04-27 07:00:00 | SPY | ETF | 149.37 | 149.37 | 149.35 | 149.35 | 2700.0 |
| 2007-04-27 07:05:00 | SPY | ETF | 149.37 | 149.37 | 149.35 | 149.35 | 40200.0 |
| 2007-04-27 07:10:00 | SPY | ETF | 149.35 | 149.35 | 149.28 | 149.28 | 32600.0 |
| 2007-04-27 07:15:00 | SPY | ETF | 149.3 | 149.32 | 149.29 | 149.3 | 193200.0 |
| 2007-04-27 07:20:00 | SPY | ETF | 149.3 | 149.32 | 149.3 | 149.32 | 89700.0 |
| 2007-04-27 07:25:00 | SPY | ETF | 149.32 | 149.32 | 149.3 | 149.3 | 9400.0 |
| 2007-04-27 07:30:00 | SPY | ETF | 149.28 | 149.28 | 149.28 | 149.28 | 2000.0 |
| 2007-04-27 07:35:00 | SPY | ETF | 149.28 | 149.28 | 149.24 | 149.24 | 29200.0 |
| 2007-04-27 07:40:00 | SPY | ETF | 149.24 | 149.25 | 149.21 | 149.25 | 119300.0 |
| 2007-04-27 07:45:00 | SPY | ETF | 149.3 | 149.32 | 149.3 | 149.32 | 25000.0 |
| 2007-04-27 07:50:00 | SPY | ETF | 149.3 | 149.3 | 149.3 | 149.3 | 50000.0 |
| 2007-04-27 07:55:00 | SPY | ETF | 149.34 | 149.38 | 149.34 | 149.37 | 100600.0 |
| 2007-04-27 08:00:00 | SPY | ETF | 149.37 | 149.37 | 149.3 | 149.36 | 908700.0 |
| 2007-04-27 08:05:00 | SPY | ETF | 149.39 | 149.39 | 149.37 | 149.38 | 13100.0 |
| 2007-04-27 08:10:00 | SPY | ETF | 149.37 | 149.43 | 149.37 | 149.4 | 55200.0 |
| 2007-04-27 08:15:00 | SPY | ETF | 149.39 | 149.41 | 149.39 | 149.4 | 629700.0 |
| 2007-04-27 08:20:00 | SPY | ETF | 149.45 | 149.45 | 149.4 | 149.44 | 131000.0 |
| 2007-04-27 08:25:00 | SPY | ETF | 149.42 | 149.53 | 149.36 | 149.5 | 362700.0 |
| 2007-04-27 08:30:00 | SPY | ETF | 149.4 | 149.45 | 148.91 | 149.04 | 2747000.0 |
| 2007-04-27 08:35:00 | SPY | ETF | 149.02 | 149.13 | 149.0 | 149.08 | 1905500.0 |
| 2007-04-27 08:40:00 | SPY | ETF | 149.08 | 149.16 | 149.0 | 149.05 | 726500.0 |
| 2007-04-27 08:45:00 | SPY | ETF | 149.04 | 149.05 | 148.93 | 148.99 | 1218500.0 |
| 2007-04-27 08:50:00 | SPY | ETF | 149.0 | 149.06 | 148.97 | 149.01 | 422000.0 |
| 2007-04-27 08:55:00 | SPY | ETF | 149.02 | 149.02 | 148.96 | 149.0 | 82400.0 |
| 2007-04-27 09:00:00 | SPY | ETF | 149.02 | 149.08 | 148.99 | 149.08 | 157100.0 |
| 2007-04-27 09:05:00 | SPY | ETF | 149.08 | 149.14 | 149.08 | 149.11 | 259400.0 |
| 2007-04-27 09:10:00 | SPY | ETF | 149.12 | 149.15 | 149.09 | 149.09 | 41000.0 |
| 2007-04-27 09:15:00 | SPY | ETF | 149.11 | 149.13 | 149.11 | 149.11 | 80300.0 |
| 2007-04-27 09:20:00 | SPY | ETF | 149.11 | 149.11 | 149.06 | 149.06 | 119675.0 |
| 2007-04-27 09:25:00 | SPY | ETF | 149.05 | 149.09 | 149.0 | 149.03 | 470800.0 |
| 2007-04-27 09:30:00 | SPY | ETF | 149.03 | 149.23 | 148.97 | 149.16 | 4173349.0 |
| 2007-04-27 09:35:00 | SPY | ETF | 149.16 | 149.18 | 148.99 | 149.03 | 2029900.0 |
| 2007-04-27 09:40:00 | SPY | ETF | 149.03 | 149.18 | 148.96 | 149.16 | 2098250.0 |
| 2007-04-27 09:45:00 | SPY | ETF | 149.17 | 149.22 | 148.9 | 148.94 | 2361779.0 |
| 2007-04-27 09:50:00 | SPY | ETF | 148.95 | 149.08 | 148.94 | 149.05 | 2723150.0 |
| 2007-04-27 09:55:00 | SPY | ETF | 149.05 | 149.11 | 149.01 | 149.11 | 1705212.0 |
| 2007-04-27 10:00:00 | SPY | ETF | 149.11 | 149.31 | 149.1 | 149.21 | 3778800.0 |
| 2007-04-27 10:05:00 | SPY | ETF | 149.2 | 149.41 | 149.2 | 149.31 | 1900440.0 |
| 2007-04-27 10:10:00 | SPY | ETF | 149.31 | 149.34 | 149.2 | 149.23 | 964700.0 |
| 2007-04-27 10:15:00 | SPY | ETF | 149.23 | 149.32 | 149.18 | 149.25 | 1211901.0 |
| 2007-04-27 10:20:00 | SPY | ETF | 149.24 | 149.34 | 149.21 | 149.22 | 896600.0 |
| 2007-04-27 10:25:00 | SPY | ETF | 149.22 | 149.29 | 149.18 | 149.27 | 782800.0 |
| 2007-04-27 10:30:00 | SPY | ETF | 149.27 | 149.34 | 149.05 | 149.12 | 1786600.0 |
| 2007-04-27 10:35:00 | SPY | ETF | 149.12 | 149.13 | 148.98 | 149.05 | 1508671.0 |
| 2007-04-27 10:40:00 | SPY | ETF | 149.05 | 149.13 | 148.94 | 149.01 | 1779106.0 |
| 2007-04-27 10:45:00 | SPY | ETF | 149.01 | 149.02 | 148.84 | 148.99 | 3429805.0 |
| 2007-04-27 10:50:00 | SPY | ETF | 148.99 | 149.06 | 148.95 | 149.04 | 1464701.0 |
> showing 50 of 14,036 rows — these rows as CSV