PREVIEW / etf_30min / 2022-03-03
file: by_date/etf_30min/2022/2022-03-03.parquet size: 667 KB rows: 26,583
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-03-03 04:00:00 | SPY | ETF | 437.89 | 438.02 | 436.98 | 437.31 | 48575.0 |
| 2022-03-03 04:30:00 | SPY | ETF | 437.08 | 437.9 | 436.99 | 437.35 | 36619.0 |
| 2022-03-03 05:00:00 | SPY | ETF | 437.39 | 437.56 | 436.64 | 436.8 | 41999.0 |
| 2022-03-03 05:30:00 | SPY | ETF | 436.85 | 437.35 | 436.7 | 437.01 | 15652.0 |
| 2022-03-03 06:00:00 | SPY | ETF | 436.9 | 437.69 | 436.8 | 437.69 | 14449.0 |
| 2022-03-03 06:30:00 | SPY | ETF | 437.76 | 437.87 | 436.52 | 436.9 | 51038.0 |
| 2022-03-03 07:00:00 | SPY | ETF | 436.9 | 438.04 | 436.85 | 437.76 | 122632.0 |
| 2022-03-03 07:30:00 | SPY | ETF | 437.88 | 438.0 | 437.38 | 437.55 | 92299.0 |
| 2022-03-03 08:00:00 | SPY | ETF | 437.57 | 439.28 | 436.5496 | 438.85 | 474225.0 |
| 2022-03-03 08:30:00 | SPY | ETF | 438.81 | 440.59 | 438.71 | 440.55 | 498714.0 |
| 2022-03-03 09:00:00 | SPY | ETF | 440.54 | 441.54 | 440.38 | 440.4 | 1326927.0 |
| 2022-03-03 09:30:00 | SPY | ETF | 440.47 | 441.11 | 438.95 | 439.7 | 8281417.0 |
| 2022-03-03 10:00:00 | SPY | ETF | 439.69 | 440.31 | 437.11 | 437.72 | 6608033.0 |
| 2022-03-03 10:30:00 | SPY | ETF | 437.74 | 438.13 | 434.85 | 434.91 | 6530287.0 |
| 2022-03-03 11:00:00 | SPY | ETF | 434.9 | 436.13 | 433.84 | 435.82 | 6535877.0 |
| 2022-03-03 11:30:00 | SPY | ETF | 435.81 | 436.86 | 435.08 | 436.3 | 5649942.0 |
| 2022-03-03 12:00:00 | SPY | ETF | 436.3 | 437.37 | 435.39 | 435.5971 | 4053569.0 |
| 2022-03-03 12:30:00 | SPY | ETF | 435.59 | 439.25 | 435.43 | 437.83 | 8030616.0 |
| 2022-03-03 13:00:00 | SPY | ETF | 437.79 | 439.01 | 437.43 | 438.88 | 3543310.0 |
| 2022-03-03 13:30:00 | SPY | ETF | 438.86 | 438.88 | 437.34 | 438.0201 | 2764914.0 |
| 2022-03-03 14:00:00 | SPY | ETF | 437.98 | 439.27 | 437.54 | 438.7 | 3321584.0 |
| 2022-03-03 14:30:00 | SPY | ETF | 438.69 | 438.71 | 435.87 | 436.2701 | 4022798.0 |
| 2022-03-03 15:00:00 | SPY | ETF | 436.26 | 436.5 | 434.76 | 436.445 | 5706679.0 |
| 2022-03-03 15:30:00 | SPY | ETF | 436.425 | 436.425 | 433.8 | 435.72 | 13197270.0 |
| 2022-03-03 16:00:00 | SPY | ETF | 435.73 | 436.29 | 435.32 | 436.08 | 3750959.0 |
| 2022-03-03 16:30:00 | SPY | ETF | 436.1 | 436.28 | 435.71 | 436.25 | 174062.0 |
| 2022-03-03 17:00:00 | SPY | ETF | 436.25 | 436.42 | 435.71 | 436.42 | 47087.0 |
| 2022-03-03 17:30:00 | SPY | ETF | 436.44 | 436.44 | 436.33 | 436.44 | 26502.0 |
| 2022-03-03 18:00:00 | SPY | ETF | 436.41 | 436.57 | 436.08 | 436.35 | 59592.0 |
| 2022-03-03 18:30:00 | SPY | ETF | 436.51 | 437.01 | 436.51 | 436.9 | 76058.0 |
| 2022-03-03 19:00:00 | SPY | ETF | 436.93 | 437.1 | 432.74 | 433.0 | 370720.0 |
| 2022-03-03 19:30:00 | SPY | ETF | 433.0 | 433.13 | 428.1 | 429.21 | 863168.0 |
| 2022-03-03 04:00:00 | QQQ | ETF | 346.53 | 346.71 | 345.38 | 346.01 | 40982.0 |
| 2022-03-03 04:30:00 | QQQ | ETF | 346.09 | 346.56 | 345.9 | 346.34 | 11295.0 |
| 2022-03-03 05:00:00 | QQQ | ETF | 346.35 | 346.39 | 345.65 | 345.95 | 24420.0 |
| 2022-03-03 05:30:00 | QQQ | ETF | 345.71 | 346.2 | 345.71 | 346.02 | 19681.0 |
| 2022-03-03 06:00:00 | QQQ | ETF | 345.8 | 346.76 | 345.8 | 346.75 | 23299.0 |
| 2022-03-03 06:30:00 | QQQ | ETF | 346.76 | 346.82 | 345.65 | 345.96 | 60948.0 |
| 2022-03-03 07:00:00 | QQQ | ETF | 345.95 | 346.94 | 345.92 | 346.67 | 90689.0 |
| 2022-03-03 07:30:00 | QQQ | ETF | 346.74 | 346.81 | 346.22 | 346.4 | 113970.0 |
| 2022-03-03 08:00:00 | QQQ | ETF | 346.39 | 347.85 | 345.75 | 347.45 | 306193.0 |
| 2022-03-03 08:30:00 | QQQ | ETF | 347.43 | 349.65 | 347.33 | 349.46 | 411982.0 |
| 2022-03-03 09:00:00 | QQQ | ETF | 349.47 | 350.93 | 349.44 | 349.89 | 1062052.0 |
| 2022-03-03 09:30:00 | QQQ | ETF | 349.94 | 350.04 | 347.14 | 347.8372 | 6159392.0 |
| 2022-03-03 10:00:00 | QQQ | ETF | 347.83 | 348.4401 | 344.53 | 345.0 | 5151909.0 |
| 2022-03-03 10:30:00 | QQQ | ETF | 345.01 | 345.459 | 342.66 | 342.7 | 4335843.0 |
| 2022-03-03 11:00:00 | QQQ | ETF | 342.7 | 344.31 | 342.2 | 343.92 | 3952079.0 |
| 2022-03-03 11:30:00 | QQQ | ETF | 343.92 | 344.76 | 343.0654 | 344.2304 | 3608996.0 |
| 2022-03-03 12:00:00 | QQQ | ETF | 344.26 | 344.93 | 342.63 | 342.79 | 2800465.0 |
| 2022-03-03 12:30:00 | QQQ | ETF | 342.81 | 346.65 | 342.58 | 344.92 | 5847871.0 |
> showing 50 of 26,583 rows — these rows as CSV