PREVIEW / etf_5min / 2020-10-01
file: by_date/etf_5min/2020/2020-10-01.parquet size: 1.6 MB rows: 74,793
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-01 04:00:00 | SPY | ETF | 337.66 | 337.78 | 337.31 | 337.43 | 17743.0 |
| 2020-10-01 04:05:00 | SPY | ETF | 337.5 | 337.74 | 337.48 | 337.7 | 31639.0 |
| 2020-10-01 04:10:00 | SPY | ETF | 337.7 | 338.0 | 337.7 | 337.99 | 5112.0 |
| 2020-10-01 04:15:00 | SPY | ETF | 337.93 | 338.08 | 337.93 | 337.99 | 12753.0 |
| 2020-10-01 04:20:00 | SPY | ETF | 338.02 | 338.02 | 337.88 | 337.89 | 5270.0 |
| 2020-10-01 04:25:00 | SPY | ETF | 337.85 | 337.85 | 337.64 | 337.64 | 6573.0 |
| 2020-10-01 04:30:00 | SPY | ETF | 337.35 | 337.35 | 337.0 | 337.0 | 7495.0 |
| 2020-10-01 04:35:00 | SPY | ETF | 337.0 | 337.14 | 336.68 | 336.81 | 8720.0 |
| 2020-10-01 04:40:00 | SPY | ETF | 336.7 | 337.05 | 336.65 | 336.82 | 13577.0 |
| 2020-10-01 04:45:00 | SPY | ETF | 336.89 | 336.99 | 336.89 | 336.97 | 4122.0 |
| 2020-10-01 04:50:00 | SPY | ETF | 336.92 | 337.12 | 336.82 | 337.1 | 5033.0 |
| 2020-10-01 04:55:00 | SPY | ETF | 337.12 | 337.12 | 336.94 | 336.94 | 10801.0 |
| 2020-10-01 05:00:00 | SPY | ETF | 336.89 | 337.17 | 336.88 | 337.17 | 5411.0 |
| 2020-10-01 05:05:00 | SPY | ETF | 337.16 | 337.35 | 337.16 | 337.35 | 7321.0 |
| 2020-10-01 05:10:00 | SPY | ETF | 337.46 | 337.54 | 337.4 | 337.41 | 4100.0 |
| 2020-10-01 05:15:00 | SPY | ETF | 337.44 | 337.55 | 337.39 | 337.55 | 4266.0 |
| 2020-10-01 05:20:00 | SPY | ETF | 337.58 | 337.67 | 337.58 | 337.64 | 5806.0 |
| 2020-10-01 05:25:00 | SPY | ETF | 337.54 | 337.8 | 337.54 | 337.8 | 8830.0 |
| 2020-10-01 05:30:00 | SPY | ETF | 337.84 | 337.92 | 337.73 | 337.75 | 3033.0 |
| 2020-10-01 05:35:00 | SPY | ETF | 337.76 | 338.07 | 337.76 | 338.07 | 4973.0 |
| 2020-10-01 05:40:00 | SPY | ETF | 338.08 | 338.38 | 338.08 | 338.21 | 9097.0 |
| 2020-10-01 05:45:00 | SPY | ETF | 338.27 | 338.3 | 338.2 | 338.25 | 5918.0 |
| 2020-10-01 05:50:00 | SPY | ETF | 338.25 | 338.25 | 338.05 | 338.05 | 10354.0 |
| 2020-10-01 05:55:00 | SPY | ETF | 338.07 | 338.31 | 338.07 | 338.29 | 3830.0 |
| 2020-10-01 06:00:00 | SPY | ETF | 338.34 | 338.55 | 338.33 | 338.47 | 7551.0 |
| 2020-10-01 06:05:00 | SPY | ETF | 338.48 | 338.6 | 338.19 | 338.22 | 18018.0 |
| 2020-10-01 06:10:00 | SPY | ETF | 338.28 | 338.29 | 337.9 | 337.92 | 4911.0 |
| 2020-10-01 06:15:00 | SPY | ETF | 337.92 | 337.95 | 337.85 | 337.91 | 34020.0 |
| 2020-10-01 06:20:00 | SPY | ETF | 337.94 | 338.05 | 337.89 | 338.01 | 60857.0 |
| 2020-10-01 06:25:00 | SPY | ETF | 338.06 | 338.49 | 338.03 | 338.26 | 6983.0 |
| 2020-10-01 06:30:00 | SPY | ETF | 338.22 | 338.22 | 338.06 | 338.07 | 4547.0 |
| 2020-10-01 06:35:00 | SPY | ETF | 338.03 | 338.05 | 337.9 | 338.02 | 4788.0 |
| 2020-10-01 06:40:00 | SPY | ETF | 338.08 | 338.15 | 338.06 | 338.09 | 7670.0 |
| 2020-10-01 06:45:00 | SPY | ETF | 338.22 | 338.22 | 338.06 | 338.2 | 5470.0 |
| 2020-10-01 06:50:00 | SPY | ETF | 338.07 | 338.1 | 337.85 | 337.96 | 7272.0 |
| 2020-10-01 06:55:00 | SPY | ETF | 338.02 | 338.2 | 338.02 | 338.12 | 11890.0 |
| 2020-10-01 07:00:00 | SPY | ETF | 338.05 | 338.19 | 337.98 | 338.03 | 21957.0 |
| 2020-10-01 07:05:00 | SPY | ETF | 338.04 | 338.24 | 338.01 | 338.04 | 13647.0 |
| 2020-10-01 07:10:00 | SPY | ETF | 338.071 | 338.31 | 338.0 | 338.31 | 29406.0 |
| 2020-10-01 07:15:00 | SPY | ETF | 338.3 | 338.47 | 338.28 | 338.32 | 9658.0 |
| 2020-10-01 07:20:00 | SPY | ETF | 338.32 | 338.32 | 338.04 | 338.07 | 11346.0 |
| 2020-10-01 07:25:00 | SPY | ETF | 338.1 | 338.38 | 338.1 | 338.31 | 18158.0 |
| 2020-10-01 07:30:00 | SPY | ETF | 338.36 | 338.47 | 338.33 | 338.46 | 24441.0 |
| 2020-10-01 07:35:00 | SPY | ETF | 338.42 | 338.42 | 338.27 | 338.41 | 21264.0 |
| 2020-10-01 07:40:00 | SPY | ETF | 338.37 | 338.37 | 338.19 | 338.24 | 11503.0 |
| 2020-10-01 07:45:00 | SPY | ETF | 338.4 | 338.41 | 338.2 | 338.26 | 19135.0 |
| 2020-10-01 07:50:00 | SPY | ETF | 338.18 | 338.45 | 338.18 | 338.45 | 13487.0 |
| 2020-10-01 07:55:00 | SPY | ETF | 338.43 | 338.72 | 338.41 | 338.47 | 107059.0 |
| 2020-10-01 08:00:00 | SPY | ETF | 338.3099 | 338.64 | 337.09 | 338.37 | 64314.0 |
| 2020-10-01 08:05:00 | SPY | ETF | 338.3 | 338.31 | 334.89 | 338.01 | 45093.0 |
> showing 50 of 74,793 rows — these rows as CSV