PREVIEW / etf_30min / 2024-04-15
file: by_date/etf_30min/2024/2024-04-15.parquet size: 839 KB rows: 34,076
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-04-15 04:00:00 | SPY | ETF | 513.63 | 513.71 | 512.61 | 513.28 | 23757.0 |
| 2024-04-15 04:30:00 | SPY | ETF | 513.39 | 513.68 | 513.33 | 513.38 | 11480.0 |
| 2024-04-15 05:00:00 | SPY | ETF | 513.32 | 513.8 | 512.85 | 512.87 | 14793.0 |
| 2024-04-15 05:30:00 | SPY | ETF | 512.91 | 513.3 | 512.8 | 513.05 | 56484.0 |
| 2024-04-15 06:00:00 | SPY | ETF | 513.15 | 513.44 | 512.89 | 512.89 | 28952.0 |
| 2024-04-15 06:30:00 | SPY | ETF | 512.86 | 513.25 | 512.86 | 513.0 | 40490.0 |
| 2024-04-15 07:00:00 | SPY | ETF | 512.94 | 513.78 | 512.38 | 513.62 | 242820.0 |
| 2024-04-15 07:30:00 | SPY | ETF | 513.59 | 513.85 | 513.27 | 513.6 | 205545.0 |
| 2024-04-15 08:00:00 | SPY | ETF | 513.61 | 513.98 | 512.15 | 513.797 | 206955.0 |
| 2024-04-15 08:30:00 | SPY | ETF | 513.51 | 515.19 | 513.0 | 514.73 | 677882.0 |
| 2024-04-15 09:00:00 | SPY | ETF | 514.74 | 515.33 | 514.74 | 515.1 | 333641.0 |
| 2024-04-15 09:30:00 | SPY | ETF | 515.13 | 515.3 | 514.19 | 514.89 | 7001650.0 |
| 2024-04-15 10:00:00 | SPY | ETF | 514.9 | 515.01 | 511.94 | 512.57 | 5514875.0 |
| 2024-04-15 10:30:00 | SPY | ETF | 512.58 | 513.01 | 511.07 | 511.1001 | 4446393.0 |
| 2024-04-15 11:00:00 | SPY | ETF | 511.11 | 511.63 | 510.81 | 511.5801 | 3645198.0 |
| 2024-04-15 11:30:00 | SPY | ETF | 511.6 | 512.6 | 511.54 | 512.315 | 2944725.0 |
| 2024-04-15 12:00:00 | SPY | ETF | 512.32 | 512.62 | 510.365 | 510.6 | 2358780.0 |
| 2024-04-15 12:30:00 | SPY | ETF | 510.61 | 510.62 | 509.51 | 510.075 | 3605024.0 |
| 2024-04-15 13:00:00 | SPY | ETF | 510.06 | 510.56 | 506.55 | 506.57 | 4690478.0 |
| 2024-04-15 13:30:00 | SPY | ETF | 506.58 | 506.85 | 505.01 | 506.365 | 7531941.0 |
| 2024-04-15 14:00:00 | SPY | ETF | 506.3706 | 506.44 | 504.73 | 505.11 | 5316163.0 |
| 2024-04-15 14:30:00 | SPY | ETF | 505.1 | 506.49 | 504.425 | 505.14 | 4506639.0 |
| 2024-04-15 15:00:00 | SPY | ETF | 505.11 | 505.27 | 503.58 | 504.2599 | 4857764.0 |
| 2024-04-15 15:30:00 | SPY | ETF | 504.26 | 505.2686 | 504.23 | 504.5 | 10624732.0 |
| 2024-04-15 16:00:00 | SPY | ETF | 504.5 | 504.5894 | 503.99 | 504.03 | 3327742.0 |
| 2024-04-15 16:30:00 | SPY | ETF | 504.03 | 504.46 | 503.65 | 504.23 | 439978.0 |
| 2024-04-15 17:00:00 | SPY | ETF | 504.3 | 504.3 | 504.0 | 504.02 | 73735.0 |
| 2024-04-15 17:30:00 | SPY | ETF | 504.1 | 504.1 | 503.9 | 504.1 | 44663.0 |
| 2024-04-15 18:00:00 | SPY | ETF | 504.1 | 504.74 | 504.1 | 504.59 | 130032.0 |
| 2024-04-15 18:30:00 | SPY | ETF | 504.53 | 504.7 | 504.5 | 504.68 | 11093.0 |
| 2024-04-15 19:00:00 | SPY | ETF | 504.46 | 504.48 | 503.69 | 504.25 | 16750.0 |
| 2024-04-15 19:30:00 | SPY | ETF | 504.23 | 504.79 | 504.23 | 504.49 | 82189.0 |
| 2024-04-15 04:00:00 | QQQ | ETF | 440.77 | 440.8 | 440.02 | 440.49 | 362565.0 |
| 2024-04-15 04:30:00 | QQQ | ETF | 440.54 | 440.85 | 440.44 | 440.63 | 123015.0 |
| 2024-04-15 05:00:00 | QQQ | ETF | 440.63 | 441.05 | 440.26 | 440.44 | 150520.0 |
| 2024-04-15 05:30:00 | QQQ | ETF | 440.41 | 440.72 | 440.24 | 440.42 | 19366.0 |
| 2024-04-15 06:00:00 | QQQ | ETF | 440.55 | 440.77 | 440.4 | 440.45 | 33774.0 |
| 2024-04-15 06:30:00 | QQQ | ETF | 440.39 | 440.91 | 440.39 | 440.61 | 123800.0 |
| 2024-04-15 07:00:00 | QQQ | ETF | 440.6 | 441.079 | 440.35 | 440.9 | 117306.0 |
| 2024-04-15 07:30:00 | QQQ | ETF | 440.97 | 441.1 | 440.64 | 440.949 | 55112.0 |
| 2024-04-15 08:00:00 | QQQ | ETF | 440.96 | 441.35 | 438.598 | 441.24 | 241226.0 |
| 2024-04-15 08:30:00 | QQQ | ETF | 441.13 | 442.29 | 440.48 | 441.96 | 565114.0 |
| 2024-04-15 09:00:00 | QQQ | ETF | 442.03 | 442.42 | 441.92 | 442.03 | 235903.0 |
| 2024-04-15 09:30:00 | QQQ | ETF | 442.06 | 442.15 | 440.27 | 441.34 | 4511833.0 |
| 2024-04-15 10:00:00 | QQQ | ETF | 441.34 | 441.84 | 438.59 | 439.51 | 3434367.0 |
| 2024-04-15 10:30:00 | QQQ | ETF | 439.51 | 440.0 | 438.12 | 438.14 | 2923272.0 |
| 2024-04-15 11:00:00 | QQQ | ETF | 438.13 | 438.75 | 437.82 | 438.71 | 2279380.0 |
| 2024-04-15 11:30:00 | QQQ | ETF | 438.71 | 439.39 | 438.37 | 439.09 | 1638963.0 |
| 2024-04-15 12:00:00 | QQQ | ETF | 439.08 | 439.48 | 437.05 | 437.29 | 1387717.0 |
| 2024-04-15 12:30:00 | QQQ | ETF | 437.3 | 437.3 | 436.05 | 436.67 | 1692224.0 |
> showing 50 of 34,076 rows — these rows as CSV