PREVIEW / etf_5min / 2018-08-07
file: by_date/etf_5min/2018/2018-08-07.parquet size: 1.3 MB rows: 57,111
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 |
|---|---|---|---|---|---|---|---|
| 2018-08-07 04:00:00 | SPY | ETF | 285.2 | 285.32 | 285.17 | 285.26 | 11942.0 |
| 2018-08-07 04:05:00 | SPY | ETF | 285.26 | 285.31 | 285.25 | 285.25 | 3342.0 |
| 2018-08-07 04:10:00 | SPY | ETF | 285.32 | 285.34 | 285.31 | 285.34 | 2882.0 |
| 2018-08-07 04:15:00 | SPY | ETF | 285.33 | 285.35 | 285.33 | 285.35 | 400.0 |
| 2018-08-07 04:20:00 | SPY | ETF | 285.33 | 285.33 | 285.33 | 285.33 | 300.0 |
| 2018-08-07 04:25:00 | SPY | ETF | 285.35 | 285.38 | 285.35 | 285.38 | 1100.0 |
| 2018-08-07 04:30:00 | SPY | ETF | 285.4 | 285.4 | 285.38 | 285.38 | 3000.0 |
| 2018-08-07 04:45:00 | SPY | ETF | 285.43 | 285.45 | 285.43 | 285.45 | 1300.0 |
| 2018-08-07 04:50:00 | SPY | ETF | 285.46 | 285.5 | 285.46 | 285.48 | 6352.0 |
| 2018-08-07 04:55:00 | SPY | ETF | 285.41 | 285.41 | 285.38 | 285.38 | 4332.0 |
| 2018-08-07 05:00:00 | SPY | ETF | 285.38 | 285.38 | 285.35 | 285.36 | 9398.0 |
| 2018-08-07 05:05:00 | SPY | ETF | 285.36 | 285.45 | 285.36 | 285.45 | 3102.0 |
| 2018-08-07 05:15:00 | SPY | ETF | 285.43 | 285.43 | 285.4 | 285.4 | 400.0 |
| 2018-08-07 05:25:00 | SPY | ETF | 285.34 | 285.34 | 285.32 | 285.32 | 800.0 |
| 2018-08-07 05:30:00 | SPY | ETF | 285.36 | 285.36 | 285.36 | 285.36 | 500.0 |
| 2018-08-07 05:35:00 | SPY | ETF | 285.32 | 285.32 | 285.32 | 285.32 | 2702.0 |
| 2018-08-07 05:45:00 | SPY | ETF | 285.25 | 285.28 | 285.25 | 285.25 | 4600.0 |
| 2018-08-07 05:50:00 | SPY | ETF | 285.28 | 285.28 | 285.28 | 285.28 | 1200.0 |
| 2018-08-07 06:00:00 | SPY | ETF | 285.28 | 285.34 | 285.28 | 285.33 | 3100.0 |
| 2018-08-07 06:05:00 | SPY | ETF | 285.33 | 285.34 | 285.33 | 285.34 | 600.0 |
| 2018-08-07 06:10:00 | SPY | ETF | 285.28 | 285.28 | 285.28 | 285.28 | 250.0 |
| 2018-08-07 06:15:00 | SPY | ETF | 285.26 | 285.26 | 285.2 | 285.2 | 3334.0 |
| 2018-08-07 06:20:00 | SPY | ETF | 285.18 | 285.23 | 285.18 | 285.23 | 4887.0 |
| 2018-08-07 06:25:00 | SPY | ETF | 285.23 | 285.23 | 285.23 | 285.23 | 300.0 |
| 2018-08-07 06:30:00 | SPY | ETF | 285.26 | 285.36 | 285.26 | 285.36 | 10100.0 |
| 2018-08-07 06:35:00 | SPY | ETF | 285.33 | 285.33 | 285.33 | 285.33 | 1100.0 |
| 2018-08-07 06:40:00 | SPY | ETF | 285.33 | 285.33 | 285.32 | 285.32 | 17000.0 |
| 2018-08-07 06:45:00 | SPY | ETF | 285.26 | 285.26 | 285.26 | 285.26 | 5500.0 |
| 2018-08-07 06:50:00 | SPY | ETF | 285.29 | 285.33 | 285.28 | 285.32 | 22350.0 |
| 2018-08-07 06:55:00 | SPY | ETF | 285.32 | 285.35 | 285.29 | 285.35 | 2075.0 |
| 2018-08-07 07:00:00 | SPY | ETF | 285.31 | 285.35 | 285.27 | 285.27 | 960.0 |
| 2018-08-07 07:10:00 | SPY | ETF | 285.3 | 285.32 | 285.3 | 285.31 | 569.0 |
| 2018-08-07 07:15:00 | SPY | ETF | 285.32 | 285.32 | 285.32 | 285.32 | 1920.0 |
| 2018-08-07 07:20:00 | SPY | ETF | 285.33 | 285.33 | 285.29 | 285.29 | 1998.0 |
| 2018-08-07 07:25:00 | SPY | ETF | 285.29 | 285.31 | 285.29 | 285.31 | 255.0 |
| 2018-08-07 07:30:00 | SPY | ETF | 285.29 | 285.3 | 285.29 | 285.29 | 7330.0 |
| 2018-08-07 07:35:00 | SPY | ETF | 285.3 | 285.3 | 285.24 | 285.25 | 15468.0 |
| 2018-08-07 07:40:00 | SPY | ETF | 285.24 | 285.25 | 285.23 | 285.25 | 22923.0 |
| 2018-08-07 07:45:00 | SPY | ETF | 285.25 | 285.29 | 285.25 | 285.29 | 5900.0 |
| 2018-08-07 07:50:00 | SPY | ETF | 285.25 | 285.29 | 285.22 | 285.22 | 11809.0 |
| 2018-08-07 07:55:00 | SPY | ETF | 285.27 | 285.28 | 285.17 | 285.17 | 4067.0 |
| 2018-08-07 08:00:00 | SPY | ETF | 285.31 | 285.32 | 284.99 | 285.2 | 19129.0 |
| 2018-08-07 08:05:00 | SPY | ETF | 285.2 | 285.23 | 285.19 | 285.23 | 6708.0 |
| 2018-08-07 08:10:00 | SPY | ETF | 285.24 | 285.3 | 285.24 | 285.24 | 3363.0 |
| 2018-08-07 08:15:00 | SPY | ETF | 285.26 | 285.26 | 285.25 | 285.25 | 4300.0 |
| 2018-08-07 08:20:00 | SPY | ETF | 285.24 | 285.26 | 285.24 | 285.25 | 2090.0 |
| 2018-08-07 08:25:00 | SPY | ETF | 285.24 | 285.25 | 285.19 | 285.21 | 36533.0 |
| 2018-08-07 08:30:00 | SPY | ETF | 285.22 | 285.26 | 285.21 | 285.25 | 10200.0 |
| 2018-08-07 08:35:00 | SPY | ETF | 285.27 | 285.27 | 285.24 | 285.25 | 3797.0 |
| 2018-08-07 08:40:00 | SPY | ETF | 285.25 | 285.29 | 285.22 | 285.28 | 31226.0 |
> showing 50 of 57,111 rows — these rows as CSV