PREVIEW / etf_30min / 2022-03-29
file: by_date/etf_30min/2022/2022-03-29.parquet size: 708 KB rows: 27,941
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-29 04:00:00 | SPY | ETF | 456.89 | 457.29 | 456.83 | 457.0 | 15667.0 |
| 2022-03-29 04:30:00 | SPY | ETF | 456.9 | 457.31 | 456.85 | 457.1 | 10653.0 |
| 2022-03-29 05:00:00 | SPY | ETF | 457.29 | 458.11 | 457.17 | 457.64 | 26517.0 |
| 2022-03-29 05:30:00 | SPY | ETF | 457.61 | 458.25 | 457.6 | 457.77 | 77127.0 |
| 2022-03-29 06:00:00 | SPY | ETF | 457.79 | 457.79 | 457.26 | 457.6 | 9403.0 |
| 2022-03-29 06:30:00 | SPY | ETF | 457.62 | 457.8 | 457.37 | 457.48 | 33355.0 |
| 2022-03-29 07:00:00 | SPY | ETF | 457.46 | 457.83 | 457.3 | 457.35 | 73142.0 |
| 2022-03-29 07:30:00 | SPY | ETF | 457.4 | 458.85 | 457.1 | 458.49 | 635140.0 |
| 2022-03-29 08:00:00 | SPY | ETF | 457.3999 | 460.1 | 456.1 | 459.86 | 793920.0 |
| 2022-03-29 08:30:00 | SPY | ETF | 459.89 | 459.89 | 459.23 | 459.66 | 408778.0 |
| 2022-03-29 09:00:00 | SPY | ETF | 459.7 | 460.12 | 459.31 | 460.07 | 657909.0 |
| 2022-03-29 09:30:00 | SPY | ETF | 460.02 | 461.75 | 458.68 | 459.2714 | 11266560.0 |
| 2022-03-29 10:00:00 | SPY | ETF | 459.3 | 459.705 | 457.18 | 458.7 | 6008446.0 |
| 2022-03-29 10:30:00 | SPY | ETF | 458.7 | 459.4179 | 457.6 | 459.19 | 4406908.0 |
| 2022-03-29 11:00:00 | SPY | ETF | 459.19 | 459.52 | 458.25 | 459.32 | 2722514.0 |
| 2022-03-29 11:30:00 | SPY | ETF | 459.32 | 459.95 | 459.105 | 459.435 | 2375675.0 |
| 2022-03-29 12:00:00 | SPY | ETF | 459.45 | 459.485 | 458.17 | 458.36 | 2233595.0 |
| 2022-03-29 12:30:00 | SPY | ETF | 458.35 | 458.8 | 457.51 | 458.31 | 2856980.0 |
| 2022-03-29 13:00:00 | SPY | ETF | 458.31 | 458.4 | 457.65 | 458.15 | 1984619.0 |
| 2022-03-29 13:30:00 | SPY | ETF | 458.1618 | 459.56 | 457.96 | 459.55 | 2832193.0 |
| 2022-03-29 14:00:00 | SPY | ETF | 459.54 | 459.87 | 459.09 | 459.815 | 2715131.0 |
| 2022-03-29 14:30:00 | SPY | ETF | 459.81 | 460.84 | 459.7155 | 460.57 | 3351979.0 |
| 2022-03-29 15:00:00 | SPY | ETF | 460.5618 | 461.54 | 460.31 | 461.515 | 6147034.0 |
| 2022-03-29 15:30:00 | SPY | ETF | 461.53 | 462.07 | 460.5909 | 461.59 | 11767965.0 |
| 2022-03-29 16:00:00 | SPY | ETF | 461.6 | 461.67 | 460.87 | 461.01 | 2881015.0 |
| 2022-03-29 16:30:00 | SPY | ETF | 461.04 | 461.55 | 461.0 | 461.07 | 302134.0 |
| 2022-03-29 17:00:00 | SPY | ETF | 460.93 | 461.02 | 460.76 | 460.92 | 101691.0 |
| 2022-03-29 17:30:00 | SPY | ETF | 460.93 | 460.97 | 460.9 | 460.97 | 31360.0 |
| 2022-03-29 18:00:00 | SPY | ETF | 460.97 | 461.02 | 460.59 | 460.84 | 63881.0 |
| 2022-03-29 18:30:00 | SPY | ETF | 460.9 | 461.08 | 460.83 | 460.89 | 19850.0 |
| 2022-03-29 19:00:00 | SPY | ETF | 460.92 | 461.01 | 460.92 | 461.0 | 3807.0 |
| 2022-03-29 19:30:00 | SPY | ETF | 460.9 | 461.1 | 460.87 | 461.1 | 56629.0 |
| 2022-03-29 04:00:00 | QQQ | ETF | 365.46 | 365.88 | 365.39 | 365.64 | 37383.0 |
| 2022-03-29 04:30:00 | QQQ | ETF | 365.61 | 366.0 | 365.5 | 365.8 | 13541.0 |
| 2022-03-29 05:00:00 | QQQ | ETF | 365.76 | 367.15 | 365.74 | 366.76 | 52088.0 |
| 2022-03-29 05:30:00 | QQQ | ETF | 366.77 | 367.31 | 366.46 | 366.6 | 39265.0 |
| 2022-03-29 06:00:00 | QQQ | ETF | 366.64 | 366.64 | 365.81 | 366.28 | 32050.0 |
| 2022-03-29 06:30:00 | QQQ | ETF | 366.2 | 366.43 | 365.83 | 365.9 | 95260.0 |
| 2022-03-29 07:00:00 | QQQ | ETF | 365.94 | 366.52 | 365.85 | 366.01 | 107553.0 |
| 2022-03-29 07:30:00 | QQQ | ETF | 365.99 | 367.73 | 365.63 | 367.44 | 371768.0 |
| 2022-03-29 08:00:00 | QQQ | ETF | 366.03 | 369.35 | 364.59 | 369.1 | 713267.0 |
| 2022-03-29 08:30:00 | QQQ | ETF | 369.04 | 369.33 | 368.41 | 369.26 | 489181.0 |
| 2022-03-29 09:00:00 | QQQ | ETF | 369.3 | 369.47 | 368.69 | 368.9 | 366689.0 |
| 2022-03-29 09:30:00 | QQQ | ETF | 368.86 | 370.72 | 367.86 | 368.96 | 9389504.0 |
| 2022-03-29 10:00:00 | QQQ | ETF | 368.97 | 369.7 | 366.06 | 367.65 | 6744000.0 |
| 2022-03-29 10:30:00 | QQQ | ETF | 367.63 | 368.62 | 366.14 | 368.3989 | 3948115.0 |
| 2022-03-29 11:00:00 | QQQ | ETF | 368.45 | 368.9789 | 367.35 | 368.72 | 2894705.0 |
| 2022-03-29 11:30:00 | QQQ | ETF | 368.7 | 369.4399 | 368.45 | 368.88 | 2307328.0 |
| 2022-03-29 12:00:00 | QQQ | ETF | 368.9 | 369.069 | 368.0047 | 368.2568 | 2185327.0 |
| 2022-03-29 12:30:00 | QQQ | ETF | 368.24 | 368.66 | 367.21 | 368.3001 | 2218410.0 |
> showing 50 of 27,941 rows — these rows as CSV