PREVIEW / etf_5min / 2022-12-28
file: by_date/etf_5min/2022/2022-12-28.parquet size: 2.1 MB rows: 102,655
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-12-28 04:00:00 | SPY | ETF | 382.0 | 382.0 | 381.81 | 381.82 | 10247.0 |
| 2022-12-28 04:05:00 | SPY | ETF | 381.85 | 381.85 | 381.67 | 381.67 | 5903.0 |
| 2022-12-28 04:10:00 | SPY | ETF | 381.5 | 381.51 | 381.22 | 381.24 | 7694.0 |
| 2022-12-28 04:15:00 | SPY | ETF | 381.31 | 381.37 | 381.31 | 381.37 | 300.0 |
| 2022-12-28 04:20:00 | SPY | ETF | 381.34 | 381.39 | 381.34 | 381.39 | 2400.0 |
| 2022-12-28 04:25:00 | SPY | ETF | 381.29 | 381.29 | 381.15 | 381.15 | 225.0 |
| 2022-12-28 04:30:00 | SPY | ETF | 381.22 | 381.25 | 381.22 | 381.25 | 900.0 |
| 2022-12-28 04:35:00 | SPY | ETF | 381.51 | 381.51 | 381.4 | 381.43 | 4433.0 |
| 2022-12-28 04:40:00 | SPY | ETF | 381.43 | 381.44 | 381.4 | 381.44 | 2200.0 |
| 2022-12-28 04:45:00 | SPY | ETF | 381.54 | 381.65 | 381.54 | 381.62 | 3172.0 |
| 2022-12-28 04:50:00 | SPY | ETF | 381.7 | 381.71 | 381.63 | 381.63 | 336.0 |
| 2022-12-28 04:55:00 | SPY | ETF | 381.5 | 381.67 | 381.5 | 381.67 | 1249.0 |
| 2022-12-28 05:00:00 | SPY | ETF | 381.7 | 381.7 | 381.69 | 381.69 | 1200.0 |
| 2022-12-28 05:05:00 | SPY | ETF | 381.74 | 381.74 | 381.7 | 381.7 | 718.0 |
| 2022-12-28 05:10:00 | SPY | ETF | 381.6 | 381.83 | 381.6 | 381.83 | 919.0 |
| 2022-12-28 05:15:00 | SPY | ETF | 381.81 | 381.81 | 381.72 | 381.76 | 500.0 |
| 2022-12-28 05:20:00 | SPY | ETF | 381.85 | 381.95 | 381.85 | 381.95 | 1619.0 |
| 2022-12-28 05:25:00 | SPY | ETF | 381.67 | 381.67 | 381.67 | 381.67 | 500.0 |
| 2022-12-28 05:30:00 | SPY | ETF | 381.66 | 381.73 | 381.66 | 381.73 | 300.0 |
| 2022-12-28 05:35:00 | SPY | ETF | 381.6 | 381.68 | 381.52 | 381.68 | 700.0 |
| 2022-12-28 05:45:00 | SPY | ETF | 381.75 | 381.87 | 381.75 | 381.83 | 1542.0 |
| 2022-12-28 05:50:00 | SPY | ETF | 381.79 | 382.06 | 381.79 | 382.06 | 3895.0 |
| 2022-12-28 05:55:00 | SPY | ETF | 382.08 | 382.34 | 382.08 | 382.18 | 12375.0 |
| 2022-12-28 06:00:00 | SPY | ETF | 382.21 | 382.3 | 382.19 | 382.3 | 6092.0 |
| 2022-12-28 06:05:00 | SPY | ETF | 382.3 | 382.3 | 382.16 | 382.18 | 1960.0 |
| 2022-12-28 06:10:00 | SPY | ETF | 382.25 | 382.25 | 382.18 | 382.18 | 300.0 |
| 2022-12-28 06:15:00 | SPY | ETF | 382.03 | 382.05 | 382.03 | 382.05 | 3207.0 |
| 2022-12-28 06:20:00 | SPY | ETF | 382.18 | 382.18 | 381.94 | 382.1 | 6551.0 |
| 2022-12-28 06:25:00 | SPY | ETF | 382.09 | 382.09 | 382.08 | 382.08 | 283.0 |
| 2022-12-28 06:30:00 | SPY | ETF | 382.03 | 382.04 | 381.99 | 381.99 | 700.0 |
| 2022-12-28 06:35:00 | SPY | ETF | 382.11 | 382.11 | 382.09 | 382.1 | 1100.0 |
| 2022-12-28 06:40:00 | SPY | ETF | 382.14 | 382.14 | 382.03 | 382.04 | 1483.0 |
| 2022-12-28 06:45:00 | SPY | ETF | 382.29 | 382.52 | 382.29 | 382.52 | 3013.0 |
| 2022-12-28 06:50:00 | SPY | ETF | 382.45 | 382.46 | 382.44 | 382.44 | 2200.0 |
| 2022-12-28 06:55:00 | SPY | ETF | 382.4 | 382.45 | 382.4 | 382.45 | 738.0 |
| 2022-12-28 07:00:00 | SPY | ETF | 382.46 | 382.46 | 382.25 | 382.34 | 15503.0 |
| 2022-12-28 07:05:00 | SPY | ETF | 382.32 | 382.45 | 382.32 | 382.44 | 20913.0 |
| 2022-12-28 07:10:00 | SPY | ETF | 382.28 | 382.37 | 382.26 | 382.32 | 14974.0 |
| 2022-12-28 07:15:00 | SPY | ETF | 382.32 | 382.43 | 382.3 | 382.3 | 13810.0 |
| 2022-12-28 07:20:00 | SPY | ETF | 382.31 | 382.44 | 382.31 | 382.44 | 19497.0 |
| 2022-12-28 07:25:00 | SPY | ETF | 382.43 | 382.45 | 382.37 | 382.45 | 25298.0 |
| 2022-12-28 07:30:00 | SPY | ETF | 382.5 | 382.61 | 382.5 | 382.54 | 12274.0 |
| 2022-12-28 07:35:00 | SPY | ETF | 382.45 | 382.53 | 382.4 | 382.4 | 46673.0 |
| 2022-12-28 07:40:00 | SPY | ETF | 382.35 | 382.42 | 382.3 | 382.42 | 15669.0 |
| 2022-12-28 07:45:00 | SPY | ETF | 382.4 | 382.59 | 382.4 | 382.59 | 3176.0 |
| 2022-12-28 07:50:00 | SPY | ETF | 382.54 | 382.64 | 382.54 | 382.54 | 38324.0 |
| 2022-12-28 07:55:00 | SPY | ETF | 382.6 | 382.68 | 382.53 | 382.55 | 4841.0 |
| 2022-12-28 08:00:00 | SPY | ETF | 382.38 | 382.69 | 381.3304 | 382.69 | 26838.0 |
| 2022-12-28 08:05:00 | SPY | ETF | 382.65 | 382.7 | 382.43 | 382.43 | 8529.0 |
| 2022-12-28 08:10:00 | SPY | ETF | 382.43 | 382.55 | 382.42 | 382.47 | 16494.0 |
> showing 50 of 102,655 rows — these rows as CSV