PREVIEW / etf_30min / 2021-02-17
file: by_date/etf_30min/2021/2021-02-17.parquet size: 630 KB rows: 23,950
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-17 04:00:00 | SPY | ETF | 392.39 | 392.74 | 392.1 | 392.27 | 27166.0 |
| 2021-02-17 04:30:00 | SPY | ETF | 392.29 | 392.3 | 391.77 | 391.95 | 12121.0 |
| 2021-02-17 05:00:00 | SPY | ETF | 391.95 | 392.26 | 391.95 | 392.26 | 1950.0 |
| 2021-02-17 05:30:00 | SPY | ETF | 392.3 | 392.34 | 392.04 | 392.09 | 31200.0 |
| 2021-02-17 06:00:00 | SPY | ETF | 392.14 | 392.28 | 391.97 | 392.14 | 10350.0 |
| 2021-02-17 06:30:00 | SPY | ETF | 392.17 | 392.34 | 392.17 | 392.34 | 15780.0 |
| 2021-02-17 07:00:00 | SPY | ETF | 392.31 | 392.42 | 392.22 | 392.3 | 62304.0 |
| 2021-02-17 07:30:00 | SPY | ETF | 392.3 | 392.68 | 392.25 | 392.56 | 125727.0 |
| 2021-02-17 08:00:00 | SPY | ETF | 392.64 | 393.0 | 391.83 | 392.19 | 385088.0 |
| 2021-02-17 08:30:00 | SPY | ETF | 392.33 | 392.37 | 390.83 | 391.34 | 449617.0 |
| 2021-02-17 09:00:00 | SPY | ETF | 391.36 | 391.59 | 390.39 | 390.47 | 375290.0 |
| 2021-02-17 09:30:00 | SPY | ETF | 390.42 | 391.67 | 389.33 | 391.06 | 6942668.0 |
| 2021-02-17 10:00:00 | SPY | ETF | 391.06 | 391.72 | 390.2222 | 390.485 | 3419408.0 |
| 2021-02-17 10:30:00 | SPY | ETF | 390.49 | 391.38 | 390.06 | 391.1901 | 3433281.0 |
| 2021-02-17 11:00:00 | SPY | ETF | 391.18 | 391.27 | 389.615 | 390.14 | 3212222.0 |
| 2021-02-17 11:30:00 | SPY | ETF | 390.14 | 390.69 | 389.48 | 390.56 | 2908704.0 |
| 2021-02-17 12:00:00 | SPY | ETF | 390.56 | 390.903 | 390.36 | 390.903 | 1377535.0 |
| 2021-02-17 12:30:00 | SPY | ETF | 390.905 | 391.315 | 390.81 | 391.0287 | 1300351.0 |
| 2021-02-17 13:00:00 | SPY | ETF | 391.02 | 391.6 | 390.95 | 391.53 | 1668356.0 |
| 2021-02-17 13:30:00 | SPY | ETF | 391.5211 | 391.55 | 391.17 | 391.27 | 1210844.0 |
| 2021-02-17 14:00:00 | SPY | ETF | 391.27 | 392.14 | 391.27 | 391.38 | 2129818.0 |
| 2021-02-17 14:30:00 | SPY | ETF | 391.38 | 391.97 | 391.26 | 391.84 | 1407979.0 |
| 2021-02-17 15:00:00 | SPY | ETF | 391.84 | 392.4 | 391.77 | 392.16 | 2349986.0 |
| 2021-02-17 15:30:00 | SPY | ETF | 392.16 | 392.66 | 392.02 | 392.43 | 5214790.0 |
| 2021-02-17 16:00:00 | SPY | ETF | 392.435 | 392.46 | 391.536 | 392.175 | 3330663.0 |
| 2021-02-17 16:30:00 | SPY | ETF | 392.19 | 392.37 | 392.14 | 392.34 | 295410.0 |
| 2021-02-17 17:00:00 | SPY | ETF | 392.37 | 392.47 | 392.3 | 392.44 | 157289.0 |
| 2021-02-17 17:30:00 | SPY | ETF | 392.45 | 392.5 | 392.39 | 392.46 | 88083.0 |
| 2021-02-17 18:00:00 | SPY | ETF | 392.46 | 392.5 | 392.1 | 392.17 | 85242.0 |
| 2021-02-17 18:30:00 | SPY | ETF | 392.23 | 392.69 | 392.19 | 392.59 | 21766.0 |
| 2021-02-17 19:00:00 | SPY | ETF | 392.67 | 393.05 | 392.67 | 392.9 | 54634.0 |
| 2021-02-17 19:30:00 | SPY | ETF | 392.92 | 393.2 | 392.82 | 393.09 | 51084.0 |
| 2021-02-17 04:00:00 | QQQ | ETF | 335.83 | 335.83 | 335.39 | 335.4 | 27693.0 |
| 2021-02-17 04:30:00 | QQQ | ETF | 335.41 | 335.41 | 334.83 | 334.93 | 18111.0 |
| 2021-02-17 05:00:00 | QQQ | ETF | 334.96 | 335.1 | 334.8 | 335.08 | 6300.0 |
| 2021-02-17 05:30:00 | QQQ | ETF | 335.09 | 335.16 | 334.82 | 334.91 | 8145.0 |
| 2021-02-17 06:00:00 | QQQ | ETF | 334.99 | 335.05 | 334.81 | 335.0 | 15206.0 |
| 2021-02-17 06:30:00 | QQQ | ETF | 335.03 | 335.14 | 334.91 | 335.05 | 7500.0 |
| 2021-02-17 07:00:00 | QQQ | ETF | 335.05 | 335.2 | 334.81 | 334.87 | 22403.0 |
| 2021-02-17 07:30:00 | QQQ | ETF | 334.85 | 335.38 | 334.85 | 335.17 | 52258.0 |
| 2021-02-17 08:00:00 | QQQ | ETF | 334.8604 | 335.5 | 334.3 | 334.46 | 262402.0 |
| 2021-02-17 08:30:00 | QQQ | ETF | 334.56 | 334.7 | 332.99 | 333.4 | 424929.0 |
| 2021-02-17 09:00:00 | QQQ | ETF | 333.36 | 333.72 | 332.19 | 332.44 | 301970.0 |
| 2021-02-17 09:30:00 | QQQ | ETF | 332.44 | 333.8 | 331.8 | 333.27 | 3403076.0 |
| 2021-02-17 10:00:00 | QQQ | ETF | 333.28 | 333.67 | 331.18 | 331.6291 | 2986607.0 |
| 2021-02-17 10:30:00 | QQQ | ETF | 331.59 | 332.88 | 331.0 | 332.81 | 2262840.0 |
| 2021-02-17 11:00:00 | QQQ | ETF | 332.78 | 332.92 | 330.27 | 331.0 | 2390004.0 |
| 2021-02-17 11:30:00 | QQQ | ETF | 330.99 | 331.58 | 330.17 | 331.52 | 1916738.0 |
| 2021-02-17 12:00:00 | QQQ | ETF | 331.58 | 331.98 | 331.33 | 331.98 | 932069.0 |
| 2021-02-17 12:30:00 | QQQ | ETF | 331.99 | 332.705 | 331.85 | 332.39 | 874695.0 |
> showing 50 of 23,950 rows — these rows as CSV