PREVIEW / etf_5min / 2019-06-13
file: by_date/etf_5min/2019/2019-06-13.parquet size: 1.3 MB rows: 58,823
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-06-13 04:00:00 | SPY | ETF | 288.99 | 289.0 | 288.85 | 289.0 | 2609.0 |
| 2019-06-13 04:05:00 | SPY | ETF | 288.98 | 289.06 | 288.96 | 289.02 | 1244.0 |
| 2019-06-13 04:10:00 | SPY | ETF | 288.99 | 289.0 | 288.94 | 288.94 | 598.0 |
| 2019-06-13 04:15:00 | SPY | ETF | 288.86 | 289.1 | 288.86 | 289.08 | 3586.0 |
| 2019-06-13 04:25:00 | SPY | ETF | 289.17 | 289.25 | 289.1 | 289.1 | 4810.0 |
| 2019-06-13 04:30:00 | SPY | ETF | 289.13 | 289.22 | 289.13 | 289.19 | 5550.0 |
| 2019-06-13 04:35:00 | SPY | ETF | 289.13 | 289.28 | 289.13 | 289.28 | 5948.0 |
| 2019-06-13 04:40:00 | SPY | ETF | 289.21 | 289.61 | 289.21 | 289.53 | 12817.0 |
| 2019-06-13 04:45:00 | SPY | ETF | 289.57 | 289.57 | 289.48 | 289.5 | 700.0 |
| 2019-06-13 04:50:00 | SPY | ETF | 289.46 | 289.46 | 289.42 | 289.43 | 900.0 |
| 2019-06-13 04:55:00 | SPY | ETF | 289.49 | 289.5 | 289.41 | 289.44 | 5000.0 |
| 2019-06-13 05:00:00 | SPY | ETF | 289.4 | 289.4 | 289.34 | 289.34 | 6311.0 |
| 2019-06-13 05:05:00 | SPY | ETF | 289.36 | 289.36 | 289.31 | 289.35 | 3200.0 |
| 2019-06-13 05:10:00 | SPY | ETF | 289.31 | 289.48 | 289.29 | 289.48 | 6154.0 |
| 2019-06-13 05:15:00 | SPY | ETF | 289.48 | 289.48 | 289.32 | 289.32 | 2900.0 |
| 2019-06-13 05:20:00 | SPY | ETF | 289.4 | 289.4 | 289.33 | 289.33 | 2200.0 |
| 2019-06-13 05:25:00 | SPY | ETF | 289.43 | 289.55 | 289.43 | 289.51 | 940.0 |
| 2019-06-13 05:30:00 | SPY | ETF | 289.51 | 289.51 | 289.48 | 289.48 | 700.0 |
| 2019-06-13 05:35:00 | SPY | ETF | 289.33 | 289.33 | 289.33 | 289.33 | 191.0 |
| 2019-06-13 05:40:00 | SPY | ETF | 289.29 | 289.36 | 289.28 | 289.36 | 1810.0 |
| 2019-06-13 05:45:00 | SPY | ETF | 289.31 | 289.32 | 289.23 | 289.23 | 3200.0 |
| 2019-06-13 05:50:00 | SPY | ETF | 289.27 | 289.32 | 289.27 | 289.32 | 1640.0 |
| 2019-06-13 05:55:00 | SPY | ETF | 289.24 | 289.24 | 289.24 | 289.24 | 2011.0 |
| 2019-06-13 06:00:00 | SPY | ETF | 289.17 | 289.17 | 289.17 | 289.17 | 100.0 |
| 2019-06-13 06:05:00 | SPY | ETF | 289.23 | 289.23 | 289.23 | 289.23 | 100.0 |
| 2019-06-13 06:10:00 | SPY | ETF | 289.19 | 289.25 | 289.19 | 289.25 | 2210.0 |
| 2019-06-13 06:20:00 | SPY | ETF | 289.28 | 289.28 | 289.28 | 289.28 | 176.0 |
| 2019-06-13 06:25:00 | SPY | ETF | 289.39 | 289.41 | 289.39 | 289.4 | 3500.0 |
| 2019-06-13 06:30:00 | SPY | ETF | 289.4 | 289.4 | 289.28 | 289.3 | 5661.0 |
| 2019-06-13 06:35:00 | SPY | ETF | 289.18 | 289.2 | 289.08 | 289.16 | 4511.0 |
| 2019-06-13 06:40:00 | SPY | ETF | 289.35 | 289.35 | 289.35 | 289.35 | 500.0 |
| 2019-06-13 06:45:00 | SPY | ETF | 289.34 | 289.41 | 289.34 | 289.41 | 1207.0 |
| 2019-06-13 06:50:00 | SPY | ETF | 289.38 | 289.55 | 289.38 | 289.51 | 10958.0 |
| 2019-06-13 06:55:00 | SPY | ETF | 289.58 | 289.73 | 289.58 | 289.73 | 1840.0 |
| 2019-06-13 07:00:00 | SPY | ETF | 289.73 | 289.77 | 289.68 | 289.69 | 15374.0 |
| 2019-06-13 07:05:00 | SPY | ETF | 289.65 | 289.65 | 289.56 | 289.56 | 25705.0 |
| 2019-06-13 07:10:00 | SPY | ETF | 289.56 | 289.59 | 289.55 | 289.57 | 27472.0 |
| 2019-06-13 07:15:00 | SPY | ETF | 289.56 | 289.58 | 289.53 | 289.53 | 19520.0 |
| 2019-06-13 07:20:00 | SPY | ETF | 289.5 | 289.5 | 289.41 | 289.43 | 42421.0 |
| 2019-06-13 07:25:00 | SPY | ETF | 289.45 | 289.45 | 289.45 | 289.45 | 200.0 |
| 2019-06-13 07:30:00 | SPY | ETF | 289.45 | 289.49 | 289.45 | 289.47 | 6465.0 |
| 2019-06-13 07:35:00 | SPY | ETF | 289.42 | 289.42 | 289.37 | 289.4 | 11400.0 |
| 2019-06-13 07:40:00 | SPY | ETF | 289.39 | 289.39 | 289.29 | 289.29 | 54030.0 |
| 2019-06-13 07:45:00 | SPY | ETF | 289.29 | 289.31 | 289.27 | 289.31 | 3800.0 |
| 2019-06-13 07:50:00 | SPY | ETF | 289.31 | 289.39 | 289.28 | 289.39 | 7235.0 |
| 2019-06-13 07:55:00 | SPY | ETF | 289.39 | 289.42 | 289.39 | 289.4 | 3724.0 |
| 2019-06-13 08:00:00 | SPY | ETF | 289.2901 | 289.73 | 287.71 | 287.71 | 45495.0 |
| 2019-06-13 08:05:00 | SPY | ETF | 289.24 | 289.3 | 288.3 | 289.23 | 19845.0 |
| 2019-06-13 08:10:00 | SPY | ETF | 289.25 | 289.25 | 289.13 | 289.1401 | 99192.0 |
| 2019-06-13 08:15:00 | SPY | ETF | 289.13 | 289.16 | 289.06 | 289.08 | 63097.0 |
> showing 50 of 58,823 rows — these rows as CSV