PREVIEW / etf_1hour / 2022-05-11
file: by_date/etf_1hour/2022/2022-05-11.parquet size: 467 KB rows: 17,094
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-11 04:00:00 | SPY | ETF | 400.57 | 403.65 | 400.53 | 403.41 | 36831.0 |
| 2022-05-11 05:00:00 | SPY | ETF | 403.58 | 403.85 | 403.22 | 403.51 | 57508.0 |
| 2022-05-11 06:00:00 | SPY | ETF | 403.51 | 403.9 | 402.76 | 403.49 | 142455.0 |
| 2022-05-11 07:00:00 | SPY | ETF | 403.51 | 404.54 | 403.37 | 403.85 | 325531.0 |
| 2022-05-11 08:00:00 | SPY | ETF | 403.53 | 404.48 | 394.33 | 395.02 | 4192911.0 |
| 2022-05-11 09:00:00 | SPY | ETF | 395.05 | 403.17 | 394.79 | 402.26 | 15499753.0 |
| 2022-05-11 10:00:00 | SPY | ETF | 402.25 | 404.04 | 399.6 | 401.45 | 15201395.0 |
| 2022-05-11 11:00:00 | SPY | ETF | 401.44 | 403.8 | 399.56 | 401.39 | 9032859.0 |
| 2022-05-11 12:00:00 | SPY | ETF | 401.34 | 401.68 | 396.83 | 396.98 | 9944612.0 |
| 2022-05-11 13:00:00 | SPY | ETF | 396.97 | 397.1 | 393.25 | 393.52 | 13197908.0 |
| 2022-05-11 14:00:00 | SPY | ETF | 393.51 | 398.16 | 393.44 | 395.33 | 13456890.0 |
| 2022-05-11 15:00:00 | SPY | ETF | 395.3 | 395.75 | 391.96 | 392.77 | 22140575.0 |
| 2022-05-11 16:00:00 | SPY | ETF | 392.77 | 394.24 | 392.3101 | 393.79 | 4564286.0 |
| 2022-05-11 17:00:00 | SPY | ETF | 393.91 | 394.128 | 393.17 | 393.5 | 907543.0 |
| 2022-05-11 18:00:00 | SPY | ETF | 393.59 | 393.65 | 392.37 | 393.55 | 225154.0 |
| 2022-05-11 19:00:00 | SPY | ETF | 393.6 | 394.13 | 393.06 | 393.85 | 121831.0 |
| 2022-05-11 04:00:00 | QQQ | ETF | 302.98 | 305.0 | 302.25 | 304.74 | 167576.0 |
| 2022-05-11 05:00:00 | QQQ | ETF | 304.71 | 305.24 | 304.5 | 304.88 | 122269.0 |
| 2022-05-11 06:00:00 | QQQ | ETF | 304.84 | 305.56 | 304.06 | 305.21 | 189539.0 |
| 2022-05-11 07:00:00 | QQQ | ETF | 305.22 | 305.86 | 304.83 | 305.09 | 572552.0 |
| 2022-05-11 08:00:00 | QQQ | ETF | 305.14 | 305.84 | 294.92 | 295.8 | 6216850.0 |
| 2022-05-11 09:00:00 | QQQ | ETF | 295.78 | 304.09 | 295.64 | 301.8598 | 18659692.0 |
| 2022-05-11 10:00:00 | QQQ | ETF | 301.83 | 302.91 | 298.81 | 299.94 | 16142492.0 |
| 2022-05-11 11:00:00 | QQQ | ETF | 299.93 | 301.98 | 297.8 | 299.46 | 9365733.0 |
| 2022-05-11 12:00:00 | QQQ | ETF | 299.46 | 299.99 | 295.57 | 295.8 | 9222455.0 |
| 2022-05-11 13:00:00 | QQQ | ETF | 295.8 | 295.96 | 292.51 | 292.69 | 10592236.0 |
| 2022-05-11 14:00:00 | QQQ | ETF | 292.67 | 296.54 | 292.62 | 293.61 | 10608814.0 |
| 2022-05-11 15:00:00 | QQQ | ETF | 293.6 | 293.85 | 290.95 | 291.83 | 18067891.0 |
| 2022-05-11 16:00:00 | QQQ | ETF | 291.84 | 300.4666 | 291.34 | 292.65 | 2505580.0 |
| 2022-05-11 17:00:00 | QQQ | ETF | 292.77 | 292.77 | 291.84 | 292.18 | 562775.0 |
| 2022-05-11 18:00:00 | QQQ | ETF | 292.29 | 292.55 | 291.35 | 292.39 | 245528.0 |
| 2022-05-11 19:00:00 | QQQ | ETF | 292.42 | 292.88 | 291.9 | 292.6 | 205163.0 |
| 2022-05-11 04:00:00 | IWM | ETF | 175.81 | 177.21 | 175.67 | 177.21 | 13474.0 |
| 2022-05-11 05:00:00 | IWM | ETF | 177.3 | 177.47 | 177.12 | 177.16 | 36284.0 |
| 2022-05-11 06:00:00 | IWM | ETF | 177.15 | 177.43 | 176.85 | 177.3 | 17277.0 |
| 2022-05-11 07:00:00 | IWM | ETF | 177.31 | 177.81 | 177.24 | 177.56 | 48115.0 |
| 2022-05-11 08:00:00 | IWM | ETF | 177.6 | 177.73 | 173.4 | 173.82 | 758319.0 |
| 2022-05-11 09:00:00 | IWM | ETF | 173.82 | 177.09 | 173.68 | 176.69 | 8740264.0 |
| 2022-05-11 10:00:00 | IWM | ETF | 176.69 | 178.19 | 175.53 | 176.5 | 11085320.0 |
| 2022-05-11 11:00:00 | IWM | ETF | 176.5 | 177.55 | 175.13 | 176.36 | 6821838.0 |
| 2022-05-11 12:00:00 | IWM | ETF | 176.37 | 176.37 | 173.22 | 173.34 | 4792450.0 |
| 2022-05-11 13:00:00 | IWM | ETF | 173.35 | 173.515 | 170.99 | 171.205 | 6017620.0 |
| 2022-05-11 14:00:00 | IWM | ETF | 171.22 | 173.5 | 171.19 | 172.32 | 4811612.0 |
| 2022-05-11 15:00:00 | IWM | ETF | 172.28 | 172.46 | 170.3 | 170.65 | 8420774.0 |
| 2022-05-11 16:00:00 | IWM | ETF | 170.6 | 171.6 | 170.46 | 171.41 | 909669.0 |
| 2022-05-11 17:00:00 | IWM | ETF | 171.23 | 171.49 | 170.6 | 171.24 | 283006.0 |
| 2022-05-11 18:00:00 | IWM | ETF | 171.24 | 171.36 | 170.69 | 171.32 | 47260.0 |
| 2022-05-11 19:00:00 | IWM | ETF | 171.33 | 171.54 | 171.11 | 171.38 | 60371.0 |
| 2022-05-11 04:00:00 | DIA | ETF | 322.4 | 324.76 | 322.4 | 324.76 | 3858.0 |
| 2022-05-11 05:00:00 | DIA | ETF | 325.04 | 325.09 | 324.64 | 324.71 | 4700.0 |
> showing 50 of 17,094 rows — these rows as CSV