PREVIEW / etf_1hour / 2024-06-20
file: by_date/etf_1hour/2024/2024-06-20.parquet size: 561 KB rows: 21,057
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-20 04:00:00 | SPY | ETF | 550.12 | 550.54 | 549.52 | 550.51 | 15588.0 |
| 2024-06-20 05:00:00 | SPY | ETF | 550.51 | 550.59 | 550.32 | 550.59 | 8731.0 |
| 2024-06-20 06:00:00 | SPY | ETF | 550.41 | 550.73 | 550.41 | 550.6 | 4052.0 |
| 2024-06-20 07:00:00 | SPY | ETF | 550.43 | 550.77 | 550.16 | 550.261 | 77696.0 |
| 2024-06-20 08:00:00 | SPY | ETF | 550.69 | 551.12 | 549.48 | 549.6 | 202206.0 |
| 2024-06-20 09:00:00 | SPY | ETF | 549.56 | 550.12 | 548.81 | 549.61 | 2753166.0 |
| 2024-06-20 10:00:00 | SPY | ETF | 549.6 | 549.82 | 548.4 | 549.23 | 3740873.0 |
| 2024-06-20 11:00:00 | SPY | ETF | 549.23 | 549.53 | 548.32 | 548.36 | 2728876.0 |
| 2024-06-20 12:00:00 | SPY | ETF | 548.34 | 548.66 | 545.99 | 547.28 | 4896680.0 |
| 2024-06-20 13:00:00 | SPY | ETF | 547.27 | 547.27 | 545.18 | 547.02 | 4415429.0 |
| 2024-06-20 14:00:00 | SPY | ETF | 547.03 | 548.19 | 546.95 | 547.18 | 5648228.0 |
| 2024-06-20 15:00:00 | SPY | ETF | 547.18 | 547.76 | 545.77 | 546.95 | 10963703.0 |
| 2024-06-20 16:00:00 | SPY | ETF | 546.95 | 547.08 | 546.44 | 546.92 | 3140261.0 |
| 2024-06-20 17:00:00 | SPY | ETF | 546.93 | 546.93 | 546.75 | 546.85 | 75271.0 |
| 2024-06-20 18:00:00 | SPY | ETF | 546.86 | 547.13 | 546.85 | 547.0 | 26244.0 |
| 2024-06-20 19:00:00 | SPY | ETF | 547.04 | 547.24 | 546.97 | 547.18 | 43572.0 |
| 2024-06-20 20:00:00 | SPY | ETF | 547.17 | 547.17 | 547.17 | 547.17 | 1000.0 |
| 2024-06-20 04:00:00 | QQQ | ETF | 487.71 | 488.66 | 487.71 | 488.35 | 77394.0 |
| 2024-06-20 05:00:00 | QQQ | ETF | 488.34 | 488.38 | 487.88 | 488.23 | 33321.0 |
| 2024-06-20 06:00:00 | QQQ | ETF | 488.16 | 488.49 | 487.92 | 488.22 | 65870.0 |
| 2024-06-20 07:00:00 | QQQ | ETF | 488.09 | 488.34 | 487.5 | 487.61 | 94390.0 |
| 2024-06-20 08:00:00 | QQQ | ETF | 487.61 | 489.07 | 485.573 | 486.94 | 221044.0 |
| 2024-06-20 09:00:00 | QQQ | ETF | 486.93 | 486.99 | 485.27 | 486.15 | 2648227.0 |
| 2024-06-20 10:00:00 | QQQ | ETF | 486.1709 | 486.31 | 483.37 | 485.73 | 3584711.0 |
| 2024-06-20 11:00:00 | QQQ | ETF | 485.74 | 486.035 | 484.31 | 484.485 | 1727902.0 |
| 2024-06-20 12:00:00 | QQQ | ETF | 484.47 | 484.815 | 480.9009 | 482.52 | 3454087.0 |
| 2024-06-20 13:00:00 | QQQ | ETF | 482.51 | 482.51 | 479.62 | 481.43 | 2940679.0 |
| 2024-06-20 14:00:00 | QQQ | ETF | 481.43 | 482.549 | 480.88 | 480.9201 | 2538443.0 |
| 2024-06-20 15:00:00 | QQQ | ETF | 480.93 | 482.19 | 479.7 | 481.38 | 6007247.0 |
| 2024-06-20 16:00:00 | QQQ | ETF | 481.37 | 481.85 | 481.19 | 481.85 | 1027065.0 |
| 2024-06-20 17:00:00 | QQQ | ETF | 481.79 | 481.79 | 481.47 | 481.63 | 987856.0 |
| 2024-06-20 18:00:00 | QQQ | ETF | 481.63 | 482.0 | 481.47 | 481.47 | 111658.0 |
| 2024-06-20 19:00:00 | QQQ | ETF | 481.97 | 482.33 | 481.47 | 482.22 | 66252.0 |
| 2024-06-20 04:00:00 | IWM | ETF | 201.2 | 201.45 | 201.15 | 201.37 | 13304.0 |
| 2024-06-20 05:00:00 | IWM | ETF | 201.42 | 201.42 | 201.06 | 201.14 | 4408.0 |
| 2024-06-20 06:00:00 | IWM | ETF | 201.17 | 201.41 | 201.17 | 201.23 | 6148.0 |
| 2024-06-20 07:00:00 | IWM | ETF | 201.14 | 201.43 | 200.84 | 200.88 | 36677.0 |
| 2024-06-20 08:00:00 | IWM | ETF | 201.21 | 201.41 | 200.1 | 200.19 | 235613.0 |
| 2024-06-20 09:00:00 | IWM | ETF | 200.18 | 201.86 | 199.64 | 201.47 | 2578227.0 |
| 2024-06-20 10:00:00 | IWM | ETF | 201.48 | 201.67 | 200.7693 | 201.14 | 2487718.0 |
| 2024-06-20 11:00:00 | IWM | ETF | 201.15 | 201.38 | 200.365 | 200.365 | 1829494.0 |
| 2024-06-20 12:00:00 | IWM | ETF | 200.36 | 200.76 | 199.87 | 200.2375 | 2134791.0 |
| 2024-06-20 13:00:00 | IWM | ETF | 200.23 | 200.23 | 199.22 | 200.075 | 2361164.0 |
| 2024-06-20 14:00:00 | IWM | ETF | 200.08 | 200.57 | 199.92 | 199.92 | 3358325.0 |
| 2024-06-20 15:00:00 | IWM | ETF | 199.92 | 200.02 | 199.445 | 199.87 | 4275678.0 |
| 2024-06-20 16:00:00 | IWM | ETF | 199.9 | 199.93 | 199.58 | 199.83 | 696690.0 |
| 2024-06-20 17:00:00 | IWM | ETF | 199.81 | 199.97 | 199.8 | 199.85 | 17663.0 |
| 2024-06-20 18:00:00 | IWM | ETF | 199.93 | 200.03 | 199.9 | 199.94 | 23566.0 |
| 2024-06-20 19:00:00 | IWM | ETF | 200.02 | 200.07 | 199.93 | 200.05 | 11961.0 |
| 2024-06-20 05:00:00 | DIA | ETF | 389.3 | 389.39 | 389.3 | 389.39 | 393.0 |
> showing 50 of 21,057 rows — these rows as CSV