PREVIEW / etf_5min / 2022-10-12
file: by_date/etf_5min/2022/2022-10-12.parquet size: 1.9 MB rows: 93,970
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-12 04:00:00 | SPY | ETF | 359.22 | 359.63 | 358.82 | 359.58 | 20158.0 |
| 2022-10-12 04:05:00 | SPY | ETF | 359.75 | 359.83 | 359.46 | 359.46 | 2189.0 |
| 2022-10-12 04:10:00 | SPY | ETF | 359.56 | 359.56 | 359.07 | 359.55 | 991.0 |
| 2022-10-12 04:15:00 | SPY | ETF | 359.44 | 359.76 | 359.31 | 359.47 | 2300.0 |
| 2022-10-12 04:20:00 | SPY | ETF | 359.5 | 359.6 | 359.37 | 359.6 | 4000.0 |
| 2022-10-12 04:25:00 | SPY | ETF | 359.61 | 360.07 | 359.61 | 360.0 | 2600.0 |
| 2022-10-12 04:30:00 | SPY | ETF | 360.01 | 360.09 | 359.55 | 359.59 | 11764.0 |
| 2022-10-12 04:35:00 | SPY | ETF | 359.41 | 359.47 | 359.3 | 359.3 | 1450.0 |
| 2022-10-12 04:40:00 | SPY | ETF | 359.68 | 359.75 | 359.55 | 359.61 | 2060.0 |
| 2022-10-12 04:45:00 | SPY | ETF | 359.51 | 359.91 | 359.41 | 359.87 | 6500.0 |
| 2022-10-12 04:50:00 | SPY | ETF | 359.59 | 359.8 | 359.55 | 359.55 | 900.0 |
| 2022-10-12 04:55:00 | SPY | ETF | 359.76 | 359.88 | 359.7 | 359.7 | 1000.0 |
| 2022-10-12 05:00:00 | SPY | ETF | 359.6 | 360.29 | 359.51 | 360.22 | 5139.0 |
| 2022-10-12 05:05:00 | SPY | ETF | 359.99 | 359.99 | 359.82 | 359.98 | 2100.0 |
| 2022-10-12 05:10:00 | SPY | ETF | 360.1 | 360.24 | 360.0 | 360.24 | 1850.0 |
| 2022-10-12 05:15:00 | SPY | ETF | 360.22 | 360.5 | 360.22 | 360.33 | 5215.0 |
| 2022-10-12 05:20:00 | SPY | ETF | 360.31 | 360.65 | 360.3 | 360.65 | 2350.0 |
| 2022-10-12 05:25:00 | SPY | ETF | 360.66 | 361.19 | 360.66 | 361.15 | 2317.0 |
| 2022-10-12 05:30:00 | SPY | ETF | 361.08 | 361.08 | 360.88 | 360.88 | 5299.0 |
| 2022-10-12 05:35:00 | SPY | ETF | 360.9 | 360.9 | 360.69 | 360.81 | 1350.0 |
| 2022-10-12 05:40:00 | SPY | ETF | 360.93 | 360.93 | 360.59 | 360.61 | 1875.0 |
| 2022-10-12 05:45:00 | SPY | ETF | 360.66 | 360.66 | 360.36 | 360.36 | 1847.0 |
| 2022-10-12 05:50:00 | SPY | ETF | 360.33 | 360.36 | 360.29 | 360.29 | 400.0 |
| 2022-10-12 05:55:00 | SPY | ETF | 360.3 | 360.5 | 360.3 | 360.5 | 1775.0 |
| 2022-10-12 06:00:00 | SPY | ETF | 360.54 | 360.97 | 360.54 | 360.71 | 4873.0 |
| 2022-10-12 06:05:00 | SPY | ETF | 360.75 | 360.75 | 360.61 | 360.61 | 649.0 |
| 2022-10-12 06:10:00 | SPY | ETF | 360.61 | 360.61 | 360.37 | 360.41 | 900.0 |
| 2022-10-12 06:15:00 | SPY | ETF | 360.62 | 360.64 | 360.39 | 360.39 | 1300.0 |
| 2022-10-12 06:20:00 | SPY | ETF | 360.25 | 360.25 | 359.96 | 359.96 | 4421.0 |
| 2022-10-12 06:25:00 | SPY | ETF | 359.95 | 359.95 | 359.65 | 359.82 | 2549.0 |
| 2022-10-12 06:30:00 | SPY | ETF | 359.83 | 359.83 | 359.51 | 359.51 | 3750.0 |
| 2022-10-12 06:35:00 | SPY | ETF | 359.63 | 359.94 | 359.57 | 359.89 | 1500.0 |
| 2022-10-12 06:40:00 | SPY | ETF | 359.8 | 359.86 | 359.31 | 359.46 | 14000.0 |
| 2022-10-12 06:45:00 | SPY | ETF | 359.52 | 359.7 | 359.27 | 359.32 | 7078.0 |
| 2022-10-12 06:50:00 | SPY | ETF | 359.38 | 359.48 | 359.11 | 359.47 | 5265.0 |
| 2022-10-12 06:55:00 | SPY | ETF | 359.46 | 359.85 | 359.35 | 359.85 | 11501.0 |
| 2022-10-12 07:00:00 | SPY | ETF | 360.0 | 360.06 | 359.81 | 359.91 | 4739.0 |
| 2022-10-12 07:05:00 | SPY | ETF | 359.87 | 360.05 | 359.16 | 359.941 | 41759.0 |
| 2022-10-12 07:10:00 | SPY | ETF | 359.98 | 360.29 | 359.72 | 360.29 | 55615.0 |
| 2022-10-12 07:15:00 | SPY | ETF | 360.16 | 360.18 | 359.85 | 360.0 | 16907.0 |
| 2022-10-12 07:20:00 | SPY | ETF | 360.02 | 360.2 | 359.99 | 360.04 | 17350.0 |
| 2022-10-12 07:25:00 | SPY | ETF | 360.11 | 360.47 | 360.1 | 360.38 | 17559.0 |
| 2022-10-12 07:30:00 | SPY | ETF | 360.47 | 360.48 | 360.29 | 360.32 | 19299.0 |
| 2022-10-12 07:35:00 | SPY | ETF | 360.35 | 360.75 | 360.24 | 360.61 | 26647.0 |
| 2022-10-12 07:40:00 | SPY | ETF | 360.62 | 360.62 | 360.22 | 360.22 | 35923.0 |
| 2022-10-12 07:45:00 | SPY | ETF | 360.29 | 360.29 | 359.95 | 360.03 | 7639.0 |
| 2022-10-12 07:50:00 | SPY | ETF | 360.09 | 360.2 | 359.9 | 360.18 | 17411.0 |
| 2022-10-12 07:55:00 | SPY | ETF | 360.19 | 360.32 | 359.95 | 359.98 | 20947.0 |
| 2022-10-12 08:00:00 | SPY | ETF | 360.05 | 361.0204 | 359.1 | 360.05 | 106844.0 |
| 2022-10-12 08:05:00 | SPY | ETF | 360.04 | 360.34 | 359.82 | 360.26 | 101485.0 |
> showing 50 of 93,970 rows — these rows as CSV