PREVIEW / etf_5min / 2022-08-11
file: by_date/etf_5min/2022/2022-08-11.parquet size: 1.9 MB rows: 93,405
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-08-11 04:00:00 | SPY | ETF | 421.0 | 421.0 | 420.79 | 420.8 | 3652.0 |
| 2022-08-11 04:05:00 | SPY | ETF | 420.71 | 420.79 | 420.57 | 420.74 | 1375.0 |
| 2022-08-11 04:10:00 | SPY | ETF | 420.7 | 420.81 | 420.7 | 420.79 | 1298.0 |
| 2022-08-11 04:15:00 | SPY | ETF | 420.84 | 420.96 | 420.84 | 420.96 | 946.0 |
| 2022-08-11 04:20:00 | SPY | ETF | 420.84 | 420.84 | 420.7 | 420.7 | 3392.0 |
| 2022-08-11 04:25:00 | SPY | ETF | 420.64 | 420.67 | 420.5 | 420.5 | 6952.0 |
| 2022-08-11 04:30:00 | SPY | ETF | 420.53 | 420.73 | 420.38 | 420.73 | 3039.0 |
| 2022-08-11 04:35:00 | SPY | ETF | 420.76 | 420.76 | 420.55 | 420.55 | 1493.0 |
| 2022-08-11 04:40:00 | SPY | ETF | 420.58 | 420.64 | 420.58 | 420.64 | 1200.0 |
| 2022-08-11 04:45:00 | SPY | ETF | 420.66 | 420.66 | 420.54 | 420.56 | 2200.0 |
| 2022-08-11 04:50:00 | SPY | ETF | 420.5 | 420.5 | 420.3 | 420.3 | 1000.0 |
| 2022-08-11 04:55:00 | SPY | ETF | 420.46 | 420.75 | 420.46 | 420.75 | 1714.0 |
| 2022-08-11 05:00:00 | SPY | ETF | 420.88 | 420.88 | 420.88 | 420.88 | 250.0 |
| 2022-08-11 05:05:00 | SPY | ETF | 420.93 | 420.95 | 420.67 | 420.67 | 6693.0 |
| 2022-08-11 05:10:00 | SPY | ETF | 420.67 | 420.78 | 420.65 | 420.67 | 5304.0 |
| 2022-08-11 05:15:00 | SPY | ETF | 420.73 | 420.82 | 420.73 | 420.76 | 2041.0 |
| 2022-08-11 05:20:00 | SPY | ETF | 420.74 | 420.74 | 420.74 | 420.74 | 500.0 |
| 2022-08-11 05:25:00 | SPY | ETF | 420.8 | 421.01 | 420.78 | 421.01 | 5152.0 |
| 2022-08-11 05:30:00 | SPY | ETF | 421.02 | 421.24 | 421.02 | 421.24 | 1664.0 |
| 2022-08-11 05:35:00 | SPY | ETF | 421.31 | 421.4 | 421.2 | 421.2 | 8413.0 |
| 2022-08-11 05:40:00 | SPY | ETF | 421.05 | 421.4 | 421.05 | 421.36 | 3400.0 |
| 2022-08-11 05:45:00 | SPY | ETF | 421.42 | 421.52 | 421.27 | 421.43 | 9100.0 |
| 2022-08-11 05:50:00 | SPY | ETF | 421.47 | 421.47 | 421.3 | 421.3 | 1100.0 |
| 2022-08-11 05:55:00 | SPY | ETF | 421.27 | 421.27 | 421.27 | 421.27 | 200.0 |
| 2022-08-11 06:00:00 | SPY | ETF | 421.3 | 421.3 | 421.18 | 421.18 | 1711.0 |
| 2022-08-11 06:05:00 | SPY | ETF | 421.09 | 421.09 | 421.01 | 421.01 | 1080.0 |
| 2022-08-11 06:10:00 | SPY | ETF | 420.98 | 421.07 | 420.98 | 421.07 | 7360.0 |
| 2022-08-11 06:15:00 | SPY | ETF | 421.01 | 421.01 | 421.01 | 421.01 | 200.0 |
| 2022-08-11 06:20:00 | SPY | ETF | 420.96 | 421.0 | 420.82 | 420.95 | 8126.0 |
| 2022-08-11 06:25:00 | SPY | ETF | 420.97 | 421.09 | 420.91 | 421.09 | 2116.0 |
| 2022-08-11 06:30:00 | SPY | ETF | 421.07 | 421.21 | 421.07 | 421.21 | 1700.0 |
| 2022-08-11 06:35:00 | SPY | ETF | 421.13 | 421.14 | 421.02 | 421.02 | 496.0 |
| 2022-08-11 06:40:00 | SPY | ETF | 421.11 | 421.17 | 421.0 | 421.0 | 733.0 |
| 2022-08-11 06:45:00 | SPY | ETF | 421.01 | 421.26 | 421.01 | 421.14 | 5572.0 |
| 2022-08-11 06:50:00 | SPY | ETF | 421.11 | 421.12 | 420.98 | 421.08 | 2912.0 |
| 2022-08-11 06:55:00 | SPY | ETF | 421.08 | 421.32 | 421.08 | 421.17 | 5400.0 |
| 2022-08-11 07:00:00 | SPY | ETF | 421.16 | 421.21 | 421.05 | 421.2 | 16489.0 |
| 2022-08-11 07:05:00 | SPY | ETF | 421.23 | 421.38 | 421.2 | 421.38 | 13686.0 |
| 2022-08-11 07:10:00 | SPY | ETF | 421.33 | 421.37 | 421.15 | 421.19 | 23714.0 |
| 2022-08-11 07:15:00 | SPY | ETF | 421.28 | 421.38 | 421.26 | 421.36 | 3402.0 |
| 2022-08-11 07:20:00 | SPY | ETF | 421.35 | 421.35 | 421.11 | 421.11 | 7174.0 |
| 2022-08-11 07:25:00 | SPY | ETF | 421.14 | 421.33 | 421.14 | 421.33 | 3100.0 |
| 2022-08-11 07:30:00 | SPY | ETF | 421.33 | 421.49 | 421.32 | 421.46 | 4504.0 |
| 2022-08-11 07:35:00 | SPY | ETF | 421.46 | 421.85 | 421.46 | 421.781 | 10279.0 |
| 2022-08-11 07:40:00 | SPY | ETF | 421.78 | 421.84 | 421.68 | 421.77 | 16440.0 |
| 2022-08-11 07:45:00 | SPY | ETF | 421.78 | 421.88 | 421.731 | 421.75 | 4438.0 |
| 2022-08-11 07:50:00 | SPY | ETF | 421.78 | 421.9 | 421.69 | 421.72 | 19081.0 |
| 2022-08-11 07:55:00 | SPY | ETF | 421.75 | 421.75 | 421.6 | 421.7 | 7413.0 |
| 2022-08-11 08:00:00 | SPY | ETF | 421.73 | 422.22 | 420.7112 | 422.05 | 62112.0 |
| 2022-08-11 08:05:00 | SPY | ETF | 422.03 | 422.1 | 421.91 | 421.99 | 28135.0 |
> showing 50 of 93,405 rows — these rows as CSV