PREVIEW / etf_30min / 2024-05-16
file: by_date/etf_30min/2024/2024-05-16.parquet size: 792 KB rows: 31,273
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-05-16 04:00:00 | SPY | ETF | 530.8 | 530.8 | 530.18 | 530.18 | 11293.0 |
| 2024-05-16 04:30:00 | SPY | ETF | 530.24 | 530.41 | 530.21 | 530.35 | 4262.0 |
| 2024-05-16 05:00:00 | SPY | ETF | 530.31 | 530.46 | 530.28 | 530.36 | 2375.0 |
| 2024-05-16 05:30:00 | SPY | ETF | 530.33 | 530.4 | 530.23 | 530.23 | 4550.0 |
| 2024-05-16 06:00:00 | SPY | ETF | 530.33 | 530.33 | 530.12 | 530.13 | 5972.0 |
| 2024-05-16 06:30:00 | SPY | ETF | 530.13 | 530.32 | 530.09 | 530.2 | 10462.0 |
| 2024-05-16 07:00:00 | SPY | ETF | 530.25 | 530.61 | 530.25 | 530.61 | 25492.0 |
| 2024-05-16 07:30:00 | SPY | ETF | 530.62 | 530.62 | 530.32 | 530.36 | 21908.0 |
| 2024-05-16 08:00:00 | SPY | ETF | 530.33 | 530.89 | 530.0904 | 530.5 | 89879.0 |
| 2024-05-16 08:30:00 | SPY | ETF | 530.65 | 530.83 | 529.85 | 529.99 | 119582.0 |
| 2024-05-16 09:00:00 | SPY | ETF | 529.99 | 529.99 | 529.68 | 529.87 | 166724.0 |
| 2024-05-16 09:30:00 | SPY | ETF | 529.87 | 530.33 | 529.86 | 530.22 | 2960311.0 |
| 2024-05-16 10:00:00 | SPY | ETF | 530.21 | 530.78 | 529.55 | 530.63 | 2803340.0 |
| 2024-05-16 10:30:00 | SPY | ETF | 530.64 | 531.47 | 530.51 | 531.375 | 2138608.0 |
| 2024-05-16 11:00:00 | SPY | ETF | 531.38 | 531.5218 | 530.52 | 531.14 | 2552065.0 |
| 2024-05-16 11:30:00 | SPY | ETF | 531.1401 | 531.35 | 530.755 | 530.91 | 1483100.0 |
| 2024-05-16 12:00:00 | SPY | ETF | 530.92 | 530.92 | 530.28 | 530.51 | 1603915.0 |
| 2024-05-16 12:30:00 | SPY | ETF | 530.51 | 530.79 | 530.19 | 530.7191 | 1137721.0 |
| 2024-05-16 13:00:00 | SPY | ETF | 530.725 | 530.85 | 529.42 | 529.79 | 2344682.0 |
| 2024-05-16 13:30:00 | SPY | ETF | 529.77 | 530.13 | 529.3303 | 530.05 | 2019811.0 |
| 2024-05-16 14:00:00 | SPY | ETF | 530.055 | 530.06 | 529.0201 | 529.465 | 2272328.0 |
| 2024-05-16 14:30:00 | SPY | ETF | 529.46 | 530.13 | 529.46 | 530.09 | 1466221.0 |
| 2024-05-16 15:00:00 | SPY | ETF | 530.1 | 530.2 | 529.825 | 529.89 | 1976392.0 |
| 2024-05-16 15:30:00 | SPY | ETF | 529.89 | 529.98 | 528.54 | 528.66 | 9631833.0 |
| 2024-05-16 16:00:00 | SPY | ETF | 528.66 | 528.82 | 528.36 | 528.3908 | 2310681.0 |
| 2024-05-16 16:30:00 | SPY | ETF | 528.43 | 528.69 | 528.24 | 528.29 | 193613.0 |
| 2024-05-16 17:00:00 | SPY | ETF | 528.29 | 528.69 | 528.25 | 528.68 | 148061.0 |
| 2024-05-16 17:30:00 | SPY | ETF | 528.68 | 528.82 | 528.65 | 528.75 | 136310.0 |
| 2024-05-16 18:00:00 | SPY | ETF | 528.74 | 528.74 | 528.47 | 528.56 | 193685.0 |
| 2024-05-16 18:30:00 | SPY | ETF | 528.5091 | 528.69 | 528.37 | 528.61 | 13011.0 |
| 2024-05-16 19:00:00 | SPY | ETF | 528.61 | 528.68 | 528.57 | 528.68 | 7695.0 |
| 2024-05-16 19:30:00 | SPY | ETF | 528.69 | 528.8 | 528.62 | 528.71 | 12354.0 |
| 2024-05-16 04:00:00 | QQQ | ETF | 453.9 | 453.9 | 453.5 | 453.65 | 42545.0 |
| 2024-05-16 04:30:00 | QQQ | ETF | 453.65 | 453.86 | 453.6 | 453.74 | 19323.0 |
| 2024-05-16 05:00:00 | QQQ | ETF | 453.76 | 453.87 | 453.71 | 453.76 | 11529.0 |
| 2024-05-16 05:30:00 | QQQ | ETF | 453.7 | 453.9 | 453.66 | 453.75 | 6661.0 |
| 2024-05-16 06:00:00 | QQQ | ETF | 453.82 | 453.82 | 453.58 | 453.58 | 5443.0 |
| 2024-05-16 06:30:00 | QQQ | ETF | 453.68 | 453.84 | 453.58 | 453.75 | 33482.0 |
| 2024-05-16 07:00:00 | QQQ | ETF | 453.67 | 453.89 | 453.57 | 453.8 | 62747.0 |
| 2024-05-16 07:30:00 | QQQ | ETF | 453.82 | 453.82 | 453.53 | 453.64 | 23740.0 |
| 2024-05-16 08:00:00 | QQQ | ETF | 453.71 | 453.97 | 453.239 | 453.61 | 53463.0 |
| 2024-05-16 08:30:00 | QQQ | ETF | 453.46 | 454.0 | 452.91 | 453.08 | 123014.0 |
| 2024-05-16 09:00:00 | QQQ | ETF | 453.09 | 453.11 | 452.71 | 452.71 | 91686.0 |
| 2024-05-16 09:30:00 | QQQ | ETF | 452.71 | 453.619 | 452.53 | 453.44 | 3157389.0 |
| 2024-05-16 10:00:00 | QQQ | ETF | 453.44 | 453.76 | 452.58 | 453.6 | 2257653.0 |
| 2024-05-16 10:30:00 | QQQ | ETF | 453.615 | 454.43 | 453.46 | 454.39 | 1606700.0 |
| 2024-05-16 11:00:00 | QQQ | ETF | 454.4095 | 454.69 | 453.81 | 454.33 | 1365271.0 |
| 2024-05-16 11:30:00 | QQQ | ETF | 454.33 | 454.57 | 453.89 | 454.23 | 1289224.0 |
| 2024-05-16 12:00:00 | QQQ | ETF | 454.22 | 454.22 | 453.49 | 453.83 | 1228859.0 |
| 2024-05-16 12:30:00 | QQQ | ETF | 453.82 | 454.075 | 453.42 | 454.0401 | 849470.0 |
> showing 50 of 31,273 rows — these rows as CSV