PREVIEW / etf_5min / 2020-05-28
file: by_date/etf_5min/2020/2020-05-28.parquet size: 1.7 MB rows: 76,663
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-05-28 04:00:00 | SPY | ETF | 304.8 | 305.01 | 304.67 | 304.9 | 8462.0 |
| 2020-05-28 04:05:00 | SPY | ETF | 304.9 | 304.9 | 304.66 | 304.75 | 8903.0 |
| 2020-05-28 04:10:00 | SPY | ETF | 304.61 | 305.05 | 304.6 | 305.05 | 11677.0 |
| 2020-05-28 04:15:00 | SPY | ETF | 305.05 | 305.05 | 304.58 | 304.65 | 3171.0 |
| 2020-05-28 04:20:00 | SPY | ETF | 304.43 | 304.46 | 304.3 | 304.31 | 14604.0 |
| 2020-05-28 04:25:00 | SPY | ETF | 304.3 | 304.4 | 304.0 | 304.12 | 11063.0 |
| 2020-05-28 04:30:00 | SPY | ETF | 304.12 | 304.12 | 303.85 | 303.9 | 3767.0 |
| 2020-05-28 04:35:00 | SPY | ETF | 304.01 | 304.26 | 303.93 | 304.25 | 14655.0 |
| 2020-05-28 04:40:00 | SPY | ETF | 304.28 | 304.35 | 304.2 | 304.35 | 11710.0 |
| 2020-05-28 04:45:00 | SPY | ETF | 304.22 | 304.32 | 304.22 | 304.3 | 3810.0 |
| 2020-05-28 04:50:00 | SPY | ETF | 304.32 | 304.34 | 303.9 | 303.91 | 7433.0 |
| 2020-05-28 04:55:00 | SPY | ETF | 303.95 | 304.02 | 303.94 | 303.96 | 1400.0 |
| 2020-05-28 05:00:00 | SPY | ETF | 304.05 | 304.08 | 304.05 | 304.08 | 717.0 |
| 2020-05-28 05:05:00 | SPY | ETF | 304.16 | 304.47 | 304.16 | 304.37 | 2502.0 |
| 2020-05-28 05:10:00 | SPY | ETF | 304.38 | 304.58 | 304.37 | 304.53 | 8476.0 |
| 2020-05-28 05:15:00 | SPY | ETF | 304.65 | 304.75 | 304.57 | 304.62 | 3166.0 |
| 2020-05-28 05:20:00 | SPY | ETF | 304.74 | 304.81 | 304.59 | 304.59 | 674.0 |
| 2020-05-28 05:25:00 | SPY | ETF | 304.58 | 304.58 | 304.47 | 304.47 | 651.0 |
| 2020-05-28 05:30:00 | SPY | ETF | 304.46 | 304.5 | 304.37 | 304.37 | 913.0 |
| 2020-05-28 05:35:00 | SPY | ETF | 304.38 | 304.38 | 304.14 | 304.14 | 1755.0 |
| 2020-05-28 05:40:00 | SPY | ETF | 304.21 | 304.3 | 304.17 | 304.19 | 900.0 |
| 2020-05-28 05:45:00 | SPY | ETF | 304.14 | 304.14 | 303.95 | 303.95 | 2627.0 |
| 2020-05-28 05:50:00 | SPY | ETF | 303.91 | 303.91 | 303.15 | 303.44 | 19506.0 |
| 2020-05-28 05:55:00 | SPY | ETF | 303.55 | 303.65 | 303.53 | 303.53 | 3834.0 |
| 2020-05-28 06:00:00 | SPY | ETF | 303.49 | 303.72 | 303.39 | 303.55 | 34817.0 |
| 2020-05-28 06:05:00 | SPY | ETF | 303.46 | 303.8 | 303.46 | 303.8 | 2735.0 |
| 2020-05-28 06:10:00 | SPY | ETF | 303.8 | 303.8 | 303.65 | 303.68 | 1352.0 |
| 2020-05-28 06:15:00 | SPY | ETF | 303.65 | 303.93 | 303.53 | 303.71 | 3936.0 |
| 2020-05-28 06:20:00 | SPY | ETF | 303.54 | 303.7 | 303.5 | 303.7 | 60978.0 |
| 2020-05-28 06:25:00 | SPY | ETF | 303.83 | 303.92 | 303.79 | 303.9 | 22294.0 |
| 2020-05-28 06:30:00 | SPY | ETF | 303.94 | 304.02 | 303.94 | 304.0 | 7621.0 |
| 2020-05-28 06:35:00 | SPY | ETF | 304.0 | 304.01 | 303.9 | 303.95 | 55858.0 |
| 2020-05-28 06:40:00 | SPY | ETF | 303.95 | 303.95 | 303.63 | 303.84 | 21232.0 |
| 2020-05-28 06:45:00 | SPY | ETF | 303.95 | 304.35 | 303.95 | 304.25 | 27996.0 |
| 2020-05-28 06:50:00 | SPY | ETF | 304.23 | 304.38 | 304.23 | 304.36 | 2566.0 |
| 2020-05-28 06:55:00 | SPY | ETF | 304.36 | 304.36 | 304.15 | 304.15 | 1878.0 |
| 2020-05-28 07:00:00 | SPY | ETF | 304.26 | 304.34 | 304.1 | 304.17 | 49019.0 |
| 2020-05-28 07:05:00 | SPY | ETF | 304.16 | 304.5 | 304.08 | 304.14 | 39366.0 |
| 2020-05-28 07:10:00 | SPY | ETF | 304.16 | 304.2 | 304.04 | 304.12 | 54855.0 |
| 2020-05-28 07:15:00 | SPY | ETF | 304.12 | 304.21 | 303.81 | 303.99 | 36436.0 |
| 2020-05-28 07:20:00 | SPY | ETF | 303.91 | 304.25 | 303.9 | 304.16 | 11156.0 |
| 2020-05-28 07:25:00 | SPY | ETF | 304.16 | 304.59 | 304.16 | 304.52 | 21368.0 |
| 2020-05-28 07:30:00 | SPY | ETF | 304.57 | 304.88 | 304.46 | 304.82 | 32617.0 |
| 2020-05-28 07:35:00 | SPY | ETF | 304.83 | 304.85 | 304.67 | 304.69 | 42065.0 |
| 2020-05-28 07:40:00 | SPY | ETF | 304.66 | 304.84 | 304.6 | 304.61 | 52842.0 |
| 2020-05-28 07:45:00 | SPY | ETF | 304.62 | 304.64 | 304.5 | 304.5 | 6926.0 |
| 2020-05-28 07:50:00 | SPY | ETF | 304.5 | 304.77 | 304.47 | 304.59 | 17205.0 |
| 2020-05-28 07:55:00 | SPY | ETF | 304.6 | 304.65 | 304.37 | 304.42 | 21896.0 |
| 2020-05-28 08:00:00 | SPY | ETF | 304.37 | 305.31 | 303.35 | 304.46 | 111948.0 |
| 2020-05-28 08:05:00 | SPY | ETF | 304.41 | 304.42 | 304.06 | 304.15 | 78729.0 |
> showing 50 of 76,663 rows — these rows as CSV