PREVIEW / etf_5min / 2020-09-21
file: by_date/etf_5min/2020/2020-09-21.parquet size: 1.8 MB rows: 80,915
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-09-21 04:00:00 | SPY | ETF | 328.14 | 328.14 | 327.8 | 327.9 | 18796.0 |
| 2020-09-21 04:05:00 | SPY | ETF | 327.81 | 327.9 | 327.63 | 327.8 | 12784.0 |
| 2020-09-21 04:10:00 | SPY | ETF | 327.55 | 327.55 | 326.79 | 326.95 | 19359.0 |
| 2020-09-21 04:15:00 | SPY | ETF | 326.95 | 327.16 | 326.53 | 326.55 | 11338.0 |
| 2020-09-21 04:20:00 | SPY | ETF | 326.55 | 326.8 | 326.42 | 326.55 | 6549.0 |
| 2020-09-21 04:25:00 | SPY | ETF | 326.45 | 326.63 | 326.14 | 326.62 | 6546.0 |
| 2020-09-21 04:30:00 | SPY | ETF | 326.54 | 326.59 | 326.06 | 326.2 | 13269.0 |
| 2020-09-21 04:35:00 | SPY | ETF | 326.27 | 326.44 | 326.19 | 326.43 | 13809.0 |
| 2020-09-21 04:40:00 | SPY | ETF | 326.19 | 326.19 | 325.38 | 325.38 | 13917.0 |
| 2020-09-21 04:45:00 | SPY | ETF | 325.25 | 325.25 | 324.87 | 325.13 | 21149.0 |
| 2020-09-21 04:50:00 | SPY | ETF | 324.9 | 325.23 | 324.65 | 325.16 | 17311.0 |
| 2020-09-21 04:55:00 | SPY | ETF | 325.11 | 325.34 | 325.11 | 325.34 | 11830.0 |
| 2020-09-21 05:00:00 | SPY | ETF | 325.33 | 325.4 | 325.26 | 325.34 | 5827.0 |
| 2020-09-21 05:05:00 | SPY | ETF | 325.39 | 325.74 | 325.39 | 325.74 | 5963.0 |
| 2020-09-21 05:10:00 | SPY | ETF | 325.99 | 326.62 | 325.89 | 326.52 | 25672.0 |
| 2020-09-21 05:15:00 | SPY | ETF | 326.67 | 326.84 | 326.67 | 326.8 | 15272.0 |
| 2020-09-21 05:20:00 | SPY | ETF | 326.78 | 326.82 | 326.56 | 326.7 | 10235.0 |
| 2020-09-21 05:25:00 | SPY | ETF | 326.55 | 326.57 | 326.1 | 326.32 | 9773.0 |
| 2020-09-21 05:30:00 | SPY | ETF | 326.26 | 326.39 | 325.95 | 325.95 | 12580.0 |
| 2020-09-21 05:35:00 | SPY | ETF | 325.96 | 326.06 | 325.57 | 325.57 | 3496.0 |
| 2020-09-21 05:40:00 | SPY | ETF | 325.63 | 325.72 | 325.33 | 325.46 | 6061.0 |
| 2020-09-21 05:45:00 | SPY | ETF | 325.4 | 325.4 | 325.0 | 325.3 | 14878.0 |
| 2020-09-21 05:50:00 | SPY | ETF | 325.33 | 325.87 | 325.11 | 325.87 | 25087.0 |
| 2020-09-21 05:55:00 | SPY | ETF | 325.79 | 325.81 | 325.48 | 325.49 | 2896.0 |
| 2020-09-21 06:00:00 | SPY | ETF | 325.55 | 325.7 | 325.4 | 325.44 | 15185.0 |
| 2020-09-21 06:05:00 | SPY | ETF | 325.53 | 325.78 | 325.53 | 325.78 | 2571.0 |
| 2020-09-21 06:10:00 | SPY | ETF | 325.79 | 325.79 | 325.4 | 325.4 | 15312.0 |
| 2020-09-21 06:15:00 | SPY | ETF | 325.39 | 325.52 | 325.37 | 325.37 | 2087.0 |
| 2020-09-21 06:20:00 | SPY | ETF | 325.5 | 326.33 | 325.46 | 326.33 | 7350.0 |
| 2020-09-21 06:25:00 | SPY | ETF | 326.28 | 326.35 | 326.15 | 326.2 | 21570.0 |
| 2020-09-21 06:30:00 | SPY | ETF | 326.22 | 326.71 | 326.22 | 326.64 | 73391.0 |
| 2020-09-21 06:35:00 | SPY | ETF | 326.66 | 326.66 | 326.52 | 326.6 | 20110.0 |
| 2020-09-21 06:40:00 | SPY | ETF | 326.52 | 326.52 | 326.21 | 326.34 | 15975.0 |
| 2020-09-21 06:45:00 | SPY | ETF | 326.29 | 326.3 | 326.15 | 326.25 | 6969.0 |
| 2020-09-21 06:50:00 | SPY | ETF | 326.26 | 326.27 | 326.09 | 326.27 | 1924.0 |
| 2020-09-21 06:55:00 | SPY | ETF | 326.23 | 326.41 | 326.23 | 326.4 | 14431.0 |
| 2020-09-21 07:00:00 | SPY | ETF | 326.46 | 326.57 | 326.11 | 326.179 | 45664.0 |
| 2020-09-21 07:05:00 | SPY | ETF | 326.21 | 326.32 | 326.02 | 326.02 | 29033.0 |
| 2020-09-21 07:10:00 | SPY | ETF | 326.15 | 326.38 | 326.1 | 326.34 | 15448.0 |
| 2020-09-21 07:15:00 | SPY | ETF | 326.41 | 326.41 | 326.15 | 326.17 | 5389.0 |
| 2020-09-21 07:20:00 | SPY | ETF | 326.19 | 326.25 | 325.75 | 325.75 | 14740.0 |
| 2020-09-21 07:25:00 | SPY | ETF | 325.71 | 325.71 | 325.5 | 325.5 | 35672.0 |
| 2020-09-21 07:30:00 | SPY | ETF | 325.59 | 325.97 | 325.43 | 325.87 | 156524.0 |
| 2020-09-21 07:35:00 | SPY | ETF | 325.84 | 326.04 | 325.79 | 326.01 | 12303.0 |
| 2020-09-21 07:40:00 | SPY | ETF | 326.0 | 326.19 | 325.97 | 326.14 | 54972.0 |
| 2020-09-21 07:45:00 | SPY | ETF | 326.17 | 326.52 | 326.16 | 326.52 | 47628.0 |
| 2020-09-21 07:50:00 | SPY | ETF | 326.51 | 326.54 | 326.45 | 326.5 | 40678.0 |
| 2020-09-21 07:55:00 | SPY | ETF | 326.51 | 326.76 | 326.51 | 326.7 | 19676.0 |
| 2020-09-21 08:00:00 | SPY | ETF | 326.3499 | 331.04 | 325.53 | 326.26 | 142456.0 |
| 2020-09-21 08:05:00 | SPY | ETF | 326.2504 | 326.3 | 325.56 | 325.6 | 110229.0 |
> showing 50 of 80,915 rows — these rows as CSV