PREVIEW / etf_30min / 2021-02-25
file: by_date/etf_30min/2021/2021-02-25.parquet size: 655 KB rows: 25,581
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-25 04:00:00 | SPY | ETF | 391.9 | 391.9 | 391.2 | 391.42 | 32323.0 |
| 2021-02-25 04:30:00 | SPY | ETF | 391.64 | 391.64 | 391.15 | 391.6 | 21423.0 |
| 2021-02-25 05:00:00 | SPY | ETF | 391.53 | 391.65 | 391.2 | 391.65 | 6793.0 |
| 2021-02-25 05:30:00 | SPY | ETF | 391.66 | 391.96 | 391.66 | 391.87 | 7634.0 |
| 2021-02-25 06:00:00 | SPY | ETF | 392.0 | 392.08 | 390.84 | 390.97 | 29221.0 |
| 2021-02-25 06:30:00 | SPY | ETF | 390.92 | 391.03 | 390.37 | 390.91 | 128313.0 |
| 2021-02-25 07:00:00 | SPY | ETF | 390.87 | 391.28 | 390.53 | 391.22 | 212311.0 |
| 2021-02-25 07:30:00 | SPY | ETF | 391.24 | 391.24 | 390.35 | 390.72 | 245459.0 |
| 2021-02-25 08:00:00 | SPY | ETF | 390.69 | 392.98 | 390.2 | 390.3499 | 396665.0 |
| 2021-02-25 08:30:00 | SPY | ETF | 390.41 | 391.21 | 390.25 | 390.7 | 299759.0 |
| 2021-02-25 09:00:00 | SPY | ETF | 390.72 | 390.73 | 390.05 | 390.47 | 401936.0 |
| 2021-02-25 09:30:00 | SPY | ETF | 390.41 | 391.88 | 390.4 | 390.96 | 8183444.0 |
| 2021-02-25 10:00:00 | SPY | ETF | 390.97 | 391.01 | 389.22 | 389.72 | 9313047.0 |
| 2021-02-25 10:30:00 | SPY | ETF | 389.72 | 389.72 | 387.565 | 389.0 | 10523616.0 |
| 2021-02-25 11:00:00 | SPY | ETF | 388.98 | 389.66 | 388.24 | 388.495 | 4947753.0 |
| 2021-02-25 11:30:00 | SPY | ETF | 388.5 | 388.56 | 386.07 | 386.33 | 8048847.0 |
| 2021-02-25 12:00:00 | SPY | ETF | 386.33 | 386.8899 | 385.26 | 385.41 | 8660045.0 |
| 2021-02-25 12:30:00 | SPY | ETF | 385.39 | 385.58 | 382.68 | 382.92 | 10976711.0 |
| 2021-02-25 13:00:00 | SPY | ETF | 382.91 | 384.99 | 381.76 | 384.55 | 13213450.0 |
| 2021-02-25 13:30:00 | SPY | ETF | 384.54 | 385.0 | 383.38 | 384.13 | 6076445.0 |
| 2021-02-25 14:00:00 | SPY | ETF | 384.115 | 386.67 | 383.74 | 386.465 | 5900753.0 |
| 2021-02-25 14:30:00 | SPY | ETF | 386.46 | 386.46 | 384.055 | 384.135 | 5641141.0 |
| 2021-02-25 15:00:00 | SPY | ETF | 384.13 | 384.66 | 381.99 | 382.25 | 9240585.0 |
| 2021-02-25 15:30:00 | SPY | ETF | 382.26 | 383.96 | 380.7789 | 382.39 | 19059416.0 |
| 2021-02-25 16:00:00 | SPY | ETF | 382.4 | 383.79 | 382.28 | 382.72 | 4941157.0 |
| 2021-02-25 16:30:00 | SPY | ETF | 382.75 | 383.01 | 381.7 | 381.89 | 318635.0 |
| 2021-02-25 17:00:00 | SPY | ETF | 381.85 | 381.94 | 381.66 | 381.9 | 83229.0 |
| 2021-02-25 17:30:00 | SPY | ETF | 381.9 | 382.33 | 381.58 | 381.69 | 211867.0 |
| 2021-02-25 18:00:00 | SPY | ETF | 381.72 | 383.02 | 381.1 | 382.29 | 267474.0 |
| 2021-02-25 18:30:00 | SPY | ETF | 382.33 | 383.1 | 381.8 | 381.83 | 104234.0 |
| 2021-02-25 19:00:00 | SPY | ETF | 381.7 | 382.29 | 380.37 | 380.5 | 167262.0 |
| 2021-02-25 19:30:00 | SPY | ETF | 380.49 | 382.35 | 380.22 | 382.13 | 226139.0 |
| 2021-02-25 04:00:00 | QQQ | ETF | 323.14 | 323.14 | 322.0 | 322.34 | 96630.0 |
| 2021-02-25 04:30:00 | QQQ | ETF | 322.3 | 322.46 | 321.52 | 322.15 | 31699.0 |
| 2021-02-25 05:00:00 | QQQ | ETF | 322.02 | 322.43 | 321.68 | 322.26 | 29306.0 |
| 2021-02-25 05:30:00 | QQQ | ETF | 322.2 | 323.18 | 322.15 | 323.18 | 26877.0 |
| 2021-02-25 06:00:00 | QQQ | ETF | 323.38 | 323.47 | 321.08 | 321.38 | 131574.0 |
| 2021-02-25 06:30:00 | QQQ | ETF | 321.22 | 321.54 | 320.55 | 321.15 | 271792.0 |
| 2021-02-25 07:00:00 | QQQ | ETF | 321.19 | 322.0 | 320.9 | 321.87 | 154002.0 |
| 2021-02-25 07:30:00 | QQQ | ETF | 321.85 | 322.01 | 320.86 | 321.23 | 235531.0 |
| 2021-02-25 08:00:00 | QQQ | ETF | 321.44 | 325.41 | 320.6996 | 320.92 | 253009.0 |
| 2021-02-25 08:30:00 | QQQ | ETF | 321.01 | 322.39 | 320.9 | 321.95 | 251497.0 |
| 2021-02-25 09:00:00 | QQQ | ETF | 321.86 | 321.86 | 320.79 | 321.35 | 399666.0 |
| 2021-02-25 09:30:00 | QQQ | ETF | 321.4 | 324.03 | 321.34 | 322.3 | 7546260.0 |
| 2021-02-25 10:00:00 | QQQ | ETF | 322.32 | 322.39 | 319.925 | 320.6862 | 6905681.0 |
| 2021-02-25 10:30:00 | QQQ | ETF | 320.63 | 320.67 | 318.34 | 320.18 | 6897543.0 |
| 2021-02-25 11:00:00 | QQQ | ETF | 320.1677 | 321.04 | 319.07 | 319.4141 | 3643729.0 |
| 2021-02-25 11:30:00 | QQQ | ETF | 319.4 | 319.459 | 316.6 | 316.71 | 5434791.0 |
| 2021-02-25 12:00:00 | QQQ | ETF | 316.73 | 317.38 | 315.5 | 315.65 | 5216474.0 |
| 2021-02-25 12:30:00 | QQQ | ETF | 315.64 | 316.05 | 312.95 | 313.37 | 6769167.0 |
> showing 50 of 25,581 rows — these rows as CSV