PREVIEW / etf_5min / 2020-10-16
file: by_date/etf_5min/2020/2020-10-16.parquet size: 1.5 MB rows: 69,746
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-16 04:00:00 | SPY | ETF | 347.55 | 347.66 | 347.51 | 347.53 | 2430.0 |
| 2020-10-16 04:05:00 | SPY | ETF | 347.75 | 347.75 | 347.75 | 347.75 | 101.0 |
| 2020-10-16 04:10:00 | SPY | ETF | 347.62 | 347.62 | 347.6 | 347.6 | 4262.0 |
| 2020-10-16 04:15:00 | SPY | ETF | 347.47 | 347.47 | 347.47 | 347.47 | 100.0 |
| 2020-10-16 04:20:00 | SPY | ETF | 347.42 | 347.42 | 347.37 | 347.39 | 450.0 |
| 2020-10-16 04:25:00 | SPY | ETF | 347.4 | 347.61 | 347.4 | 347.61 | 6600.0 |
| 2020-10-16 04:30:00 | SPY | ETF | 347.69 | 347.72 | 347.69 | 347.72 | 1030.0 |
| 2020-10-16 04:35:00 | SPY | ETF | 347.67 | 347.82 | 347.64 | 347.82 | 26050.0 |
| 2020-10-16 04:40:00 | SPY | ETF | 347.6 | 347.6 | 347.6 | 347.6 | 200.0 |
| 2020-10-16 04:45:00 | SPY | ETF | 347.61 | 347.66 | 347.61 | 347.66 | 600.0 |
| 2020-10-16 04:55:00 | SPY | ETF | 347.79 | 347.79 | 347.79 | 347.79 | 372.0 |
| 2020-10-16 05:00:00 | SPY | ETF | 347.81 | 347.81 | 347.81 | 347.81 | 100.0 |
| 2020-10-16 05:05:00 | SPY | ETF | 347.72 | 347.72 | 347.72 | 347.72 | 171.0 |
| 2020-10-16 05:10:00 | SPY | ETF | 347.8 | 347.8 | 347.75 | 347.75 | 814.0 |
| 2020-10-16 05:15:00 | SPY | ETF | 347.71 | 347.72 | 347.71 | 347.71 | 1225.0 |
| 2020-10-16 05:20:00 | SPY | ETF | 347.78 | 347.78 | 347.52 | 347.52 | 2066.0 |
| 2020-10-16 05:25:00 | SPY | ETF | 347.63 | 347.63 | 347.49 | 347.49 | 550.0 |
| 2020-10-16 05:30:00 | SPY | ETF | 347.35 | 347.46 | 347.34 | 347.35 | 3075.0 |
| 2020-10-16 05:35:00 | SPY | ETF | 347.19 | 347.19 | 347.16 | 347.19 | 1431.0 |
| 2020-10-16 05:40:00 | SPY | ETF | 347.15 | 347.35 | 347.15 | 347.35 | 3033.0 |
| 2020-10-16 05:45:00 | SPY | ETF | 347.35 | 347.35 | 347.1 | 347.1 | 3153.0 |
| 2020-10-16 05:50:00 | SPY | ETF | 347.05 | 347.35 | 347.03 | 347.31 | 2495.0 |
| 2020-10-16 05:55:00 | SPY | ETF | 347.37 | 347.53 | 347.37 | 347.53 | 1061.0 |
| 2020-10-16 06:00:00 | SPY | ETF | 347.46 | 347.46 | 347.45 | 347.45 | 600.0 |
| 2020-10-16 06:05:00 | SPY | ETF | 347.34 | 347.47 | 347.34 | 347.44 | 3270.0 |
| 2020-10-16 06:10:00 | SPY | ETF | 347.5 | 347.5 | 347.48 | 347.48 | 257.0 |
| 2020-10-16 06:15:00 | SPY | ETF | 347.46 | 347.64 | 347.46 | 347.59 | 1601.0 |
| 2020-10-16 06:20:00 | SPY | ETF | 347.85 | 347.92 | 347.78 | 347.89 | 1029.0 |
| 2020-10-16 06:25:00 | SPY | ETF | 347.98 | 348.09 | 347.97 | 348.09 | 2027.0 |
| 2020-10-16 06:30:00 | SPY | ETF | 348.19 | 348.19 | 348.03 | 348.14 | 10935.0 |
| 2020-10-16 06:35:00 | SPY | ETF | 348.18 | 348.28 | 348.18 | 348.24 | 2635.0 |
| 2020-10-16 06:40:00 | SPY | ETF | 348.24 | 348.28 | 348.24 | 348.28 | 81605.0 |
| 2020-10-16 06:45:00 | SPY | ETF | 348.28 | 348.28 | 348.07 | 348.07 | 20690.0 |
| 2020-10-16 06:50:00 | SPY | ETF | 348.07 | 348.09 | 347.58 | 347.61 | 22028.0 |
| 2020-10-16 06:55:00 | SPY | ETF | 347.74 | 348.0 | 347.74 | 348.0 | 19093.0 |
| 2020-10-16 07:00:00 | SPY | ETF | 348.02 | 348.02 | 347.78 | 347.88 | 27346.0 |
| 2020-10-16 07:05:00 | SPY | ETF | 347.91 | 348.1 | 347.91 | 348.1 | 3586.0 |
| 2020-10-16 07:10:00 | SPY | ETF | 348.03 | 348.03 | 347.79 | 347.86 | 9653.0 |
| 2020-10-16 07:15:00 | SPY | ETF | 347.82 | 348.14 | 347.82 | 348.05 | 2511.0 |
| 2020-10-16 07:20:00 | SPY | ETF | 348.08 | 348.2 | 348.07 | 348.16 | 43659.0 |
| 2020-10-16 07:25:00 | SPY | ETF | 348.25 | 348.5 | 348.25 | 348.26 | 33178.0 |
| 2020-10-16 07:30:00 | SPY | ETF | 348.27 | 348.53 | 348.27 | 348.46 | 23016.0 |
| 2020-10-16 07:35:00 | SPY | ETF | 348.4 | 348.45 | 348.37 | 348.45 | 7721.0 |
| 2020-10-16 07:40:00 | SPY | ETF | 348.49 | 348.51 | 348.35 | 348.42 | 9656.0 |
| 2020-10-16 07:45:00 | SPY | ETF | 348.52 | 348.6 | 348.48 | 348.6 | 4824.0 |
| 2020-10-16 07:50:00 | SPY | ETF | 348.59 | 348.6 | 348.43 | 348.469 | 14646.0 |
| 2020-10-16 07:55:00 | SPY | ETF | 348.45 | 348.45 | 348.22 | 348.23 | 6237.0 |
| 2020-10-16 08:00:00 | SPY | ETF | 347.7699 | 348.51 | 347.0 | 348.08 | 39639.0 |
| 2020-10-16 08:05:00 | SPY | ETF | 348.2796 | 348.41 | 348.21 | 348.35 | 17502.0 |
| 2020-10-16 08:10:00 | SPY | ETF | 348.32 | 348.32 | 348.21 | 348.21 | 6642.0 |
> showing 50 of 69,746 rows — these rows as CSV