PREVIEW / etf_5min / 2023-12-11
file: by_date/etf_5min/2023/2023-12-11.parquet size: 2.2 MB rows: 105,178
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-12-11 04:00:00 | SPY | ETF | 459.82 | 459.88 | 459.69 | 459.88 | 4435.0 |
| 2023-12-11 04:05:00 | SPY | ETF | 459.92 | 460.15 | 459.92 | 460.11 | 1720.0 |
| 2023-12-11 04:10:00 | SPY | ETF | 460.12 | 460.12 | 460.08 | 460.12 | 1872.0 |
| 2023-12-11 04:15:00 | SPY | ETF | 460.18 | 460.18 | 460.18 | 460.18 | 1000.0 |
| 2023-12-11 04:25:00 | SPY | ETF | 460.4 | 460.4 | 460.35 | 460.35 | 450.0 |
| 2023-12-11 04:30:00 | SPY | ETF | 460.38 | 460.38 | 460.38 | 460.38 | 800.0 |
| 2023-12-11 04:35:00 | SPY | ETF | 460.3 | 460.35 | 460.22 | 460.22 | 1496.0 |
| 2023-12-11 04:40:00 | SPY | ETF | 460.32 | 460.32 | 460.3 | 460.3 | 469.0 |
| 2023-12-11 04:50:00 | SPY | ETF | 460.35 | 460.35 | 460.2 | 460.2 | 996.0 |
| 2023-12-11 04:55:00 | SPY | ETF | 460.15 | 460.15 | 459.96 | 459.96 | 4825.0 |
| 2023-12-11 05:00:00 | SPY | ETF | 459.9 | 460.1 | 459.9 | 460.1 | 200.0 |
| 2023-12-11 05:05:00 | SPY | ETF | 459.99 | 460.0 | 459.99 | 460.0 | 274.0 |
| 2023-12-11 05:15:00 | SPY | ETF | 460.13 | 460.13 | 460.13 | 460.13 | 3200.0 |
| 2023-12-11 05:20:00 | SPY | ETF | 460.03 | 460.03 | 460.03 | 460.03 | 295.0 |
| 2023-12-11 05:25:00 | SPY | ETF | 459.87 | 459.87 | 459.87 | 459.87 | 184.0 |
| 2023-12-11 05:30:00 | SPY | ETF | 459.81 | 459.85 | 459.81 | 459.85 | 1244.0 |
| 2023-12-11 05:35:00 | SPY | ETF | 459.96 | 459.96 | 459.93 | 459.93 | 2094.0 |
| 2023-12-11 05:40:00 | SPY | ETF | 459.85 | 459.9 | 459.85 | 459.9 | 1708.0 |
| 2023-12-11 05:45:00 | SPY | ETF | 459.99 | 460.06 | 459.97 | 459.97 | 1005.0 |
| 2023-12-11 05:50:00 | SPY | ETF | 459.8 | 459.8 | 459.8 | 459.8 | 888.0 |
| 2023-12-11 05:55:00 | SPY | ETF | 459.72 | 459.72 | 459.69 | 459.69 | 1026.0 |
| 2023-12-11 06:00:00 | SPY | ETF | 459.68 | 459.7 | 459.68 | 459.69 | 300.0 |
| 2023-12-11 06:05:00 | SPY | ETF | 459.76 | 459.88 | 459.76 | 459.88 | 1952.0 |
| 2023-12-11 06:10:00 | SPY | ETF | 459.74 | 459.74 | 459.64 | 459.64 | 719.0 |
| 2023-12-11 06:15:00 | SPY | ETF | 459.64 | 459.66 | 459.55 | 459.57 | 4204.0 |
| 2023-12-11 06:20:00 | SPY | ETF | 459.6 | 459.6 | 459.45 | 459.45 | 5268.0 |
| 2023-12-11 06:25:00 | SPY | ETF | 459.41 | 459.6 | 459.41 | 459.6 | 1008.0 |
| 2023-12-11 06:30:00 | SPY | ETF | 459.63 | 459.75 | 459.63 | 459.71 | 1297.0 |
| 2023-12-11 06:35:00 | SPY | ETF | 459.77 | 459.81 | 459.72 | 459.77 | 3978.0 |
| 2023-12-11 06:40:00 | SPY | ETF | 459.78 | 459.78 | 459.76 | 459.77 | 4117.0 |
| 2023-12-11 06:45:00 | SPY | ETF | 459.7 | 459.7 | 459.67 | 459.69 | 1692.0 |
| 2023-12-11 06:50:00 | SPY | ETF | 459.63 | 459.87 | 459.63 | 459.85 | 5957.0 |
| 2023-12-11 06:55:00 | SPY | ETF | 459.9 | 459.98 | 459.9 | 459.98 | 933.0 |
| 2023-12-11 07:00:00 | SPY | ETF | 459.95 | 460.02 | 459.95 | 459.97 | 7933.0 |
| 2023-12-11 07:05:00 | SPY | ETF | 459.98 | 460.01 | 459.85 | 460.01 | 1050.0 |
| 2023-12-11 07:10:00 | SPY | ETF | 460.05 | 460.06 | 460.05 | 460.06 | 315.0 |
| 2023-12-11 07:15:00 | SPY | ETF | 460.05 | 460.11 | 460.0 | 460.1 | 5046.0 |
| 2023-12-11 07:20:00 | SPY | ETF | 460.11 | 460.11 | 460.04 | 460.07 | 3229.0 |
| 2023-12-11 07:25:00 | SPY | ETF | 459.97 | 460.04 | 459.96 | 459.96 | 4693.0 |
| 2023-12-11 07:30:00 | SPY | ETF | 460.01 | 460.01 | 459.96 | 460.0 | 1924.0 |
| 2023-12-11 07:35:00 | SPY | ETF | 460.0 | 460.0 | 459.901 | 459.94 | 1692.0 |
| 2023-12-11 07:40:00 | SPY | ETF | 459.87 | 459.89 | 459.8 | 459.81 | 8443.0 |
| 2023-12-11 07:45:00 | SPY | ETF | 459.88 | 459.93 | 459.86 | 459.93 | 15869.0 |
| 2023-12-11 07:50:00 | SPY | ETF | 459.999 | 459.999 | 459.85 | 459.9 | 1650.0 |
| 2023-12-11 07:55:00 | SPY | ETF | 460.0 | 460.05 | 459.94 | 460.05 | 6103.0 |
| 2023-12-11 08:00:00 | SPY | ETF | 460.05 | 460.2796 | 459.41 | 459.74 | 32269.0 |
| 2023-12-11 08:05:00 | SPY | ETF | 459.73 | 459.82 | 459.71 | 459.82 | 2693.0 |
| 2023-12-11 08:10:00 | SPY | ETF | 459.72 | 459.79 | 459.7 | 459.79 | 2350.0 |
| 2023-12-11 08:15:00 | SPY | ETF | 459.81 | 460.15 | 459.8 | 460.15 | 6200.0 |
| 2023-12-11 08:20:00 | SPY | ETF | 460.18 | 460.25 | 460.08 | 460.2 | 8427.0 |
> showing 50 of 105,178 rows — these rows as CSV