PREVIEW / etf_5min / 2022-10-20
file: by_date/etf_5min/2022/2022-10-20.parquet size: 1.9 MB rows: 94,563
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-10-20 04:00:00 | SPY | ETF | 367.49 | 367.49 | 366.13 | 366.7 | 15819.0 |
| 2022-10-20 04:05:00 | SPY | ETF | 366.8 | 367.12 | 366.8 | 366.9 | 4821.0 |
| 2022-10-20 04:10:00 | SPY | ETF | 366.8 | 366.82 | 366.23 | 366.23 | 6302.0 |
| 2022-10-20 04:15:00 | SPY | ETF | 366.4 | 366.72 | 366.4 | 366.72 | 1033.0 |
| 2022-10-20 04:20:00 | SPY | ETF | 366.78 | 366.78 | 366.75 | 366.75 | 425.0 |
| 2022-10-20 04:25:00 | SPY | ETF | 366.63 | 366.63 | 366.4 | 366.4 | 300.0 |
| 2022-10-20 04:30:00 | SPY | ETF | 366.57 | 366.57 | 366.57 | 366.57 | 100.0 |
| 2022-10-20 04:35:00 | SPY | ETF | 366.79 | 367.01 | 366.78 | 367.01 | 725.0 |
| 2022-10-20 04:40:00 | SPY | ETF | 367.03 | 367.04 | 366.92 | 367.04 | 612.0 |
| 2022-10-20 04:45:00 | SPY | ETF | 367.13 | 367.13 | 367.04 | 367.1 | 1300.0 |
| 2022-10-20 04:50:00 | SPY | ETF | 367.2 | 367.23 | 366.92 | 366.97 | 2422.0 |
| 2022-10-20 04:55:00 | SPY | ETF | 366.7 | 366.7 | 366.7 | 366.7 | 100.0 |
| 2022-10-20 05:00:00 | SPY | ETF | 366.71 | 366.71 | 366.7 | 366.7 | 800.0 |
| 2022-10-20 05:05:00 | SPY | ETF | 366.99 | 367.1 | 366.97 | 367.1 | 1250.0 |
| 2022-10-20 05:10:00 | SPY | ETF | 367.24 | 367.24 | 367.03 | 367.03 | 3958.0 |
| 2022-10-20 05:15:00 | SPY | ETF | 367.05 | 367.41 | 367.03 | 367.21 | 31330.0 |
| 2022-10-20 05:20:00 | SPY | ETF | 367.2 | 367.31 | 367.0 | 367.0 | 21450.0 |
| 2022-10-20 05:25:00 | SPY | ETF | 367.0 | 367.18 | 366.95 | 367.1 | 3500.0 |
| 2022-10-20 05:30:00 | SPY | ETF | 367.3 | 367.65 | 367.22 | 367.65 | 3300.0 |
| 2022-10-20 05:35:00 | SPY | ETF | 367.69 | 367.91 | 367.69 | 367.69 | 5100.0 |
| 2022-10-20 05:40:00 | SPY | ETF | 367.6 | 367.71 | 367.5 | 367.5 | 1150.0 |
| 2022-10-20 05:45:00 | SPY | ETF | 367.75 | 367.99 | 367.75 | 367.99 | 2680.0 |
| 2022-10-20 05:50:00 | SPY | ETF | 367.8 | 367.95 | 367.7 | 367.95 | 1400.0 |
| 2022-10-20 05:55:00 | SPY | ETF | 367.95 | 367.95 | 367.55 | 367.59 | 3275.0 |
| 2022-10-20 06:00:00 | SPY | ETF | 367.55 | 367.63 | 367.27 | 367.27 | 3700.0 |
| 2022-10-20 06:05:00 | SPY | ETF | 367.65 | 367.65 | 367.41 | 367.41 | 3380.0 |
| 2022-10-20 06:10:00 | SPY | ETF | 367.3 | 367.4 | 367.29 | 367.4 | 1275.0 |
| 2022-10-20 06:15:00 | SPY | ETF | 367.45 | 367.45 | 367.45 | 367.45 | 100.0 |
| 2022-10-20 06:20:00 | SPY | ETF | 367.35 | 367.68 | 367.35 | 367.68 | 21550.0 |
| 2022-10-20 06:25:00 | SPY | ETF | 367.79 | 367.9 | 367.75 | 367.75 | 30664.0 |
| 2022-10-20 06:30:00 | SPY | ETF | 367.85 | 368.03 | 367.83 | 367.88 | 5125.0 |
| 2022-10-20 06:35:00 | SPY | ETF | 367.86 | 368.35 | 367.86 | 368.29 | 20448.0 |
| 2022-10-20 06:40:00 | SPY | ETF | 368.32 | 369.1 | 368.29 | 368.94 | 21237.0 |
| 2022-10-20 06:45:00 | SPY | ETF | 368.9 | 368.9 | 368.45 | 368.59 | 7081.0 |
| 2022-10-20 06:50:00 | SPY | ETF | 368.83 | 369.94 | 368.83 | 369.91 | 34434.0 |
| 2022-10-20 06:55:00 | SPY | ETF | 369.88 | 370.07 | 369.25 | 369.54 | 39448.0 |
| 2022-10-20 07:00:00 | SPY | ETF | 369.54 | 370.09 | 369.29 | 370.08 | 42341.0 |
| 2022-10-20 07:05:00 | SPY | ETF | 370.0 | 370.0 | 369.62 | 369.94 | 28007.0 |
| 2022-10-20 07:10:00 | SPY | ETF | 369.86 | 370.45 | 369.76 | 369.81 | 61025.0 |
| 2022-10-20 07:15:00 | SPY | ETF | 369.84 | 370.24 | 369.83 | 370.07 | 36754.0 |
| 2022-10-20 07:20:00 | SPY | ETF | 370.1 | 370.16 | 369.65 | 369.76 | 26515.0 |
| 2022-10-20 07:25:00 | SPY | ETF | 369.75 | 369.75 | 369.5 | 369.54 | 15008.0 |
| 2022-10-20 07:30:00 | SPY | ETF | 369.55 | 369.74 | 369.28 | 369.35 | 24220.0 |
| 2022-10-20 07:35:00 | SPY | ETF | 369.49 | 369.5 | 369.18 | 369.25 | 11762.0 |
| 2022-10-20 07:40:00 | SPY | ETF | 369.24 | 369.24 | 368.8 | 368.8 | 33096.0 |
| 2022-10-20 07:45:00 | SPY | ETF | 368.77 | 369.4 | 368.77 | 369.21 | 26422.0 |
| 2022-10-20 07:50:00 | SPY | ETF | 369.13 | 369.2 | 368.86 | 369.17 | 31252.0 |
| 2022-10-20 07:55:00 | SPY | ETF | 369.2 | 369.54 | 369.19 | 369.44 | 18555.0 |
| 2022-10-20 08:00:00 | SPY | ETF | 369.7598 | 370.32 | 366.18 | 369.87 | 122401.0 |
| 2022-10-20 08:05:00 | SPY | ETF | 369.88 | 369.88 | 369.08 | 369.24 | 43697.0 |
> showing 50 of 94,563 rows — these rows as CSV