PREVIEW / etf_30min / 2021-03-11
file: by_date/etf_30min/2021/2021-03-11.parquet size: 646 KB rows: 24,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-03-11 04:00:00 | SPY | ETF | 392.0 | 392.64 | 391.52 | 392.56 | 41495.0 |
| 2021-03-11 04:30:00 | SPY | ETF | 392.27 | 392.44 | 392.25 | 392.25 | 4400.0 |
| 2021-03-11 05:00:00 | SPY | ETF | 392.3 | 392.37 | 392.08 | 392.25 | 20198.0 |
| 2021-03-11 05:30:00 | SPY | ETF | 392.19 | 392.67 | 392.15 | 392.52 | 16350.0 |
| 2021-03-11 06:00:00 | SPY | ETF | 392.5 | 392.5 | 392.05 | 392.09 | 15296.0 |
| 2021-03-11 06:30:00 | SPY | ETF | 392.07 | 392.28 | 391.95 | 392.0 | 16161.0 |
| 2021-03-11 07:00:00 | SPY | ETF | 391.98 | 392.21 | 391.74 | 392.15 | 183381.0 |
| 2021-03-11 07:30:00 | SPY | ETF | 392.2 | 392.5 | 391.96 | 392.23 | 125743.0 |
| 2021-03-11 08:00:00 | SPY | ETF | 392.3804 | 392.46 | 391.71 | 392.13 | 127345.0 |
| 2021-03-11 08:30:00 | SPY | ETF | 392.11 | 392.2 | 391.58 | 391.86 | 121995.0 |
| 2021-03-11 09:00:00 | SPY | ETF | 391.83 | 392.29 | 391.73 | 392.23 | 186433.0 |
| 2021-03-11 09:30:00 | SPY | ETF | 392.22 | 392.985 | 391.74 | 392.949 | 7887619.0 |
| 2021-03-11 10:00:00 | SPY | ETF | 392.95 | 393.25 | 391.97 | 392.97 | 4372864.0 |
| 2021-03-11 10:30:00 | SPY | ETF | 392.965 | 394.14 | 392.92 | 394.05 | 4899127.0 |
| 2021-03-11 11:00:00 | SPY | ETF | 394.05 | 395.03 | 394.05 | 394.7895 | 4929029.0 |
| 2021-03-11 11:30:00 | SPY | ETF | 394.775 | 395.25 | 394.625 | 394.82 | 3631336.0 |
| 2021-03-11 12:00:00 | SPY | ETF | 394.82 | 395.41 | 394.7 | 394.95 | 2939872.0 |
| 2021-03-11 12:30:00 | SPY | ETF | 394.9599 | 395.15 | 394.54 | 394.915 | 2385270.0 |
| 2021-03-11 13:00:00 | SPY | ETF | 394.9119 | 395.65 | 394.69 | 394.815 | 4082388.0 |
| 2021-03-11 13:30:00 | SPY | ETF | 394.835 | 395.07 | 394.37 | 394.57 | 3192009.0 |
| 2021-03-11 14:00:00 | SPY | ETF | 394.56 | 395.135 | 394.56 | 394.9519 | 2378055.0 |
| 2021-03-11 14:30:00 | SPY | ETF | 394.96 | 395.04 | 394.06 | 394.07 | 2976195.0 |
| 2021-03-11 15:00:00 | SPY | ETF | 394.07 | 394.25 | 393.79 | 394.14 | 3775704.0 |
| 2021-03-11 15:30:00 | SPY | ETF | 394.13 | 394.15 | 393.28 | 393.5 | 11051961.0 |
| 2021-03-11 16:00:00 | SPY | ETF | 393.48 | 393.6 | 393.3 | 393.4 | 3587452.0 |
| 2021-03-11 16:30:00 | SPY | ETF | 393.46 | 393.53 | 393.15 | 393.37 | 280701.0 |
| 2021-03-11 17:00:00 | SPY | ETF | 393.41 | 393.45 | 393.3 | 393.4 | 34383.0 |
| 2021-03-11 17:30:00 | SPY | ETF | 393.4 | 393.59 | 393.38 | 393.58 | 453816.0 |
| 2021-03-11 18:00:00 | SPY | ETF | 393.54 | 394.1 | 393.49 | 394.1 | 104803.0 |
| 2021-03-11 18:30:00 | SPY | ETF | 393.53 | 394.37 | 393.53 | 393.96 | 86421.0 |
| 2021-03-11 19:00:00 | SPY | ETF | 393.91 | 394.36 | 393.84 | 394.0001 | 42357.0 |
| 2021-03-11 19:30:00 | SPY | ETF | 394.0 | 394.3 | 393.86 | 394.02 | 36801.0 |
| 2021-03-11 04:00:00 | QQQ | ETF | 315.94 | 316.9 | 315.94 | 316.48 | 81770.0 |
| 2021-03-11 04:30:00 | QQQ | ETF | 316.43 | 316.76 | 316.24 | 316.53 | 30529.0 |
| 2021-03-11 05:00:00 | QQQ | ETF | 316.53 | 316.65 | 316.0 | 316.32 | 30617.0 |
| 2021-03-11 05:30:00 | QQQ | ETF | 316.34 | 317.27 | 316.14 | 316.95 | 66132.0 |
| 2021-03-11 06:00:00 | QQQ | ETF | 316.89 | 317.04 | 316.12 | 316.37 | 50564.0 |
| 2021-03-11 06:30:00 | QQQ | ETF | 316.35 | 316.78 | 316.27 | 316.3 | 66176.0 |
| 2021-03-11 07:00:00 | QQQ | ETF | 316.31 | 316.39 | 315.61 | 316.22 | 195333.0 |
| 2021-03-11 07:30:00 | QQQ | ETF | 316.25 | 317.22 | 315.85 | 316.75 | 445338.0 |
| 2021-03-11 08:00:00 | QQQ | ETF | 316.8804 | 317.17 | 310.88 | 316.52 | 373794.0 |
| 2021-03-11 08:30:00 | QQQ | ETF | 316.391 | 316.45 | 315.47 | 315.96 | 308900.0 |
| 2021-03-11 09:00:00 | QQQ | ETF | 315.94 | 316.6 | 315.34 | 315.76 | 342451.0 |
| 2021-03-11 09:30:00 | QQQ | ETF | 315.76 | 317.13 | 315.3 | 316.13 | 7576028.0 |
| 2021-03-11 10:00:00 | QQQ | ETF | 316.125 | 317.1 | 314.85 | 315.79 | 3866586.0 |
| 2021-03-11 10:30:00 | QQQ | ETF | 315.82 | 317.64 | 315.82 | 317.55 | 3384193.0 |
| 2021-03-11 11:00:00 | QQQ | ETF | 317.55 | 318.5 | 317.55 | 318.235 | 3069544.0 |
| 2021-03-11 11:30:00 | QQQ | ETF | 318.23 | 319.07 | 318.0407 | 318.64 | 2750596.0 |
| 2021-03-11 12:00:00 | QQQ | ETF | 318.6701 | 319.29 | 318.28 | 318.795 | 1842086.0 |
| 2021-03-11 12:30:00 | QQQ | ETF | 318.81 | 319.03 | 318.39 | 318.77 | 1435332.0 |
> showing 50 of 24,581 rows — these rows as CSV