PREVIEW / etf_5min / 2022-03-24
file: by_date/etf_5min/2022/2022-03-24.parquet size: 1.9 MB rows: 91,888
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-24 04:00:00 | SPY | ETF | 445.29 | 445.87 | 445.21 | 445.87 | 5218.0 |
| 2022-03-24 04:05:00 | SPY | ETF | 446.08 | 446.58 | 446.08 | 446.47 | 3540.0 |
| 2022-03-24 04:10:00 | SPY | ETF | 446.43 | 446.43 | 446.06 | 446.06 | 1711.0 |
| 2022-03-24 04:15:00 | SPY | ETF | 446.18 | 446.42 | 446.1 | 446.42 | 1350.0 |
| 2022-03-24 04:20:00 | SPY | ETF | 446.32 | 446.55 | 446.23 | 446.55 | 1376.0 |
| 2022-03-24 04:25:00 | SPY | ETF | 446.56 | 446.6 | 446.56 | 446.6 | 480.0 |
| 2022-03-24 04:30:00 | SPY | ETF | 446.62 | 447.0 | 446.62 | 446.71 | 8664.0 |
| 2022-03-24 04:35:00 | SPY | ETF | 446.7 | 446.85 | 446.7 | 446.85 | 1700.0 |
| 2022-03-24 04:40:00 | SPY | ETF | 446.78 | 446.78 | 446.64 | 446.66 | 1650.0 |
| 2022-03-24 04:45:00 | SPY | ETF | 446.5 | 446.52 | 446.48 | 446.52 | 397.0 |
| 2022-03-24 04:50:00 | SPY | ETF | 446.66 | 446.66 | 446.64 | 446.64 | 267.0 |
| 2022-03-24 04:55:00 | SPY | ETF | 446.63 | 446.74 | 446.63 | 446.72 | 1700.0 |
| 2022-03-24 05:00:00 | SPY | ETF | 446.65 | 446.93 | 446.65 | 446.93 | 1106.0 |
| 2022-03-24 05:05:00 | SPY | ETF | 446.93 | 446.93 | 446.67 | 446.75 | 2537.0 |
| 2022-03-24 05:10:00 | SPY | ETF | 446.65 | 446.65 | 446.65 | 446.65 | 800.0 |
| 2022-03-24 05:25:00 | SPY | ETF | 446.55 | 446.55 | 446.51 | 446.51 | 6043.0 |
| 2022-03-24 05:30:00 | SPY | ETF | 446.5 | 446.61 | 446.5 | 446.61 | 2076.0 |
| 2022-03-24 05:35:00 | SPY | ETF | 446.59 | 446.59 | 446.59 | 446.59 | 481.0 |
| 2022-03-24 05:40:00 | SPY | ETF | 446.6 | 446.6 | 446.52 | 446.52 | 640.0 |
| 2022-03-24 05:45:00 | SPY | ETF | 446.6 | 446.6 | 446.59 | 446.59 | 1300.0 |
| 2022-03-24 05:50:00 | SPY | ETF | 446.53 | 446.53 | 446.53 | 446.53 | 100.0 |
| 2022-03-24 05:55:00 | SPY | ETF | 446.4 | 446.4 | 446.4 | 446.4 | 190.0 |
| 2022-03-24 06:00:00 | SPY | ETF | 446.25 | 446.25 | 446.11 | 446.19 | 1400.0 |
| 2022-03-24 06:05:00 | SPY | ETF | 446.15 | 446.15 | 445.93 | 445.93 | 910.0 |
| 2022-03-24 06:10:00 | SPY | ETF | 445.93 | 445.98 | 445.93 | 445.98 | 1600.0 |
| 2022-03-24 06:15:00 | SPY | ETF | 445.64 | 445.75 | 445.64 | 445.75 | 1600.0 |
| 2022-03-24 06:20:00 | SPY | ETF | 445.6 | 445.68 | 445.6 | 445.68 | 2985.0 |
| 2022-03-24 06:25:00 | SPY | ETF | 445.78 | 445.88 | 445.78 | 445.85 | 1730.0 |
| 2022-03-24 06:30:00 | SPY | ETF | 445.85 | 446.02 | 445.75 | 446.02 | 7305.0 |
| 2022-03-24 06:35:00 | SPY | ETF | 445.97 | 445.98 | 445.96 | 445.98 | 2050.0 |
| 2022-03-24 06:40:00 | SPY | ETF | 445.87 | 445.95 | 445.79 | 445.95 | 3399.0 |
| 2022-03-24 06:45:00 | SPY | ETF | 446.0 | 446.0 | 445.95 | 445.96 | 1267.0 |
| 2022-03-24 06:50:00 | SPY | ETF | 445.93 | 445.95 | 445.92 | 445.94 | 29491.0 |
| 2022-03-24 06:55:00 | SPY | ETF | 446.02 | 446.02 | 445.83 | 445.87 | 4200.0 |
| 2022-03-24 07:00:00 | SPY | ETF | 445.8 | 446.07 | 445.64 | 446.0 | 39246.0 |
| 2022-03-24 07:05:00 | SPY | ETF | 445.96 | 447.1 | 445.95 | 446.8 | 38995.0 |
| 2022-03-24 07:10:00 | SPY | ETF | 446.8 | 446.8 | 446.48 | 446.5 | 22728.0 |
| 2022-03-24 07:15:00 | SPY | ETF | 446.5 | 446.61 | 446.5 | 446.5 | 24140.0 |
| 2022-03-24 07:20:00 | SPY | ETF | 446.47 | 446.68 | 446.47 | 446.63 | 3100.0 |
| 2022-03-24 07:25:00 | SPY | ETF | 446.61 | 446.69 | 446.6 | 446.68 | 5580.0 |
| 2022-03-24 07:30:00 | SPY | ETF | 446.62 | 446.8 | 446.58 | 446.72 | 13592.0 |
| 2022-03-24 07:35:00 | SPY | ETF | 446.71 | 446.87 | 446.62 | 446.69 | 25719.0 |
| 2022-03-24 07:40:00 | SPY | ETF | 446.69 | 446.69 | 445.36 | 446.15 | 212346.0 |
| 2022-03-24 07:45:00 | SPY | ETF | 446.16 | 446.45 | 446.11 | 446.3 | 120085.0 |
| 2022-03-24 07:50:00 | SPY | ETF | 446.26 | 446.27 | 445.78 | 445.87 | 28073.0 |
| 2022-03-24 07:55:00 | SPY | ETF | 445.91 | 446.1 | 445.87 | 445.92 | 53633.0 |
| 2022-03-24 08:00:00 | SPY | ETF | 446.69 | 447.0 | 445.25 | 446.2 | 80356.0 |
| 2022-03-24 08:05:00 | SPY | ETF | 446.21 | 446.28 | 446.01 | 446.01 | 24891.0 |
| 2022-03-24 08:10:00 | SPY | ETF | 446.01 | 446.05 | 445.68 | 445.9 | 21332.0 |
| 2022-03-24 08:15:00 | SPY | ETF | 445.9 | 445.9 | 445.67 | 445.74 | 14719.0 |
> showing 50 of 91,888 rows — these rows as CSV