PREVIEW / etf_30min / 2022-02-28
file: by_date/etf_30min/2022/2022-02-28.parquet size: 680 KB rows: 27,429
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-02-28 04:00:00 | SPY | ETF | 430.1 | 432.21 | 429.64 | 430.17 | 137680.0 |
| 2022-02-28 04:30:00 | SPY | ETF | 430.17 | 431.45 | 429.82 | 430.83 | 116418.0 |
| 2022-02-28 05:00:00 | SPY | ETF | 431.0 | 431.3 | 430.29 | 430.29 | 108380.0 |
| 2022-02-28 05:30:00 | SPY | ETF | 430.2 | 432.05 | 429.91 | 432.05 | 65068.0 |
| 2022-02-28 06:00:00 | SPY | ETF | 432.0 | 432.9 | 431.2 | 431.2 | 95660.0 |
| 2022-02-28 06:30:00 | SPY | ETF | 431.25 | 431.97 | 431.0 | 431.47 | 123022.0 |
| 2022-02-28 07:00:00 | SPY | ETF | 431.54 | 434.0 | 431.42 | 433.54 | 530847.0 |
| 2022-02-28 07:30:00 | SPY | ETF | 433.5 | 433.87 | 431.72 | 432.24 | 554314.0 |
| 2022-02-28 08:00:00 | SPY | ETF | 432.17 | 433.99 | 427.67 | 432.26 | 549561.0 |
| 2022-02-28 08:30:00 | SPY | ETF | 432.35 | 432.7 | 430.5 | 431.4 | 678377.0 |
| 2022-02-28 09:00:00 | SPY | ETF | 431.4199 | 432.82 | 431.05 | 432.08 | 760286.0 |
| 2022-02-28 09:30:00 | SPY | ETF | 432.02 | 434.49 | 431.87 | 434.27 | 12803953.0 |
| 2022-02-28 10:00:00 | SPY | ETF | 434.29 | 434.55 | 431.85 | 432.92 | 7990671.0 |
| 2022-02-28 10:30:00 | SPY | ETF | 432.93 | 436.26 | 432.84 | 435.95 | 8706535.0 |
| 2022-02-28 11:00:00 | SPY | ETF | 435.94 | 437.9 | 435.49 | 437.63 | 6601185.0 |
| 2022-02-28 11:30:00 | SPY | ETF | 437.66 | 438.2 | 436.17 | 437.3414 | 6489332.0 |
| 2022-02-28 12:00:00 | SPY | ETF | 437.34 | 437.675 | 434.205 | 434.69 | 5313321.0 |
| 2022-02-28 12:30:00 | SPY | ETF | 434.68 | 434.97 | 432.66 | 433.59 | 4785800.0 |
| 2022-02-28 13:00:00 | SPY | ETF | 433.6 | 435.46 | 432.87 | 433.8101 | 5254157.0 |
| 2022-02-28 13:30:00 | SPY | ETF | 433.82 | 435.1 | 433.15 | 434.58 | 4442583.0 |
| 2022-02-28 14:00:00 | SPY | ETF | 434.56 | 434.56 | 430.715 | 431.25 | 8595824.0 |
| 2022-02-28 14:30:00 | SPY | ETF | 431.24 | 433.38 | 430.7 | 432.92 | 5720618.0 |
| 2022-02-28 15:00:00 | SPY | ETF | 432.92 | 434.25 | 431.64 | 433.55 | 6062882.0 |
| 2022-02-28 15:30:00 | SPY | ETF | 433.53 | 436.94 | 431.61 | 436.67 | 19704716.0 |
| 2022-02-28 16:00:00 | SPY | ETF | 436.65 | 436.8 | 436.05 | 436.63 | 7016444.0 |
| 2022-02-28 16:30:00 | SPY | ETF | 436.63 | 436.81 | 436.58 | 436.75 | 142568.0 |
| 2022-02-28 17:00:00 | SPY | ETF | 436.75 | 436.75 | 436.5 | 436.55 | 62989.0 |
| 2022-02-28 17:30:00 | SPY | ETF | 436.55 | 436.55 | 436.31 | 436.42 | 38593.0 |
| 2022-02-28 18:00:00 | SPY | ETF | 436.42 | 437.1 | 436.42 | 436.78 | 76065.0 |
| 2022-02-28 18:30:00 | SPY | ETF | 436.87 | 437.82 | 436.87 | 437.45 | 85936.0 |
| 2022-02-28 19:00:00 | SPY | ETF | 437.63 | 437.63 | 436.91 | 437.32 | 36948.0 |
| 2022-02-28 19:30:00 | SPY | ETF | 437.25 | 437.25 | 435.99 | 436.59 | 93183.0 |
| 2022-02-28 04:00:00 | QQQ | ETF | 341.27 | 342.55 | 340.0 | 340.4 | 145784.0 |
| 2022-02-28 04:30:00 | QQQ | ETF | 340.35 | 341.84 | 340.18 | 341.0 | 144068.0 |
| 2022-02-28 05:00:00 | QQQ | ETF | 341.06 | 341.41 | 340.49 | 340.58 | 122200.0 |
| 2022-02-28 05:30:00 | QQQ | ETF | 340.58 | 341.68 | 340.2 | 341.45 | 70384.0 |
| 2022-02-28 06:00:00 | QQQ | ETF | 341.47 | 342.25 | 340.82 | 340.91 | 56028.0 |
| 2022-02-28 06:30:00 | QQQ | ETF | 340.85 | 341.5 | 340.59 | 341.14 | 82643.0 |
| 2022-02-28 07:00:00 | QQQ | ETF | 341.26 | 343.16 | 341.24 | 342.69 | 227377.0 |
| 2022-02-28 07:30:00 | QQQ | ETF | 342.64 | 342.98 | 341.35 | 341.9 | 286444.0 |
| 2022-02-28 08:00:00 | QQQ | ETF | 341.5399 | 346.029 | 337.21 | 341.88 | 381779.0 |
| 2022-02-28 08:30:00 | QQQ | ETF | 341.84 | 342.24 | 340.76 | 341.48 | 258916.0 |
| 2022-02-28 09:00:00 | QQQ | ETF | 341.44 | 342.67 | 341.25 | 342.49 | 278480.0 |
| 2022-02-28 09:30:00 | QQQ | ETF | 342.47 | 345.03 | 342.15 | 344.98 | 8527281.0 |
| 2022-02-28 10:00:00 | QQQ | ETF | 344.94 | 345.29 | 342.24 | 343.735 | 4391580.0 |
| 2022-02-28 10:30:00 | QQQ | ETF | 343.75 | 347.17 | 343.66 | 346.72 | 5006830.0 |
| 2022-02-28 11:00:00 | QQQ | ETF | 346.69 | 348.16 | 346.03 | 347.89 | 3536835.0 |
| 2022-02-28 11:30:00 | QQQ | ETF | 347.88 | 348.54 | 346.91 | 347.6851 | 3041955.0 |
| 2022-02-28 12:00:00 | QQQ | ETF | 347.67 | 348.05 | 344.55 | 345.06 | 3310348.0 |
| 2022-02-28 12:30:00 | QQQ | ETF | 345.06 | 345.35 | 343.07 | 344.09 | 3432540.0 |
> showing 50 of 27,429 rows — these rows as CSV