PREVIEW / etf_30min / 2022-02-22
file: by_date/etf_30min/2022/2022-02-22.parquet size: 707 KB rows: 28,025
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-22 04:00:00 | SPY | ETF | 430.25 | 430.97 | 428.24 | 429.22 | 87547.0 |
| 2022-02-22 04:30:00 | SPY | ETF | 429.19 | 429.65 | 428.58 | 428.76 | 53545.0 |
| 2022-02-22 05:00:00 | SPY | ETF | 428.99 | 432.22 | 428.92 | 431.96 | 198067.0 |
| 2022-02-22 05:30:00 | SPY | ETF | 431.74 | 434.66 | 431.51 | 433.32 | 346564.0 |
| 2022-02-22 06:00:00 | SPY | ETF | 433.45 | 433.82 | 432.9 | 433.0 | 143014.0 |
| 2022-02-22 06:30:00 | SPY | ETF | 433.11 | 433.55 | 432.03 | 433.19 | 87163.0 |
| 2022-02-22 07:00:00 | SPY | ETF | 433.12 | 434.63 | 432.22 | 433.72 | 303705.0 |
| 2022-02-22 07:30:00 | SPY | ETF | 433.71 | 434.2 | 433.06 | 433.81 | 154680.0 |
| 2022-02-22 08:00:00 | SPY | ETF | 432.6701 | 434.61 | 426.5 | 432.53 | 671181.0 |
| 2022-02-22 08:30:00 | SPY | ETF | 432.51 | 433.89 | 432.51 | 433.43 | 227963.0 |
| 2022-02-22 09:00:00 | SPY | ETF | 433.36 | 433.89 | 431.87 | 431.93 | 987739.0 |
| 2022-02-22 09:30:00 | SPY | ETF | 431.89 | 435.3 | 430.49 | 434.19 | 10194066.0 |
| 2022-02-22 10:00:00 | SPY | ETF | 434.19 | 435.48 | 432.88 | 435.42 | 5351279.0 |
| 2022-02-22 10:30:00 | SPY | ETF | 435.44 | 435.5 | 431.67 | 431.78 | 5044596.0 |
| 2022-02-22 11:00:00 | SPY | ETF | 431.79 | 432.45 | 430.93 | 431.36 | 4680830.0 |
| 2022-02-22 11:30:00 | SPY | ETF | 431.37 | 432.42 | 430.41 | 431.2404 | 4258013.0 |
| 2022-02-22 12:00:00 | SPY | ETF | 431.24 | 431.93 | 430.27 | 430.4591 | 2921041.0 |
| 2022-02-22 12:30:00 | SPY | ETF | 430.45 | 430.67 | 429.23 | 429.44 | 3693788.0 |
| 2022-02-22 13:00:00 | SPY | ETF | 429.45 | 430.09 | 428.23 | 428.81 | 3710239.0 |
| 2022-02-22 13:30:00 | SPY | ETF | 428.8 | 429.27 | 426.77 | 427.3199 | 4179662.0 |
| 2022-02-22 14:00:00 | SPY | ETF | 427.29 | 428.8 | 425.86 | 428.21 | 9006114.0 |
| 2022-02-22 14:30:00 | SPY | ETF | 428.15 | 431.7799 | 427.31 | 430.94 | 9403263.0 |
| 2022-02-22 15:00:00 | SPY | ETF | 430.95 | 432.88 | 430.73 | 431.66 | 7758636.0 |
| 2022-02-22 15:30:00 | SPY | ETF | 431.63 | 431.8 | 428.05 | 429.65 | 17915221.0 |
| 2022-02-22 16:00:00 | SPY | ETF | 429.65 | 431.59 | 429.57 | 431.09 | 4740548.0 |
| 2022-02-22 16:30:00 | SPY | ETF | 431.11 | 431.66 | 429.57 | 430.87 | 537267.0 |
| 2022-02-22 17:00:00 | SPY | ETF | 430.79 | 431.0 | 430.62 | 430.95 | 173952.0 |
| 2022-02-22 17:30:00 | SPY | ETF | 430.83 | 430.95 | 430.76 | 430.76 | 17287.0 |
| 2022-02-22 18:00:00 | SPY | ETF | 430.73 | 432.1 | 430.73 | 432.0 | 121576.0 |
| 2022-02-22 18:30:00 | SPY | ETF | 429.57 | 432.3 | 429.57 | 432.031 | 88450.0 |
| 2022-02-22 19:00:00 | SPY | ETF | 432.13 | 432.2 | 431.88 | 432.01 | 50289.0 |
| 2022-02-22 19:30:00 | SPY | ETF | 432.02 | 432.14 | 431.86 | 432.14 | 59453.0 |
| 2022-02-22 04:00:00 | QQQ | ETF | 335.0 | 336.84 | 334.12 | 335.16 | 213628.0 |
| 2022-02-22 04:30:00 | QQQ | ETF | 335.17 | 335.75 | 334.63 | 334.74 | 88254.0 |
| 2022-02-22 05:00:00 | QQQ | ETF | 334.76 | 337.92 | 334.69 | 337.8 | 136702.0 |
| 2022-02-22 05:30:00 | QQQ | ETF | 337.68 | 340.57 | 337.61 | 339.47 | 202897.0 |
| 2022-02-22 06:00:00 | QQQ | ETF | 339.57 | 339.73 | 339.09 | 339.19 | 62908.0 |
| 2022-02-22 06:30:00 | QQQ | ETF | 339.32 | 339.61 | 338.2 | 339.4 | 81997.0 |
| 2022-02-22 07:00:00 | QQQ | ETF | 339.15 | 340.35 | 338.37 | 339.8 | 467050.0 |
| 2022-02-22 07:30:00 | QQQ | ETF | 339.83 | 340.2 | 338.97 | 339.83 | 213408.0 |
| 2022-02-22 08:00:00 | QQQ | ETF | 339.8701 | 341.766 | 332.28 | 338.84 | 380948.0 |
| 2022-02-22 08:30:00 | QQQ | ETF | 338.95 | 340.19 | 338.92 | 339.9 | 346225.0 |
| 2022-02-22 09:00:00 | QQQ | ETF | 339.79 | 340.11 | 338.36 | 338.5 | 423304.0 |
| 2022-02-22 09:30:00 | QQQ | ETF | 338.52 | 343.73 | 338.04 | 341.93 | 8434091.0 |
| 2022-02-22 10:00:00 | QQQ | ETF | 341.92 | 344.03 | 339.17 | 343.989 | 5039336.0 |
| 2022-02-22 10:30:00 | QQQ | ETF | 343.9964 | 344.04 | 339.81 | 340.01 | 4347362.0 |
| 2022-02-22 11:00:00 | QQQ | ETF | 340.03 | 340.48 | 338.48 | 338.76 | 4367463.0 |
| 2022-02-22 11:30:00 | QQQ | ETF | 338.8 | 339.55 | 337.34 | 338.25 | 4138143.0 |
| 2022-02-22 12:00:00 | QQQ | ETF | 338.23 | 339.14 | 337.5301 | 337.845 | 2547732.0 |
| 2022-02-22 12:30:00 | QQQ | ETF | 337.84 | 338.15 | 336.865 | 337.31 | 2840806.0 |
> showing 50 of 28,025 rows — these rows as CSV