PREVIEW / etf_1hour / 2024-06-13
file: by_date/etf_1hour/2024/2024-06-13.parquet size: 542 KB rows: 20,012
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-13 04:00:00 | SPY | ETF | 542.55 | 542.81 | 542.07 | 542.22 | 19321.0 |
| 2024-06-13 05:00:00 | SPY | ETF | 542.53 | 542.53 | 541.55 | 541.61 | 13923.0 |
| 2024-06-13 06:00:00 | SPY | ETF | 541.7 | 541.95 | 541.37 | 541.95 | 23947.0 |
| 2024-06-13 07:00:00 | SPY | ETF | 541.99 | 542.24 | 541.89 | 541.89 | 286081.0 |
| 2024-06-13 08:00:00 | SPY | ETF | 541.9782 | 544.03 | 541.8104 | 542.91 | 618529.0 |
| 2024-06-13 09:00:00 | SPY | ETF | 542.78 | 543.25 | 541.74 | 541.99 | 3635062.0 |
| 2024-06-13 10:00:00 | SPY | ETF | 541.99 | 542.285 | 540.43 | 540.56 | 4345026.0 |
| 2024-06-13 11:00:00 | SPY | ETF | 540.55 | 541.65 | 540.25 | 541.21 | 2495965.0 |
| 2024-06-13 12:00:00 | SPY | ETF | 541.2 | 541.21 | 539.59 | 540.74 | 2839867.0 |
| 2024-06-13 13:00:00 | SPY | ETF | 540.72 | 541.9694 | 540.58 | 541.67 | 2182446.0 |
| 2024-06-13 14:00:00 | SPY | ETF | 541.68 | 542.58 | 541.255 | 542.49 | 2871449.0 |
| 2024-06-13 15:00:00 | SPY | ETF | 542.5 | 543.325 | 542.18 | 542.4 | 7351327.0 |
| 2024-06-13 16:00:00 | SPY | ETF | 542.4 | 543.05 | 542.15 | 542.32 | 4404917.0 |
| 2024-06-13 17:00:00 | SPY | ETF | 542.3 | 542.39 | 542.22 | 542.28 | 24310.0 |
| 2024-06-13 18:00:00 | SPY | ETF | 542.28 | 542.45 | 542.01 | 542.38 | 63182.0 |
| 2024-06-13 19:00:00 | SPY | ETF | 542.45 | 542.53 | 542.25 | 542.5 | 18078.0 |
| 2024-06-13 04:00:00 | QQQ | ETF | 478.2 | 478.28 | 477.5 | 477.76 | 120394.0 |
| 2024-06-13 05:00:00 | QQQ | ETF | 477.82 | 477.93 | 476.5 | 476.72 | 110931.0 |
| 2024-06-13 06:00:00 | QQQ | ETF | 476.77 | 477.22 | 476.54 | 477.22 | 28344.0 |
| 2024-06-13 07:00:00 | QQQ | ETF | 477.18 | 477.52 | 477.0 | 477.1 | 133294.0 |
| 2024-06-13 08:00:00 | QQQ | ETF | 477.3089 | 478.95 | 473.795 | 477.52 | 825751.0 |
| 2024-06-13 09:00:00 | QQQ | ETF | 477.5 | 478.39 | 477.2 | 477.59 | 3364735.0 |
| 2024-06-13 10:00:00 | QQQ | ETF | 477.61 | 478.06 | 475.25 | 475.75 | 3699843.0 |
| 2024-06-13 11:00:00 | QQQ | ETF | 475.7901 | 477.07 | 475.51 | 476.5325 | 1842895.0 |
| 2024-06-13 12:00:00 | QQQ | ETF | 476.54 | 476.5593 | 474.42 | 475.48 | 2659812.0 |
| 2024-06-13 13:00:00 | QQQ | ETF | 475.48 | 476.5 | 475.35 | 476.0799 | 1447312.0 |
| 2024-06-13 14:00:00 | QQQ | ETF | 476.11 | 476.9899 | 475.61 | 476.86 | 1322800.0 |
| 2024-06-13 15:00:00 | QQQ | ETF | 476.84 | 477.64 | 476.49 | 476.71 | 3445792.0 |
| 2024-06-13 16:00:00 | QQQ | ETF | 476.69 | 477.77 | 476.62 | 477.01 | 1090418.0 |
| 2024-06-13 17:00:00 | QQQ | ETF | 477.02 | 477.03 | 476.6705 | 476.7 | 23755.0 |
| 2024-06-13 18:00:00 | QQQ | ETF | 476.8 | 477.19 | 476.66 | 477.05 | 68167.0 |
| 2024-06-13 19:00:00 | QQQ | ETF | 477.13 | 477.3586 | 476.9 | 477.24 | 41598.0 |
| 2024-06-13 04:00:00 | IWM | ETF | 203.15 | 203.22 | 202.74 | 202.86 | 23156.0 |
| 2024-06-13 05:00:00 | IWM | ETF | 202.94 | 203.3 | 202.73 | 202.9 | 40270.0 |
| 2024-06-13 06:00:00 | IWM | ETF | 202.89 | 202.91 | 202.3 | 202.63 | 19481.0 |
| 2024-06-13 07:00:00 | IWM | ETF | 202.61 | 203.07 | 202.61 | 202.86 | 57643.0 |
| 2024-06-13 08:00:00 | IWM | ETF | 202.89 | 205.27 | 202.4704 | 203.94 | 942314.0 |
| 2024-06-13 09:00:00 | IWM | ETF | 203.81 | 203.93 | 201.97 | 202.06 | 3133337.0 |
| 2024-06-13 10:00:00 | IWM | ETF | 202.065 | 202.34 | 201.0299 | 201.48 | 3889109.0 |
| 2024-06-13 11:00:00 | IWM | ETF | 201.505 | 201.55 | 200.675 | 201.015 | 1910087.0 |
| 2024-06-13 12:00:00 | IWM | ETF | 201.01 | 201.48 | 200.51 | 201.27 | 1999730.0 |
| 2024-06-13 13:00:00 | IWM | ETF | 201.26 | 201.75 | 201.2 | 201.57 | 1736527.0 |
| 2024-06-13 14:00:00 | IWM | ETF | 201.575 | 201.93 | 201.33 | 201.82 | 1311389.0 |
| 2024-06-13 15:00:00 | IWM | ETF | 201.81 | 202.185 | 201.58 | 201.9 | 3995098.0 |
| 2024-06-13 16:00:00 | IWM | ETF | 201.94 | 202.05 | 201.45 | 201.64 | 1908971.0 |
| 2024-06-13 17:00:00 | IWM | ETF | 201.59 | 201.94 | 201.35 | 201.58 | 25205.0 |
| 2024-06-13 18:00:00 | IWM | ETF | 201.52 | 201.66 | 201.35 | 201.65 | 28590.0 |
| 2024-06-13 19:00:00 | IWM | ETF | 201.61 | 201.65 | 201.49 | 201.58 | 37215.0 |
| 2024-06-13 04:00:00 | DIA | ETF | 386.97 | 386.97 | 386.43 | 386.43 | 4702.0 |
| 2024-06-13 05:00:00 | DIA | ETF | 386.66 | 386.78 | 386.47 | 386.52 | 2300.0 |
> showing 50 of 20,012 rows — these rows as CSV