PREVIEW / etf_5min / 2015-10-12
file: by_date/etf_5min/2015/2015-10-12.parquet size: 1024 KB rows: 43,598
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-12 04:00:00 | SPY | ETF | 201.52 | 201.6 | 201.52 | 201.6 | 301.0 |
| 2015-10-12 04:10:00 | SPY | ETF | 201.55 | 201.55 | 201.55 | 201.55 | 100.0 |
| 2015-10-12 04:20:00 | SPY | ETF | 201.52 | 201.52 | 201.52 | 201.52 | 2000.0 |
| 2015-10-12 04:30:00 | SPY | ETF | 201.51 | 201.51 | 201.51 | 201.51 | 500.0 |
| 2015-10-12 04:35:00 | SPY | ETF | 201.47 | 201.47 | 201.44 | 201.44 | 1100.0 |
| 2015-10-12 04:45:00 | SPY | ETF | 201.4 | 201.4 | 201.4 | 201.4 | 500.0 |
| 2015-10-12 04:50:00 | SPY | ETF | 201.35 | 201.35 | 201.3 | 201.3 | 802.0 |
| 2015-10-12 05:00:00 | SPY | ETF | 201.32 | 201.33 | 201.32 | 201.33 | 3710.0 |
| 2015-10-12 05:10:00 | SPY | ETF | 201.35 | 201.35 | 201.2 | 201.2 | 900.0 |
| 2015-10-12 05:15:00 | SPY | ETF | 201.2 | 201.2 | 201.15 | 201.16 | 1572.0 |
| 2015-10-12 05:20:00 | SPY | ETF | 201.21 | 201.25 | 201.21 | 201.25 | 1400.0 |
| 2015-10-12 05:25:00 | SPY | ETF | 201.32 | 201.32 | 201.32 | 201.32 | 900.0 |
| 2015-10-12 05:35:00 | SPY | ETF | 201.27 | 201.32 | 201.27 | 201.32 | 1337.0 |
| 2015-10-12 05:45:00 | SPY | ETF | 201.28 | 201.31 | 201.28 | 201.3 | 1170.0 |
| 2015-10-12 05:55:00 | SPY | ETF | 201.34 | 201.37 | 201.34 | 201.37 | 4100.0 |
| 2015-10-12 06:00:00 | SPY | ETF | 201.39 | 201.43 | 201.36 | 201.43 | 4221.0 |
| 2015-10-12 06:05:00 | SPY | ETF | 201.36 | 201.36 | 201.36 | 201.36 | 1501.0 |
| 2015-10-12 06:10:00 | SPY | ETF | 201.36 | 201.36 | 201.36 | 201.36 | 2199.0 |
| 2015-10-12 06:15:00 | SPY | ETF | 201.34 | 201.34 | 201.34 | 201.34 | 100.0 |
| 2015-10-12 06:20:00 | SPY | ETF | 201.42 | 201.42 | 201.37 | 201.4 | 14900.0 |
| 2015-10-12 06:25:00 | SPY | ETF | 201.42 | 201.42 | 201.42 | 201.42 | 27200.0 |
| 2015-10-12 06:30:00 | SPY | ETF | 201.41 | 201.49 | 201.41 | 201.49 | 2381.0 |
| 2015-10-12 06:35:00 | SPY | ETF | 201.45 | 201.46 | 201.45 | 201.46 | 1039.0 |
| 2015-10-12 06:40:00 | SPY | ETF | 201.49 | 201.49 | 201.49 | 201.49 | 200.0 |
| 2015-10-12 06:45:00 | SPY | ETF | 201.46 | 201.46 | 201.39 | 201.46 | 1618.0 |
| 2015-10-12 06:50:00 | SPY | ETF | 201.5 | 201.5 | 201.5 | 201.5 | 1055.0 |
| 2015-10-12 06:55:00 | SPY | ETF | 201.54 | 201.54 | 201.48 | 201.5 | 4750.0 |
| 2015-10-12 07:00:00 | SPY | ETF | 201.51 | 201.57 | 201.48 | 201.57 | 7979.0 |
| 2015-10-12 07:05:00 | SPY | ETF | 201.56 | 201.56 | 201.53 | 201.55 | 3125.0 |
| 2015-10-12 07:10:00 | SPY | ETF | 201.52 | 201.56 | 201.49 | 201.49 | 4106.0 |
| 2015-10-12 07:15:00 | SPY | ETF | 201.48 | 201.5 | 201.46 | 201.46 | 13300.0 |
| 2015-10-12 07:20:00 | SPY | ETF | 201.42 | 201.42 | 201.31 | 201.31 | 4860.0 |
| 2015-10-12 07:30:00 | SPY | ETF | 201.39 | 201.41 | 201.39 | 201.41 | 920.0 |
| 2015-10-12 07:35:00 | SPY | ETF | 201.44 | 201.46 | 201.39 | 201.42 | 4844.0 |
| 2015-10-12 07:40:00 | SPY | ETF | 201.44 | 201.44 | 201.41 | 201.42 | 8900.0 |
| 2015-10-12 07:45:00 | SPY | ETF | 201.41 | 201.42 | 201.38 | 201.42 | 6163.0 |
| 2015-10-12 07:50:00 | SPY | ETF | 201.42 | 201.44 | 201.42 | 201.44 | 11100.0 |
| 2015-10-12 07:55:00 | SPY | ETF | 201.43 | 201.51 | 201.43 | 201.51 | 9210.0 |
| 2015-10-12 08:00:00 | SPY | ETF | 201.51 | 201.56 | 201.37 | 201.43 | 18718.0 |
| 2015-10-12 08:05:00 | SPY | ETF | 201.45 | 201.49 | 201.37 | 201.37 | 13720.0 |
| 2015-10-12 08:10:00 | SPY | ETF | 201.39 | 201.47 | 201.36 | 201.38 | 57518.0 |
| 2015-10-12 08:15:00 | SPY | ETF | 201.37 | 201.43 | 201.37 | 201.39 | 15785.0 |
| 2015-10-12 08:20:00 | SPY | ETF | 201.4 | 201.4 | 201.3 | 201.33 | 7889.0 |
| 2015-10-12 08:25:00 | SPY | ETF | 201.35 | 201.41 | 201.35 | 201.41 | 12419.0 |
| 2015-10-12 08:30:00 | SPY | ETF | 201.4 | 201.4 | 201.33 | 201.36 | 6357.0 |
| 2015-10-12 08:35:00 | SPY | ETF | 201.36 | 201.41 | 201.35 | 201.38 | 13141.0 |
| 2015-10-12 08:40:00 | SPY | ETF | 201.38 | 201.39 | 201.32 | 201.33 | 23684.0 |
| 2015-10-12 08:45:00 | SPY | ETF | 201.37 | 201.37 | 201.21 | 201.3 | 64571.0 |
| 2015-10-12 08:50:00 | SPY | ETF | 201.3 | 201.36 | 201.26 | 201.34 | 82989.0 |
| 2015-10-12 08:55:00 | SPY | ETF | 201.3 | 201.33 | 201.29 | 201.29 | 6472.0 |
> showing 50 of 43,598 rows — these rows as CSV