PREVIEW / etf_5min / 2007-10-02
file: by_date/etf_5min/2007/2007-10-02.parquet size: 344 KB rows: 18,371
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-10-02 04:50:00 | SPY | ETF | 154.35 | 154.35 | 154.35 | 154.35 | 30000.0 |
| 2007-10-02 05:40:00 | SPY | ETF | 154.3 | 154.3 | 154.3 | 154.3 | 10000.0 |
| 2007-10-02 05:55:00 | SPY | ETF | 154.43 | 154.43 | 154.43 | 154.43 | 10000.0 |
| 2007-10-02 06:00:00 | SPY | ETF | 154.48 | 154.48 | 154.48 | 154.48 | 5000.0 |
| 2007-10-02 06:10:00 | SPY | ETF | 154.44 | 154.44 | 154.44 | 154.44 | 2000.0 |
| 2007-10-02 06:25:00 | SPY | ETF | 154.53 | 154.56 | 154.53 | 154.56 | 5500.0 |
| 2007-10-02 06:30:00 | SPY | ETF | 154.5 | 154.5 | 154.48 | 154.5 | 38000.0 |
| 2007-10-02 06:35:00 | SPY | ETF | 154.5 | 154.5 | 154.5 | 154.5 | 15000.0 |
| 2007-10-02 06:45:00 | SPY | ETF | 154.45 | 154.46 | 154.45 | 154.46 | 24000.0 |
| 2007-10-02 06:50:00 | SPY | ETF | 154.46 | 154.46 | 154.45 | 154.45 | 5000.0 |
| 2007-10-02 06:55:00 | SPY | ETF | 154.53 | 154.6 | 154.53 | 154.6 | 61000.0 |
| 2007-10-02 07:00:00 | SPY | ETF | 154.63 | 154.64 | 154.6 | 154.64 | 91200.0 |
| 2007-10-02 07:05:00 | SPY | ETF | 154.63 | 154.63 | 154.57 | 154.58 | 140300.0 |
| 2007-10-02 07:10:00 | SPY | ETF | 154.61 | 154.61 | 154.56 | 154.58 | 1700.0 |
| 2007-10-02 07:15:00 | SPY | ETF | 154.56 | 154.59 | 154.52 | 154.58 | 10900.0 |
| 2007-10-02 07:20:00 | SPY | ETF | 154.52 | 154.56 | 154.51 | 154.55 | 16500.0 |
| 2007-10-02 07:25:00 | SPY | ETF | 154.57 | 154.57 | 154.56 | 154.56 | 1100.0 |
| 2007-10-02 07:30:00 | SPY | ETF | 154.54 | 154.58 | 154.54 | 154.58 | 10600.0 |
| 2007-10-02 07:35:00 | SPY | ETF | 154.58 | 154.58 | 154.55 | 154.56 | 41600.0 |
| 2007-10-02 07:40:00 | SPY | ETF | 154.56 | 154.56 | 154.53 | 154.53 | 4000.0 |
| 2007-10-02 07:45:00 | SPY | ETF | 154.56 | 154.56 | 154.53 | 154.53 | 2000.0 |
| 2007-10-02 07:50:00 | SPY | ETF | 154.52 | 154.68 | 154.52 | 154.66 | 47800.0 |
| 2007-10-02 07:55:00 | SPY | ETF | 154.68 | 154.68 | 154.64 | 154.64 | 28900.0 |
| 2007-10-02 08:00:00 | SPY | ETF | 154.62 | 154.63 | 154.61 | 154.61 | 17600.0 |
| 2007-10-02 08:05:00 | SPY | ETF | 154.61 | 154.63 | 154.59 | 154.62 | 5200.0 |
| 2007-10-02 08:10:00 | SPY | ETF | 154.62 | 154.62 | 154.54 | 154.56 | 4600.0 |
| 2007-10-02 08:15:00 | SPY | ETF | 154.52 | 154.54 | 154.46 | 154.46 | 32500.0 |
| 2007-10-02 08:20:00 | SPY | ETF | 154.46 | 154.47 | 154.43 | 154.46 | 66100.0 |
| 2007-10-02 08:25:00 | SPY | ETF | 154.47 | 154.47 | 154.43 | 154.43 | 29200.0 |
| 2007-10-02 08:30:00 | SPY | ETF | 154.45 | 154.5 | 154.38 | 154.39 | 130300.0 |
| 2007-10-02 08:35:00 | SPY | ETF | 154.36 | 154.47 | 154.36 | 154.43 | 70300.0 |
| 2007-10-02 08:40:00 | SPY | ETF | 154.42 | 154.54 | 154.39 | 154.53 | 181600.0 |
| 2007-10-02 08:45:00 | SPY | ETF | 154.52 | 154.6 | 154.48 | 154.57 | 97200.0 |
| 2007-10-02 08:50:00 | SPY | ETF | 154.56 | 154.6 | 154.53 | 154.55 | 83500.0 |
| 2007-10-02 08:55:00 | SPY | ETF | 154.55 | 154.62 | 154.54 | 154.57 | 117400.0 |
| 2007-10-02 09:00:00 | SPY | ETF | 154.58 | 154.6 | 154.51 | 154.53 | 45600.0 |
| 2007-10-02 09:05:00 | SPY | ETF | 154.52 | 154.52 | 154.48 | 154.52 | 63600.0 |
| 2007-10-02 09:10:00 | SPY | ETF | 154.55 | 154.55 | 154.5 | 154.5 | 36300.0 |
| 2007-10-02 09:15:00 | SPY | ETF | 154.5 | 154.51 | 154.48 | 154.51 | 13000.0 |
| 2007-10-02 09:20:00 | SPY | ETF | 154.5 | 154.53 | 154.5 | 154.53 | 5600.0 |
| 2007-10-02 09:25:00 | SPY | ETF | 154.51 | 154.61 | 154.5 | 154.6 | 120400.0 |
| 2007-10-02 09:30:00 | SPY | ETF | 154.61 | 154.62 | 154.48 | 154.55 | 1446620.0 |
| 2007-10-02 09:35:00 | SPY | ETF | 154.55 | 154.65 | 154.5 | 154.59 | 2906500.0 |
| 2007-10-02 09:40:00 | SPY | ETF | 154.6 | 154.6274 | 154.46 | 154.49 | 1628500.0 |
| 2007-10-02 09:45:00 | SPY | ETF | 154.49 | 154.49 | 154.36 | 154.39 | 2107800.0 |
| 2007-10-02 09:50:00 | SPY | ETF | 154.39 | 154.45 | 154.36 | 154.42 | 2041700.0 |
| 2007-10-02 09:55:00 | SPY | ETF | 154.41 | 154.46 | 154.3 | 154.33 | 1711600.0 |
| 2007-10-02 10:00:00 | SPY | ETF | 154.325 | 154.5 | 154.19 | 154.38 | 5471600.0 |
| 2007-10-02 10:05:00 | SPY | ETF | 154.37 | 154.44 | 154.25 | 154.41 | 1933700.0 |
| 2007-10-02 10:10:00 | SPY | ETF | 154.41 | 154.52 | 154.39 | 154.5 | 2274400.0 |
> showing 50 of 18,371 rows — these rows as CSV