PREVIEW / etf_5min / 2023-01-03
file: by_date/etf_5min/2023/2023-01-03.parquet size: 2.0 MB rows: 101,928
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-03 04:00:00 | SPY | ETF | 384.0 | 386.54 | 384.0 | 386.51 | 23462.0 |
| 2023-01-03 04:05:00 | SPY | ETF | 386.5 | 386.53 | 385.91 | 385.96 | 48472.0 |
| 2023-01-03 04:10:00 | SPY | ETF | 386.18 | 386.51 | 386.13 | 386.51 | 6729.0 |
| 2023-01-03 04:15:00 | SPY | ETF | 386.54 | 386.79 | 386.28 | 386.28 | 7730.0 |
| 2023-01-03 04:20:00 | SPY | ETF | 386.48 | 386.7 | 386.48 | 386.7 | 3542.0 |
| 2023-01-03 04:25:00 | SPY | ETF | 386.79 | 386.83 | 386.47 | 386.5 | 7522.0 |
| 2023-01-03 04:30:00 | SPY | ETF | 386.68 | 386.68 | 386.5 | 386.65 | 3464.0 |
| 2023-01-03 04:35:00 | SPY | ETF | 386.68 | 386.75 | 386.41 | 386.41 | 4073.0 |
| 2023-01-03 04:40:00 | SPY | ETF | 386.47 | 386.74 | 386.47 | 386.49 | 14212.0 |
| 2023-01-03 04:45:00 | SPY | ETF | 386.53 | 386.74 | 386.53 | 386.74 | 2130.0 |
| 2023-01-03 04:50:00 | SPY | ETF | 386.72 | 386.81 | 386.7 | 386.7 | 2130.0 |
| 2023-01-03 04:55:00 | SPY | ETF | 386.66 | 386.83 | 386.64 | 386.83 | 12298.0 |
| 2023-01-03 05:00:00 | SPY | ETF | 386.63 | 386.63 | 386.63 | 386.63 | 400.0 |
| 2023-01-03 05:05:00 | SPY | ETF | 386.64 | 386.64 | 386.45 | 386.45 | 4700.0 |
| 2023-01-03 05:10:00 | SPY | ETF | 386.46 | 386.48 | 386.14 | 386.14 | 4500.0 |
| 2023-01-03 05:15:00 | SPY | ETF | 386.2 | 386.25 | 386.0 | 386.0 | 10028.0 |
| 2023-01-03 05:20:00 | SPY | ETF | 385.96 | 385.96 | 385.75 | 385.79 | 25897.0 |
| 2023-01-03 05:25:00 | SPY | ETF | 385.78 | 385.86 | 385.73 | 385.82 | 3792.0 |
| 2023-01-03 05:30:00 | SPY | ETF | 385.77 | 385.91 | 385.71 | 385.91 | 1550.0 |
| 2023-01-03 05:35:00 | SPY | ETF | 385.81 | 385.87 | 385.62 | 385.85 | 7750.0 |
| 2023-01-03 05:40:00 | SPY | ETF | 385.85 | 386.05 | 385.83 | 386.04 | 48191.0 |
| 2023-01-03 05:45:00 | SPY | ETF | 386.03 | 386.16 | 386.03 | 386.07 | 2050.0 |
| 2023-01-03 05:50:00 | SPY | ETF | 386.06 | 386.13 | 386.06 | 386.13 | 2099.0 |
| 2023-01-03 05:55:00 | SPY | ETF | 386.21 | 386.21 | 386.06 | 386.06 | 300.0 |
| 2023-01-03 06:00:00 | SPY | ETF | 385.9 | 386.0 | 385.85 | 386.0 | 700.0 |
| 2023-01-03 06:05:00 | SPY | ETF | 386.0 | 386.0 | 385.74 | 385.74 | 2544.0 |
| 2023-01-03 06:10:00 | SPY | ETF | 385.77 | 385.77 | 385.39 | 385.42 | 4900.0 |
| 2023-01-03 06:15:00 | SPY | ETF | 385.4 | 385.58 | 385.38 | 385.4 | 3515.0 |
| 2023-01-03 06:20:00 | SPY | ETF | 385.4 | 385.57 | 385.4 | 385.49 | 3737.0 |
| 2023-01-03 06:25:00 | SPY | ETF | 385.5 | 385.61 | 385.49 | 385.53 | 1767.0 |
| 2023-01-03 06:30:00 | SPY | ETF | 385.57 | 385.67 | 385.53 | 385.58 | 8582.0 |
| 2023-01-03 06:35:00 | SPY | ETF | 385.61 | 385.61 | 385.46 | 385.53 | 2198.0 |
| 2023-01-03 06:40:00 | SPY | ETF | 385.46 | 385.46 | 383.93 | 384.02 | 25497.0 |
| 2023-01-03 06:45:00 | SPY | ETF | 384.01 | 384.2 | 383.52 | 383.95 | 32397.0 |
| 2023-01-03 06:50:00 | SPY | ETF | 383.98 | 384.12 | 383.75 | 383.96 | 11905.0 |
| 2023-01-03 06:55:00 | SPY | ETF | 384.0 | 384.19 | 383.92 | 383.96 | 15764.0 |
| 2023-01-03 07:00:00 | SPY | ETF | 383.95 | 384.01 | 383.39 | 383.61 | 40358.0 |
| 2023-01-03 07:05:00 | SPY | ETF | 383.55 | 383.79 | 383.51 | 383.51 | 33029.0 |
| 2023-01-03 07:10:00 | SPY | ETF | 383.5 | 383.72 | 383.34 | 383.7 | 27724.0 |
| 2023-01-03 07:15:00 | SPY | ETF | 383.65 | 383.92 | 383.55 | 383.92 | 28474.0 |
| 2023-01-03 07:20:00 | SPY | ETF | 383.88 | 384.16 | 383.84 | 384.04 | 24527.0 |
| 2023-01-03 07:25:00 | SPY | ETF | 384.09 | 384.1 | 383.82 | 383.82 | 16751.0 |
| 2023-01-03 07:30:00 | SPY | ETF | 383.82 | 384.28 | 383.82 | 384.27 | 10579.0 |
| 2023-01-03 07:35:00 | SPY | ETF | 384.25 | 384.27 | 384.08 | 384.27 | 9740.0 |
| 2023-01-03 07:40:00 | SPY | ETF | 384.32 | 384.44 | 384.28 | 384.33 | 4356.0 |
| 2023-01-03 07:45:00 | SPY | ETF | 384.35 | 384.35 | 383.95 | 384.28 | 5456.0 |
| 2023-01-03 07:50:00 | SPY | ETF | 384.24 | 384.25 | 384.0 | 384.0 | 44464.0 |
| 2023-01-03 07:55:00 | SPY | ETF | 383.9 | 384.31 | 383.87 | 384.31 | 123160.0 |
| 2023-01-03 08:00:00 | SPY | ETF | 383.53 | 386.7204 | 382.77 | 384.71 | 147612.0 |
| 2023-01-03 08:05:00 | SPY | ETF | 384.69 | 384.75 | 383.44 | 383.55 | 170378.0 |
> showing 50 of 101,928 rows — these rows as CSV