PREVIEW / etf_5min / 2024-01-23
file: by_date/etf_5min/2024/2024-01-23.parquet size: 2.3 MB rows: 109,010
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-23 04:00:00 | SPY | ETF | 483.35 | 483.35 | 483.35 | 483.35 | 300.0 |
| 2024-01-23 04:05:00 | SPY | ETF | 483.35 | 483.35 | 483.35 | 483.35 | 3098.0 |
| 2024-01-23 04:20:00 | SPY | ETF | 483.62 | 483.62 | 483.62 | 483.62 | 400.0 |
| 2024-01-23 04:25:00 | SPY | ETF | 483.76 | 483.76 | 483.63 | 483.65 | 1500.0 |
| 2024-01-23 04:30:00 | SPY | ETF | 483.61 | 483.63 | 483.58 | 483.58 | 1300.0 |
| 2024-01-23 04:35:00 | SPY | ETF | 483.61 | 483.61 | 483.61 | 483.61 | 100.0 |
| 2024-01-23 04:45:00 | SPY | ETF | 483.66 | 483.66 | 483.66 | 483.66 | 118.0 |
| 2024-01-23 04:50:00 | SPY | ETF | 483.66 | 483.66 | 483.66 | 483.66 | 110.0 |
| 2024-01-23 04:55:00 | SPY | ETF | 483.67 | 483.67 | 483.67 | 483.67 | 200.0 |
| 2024-01-23 05:00:00 | SPY | ETF | 483.64 | 483.64 | 483.55 | 483.55 | 600.0 |
| 2024-01-23 05:05:00 | SPY | ETF | 483.33 | 483.33 | 483.33 | 483.33 | 200.0 |
| 2024-01-23 05:10:00 | SPY | ETF | 483.32 | 483.32 | 483.32 | 483.32 | 400.0 |
| 2024-01-23 05:15:00 | SPY | ETF | 483.39 | 483.5 | 483.38 | 483.49 | 899.0 |
| 2024-01-23 05:30:00 | SPY | ETF | 483.55 | 483.55 | 483.54 | 483.54 | 500.0 |
| 2024-01-23 05:35:00 | SPY | ETF | 483.46 | 483.46 | 483.45 | 483.45 | 200.0 |
| 2024-01-23 05:40:00 | SPY | ETF | 483.59 | 483.6 | 483.59 | 483.6 | 500.0 |
| 2024-01-23 05:50:00 | SPY | ETF | 483.46 | 483.46 | 483.46 | 483.46 | 2625.0 |
| 2024-01-23 05:55:00 | SPY | ETF | 483.53 | 483.53 | 483.53 | 483.53 | 200.0 |
| 2024-01-23 06:00:00 | SPY | ETF | 483.51 | 483.51 | 483.51 | 483.51 | 490.0 |
| 2024-01-23 06:05:00 | SPY | ETF | 483.64 | 483.64 | 483.64 | 483.64 | 200.0 |
| 2024-01-23 06:15:00 | SPY | ETF | 483.65 | 483.67 | 483.65 | 483.67 | 400.0 |
| 2024-01-23 06:20:00 | SPY | ETF | 483.53 | 483.53 | 483.46 | 483.46 | 455.0 |
| 2024-01-23 06:25:00 | SPY | ETF | 483.49 | 483.5 | 483.47 | 483.47 | 450.0 |
| 2024-01-23 06:30:00 | SPY | ETF | 483.43 | 483.43 | 483.43 | 483.43 | 100.0 |
| 2024-01-23 06:35:00 | SPY | ETF | 483.59 | 483.61 | 483.5 | 483.61 | 6800.0 |
| 2024-01-23 06:40:00 | SPY | ETF | 483.59 | 483.59 | 483.59 | 483.59 | 200.0 |
| 2024-01-23 06:45:00 | SPY | ETF | 483.63 | 483.63 | 483.6 | 483.61 | 2044.0 |
| 2024-01-23 06:50:00 | SPY | ETF | 483.6 | 483.6 | 483.58 | 483.59 | 500.0 |
| 2024-01-23 06:55:00 | SPY | ETF | 483.62 | 483.72 | 483.62 | 483.72 | 3768.0 |
| 2024-01-23 07:00:00 | SPY | ETF | 483.69 | 483.73 | 483.65 | 483.66 | 22055.0 |
| 2024-01-23 07:05:00 | SPY | ETF | 483.71 | 483.78 | 483.71 | 483.77 | 4299.0 |
| 2024-01-23 07:10:00 | SPY | ETF | 483.77 | 483.83 | 483.77 | 483.82 | 2600.0 |
| 2024-01-23 07:15:00 | SPY | ETF | 483.78 | 483.78 | 483.69 | 483.78 | 12981.0 |
| 2024-01-23 07:20:00 | SPY | ETF | 483.83 | 483.88 | 483.81 | 483.84 | 5576.0 |
| 2024-01-23 07:25:00 | SPY | ETF | 483.8 | 483.81 | 483.73 | 483.73 | 5355.0 |
| 2024-01-23 07:30:00 | SPY | ETF | 483.76 | 483.79 | 483.76 | 483.79 | 2779.0 |
| 2024-01-23 07:35:00 | SPY | ETF | 483.78 | 483.84 | 483.78 | 483.83 | 4748.0 |
| 2024-01-23 07:40:00 | SPY | ETF | 483.9 | 483.93 | 483.7 | 483.7 | 4478.0 |
| 2024-01-23 07:45:00 | SPY | ETF | 483.75 | 483.75 | 483.68 | 483.7 | 7871.0 |
| 2024-01-23 07:50:00 | SPY | ETF | 483.68 | 483.83 | 483.67 | 483.83 | 9950.0 |
| 2024-01-23 07:55:00 | SPY | ETF | 483.85 | 483.94 | 483.85 | 483.93 | 5575.0 |
| 2024-01-23 08:00:00 | SPY | ETF | 483.84 | 484.1 | 483.29 | 484.07 | 38301.0 |
| 2024-01-23 08:05:00 | SPY | ETF | 484.099 | 484.1 | 483.99 | 484.03 | 7921.0 |
| 2024-01-23 08:10:00 | SPY | ETF | 484.04 | 484.04 | 483.88 | 483.92 | 4105.0 |
| 2024-01-23 08:15:00 | SPY | ETF | 483.99 | 484.08 | 483.95 | 483.98 | 10680.0 |
| 2024-01-23 08:20:00 | SPY | ETF | 483.9896 | 484.2 | 483.9896 | 484.1899 | 18556.0 |
| 2024-01-23 08:25:00 | SPY | ETF | 484.14 | 484.32 | 484.14 | 484.32 | 8243.0 |
| 2024-01-23 08:30:00 | SPY | ETF | 484.32 | 484.34 | 484.14 | 484.2121 | 10167.0 |
| 2024-01-23 08:35:00 | SPY | ETF | 484.24 | 484.51 | 484.24 | 484.47 | 57532.0 |
| 2024-01-23 08:40:00 | SPY | ETF | 484.59 | 484.62 | 484.55 | 484.58 | 14260.0 |
> showing 50 of 109,010 rows — these rows as CSV