PREVIEW / etf_5min / 2014-06-19
file: by_date/etf_5min/2014/2014-06-19.parquet size: 1001 KB rows: 43,137
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-19 04:10:00 | SPY | ETF | 196.36 | 196.36 | 196.36 | 196.36 | 200.0 |
| 2014-06-19 04:15:00 | SPY | ETF | 196.31 | 196.31 | 196.31 | 196.31 | 710.0 |
| 2014-06-19 04:25:00 | SPY | ETF | 196.31 | 196.31 | 196.31 | 196.31 | 143.0 |
| 2014-06-19 04:40:00 | SPY | ETF | 196.31 | 196.31 | 196.31 | 196.31 | 100.0 |
| 2014-06-19 04:45:00 | SPY | ETF | 196.31 | 196.31 | 196.31 | 196.31 | 167.0 |
| 2014-06-19 05:15:00 | SPY | ETF | 196.53 | 196.53 | 196.53 | 196.53 | 1000.0 |
| 2014-06-19 05:35:00 | SPY | ETF | 196.38 | 196.38 | 196.28 | 196.36 | 1000.0 |
| 2014-06-19 05:40:00 | SPY | ETF | 196.36 | 196.36 | 196.36 | 196.36 | 100.0 |
| 2014-06-19 05:45:00 | SPY | ETF | 196.36 | 196.36 | 196.36 | 196.36 | 100.0 |
| 2014-06-19 05:50:00 | SPY | ETF | 196.36 | 196.36 | 196.36 | 196.36 | 100.0 |
| 2014-06-19 06:05:00 | SPY | ETF | 196.36 | 196.38 | 196.36 | 196.38 | 410.0 |
| 2014-06-19 06:10:00 | SPY | ETF | 196.38 | 196.38 | 196.37 | 196.38 | 2990.0 |
| 2014-06-19 06:15:00 | SPY | ETF | 196.38 | 196.38 | 196.38 | 196.38 | 310.0 |
| 2014-06-19 06:30:00 | SPY | ETF | 196.32 | 196.32 | 196.32 | 196.32 | 400.0 |
| 2014-06-19 06:35:00 | SPY | ETF | 196.28 | 196.28 | 196.24 | 196.24 | 550.0 |
| 2014-06-19 06:40:00 | SPY | ETF | 196.28 | 196.28 | 196.27 | 196.27 | 300.0 |
| 2014-06-19 07:00:00 | SPY | ETF | 196.3 | 196.33 | 196.3 | 196.33 | 3625.0 |
| 2014-06-19 07:10:00 | SPY | ETF | 196.31 | 196.31 | 196.28 | 196.28 | 1750.0 |
| 2014-06-19 07:15:00 | SPY | ETF | 196.26 | 196.3 | 196.26 | 196.26 | 1400.0 |
| 2014-06-19 07:20:00 | SPY | ETF | 196.32 | 196.32 | 196.32 | 196.32 | 400.0 |
| 2014-06-19 07:25:00 | SPY | ETF | 196.31 | 196.31 | 196.31 | 196.31 | 100.0 |
| 2014-06-19 07:30:00 | SPY | ETF | 196.28 | 196.28 | 196.24 | 196.24 | 5129.0 |
| 2014-06-19 07:35:00 | SPY | ETF | 196.26 | 196.26 | 196.26 | 196.26 | 5120.0 |
| 2014-06-19 07:40:00 | SPY | ETF | 196.28 | 196.29 | 196.28 | 196.29 | 1300.0 |
| 2014-06-19 07:45:00 | SPY | ETF | 196.26 | 196.31 | 196.26 | 196.31 | 2250.0 |
| 2014-06-19 07:50:00 | SPY | ETF | 196.28 | 196.29 | 196.28 | 196.28 | 22800.0 |
| 2014-06-19 08:00:00 | SPY | ETF | 196.28 | 196.32 | 196.26 | 196.29 | 78553.0 |
| 2014-06-19 08:05:00 | SPY | ETF | 196.29 | 196.34 | 196.29 | 196.33 | 5040.0 |
| 2014-06-19 08:10:00 | SPY | ETF | 196.32 | 196.35 | 196.31 | 196.31 | 16050.0 |
| 2014-06-19 08:15:00 | SPY | ETF | 196.31 | 196.39 | 196.31 | 196.35 | 73088.0 |
| 2014-06-19 08:20:00 | SPY | ETF | 196.35 | 196.36 | 196.32 | 196.35 | 15700.0 |
| 2014-06-19 08:25:00 | SPY | ETF | 196.38 | 196.48 | 196.36 | 196.4 | 53634.0 |
| 2014-06-19 08:30:00 | SPY | ETF | 196.44 | 196.45 | 196.38 | 196.43 | 147807.0 |
| 2014-06-19 08:35:00 | SPY | ETF | 196.44 | 196.46 | 196.42 | 196.44 | 37811.0 |
| 2014-06-19 08:40:00 | SPY | ETF | 196.44 | 196.45 | 196.38 | 196.44 | 31609.0 |
| 2014-06-19 08:45:00 | SPY | ETF | 196.42 | 196.42 | 196.38 | 196.41 | 15054.0 |
| 2014-06-19 08:50:00 | SPY | ETF | 196.39 | 196.42 | 196.39 | 196.41 | 15485.0 |
| 2014-06-19 08:55:00 | SPY | ETF | 196.41 | 196.44 | 196.4 | 196.4 | 69788.0 |
| 2014-06-19 09:00:00 | SPY | ETF | 196.4 | 196.44 | 196.4 | 196.4 | 14482.0 |
| 2014-06-19 09:05:00 | SPY | ETF | 196.41 | 196.44 | 196.41 | 196.44 | 30022.0 |
| 2014-06-19 09:10:00 | SPY | ETF | 196.44 | 196.44 | 196.41 | 196.41 | 8130.0 |
| 2014-06-19 09:15:00 | SPY | ETF | 196.41 | 196.44 | 196.41 | 196.41 | 18330.0 |
| 2014-06-19 09:20:00 | SPY | ETF | 196.42 | 196.49 | 196.41 | 196.47 | 87782.0 |
| 2014-06-19 09:25:00 | SPY | ETF | 196.47 | 196.47 | 196.4 | 196.43 | 158092.0 |
| 2014-06-19 09:30:00 | SPY | ETF | 196.43 | 196.46 | 196.32 | 196.39 | 2358337.0 |
| 2014-06-19 09:35:00 | SPY | ETF | 196.38 | 196.53 | 196.33 | 196.475 | 1278279.0 |
| 2014-06-19 09:40:00 | SPY | ETF | 196.47 | 196.6 | 196.46 | 196.565 | 991756.0 |
| 2014-06-19 09:45:00 | SPY | ETF | 196.57 | 196.59 | 196.36 | 196.39 | 1119645.0 |
| 2014-06-19 09:50:00 | SPY | ETF | 196.3901 | 196.4074 | 196.33 | 196.36 | 1102643.0 |
| 2014-06-19 09:55:00 | SPY | ETF | 196.38 | 196.38 | 196.275 | 196.32 | 1239371.0 |
> showing 50 of 43,137 rows — these rows as CSV