PREVIEW / etf_5min / 2016-08-03
file: by_date/etf_5min/2016/2016-08-03.parquet size: 1.1 MB rows: 48,032
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-03 04:00:00 | SPY | ETF | 215.3 | 215.3 | 215.11 | 215.11 | 1115.0 |
| 2016-08-03 04:05:00 | SPY | ETF | 215.13 | 215.14 | 215.05 | 215.05 | 15419.0 |
| 2016-08-03 04:10:00 | SPY | ETF | 215.06 | 215.13 | 215.06 | 215.12 | 2213.0 |
| 2016-08-03 04:15:00 | SPY | ETF | 215.12 | 215.28 | 215.1 | 215.28 | 15725.0 |
| 2016-08-03 04:20:00 | SPY | ETF | 215.27 | 215.3 | 215.27 | 215.28 | 2903.0 |
| 2016-08-03 04:35:00 | SPY | ETF | 215.29 | 215.33 | 215.25 | 215.25 | 1106.0 |
| 2016-08-03 04:40:00 | SPY | ETF | 215.25 | 215.25 | 215.13 | 215.13 | 3609.0 |
| 2016-08-03 04:45:00 | SPY | ETF | 215.15 | 215.15 | 215.15 | 215.15 | 2100.0 |
| 2016-08-03 04:55:00 | SPY | ETF | 215.18 | 215.2 | 215.18 | 215.2 | 2550.0 |
| 2016-08-03 05:00:00 | SPY | ETF | 215.2 | 215.22 | 215.15 | 215.15 | 4555.0 |
| 2016-08-03 05:05:00 | SPY | ETF | 215.22 | 215.22 | 215.17 | 215.18 | 3001.0 |
| 2016-08-03 05:10:00 | SPY | ETF | 215.16 | 215.16 | 215.1 | 215.1 | 21120.0 |
| 2016-08-03 05:15:00 | SPY | ETF | 215.14 | 215.16 | 215.14 | 215.16 | 2520.0 |
| 2016-08-03 05:20:00 | SPY | ETF | 215.2 | 215.3 | 215.2 | 215.3 | 4557.0 |
| 2016-08-03 05:25:00 | SPY | ETF | 215.3 | 215.31 | 215.26 | 215.26 | 2101.0 |
| 2016-08-03 05:30:00 | SPY | ETF | 215.33 | 215.36 | 215.33 | 215.36 | 3103.0 |
| 2016-08-03 05:35:00 | SPY | ETF | 215.31 | 215.31 | 215.31 | 215.31 | 2800.0 |
| 2016-08-03 05:40:00 | SPY | ETF | 215.25 | 215.31 | 215.25 | 215.31 | 1601.0 |
| 2016-08-03 05:45:00 | SPY | ETF | 215.31 | 215.34 | 215.31 | 215.34 | 5802.0 |
| 2016-08-03 05:50:00 | SPY | ETF | 215.28 | 215.33 | 215.28 | 215.33 | 1704.0 |
| 2016-08-03 05:55:00 | SPY | ETF | 215.32 | 215.32 | 215.32 | 215.32 | 201.0 |
| 2016-08-03 06:00:00 | SPY | ETF | 215.27 | 215.28 | 215.27 | 215.28 | 1001.0 |
| 2016-08-03 06:05:00 | SPY | ETF | 215.25 | 215.25 | 215.25 | 215.25 | 600.0 |
| 2016-08-03 06:10:00 | SPY | ETF | 215.25 | 215.3 | 215.25 | 215.29 | 15500.0 |
| 2016-08-03 06:15:00 | SPY | ETF | 215.25 | 215.27 | 215.25 | 215.27 | 5900.0 |
| 2016-08-03 06:20:00 | SPY | ETF | 215.33 | 215.33 | 215.33 | 215.33 | 302.0 |
| 2016-08-03 06:25:00 | SPY | ETF | 215.33 | 215.33 | 215.23 | 215.26 | 1807.0 |
| 2016-08-03 06:30:00 | SPY | ETF | 215.25 | 215.29 | 215.25 | 215.26 | 10600.0 |
| 2016-08-03 06:35:00 | SPY | ETF | 215.3 | 215.3 | 215.3 | 215.3 | 2522.0 |
| 2016-08-03 06:40:00 | SPY | ETF | 215.29 | 215.3 | 215.29 | 215.29 | 12802.0 |
| 2016-08-03 06:45:00 | SPY | ETF | 215.28 | 215.32 | 215.27 | 215.32 | 20301.0 |
| 2016-08-03 06:50:00 | SPY | ETF | 215.26 | 215.26 | 215.26 | 215.26 | 355.0 |
| 2016-08-03 06:55:00 | SPY | ETF | 215.26 | 215.31 | 215.24 | 215.24 | 3805.0 |
| 2016-08-03 07:00:00 | SPY | ETF | 215.29 | 215.31 | 215.28 | 215.31 | 30451.0 |
| 2016-08-03 07:05:00 | SPY | ETF | 215.31 | 215.31 | 215.31 | 215.31 | 6800.0 |
| 2016-08-03 07:10:00 | SPY | ETF | 215.31 | 215.31 | 215.28 | 215.28 | 2116.0 |
| 2016-08-03 07:15:00 | SPY | ETF | 215.27 | 215.27 | 215.2 | 215.22 | 18404.0 |
| 2016-08-03 07:20:00 | SPY | ETF | 215.2 | 215.24 | 215.18 | 215.21 | 13804.0 |
| 2016-08-03 07:25:00 | SPY | ETF | 215.19 | 215.23 | 215.18 | 215.22 | 132452.0 |
| 2016-08-03 07:30:00 | SPY | ETF | 215.2 | 215.27 | 215.2 | 215.27 | 5601.0 |
| 2016-08-03 07:35:00 | SPY | ETF | 215.23 | 215.25 | 215.19 | 215.25 | 8030.0 |
| 2016-08-03 07:40:00 | SPY | ETF | 215.25 | 215.27 | 215.24 | 215.24 | 10570.0 |
| 2016-08-03 07:45:00 | SPY | ETF | 215.21 | 215.29 | 215.21 | 215.29 | 4238.0 |
| 2016-08-03 07:50:00 | SPY | ETF | 215.31 | 215.31 | 215.3 | 215.3 | 26400.0 |
| 2016-08-03 07:55:00 | SPY | ETF | 215.3 | 215.37 | 215.3 | 215.35 | 12302.0 |
| 2016-08-03 08:00:00 | SPY | ETF | 215.35 | 215.35 | 215.08 | 215.08 | 70976.0 |
| 2016-08-03 08:05:00 | SPY | ETF | 215.2 | 215.32 | 215.105 | 215.3 | 113354.0 |
| 2016-08-03 08:10:00 | SPY | ETF | 215.31 | 215.36 | 215.31 | 215.33 | 8145.0 |
| 2016-08-03 08:15:00 | SPY | ETF | 215.33 | 215.4 | 215.33 | 215.36 | 16377.0 |
| 2016-08-03 08:20:00 | SPY | ETF | 215.4 | 215.49 | 215.4 | 215.48 | 44981.0 |
> showing 50 of 48,032 rows — these rows as CSV