PREVIEW / etf_30min / 2021-05-21
file: by_date/etf_30min/2021/2021-05-21.parquet size: 587 KB rows: 22,442
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-05-21 04:00:00 | SPY | ETF | 415.85 | 416.02 | 415.36 | 415.54 | 6069.0 |
| 2021-05-21 04:30:00 | SPY | ETF | 415.6 | 415.75 | 415.56 | 415.75 | 600.0 |
| 2021-05-21 05:00:00 | SPY | ETF | 415.86 | 416.23 | 415.86 | 416.03 | 14750.0 |
| 2021-05-21 05:30:00 | SPY | ETF | 415.93 | 416.4 | 415.93 | 416.2 | 10552.0 |
| 2021-05-21 06:00:00 | SPY | ETF | 416.1 | 416.5 | 416.1 | 416.5 | 16990.0 |
| 2021-05-21 06:30:00 | SPY | ETF | 416.4 | 416.43 | 416.02 | 416.02 | 5443.0 |
| 2021-05-21 07:00:00 | SPY | ETF | 416.12 | 416.67 | 416.12 | 416.67 | 84216.0 |
| 2021-05-21 07:30:00 | SPY | ETF | 416.73 | 417.03 | 416.7 | 416.9 | 73679.0 |
| 2021-05-21 08:00:00 | SPY | ETF | 416.2599 | 417.0 | 416.1504 | 416.75 | 117093.0 |
| 2021-05-21 08:30:00 | SPY | ETF | 416.76 | 416.76 | 416.48 | 416.53 | 92983.0 |
| 2021-05-21 09:00:00 | SPY | ETF | 416.58 | 417.19 | 416.49 | 416.85 | 322081.0 |
| 2021-05-21 09:30:00 | SPY | ETF | 416.87 | 418.19 | 416.83 | 418.17 | 7073207.0 |
| 2021-05-21 10:00:00 | SPY | ETF | 418.18 | 418.2 | 416.77 | 416.79 | 5169326.0 |
| 2021-05-21 10:30:00 | SPY | ETF | 416.79 | 417.35 | 416.34 | 417.06 | 3734748.0 |
| 2021-05-21 11:00:00 | SPY | ETF | 417.07 | 417.27 | 416.23 | 416.3 | 2230348.0 |
| 2021-05-21 11:30:00 | SPY | ETF | 416.3 | 416.76 | 415.85 | 415.9596 | 2602974.0 |
| 2021-05-21 12:00:00 | SPY | ETF | 415.95 | 416.22 | 415.12 | 415.5 | 3691354.0 |
| 2021-05-21 12:30:00 | SPY | ETF | 415.49 | 415.685 | 414.45 | 414.89 | 2981833.0 |
| 2021-05-21 13:00:00 | SPY | ETF | 414.88 | 415.5 | 414.81 | 415.44 | 2406920.0 |
| 2021-05-21 13:30:00 | SPY | ETF | 415.45 | 415.94 | 415.4 | 415.72 | 1579911.0 |
| 2021-05-21 14:00:00 | SPY | ETF | 415.73 | 416.19 | 415.35 | 415.4643 | 2299772.0 |
| 2021-05-21 14:30:00 | SPY | ETF | 415.47 | 415.83 | 414.96 | 415.735 | 2526567.0 |
| 2021-05-21 15:00:00 | SPY | ETF | 415.735 | 416.25 | 415.3211 | 416.005 | 3580043.0 |
| 2021-05-21 15:30:00 | SPY | ETF | 416.01 | 416.02 | 414.7 | 414.95 | 10813368.0 |
| 2021-05-21 16:00:00 | SPY | ETF | 414.9501 | 415.93 | 414.9035 | 415.29 | 2613616.0 |
| 2021-05-21 16:30:00 | SPY | ETF | 415.29 | 415.42 | 414.94 | 415.41 | 610545.0 |
| 2021-05-21 17:00:00 | SPY | ETF | 415.42 | 415.55 | 415.25 | 415.5 | 43905.0 |
| 2021-05-21 17:30:00 | SPY | ETF | 415.42 | 415.54 | 415.4 | 415.45 | 12434.0 |
| 2021-05-21 18:00:00 | SPY | ETF | 415.51 | 415.68 | 415.43 | 415.65 | 21305.0 |
| 2021-05-21 18:30:00 | SPY | ETF | 414.94 | 415.65 | 414.94 | 415.54 | 17858.0 |
| 2021-05-21 19:00:00 | SPY | ETF | 415.54 | 415.56 | 415.41 | 415.49 | 7997.0 |
| 2021-05-21 19:30:00 | SPY | ETF | 415.44 | 415.5 | 415.4 | 415.44 | 17317.0 |
| 2021-05-21 04:00:00 | QQQ | ETF | 329.74 | 329.85 | 329.29 | 329.44 | 16948.0 |
| 2021-05-21 04:30:00 | QQQ | ETF | 329.5 | 329.5 | 329.29 | 329.47 | 10048.0 |
| 2021-05-21 05:00:00 | QQQ | ETF | 329.64 | 329.81 | 329.56 | 329.66 | 8786.0 |
| 2021-05-21 05:30:00 | QQQ | ETF | 329.63 | 329.93 | 329.53 | 329.6 | 23738.0 |
| 2021-05-21 06:00:00 | QQQ | ETF | 329.54 | 329.78 | 329.41 | 329.78 | 20352.0 |
| 2021-05-21 06:30:00 | QQQ | ETF | 329.75 | 329.75 | 329.4 | 329.48 | 19801.0 |
| 2021-05-21 07:00:00 | QQQ | ETF | 329.48 | 330.05 | 329.48 | 330.05 | 82137.0 |
| 2021-05-21 07:30:00 | QQQ | ETF | 330.05 | 330.34 | 329.97 | 330.18 | 161144.0 |
| 2021-05-21 08:00:00 | QQQ | ETF | 330.19 | 330.3096 | 329.37 | 330.12 | 103646.0 |
| 2021-05-21 08:30:00 | QQQ | ETF | 330.12 | 330.14 | 329.59 | 329.76 | 132282.0 |
| 2021-05-21 09:00:00 | QQQ | ETF | 329.78 | 330.69 | 329.78 | 330.5 | 611690.0 |
| 2021-05-21 09:30:00 | QQQ | ETF | 330.48 | 330.86 | 328.805 | 330.2298 | 4299171.0 |
| 2021-05-21 10:00:00 | QQQ | ETF | 330.23 | 330.36 | 328.61 | 328.71 | 3314383.0 |
| 2021-05-21 10:30:00 | QQQ | ETF | 328.73 | 329.35 | 327.82 | 328.485 | 2716797.0 |
| 2021-05-21 11:00:00 | QQQ | ETF | 328.5 | 328.81 | 327.63 | 327.7 | 1585864.0 |
| 2021-05-21 11:30:00 | QQQ | ETF | 327.71 | 328.28 | 327.109 | 327.23 | 2386068.0 |
| 2021-05-21 12:00:00 | QQQ | ETF | 327.23 | 327.615 | 326.87 | 327.37 | 2729300.0 |
| 2021-05-21 12:30:00 | QQQ | ETF | 327.36 | 327.73 | 326.71 | 327.3 | 1703115.0 |
> showing 50 of 22,442 rows — these rows as CSV