PREVIEW / etf_5min / 2024-01-29
file: by_date/etf_5min/2024/2024-01-29.parquet size: 2.2 MB rows: 109,049
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-29 04:00:00 | SPY | ETF | 487.7 | 487.86 | 487.5 | 487.81 | 6303.0 |
| 2024-01-29 04:05:00 | SPY | ETF | 487.8 | 487.94 | 487.79 | 487.94 | 440.0 |
| 2024-01-29 04:10:00 | SPY | ETF | 487.79 | 487.79 | 487.79 | 487.79 | 499.0 |
| 2024-01-29 04:15:00 | SPY | ETF | 487.63 | 487.7 | 487.63 | 487.65 | 351.0 |
| 2024-01-29 04:20:00 | SPY | ETF | 487.54 | 487.54 | 487.44 | 487.44 | 2120.0 |
| 2024-01-29 04:25:00 | SPY | ETF | 487.39 | 487.44 | 487.36 | 487.42 | 2935.0 |
| 2024-01-29 04:30:00 | SPY | ETF | 487.48 | 487.55 | 487.48 | 487.55 | 2214.0 |
| 2024-01-29 04:35:00 | SPY | ETF | 487.63 | 487.63 | 487.5 | 487.5 | 1018.0 |
| 2024-01-29 04:40:00 | SPY | ETF | 487.42 | 487.42 | 487.17 | 487.24 | 991.0 |
| 2024-01-29 04:45:00 | SPY | ETF | 487.27 | 487.37 | 487.27 | 487.37 | 1000.0 |
| 2024-01-29 04:50:00 | SPY | ETF | 487.34 | 487.34 | 487.23 | 487.23 | 1000.0 |
| 2024-01-29 04:55:00 | SPY | ETF | 487.23 | 487.24 | 487.23 | 487.24 | 499.0 |
| 2024-01-29 05:05:00 | SPY | ETF | 487.4 | 487.41 | 487.4 | 487.41 | 499.0 |
| 2024-01-29 05:10:00 | SPY | ETF | 487.45 | 487.45 | 487.37 | 487.37 | 496.0 |
| 2024-01-29 05:20:00 | SPY | ETF | 487.53 | 487.53 | 487.53 | 487.53 | 100.0 |
| 2024-01-29 05:25:00 | SPY | ETF | 487.55 | 487.58 | 487.55 | 487.58 | 795.0 |
| 2024-01-29 05:35:00 | SPY | ETF | 487.58 | 487.58 | 487.49 | 487.49 | 775.0 |
| 2024-01-29 05:40:00 | SPY | ETF | 487.58 | 487.58 | 487.58 | 487.58 | 100.0 |
| 2024-01-29 05:50:00 | SPY | ETF | 487.67 | 487.68 | 487.67 | 487.68 | 400.0 |
| 2024-01-29 05:55:00 | SPY | ETF | 487.56 | 487.56 | 487.56 | 487.56 | 200.0 |
| 2024-01-29 06:00:00 | SPY | ETF | 487.69 | 487.69 | 487.69 | 487.69 | 400.0 |
| 2024-01-29 06:05:00 | SPY | ETF | 487.61 | 487.61 | 487.61 | 487.61 | 176.0 |
| 2024-01-29 06:10:00 | SPY | ETF | 487.57 | 487.6 | 487.57 | 487.6 | 952.0 |
| 2024-01-29 06:15:00 | SPY | ETF | 487.59 | 487.66 | 487.59 | 487.66 | 1342.0 |
| 2024-01-29 06:20:00 | SPY | ETF | 487.66 | 487.75 | 487.66 | 487.75 | 1000.0 |
| 2024-01-29 06:25:00 | SPY | ETF | 487.8 | 487.81 | 487.71 | 487.73 | 1914.0 |
| 2024-01-29 06:30:00 | SPY | ETF | 487.78 | 487.78 | 487.75 | 487.77 | 402.0 |
| 2024-01-29 06:35:00 | SPY | ETF | 487.78 | 487.79 | 487.73 | 487.73 | 1686.0 |
| 2024-01-29 06:40:00 | SPY | ETF | 487.7 | 487.74 | 487.7 | 487.74 | 5118.0 |
| 2024-01-29 06:45:00 | SPY | ETF | 487.73 | 487.73 | 487.73 | 487.73 | 698.0 |
| 2024-01-29 06:50:00 | SPY | ETF | 487.81 | 487.81 | 487.74 | 487.74 | 805.0 |
| 2024-01-29 06:55:00 | SPY | ETF | 487.85 | 487.85 | 487.79 | 487.79 | 5681.0 |
| 2024-01-29 07:00:00 | SPY | ETF | 487.8 | 487.87 | 487.76 | 487.82 | 7783.0 |
| 2024-01-29 07:05:00 | SPY | ETF | 487.8 | 487.9 | 487.77 | 487.9 | 7924.0 |
| 2024-01-29 07:10:00 | SPY | ETF | 487.89 | 487.94 | 487.82 | 487.85 | 15797.0 |
| 2024-01-29 07:15:00 | SPY | ETF | 487.79 | 487.86 | 487.77 | 487.84 | 3022.0 |
| 2024-01-29 07:20:00 | SPY | ETF | 487.81 | 487.81 | 487.81 | 487.81 | 100.0 |
| 2024-01-29 07:25:00 | SPY | ETF | 487.88 | 488.0 | 487.88 | 488.0 | 24340.0 |
| 2024-01-29 07:30:00 | SPY | ETF | 487.92 | 487.99 | 487.83 | 487.92 | 8383.0 |
| 2024-01-29 07:35:00 | SPY | ETF | 487.91 | 487.91 | 487.72 | 487.82 | 4645.0 |
| 2024-01-29 07:40:00 | SPY | ETF | 487.82 | 487.85 | 487.7 | 487.78 | 4660.0 |
| 2024-01-29 07:50:00 | SPY | ETF | 487.59 | 487.59 | 487.5 | 487.52 | 2105.0 |
| 2024-01-29 07:55:00 | SPY | ETF | 487.68 | 487.74 | 487.54 | 487.54 | 70473.0 |
| 2024-01-29 08:00:00 | SPY | ETF | 487.54 | 488.0 | 486.94 | 487.6 | 48176.0 |
| 2024-01-29 08:05:00 | SPY | ETF | 487.6 | 487.79 | 487.56 | 487.67 | 8155.0 |
| 2024-01-29 08:10:00 | SPY | ETF | 487.74 | 487.8 | 487.65 | 487.65 | 73212.0 |
| 2024-01-29 08:15:00 | SPY | ETF | 487.67 | 487.68 | 487.48 | 487.48 | 13060.0 |
| 2024-01-29 08:20:00 | SPY | ETF | 487.45 | 487.48 | 487.36 | 487.41 | 9850.0 |
| 2024-01-29 08:25:00 | SPY | ETF | 487.44 | 487.4881 | 487.37 | 487.4881 | 4540.0 |
| 2024-01-29 08:30:00 | SPY | ETF | 487.46 | 487.51 | 487.38 | 487.39 | 9348.0 |
> showing 50 of 109,049 rows — these rows as CSV