PREVIEW / etf_30min / 2022-04-22
file: by_date/etf_30min/2022/2022-04-22.parquet size: 688 KB rows: 27,262
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-22 04:00:00 | SPY | ETF | 438.01 | 438.33 | 437.68 | 438.02 | 46808.0 |
| 2022-04-22 04:30:00 | SPY | ETF | 438.0 | 438.08 | 437.3 | 437.41 | 10415.0 |
| 2022-04-22 05:00:00 | SPY | ETF | 437.28 | 437.77 | 437.21 | 437.5 | 5802.0 |
| 2022-04-22 05:30:00 | SPY | ETF | 437.5 | 437.5 | 436.31 | 436.65 | 13510.0 |
| 2022-04-22 06:00:00 | SPY | ETF | 436.5 | 436.9 | 436.3 | 436.3 | 47709.0 |
| 2022-04-22 06:30:00 | SPY | ETF | 436.38 | 437.02 | 436.15 | 436.73 | 49892.0 |
| 2022-04-22 07:00:00 | SPY | ETF | 436.8 | 437.72 | 436.8 | 437.64 | 189924.0 |
| 2022-04-22 07:30:00 | SPY | ETF | 437.66 | 437.88 | 437.22 | 437.73 | 189075.0 |
| 2022-04-22 08:00:00 | SPY | ETF | 437.75 | 438.3396 | 436.4596 | 438.17 | 330489.0 |
| 2022-04-22 08:30:00 | SPY | ETF | 438.2 | 438.27 | 436.85 | 437.12 | 247532.0 |
| 2022-04-22 09:00:00 | SPY | ETF | 437.09 | 437.31 | 436.4 | 436.9 | 343324.0 |
| 2022-04-22 09:30:00 | SPY | ETF | 436.9 | 437.23 | 433.84 | 434.31 | 7635799.0 |
| 2022-04-22 10:00:00 | SPY | ETF | 434.34 | 435.96 | 432.82 | 432.93 | 7059348.0 |
| 2022-04-22 10:30:00 | SPY | ETF | 432.93 | 434.1 | 432.16 | 432.3401 | 5121091.0 |
| 2022-04-22 11:00:00 | SPY | ETF | 432.32 | 433.5 | 431.93 | 432.7122 | 4024003.0 |
| 2022-04-22 11:30:00 | SPY | ETF | 432.7 | 432.99 | 430.35 | 430.38 | 4818767.0 |
| 2022-04-22 12:00:00 | SPY | ETF | 430.37 | 431.33 | 429.87 | 430.9016 | 4497346.0 |
| 2022-04-22 12:30:00 | SPY | ETF | 430.885 | 431.89 | 430.33 | 430.44 | 3109605.0 |
| 2022-04-22 13:00:00 | SPY | ETF | 430.42 | 430.72 | 429.5305 | 430.0721 | 2899963.0 |
| 2022-04-22 13:30:00 | SPY | ETF | 430.07 | 430.2 | 428.74 | 428.75 | 3784475.0 |
| 2022-04-22 14:00:00 | SPY | ETF | 428.74 | 430.0 | 428.32 | 428.905 | 5538679.0 |
| 2022-04-22 14:30:00 | SPY | ETF | 428.89 | 429.22 | 426.81 | 427.4524 | 5849273.0 |
| 2022-04-22 15:00:00 | SPY | ETF | 427.4578 | 429.41 | 426.711 | 428.56 | 7653328.0 |
| 2022-04-22 15:30:00 | SPY | ETF | 428.54 | 430.41 | 425.44 | 426.09 | 25711466.0 |
| 2022-04-22 16:00:00 | SPY | ETF | 426.08 | 426.25 | 424.25 | 424.25 | 8076723.0 |
| 2022-04-22 16:30:00 | SPY | ETF | 424.26 | 424.83 | 423.95 | 424.38 | 398787.0 |
| 2022-04-22 17:00:00 | SPY | ETF | 424.44 | 424.75 | 424.35 | 424.45 | 186876.0 |
| 2022-04-22 17:30:00 | SPY | ETF | 424.44 | 424.55 | 424.25 | 424.37 | 46721.0 |
| 2022-04-22 18:00:00 | SPY | ETF | 424.37 | 424.45 | 424.25 | 424.39 | 32080.0 |
| 2022-04-22 18:30:00 | SPY | ETF | 424.39 | 424.39 | 424.17 | 424.26 | 16089.0 |
| 2022-04-22 19:00:00 | SPY | ETF | 424.29 | 424.3 | 424.1 | 424.2 | 16973.0 |
| 2022-04-22 19:30:00 | SPY | ETF | 424.23 | 424.26 | 424.12 | 424.23 | 41504.0 |
| 2022-04-22 04:00:00 | QQQ | ETF | 333.36 | 334.81 | 333.36 | 334.36 | 63483.0 |
| 2022-04-22 04:30:00 | QQQ | ETF | 334.35 | 334.38 | 333.9 | 334.04 | 15069.0 |
| 2022-04-22 05:00:00 | QQQ | ETF | 333.99 | 334.34 | 333.73 | 333.9 | 39844.0 |
| 2022-04-22 05:30:00 | QQQ | ETF | 333.88 | 333.89 | 332.63 | 332.91 | 51373.0 |
| 2022-04-22 06:00:00 | QQQ | ETF | 332.84 | 333.4 | 332.8 | 332.86 | 53570.0 |
| 2022-04-22 06:30:00 | QQQ | ETF | 332.9 | 333.61 | 332.57 | 333.39 | 75941.0 |
| 2022-04-22 07:00:00 | QQQ | ETF | 333.38 | 334.5 | 333.27 | 334.39 | 219329.0 |
| 2022-04-22 07:30:00 | QQQ | ETF | 334.38 | 335.0 | 334.11 | 334.88 | 230928.0 |
| 2022-04-22 08:00:00 | QQQ | ETF | 333.5001 | 335.61 | 332.6196 | 335.53 | 321438.0 |
| 2022-04-22 08:30:00 | QQQ | ETF | 335.56 | 335.62 | 333.97 | 334.28 | 288527.0 |
| 2022-04-22 09:00:00 | QQQ | ETF | 334.24 | 334.4 | 333.35 | 334.3 | 362648.0 |
| 2022-04-22 09:30:00 | QQQ | ETF | 334.33 | 335.56 | 331.64 | 332.9072 | 9956867.0 |
| 2022-04-22 10:00:00 | QQQ | ETF | 332.91 | 335.04 | 330.83 | 331.01 | 6887092.0 |
| 2022-04-22 10:30:00 | QQQ | ETF | 331.01 | 332.89 | 330.91 | 331.525 | 4758497.0 |
| 2022-04-22 11:00:00 | QQQ | ETF | 331.52 | 333.01 | 330.87 | 331.655 | 4243506.0 |
| 2022-04-22 11:30:00 | QQQ | ETF | 331.67 | 332.02 | 329.13 | 329.15 | 3786636.0 |
| 2022-04-22 12:00:00 | QQQ | ETF | 329.14 | 329.77 | 328.4799 | 329.1899 | 3717017.0 |
| 2022-04-22 12:30:00 | QQQ | ETF | 329.17 | 330.13 | 328.51 | 328.62 | 2234257.0 |
> showing 50 of 27,262 rows — these rows as CSV