PREVIEW / etf_5min / 2022-07-06
file: by_date/etf_5min/2022/2022-07-06.parquet size: 1.9 MB rows: 94,902
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-07-06 04:00:00 | SPY | ETF | 382.25 | 382.45 | 381.6 | 381.6 | 7008.0 |
| 2022-07-06 04:05:00 | SPY | ETF | 381.55 | 382.3 | 381.48 | 382.3 | 11400.0 |
| 2022-07-06 04:10:00 | SPY | ETF | 382.18 | 382.5 | 382.17 | 382.47 | 5600.0 |
| 2022-07-06 04:15:00 | SPY | ETF | 382.3 | 382.3 | 381.8 | 381.83 | 2700.0 |
| 2022-07-06 04:20:00 | SPY | ETF | 381.74 | 381.9 | 381.74 | 381.9 | 1200.0 |
| 2022-07-06 04:25:00 | SPY | ETF | 381.78 | 381.78 | 381.53 | 381.53 | 1600.0 |
| 2022-07-06 04:30:00 | SPY | ETF | 381.2 | 381.2 | 380.93 | 380.95 | 10771.0 |
| 2022-07-06 04:35:00 | SPY | ETF | 381.05 | 381.17 | 380.97 | 381.04 | 2930.0 |
| 2022-07-06 04:40:00 | SPY | ETF | 380.61 | 380.64 | 380.51 | 380.64 | 8947.0 |
| 2022-07-06 04:45:00 | SPY | ETF | 380.6 | 380.73 | 380.54 | 380.54 | 3799.0 |
| 2022-07-06 04:50:00 | SPY | ETF | 380.75 | 381.01 | 380.75 | 381.01 | 1963.0 |
| 2022-07-06 04:55:00 | SPY | ETF | 381.07 | 381.07 | 380.72 | 380.72 | 1413.0 |
| 2022-07-06 05:00:00 | SPY | ETF | 380.75 | 380.75 | 380.36 | 380.38 | 1687.0 |
| 2022-07-06 05:05:00 | SPY | ETF | 380.34 | 380.7 | 380.34 | 380.7 | 3450.0 |
| 2022-07-06 05:10:00 | SPY | ETF | 380.74 | 380.74 | 380.4 | 380.4 | 1549.0 |
| 2022-07-06 05:15:00 | SPY | ETF | 380.45 | 380.6 | 380.21 | 380.6 | 2000.0 |
| 2022-07-06 05:20:00 | SPY | ETF | 380.84 | 381.09 | 380.84 | 381.09 | 2801.0 |
| 2022-07-06 05:25:00 | SPY | ETF | 381.22 | 381.43 | 381.22 | 381.43 | 4200.0 |
| 2022-07-06 05:30:00 | SPY | ETF | 381.45 | 381.5 | 381.15 | 381.15 | 4250.0 |
| 2022-07-06 05:35:00 | SPY | ETF | 381.1 | 381.11 | 380.98 | 380.98 | 1700.0 |
| 2022-07-06 05:40:00 | SPY | ETF | 381.23 | 381.37 | 381.15 | 381.37 | 1409.0 |
| 2022-07-06 05:45:00 | SPY | ETF | 381.41 | 381.41 | 381.32 | 381.39 | 1800.0 |
| 2022-07-06 05:50:00 | SPY | ETF | 381.4 | 381.75 | 381.38 | 381.75 | 900.0 |
| 2022-07-06 05:55:00 | SPY | ETF | 381.7 | 381.78 | 381.68 | 381.77 | 1950.0 |
| 2022-07-06 06:00:00 | SPY | ETF | 381.73 | 381.89 | 381.68 | 381.68 | 2700.0 |
| 2022-07-06 06:05:00 | SPY | ETF | 381.68 | 382.02 | 381.68 | 381.91 | 25444.0 |
| 2022-07-06 06:10:00 | SPY | ETF | 381.68 | 381.68 | 381.58 | 381.67 | 850.0 |
| 2022-07-06 06:15:00 | SPY | ETF | 381.78 | 381.84 | 381.66 | 381.84 | 2450.0 |
| 2022-07-06 06:20:00 | SPY | ETF | 381.65 | 382.1 | 381.65 | 382.1 | 2950.0 |
| 2022-07-06 06:25:00 | SPY | ETF | 382.07 | 382.09 | 381.96 | 382.09 | 2000.0 |
| 2022-07-06 06:30:00 | SPY | ETF | 382.1 | 382.22 | 382.08 | 382.14 | 2044.0 |
| 2022-07-06 06:35:00 | SPY | ETF | 382.11 | 382.11 | 381.98 | 382.02 | 898.0 |
| 2022-07-06 06:40:00 | SPY | ETF | 381.88 | 381.88 | 381.5 | 381.55 | 5196.0 |
| 2022-07-06 06:45:00 | SPY | ETF | 381.55 | 381.55 | 381.33 | 381.45 | 2495.0 |
| 2022-07-06 06:50:00 | SPY | ETF | 381.33 | 381.34 | 381.14 | 381.26 | 2915.0 |
| 2022-07-06 06:55:00 | SPY | ETF | 381.18 | 381.42 | 381.18 | 381.42 | 3840.0 |
| 2022-07-06 07:00:00 | SPY | ETF | 381.28 | 381.33 | 381.25 | 381.25 | 8747.0 |
| 2022-07-06 07:05:00 | SPY | ETF | 381.12 | 381.16 | 380.95 | 381.07 | 17698.0 |
| 2022-07-06 07:10:00 | SPY | ETF | 381.1 | 381.1 | 380.92 | 381.0 | 5300.0 |
| 2022-07-06 07:15:00 | SPY | ETF | 381.04 | 381.2 | 380.95 | 381.2 | 13509.0 |
| 2022-07-06 07:20:00 | SPY | ETF | 381.19 | 381.19 | 381.05 | 381.15 | 6650.0 |
| 2022-07-06 07:25:00 | SPY | ETF | 381.22 | 381.33 | 380.92 | 380.93 | 12492.0 |
| 2022-07-06 07:30:00 | SPY | ETF | 380.97 | 381.14 | 380.91 | 381.11 | 16367.0 |
| 2022-07-06 07:35:00 | SPY | ETF | 381.05 | 381.14 | 380.99 | 381.05 | 1747.0 |
| 2022-07-06 07:40:00 | SPY | ETF | 380.99 | 380.99 | 380.62 | 380.62 | 9807.0 |
| 2022-07-06 07:45:00 | SPY | ETF | 380.6 | 380.6 | 380.35 | 380.39 | 18809.0 |
| 2022-07-06 07:50:00 | SPY | ETF | 380.36 | 380.51 | 380.14 | 380.51 | 50914.0 |
| 2022-07-06 07:55:00 | SPY | ETF | 380.43 | 380.57 | 380.4 | 380.47 | 7173.0 |
| 2022-07-06 08:00:00 | SPY | ETF | 380.99 | 382.99 | 379.96 | 380.1 | 51627.0 |
| 2022-07-06 08:05:00 | SPY | ETF | 380.11 | 380.42 | 380.06 | 380.1301 | 48550.0 |
> showing 50 of 94,902 rows — these rows as CSV