PREVIEW / etf_5min / 2019-01-16
file: by_date/etf_5min/2019/2019-01-16.parquet size: 1.4 MB rows: 63,659
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-16 04:00:00 | SPY | ETF | 260.77 | 260.83 | 260.77 | 260.82 | 902.0 |
| 2019-01-16 04:05:00 | SPY | ETF | 260.8 | 260.8 | 260.8 | 260.8 | 1178.0 |
| 2019-01-16 04:10:00 | SPY | ETF | 260.77 | 260.77 | 260.77 | 260.77 | 100.0 |
| 2019-01-16 04:20:00 | SPY | ETF | 260.63 | 260.63 | 260.47 | 260.47 | 1292.0 |
| 2019-01-16 04:25:00 | SPY | ETF | 260.47 | 260.47 | 260.47 | 260.47 | 1100.0 |
| 2019-01-16 04:35:00 | SPY | ETF | 260.46 | 260.46 | 260.46 | 260.46 | 1000.0 |
| 2019-01-16 04:40:00 | SPY | ETF | 260.48 | 260.48 | 260.48 | 260.48 | 600.0 |
| 2019-01-16 04:45:00 | SPY | ETF | 260.43 | 260.51 | 260.36 | 260.51 | 3100.0 |
| 2019-01-16 04:50:00 | SPY | ETF | 260.53 | 260.57 | 260.5 | 260.53 | 800.0 |
| 2019-01-16 04:55:00 | SPY | ETF | 260.38 | 260.42 | 260.33 | 260.42 | 1800.0 |
| 2019-01-16 05:00:00 | SPY | ETF | 260.47 | 260.47 | 260.47 | 260.47 | 100.0 |
| 2019-01-16 05:05:00 | SPY | ETF | 260.52 | 260.54 | 260.52 | 260.54 | 200.0 |
| 2019-01-16 05:10:00 | SPY | ETF | 260.66 | 260.66 | 260.66 | 260.66 | 100.0 |
| 2019-01-16 05:15:00 | SPY | ETF | 260.72 | 260.72 | 260.72 | 260.72 | 500.0 |
| 2019-01-16 05:20:00 | SPY | ETF | 260.68 | 260.7 | 260.6 | 260.6 | 879.0 |
| 2019-01-16 05:25:00 | SPY | ETF | 260.62 | 260.64 | 260.6 | 260.6 | 1260.0 |
| 2019-01-16 05:30:00 | SPY | ETF | 260.56 | 260.56 | 260.56 | 260.56 | 169.0 |
| 2019-01-16 05:35:00 | SPY | ETF | 260.53 | 260.53 | 260.47 | 260.48 | 5069.0 |
| 2019-01-16 05:40:00 | SPY | ETF | 260.46 | 260.5 | 260.42 | 260.46 | 3099.0 |
| 2019-01-16 05:45:00 | SPY | ETF | 260.47 | 260.48 | 260.44 | 260.48 | 538.0 |
| 2019-01-16 05:50:00 | SPY | ETF | 260.44 | 260.44 | 260.31 | 260.35 | 2000.0 |
| 2019-01-16 05:55:00 | SPY | ETF | 260.35 | 260.38 | 260.31 | 260.32 | 3548.0 |
| 2019-01-16 06:00:00 | SPY | ETF | 260.26 | 260.28 | 260.24 | 260.28 | 794.0 |
| 2019-01-16 06:05:00 | SPY | ETF | 260.24 | 260.24 | 260.16 | 260.16 | 1769.0 |
| 2019-01-16 06:10:00 | SPY | ETF | 260.14 | 260.18 | 260.14 | 260.18 | 1364.0 |
| 2019-01-16 06:20:00 | SPY | ETF | 260.17 | 260.21 | 260.14 | 260.21 | 1400.0 |
| 2019-01-16 06:25:00 | SPY | ETF | 260.26 | 260.26 | 260.26 | 260.26 | 369.0 |
| 2019-01-16 06:30:00 | SPY | ETF | 260.22 | 260.22 | 260.15 | 260.18 | 469.0 |
| 2019-01-16 06:35:00 | SPY | ETF | 260.26 | 260.26 | 260.26 | 260.26 | 369.0 |
| 2019-01-16 06:40:00 | SPY | ETF | 260.22 | 260.22 | 260.16 | 260.16 | 1038.0 |
| 2019-01-16 06:45:00 | SPY | ETF | 260.17 | 260.34 | 260.17 | 260.34 | 1568.0 |
| 2019-01-16 06:50:00 | SPY | ETF | 260.27 | 260.36 | 260.27 | 260.36 | 1324.0 |
| 2019-01-16 06:55:00 | SPY | ETF | 260.32 | 260.35 | 260.32 | 260.35 | 200.0 |
| 2019-01-16 07:00:00 | SPY | ETF | 260.38 | 260.44 | 260.31 | 260.34 | 11032.0 |
| 2019-01-16 07:05:00 | SPY | ETF | 260.31 | 260.31 | 260.1 | 260.11 | 12539.0 |
| 2019-01-16 07:10:00 | SPY | ETF | 260.16 | 260.16 | 260.13 | 260.13 | 3251.0 |
| 2019-01-16 07:15:00 | SPY | ETF | 260.17 | 260.17 | 260.09 | 260.09 | 1804.0 |
| 2019-01-16 07:20:00 | SPY | ETF | 260.17 | 260.31 | 260.17 | 260.31 | 3876.0 |
| 2019-01-16 07:25:00 | SPY | ETF | 260.3 | 260.31 | 260.29 | 260.29 | 1735.0 |
| 2019-01-16 07:30:00 | SPY | ETF | 260.24 | 260.27 | 260.21 | 260.27 | 11360.0 |
| 2019-01-16 07:35:00 | SPY | ETF | 260.3 | 260.55 | 260.3 | 260.44 | 36916.0 |
| 2019-01-16 07:40:00 | SPY | ETF | 260.45 | 260.59 | 260.44 | 260.59 | 11508.0 |
| 2019-01-16 07:45:00 | SPY | ETF | 260.61 | 260.66 | 260.56 | 260.64 | 23609.0 |
| 2019-01-16 07:50:00 | SPY | ETF | 260.64 | 260.64 | 260.55 | 260.55 | 11384.0 |
| 2019-01-16 07:55:00 | SPY | ETF | 260.55 | 260.62 | 260.52 | 260.54 | 6877.0 |
| 2019-01-16 08:00:00 | SPY | ETF | 260.1501 | 260.83 | 260.1501 | 260.61 | 10521.0 |
| 2019-01-16 08:05:00 | SPY | ETF | 260.56 | 260.57 | 260.53 | 260.55 | 8828.0 |
| 2019-01-16 08:10:00 | SPY | ETF | 260.56 | 260.56 | 260.48 | 260.51 | 7179.0 |
| 2019-01-16 08:15:00 | SPY | ETF | 260.53 | 260.53 | 260.46 | 260.49 | 18672.0 |
| 2019-01-16 08:20:00 | SPY | ETF | 260.52 | 260.66 | 260.5 | 260.66 | 16352.0 |
> showing 50 of 63,659 rows — these rows as CSV