PREVIEW / etf_5min / 2018-12-07
file: by_date/etf_5min/2018/2018-12-07.parquet size: 1.6 MB rows: 66,084
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-12-07 04:00:00 | SPY | ETF | 268.34 | 268.34 | 267.97 | 267.97 | 3083.0 |
| 2018-12-07 04:05:00 | SPY | ETF | 268.02 | 268.02 | 267.93 | 267.93 | 237.0 |
| 2018-12-07 04:10:00 | SPY | ETF | 268.1 | 268.25 | 268.1 | 268.22 | 1450.0 |
| 2018-12-07 04:15:00 | SPY | ETF | 268.16 | 268.16 | 268.14 | 268.14 | 250.0 |
| 2018-12-07 04:20:00 | SPY | ETF | 268.25 | 268.25 | 268.25 | 268.25 | 252.0 |
| 2018-12-07 04:25:00 | SPY | ETF | 268.35 | 268.35 | 268.35 | 268.35 | 200.0 |
| 2018-12-07 04:30:00 | SPY | ETF | 268.3 | 268.3 | 268.2 | 268.2 | 3655.0 |
| 2018-12-07 04:35:00 | SPY | ETF | 268.34 | 268.44 | 268.34 | 268.44 | 3550.0 |
| 2018-12-07 04:40:00 | SPY | ETF | 268.4 | 268.4 | 268.4 | 268.4 | 300.0 |
| 2018-12-07 04:45:00 | SPY | ETF | 268.48 | 268.48 | 268.48 | 268.48 | 200.0 |
| 2018-12-07 04:50:00 | SPY | ETF | 268.46 | 268.74 | 268.46 | 268.61 | 6816.0 |
| 2018-12-07 04:55:00 | SPY | ETF | 268.67 | 268.74 | 268.63 | 268.74 | 1145.0 |
| 2018-12-07 05:00:00 | SPY | ETF | 268.63 | 268.63 | 268.56 | 268.56 | 700.0 |
| 2018-12-07 05:05:00 | SPY | ETF | 268.56 | 268.56 | 268.5 | 268.5 | 510.0 |
| 2018-12-07 05:10:00 | SPY | ETF | 268.36 | 268.38 | 268.32 | 268.38 | 660.0 |
| 2018-12-07 05:15:00 | SPY | ETF | 268.36 | 268.36 | 268.36 | 268.36 | 400.0 |
| 2018-12-07 05:30:00 | SPY | ETF | 268.45 | 268.45 | 268.45 | 268.45 | 100.0 |
| 2018-12-07 05:35:00 | SPY | ETF | 268.56 | 268.56 | 268.56 | 268.56 | 250.0 |
| 2018-12-07 05:40:00 | SPY | ETF | 268.55 | 268.77 | 268.55 | 268.77 | 400.0 |
| 2018-12-07 05:45:00 | SPY | ETF | 268.71 | 268.71 | 268.61 | 268.63 | 1150.0 |
| 2018-12-07 05:50:00 | SPY | ETF | 268.6 | 268.6 | 268.41 | 268.41 | 1000.0 |
| 2018-12-07 06:00:00 | SPY | ETF | 268.29 | 268.29 | 268.29 | 268.29 | 400.0 |
| 2018-12-07 06:05:00 | SPY | ETF | 268.37 | 268.41 | 268.36 | 268.36 | 3058.0 |
| 2018-12-07 06:10:00 | SPY | ETF | 268.33 | 268.33 | 268.26 | 268.26 | 538.0 |
| 2018-12-07 06:15:00 | SPY | ETF | 268.33 | 268.44 | 268.3 | 268.4 | 1807.0 |
| 2018-12-07 06:20:00 | SPY | ETF | 268.41 | 268.43 | 268.15 | 268.16 | 19845.0 |
| 2018-12-07 06:25:00 | SPY | ETF | 268.16 | 268.26 | 268.08 | 268.1 | 12292.0 |
| 2018-12-07 06:30:00 | SPY | ETF | 268.15 | 268.2 | 268.1 | 268.13 | 8950.0 |
| 2018-12-07 06:35:00 | SPY | ETF | 268.07 | 268.15 | 268.02 | 268.15 | 8319.0 |
| 2018-12-07 06:40:00 | SPY | ETF | 268.1 | 268.15 | 268.05 | 268.15 | 5497.0 |
| 2018-12-07 06:45:00 | SPY | ETF | 268.1 | 268.1 | 268.0 | 268.0 | 11995.0 |
| 2018-12-07 06:50:00 | SPY | ETF | 268.02 | 268.15 | 268.01 | 268.12 | 12948.0 |
| 2018-12-07 06:55:00 | SPY | ETF | 268.17 | 268.19 | 267.85 | 267.85 | 18686.0 |
| 2018-12-07 07:00:00 | SPY | ETF | 267.87 | 267.92 | 267.81 | 267.9 | 21873.0 |
| 2018-12-07 07:05:00 | SPY | ETF | 267.95 | 267.99 | 267.72 | 267.85 | 19527.0 |
| 2018-12-07 07:10:00 | SPY | ETF | 267.85 | 267.97 | 267.85 | 267.94 | 16871.0 |
| 2018-12-07 07:15:00 | SPY | ETF | 268.03 | 268.18 | 268.0 | 268.18 | 13625.0 |
| 2018-12-07 07:20:00 | SPY | ETF | 268.15 | 268.15 | 267.95 | 268.02 | 6125.0 |
| 2018-12-07 07:25:00 | SPY | ETF | 267.96 | 267.96 | 267.85 | 267.9 | 40210.0 |
| 2018-12-07 07:30:00 | SPY | ETF | 267.85 | 267.96 | 267.77 | 267.86 | 89511.0 |
| 2018-12-07 07:35:00 | SPY | ETF | 267.87 | 267.99 | 267.84 | 267.93 | 123200.0 |
| 2018-12-07 07:40:00 | SPY | ETF | 267.91 | 268.1 | 267.87 | 268.1 | 75096.0 |
| 2018-12-07 07:45:00 | SPY | ETF | 268.07 | 268.11 | 267.95 | 268.0 | 10165.0 |
| 2018-12-07 07:50:00 | SPY | ETF | 268.05 | 268.06 | 267.99 | 268.02 | 45341.0 |
| 2018-12-07 07:55:00 | SPY | ETF | 267.99 | 268.15 | 267.96 | 268.1 | 72904.0 |
| 2018-12-07 08:00:00 | SPY | ETF | 267.9401 | 269.15 | 267.45 | 268.29 | 54424.0 |
| 2018-12-07 08:05:00 | SPY | ETF | 268.28 | 268.28 | 268.07 | 268.18 | 24440.0 |
| 2018-12-07 08:10:00 | SPY | ETF | 268.15 | 268.52 | 268.1 | 268.49 | 80482.0 |
| 2018-12-07 08:15:00 | SPY | ETF | 268.46 | 268.58 | 268.38 | 268.55 | 97652.0 |
| 2018-12-07 08:20:00 | SPY | ETF | 268.56 | 268.64 | 268.52 | 268.64 | 49846.0 |
> showing 50 of 66,084 rows — these rows as CSV