PREVIEW / etf_30min / 2021-10-11
file: by_date/etf_30min/2021/2021-10-11.parquet size: 604 KB rows: 22,873
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-10-11 04:00:00 | SPY | ETF | 436.5 | 436.76 | 435.94 | 436.07 | 23440.0 |
| 2021-10-11 04:30:00 | SPY | ETF | 436.49 | 436.72 | 435.94 | 436.41 | 6040.0 |
| 2021-10-11 05:00:00 | SPY | ETF | 436.42 | 436.86 | 436.4 | 436.61 | 4800.0 |
| 2021-10-11 05:30:00 | SPY | ETF | 436.33 | 436.85 | 436.33 | 436.66 | 3999.0 |
| 2021-10-11 06:00:00 | SPY | ETF | 436.61 | 436.65 | 436.13 | 436.14 | 9325.0 |
| 2021-10-11 06:30:00 | SPY | ETF | 436.19 | 436.19 | 435.36 | 435.63 | 54545.0 |
| 2021-10-11 07:00:00 | SPY | ETF | 435.67 | 436.41 | 435.5 | 436.29 | 88648.0 |
| 2021-10-11 07:30:00 | SPY | ETF | 436.26 | 436.32 | 435.64 | 435.88 | 89710.0 |
| 2021-10-11 08:00:00 | SPY | ETF | 435.6201 | 438.158 | 435.54 | 436.28 | 159292.0 |
| 2021-10-11 08:30:00 | SPY | ETF | 436.25 | 437.06 | 436.16 | 436.8 | 231748.0 |
| 2021-10-11 09:00:00 | SPY | ETF | 436.84 | 437.44 | 436.76 | 437.13 | 201737.0 |
| 2021-10-11 09:30:00 | SPY | ETF | 437.16 | 439.41 | 436.9 | 439.39 | 5392913.0 |
| 2021-10-11 10:00:00 | SPY | ETF | 439.4 | 440.26 | 439.36 | 440.15 | 3273453.0 |
| 2021-10-11 10:30:00 | SPY | ETF | 440.16 | 440.23 | 439.5201 | 439.64 | 2059212.0 |
| 2021-10-11 11:00:00 | SPY | ETF | 439.65 | 439.8698 | 439.13 | 439.38 | 1958804.0 |
| 2021-10-11 11:30:00 | SPY | ETF | 439.38 | 440.14 | 439.33 | 439.6 | 2114609.0 |
| 2021-10-11 12:00:00 | SPY | ETF | 439.59 | 439.68 | 438.21 | 438.63 | 3107122.0 |
| 2021-10-11 12:30:00 | SPY | ETF | 438.62 | 438.65 | 437.72 | 438.06 | 2160874.0 |
| 2021-10-11 13:00:00 | SPY | ETF | 438.07 | 438.08 | 436.28 | 436.47 | 4202772.0 |
| 2021-10-11 13:30:00 | SPY | ETF | 436.46 | 436.83 | 435.93 | 436.48 | 3519204.0 |
| 2021-10-11 14:00:00 | SPY | ETF | 436.475 | 437.32 | 436.27 | 436.56 | 2892578.0 |
| 2021-10-11 14:30:00 | SPY | ETF | 436.54 | 437.03 | 436.2 | 436.83 | 2318487.0 |
| 2021-10-11 15:00:00 | SPY | ETF | 436.81 | 437.07 | 435.85 | 435.885 | 3057883.0 |
| 2021-10-11 15:30:00 | SPY | ETF | 435.9 | 436.19 | 434.62 | 434.66 | 9541612.0 |
| 2021-10-11 16:00:00 | SPY | ETF | 434.66 | 434.7417 | 434.21 | 434.44 | 3109397.0 |
| 2021-10-11 16:30:00 | SPY | ETF | 434.42 | 434.69 | 434.0 | 434.37 | 112488.0 |
| 2021-10-11 17:00:00 | SPY | ETF | 434.24 | 434.47 | 434.24 | 434.39 | 8471.0 |
| 2021-10-11 17:30:00 | SPY | ETF | 434.39 | 434.5 | 434.38 | 434.44 | 54399.0 |
| 2021-10-11 18:00:00 | SPY | ETF | 434.43 | 434.55 | 434.07 | 434.37 | 75677.0 |
| 2021-10-11 18:30:00 | SPY | ETF | 434.69 | 434.69 | 433.82 | 433.9 | 76643.0 |
| 2021-10-11 19:00:00 | SPY | ETF | 433.9 | 434.31 | 433.82 | 434.1 | 53222.0 |
| 2021-10-11 19:30:00 | SPY | ETF | 434.17 | 434.45 | 433.99 | 434.4 | 44053.0 |
| 2021-10-11 04:00:00 | QQQ | ETF | 360.46 | 360.46 | 359.01 | 359.37 | 62343.0 |
| 2021-10-11 04:30:00 | QQQ | ETF | 359.4 | 359.72 | 359.23 | 359.57 | 21535.0 |
| 2021-10-11 05:00:00 | QQQ | ETF | 359.76 | 360.01 | 359.57 | 359.57 | 15110.0 |
| 2021-10-11 05:30:00 | QQQ | ETF | 359.53 | 359.81 | 359.45 | 359.74 | 62235.0 |
| 2021-10-11 06:00:00 | QQQ | ETF | 359.66 | 359.66 | 359.03 | 359.12 | 38821.0 |
| 2021-10-11 06:30:00 | QQQ | ETF | 359.04 | 359.1 | 358.16 | 358.46 | 134443.0 |
| 2021-10-11 07:00:00 | QQQ | ETF | 358.46 | 359.11 | 358.39 | 358.93 | 93479.0 |
| 2021-10-11 07:30:00 | QQQ | ETF | 358.87 | 358.97 | 358.11 | 358.3 | 118730.0 |
| 2021-10-11 08:00:00 | QQQ | ETF | 358.58 | 361.43 | 358.0 | 358.68 | 263662.0 |
| 2021-10-11 08:30:00 | QQQ | ETF | 358.66 | 359.46 | 358.57 | 359.17 | 168873.0 |
| 2021-10-11 09:00:00 | QQQ | ETF | 359.2 | 359.85 | 359.16 | 359.56 | 324950.0 |
| 2021-10-11 09:30:00 | QQQ | ETF | 359.58 | 362.31 | 358.94 | 362.28 | 4105535.0 |
| 2021-10-11 10:00:00 | QQQ | ETF | 362.2799 | 363.2 | 362.2799 | 363.025 | 2146771.0 |
| 2021-10-11 10:30:00 | QQQ | ETF | 363.04 | 363.115 | 362.01 | 362.38 | 1436386.0 |
| 2021-10-11 11:00:00 | QQQ | ETF | 362.375 | 362.863 | 362.13 | 362.2901 | 1222486.0 |
| 2021-10-11 11:30:00 | QQQ | ETF | 362.3 | 362.87 | 362.22 | 362.35 | 1204145.0 |
| 2021-10-11 12:00:00 | QQQ | ETF | 362.35 | 362.42 | 361.23 | 361.7807 | 2073644.0 |
| 2021-10-11 12:30:00 | QQQ | ETF | 361.78 | 361.8 | 361.11 | 361.68 | 1426487.0 |
> showing 50 of 22,873 rows — these rows as CSV