PREVIEW / etf_5min / 2020-07-28
file: by_date/etf_5min/2020/2020-07-28.parquet size: 1.5 MB rows: 71,250
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-28 04:00:00 | SPY | ETF | 323.4 | 323.41 | 323.28 | 323.32 | 4164.0 |
| 2020-07-28 04:05:00 | SPY | ETF | 323.32 | 323.39 | 323.21 | 323.32 | 1005.0 |
| 2020-07-28 04:10:00 | SPY | ETF | 323.22 | 323.23 | 323.18 | 323.18 | 4680.0 |
| 2020-07-28 04:15:00 | SPY | ETF | 323.22 | 323.27 | 323.19 | 323.25 | 1105.0 |
| 2020-07-28 04:20:00 | SPY | ETF | 323.25 | 323.25 | 323.09 | 323.09 | 1523.0 |
| 2020-07-28 04:25:00 | SPY | ETF | 323.09 | 323.28 | 323.08 | 323.22 | 4751.0 |
| 2020-07-28 04:30:00 | SPY | ETF | 323.2 | 323.31 | 323.18 | 323.31 | 1978.0 |
| 2020-07-28 04:35:00 | SPY | ETF | 323.34 | 323.34 | 323.33 | 323.33 | 500.0 |
| 2020-07-28 04:45:00 | SPY | ETF | 323.25 | 323.32 | 323.25 | 323.31 | 3049.0 |
| 2020-07-28 04:50:00 | SPY | ETF | 323.48 | 323.48 | 323.42 | 323.46 | 1050.0 |
| 2020-07-28 04:55:00 | SPY | ETF | 323.46 | 323.46 | 323.4 | 323.4 | 629.0 |
| 2020-07-28 05:00:00 | SPY | ETF | 323.53 | 323.6 | 323.53 | 323.56 | 9259.0 |
| 2020-07-28 05:10:00 | SPY | ETF | 323.57 | 323.57 | 323.54 | 323.55 | 3500.0 |
| 2020-07-28 05:15:00 | SPY | ETF | 323.52 | 323.52 | 323.52 | 323.52 | 150.0 |
| 2020-07-28 05:20:00 | SPY | ETF | 323.3 | 323.3 | 323.09 | 323.09 | 3798.0 |
| 2020-07-28 05:25:00 | SPY | ETF | 323.17 | 323.2 | 323.17 | 323.2 | 525.0 |
| 2020-07-28 05:30:00 | SPY | ETF | 323.1 | 323.19 | 323.1 | 323.19 | 230.0 |
| 2020-07-28 05:40:00 | SPY | ETF | 323.2 | 323.2 | 323.08 | 323.08 | 3206.0 |
| 2020-07-28 05:45:00 | SPY | ETF | 323.07 | 323.1 | 323.0 | 323.0 | 2926.0 |
| 2020-07-28 05:50:00 | SPY | ETF | 322.96 | 322.96 | 322.36 | 322.36 | 16537.0 |
| 2020-07-28 05:55:00 | SPY | ETF | 322.46 | 322.46 | 322.12 | 322.4 | 11590.0 |
| 2020-07-28 06:00:00 | SPY | ETF | 322.44 | 322.44 | 322.27 | 322.27 | 729.0 |
| 2020-07-28 06:05:00 | SPY | ETF | 322.15 | 322.2 | 321.79 | 321.92 | 21737.0 |
| 2020-07-28 06:10:00 | SPY | ETF | 321.95 | 322.11 | 321.9 | 322.09 | 21501.0 |
| 2020-07-28 06:15:00 | SPY | ETF | 322.05 | 322.18 | 322.04 | 322.18 | 1240.0 |
| 2020-07-28 06:20:00 | SPY | ETF | 322.15 | 322.32 | 322.15 | 322.31 | 10771.0 |
| 2020-07-28 06:25:00 | SPY | ETF | 322.23 | 322.31 | 322.21 | 322.31 | 3735.0 |
| 2020-07-28 06:30:00 | SPY | ETF | 322.3 | 322.33 | 322.3 | 322.33 | 591.0 |
| 2020-07-28 06:35:00 | SPY | ETF | 322.4 | 322.48 | 322.36 | 322.48 | 9970.0 |
| 2020-07-28 06:40:00 | SPY | ETF | 322.46 | 322.46 | 322.43 | 322.43 | 402.0 |
| 2020-07-28 06:45:00 | SPY | ETF | 322.42 | 322.58 | 322.42 | 322.51 | 3900.0 |
| 2020-07-28 06:50:00 | SPY | ETF | 322.5 | 322.5 | 322.5 | 322.5 | 442.0 |
| 2020-07-28 06:55:00 | SPY | ETF | 322.63 | 322.71 | 322.63 | 322.67 | 2785.0 |
| 2020-07-28 07:00:00 | SPY | ETF | 322.68 | 322.81 | 322.68 | 322.73 | 4620.0 |
| 2020-07-28 07:05:00 | SPY | ETF | 322.75 | 322.84 | 322.72 | 322.73 | 15574.0 |
| 2020-07-28 07:10:00 | SPY | ETF | 322.7 | 322.71 | 322.47 | 322.55 | 10086.0 |
| 2020-07-28 07:15:00 | SPY | ETF | 322.54 | 322.54 | 322.0 | 322.05 | 28983.0 |
| 2020-07-28 07:20:00 | SPY | ETF | 321.98 | 322.11 | 321.9 | 322.05 | 47192.0 |
| 2020-07-28 07:25:00 | SPY | ETF | 322.13 | 322.17 | 322.03 | 322.03 | 8400.0 |
| 2020-07-28 07:30:00 | SPY | ETF | 322.0 | 322.02 | 321.72 | 321.82 | 26656.0 |
| 2020-07-28 07:35:00 | SPY | ETF | 321.79 | 321.79 | 321.59 | 321.78 | 9457.0 |
| 2020-07-28 07:40:00 | SPY | ETF | 321.82 | 322.03 | 321.76 | 322.03 | 18895.0 |
| 2020-07-28 07:45:00 | SPY | ETF | 322.01 | 322.12 | 321.9 | 322.12 | 3471.0 |
| 2020-07-28 07:50:00 | SPY | ETF | 322.1 | 322.12 | 322.0 | 322.07 | 4439.0 |
| 2020-07-28 07:55:00 | SPY | ETF | 322.08 | 322.1 | 321.98 | 321.98 | 9342.0 |
| 2020-07-28 08:00:00 | SPY | ETF | 322.0 | 323.7 | 321.59 | 322.05 | 49919.0 |
| 2020-07-28 08:05:00 | SPY | ETF | 322.01 | 322.13 | 321.83 | 322.11 | 32664.0 |
| 2020-07-28 08:10:00 | SPY | ETF | 322.1 | 322.22 | 322.01 | 322.22 | 10393.0 |
| 2020-07-28 08:15:00 | SPY | ETF | 322.17 | 322.2 | 321.93 | 321.99 | 16340.0 |
| 2020-07-28 08:20:00 | SPY | ETF | 322.01 | 322.05 | 321.94 | 322.01 | 11737.0 |
> showing 50 of 71,250 rows — these rows as CSV