PREVIEW / etf_5min / 2020-07-15
file: by_date/etf_5min/2020/2020-07-15.parquet size: 1.6 MB rows: 76,916
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-15 04:00:00 | SPY | ETF | 320.68 | 320.87 | 320.68 | 320.81 | 2156.0 |
| 2020-07-15 04:05:00 | SPY | ETF | 320.88 | 320.91 | 320.79 | 320.84 | 8842.0 |
| 2020-07-15 04:10:00 | SPY | ETF | 320.89 | 321.08 | 320.89 | 321.08 | 879.0 |
| 2020-07-15 04:15:00 | SPY | ETF | 320.76 | 320.79 | 320.76 | 320.78 | 2380.0 |
| 2020-07-15 04:20:00 | SPY | ETF | 320.83 | 320.83 | 320.78 | 320.78 | 220.0 |
| 2020-07-15 04:25:00 | SPY | ETF | 320.56 | 320.71 | 320.46 | 320.71 | 1130.0 |
| 2020-07-15 04:30:00 | SPY | ETF | 320.99 | 321.07 | 320.88 | 320.88 | 2664.0 |
| 2020-07-15 04:35:00 | SPY | ETF | 320.89 | 320.89 | 320.89 | 320.89 | 200.0 |
| 2020-07-15 04:40:00 | SPY | ETF | 320.6 | 320.6 | 320.6 | 320.6 | 185.0 |
| 2020-07-15 04:45:00 | SPY | ETF | 320.57 | 320.57 | 320.52 | 320.54 | 1427.0 |
| 2020-07-15 04:50:00 | SPY | ETF | 320.48 | 320.61 | 320.45 | 320.61 | 595.0 |
| 2020-07-15 04:55:00 | SPY | ETF | 320.56 | 320.58 | 320.56 | 320.58 | 337.0 |
| 2020-07-15 05:00:00 | SPY | ETF | 320.4 | 320.42 | 320.2 | 320.41 | 7330.0 |
| 2020-07-15 05:05:00 | SPY | ETF | 320.28 | 320.31 | 320.11 | 320.31 | 2126.0 |
| 2020-07-15 05:10:00 | SPY | ETF | 320.39 | 320.39 | 320.39 | 320.39 | 312.0 |
| 2020-07-15 05:15:00 | SPY | ETF | 320.29 | 320.46 | 320.27 | 320.44 | 2483.0 |
| 2020-07-15 05:20:00 | SPY | ETF | 320.4 | 320.58 | 320.4 | 320.56 | 2068.0 |
| 2020-07-15 05:25:00 | SPY | ETF | 320.54 | 320.54 | 320.39 | 320.39 | 3106.0 |
| 2020-07-15 05:30:00 | SPY | ETF | 320.2 | 320.29 | 320.2 | 320.25 | 645.0 |
| 2020-07-15 05:35:00 | SPY | ETF | 320.34 | 320.34 | 320.3 | 320.3 | 890.0 |
| 2020-07-15 05:40:00 | SPY | ETF | 320.38 | 320.39 | 320.28 | 320.28 | 31762.0 |
| 2020-07-15 05:45:00 | SPY | ETF | 320.28 | 320.45 | 320.25 | 320.45 | 25898.0 |
| 2020-07-15 05:50:00 | SPY | ETF | 320.22 | 320.22 | 320.11 | 320.21 | 8095.0 |
| 2020-07-15 05:55:00 | SPY | ETF | 320.4 | 320.4 | 320.22 | 320.22 | 2505.0 |
| 2020-07-15 06:00:00 | SPY | ETF | 320.25 | 320.35 | 320.15 | 320.35 | 2210.0 |
| 2020-07-15 06:05:00 | SPY | ETF | 320.37 | 320.42 | 320.25 | 320.42 | 6700.0 |
| 2020-07-15 06:10:00 | SPY | ETF | 320.4 | 321.17 | 320.4 | 321.05 | 20051.0 |
| 2020-07-15 06:15:00 | SPY | ETF | 321.01 | 321.12 | 320.97 | 321.12 | 6407.0 |
| 2020-07-15 06:20:00 | SPY | ETF | 321.09 | 321.37 | 321.01 | 321.01 | 12211.0 |
| 2020-07-15 06:25:00 | SPY | ETF | 321.03 | 321.3 | 320.97 | 321.27 | 15763.0 |
| 2020-07-15 06:30:00 | SPY | ETF | 321.4 | 321.64 | 321.31 | 321.32 | 10366.0 |
| 2020-07-15 06:35:00 | SPY | ETF | 321.43 | 321.55 | 321.43 | 321.44 | 33957.0 |
| 2020-07-15 06:40:00 | SPY | ETF | 321.58 | 321.59 | 321.46 | 321.49 | 1871.0 |
| 2020-07-15 06:45:00 | SPY | ETF | 321.54 | 321.76 | 321.54 | 321.74 | 5129.0 |
| 2020-07-15 06:50:00 | SPY | ETF | 321.74 | 321.93 | 321.71 | 321.93 | 7427.0 |
| 2020-07-15 06:55:00 | SPY | ETF | 321.91 | 322.23 | 321.88 | 322.01 | 24801.0 |
| 2020-07-15 07:00:00 | SPY | ETF | 322.04 | 322.33 | 321.9 | 322.25 | 44801.0 |
| 2020-07-15 07:05:00 | SPY | ETF | 322.25 | 322.62 | 322.09 | 322.43 | 85485.0 |
| 2020-07-15 07:10:00 | SPY | ETF | 322.43 | 322.88 | 322.4 | 322.84 | 144302.0 |
| 2020-07-15 07:15:00 | SPY | ETF | 322.77 | 322.77 | 322.3 | 322.33 | 45586.0 |
| 2020-07-15 07:20:00 | SPY | ETF | 322.33 | 322.71 | 322.33 | 322.38 | 107588.0 |
| 2020-07-15 07:25:00 | SPY | ETF | 322.46 | 322.6 | 322.43 | 322.55 | 15943.0 |
| 2020-07-15 07:30:00 | SPY | ETF | 322.55 | 322.64 | 322.35 | 322.53 | 141782.0 |
| 2020-07-15 07:35:00 | SPY | ETF | 322.59 | 322.81 | 322.45 | 322.47 | 55766.0 |
| 2020-07-15 07:40:00 | SPY | ETF | 322.54 | 322.78 | 322.41 | 322.78 | 10240.0 |
| 2020-07-15 07:45:00 | SPY | ETF | 322.72 | 322.72 | 322.54 | 322.55 | 13627.0 |
| 2020-07-15 07:50:00 | SPY | ETF | 322.64 | 322.8 | 322.62 | 322.74 | 36027.0 |
| 2020-07-15 07:55:00 | SPY | ETF | 322.69 | 322.83 | 322.65 | 322.76 | 17851.0 |
| 2020-07-15 08:00:00 | SPY | ETF | 322.4801 | 322.98 | 320.4 | 321.23 | 176261.0 |
| 2020-07-15 08:05:00 | SPY | ETF | 322.87 | 323.04 | 322.78 | 322.9 | 57736.0 |
> showing 50 of 76,916 rows — these rows as CSV