PREVIEW / etf_5min / 2016-08-30
file: by_date/etf_5min/2016/2016-08-30.parquet size: 1.1 MB rows: 48,410
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 |
|---|---|---|---|---|---|---|---|
| 2016-08-30 04:25:00 | SPY | ETF | 218.33 | 218.33 | 218.33 | 218.33 | 500.0 |
| 2016-08-30 04:30:00 | SPY | ETF | 218.33 | 218.36 | 218.32 | 218.32 | 1750.0 |
| 2016-08-30 04:40:00 | SPY | ETF | 218.33 | 218.38 | 218.33 | 218.38 | 806.0 |
| 2016-08-30 04:45:00 | SPY | ETF | 218.48 | 218.48 | 218.45 | 218.45 | 1601.0 |
| 2016-08-30 05:00:00 | SPY | ETF | 218.38 | 218.38 | 218.35 | 218.35 | 901.0 |
| 2016-08-30 05:05:00 | SPY | ETF | 218.34 | 218.34 | 218.34 | 218.34 | 302.0 |
| 2016-08-30 05:30:00 | SPY | ETF | 218.35 | 218.35 | 218.3 | 218.33 | 19811.0 |
| 2016-08-30 05:40:00 | SPY | ETF | 218.32 | 218.32 | 218.32 | 218.32 | 300.0 |
| 2016-08-30 05:45:00 | SPY | ETF | 218.29 | 218.29 | 218.29 | 218.29 | 100.0 |
| 2016-08-30 05:50:00 | SPY | ETF | 218.28 | 218.28 | 218.26 | 218.26 | 400.0 |
| 2016-08-30 06:05:00 | SPY | ETF | 218.26 | 218.26 | 218.26 | 218.26 | 602.0 |
| 2016-08-30 06:10:00 | SPY | ETF | 218.24 | 218.24 | 218.13 | 218.17 | 7466.0 |
| 2016-08-30 06:15:00 | SPY | ETF | 218.15 | 218.18 | 218.15 | 218.18 | 699.0 |
| 2016-08-30 06:20:00 | SPY | ETF | 218.18 | 218.18 | 218.15 | 218.18 | 1500.0 |
| 2016-08-30 06:25:00 | SPY | ETF | 218.21 | 218.21 | 218.21 | 218.21 | 5000.0 |
| 2016-08-30 06:30:00 | SPY | ETF | 218.18 | 218.21 | 218.15 | 218.16 | 17204.0 |
| 2016-08-30 06:35:00 | SPY | ETF | 218.12 | 218.21 | 218.12 | 218.15 | 7304.0 |
| 2016-08-30 06:40:00 | SPY | ETF | 218.18 | 218.21 | 218.18 | 218.21 | 7302.0 |
| 2016-08-30 06:50:00 | SPY | ETF | 218.23 | 218.23 | 218.23 | 218.23 | 100.0 |
| 2016-08-30 06:55:00 | SPY | ETF | 218.27 | 218.35 | 218.27 | 218.35 | 7560.0 |
| 2016-08-30 07:00:00 | SPY | ETF | 218.33 | 218.33 | 218.3 | 218.31 | 1705.0 |
| 2016-08-30 07:05:00 | SPY | ETF | 218.31 | 218.33 | 218.3 | 218.33 | 921.0 |
| 2016-08-30 07:15:00 | SPY | ETF | 218.33 | 218.33 | 218.33 | 218.33 | 2000.0 |
| 2016-08-30 07:20:00 | SPY | ETF | 218.35 | 218.35 | 218.32 | 218.32 | 3500.0 |
| 2016-08-30 07:25:00 | SPY | ETF | 218.33 | 218.33 | 218.31 | 218.31 | 2902.0 |
| 2016-08-30 07:30:00 | SPY | ETF | 218.29 | 218.29 | 218.29 | 218.29 | 2026.0 |
| 2016-08-30 07:35:00 | SPY | ETF | 218.3 | 218.33 | 218.3 | 218.33 | 8401.0 |
| 2016-08-30 07:40:00 | SPY | ETF | 218.34 | 218.34 | 218.31 | 218.31 | 4551.0 |
| 2016-08-30 07:45:00 | SPY | ETF | 218.27 | 218.32 | 218.27 | 218.28 | 1303.0 |
| 2016-08-30 07:50:00 | SPY | ETF | 218.28 | 218.28 | 218.28 | 218.28 | 101.0 |
| 2016-08-30 07:55:00 | SPY | ETF | 218.3 | 218.3 | 218.3 | 218.3 | 903.0 |
| 2016-08-30 08:00:00 | SPY | ETF | 218.28 | 218.33 | 218.28 | 218.317 | 56913.0 |
| 2016-08-30 08:05:00 | SPY | ETF | 218.34 | 218.34 | 218.33 | 218.33 | 691.0 |
| 2016-08-30 08:10:00 | SPY | ETF | 218.34 | 218.34 | 218.32 | 218.33 | 5556.0 |
| 2016-08-30 08:15:00 | SPY | ETF | 218.34 | 218.39 | 218.34 | 218.38 | 30272.0 |
| 2016-08-30 08:20:00 | SPY | ETF | 218.37 | 218.37 | 218.29 | 218.31 | 2286.0 |
| 2016-08-30 08:25:00 | SPY | ETF | 218.3 | 218.32 | 218.3 | 218.31 | 9443.0 |
| 2016-08-30 08:30:00 | SPY | ETF | 218.3 | 218.34 | 218.3 | 218.32 | 29724.0 |
| 2016-08-30 08:35:00 | SPY | ETF | 218.32 | 218.33 | 218.31 | 218.31 | 7481.0 |
| 2016-08-30 08:40:00 | SPY | ETF | 218.31 | 218.31 | 218.28 | 218.29 | 2190.0 |
| 2016-08-30 08:45:00 | SPY | ETF | 218.29 | 218.29 | 218.22 | 218.24 | 15613.0 |
| 2016-08-30 08:50:00 | SPY | ETF | 218.26 | 218.28 | 218.24 | 218.24 | 52692.0 |
| 2016-08-30 08:55:00 | SPY | ETF | 218.25 | 218.29 | 218.24 | 218.25 | 18458.0 |
| 2016-08-30 09:00:00 | SPY | ETF | 218.3 | 218.31 | 218.26 | 218.31 | 43076.0 |
| 2016-08-30 09:05:00 | SPY | ETF | 218.3 | 218.34 | 218.28 | 218.31 | 65141.0 |
| 2016-08-30 09:10:00 | SPY | ETF | 218.3 | 218.34 | 218.3 | 218.34 | 28985.0 |
| 2016-08-30 09:15:00 | SPY | ETF | 218.34 | 218.34 | 218.3 | 218.32 | 25066.0 |
| 2016-08-30 09:20:00 | SPY | ETF | 218.31 | 218.32 | 218.28 | 218.3 | 18520.0 |
| 2016-08-30 09:25:00 | SPY | ETF | 218.3 | 218.35 | 218.25 | 218.25 | 208260.0 |
| 2016-08-30 09:30:00 | SPY | ETF | 218.26 | 218.53 | 218.25 | 218.52 | 1526708.0 |
> showing 50 of 48,410 rows — these rows as CSV