PREVIEW / etf_5min / 2021-05-26
file: by_date/etf_5min/2021/2021-05-26.parquet size: 1.7 MB rows: 80,157
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-05-26 04:00:00 | SPY | ETF | 419.33 | 419.46 | 419.33 | 419.36 | 2500.0 |
| 2021-05-26 04:05:00 | SPY | ETF | 419.36 | 419.45 | 419.36 | 419.44 | 2208.0 |
| 2021-05-26 04:10:00 | SPY | ETF | 419.58 | 419.65 | 419.58 | 419.65 | 2700.0 |
| 2021-05-26 04:15:00 | SPY | ETF | 419.55 | 419.55 | 419.55 | 419.55 | 250.0 |
| 2021-05-26 04:20:00 | SPY | ETF | 419.53 | 419.59 | 419.53 | 419.59 | 3400.0 |
| 2021-05-26 04:30:00 | SPY | ETF | 419.57 | 419.57 | 419.43 | 419.43 | 1600.0 |
| 2021-05-26 04:35:00 | SPY | ETF | 419.36 | 419.36 | 419.33 | 419.33 | 300.0 |
| 2021-05-26 04:40:00 | SPY | ETF | 419.25 | 419.25 | 419.25 | 419.25 | 1500.0 |
| 2021-05-26 05:00:00 | SPY | ETF | 419.33 | 419.33 | 419.33 | 419.33 | 400.0 |
| 2021-05-26 05:05:00 | SPY | ETF | 419.54 | 419.54 | 419.54 | 419.54 | 100.0 |
| 2021-05-26 05:10:00 | SPY | ETF | 419.64 | 419.64 | 419.64 | 419.64 | 700.0 |
| 2021-05-26 05:20:00 | SPY | ETF | 419.6 | 419.74 | 419.6 | 419.74 | 400.0 |
| 2021-05-26 05:25:00 | SPY | ETF | 419.84 | 419.84 | 419.84 | 419.84 | 100.0 |
| 2021-05-26 05:30:00 | SPY | ETF | 419.91 | 420.02 | 419.91 | 420.02 | 1620.0 |
| 2021-05-26 05:40:00 | SPY | ETF | 419.89 | 419.89 | 419.8 | 419.8 | 700.0 |
| 2021-05-26 05:45:00 | SPY | ETF | 419.71 | 419.71 | 419.5 | 419.5 | 1800.0 |
| 2021-05-26 05:50:00 | SPY | ETF | 419.51 | 419.51 | 419.5 | 419.51 | 1400.0 |
| 2021-05-26 05:55:00 | SPY | ETF | 419.45 | 419.45 | 419.4 | 419.4 | 300.0 |
| 2021-05-26 06:00:00 | SPY | ETF | 419.4 | 419.4 | 419.4 | 419.4 | 550.0 |
| 2021-05-26 06:05:00 | SPY | ETF | 419.46 | 419.46 | 419.43 | 419.43 | 400.0 |
| 2021-05-26 06:10:00 | SPY | ETF | 419.5 | 419.5 | 419.5 | 419.5 | 700.0 |
| 2021-05-26 06:15:00 | SPY | ETF | 419.34 | 419.34 | 419.34 | 419.34 | 100.0 |
| 2021-05-26 06:20:00 | SPY | ETF | 419.35 | 419.35 | 419.35 | 419.35 | 167.0 |
| 2021-05-26 06:30:00 | SPY | ETF | 419.45 | 419.45 | 419.45 | 419.45 | 499.0 |
| 2021-05-26 06:35:00 | SPY | ETF | 419.43 | 419.44 | 419.43 | 419.44 | 550.0 |
| 2021-05-26 06:40:00 | SPY | ETF | 419.44 | 419.44 | 419.4 | 419.4 | 1200.0 |
| 2021-05-26 06:45:00 | SPY | ETF | 419.35 | 419.35 | 419.33 | 419.33 | 500.0 |
| 2021-05-26 06:50:00 | SPY | ETF | 419.42 | 419.45 | 419.42 | 419.45 | 1629.0 |
| 2021-05-26 07:00:00 | SPY | ETF | 419.43 | 419.6 | 419.4 | 419.59 | 4640.0 |
| 2021-05-26 07:05:00 | SPY | ETF | 419.62 | 419.62 | 419.46 | 419.53 | 9640.0 |
| 2021-05-26 07:10:00 | SPY | ETF | 419.6 | 419.63 | 419.58 | 419.59 | 18081.0 |
| 2021-05-26 07:15:00 | SPY | ETF | 419.63 | 419.68 | 419.63 | 419.66 | 15758.0 |
| 2021-05-26 07:20:00 | SPY | ETF | 419.66 | 419.86 | 419.66 | 419.83 | 9115.0 |
| 2021-05-26 07:25:00 | SPY | ETF | 419.82 | 420.0 | 419.77 | 419.77 | 7585.0 |
| 2021-05-26 07:30:00 | SPY | ETF | 419.72 | 419.72 | 419.42 | 419.47 | 8277.0 |
| 2021-05-26 07:35:00 | SPY | ETF | 419.51 | 419.52 | 419.42 | 419.5 | 12222.0 |
| 2021-05-26 07:40:00 | SPY | ETF | 419.47 | 419.47 | 419.37 | 419.44 | 7638.0 |
| 2021-05-26 07:45:00 | SPY | ETF | 419.46 | 419.46 | 419.4 | 419.4 | 3514.0 |
| 2021-05-26 07:50:00 | SPY | ETF | 419.39 | 419.39 | 419.38 | 419.38 | 2237.0 |
| 2021-05-26 07:55:00 | SPY | ETF | 419.4 | 419.41 | 419.33 | 419.39 | 10705.0 |
| 2021-05-26 08:00:00 | SPY | ETF | 419.4296 | 419.97 | 419.16 | 419.53 | 24671.0 |
| 2021-05-26 08:05:00 | SPY | ETF | 419.53 | 419.61 | 419.53 | 419.57 | 1952.0 |
| 2021-05-26 08:10:00 | SPY | ETF | 419.57 | 419.66 | 419.57 | 419.61 | 11421.0 |
| 2021-05-26 08:15:00 | SPY | ETF | 419.63 | 419.64 | 419.59 | 419.64 | 3257.0 |
| 2021-05-26 08:20:00 | SPY | ETF | 419.62 | 419.67 | 419.59 | 419.62 | 11687.0 |
| 2021-05-26 08:25:00 | SPY | ETF | 419.66 | 419.75 | 419.66 | 419.75 | 9839.0 |
| 2021-05-26 08:30:00 | SPY | ETF | 419.732 | 419.732 | 419.66 | 419.7 | 4311.0 |
| 2021-05-26 08:35:00 | SPY | ETF | 419.71 | 419.71 | 419.63 | 419.66 | 5463.0 |
| 2021-05-26 08:40:00 | SPY | ETF | 419.67 | 419.73 | 419.64 | 419.7 | 3896.0 |
| 2021-05-26 08:45:00 | SPY | ETF | 419.67 | 419.67 | 419.4 | 419.4 | 25877.0 |
> showing 50 of 80,157 rows — these rows as CSV