PREVIEW / etf_5min / 2022-02-03
file: by_date/etf_5min/2022/2022-02-03.parquet size: 2.0 MB rows: 95,872
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-02-03 04:00:00 | SPY | ETF | 453.28 | 453.28 | 453.16 | 453.16 | 215.0 |
| 2022-02-03 04:05:00 | SPY | ETF | 453.29 | 453.29 | 453.06 | 453.09 | 3400.0 |
| 2022-02-03 04:10:00 | SPY | ETF | 453.03 | 453.34 | 453.03 | 453.34 | 710.0 |
| 2022-02-03 04:15:00 | SPY | ETF | 453.38 | 453.42 | 453.37 | 453.42 | 1470.0 |
| 2022-02-03 04:20:00 | SPY | ETF | 453.57 | 453.57 | 453.51 | 453.51 | 200.0 |
| 2022-02-03 04:25:00 | SPY | ETF | 453.37 | 453.37 | 453.11 | 453.11 | 250.0 |
| 2022-02-03 04:30:00 | SPY | ETF | 453.22 | 453.22 | 453.14 | 453.14 | 923.0 |
| 2022-02-03 04:40:00 | SPY | ETF | 452.78 | 452.78 | 452.33 | 452.55 | 11779.0 |
| 2022-02-03 04:45:00 | SPY | ETF | 452.88 | 452.89 | 452.85 | 452.85 | 13799.0 |
| 2022-02-03 04:50:00 | SPY | ETF | 452.87 | 452.87 | 452.37 | 452.37 | 3600.0 |
| 2022-02-03 04:55:00 | SPY | ETF | 452.32 | 452.32 | 452.03 | 452.07 | 1589.0 |
| 2022-02-03 05:00:00 | SPY | ETF | 452.19 | 452.24 | 452.14 | 452.23 | 3159.0 |
| 2022-02-03 05:05:00 | SPY | ETF | 452.37 | 452.5 | 452.34 | 452.48 | 2464.0 |
| 2022-02-03 05:10:00 | SPY | ETF | 452.57 | 452.65 | 452.43 | 452.5 | 670.0 |
| 2022-02-03 05:15:00 | SPY | ETF | 452.6 | 452.6 | 452.6 | 452.6 | 115.0 |
| 2022-02-03 05:20:00 | SPY | ETF | 452.79 | 452.79 | 452.38 | 452.48 | 25829.0 |
| 2022-02-03 05:25:00 | SPY | ETF | 452.46 | 452.62 | 452.45 | 452.62 | 2729.0 |
| 2022-02-03 05:35:00 | SPY | ETF | 452.37 | 452.4 | 452.27 | 452.4 | 3213.0 |
| 2022-02-03 05:40:00 | SPY | ETF | 452.32 | 452.32 | 452.3 | 452.3 | 616.0 |
| 2022-02-03 05:50:00 | SPY | ETF | 452.15 | 452.15 | 452.1 | 452.1 | 200.0 |
| 2022-02-03 05:55:00 | SPY | ETF | 452.01 | 452.19 | 451.93 | 452.19 | 11308.0 |
| 2022-02-03 06:00:00 | SPY | ETF | 452.2 | 452.2 | 452.0 | 452.18 | 380.0 |
| 2022-02-03 06:05:00 | SPY | ETF | 452.38 | 452.64 | 452.38 | 452.64 | 3039.0 |
| 2022-02-03 06:10:00 | SPY | ETF | 452.34 | 452.34 | 452.16 | 452.16 | 426.0 |
| 2022-02-03 06:15:00 | SPY | ETF | 452.18 | 452.18 | 451.81 | 451.81 | 1844.0 |
| 2022-02-03 06:20:00 | SPY | ETF | 451.72 | 451.75 | 451.7 | 451.75 | 1379.0 |
| 2022-02-03 06:25:00 | SPY | ETF | 451.64 | 451.88 | 451.61 | 451.83 | 3455.0 |
| 2022-02-03 06:30:00 | SPY | ETF | 451.7 | 451.7 | 451.59 | 451.59 | 365.0 |
| 2022-02-03 06:35:00 | SPY | ETF | 451.83 | 451.84 | 451.75 | 451.75 | 1900.0 |
| 2022-02-03 06:40:00 | SPY | ETF | 451.74 | 451.93 | 451.67 | 451.93 | 2471.0 |
| 2022-02-03 06:45:00 | SPY | ETF | 452.0 | 452.07 | 451.98 | 452.06 | 1892.0 |
| 2022-02-03 06:50:00 | SPY | ETF | 452.06 | 452.32 | 452.06 | 452.25 | 23246.0 |
| 2022-02-03 06:55:00 | SPY | ETF | 452.27 | 452.5 | 452.27 | 452.5 | 8149.0 |
| 2022-02-03 07:00:00 | SPY | ETF | 452.44 | 452.55 | 451.9 | 452.0 | 42454.0 |
| 2022-02-03 07:05:00 | SPY | ETF | 451.95 | 452.15 | 451.92 | 452.14 | 54274.0 |
| 2022-02-03 07:10:00 | SPY | ETF | 452.16 | 452.459 | 452.16 | 452.37 | 17250.0 |
| 2022-02-03 07:15:00 | SPY | ETF | 452.4 | 452.8 | 452.33 | 452.8 | 36561.0 |
| 2022-02-03 07:20:00 | SPY | ETF | 452.62 | 452.75 | 452.55 | 452.58 | 23246.0 |
| 2022-02-03 07:25:00 | SPY | ETF | 452.46 | 452.65 | 452.3 | 452.65 | 22852.0 |
| 2022-02-03 07:30:00 | SPY | ETF | 452.66 | 452.66 | 452.33 | 452.55 | 25834.0 |
| 2022-02-03 07:35:00 | SPY | ETF | 452.56 | 453.44 | 452.56 | 453.44 | 22990.0 |
| 2022-02-03 07:40:00 | SPY | ETF | 453.39 | 453.51 | 453.05 | 453.05 | 29627.0 |
| 2022-02-03 07:45:00 | SPY | ETF | 453.25 | 453.25 | 453.0 | 453.1 | 36481.0 |
| 2022-02-03 07:50:00 | SPY | ETF | 453.07 | 453.59 | 453.01 | 453.42 | 49311.0 |
| 2022-02-03 07:55:00 | SPY | ETF | 453.4 | 453.4 | 453.02 | 453.15 | 74670.0 |
| 2022-02-03 08:00:00 | SPY | ETF | 452.9 | 457.693 | 451.6896 | 452.87 | 139605.0 |
| 2022-02-03 08:05:00 | SPY | ETF | 452.96 | 453.05 | 452.65 | 452.7299 | 54818.0 |
| 2022-02-03 08:10:00 | SPY | ETF | 452.71 | 452.75 | 452.31 | 452.45 | 34673.0 |
| 2022-02-03 08:15:00 | SPY | ETF | 452.46 | 452.83 | 452.45 | 452.83 | 60416.0 |
| 2022-02-03 08:20:00 | SPY | ETF | 452.76 | 452.83 | 452.5 | 452.72 | 15165.0 |
> showing 50 of 95,872 rows — these rows as CSV