PREVIEW / etf_30min / 2024-03-19
file: by_date/etf_30min/2024/2024-03-19.parquet size: 792 KB rows: 31,600
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-03-19 04:00:00 | SPY | ETF | 512.45 | 512.57 | 512.11 | 512.5 | 9610.0 |
| 2024-03-19 04:30:00 | SPY | ETF | 512.57 | 513.45 | 512.46 | 512.85 | 13743.0 |
| 2024-03-19 05:00:00 | SPY | ETF | 512.95 | 513.06 | 512.4 | 512.47 | 9595.0 |
| 2024-03-19 05:30:00 | SPY | ETF | 512.49 | 512.49 | 511.88 | 511.88 | 9725.0 |
| 2024-03-19 06:00:00 | SPY | ETF | 512.09 | 512.28 | 512.06 | 512.16 | 12050.0 |
| 2024-03-19 06:30:00 | SPY | ETF | 512.2 | 512.33 | 511.71 | 511.95 | 139806.0 |
| 2024-03-19 07:00:00 | SPY | ETF | 511.86 | 511.86 | 510.93 | 511.05 | 91438.0 |
| 2024-03-19 07:30:00 | SPY | ETF | 511.03 | 511.03 | 510.56 | 510.96 | 54901.0 |
| 2024-03-19 08:00:00 | SPY | ETF | 510.96 | 513.4604 | 510.29 | 510.34 | 122046.0 |
| 2024-03-19 08:30:00 | SPY | ETF | 510.45 | 511.49 | 510.35 | 511.44 | 114998.0 |
| 2024-03-19 09:00:00 | SPY | ETF | 511.45 | 512.2 | 511.24 | 512.15 | 122837.0 |
| 2024-03-19 09:30:00 | SPY | ETF | 512.15 | 512.17 | 511.12 | 511.6899 | 4439044.0 |
| 2024-03-19 10:00:00 | SPY | ETF | 511.68 | 512.09 | 511.22 | 511.4591 | 2959250.0 |
| 2024-03-19 10:30:00 | SPY | ETF | 511.45 | 512.61 | 511.3479 | 512.23 | 3206934.0 |
| 2024-03-19 11:00:00 | SPY | ETF | 512.24 | 512.77 | 512.16 | 512.675 | 1695832.0 |
| 2024-03-19 11:30:00 | SPY | ETF | 512.68 | 513.43 | 512.68 | 513.1802 | 2301242.0 |
| 2024-03-19 12:00:00 | SPY | ETF | 513.18 | 514.115 | 513.005 | 513.9901 | 2208594.0 |
| 2024-03-19 12:30:00 | SPY | ETF | 514.0 | 515.135 | 514.0 | 514.6798 | 3514400.0 |
| 2024-03-19 13:00:00 | SPY | ETF | 514.68 | 515.45 | 514.36 | 514.85 | 2167985.0 |
| 2024-03-19 13:30:00 | SPY | ETF | 514.86 | 515.27 | 514.71 | 514.99 | 1936050.0 |
| 2024-03-19 14:00:00 | SPY | ETF | 514.99 | 515.2 | 514.5 | 515.0001 | 2542951.0 |
| 2024-03-19 14:30:00 | SPY | ETF | 515.01 | 515.3599 | 514.59 | 514.9 | 2195289.0 |
| 2024-03-19 15:00:00 | SPY | ETF | 514.885 | 515.07 | 514.23 | 514.53 | 3054576.0 |
| 2024-03-19 15:30:00 | SPY | ETF | 514.53 | 515.995 | 514.41 | 515.76 | 8849793.0 |
| 2024-03-19 16:00:00 | SPY | ETF | 515.76 | 515.94 | 515.43 | 515.59 | 3984166.0 |
| 2024-03-19 16:30:00 | SPY | ETF | 515.59 | 515.83 | 515.56 | 515.56 | 93345.0 |
| 2024-03-19 17:00:00 | SPY | ETF | 515.52 | 515.53 | 515.41 | 515.45 | 38980.0 |
| 2024-03-19 17:30:00 | SPY | ETF | 515.52 | 515.62 | 515.5126 | 515.53 | 23357.0 |
| 2024-03-19 18:00:00 | SPY | ETF | 515.53 | 515.6 | 515.42 | 515.59 | 28700.0 |
| 2024-03-19 18:30:00 | SPY | ETF | 515.46 | 515.6 | 515.4593 | 515.57 | 2591.0 |
| 2024-03-19 19:00:00 | SPY | ETF | 515.6 | 515.63 | 515.48 | 515.63 | 5286.0 |
| 2024-03-19 19:30:00 | SPY | ETF | 515.63 | 515.63 | 515.45 | 515.45 | 4834.0 |
| 2024-03-19 04:00:00 | QQQ | ETF | 436.4 | 436.68 | 435.9 | 436.64 | 61728.0 |
| 2024-03-19 04:30:00 | QQQ | ETF | 436.58 | 438.1 | 436.49 | 437.35 | 67306.0 |
| 2024-03-19 05:00:00 | QQQ | ETF | 437.49 | 437.57 | 436.8 | 437.08 | 10437.0 |
| 2024-03-19 05:30:00 | QQQ | ETF | 437.02 | 437.02 | 436.2 | 436.28 | 31346.0 |
| 2024-03-19 06:00:00 | QQQ | ETF | 436.25 | 436.65 | 436.21 | 436.53 | 19350.0 |
| 2024-03-19 06:30:00 | QQQ | ETF | 436.54 | 436.85 | 436.08 | 436.39 | 40666.0 |
| 2024-03-19 07:00:00 | QQQ | ETF | 436.339 | 436.339 | 435.04 | 435.22 | 92101.0 |
| 2024-03-19 07:30:00 | QQQ | ETF | 435.17 | 435.17 | 434.53 | 434.85 | 212008.0 |
| 2024-03-19 08:00:00 | QQQ | ETF | 434.92 | 437.9496 | 433.95 | 434.08 | 161798.0 |
| 2024-03-19 08:30:00 | QQQ | ETF | 434.09 | 435.22 | 433.95 | 435.16 | 193263.0 |
| 2024-03-19 09:00:00 | QQQ | ETF | 435.12 | 435.61 | 434.87 | 435.46 | 175733.0 |
| 2024-03-19 09:30:00 | QQQ | ETF | 435.45 | 435.69 | 433.33 | 434.24 | 4760241.0 |
| 2024-03-19 10:00:00 | QQQ | ETF | 434.22 | 435.12 | 433.71 | 433.88 | 2582158.0 |
| 2024-03-19 10:30:00 | QQQ | ETF | 433.87 | 435.57 | 433.68 | 434.85 | 2278489.0 |
| 2024-03-19 11:00:00 | QQQ | ETF | 434.87 | 435.46 | 434.57 | 435.1925 | 1506530.0 |
| 2024-03-19 11:30:00 | QQQ | ETF | 435.22 | 436.13 | 435.22 | 435.865 | 1747656.0 |
| 2024-03-19 12:00:00 | QQQ | ETF | 435.86 | 436.92 | 435.59 | 436.77 | 1700280.0 |
| 2024-03-19 12:30:00 | QQQ | ETF | 436.79 | 438.5 | 436.79 | 437.8993 | 2741434.0 |
> showing 50 of 31,600 rows — these rows as CSV