PREVIEW / etf_5min / 2020-10-09
file: by_date/etf_5min/2020/2020-10-09.parquet size: 1.6 MB rows: 73,255
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-09 04:00:00 | SPY | ETF | 345.0 | 345.14 | 344.91 | 345.14 | 9223.0 |
| 2020-10-09 04:05:00 | SPY | ETF | 345.14 | 345.14 | 345.1 | 345.1 | 629.0 |
| 2020-10-09 04:10:00 | SPY | ETF | 344.96 | 344.96 | 344.9 | 344.95 | 930.0 |
| 2020-10-09 04:15:00 | SPY | ETF | 344.9 | 344.93 | 344.9 | 344.93 | 700.0 |
| 2020-10-09 04:20:00 | SPY | ETF | 344.95 | 345.03 | 344.94 | 345.03 | 1500.0 |
| 2020-10-09 04:25:00 | SPY | ETF | 345.03 | 345.05 | 345.0 | 345.0 | 2002.0 |
| 2020-10-09 04:30:00 | SPY | ETF | 345.0 | 345.04 | 344.96 | 344.96 | 11329.0 |
| 2020-10-09 04:35:00 | SPY | ETF | 344.86 | 344.91 | 344.86 | 344.9 | 13202.0 |
| 2020-10-09 04:40:00 | SPY | ETF | 344.86 | 344.91 | 344.85 | 344.91 | 1280.0 |
| 2020-10-09 04:45:00 | SPY | ETF | 344.94 | 344.94 | 344.91 | 344.94 | 1200.0 |
| 2020-10-09 04:50:00 | SPY | ETF | 345.09 | 345.24 | 345.09 | 345.21 | 11457.0 |
| 2020-10-09 04:55:00 | SPY | ETF | 345.28 | 345.3 | 345.04 | 345.04 | 2158.0 |
| 2020-10-09 05:00:00 | SPY | ETF | 345.01 | 345.01 | 344.87 | 344.87 | 4607.0 |
| 2020-10-09 05:05:00 | SPY | ETF | 345.04 | 345.04 | 345.04 | 345.04 | 370.0 |
| 2020-10-09 05:10:00 | SPY | ETF | 344.99 | 345.0 | 344.95 | 344.95 | 2968.0 |
| 2020-10-09 05:15:00 | SPY | ETF | 345.01 | 345.02 | 344.99 | 344.99 | 1500.0 |
| 2020-10-09 05:20:00 | SPY | ETF | 344.97 | 345.05 | 344.94 | 345.02 | 4578.0 |
| 2020-10-09 05:25:00 | SPY | ETF | 345.02 | 345.05 | 345.02 | 345.04 | 1162.0 |
| 2020-10-09 05:30:00 | SPY | ETF | 345.05 | 345.05 | 344.95 | 344.96 | 2071.0 |
| 2020-10-09 05:35:00 | SPY | ETF | 344.97 | 345.02 | 344.97 | 345.02 | 1970.0 |
| 2020-10-09 05:40:00 | SPY | ETF | 345.01 | 345.05 | 345.0 | 345.0 | 1350.0 |
| 2020-10-09 05:45:00 | SPY | ETF | 345.01 | 345.01 | 345.01 | 345.01 | 112.0 |
| 2020-10-09 05:50:00 | SPY | ETF | 345.1 | 345.13 | 345.05 | 345.09 | 1821.0 |
| 2020-10-09 05:55:00 | SPY | ETF | 345.08 | 345.08 | 345.08 | 345.08 | 1220.0 |
| 2020-10-09 06:00:00 | SPY | ETF | 345.06 | 345.1 | 345.05 | 345.05 | 5093.0 |
| 2020-10-09 06:05:00 | SPY | ETF | 345.18 | 345.23 | 345.18 | 345.2 | 1161.0 |
| 2020-10-09 06:10:00 | SPY | ETF | 345.3 | 345.48 | 345.3 | 345.48 | 952.0 |
| 2020-10-09 06:15:00 | SPY | ETF | 345.53 | 345.53 | 345.46 | 345.47 | 1121.0 |
| 2020-10-09 06:20:00 | SPY | ETF | 345.21 | 345.24 | 345.19 | 345.2 | 11210.0 |
| 2020-10-09 06:25:00 | SPY | ETF | 345.2 | 345.2 | 345.2 | 345.2 | 580.0 |
| 2020-10-09 06:30:00 | SPY | ETF | 345.25 | 345.25 | 345.2 | 345.2 | 1220.0 |
| 2020-10-09 06:35:00 | SPY | ETF | 345.19 | 345.29 | 345.15 | 345.15 | 3486.0 |
| 2020-10-09 06:40:00 | SPY | ETF | 345.15 | 345.15 | 345.1 | 345.1 | 596.0 |
| 2020-10-09 06:45:00 | SPY | ETF | 345.05 | 345.05 | 344.95 | 344.95 | 2863.0 |
| 2020-10-09 06:50:00 | SPY | ETF | 344.92 | 344.92 | 344.69 | 344.73 | 14335.0 |
| 2020-10-09 06:55:00 | SPY | ETF | 344.71 | 344.78 | 344.71 | 344.72 | 1714.0 |
| 2020-10-09 07:00:00 | SPY | ETF | 344.7 | 344.88 | 344.65 | 344.81 | 12180.0 |
| 2020-10-09 07:05:00 | SPY | ETF | 344.88 | 345.13 | 344.88 | 345.13 | 9953.0 |
| 2020-10-09 07:10:00 | SPY | ETF | 345.12 | 345.12 | 345.05 | 345.06 | 12311.0 |
| 2020-10-09 07:15:00 | SPY | ETF | 345.06 | 345.16 | 345.06 | 345.13 | 16795.0 |
| 2020-10-09 07:20:00 | SPY | ETF | 345.16 | 345.35 | 345.15 | 345.35 | 14795.0 |
| 2020-10-09 07:25:00 | SPY | ETF | 345.33 | 345.34 | 345.3 | 345.3 | 12011.0 |
| 2020-10-09 07:30:00 | SPY | ETF | 345.35 | 345.45 | 345.35 | 345.44 | 8335.0 |
| 2020-10-09 07:35:00 | SPY | ETF | 345.43 | 345.45 | 345.4 | 345.4 | 4026.0 |
| 2020-10-09 07:40:00 | SPY | ETF | 345.4 | 345.4 | 345.26 | 345.26 | 8694.0 |
| 2020-10-09 07:45:00 | SPY | ETF | 345.28 | 345.28 | 345.27 | 345.27 | 1912.0 |
| 2020-10-09 07:50:00 | SPY | ETF | 345.31 | 345.31 | 345.26 | 345.3 | 6099.0 |
| 2020-10-09 07:55:00 | SPY | ETF | 345.3 | 345.33 | 345.19 | 345.23 | 18947.0 |
| 2020-10-09 08:00:00 | SPY | ETF | 345.21 | 345.96 | 343.78 | 345.15 | 30671.0 |
| 2020-10-09 08:05:00 | SPY | ETF | 345.24 | 345.28 | 345.2 | 345.21 | 20278.0 |
> showing 50 of 73,255 rows — these rows as CSV