PREVIEW / etf_5min / 2015-10-16
file: by_date/etf_5min/2015/2015-10-16.parquet size: 1.1 MB rows: 45,772
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-16 04:00:00 | SPY | ETF | 202.66 | 202.66 | 202.54 | 202.54 | 2075.0 |
| 2015-10-16 04:05:00 | SPY | ETF | 202.56 | 202.56 | 202.42 | 202.55 | 2515.0 |
| 2015-10-16 04:25:00 | SPY | ETF | 202.61 | 202.64 | 202.58 | 202.58 | 2025.0 |
| 2015-10-16 04:30:00 | SPY | ETF | 202.58 | 202.58 | 202.58 | 202.58 | 500.0 |
| 2015-10-16 04:35:00 | SPY | ETF | 202.68 | 202.68 | 202.68 | 202.68 | 600.0 |
| 2015-10-16 04:40:00 | SPY | ETF | 202.78 | 202.78 | 202.78 | 202.78 | 125.0 |
| 2015-10-16 04:45:00 | SPY | ETF | 202.8 | 202.8 | 202.74 | 202.74 | 2338.0 |
| 2015-10-16 04:50:00 | SPY | ETF | 202.8 | 202.8 | 202.77 | 202.77 | 3000.0 |
| 2015-10-16 04:55:00 | SPY | ETF | 202.77 | 202.77 | 202.77 | 202.77 | 6250.0 |
| 2015-10-16 05:00:00 | SPY | ETF | 202.65 | 202.69 | 202.65 | 202.69 | 1200.0 |
| 2015-10-16 05:10:00 | SPY | ETF | 202.65 | 202.66 | 202.6 | 202.66 | 1700.0 |
| 2015-10-16 05:15:00 | SPY | ETF | 202.68 | 202.78 | 202.68 | 202.78 | 972.0 |
| 2015-10-16 05:45:00 | SPY | ETF | 202.74 | 202.74 | 202.57 | 202.57 | 1104.0 |
| 2015-10-16 06:00:00 | SPY | ETF | 202.65 | 202.65 | 202.6 | 202.6 | 5700.0 |
| 2015-10-16 06:05:00 | SPY | ETF | 202.57 | 202.57 | 202.55 | 202.56 | 3112.0 |
| 2015-10-16 06:10:00 | SPY | ETF | 202.53 | 202.57 | 202.5 | 202.5 | 5417.0 |
| 2015-10-16 06:15:00 | SPY | ETF | 202.52 | 202.52 | 202.5 | 202.5 | 902.0 |
| 2015-10-16 06:20:00 | SPY | ETF | 202.47 | 202.47 | 202.47 | 202.47 | 1000.0 |
| 2015-10-16 06:25:00 | SPY | ETF | 202.46 | 202.47 | 202.46 | 202.46 | 13193.0 |
| 2015-10-16 06:30:00 | SPY | ETF | 202.42 | 202.44 | 202.32 | 202.32 | 13309.0 |
| 2015-10-16 06:35:00 | SPY | ETF | 202.36 | 202.36 | 202.27 | 202.27 | 20681.0 |
| 2015-10-16 06:40:00 | SPY | ETF | 202.34 | 202.35 | 202.19 | 202.23 | 32974.0 |
| 2015-10-16 06:45:00 | SPY | ETF | 202.22 | 202.31 | 202.22 | 202.31 | 3006.0 |
| 2015-10-16 06:50:00 | SPY | ETF | 202.27 | 202.27 | 202.2 | 202.23 | 12656.0 |
| 2015-10-16 06:55:00 | SPY | ETF | 202.27 | 202.27 | 202.24 | 202.24 | 10625.0 |
| 2015-10-16 07:00:00 | SPY | ETF | 202.27 | 202.29 | 202.08 | 202.08 | 24426.0 |
| 2015-10-16 07:05:00 | SPY | ETF | 202.12 | 202.18 | 202.09 | 202.11 | 19090.0 |
| 2015-10-16 07:10:00 | SPY | ETF | 202.15 | 202.15 | 202.06 | 202.1 | 14589.0 |
| 2015-10-16 07:15:00 | SPY | ETF | 202.09 | 202.17 | 202.09 | 202.1 | 5304.0 |
| 2015-10-16 07:20:00 | SPY | ETF | 202.09 | 202.2 | 202.08 | 202.2 | 13203.0 |
| 2015-10-16 07:25:00 | SPY | ETF | 202.2 | 202.25 | 202.2 | 202.24 | 29835.0 |
| 2015-10-16 07:30:00 | SPY | ETF | 202.21 | 202.23 | 202.18 | 202.23 | 13348.0 |
| 2015-10-16 07:35:00 | SPY | ETF | 202.21 | 202.25 | 202.2 | 202.25 | 5617.0 |
| 2015-10-16 07:40:00 | SPY | ETF | 202.25 | 202.29 | 202.25 | 202.29 | 2806.0 |
| 2015-10-16 07:45:00 | SPY | ETF | 202.31 | 202.31 | 202.27 | 202.29 | 3383.0 |
| 2015-10-16 07:50:00 | SPY | ETF | 202.31 | 202.35 | 202.28 | 202.35 | 9175.0 |
| 2015-10-16 07:55:00 | SPY | ETF | 202.35 | 202.41 | 202.35 | 202.37 | 25894.0 |
| 2015-10-16 08:00:00 | SPY | ETF | 202.35 | 202.67 | 202.24 | 202.67 | 50018.0 |
| 2015-10-16 08:05:00 | SPY | ETF | 202.3 | 202.31 | 202.19 | 202.2 | 34418.0 |
| 2015-10-16 08:10:00 | SPY | ETF | 202.2 | 202.28 | 202.19 | 202.25 | 78071.0 |
| 2015-10-16 08:15:00 | SPY | ETF | 202.24 | 202.32 | 202.24 | 202.32 | 46651.0 |
| 2015-10-16 08:20:00 | SPY | ETF | 202.32 | 202.32 | 202.22 | 202.22 | 21967.0 |
| 2015-10-16 08:25:00 | SPY | ETF | 202.26 | 202.33 | 202.26 | 202.33 | 9282.0 |
| 2015-10-16 08:30:00 | SPY | ETF | 202.32 | 202.42 | 202.32 | 202.41 | 94386.0 |
| 2015-10-16 08:35:00 | SPY | ETF | 202.41 | 202.47 | 202.41 | 202.47 | 56313.0 |
| 2015-10-16 08:40:00 | SPY | ETF | 202.45 | 202.47 | 202.42 | 202.42 | 29760.0 |
| 2015-10-16 08:45:00 | SPY | ETF | 202.44 | 202.44 | 202.36 | 202.36 | 87356.0 |
| 2015-10-16 08:50:00 | SPY | ETF | 202.35 | 202.43 | 202.32 | 202.43 | 18147.0 |
| 2015-10-16 08:55:00 | SPY | ETF | 202.43 | 202.44 | 202.41 | 202.41 | 18374.0 |
| 2015-10-16 09:00:00 | SPY | ETF | 202.43 | 202.54 | 202.43 | 202.48 | 50813.0 |
> showing 50 of 45,772 rows — these rows as CSV