PREVIEW / etf_5min / 2017-02-09
file: by_date/etf_5min/2017/2017-02-09.parquet size: 1.3 MB rows: 54,687
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-09 04:10:00 | SPY | ETF | 229.2 | 229.2 | 229.2 | 229.2 | 300.0 |
| 2017-02-09 04:20:00 | SPY | ETF | 229.27 | 229.27 | 229.27 | 229.27 | 100.0 |
| 2017-02-09 04:25:00 | SPY | ETF | 229.27 | 229.27 | 229.27 | 229.27 | 900.0 |
| 2017-02-09 04:35:00 | SPY | ETF | 229.26 | 229.26 | 229.26 | 229.26 | 500.0 |
| 2017-02-09 05:05:00 | SPY | ETF | 229.24 | 229.24 | 229.24 | 229.24 | 130.0 |
| 2017-02-09 05:20:00 | SPY | ETF | 229.25 | 229.25 | 229.25 | 229.25 | 200.0 |
| 2017-02-09 05:25:00 | SPY | ETF | 229.28 | 229.28 | 229.28 | 229.28 | 100.0 |
| 2017-02-09 05:30:00 | SPY | ETF | 229.35 | 229.35 | 229.33 | 229.33 | 400.0 |
| 2017-02-09 05:35:00 | SPY | ETF | 229.35 | 229.35 | 229.35 | 229.35 | 800.0 |
| 2017-02-09 05:45:00 | SPY | ETF | 229.23 | 229.23 | 229.23 | 229.23 | 2500.0 |
| 2017-02-09 06:10:00 | SPY | ETF | 229.39 | 229.48 | 229.39 | 229.48 | 4460.0 |
| 2017-02-09 06:15:00 | SPY | ETF | 229.49 | 229.58 | 229.49 | 229.55 | 11460.0 |
| 2017-02-09 06:20:00 | SPY | ETF | 229.55 | 229.67 | 229.55 | 229.67 | 6531.0 |
| 2017-02-09 06:25:00 | SPY | ETF | 229.68 | 229.8 | 229.68 | 229.77 | 5844.0 |
| 2017-02-09 06:30:00 | SPY | ETF | 229.77 | 229.8 | 229.76 | 229.76 | 30901.0 |
| 2017-02-09 06:35:00 | SPY | ETF | 229.76 | 229.76 | 229.74 | 229.76 | 3815.0 |
| 2017-02-09 06:40:00 | SPY | ETF | 229.75 | 229.76 | 229.74 | 229.74 | 5001.0 |
| 2017-02-09 06:45:00 | SPY | ETF | 229.75 | 229.78 | 229.73 | 229.75 | 16807.0 |
| 2017-02-09 06:50:00 | SPY | ETF | 229.75 | 229.75 | 229.74 | 229.74 | 9200.0 |
| 2017-02-09 06:55:00 | SPY | ETF | 229.71 | 229.73 | 229.7 | 229.73 | 23701.0 |
| 2017-02-09 07:00:00 | SPY | ETF | 229.7 | 229.71 | 229.68 | 229.71 | 17602.0 |
| 2017-02-09 07:05:00 | SPY | ETF | 229.69 | 229.73 | 229.68 | 229.7 | 1960.0 |
| 2017-02-09 07:10:00 | SPY | ETF | 229.68 | 229.7 | 229.67 | 229.67 | 2302.0 |
| 2017-02-09 07:15:00 | SPY | ETF | 229.67 | 229.69 | 229.66 | 229.66 | 10201.0 |
| 2017-02-09 07:20:00 | SPY | ETF | 229.66 | 229.67 | 229.66 | 229.67 | 4760.0 |
| 2017-02-09 07:25:00 | SPY | ETF | 229.65 | 229.65 | 229.64 | 229.64 | 6501.0 |
| 2017-02-09 07:30:00 | SPY | ETF | 229.64 | 229.67 | 229.64 | 229.67 | 400.0 |
| 2017-02-09 07:35:00 | SPY | ETF | 229.61 | 229.63 | 229.58 | 229.58 | 14480.0 |
| 2017-02-09 07:40:00 | SPY | ETF | 229.58 | 229.58 | 229.52 | 229.55 | 37309.0 |
| 2017-02-09 07:45:00 | SPY | ETF | 229.55 | 229.55 | 229.5 | 229.52 | 13375.0 |
| 2017-02-09 07:50:00 | SPY | ETF | 229.55 | 229.57 | 229.52 | 229.57 | 12006.0 |
| 2017-02-09 07:55:00 | SPY | ETF | 229.57 | 229.62 | 229.55 | 229.62 | 3657.0 |
| 2017-02-09 08:00:00 | SPY | ETF | 229.68 | 229.68 | 229.52 | 229.57 | 23008.0 |
| 2017-02-09 08:05:00 | SPY | ETF | 229.55 | 229.62 | 229.55 | 229.57 | 4152.0 |
| 2017-02-09 08:10:00 | SPY | ETF | 229.56 | 229.57 | 229.44 | 229.45 | 34052.0 |
| 2017-02-09 08:15:00 | SPY | ETF | 229.46 | 229.48 | 229.45 | 229.46 | 12783.0 |
| 2017-02-09 08:20:00 | SPY | ETF | 229.46 | 229.47 | 229.43 | 229.47 | 10001.0 |
| 2017-02-09 08:25:00 | SPY | ETF | 229.5 | 229.5 | 229.48 | 229.5 | 3002.0 |
| 2017-02-09 08:30:00 | SPY | ETF | 229.5 | 229.51 | 229.45 | 229.46 | 23217.0 |
| 2017-02-09 08:35:00 | SPY | ETF | 229.48 | 229.48 | 229.4 | 229.45 | 14752.0 |
| 2017-02-09 08:40:00 | SPY | ETF | 229.46 | 229.46 | 229.38 | 229.38 | 6264.0 |
| 2017-02-09 08:45:00 | SPY | ETF | 229.41 | 229.45 | 229.37 | 229.38 | 16119.0 |
| 2017-02-09 08:50:00 | SPY | ETF | 229.37 | 229.47 | 229.37 | 229.43 | 102740.0 |
| 2017-02-09 08:55:00 | SPY | ETF | 229.43 | 229.46 | 229.39 | 229.45 | 68784.0 |
| 2017-02-09 09:00:00 | SPY | ETF | 229.45 | 229.52 | 229.45 | 229.51 | 44800.0 |
| 2017-02-09 09:05:00 | SPY | ETF | 229.51 | 229.52 | 229.49 | 229.51 | 38254.0 |
| 2017-02-09 09:10:00 | SPY | ETF | 229.51 | 229.52 | 229.45 | 229.45 | 55558.0 |
| 2017-02-09 09:15:00 | SPY | ETF | 229.48 | 229.49 | 229.43 | 229.45 | 7617.0 |
| 2017-02-09 09:20:00 | SPY | ETF | 229.46 | 229.52 | 229.46 | 229.5 | 15245.0 |
| 2017-02-09 09:25:00 | SPY | ETF | 229.49 | 229.55 | 229.46 | 229.55 | 103350.0 |
> showing 50 of 54,687 rows — these rows as CSV