PREVIEW / etf_1hour / 2024-03-18
file: by_date/etf_1hour/2024/2024-03-18.parquet size: 542 KB rows: 20,050
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-03-18 04:00:00 | SPY | ETF | 511.41 | 511.7 | 510.76 | 511.7 | 7320.0 |
| 2024-03-18 05:00:00 | SPY | ETF | 511.81 | 511.89 | 511.35 | 511.58 | 4812.0 |
| 2024-03-18 06:00:00 | SPY | ETF | 511.56 | 511.91 | 511.45 | 511.77 | 10553.0 |
| 2024-03-18 07:00:00 | SPY | ETF | 511.77 | 513.54 | 511.47 | 513.34 | 249916.0 |
| 2024-03-18 08:00:00 | SPY | ETF | 512.07 | 513.99 | 509.83 | 513.49 | 437840.0 |
| 2024-03-18 09:00:00 | SPY | ETF | 513.52 | 514.83 | 513.26 | 513.835 | 7672399.0 |
| 2024-03-18 10:00:00 | SPY | ETF | 513.84 | 515.48 | 513.81 | 515.14 | 6869558.0 |
| 2024-03-18 11:00:00 | SPY | ETF | 515.14 | 515.225 | 513.905 | 514.225 | 4818290.0 |
| 2024-03-18 12:00:00 | SPY | ETF | 514.22 | 514.515 | 513.47 | 513.5134 | 4041943.0 |
| 2024-03-18 13:00:00 | SPY | ETF | 513.52 | 514.25 | 513.2901 | 513.8 | 4362486.0 |
| 2024-03-18 14:00:00 | SPY | ETF | 513.81 | 514.4 | 513.21 | 513.79 | 4965013.0 |
| 2024-03-18 15:00:00 | SPY | ETF | 513.79 | 514.145 | 512.44 | 512.87 | 17990910.0 |
| 2024-03-18 16:00:00 | SPY | ETF | 512.86 | 513.15 | 512.58 | 512.9 | 5121511.0 |
| 2024-03-18 17:00:00 | SPY | ETF | 512.98 | 513.05 | 512.4 | 512.8 | 89735.0 |
| 2024-03-18 18:00:00 | SPY | ETF | 512.9 | 513.04 | 512.24 | 512.3 | 191656.0 |
| 2024-03-18 19:00:00 | SPY | ETF | 512.26 | 512.5099 | 512.1 | 512.47 | 51250.0 |
| 2024-03-18 04:00:00 | QQQ | ETF | 435.12 | 436.53 | 435.0 | 436.5 | 56260.0 |
| 2024-03-18 05:00:00 | QQQ | ETF | 436.5 | 436.71 | 436.04 | 436.25 | 20524.0 |
| 2024-03-18 06:00:00 | QQQ | ETF | 436.18 | 436.91 | 436.18 | 436.74 | 62845.0 |
| 2024-03-18 07:00:00 | QQQ | ETF | 436.75 | 438.38 | 436.57 | 438.31 | 182302.0 |
| 2024-03-18 08:00:00 | QQQ | ETF | 436.57 | 438.87 | 433.614 | 438.51 | 360957.0 |
| 2024-03-18 09:00:00 | QQQ | ETF | 438.53 | 440.58 | 438.4 | 438.82 | 6958175.0 |
| 2024-03-18 10:00:00 | QQQ | ETF | 438.83 | 441.04 | 438.78 | 440.48 | 5527740.0 |
| 2024-03-18 11:00:00 | QQQ | ETF | 440.5 | 440.67 | 438.58 | 439.02 | 3774642.0 |
| 2024-03-18 12:00:00 | QQQ | ETF | 439.02 | 439.48 | 437.845 | 437.92 | 3012468.0 |
| 2024-03-18 13:00:00 | QQQ | ETF | 437.93 | 438.95 | 437.61 | 438.5 | 2649003.0 |
| 2024-03-18 14:00:00 | QQQ | ETF | 438.51 | 439.42 | 438.08 | 438.63 | 2572103.0 |
| 2024-03-18 15:00:00 | QQQ | ETF | 438.65 | 439.09 | 437.24 | 437.47 | 5313424.0 |
| 2024-03-18 16:00:00 | QQQ | ETF | 437.48 | 437.9 | 436.85 | 437.43 | 1615225.0 |
| 2024-03-18 17:00:00 | QQQ | ETF | 437.36 | 437.47 | 436.8 | 437.0 | 263761.0 |
| 2024-03-18 18:00:00 | QQQ | ETF | 437.04 | 437.48 | 436.271 | 436.4 | 611995.0 |
| 2024-03-18 19:00:00 | QQQ | ETF | 436.38 | 436.6404 | 436.18 | 436.57 | 63058.0 |
| 2024-03-18 04:00:00 | IWM | ETF | 202.69 | 202.74 | 202.42 | 202.74 | 12817.0 |
| 2024-03-18 05:00:00 | IWM | ETF | 202.85 | 202.93 | 202.68 | 202.78 | 2648.0 |
| 2024-03-18 06:00:00 | IWM | ETF | 202.46 | 202.51 | 202.37 | 202.48 | 8634.0 |
| 2024-03-18 07:00:00 | IWM | ETF | 202.42 | 203.54 | 202.4 | 203.41 | 88675.0 |
| 2024-03-18 08:00:00 | IWM | ETF | 203.4 | 203.7 | 202.42 | 203.14 | 106678.0 |
| 2024-03-18 09:00:00 | IWM | ETF | 203.19 | 203.2 | 201.42 | 201.825 | 3906062.0 |
| 2024-03-18 10:00:00 | IWM | ETF | 201.83 | 202.78 | 201.45 | 202.7415 | 2893045.0 |
| 2024-03-18 11:00:00 | IWM | ETF | 202.74 | 202.78 | 201.7598 | 202.03 | 2303333.0 |
| 2024-03-18 12:00:00 | IWM | ETF | 202.05 | 202.3151 | 201.63 | 201.69 | 1645950.0 |
| 2024-03-18 13:00:00 | IWM | ETF | 201.69 | 202.095 | 201.59 | 202.07 | 1980838.0 |
| 2024-03-18 14:00:00 | IWM | ETF | 202.08 | 202.46 | 201.88 | 202.05 | 2093097.0 |
| 2024-03-18 15:00:00 | IWM | ETF | 202.045 | 202.1 | 200.905 | 201.2 | 4433278.0 |
| 2024-03-18 16:00:00 | IWM | ETF | 201.25 | 201.25 | 200.94 | 201.14 | 3836262.0 |
| 2024-03-18 17:00:00 | IWM | ETF | 201.15 | 201.15 | 201.0 | 201.01 | 19707.0 |
| 2024-03-18 18:00:00 | IWM | ETF | 201.1 | 201.25 | 200.96 | 201.0401 | 1421538.0 |
| 2024-03-18 19:00:00 | IWM | ETF | 201.08 | 201.1 | 200.96 | 201.05 | 12061.0 |
| 2024-03-18 04:00:00 | DIA | ETF | 386.97 | 387.05 | 386.96 | 387.05 | 300.0 |
| 2024-03-18 05:00:00 | DIA | ETF | 387.15 | 387.15 | 386.78 | 386.78 | 200.0 |
> showing 50 of 20,050 rows — these rows as CSV