PREVIEW / etf_5min / 2024-08-09
file: by_date/etf_5min/2024/2024-08-09.parquet size: 2.2 MB rows: 108,760
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-08-09 04:00:00 | SPY | ETF | 531.69 | 531.96 | 531.55 | 531.75 | 8217.0 |
| 2024-08-09 04:05:00 | SPY | ETF | 531.81 | 531.81 | 531.62 | 531.62 | 581.0 |
| 2024-08-09 04:10:00 | SPY | ETF | 531.57 | 531.9 | 531.57 | 531.61 | 1080.0 |
| 2024-08-09 04:15:00 | SPY | ETF | 531.6 | 531.65 | 531.53 | 531.53 | 4744.0 |
| 2024-08-09 04:20:00 | SPY | ETF | 531.42 | 531.6 | 531.36 | 531.6 | 2070.0 |
| 2024-08-09 04:25:00 | SPY | ETF | 531.6 | 531.9 | 531.6 | 531.9 | 661.0 |
| 2024-08-09 04:30:00 | SPY | ETF | 531.79 | 532.72 | 531.79 | 532.72 | 23790.0 |
| 2024-08-09 04:35:00 | SPY | ETF | 532.82 | 533.02 | 532.66 | 533.02 | 4435.0 |
| 2024-08-09 04:40:00 | SPY | ETF | 532.99 | 533.02 | 532.97 | 533.02 | 914.0 |
| 2024-08-09 04:45:00 | SPY | ETF | 533.06 | 533.06 | 532.82 | 532.93 | 3904.0 |
| 2024-08-09 04:50:00 | SPY | ETF | 533.04 | 533.14 | 533.04 | 533.14 | 585.0 |
| 2024-08-09 04:55:00 | SPY | ETF | 533.1 | 533.1 | 532.94 | 532.94 | 200.0 |
| 2024-08-09 05:00:00 | SPY | ETF | 533.0 | 533.0 | 533.0 | 533.0 | 100.0 |
| 2024-08-09 05:05:00 | SPY | ETF | 532.94 | 532.95 | 532.87 | 532.87 | 815.0 |
| 2024-08-09 05:10:00 | SPY | ETF | 532.92 | 533.07 | 532.71 | 532.82 | 4006.0 |
| 2024-08-09 05:15:00 | SPY | ETF | 532.71 | 533.03 | 532.71 | 533.03 | 790.0 |
| 2024-08-09 05:20:00 | SPY | ETF | 533.02 | 533.02 | 532.89 | 532.89 | 209.0 |
| 2024-08-09 05:25:00 | SPY | ETF | 532.94 | 532.94 | 532.74 | 532.74 | 649.0 |
| 2024-08-09 05:30:00 | SPY | ETF | 532.81 | 532.81 | 532.72 | 532.72 | 600.0 |
| 2024-08-09 05:35:00 | SPY | ETF | 532.72 | 532.74 | 532.72 | 532.74 | 2749.0 |
| 2024-08-09 05:40:00 | SPY | ETF | 532.6 | 532.6 | 532.54 | 532.58 | 4946.0 |
| 2024-08-09 05:45:00 | SPY | ETF | 532.59 | 532.59 | 532.0 | 532.0 | 300.0 |
| 2024-08-09 05:55:00 | SPY | ETF | 532.75 | 532.75 | 532.54 | 532.54 | 794.0 |
| 2024-08-09 06:00:00 | SPY | ETF | 532.22 | 532.22 | 532.0 | 532.0 | 200.0 |
| 2024-08-09 06:05:00 | SPY | ETF | 532.08 | 532.08 | 531.48 | 531.62 | 1568.0 |
| 2024-08-09 06:10:00 | SPY | ETF | 531.57 | 531.82 | 531.51 | 531.82 | 976.0 |
| 2024-08-09 06:15:00 | SPY | ETF | 531.67 | 531.67 | 531.61 | 531.61 | 967.0 |
| 2024-08-09 06:20:00 | SPY | ETF | 531.39 | 531.76 | 531.37 | 531.76 | 3157.0 |
| 2024-08-09 06:25:00 | SPY | ETF | 531.73 | 531.98 | 531.67 | 531.98 | 1675.0 |
| 2024-08-09 06:30:00 | SPY | ETF | 531.85 | 532.0 | 531.83 | 531.85 | 1299.0 |
| 2024-08-09 06:35:00 | SPY | ETF | 531.75 | 531.75 | 531.68 | 531.75 | 373.0 |
| 2024-08-09 06:40:00 | SPY | ETF | 531.61 | 531.61 | 531.42 | 531.44 | 541.0 |
| 2024-08-09 06:45:00 | SPY | ETF | 531.5 | 531.5 | 531.36 | 531.4 | 985.0 |
| 2024-08-09 06:50:00 | SPY | ETF | 531.5 | 531.71 | 531.5 | 531.66 | 16911.0 |
| 2024-08-09 06:55:00 | SPY | ETF | 531.66 | 531.66 | 531.37 | 531.49 | 37185.0 |
| 2024-08-09 07:00:00 | SPY | ETF | 531.57 | 532.0 | 531.5 | 531.96 | 94669.0 |
| 2024-08-09 07:05:00 | SPY | ETF | 531.99 | 532.12 | 531.85 | 531.88 | 3747.0 |
| 2024-08-09 07:10:00 | SPY | ETF | 532.05 | 532.19 | 531.96 | 532.05 | 13318.0 |
| 2024-08-09 07:15:00 | SPY | ETF | 531.97 | 532.39 | 531.97 | 532.13 | 9121.0 |
| 2024-08-09 07:20:00 | SPY | ETF | 532.15 | 532.18 | 531.64 | 531.72 | 15797.0 |
| 2024-08-09 07:25:00 | SPY | ETF | 531.78 | 531.78 | 530.85 | 531.15 | 24286.0 |
| 2024-08-09 07:30:00 | SPY | ETF | 531.16 | 531.24 | 530.32 | 530.68 | 55192.0 |
| 2024-08-09 07:35:00 | SPY | ETF | 530.8 | 530.93 | 530.26 | 530.51 | 19804.0 |
| 2024-08-09 07:40:00 | SPY | ETF | 530.46 | 530.5 | 530.15 | 530.27 | 48269.0 |
| 2024-08-09 07:45:00 | SPY | ETF | 530.38 | 530.72 | 530.33 | 530.52 | 14090.0 |
| 2024-08-09 07:50:00 | SPY | ETF | 530.69 | 530.92 | 530.69 | 530.8 | 3418.0 |
| 2024-08-09 07:55:00 | SPY | ETF | 530.83 | 531.09 | 530.8 | 530.84 | 33620.0 |
| 2024-08-09 08:00:00 | SPY | ETF | 531.69 | 532.9396 | 529.05 | 530.15 | 61621.0 |
| 2024-08-09 08:05:00 | SPY | ETF | 530.15 | 530.15 | 529.57 | 529.76 | 153434.0 |
| 2024-08-09 08:10:00 | SPY | ETF | 529.75 | 529.9996 | 529.72 | 529.8396 | 25642.0 |
> showing 50 of 108,760 rows — these rows as CSV