PREVIEW / etf_5min / 2024-01-30
file: by_date/etf_5min/2024/2024-01-30.parquet size: 2.2 MB rows: 109,794
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-30 04:00:00 | SPY | ETF | 491.15 | 491.23 | 491.06 | 491.14 | 9193.0 |
| 2024-01-30 04:05:00 | SPY | ETF | 491.15 | 491.26 | 491.15 | 491.26 | 1950.0 |
| 2024-01-30 04:10:00 | SPY | ETF | 491.28 | 491.29 | 491.1 | 491.1 | 1831.0 |
| 2024-01-30 04:15:00 | SPY | ETF | 491.0 | 491.0 | 490.9 | 490.9 | 2912.0 |
| 2024-01-30 04:20:00 | SPY | ETF | 490.9 | 490.99 | 490.9 | 490.97 | 603.0 |
| 2024-01-30 04:25:00 | SPY | ETF | 490.82 | 490.82 | 490.8 | 490.81 | 726.0 |
| 2024-01-30 04:30:00 | SPY | ETF | 490.78 | 490.78 | 490.78 | 490.78 | 1300.0 |
| 2024-01-30 04:35:00 | SPY | ETF | 490.89 | 490.89 | 490.75 | 490.75 | 5512.0 |
| 2024-01-30 04:40:00 | SPY | ETF | 490.78 | 490.81 | 490.71 | 490.79 | 5837.0 |
| 2024-01-30 04:45:00 | SPY | ETF | 490.91 | 490.91 | 490.87 | 490.87 | 2675.0 |
| 2024-01-30 04:50:00 | SPY | ETF | 490.92 | 490.93 | 490.79 | 490.79 | 1761.0 |
| 2024-01-30 04:55:00 | SPY | ETF | 490.82 | 490.88 | 490.82 | 490.88 | 857.0 |
| 2024-01-30 05:00:00 | SPY | ETF | 490.87 | 490.93 | 490.87 | 490.93 | 800.0 |
| 2024-01-30 05:05:00 | SPY | ETF | 490.84 | 490.84 | 490.84 | 490.84 | 125.0 |
| 2024-01-30 05:10:00 | SPY | ETF | 490.86 | 491.03 | 490.86 | 491.03 | 6830.0 |
| 2024-01-30 05:15:00 | SPY | ETF | 491.1 | 491.1 | 491.1 | 491.1 | 116.0 |
| 2024-01-30 05:20:00 | SPY | ETF | 491.03 | 491.03 | 491.0 | 491.0 | 600.0 |
| 2024-01-30 05:25:00 | SPY | ETF | 491.08 | 491.12 | 491.08 | 491.12 | 1798.0 |
| 2024-01-30 05:30:00 | SPY | ETF | 491.04 | 491.13 | 491.04 | 491.13 | 916.0 |
| 2024-01-30 05:35:00 | SPY | ETF | 491.15 | 491.16 | 491.15 | 491.16 | 482.0 |
| 2024-01-30 05:40:00 | SPY | ETF | 491.04 | 491.04 | 491.04 | 491.04 | 499.0 |
| 2024-01-30 05:45:00 | SPY | ETF | 490.96 | 490.99 | 490.96 | 490.99 | 650.0 |
| 2024-01-30 05:50:00 | SPY | ETF | 491.06 | 491.06 | 491.06 | 491.06 | 200.0 |
| 2024-01-30 05:55:00 | SPY | ETF | 490.93 | 490.93 | 490.93 | 490.93 | 211.0 |
| 2024-01-30 06:00:00 | SPY | ETF | 490.9 | 490.9 | 490.85 | 490.85 | 622.0 |
| 2024-01-30 06:05:00 | SPY | ETF | 490.84 | 490.84 | 490.67 | 490.68 | 1172.0 |
| 2024-01-30 06:10:00 | SPY | ETF | 490.75 | 490.76 | 490.7 | 490.76 | 4448.0 |
| 2024-01-30 06:15:00 | SPY | ETF | 490.77 | 490.77 | 490.61 | 490.64 | 501.0 |
| 2024-01-30 06:20:00 | SPY | ETF | 490.61 | 490.61 | 490.6 | 490.61 | 1472.0 |
| 2024-01-30 06:25:00 | SPY | ETF | 490.66 | 490.76 | 490.65 | 490.75 | 3229.0 |
| 2024-01-30 06:30:00 | SPY | ETF | 490.84 | 490.84 | 490.7 | 490.74 | 998.0 |
| 2024-01-30 06:35:00 | SPY | ETF | 490.75 | 490.79 | 490.75 | 490.79 | 1930.0 |
| 2024-01-30 06:40:00 | SPY | ETF | 490.76 | 490.76 | 490.76 | 490.76 | 449.0 |
| 2024-01-30 06:50:00 | SPY | ETF | 490.85 | 490.85 | 490.79 | 490.83 | 1000.0 |
| 2024-01-30 06:55:00 | SPY | ETF | 490.84 | 490.84 | 490.83 | 490.83 | 588.0 |
| 2024-01-30 07:00:00 | SPY | ETF | 490.86 | 490.88 | 490.83 | 490.83 | 6609.0 |
| 2024-01-30 07:05:00 | SPY | ETF | 490.81 | 490.83 | 490.8 | 490.8 | 3033.0 |
| 2024-01-30 07:10:00 | SPY | ETF | 490.81 | 490.81 | 490.75 | 490.79 | 2070.0 |
| 2024-01-30 07:15:00 | SPY | ETF | 490.82 | 490.85 | 490.76 | 490.85 | 5238.0 |
| 2024-01-30 07:20:00 | SPY | ETF | 490.88 | 490.95 | 490.86 | 490.86 | 3770.0 |
| 2024-01-30 07:25:00 | SPY | ETF | 490.87 | 490.92 | 490.81 | 490.92 | 4153.0 |
| 2024-01-30 07:30:00 | SPY | ETF | 490.831 | 490.85 | 490.761 | 490.78 | 2999.0 |
| 2024-01-30 07:35:00 | SPY | ETF | 490.8 | 490.8 | 490.58 | 490.59 | 5958.0 |
| 2024-01-30 07:40:00 | SPY | ETF | 490.57 | 490.57 | 490.48 | 490.51 | 7681.0 |
| 2024-01-30 07:45:00 | SPY | ETF | 490.5 | 490.67 | 490.47 | 490.66 | 25925.0 |
| 2024-01-30 07:50:00 | SPY | ETF | 490.62 | 490.64 | 490.6 | 490.61 | 2822.0 |
| 2024-01-30 07:55:00 | SPY | ETF | 490.63 | 490.66 | 490.6 | 490.6 | 7575.0 |
| 2024-01-30 08:00:00 | SPY | ETF | 490.8896 | 491.34 | 490.385 | 490.4 | 94385.0 |
| 2024-01-30 08:05:00 | SPY | ETF | 490.39 | 490.46 | 490.3 | 490.38 | 25914.0 |
| 2024-01-30 08:10:00 | SPY | ETF | 490.39 | 490.39 | 490.23 | 490.27 | 18542.0 |
> showing 50 of 109,794 rows — these rows as CSV