PREVIEW / etf_5min / 2021-01-06
file: by_date/etf_5min/2021/2021-01-06.parquet size: 2.0 MB rows: 91,241
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 |
|---|---|---|---|---|---|---|---|
| 2021-01-06 04:00:00 | SPY | ETF | 368.66 | 368.79 | 368.04 | 368.74 | 25934.0 |
| 2021-01-06 04:05:00 | SPY | ETF | 368.69 | 368.84 | 368.61 | 368.84 | 6973.0 |
| 2021-01-06 04:10:00 | SPY | ETF | 368.82 | 369.11 | 368.74 | 369.02 | 7922.0 |
| 2021-01-06 04:15:00 | SPY | ETF | 369.08 | 369.8 | 369.08 | 369.71 | 17647.0 |
| 2021-01-06 04:20:00 | SPY | ETF | 369.75 | 369.77 | 369.46 | 369.51 | 12879.0 |
| 2021-01-06 04:25:00 | SPY | ETF | 369.53 | 369.56 | 369.47 | 369.47 | 6568.0 |
| 2021-01-06 04:30:00 | SPY | ETF | 369.36 | 369.58 | 369.36 | 369.55 | 4269.0 |
| 2021-01-06 04:35:00 | SPY | ETF | 369.55 | 369.64 | 369.39 | 369.54 | 12152.0 |
| 2021-01-06 04:40:00 | SPY | ETF | 369.54 | 369.7 | 369.48 | 369.7 | 2989.0 |
| 2021-01-06 04:45:00 | SPY | ETF | 369.78 | 370.48 | 369.76 | 370.42 | 24241.0 |
| 2021-01-06 04:50:00 | SPY | ETF | 370.45 | 370.64 | 370.42 | 370.5 | 15223.0 |
| 2021-01-06 04:55:00 | SPY | ETF | 370.42 | 370.43 | 370.12 | 370.13 | 5726.0 |
| 2021-01-06 05:00:00 | SPY | ETF | 370.37 | 370.69 | 370.37 | 370.5 | 3451.0 |
| 2021-01-06 05:05:00 | SPY | ETF | 370.5 | 370.54 | 370.3 | 370.3 | 2336.0 |
| 2021-01-06 05:10:00 | SPY | ETF | 370.54 | 370.54 | 370.1 | 370.13 | 12025.0 |
| 2021-01-06 05:15:00 | SPY | ETF | 370.32 | 370.42 | 370.29 | 370.39 | 10153.0 |
| 2021-01-06 05:20:00 | SPY | ETF | 370.39 | 370.5 | 370.28 | 370.31 | 5706.0 |
| 2021-01-06 05:25:00 | SPY | ETF | 370.31 | 370.47 | 369.9 | 369.9 | 3165.0 |
| 2021-01-06 05:30:00 | SPY | ETF | 369.89 | 370.27 | 369.89 | 370.14 | 7598.0 |
| 2021-01-06 05:35:00 | SPY | ETF | 370.1 | 370.31 | 369.97 | 370.0 | 1745.0 |
| 2021-01-06 05:40:00 | SPY | ETF | 370.28 | 370.62 | 370.28 | 370.55 | 6118.0 |
| 2021-01-06 05:45:00 | SPY | ETF | 370.68 | 370.96 | 370.67 | 370.78 | 11441.0 |
| 2021-01-06 05:50:00 | SPY | ETF | 370.78 | 371.0 | 370.66 | 370.85 | 58757.0 |
| 2021-01-06 05:55:00 | SPY | ETF | 370.8 | 370.8 | 370.42 | 370.47 | 6899.0 |
| 2021-01-06 06:00:00 | SPY | ETF | 370.43 | 370.47 | 370.27 | 370.27 | 4339.0 |
| 2021-01-06 06:05:00 | SPY | ETF | 370.2 | 370.2 | 369.98 | 369.98 | 44453.0 |
| 2021-01-06 06:10:00 | SPY | ETF | 370.0 | 370.13 | 369.89 | 369.89 | 14867.0 |
| 2021-01-06 06:15:00 | SPY | ETF | 369.85 | 369.85 | 369.39 | 369.45 | 13229.0 |
| 2021-01-06 06:20:00 | SPY | ETF | 369.49 | 369.94 | 369.3 | 369.94 | 8648.0 |
| 2021-01-06 06:25:00 | SPY | ETF | 369.92 | 370.05 | 369.92 | 370.0 | 8215.0 |
| 2021-01-06 06:30:00 | SPY | ETF | 369.87 | 369.97 | 369.87 | 369.94 | 5198.0 |
| 2021-01-06 06:35:00 | SPY | ETF | 369.98 | 370.06 | 369.75 | 370.06 | 9929.0 |
| 2021-01-06 06:40:00 | SPY | ETF | 370.0 | 370.19 | 369.96 | 370.1 | 11131.0 |
| 2021-01-06 06:45:00 | SPY | ETF | 370.0 | 370.05 | 369.93 | 370.0 | 3045.0 |
| 2021-01-06 06:50:00 | SPY | ETF | 370.04 | 370.44 | 370.04 | 370.36 | 7940.0 |
| 2021-01-06 06:55:00 | SPY | ETF | 370.37 | 370.61 | 370.37 | 370.45 | 19803.0 |
| 2021-01-06 07:00:00 | SPY | ETF | 370.43 | 371.08 | 370.35 | 371.05 | 67395.0 |
| 2021-01-06 07:05:00 | SPY | ETF | 371.04 | 371.18 | 370.91 | 370.91 | 35246.0 |
| 2021-01-06 07:10:00 | SPY | ETF | 370.9 | 371.22 | 370.87 | 371.22 | 23332.0 |
| 2021-01-06 07:15:00 | SPY | ETF | 371.12 | 371.25 | 371.0 | 371.25 | 12531.0 |
| 2021-01-06 07:20:00 | SPY | ETF | 371.23 | 371.41 | 371.21 | 371.29 | 78906.0 |
| 2021-01-06 07:25:00 | SPY | ETF | 371.27 | 371.27 | 370.85 | 370.97 | 108384.0 |
| 2021-01-06 07:30:00 | SPY | ETF | 370.97 | 371.19 | 370.65 | 370.65 | 84993.0 |
| 2021-01-06 07:35:00 | SPY | ETF | 370.62 | 370.8 | 370.33 | 370.54 | 93045.0 |
| 2021-01-06 07:40:00 | SPY | ETF | 370.58 | 370.59 | 370.39 | 370.5 | 78882.0 |
| 2021-01-06 07:45:00 | SPY | ETF | 370.59 | 370.59 | 370.33 | 370.48 | 92562.0 |
| 2021-01-06 07:50:00 | SPY | ETF | 370.42 | 370.46 | 370.0 | 370.1 | 148599.0 |
| 2021-01-06 07:55:00 | SPY | ETF | 370.09 | 370.17 | 369.85 | 369.95 | 131568.0 |
| 2021-01-06 08:00:00 | SPY | ETF | 369.92 | 371.41 | 368.86 | 370.34 | 274727.0 |
| 2021-01-06 08:05:00 | SPY | ETF | 370.43 | 370.44 | 370.21 | 370.4 | 53921.0 |
> showing 50 of 91,241 rows — these rows as CSV