PREVIEW / etf_5min / 2021-08-18
file: by_date/etf_5min/2021/2021-08-18.parquet size: 1.7 MB rows: 78,944
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-08-18 04:00:00 | SPY | ETF | 443.45 | 443.64 | 443.45 | 443.64 | 1335.0 |
| 2021-08-18 04:05:00 | SPY | ETF | 443.79 | 443.91 | 443.79 | 443.9 | 3100.0 |
| 2021-08-18 04:10:00 | SPY | ETF | 443.77 | 443.77 | 443.63 | 443.64 | 1000.0 |
| 2021-08-18 04:15:00 | SPY | ETF | 443.64 | 443.64 | 443.52 | 443.52 | 1100.0 |
| 2021-08-18 04:20:00 | SPY | ETF | 443.49 | 443.78 | 443.49 | 443.56 | 4800.0 |
| 2021-08-18 04:25:00 | SPY | ETF | 443.44 | 443.44 | 443.42 | 443.42 | 300.0 |
| 2021-08-18 04:30:00 | SPY | ETF | 443.42 | 443.42 | 443.42 | 443.42 | 120.0 |
| 2021-08-18 04:35:00 | SPY | ETF | 443.47 | 443.57 | 443.47 | 443.57 | 533.0 |
| 2021-08-18 04:40:00 | SPY | ETF | 443.53 | 443.53 | 443.42 | 443.42 | 1000.0 |
| 2021-08-18 04:45:00 | SPY | ETF | 443.38 | 443.4 | 443.38 | 443.4 | 602.0 |
| 2021-08-18 04:50:00 | SPY | ETF | 443.41 | 443.41 | 443.41 | 443.41 | 100.0 |
| 2021-08-18 04:55:00 | SPY | ETF | 443.34 | 443.53 | 443.34 | 443.53 | 1596.0 |
| 2021-08-18 05:00:00 | SPY | ETF | 443.48 | 443.52 | 443.48 | 443.52 | 896.0 |
| 2021-08-18 05:05:00 | SPY | ETF | 443.42 | 443.51 | 443.42 | 443.51 | 700.0 |
| 2021-08-18 05:15:00 | SPY | ETF | 443.7 | 443.7 | 443.7 | 443.7 | 500.0 |
| 2021-08-18 05:25:00 | SPY | ETF | 443.66 | 443.66 | 443.66 | 443.66 | 200.0 |
| 2021-08-18 05:35:00 | SPY | ETF | 443.57 | 443.57 | 443.57 | 443.57 | 200.0 |
| 2021-08-18 05:50:00 | SPY | ETF | 443.48 | 443.48 | 443.45 | 443.45 | 601.0 |
| 2021-08-18 05:55:00 | SPY | ETF | 443.35 | 443.35 | 443.35 | 443.35 | 999.0 |
| 2021-08-18 06:00:00 | SPY | ETF | 443.38 | 443.38 | 443.38 | 443.38 | 300.0 |
| 2021-08-18 06:05:00 | SPY | ETF | 443.41 | 443.41 | 443.39 | 443.39 | 2100.0 |
| 2021-08-18 06:10:00 | SPY | ETF | 443.31 | 443.31 | 443.31 | 443.31 | 100.0 |
| 2021-08-18 06:20:00 | SPY | ETF | 443.23 | 443.26 | 443.23 | 443.23 | 699.0 |
| 2021-08-18 06:25:00 | SPY | ETF | 443.31 | 443.31 | 443.28 | 443.28 | 655.0 |
| 2021-08-18 06:30:00 | SPY | ETF | 443.43 | 443.43 | 443.43 | 443.43 | 300.0 |
| 2021-08-18 06:35:00 | SPY | ETF | 443.54 | 443.54 | 443.54 | 443.54 | 400.0 |
| 2021-08-18 06:40:00 | SPY | ETF | 443.67 | 443.67 | 443.67 | 443.67 | 100.0 |
| 2021-08-18 06:45:00 | SPY | ETF | 443.66 | 443.72 | 443.64 | 443.72 | 3876.0 |
| 2021-08-18 06:50:00 | SPY | ETF | 443.73 | 443.99 | 443.73 | 443.99 | 6448.0 |
| 2021-08-18 06:55:00 | SPY | ETF | 443.99 | 443.99 | 443.85 | 443.91 | 1896.0 |
| 2021-08-18 07:00:00 | SPY | ETF | 443.91 | 444.0 | 443.87 | 443.89 | 7494.0 |
| 2021-08-18 07:05:00 | SPY | ETF | 443.86 | 443.98 | 443.86 | 443.98 | 3121.0 |
| 2021-08-18 07:10:00 | SPY | ETF | 443.93 | 443.93 | 443.71 | 443.71 | 6421.0 |
| 2021-08-18 07:15:00 | SPY | ETF | 443.67 | 443.67 | 443.6 | 443.63 | 3683.0 |
| 2021-08-18 07:20:00 | SPY | ETF | 443.65 | 443.69 | 443.57 | 443.67 | 2348.0 |
| 2021-08-18 07:25:00 | SPY | ETF | 443.694 | 443.694 | 443.58 | 443.58 | 1368.0 |
| 2021-08-18 07:30:00 | SPY | ETF | 443.56 | 443.59 | 443.5 | 443.5 | 3539.0 |
| 2021-08-18 07:35:00 | SPY | ETF | 443.57 | 443.59 | 443.54 | 443.54 | 6093.0 |
| 2021-08-18 07:40:00 | SPY | ETF | 443.62 | 443.67 | 443.57 | 443.57 | 6774.0 |
| 2021-08-18 07:45:00 | SPY | ETF | 443.54 | 443.69 | 443.54 | 443.69 | 813.0 |
| 2021-08-18 07:50:00 | SPY | ETF | 443.69 | 443.69 | 443.6 | 443.6 | 4349.0 |
| 2021-08-18 07:55:00 | SPY | ETF | 443.6 | 443.63 | 443.58 | 443.62 | 5439.0 |
| 2021-08-18 08:00:00 | SPY | ETF | 443.66 | 444.373 | 443.57 | 443.78 | 18761.0 |
| 2021-08-18 08:05:00 | SPY | ETF | 443.8 | 443.8 | 443.57 | 443.57 | 30454.0 |
| 2021-08-18 08:10:00 | SPY | ETF | 443.56 | 443.56 | 443.41 | 443.47 | 22804.0 |
| 2021-08-18 08:15:00 | SPY | ETF | 443.51 | 443.58 | 443.49 | 443.58 | 4179.0 |
| 2021-08-18 08:20:00 | SPY | ETF | 443.54 | 443.6101 | 443.52 | 443.58 | 6412.0 |
| 2021-08-18 08:25:00 | SPY | ETF | 443.6 | 443.6 | 443.4 | 443.4 | 8963.0 |
| 2021-08-18 08:30:00 | SPY | ETF | 443.4 | 443.51 | 443.38 | 443.51 | 6586.0 |
| 2021-08-18 08:35:00 | SPY | ETF | 443.51 | 443.62 | 443.44 | 443.5 | 8352.0 |
> showing 50 of 78,944 rows — these rows as CSV