PREVIEW / etf_1hour / 2024-02-07
file: by_date/etf_1hour/2024/2024-02-07.parquet size: 538 KB rows: 19,801
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-02-07 04:00:00 | SPY | ETF | 493.98 | 494.19 | 493.89 | 494.12 | 7608.0 |
| 2024-02-07 05:00:00 | SPY | ETF | 494.07 | 494.18 | 493.5 | 493.71 | 43684.0 |
| 2024-02-07 06:00:00 | SPY | ETF | 493.73 | 494.09 | 493.73 | 493.85 | 41421.0 |
| 2024-02-07 07:00:00 | SPY | ETF | 494.0 | 494.94 | 493.72 | 494.86 | 87306.0 |
| 2024-02-07 08:00:00 | SPY | ETF | 493.82 | 495.75 | 493.7502 | 495.53 | 293374.0 |
| 2024-02-07 09:00:00 | SPY | ETF | 495.56 | 496.44 | 495.36 | 495.89 | 5531075.0 |
| 2024-02-07 10:00:00 | SPY | ETF | 495.87 | 498.04 | 495.502 | 497.26 | 11099602.0 |
| 2024-02-07 11:00:00 | SPY | ETF | 497.25 | 497.86 | 496.83 | 497.5891 | 6090969.0 |
| 2024-02-07 12:00:00 | SPY | ETF | 497.59 | 497.855 | 496.79 | 497.56 | 4516320.0 |
| 2024-02-07 13:00:00 | SPY | ETF | 497.56 | 498.43 | 497.08 | 498.071 | 5804559.0 |
| 2024-02-07 14:00:00 | SPY | ETF | 498.08 | 498.35 | 497.79 | 498.325 | 4173059.0 |
| 2024-02-07 15:00:00 | SPY | ETF | 498.33 | 498.53 | 497.61 | 498.05 | 11293059.0 |
| 2024-02-07 16:00:00 | SPY | ETF | 498.05 | 498.11 | 497.7699 | 498.06 | 2998850.0 |
| 2024-02-07 17:00:00 | SPY | ETF | 498.06 | 498.11 | 497.99 | 498.01 | 58204.0 |
| 2024-02-07 18:00:00 | SPY | ETF | 498.01 | 498.06 | 497.7 | 497.87 | 91309.0 |
| 2024-02-07 19:00:00 | SPY | ETF | 497.88 | 497.92 | 497.7001 | 497.76 | 40233.0 |
| 2024-02-07 04:00:00 | QQQ | ETF | 427.57 | 428.09 | 427.41 | 428.09 | 40544.0 |
| 2024-02-07 05:00:00 | QQQ | ETF | 427.98 | 428.24 | 427.55 | 427.78 | 29208.0 |
| 2024-02-07 06:00:00 | QQQ | ETF | 427.67 | 428.4 | 427.66 | 428.15 | 59799.0 |
| 2024-02-07 07:00:00 | QQQ | ETF | 428.18 | 428.88 | 427.56 | 428.85 | 85896.0 |
| 2024-02-07 08:00:00 | QQQ | ETF | 427.9685 | 429.75 | 427.01 | 429.5 | 211290.0 |
| 2024-02-07 09:00:00 | QQQ | ETF | 429.51 | 430.51 | 429.09 | 429.755 | 4159077.0 |
| 2024-02-07 10:00:00 | QQQ | ETF | 429.73 | 432.83 | 429.255 | 431.8399 | 6942106.0 |
| 2024-02-07 11:00:00 | QQQ | ETF | 431.83 | 432.3 | 431.09 | 432.08 | 3904510.0 |
| 2024-02-07 12:00:00 | QQQ | ETF | 432.0921 | 432.31 | 430.55 | 431.4899 | 3103725.0 |
| 2024-02-07 13:00:00 | QQQ | ETF | 431.49 | 432.46 | 430.77 | 432.27 | 3308126.0 |
| 2024-02-07 14:00:00 | QQQ | ETF | 432.28 | 432.5 | 431.785 | 432.33 | 2239815.0 |
| 2024-02-07 15:00:00 | QQQ | ETF | 432.33 | 432.62 | 431.77 | 432.03 | 4300313.0 |
| 2024-02-07 16:00:00 | QQQ | ETF | 432.02 | 432.48 | 431.85 | 432.39 | 1206303.0 |
| 2024-02-07 17:00:00 | QQQ | ETF | 432.36 | 432.49 | 432.26 | 432.3 | 45149.0 |
| 2024-02-07 18:00:00 | QQQ | ETF | 432.27 | 432.27 | 431.9 | 432.03 | 60012.0 |
| 2024-02-07 19:00:00 | QQQ | ETF | 432.06 | 432.06 | 431.92 | 431.98 | 28139.0 |
| 2024-02-07 04:00:00 | IWM | ETF | 193.5 | 193.5 | 192.55 | 193.02 | 18375.0 |
| 2024-02-07 05:00:00 | IWM | ETF | 193.05 | 193.06 | 192.24 | 192.35 | 20469.0 |
| 2024-02-07 06:00:00 | IWM | ETF | 192.36 | 192.84 | 192.21 | 192.76 | 13822.0 |
| 2024-02-07 07:00:00 | IWM | ETF | 192.76 | 193.75 | 192.35 | 193.54 | 103169.0 |
| 2024-02-07 08:00:00 | IWM | ETF | 192.52 | 194.63 | 192.2996 | 194.12 | 347116.0 |
| 2024-02-07 09:00:00 | IWM | ETF | 194.18 | 194.439 | 192.04 | 192.2 | 4058150.0 |
| 2024-02-07 10:00:00 | IWM | ETF | 192.195 | 193.55 | 192.11 | 192.98 | 4906172.0 |
| 2024-02-07 11:00:00 | IWM | ETF | 192.97 | 193.55 | 192.69 | 192.96 | 2891191.0 |
| 2024-02-07 12:00:00 | IWM | ETF | 192.955 | 193.27 | 192.63 | 193.27 | 2531284.0 |
| 2024-02-07 13:00:00 | IWM | ETF | 193.27 | 194.13 | 193.07 | 193.97 | 3329852.0 |
| 2024-02-07 14:00:00 | IWM | ETF | 193.98 | 194.15 | 193.72 | 194.0 | 1946997.0 |
| 2024-02-07 15:00:00 | IWM | ETF | 193.99 | 194.03 | 193.02 | 193.22 | 5355137.0 |
| 2024-02-07 16:00:00 | IWM | ETF | 193.22 | 193.22 | 192.72 | 192.9 | 1210512.0 |
| 2024-02-07 17:00:00 | IWM | ETF | 192.91 | 193.08 | 192.91 | 193.04 | 27324.0 |
| 2024-02-07 18:00:00 | IWM | ETF | 192.99 | 193.0 | 192.75 | 192.77 | 19775.0 |
| 2024-02-07 19:00:00 | IWM | ETF | 192.86 | 192.89 | 192.61 | 192.67 | 21191.0 |
| 2024-02-07 04:00:00 | DIA | ETF | 385.24 | 385.24 | 385.24 | 385.24 | 103.0 |
| 2024-02-07 06:00:00 | DIA | ETF | 384.85 | 384.85 | 384.72 | 384.72 | 542.0 |
> showing 50 of 19,801 rows — these rows as CSV