PREVIEW / etf_5min / 2020-07-30
file: by_date/etf_5min/2020/2020-07-30.parquet size: 1.6 MB rows: 75,211
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-07-30 04:00:00 | SPY | ETF | 323.0 | 323.0 | 322.59 | 322.92 | 20553.0 |
| 2020-07-30 04:05:00 | SPY | ETF | 322.99 | 322.99 | 322.58 | 322.69 | 12477.0 |
| 2020-07-30 04:10:00 | SPY | ETF | 322.66 | 322.66 | 322.61 | 322.63 | 1814.0 |
| 2020-07-30 04:20:00 | SPY | ETF | 322.74 | 322.74 | 322.66 | 322.66 | 2873.0 |
| 2020-07-30 04:25:00 | SPY | ETF | 322.62 | 322.62 | 322.32 | 322.39 | 4744.0 |
| 2020-07-30 04:30:00 | SPY | ETF | 322.39 | 322.49 | 322.34 | 322.34 | 8534.0 |
| 2020-07-30 04:35:00 | SPY | ETF | 322.44 | 322.47 | 322.32 | 322.32 | 6933.0 |
| 2020-07-30 04:40:00 | SPY | ETF | 322.27 | 322.3 | 322.2 | 322.24 | 3488.0 |
| 2020-07-30 04:45:00 | SPY | ETF | 322.16 | 322.28 | 322.16 | 322.28 | 257.0 |
| 2020-07-30 04:50:00 | SPY | ETF | 322.24 | 322.24 | 322.18 | 322.18 | 1205.0 |
| 2020-07-30 04:55:00 | SPY | ETF | 322.16 | 322.16 | 321.71 | 321.71 | 7961.0 |
| 2020-07-30 05:00:00 | SPY | ETF | 321.66 | 322.0 | 321.61 | 321.82 | 6278.0 |
| 2020-07-30 05:05:00 | SPY | ETF | 321.85 | 322.06 | 321.85 | 322.06 | 5574.0 |
| 2020-07-30 05:10:00 | SPY | ETF | 322.08 | 322.35 | 321.85 | 322.28 | 4664.0 |
| 2020-07-30 05:15:00 | SPY | ETF | 322.28 | 322.28 | 322.24 | 322.24 | 400.0 |
| 2020-07-30 05:20:00 | SPY | ETF | 322.25 | 322.45 | 322.18 | 322.45 | 3323.0 |
| 2020-07-30 05:25:00 | SPY | ETF | 322.42 | 322.48 | 322.36 | 322.4 | 3752.0 |
| 2020-07-30 05:30:00 | SPY | ETF | 322.55 | 322.8 | 322.55 | 322.8 | 3106.0 |
| 2020-07-30 05:35:00 | SPY | ETF | 322.71 | 322.82 | 322.71 | 322.81 | 3926.0 |
| 2020-07-30 05:40:00 | SPY | ETF | 322.99 | 323.0 | 322.83 | 322.83 | 4256.0 |
| 2020-07-30 05:45:00 | SPY | ETF | 322.9 | 322.9 | 322.78 | 322.81 | 2810.0 |
| 2020-07-30 05:50:00 | SPY | ETF | 322.85 | 322.9 | 322.78 | 322.78 | 2515.0 |
| 2020-07-30 05:55:00 | SPY | ETF | 322.8 | 322.8 | 322.57 | 322.63 | 2150.0 |
| 2020-07-30 06:00:00 | SPY | ETF | 322.6 | 322.6 | 322.4 | 322.4 | 1889.0 |
| 2020-07-30 06:05:00 | SPY | ETF | 322.32 | 322.41 | 322.28 | 322.35 | 3690.0 |
| 2020-07-30 06:10:00 | SPY | ETF | 322.36 | 322.61 | 322.33 | 322.61 | 3211.0 |
| 2020-07-30 06:15:00 | SPY | ETF | 322.58 | 322.61 | 322.4 | 322.51 | 6281.0 |
| 2020-07-30 06:20:00 | SPY | ETF | 322.5 | 322.63 | 322.48 | 322.61 | 2138.0 |
| 2020-07-30 06:25:00 | SPY | ETF | 322.56 | 322.57 | 322.33 | 322.33 | 2275.0 |
| 2020-07-30 06:30:00 | SPY | ETF | 322.36 | 322.36 | 322.22 | 322.34 | 1022.0 |
| 2020-07-30 06:35:00 | SPY | ETF | 322.34 | 322.34 | 322.22 | 322.22 | 5296.0 |
| 2020-07-30 06:40:00 | SPY | ETF | 322.19 | 322.19 | 322.0 | 322.02 | 18959.0 |
| 2020-07-30 06:45:00 | SPY | ETF | 321.98 | 321.98 | 321.76 | 321.76 | 17456.0 |
| 2020-07-30 06:50:00 | SPY | ETF | 321.73 | 321.73 | 321.58 | 321.59 | 20006.0 |
| 2020-07-30 06:55:00 | SPY | ETF | 321.56 | 321.61 | 321.21 | 321.61 | 17405.0 |
| 2020-07-30 07:00:00 | SPY | ETF | 321.67 | 322.02 | 321.56 | 322.02 | 83401.0 |
| 2020-07-30 07:05:00 | SPY | ETF | 322.05 | 322.18 | 321.9 | 321.91 | 39666.0 |
| 2020-07-30 07:10:00 | SPY | ETF | 321.88 | 322.22 | 321.81 | 322.14 | 28448.0 |
| 2020-07-30 07:15:00 | SPY | ETF | 322.13 | 322.39 | 322.08 | 322.3 | 42925.0 |
| 2020-07-30 07:20:00 | SPY | ETF | 322.26 | 322.29 | 322.1 | 322.13 | 110161.0 |
| 2020-07-30 07:25:00 | SPY | ETF | 322.15 | 322.24 | 322.1 | 322.1 | 28049.0 |
| 2020-07-30 07:30:00 | SPY | ETF | 322.14 | 322.32 | 322.1 | 322.16 | 23943.0 |
| 2020-07-30 07:35:00 | SPY | ETF | 322.17 | 322.3 | 322.13 | 322.2 | 23403.0 |
| 2020-07-30 07:40:00 | SPY | ETF | 322.23 | 322.57 | 322.23 | 322.48 | 20731.0 |
| 2020-07-30 07:45:00 | SPY | ETF | 322.56 | 322.64 | 322.51 | 322.61 | 93174.0 |
| 2020-07-30 07:50:00 | SPY | ETF | 322.67 | 322.95 | 322.67 | 322.91 | 41124.0 |
| 2020-07-30 07:55:00 | SPY | ETF | 322.92 | 322.92 | 322.78 | 322.86 | 29053.0 |
| 2020-07-30 08:00:00 | SPY | ETF | 322.0301 | 324.85 | 321.3996 | 322.75 | 167773.0 |
| 2020-07-30 08:05:00 | SPY | ETF | 322.75 | 322.78 | 322.61 | 322.66 | 66201.0 |
| 2020-07-30 08:10:00 | SPY | ETF | 322.66 | 324.75 | 322.51 | 322.58 | 83837.0 |
> showing 50 of 75,211 rows — these rows as CSV