PREVIEW / etf_5min / 2016-08-19
file: by_date/etf_5min/2016/2016-08-19.parquet size: 1.1 MB rows: 46,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 |
|---|---|---|---|---|---|---|---|
| 2016-08-19 04:00:00 | SPY | ETF | 218.43 | 218.43 | 218.37 | 218.38 | 934.0 |
| 2016-08-19 04:05:00 | SPY | ETF | 218.35 | 218.35 | 218.23 | 218.23 | 1790.0 |
| 2016-08-19 04:10:00 | SPY | ETF | 218.26 | 218.26 | 218.26 | 218.26 | 300.0 |
| 2016-08-19 04:15:00 | SPY | ETF | 218.21 | 218.21 | 218.21 | 218.21 | 602.0 |
| 2016-08-19 04:20:00 | SPY | ETF | 218.2 | 218.2 | 218.17 | 218.17 | 1028.0 |
| 2016-08-19 04:25:00 | SPY | ETF | 218.11 | 218.11 | 218.05 | 218.05 | 6701.0 |
| 2016-08-19 04:30:00 | SPY | ETF | 218.08 | 218.08 | 218.0 | 218.0 | 1332.0 |
| 2016-08-19 04:35:00 | SPY | ETF | 218.0 | 218.05 | 218.0 | 218.05 | 7101.0 |
| 2016-08-19 04:40:00 | SPY | ETF | 218.1 | 218.1 | 218.05 | 218.05 | 778.0 |
| 2016-08-19 04:45:00 | SPY | ETF | 218.11 | 218.12 | 218.11 | 218.12 | 401.0 |
| 2016-08-19 04:50:00 | SPY | ETF | 218.07 | 218.07 | 218.07 | 218.07 | 801.0 |
| 2016-08-19 04:55:00 | SPY | ETF | 218.08 | 218.08 | 218.05 | 218.06 | 2562.0 |
| 2016-08-19 05:00:00 | SPY | ETF | 218.05 | 218.1 | 218.05 | 218.1 | 200.0 |
| 2016-08-19 05:05:00 | SPY | ETF | 218.16 | 218.19 | 218.16 | 218.19 | 1114.0 |
| 2016-08-19 05:10:00 | SPY | ETF | 218.22 | 218.22 | 218.22 | 218.22 | 201.0 |
| 2016-08-19 05:20:00 | SPY | ETF | 218.2 | 218.2 | 218.2 | 218.2 | 500.0 |
| 2016-08-19 05:25:00 | SPY | ETF | 218.17 | 218.17 | 218.17 | 218.17 | 113.0 |
| 2016-08-19 05:30:00 | SPY | ETF | 218.15 | 218.15 | 218.15 | 218.15 | 303.0 |
| 2016-08-19 05:35:00 | SPY | ETF | 218.22 | 218.22 | 218.22 | 218.22 | 1100.0 |
| 2016-08-19 05:40:00 | SPY | ETF | 218.2 | 218.2 | 218.2 | 218.2 | 100.0 |
| 2016-08-19 05:45:00 | SPY | ETF | 218.2 | 218.2 | 218.2 | 218.2 | 272.0 |
| 2016-08-19 05:50:00 | SPY | ETF | 218.23 | 218.23 | 218.23 | 218.23 | 200.0 |
| 2016-08-19 05:55:00 | SPY | ETF | 218.18 | 218.18 | 218.18 | 218.18 | 201.0 |
| 2016-08-19 06:00:00 | SPY | ETF | 218.23 | 218.25 | 218.22 | 218.25 | 1752.0 |
| 2016-08-19 06:05:00 | SPY | ETF | 218.27 | 218.37 | 218.27 | 218.37 | 1330.0 |
| 2016-08-19 06:10:00 | SPY | ETF | 218.34 | 218.35 | 218.33 | 218.35 | 700.0 |
| 2016-08-19 06:15:00 | SPY | ETF | 218.33 | 218.33 | 218.32 | 218.32 | 400.0 |
| 2016-08-19 06:20:00 | SPY | ETF | 218.3 | 218.3 | 218.3 | 218.3 | 200.0 |
| 2016-08-19 06:30:00 | SPY | ETF | 218.25 | 218.25 | 218.25 | 218.25 | 7929.0 |
| 2016-08-19 06:35:00 | SPY | ETF | 218.25 | 218.28 | 218.25 | 218.28 | 1401.0 |
| 2016-08-19 06:40:00 | SPY | ETF | 218.3 | 218.3 | 218.25 | 218.25 | 583.0 |
| 2016-08-19 06:45:00 | SPY | ETF | 218.22 | 218.22 | 218.18 | 218.18 | 1143.0 |
| 2016-08-19 06:50:00 | SPY | ETF | 218.22 | 218.22 | 218.2 | 218.2 | 347.0 |
| 2016-08-19 06:55:00 | SPY | ETF | 218.2 | 218.2 | 218.17 | 218.17 | 4201.0 |
| 2016-08-19 07:00:00 | SPY | ETF | 218.16 | 218.25 | 218.12 | 218.25 | 6857.0 |
| 2016-08-19 07:05:00 | SPY | ETF | 218.25 | 218.27 | 218.25 | 218.26 | 6299.0 |
| 2016-08-19 07:10:00 | SPY | ETF | 218.25 | 218.26 | 218.25 | 218.26 | 1300.0 |
| 2016-08-19 07:15:00 | SPY | ETF | 218.22 | 218.25 | 218.22 | 218.25 | 3316.0 |
| 2016-08-19 07:20:00 | SPY | ETF | 218.22 | 218.22 | 218.22 | 218.22 | 500.0 |
| 2016-08-19 07:25:00 | SPY | ETF | 218.23 | 218.23 | 218.21 | 218.21 | 12000.0 |
| 2016-08-19 07:30:00 | SPY | ETF | 218.22 | 218.22 | 218.2 | 218.2 | 1721.0 |
| 2016-08-19 07:35:00 | SPY | ETF | 218.21 | 218.24 | 218.2 | 218.23 | 28725.0 |
| 2016-08-19 07:40:00 | SPY | ETF | 218.24 | 218.25 | 218.23 | 218.23 | 2205.0 |
| 2016-08-19 07:45:00 | SPY | ETF | 218.23 | 218.23 | 218.2 | 218.2 | 32912.0 |
| 2016-08-19 07:50:00 | SPY | ETF | 218.16 | 218.16 | 218.08 | 218.13 | 8255.0 |
| 2016-08-19 07:55:00 | SPY | ETF | 218.13 | 218.13 | 218.1 | 218.11 | 7252.0 |
| 2016-08-19 08:00:00 | SPY | ETF | 218.11 | 218.21 | 218.03 | 218.05 | 112845.0 |
| 2016-08-19 08:05:00 | SPY | ETF | 218.05 | 218.12 | 218.05 | 218.11 | 32944.0 |
| 2016-08-19 08:10:00 | SPY | ETF | 218.12 | 218.17 | 218.11 | 218.17 | 10937.0 |
| 2016-08-19 08:15:00 | SPY | ETF | 218.17 | 218.17 | 218.13 | 218.13 | 12408.0 |
> showing 50 of 46,598 rows — these rows as CSV