PREVIEW / etf_30min / 2024-09-12
file: by_date/etf_30min/2024/2024-09-12.parquet size: 808 KB rows: 32,856
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-09-12 04:00:00 | SPY | ETF | 554.87 | 556.0 | 554.87 | 555.25 | 13083.0 |
| 2024-09-12 04:30:00 | SPY | ETF | 555.68 | 556.0 | 555.56 | 555.56 | 20080.0 |
| 2024-09-12 05:00:00 | SPY | ETF | 555.57 | 556.25 | 555.53 | 556.01 | 8455.0 |
| 2024-09-12 05:30:00 | SPY | ETF | 556.14 | 556.15 | 555.55 | 555.58 | 11689.0 |
| 2024-09-12 06:00:00 | SPY | ETF | 555.62 | 555.88 | 555.56 | 555.6 | 4284.0 |
| 2024-09-12 06:30:00 | SPY | ETF | 555.5 | 556.05 | 555.5 | 555.59 | 21028.0 |
| 2024-09-12 07:00:00 | SPY | ETF | 555.61 | 555.74 | 555.37 | 555.6 | 69708.0 |
| 2024-09-12 07:30:00 | SPY | ETF | 555.62 | 555.93 | 555.48 | 555.93 | 51357.0 |
| 2024-09-12 08:00:00 | SPY | ETF | 555.67 | 556.49 | 555.42 | 556.1237 | 96435.0 |
| 2024-09-12 08:30:00 | SPY | ETF | 556.15 | 556.85 | 554.99 | 555.16 | 333537.0 |
| 2024-09-12 09:00:00 | SPY | ETF | 555.23 | 555.75 | 554.81 | 555.01 | 207638.0 |
| 2024-09-12 09:30:00 | SPY | ETF | 555.01 | 555.37 | 552.74 | 553.77 | 3635182.0 |
| 2024-09-12 10:00:00 | SPY | ETF | 553.81 | 556.0 | 553.31 | 555.8 | 2491528.0 |
| 2024-09-12 10:30:00 | SPY | ETF | 555.82 | 556.28 | 554.32 | 554.45 | 2259506.0 |
| 2024-09-12 11:00:00 | SPY | ETF | 554.41 | 556.64 | 554.06 | 554.93 | 1964714.0 |
| 2024-09-12 11:30:00 | SPY | ETF | 554.96 | 555.5 | 554.2 | 554.5 | 1400332.0 |
| 2024-09-12 12:00:00 | SPY | ETF | 554.47 | 555.545 | 554.35 | 555.38 | 1426674.0 |
| 2024-09-12 12:30:00 | SPY | ETF | 555.4 | 557.24 | 555.0 | 557.12 | 1367123.0 |
| 2024-09-12 13:00:00 | SPY | ETF | 557.13 | 558.09 | 557.0 | 557.84 | 1777469.0 |
| 2024-09-12 13:30:00 | SPY | ETF | 557.86 | 559.37 | 557.68 | 559.14 | 2028926.0 |
| 2024-09-12 14:00:00 | SPY | ETF | 559.145 | 559.32 | 558.32 | 559.09 | 2148746.0 |
| 2024-09-12 14:30:00 | SPY | ETF | 559.0801 | 559.4 | 556.54 | 558.68 | 2475799.0 |
| 2024-09-12 15:00:00 | SPY | ETF | 558.66 | 558.94 | 558.195 | 558.76 | 1950104.0 |
| 2024-09-12 15:30:00 | SPY | ETF | 558.76 | 559.22 | 558.12 | 559.02 | 6696173.0 |
| 2024-09-12 16:00:00 | SPY | ETF | 559.02 | 559.09 | 558.0 | 558.68 | 2393357.0 |
| 2024-09-12 16:30:00 | SPY | ETF | 558.66 | 559.09 | 558.3 | 558.32 | 584022.0 |
| 2024-09-12 17:00:00 | SPY | ETF | 558.22 | 558.51 | 558.22 | 558.43 | 43427.0 |
| 2024-09-12 17:30:00 | SPY | ETF | 558.36 | 558.43 | 558.33 | 558.43 | 8567.0 |
| 2024-09-12 18:00:00 | SPY | ETF | 558.43 | 558.9 | 558.43 | 558.82 | 20946.0 |
| 2024-09-12 18:30:00 | SPY | ETF | 558.87 | 559.05 | 558.74 | 559.03 | 11695.0 |
| 2024-09-12 19:00:00 | SPY | ETF | 558.94 | 559.4 | 558.94 | 559.16 | 18271.0 |
| 2024-09-12 19:30:00 | SPY | ETF | 559.183 | 559.54 | 559.15 | 559.24 | 21756.0 |
| 2024-09-12 04:00:00 | QQQ | ETF | 469.13 | 469.43 | 468.68 | 469.2 | 32437.0 |
| 2024-09-12 04:30:00 | QQQ | ETF | 469.0 | 469.89 | 469.0 | 469.48 | 43496.0 |
| 2024-09-12 05:00:00 | QQQ | ETF | 469.57 | 470.34 | 469.57 | 470.15 | 93316.0 |
| 2024-09-12 05:30:00 | QQQ | ETF | 470.25 | 470.25 | 469.46 | 469.46 | 20990.0 |
| 2024-09-12 06:00:00 | QQQ | ETF | 469.51 | 469.62 | 469.24 | 469.27 | 16236.0 |
| 2024-09-12 06:30:00 | QQQ | ETF | 469.23 | 469.84 | 469.21 | 469.37 | 18867.0 |
| 2024-09-12 07:00:00 | QQQ | ETF | 469.3 | 469.46 | 468.99 | 469.15 | 114923.0 |
| 2024-09-12 07:30:00 | QQQ | ETF | 469.22 | 469.67 | 468.98 | 469.55 | 50568.0 |
| 2024-09-12 08:00:00 | QQQ | ETF | 469.23 | 470.59 | 468.971 | 469.8 | 180109.0 |
| 2024-09-12 08:30:00 | QQQ | ETF | 469.6 | 470.25 | 468.4 | 468.63 | 440648.0 |
| 2024-09-12 09:00:00 | QQQ | ETF | 468.61 | 469.26 | 468.38 | 468.69 | 196367.0 |
| 2024-09-12 09:30:00 | QQQ | ETF | 468.64 | 469.33 | 466.8491 | 468.6 | 3487500.0 |
| 2024-09-12 10:00:00 | QQQ | ETF | 468.6 | 470.84 | 467.75 | 470.5299 | 2411803.0 |
| 2024-09-12 10:30:00 | QQQ | ETF | 470.54 | 471.22 | 468.65 | 469.14 | 2212445.0 |
| 2024-09-12 11:00:00 | QQQ | ETF | 469.12 | 471.79 | 468.56 | 469.34 | 1889424.0 |
| 2024-09-12 11:30:00 | QQQ | ETF | 469.39 | 469.78 | 468.3498 | 468.765 | 1185709.0 |
| 2024-09-12 12:00:00 | QQQ | ETF | 468.76 | 470.17 | 468.64 | 470.05 | 963908.0 |
| 2024-09-12 12:30:00 | QQQ | ETF | 470.1 | 471.663 | 469.21 | 471.6 | 1004965.0 |
> showing 50 of 32,856 rows — these rows as CSV