PREVIEW / etf_5min / 2016-01-12
file: by_date/etf_5min/2016/2016-01-12.parquet size: 1.3 MB rows: 53,629
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-01-12 04:00:00 | SPY | ETF | 191.64 | 191.71 | 191.4 | 191.4 | 1431.0 |
| 2016-01-12 04:05:00 | SPY | ETF | 191.62 | 191.62 | 191.52 | 191.58 | 3140.0 |
| 2016-01-12 04:10:00 | SPY | ETF | 191.55 | 191.64 | 191.35 | 191.64 | 6948.0 |
| 2016-01-12 04:15:00 | SPY | ETF | 191.61 | 191.88 | 191.61 | 191.83 | 2972.0 |
| 2016-01-12 04:20:00 | SPY | ETF | 191.88 | 192.02 | 191.88 | 191.9 | 6273.0 |
| 2016-01-12 04:25:00 | SPY | ETF | 191.96 | 192.38 | 191.96 | 192.38 | 5330.0 |
| 2016-01-12 04:30:00 | SPY | ETF | 192.36 | 192.36 | 192.23 | 192.25 | 12960.0 |
| 2016-01-12 04:35:00 | SPY | ETF | 192.33 | 192.34 | 192.13 | 192.13 | 1660.0 |
| 2016-01-12 04:40:00 | SPY | ETF | 192.13 | 192.13 | 192.13 | 192.13 | 650.0 |
| 2016-01-12 04:45:00 | SPY | ETF | 192.43 | 192.49 | 192.43 | 192.48 | 2246.0 |
| 2016-01-12 04:50:00 | SPY | ETF | 192.5 | 192.66 | 192.5 | 192.62 | 2655.0 |
| 2016-01-12 04:55:00 | SPY | ETF | 192.71 | 192.71 | 192.55 | 192.6 | 1210.0 |
| 2016-01-12 05:00:00 | SPY | ETF | 192.65 | 192.71 | 192.65 | 192.71 | 2550.0 |
| 2016-01-12 05:05:00 | SPY | ETF | 192.76 | 192.95 | 192.71 | 192.95 | 6410.0 |
| 2016-01-12 05:10:00 | SPY | ETF | 192.93 | 192.93 | 192.9 | 192.9 | 2040.0 |
| 2016-01-12 05:15:00 | SPY | ETF | 192.71 | 192.71 | 192.66 | 192.71 | 705.0 |
| 2016-01-12 05:20:00 | SPY | ETF | 192.59 | 192.59 | 192.59 | 192.59 | 110.0 |
| 2016-01-12 05:25:00 | SPY | ETF | 192.6 | 192.8 | 192.52 | 192.8 | 2615.0 |
| 2016-01-12 05:30:00 | SPY | ETF | 192.76 | 192.82 | 192.76 | 192.82 | 600.0 |
| 2016-01-12 05:35:00 | SPY | ETF | 192.84 | 193.23 | 192.84 | 193.23 | 8182.0 |
| 2016-01-12 05:40:00 | SPY | ETF | 193.21 | 193.25 | 193.12 | 193.2 | 8025.0 |
| 2016-01-12 05:45:00 | SPY | ETF | 193.23 | 193.28 | 193.23 | 193.28 | 4785.0 |
| 2016-01-12 05:50:00 | SPY | ETF | 193.26 | 193.26 | 193.22 | 193.22 | 1500.0 |
| 2016-01-12 05:55:00 | SPY | ETF | 193.27 | 193.55 | 193.26 | 193.53 | 10999.0 |
| 2016-01-12 06:00:00 | SPY | ETF | 193.45 | 193.59 | 193.45 | 193.46 | 12229.0 |
| 2016-01-12 06:05:00 | SPY | ETF | 193.44 | 193.51 | 193.25 | 193.25 | 4750.0 |
| 2016-01-12 06:10:00 | SPY | ETF | 193.29 | 193.29 | 193.16 | 193.24 | 2560.0 |
| 2016-01-12 06:15:00 | SPY | ETF | 193.29 | 193.39 | 193.28 | 193.33 | 4232.0 |
| 2016-01-12 06:20:00 | SPY | ETF | 193.45 | 193.48 | 193.3 | 193.35 | 9280.0 |
| 2016-01-12 06:25:00 | SPY | ETF | 193.44 | 193.51 | 193.4 | 193.4 | 5320.0 |
| 2016-01-12 06:30:00 | SPY | ETF | 193.42 | 193.42 | 193.25 | 193.25 | 14511.0 |
| 2016-01-12 06:35:00 | SPY | ETF | 193.25 | 193.25 | 193.12 | 193.23 | 21265.0 |
| 2016-01-12 06:40:00 | SPY | ETF | 193.31 | 193.38 | 193.23 | 193.23 | 10600.0 |
| 2016-01-12 06:45:00 | SPY | ETF | 193.24 | 193.26 | 193.06 | 193.09 | 76320.0 |
| 2016-01-12 06:50:00 | SPY | ETF | 193.1 | 194.0 | 192.97 | 193.02 | 74145.0 |
| 2016-01-12 06:55:00 | SPY | ETF | 192.99 | 193.25 | 192.95 | 193.25 | 9567.0 |
| 2016-01-12 07:00:00 | SPY | ETF | 193.23 | 193.3 | 193.17 | 193.29 | 68120.0 |
| 2016-01-12 07:05:00 | SPY | ETF | 193.28 | 193.3 | 193.06 | 193.11 | 15769.0 |
| 2016-01-12 07:10:00 | SPY | ETF | 193.15 | 193.15 | 193.09 | 193.15 | 5620.0 |
| 2016-01-12 07:15:00 | SPY | ETF | 193.15 | 193.26 | 193.15 | 193.18 | 25729.0 |
| 2016-01-12 07:20:00 | SPY | ETF | 193.16 | 193.34 | 193.14 | 193.3 | 18955.0 |
| 2016-01-12 07:25:00 | SPY | ETF | 193.33 | 193.48 | 193.31 | 193.43 | 19276.0 |
| 2016-01-12 07:30:00 | SPY | ETF | 193.36 | 193.37 | 193.2 | 193.24 | 58356.0 |
| 2016-01-12 07:35:00 | SPY | ETF | 193.26 | 193.35 | 193.2 | 193.31 | 39804.0 |
| 2016-01-12 07:40:00 | SPY | ETF | 193.31 | 193.33 | 193.23 | 193.23 | 26213.0 |
| 2016-01-12 07:45:00 | SPY | ETF | 193.22 | 193.47 | 193.2 | 193.45 | 42234.0 |
| 2016-01-12 07:50:00 | SPY | ETF | 193.45 | 193.58 | 193.39 | 193.56 | 137917.0 |
| 2016-01-12 07:55:00 | SPY | ETF | 193.58 | 193.99 | 193.55 | 193.85 | 345375.0 |
| 2016-01-12 08:00:00 | SPY | ETF | 193.84 | 194.09 | 193.07 | 194.04 | 260190.0 |
| 2016-01-12 08:05:00 | SPY | ETF | 194.04 | 194.08 | 193.9 | 194.01 | 484250.0 |
> showing 50 of 53,629 rows — these rows as CSV