PREVIEW / etf_30min / 2022-02-14
file: by_date/etf_30min/2022/2022-02-14.parquet size: 666 KB rows: 26,654
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-14 04:00:00 | SPY | ETF | 440.36 | 440.36 | 435.78 | 437.15 | 77660.0 |
| 2022-02-14 04:30:00 | SPY | ETF | 437.1 | 437.38 | 436.06 | 436.16 | 26331.0 |
| 2022-02-14 05:00:00 | SPY | ETF | 436.0 | 437.25 | 435.24 | 436.92 | 24223.0 |
| 2022-02-14 05:30:00 | SPY | ETF | 436.92 | 438.33 | 436.59 | 437.51 | 49718.0 |
| 2022-02-14 06:00:00 | SPY | ETF | 437.01 | 437.58 | 436.67 | 437.58 | 10952.0 |
| 2022-02-14 06:30:00 | SPY | ETF | 437.31 | 437.84 | 436.95 | 437.51 | 35300.0 |
| 2022-02-14 07:00:00 | SPY | ETF | 437.49 | 437.54 | 436.5 | 437.3 | 106808.0 |
| 2022-02-14 07:30:00 | SPY | ETF | 437.3 | 441.8 | 437.12 | 440.5 | 1127237.0 |
| 2022-02-14 08:00:00 | SPY | ETF | 437.7001 | 442.0 | 435.9096 | 441.21 | 872566.0 |
| 2022-02-14 08:30:00 | SPY | ETF | 441.21 | 441.71 | 438.79 | 439.45 | 807233.0 |
| 2022-02-14 09:00:00 | SPY | ETF | 439.48 | 440.8 | 439.13 | 439.8604 | 369637.0 |
| 2022-02-14 09:30:00 | SPY | ETF | 439.92 | 441.28 | 438.97 | 440.18 | 9771785.0 |
| 2022-02-14 10:00:00 | SPY | ETF | 440.16 | 440.41 | 437.651 | 438.94 | 7818560.0 |
| 2022-02-14 10:30:00 | SPY | ETF | 438.93 | 439.37 | 437.36 | 437.87 | 5634420.0 |
| 2022-02-14 11:00:00 | SPY | ETF | 437.88 | 440.17 | 437.62 | 439.78 | 4984130.0 |
| 2022-02-14 11:30:00 | SPY | ETF | 439.79 | 440.68 | 438.86 | 440.17 | 5568910.0 |
| 2022-02-14 12:00:00 | SPY | ETF | 440.18 | 440.97 | 439.55 | 440.94 | 3165980.0 |
| 2022-02-14 12:30:00 | SPY | ETF | 440.92 | 441.489 | 440.455 | 440.9023 | 3400495.0 |
| 2022-02-14 13:00:00 | SPY | ETF | 440.91 | 441.6 | 439.71 | 439.95 | 3279637.0 |
| 2022-02-14 13:30:00 | SPY | ETF | 439.94 | 440.0499 | 436.15 | 436.24 | 8289126.0 |
| 2022-02-14 14:00:00 | SPY | ETF | 436.26 | 438.78 | 435.34 | 437.49 | 9376167.0 |
| 2022-02-14 14:30:00 | SPY | ETF | 437.48 | 438.88 | 436.57 | 438.08 | 7571534.0 |
| 2022-02-14 15:00:00 | SPY | ETF | 438.1 | 439.47 | 436.83 | 438.51 | 5860109.0 |
| 2022-02-14 15:30:00 | SPY | ETF | 438.505 | 440.2 | 438.28 | 439.06 | 14645105.0 |
| 2022-02-14 16:00:00 | SPY | ETF | 439.06 | 439.48 | 438.89 | 439.37 | 4841681.0 |
| 2022-02-14 16:30:00 | SPY | ETF | 439.37 | 439.4496 | 438.96 | 439.1 | 113865.0 |
| 2022-02-14 17:00:00 | SPY | ETF | 439.18 | 439.28 | 439.0 | 439.14 | 26214.0 |
| 2022-02-14 17:30:00 | SPY | ETF | 439.15 | 439.19 | 439.15 | 439.15 | 1775.0 |
| 2022-02-14 18:00:00 | SPY | ETF | 439.14 | 439.81 | 439.1 | 439.73 | 49967.0 |
| 2022-02-14 18:30:00 | SPY | ETF | 439.02 | 439.87 | 439.02 | 439.8404 | 65226.0 |
| 2022-02-14 19:00:00 | SPY | ETF | 439.94 | 440.06 | 438.91 | 439.06 | 94503.0 |
| 2022-02-14 19:30:00 | SPY | ETF | 439.02 | 439.4 | 438.6 | 439.3899 | 42392.0 |
| 2022-02-14 04:00:00 | QQQ | ETF | 345.0 | 345.0 | 342.58 | 343.79 | 94259.0 |
| 2022-02-14 04:30:00 | QQQ | ETF | 343.81 | 344.07 | 343.04 | 343.3 | 101577.0 |
| 2022-02-14 05:00:00 | QQQ | ETF | 343.08 | 344.01 | 342.2 | 343.81 | 127687.0 |
| 2022-02-14 05:30:00 | QQQ | ETF | 343.71 | 344.5 | 343.4 | 343.95 | 51842.0 |
| 2022-02-14 06:00:00 | QQQ | ETF | 343.72 | 343.92 | 343.02 | 343.68 | 71353.0 |
| 2022-02-14 06:30:00 | QQQ | ETF | 343.71 | 344.41 | 343.53 | 343.9 | 164333.0 |
| 2022-02-14 07:00:00 | QQQ | ETF | 343.97 | 344.3 | 342.97 | 343.72 | 179351.0 |
| 2022-02-14 07:30:00 | QQQ | ETF | 343.67 | 347.76 | 343.34 | 347.08 | 971673.0 |
| 2022-02-14 08:00:00 | QQQ | ETF | 343.6301 | 348.3 | 342.6096 | 347.51 | 522269.0 |
| 2022-02-14 08:30:00 | QQQ | ETF | 347.51 | 347.62 | 345.38 | 345.92 | 730494.0 |
| 2022-02-14 09:00:00 | QQQ | ETF | 345.87 | 347.42 | 345.52 | 346.45 | 597686.0 |
| 2022-02-14 09:30:00 | QQQ | ETF | 346.46 | 349.55 | 345.81 | 348.4291 | 8024511.0 |
| 2022-02-14 10:00:00 | QQQ | ETF | 348.4 | 348.85 | 346.4841 | 348.03 | 5827117.0 |
| 2022-02-14 10:30:00 | QQQ | ETF | 348.03 | 349.26 | 346.4 | 348.02 | 5070005.0 |
| 2022-02-14 11:00:00 | QQQ | ETF | 348.01 | 350.569 | 347.66 | 350.13 | 3819073.0 |
| 2022-02-14 11:30:00 | QQQ | ETF | 350.14 | 350.5 | 349.07 | 349.66 | 3453418.0 |
| 2022-02-14 12:00:00 | QQQ | ETF | 349.69 | 350.44 | 349.24 | 350.43 | 2297514.0 |
| 2022-02-14 12:30:00 | QQQ | ETF | 350.42 | 350.98 | 349.59 | 349.87 | 1937171.0 |
> showing 50 of 26,654 rows — these rows as CSV