PREVIEW / etf_5min / 2020-10-08
file: by_date/etf_5min/2020/2020-10-08.parquet size: 1.6 MB rows: 71,985
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-08 04:00:00 | SPY | ETF | 342.7 | 342.7 | 342.44 | 342.45 | 6165.0 |
| 2020-10-08 04:05:00 | SPY | ETF | 342.49 | 342.49 | 342.32 | 342.32 | 3169.0 |
| 2020-10-08 04:10:00 | SPY | ETF | 342.3 | 342.3 | 342.18 | 342.22 | 5852.0 |
| 2020-10-08 04:15:00 | SPY | ETF | 342.25 | 342.3 | 342.18 | 342.18 | 2533.0 |
| 2020-10-08 04:20:00 | SPY | ETF | 342.02 | 342.05 | 341.97 | 342.01 | 5237.0 |
| 2020-10-08 04:25:00 | SPY | ETF | 342.0 | 342.0 | 341.53 | 341.53 | 6828.0 |
| 2020-10-08 04:30:00 | SPY | ETF | 341.58 | 341.85 | 341.58 | 341.78 | 1734.0 |
| 2020-10-08 04:35:00 | SPY | ETF | 341.68 | 341.94 | 341.64 | 341.94 | 2182.0 |
| 2020-10-08 04:40:00 | SPY | ETF | 342.07 | 342.1 | 342.0 | 342.1 | 1272.0 |
| 2020-10-08 04:45:00 | SPY | ETF | 342.03 | 342.05 | 342.03 | 342.05 | 622.0 |
| 2020-10-08 04:50:00 | SPY | ETF | 342.08 | 342.08 | 342.08 | 342.08 | 500.0 |
| 2020-10-08 04:55:00 | SPY | ETF | 342.16 | 342.16 | 342.16 | 342.16 | 146.0 |
| 2020-10-08 05:00:00 | SPY | ETF | 342.16 | 342.16 | 342.16 | 342.16 | 101.0 |
| 2020-10-08 05:05:00 | SPY | ETF | 342.12 | 342.14 | 342.03 | 342.12 | 5801.0 |
| 2020-10-08 05:15:00 | SPY | ETF | 342.11 | 342.11 | 342.05 | 342.05 | 1202.0 |
| 2020-10-08 05:20:00 | SPY | ETF | 342.14 | 342.2 | 342.14 | 342.2 | 713.0 |
| 2020-10-08 05:25:00 | SPY | ETF | 342.14 | 342.15 | 342.05 | 342.05 | 2346.0 |
| 2020-10-08 05:30:00 | SPY | ETF | 342.06 | 342.07 | 341.94 | 341.94 | 1050.0 |
| 2020-10-08 05:35:00 | SPY | ETF | 342.0 | 342.0 | 341.95 | 341.95 | 812.0 |
| 2020-10-08 05:40:00 | SPY | ETF | 341.9 | 341.9 | 341.85 | 341.85 | 1046.0 |
| 2020-10-08 05:45:00 | SPY | ETF | 341.9 | 341.95 | 341.9 | 341.9 | 1810.0 |
| 2020-10-08 05:50:00 | SPY | ETF | 341.9 | 341.9 | 341.72 | 341.9 | 1715.0 |
| 2020-10-08 05:55:00 | SPY | ETF | 341.91 | 341.91 | 341.86 | 341.86 | 601.0 |
| 2020-10-08 06:00:00 | SPY | ETF | 341.85 | 342.08 | 341.85 | 342.08 | 719.0 |
| 2020-10-08 06:05:00 | SPY | ETF | 342.14 | 342.2 | 342.05 | 342.2 | 2651.0 |
| 2020-10-08 06:10:00 | SPY | ETF | 342.2 | 342.21 | 342.12 | 342.12 | 4126.0 |
| 2020-10-08 06:15:00 | SPY | ETF | 342.1 | 342.1 | 342.1 | 342.1 | 267.0 |
| 2020-10-08 06:20:00 | SPY | ETF | 342.04 | 342.04 | 342.04 | 342.04 | 110.0 |
| 2020-10-08 06:25:00 | SPY | ETF | 342.15 | 342.15 | 342.15 | 342.15 | 110.0 |
| 2020-10-08 06:30:00 | SPY | ETF | 342.17 | 342.45 | 342.17 | 342.4 | 12722.0 |
| 2020-10-08 06:35:00 | SPY | ETF | 342.38 | 342.42 | 342.38 | 342.42 | 242.0 |
| 2020-10-08 06:40:00 | SPY | ETF | 342.35 | 342.35 | 342.33 | 342.33 | 575.0 |
| 2020-10-08 06:45:00 | SPY | ETF | 342.34 | 343.0 | 342.2 | 342.28 | 30253.0 |
| 2020-10-08 06:50:00 | SPY | ETF | 342.3 | 342.35 | 342.15 | 342.15 | 1748.0 |
| 2020-10-08 06:55:00 | SPY | ETF | 342.17 | 342.17 | 342.0 | 342.04 | 1966.0 |
| 2020-10-08 07:00:00 | SPY | ETF | 342.0 | 342.18 | 341.94 | 342.1 | 65298.0 |
| 2020-10-08 07:05:00 | SPY | ETF | 342.1 | 342.15 | 342.08 | 342.08 | 56488.0 |
| 2020-10-08 07:10:00 | SPY | ETF | 342.0 | 342.21 | 342.0 | 342.19 | 6527.0 |
| 2020-10-08 07:15:00 | SPY | ETF | 342.2 | 342.24 | 342.06 | 342.16 | 5265.0 |
| 2020-10-08 07:20:00 | SPY | ETF | 342.2 | 342.3 | 342.16 | 342.26 | 18071.0 |
| 2020-10-08 07:25:00 | SPY | ETF | 342.18 | 342.24 | 342.18 | 342.24 | 2948.0 |
| 2020-10-08 07:30:00 | SPY | ETF | 342.22 | 342.24 | 341.84 | 341.84 | 20659.0 |
| 2020-10-08 07:35:00 | SPY | ETF | 341.88 | 342.22 | 341.81 | 342.21 | 13984.0 |
| 2020-10-08 07:40:00 | SPY | ETF | 342.17 | 342.22 | 342.1 | 342.22 | 5826.0 |
| 2020-10-08 07:45:00 | SPY | ETF | 342.25 | 342.25 | 342.1 | 342.21 | 5988.0 |
| 2020-10-08 07:50:00 | SPY | ETF | 342.19 | 342.31 | 342.14 | 342.2 | 17621.0 |
| 2020-10-08 07:55:00 | SPY | ETF | 342.19 | 342.23 | 342.19 | 342.21 | 5349.0 |
| 2020-10-08 08:00:00 | SPY | ETF | 342.21 | 343.06 | 341.95 | 342.12 | 34218.0 |
| 2020-10-08 08:05:00 | SPY | ETF | 342.19 | 342.38 | 342.19 | 342.38 | 11269.0 |
| 2020-10-08 08:10:00 | SPY | ETF | 342.33 | 343.06 | 342.33 | 342.76 | 151991.0 |
> showing 50 of 71,985 rows — these rows as CSV