PREVIEW / etf_5min / 2020-07-08
file: by_date/etf_5min/2020/2020-07-08.parquet size: 1.6 MB rows: 74,615
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-08 04:00:00 | SPY | ETF | 314.61 | 314.61 | 314.42 | 314.42 | 4773.0 |
| 2020-07-08 04:05:00 | SPY | ETF | 314.56 | 314.57 | 314.28 | 314.45 | 4033.0 |
| 2020-07-08 04:10:00 | SPY | ETF | 314.41 | 314.79 | 314.41 | 314.53 | 1110.0 |
| 2020-07-08 04:15:00 | SPY | ETF | 314.62 | 314.62 | 314.44 | 314.53 | 1273.0 |
| 2020-07-08 04:20:00 | SPY | ETF | 314.78 | 314.78 | 314.78 | 314.78 | 432.0 |
| 2020-07-08 04:25:00 | SPY | ETF | 314.71 | 314.82 | 314.61 | 314.68 | 2446.0 |
| 2020-07-08 04:30:00 | SPY | ETF | 314.65 | 314.65 | 314.5 | 314.5 | 1400.0 |
| 2020-07-08 04:35:00 | SPY | ETF | 314.44 | 315.33 | 314.44 | 314.67 | 11949.0 |
| 2020-07-08 04:40:00 | SPY | ETF | 314.94 | 314.94 | 314.88 | 314.88 | 465.0 |
| 2020-07-08 04:45:00 | SPY | ETF | 314.89 | 314.89 | 314.8 | 314.8 | 1871.0 |
| 2020-07-08 04:50:00 | SPY | ETF | 314.83 | 314.83 | 314.56 | 314.57 | 4160.0 |
| 2020-07-08 04:55:00 | SPY | ETF | 314.49 | 314.49 | 314.29 | 314.34 | 6054.0 |
| 2020-07-08 05:00:00 | SPY | ETF | 314.45 | 314.45 | 314.26 | 314.32 | 2031.0 |
| 2020-07-08 05:05:00 | SPY | ETF | 314.3 | 314.33 | 314.19 | 314.27 | 3297.0 |
| 2020-07-08 05:10:00 | SPY | ETF | 314.21 | 314.21 | 313.71 | 313.71 | 3424.0 |
| 2020-07-08 05:15:00 | SPY | ETF | 313.63 | 313.69 | 313.3 | 313.3 | 10300.0 |
| 2020-07-08 05:20:00 | SPY | ETF | 313.33 | 313.59 | 313.25 | 313.55 | 12459.0 |
| 2020-07-08 05:25:00 | SPY | ETF | 313.54 | 313.55 | 313.41 | 313.55 | 2034.0 |
| 2020-07-08 05:30:00 | SPY | ETF | 313.5 | 313.8 | 313.5 | 313.73 | 7723.0 |
| 2020-07-08 05:35:00 | SPY | ETF | 313.75 | 313.8 | 313.6 | 313.6 | 3237.0 |
| 2020-07-08 05:40:00 | SPY | ETF | 313.58 | 313.58 | 313.1 | 313.15 | 18768.0 |
| 2020-07-08 05:45:00 | SPY | ETF | 313.15 | 313.35 | 313.15 | 313.35 | 9505.0 |
| 2020-07-08 05:50:00 | SPY | ETF | 313.35 | 313.4 | 313.14 | 313.14 | 912.0 |
| 2020-07-08 05:55:00 | SPY | ETF | 313.38 | 313.49 | 313.34 | 313.46 | 53061.0 |
| 2020-07-08 06:00:00 | SPY | ETF | 313.32 | 313.32 | 313.23 | 313.26 | 4876.0 |
| 2020-07-08 06:05:00 | SPY | ETF | 313.44 | 313.51 | 313.28 | 313.51 | 3188.0 |
| 2020-07-08 06:10:00 | SPY | ETF | 313.46 | 313.5 | 313.14 | 313.32 | 5687.0 |
| 2020-07-08 06:15:00 | SPY | ETF | 313.44 | 313.61 | 313.44 | 313.59 | 2666.0 |
| 2020-07-08 06:20:00 | SPY | ETF | 313.5 | 313.5 | 313.33 | 313.41 | 1152.0 |
| 2020-07-08 06:25:00 | SPY | ETF | 313.56 | 313.59 | 313.51 | 313.51 | 416.0 |
| 2020-07-08 06:30:00 | SPY | ETF | 313.51 | 313.54 | 313.51 | 313.54 | 2175.0 |
| 2020-07-08 06:35:00 | SPY | ETF | 313.71 | 313.71 | 313.65 | 313.69 | 2327.0 |
| 2020-07-08 06:40:00 | SPY | ETF | 313.78 | 313.94 | 313.78 | 313.89 | 6421.0 |
| 2020-07-08 06:45:00 | SPY | ETF | 313.9 | 313.95 | 313.87 | 313.95 | 8303.0 |
| 2020-07-08 06:50:00 | SPY | ETF | 313.95 | 314.06 | 313.86 | 314.06 | 4953.0 |
| 2020-07-08 06:55:00 | SPY | ETF | 314.0 | 314.09 | 313.9 | 314.09 | 27376.0 |
| 2020-07-08 07:00:00 | SPY | ETF | 314.07 | 314.2 | 314.0 | 314.2 | 12761.0 |
| 2020-07-08 07:05:00 | SPY | ETF | 314.27 | 314.32 | 314.1 | 314.22 | 30462.0 |
| 2020-07-08 07:10:00 | SPY | ETF | 314.24 | 314.32 | 314.17 | 314.17 | 5528.0 |
| 2020-07-08 07:15:00 | SPY | ETF | 314.27 | 314.29 | 314.22 | 314.25 | 4334.0 |
| 2020-07-08 07:20:00 | SPY | ETF | 314.27 | 314.27 | 313.99 | 313.99 | 14616.0 |
| 2020-07-08 07:25:00 | SPY | ETF | 313.97 | 313.98 | 313.8 | 313.91 | 9905.0 |
| 2020-07-08 07:30:00 | SPY | ETF | 313.92 | 314.149 | 313.9 | 314.12 | 12388.0 |
| 2020-07-08 07:35:00 | SPY | ETF | 314.12 | 314.27 | 314.12 | 314.27 | 21336.0 |
| 2020-07-08 07:40:00 | SPY | ETF | 314.2 | 314.46 | 314.2 | 314.44 | 23724.0 |
| 2020-07-08 07:45:00 | SPY | ETF | 314.41 | 314.57 | 314.41 | 314.45 | 16926.0 |
| 2020-07-08 07:50:00 | SPY | ETF | 314.46 | 314.675 | 314.45 | 314.675 | 40244.0 |
| 2020-07-08 07:55:00 | SPY | ETF | 314.64 | 314.64 | 314.4 | 314.41 | 8440.0 |
| 2020-07-08 08:00:00 | SPY | ETF | 314.49 | 314.67 | 313.72 | 314.31 | 64116.0 |
| 2020-07-08 08:05:00 | SPY | ETF | 314.31 | 314.4 | 314.21 | 314.34 | 14940.0 |
> showing 50 of 74,615 rows — these rows as CSV