PREVIEW / etf_1hour / 2024-08-12
file: by_date/etf_1hour/2024/2024-08-12.parquet size: 550 KB rows: 20,620
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-08-12 04:00:00 | SPY | ETF | 533.5 | 534.45 | 533.49 | 533.49 | 33066.0 |
| 2024-08-12 05:00:00 | SPY | ETF | 533.41 | 533.9 | 533.35 | 533.57 | 9924.0 |
| 2024-08-12 06:00:00 | SPY | ETF | 533.66 | 534.22 | 533.36 | 534.05 | 29281.0 |
| 2024-08-12 07:00:00 | SPY | ETF | 534.14 | 534.74 | 533.54 | 534.5 | 237714.0 |
| 2024-08-12 08:00:00 | SPY | ETF | 533.95 | 535.0 | 532.94 | 534.34 | 292703.0 |
| 2024-08-12 09:00:00 | SPY | ETF | 534.31 | 534.51 | 530.95 | 531.41 | 4361562.0 |
| 2024-08-12 10:00:00 | SPY | ETF | 531.44 | 535.31 | 531.23 | 535.21 | 4598673.0 |
| 2024-08-12 11:00:00 | SPY | ETF | 535.22 | 535.73 | 531.86 | 534.83 | 4663774.0 |
| 2024-08-12 12:00:00 | SPY | ETF | 534.8325 | 535.15 | 532.74 | 532.76 | 2826415.0 |
| 2024-08-12 13:00:00 | SPY | ETF | 532.78 | 534.23 | 531.76 | 532.43 | 2465408.0 |
| 2024-08-12 14:00:00 | SPY | ETF | 532.42 | 533.2599 | 532.18 | 533.2099 | 2632221.0 |
| 2024-08-12 15:00:00 | SPY | ETF | 533.21 | 533.3 | 531.765 | 533.25 | 7520172.0 |
| 2024-08-12 16:00:00 | SPY | ETF | 533.25 | 533.51 | 532.72 | 533.0 | 2386166.0 |
| 2024-08-12 17:00:00 | SPY | ETF | 533.008 | 533.25 | 532.91 | 533.11 | 25138.0 |
| 2024-08-12 18:00:00 | SPY | ETF | 533.25 | 533.44 | 533.059 | 533.18 | 39848.0 |
| 2024-08-12 19:00:00 | SPY | ETF | 533.23 | 533.67 | 533.0 | 533.28 | 131434.0 |
| 2024-08-12 04:00:00 | QQQ | ETF | 452.23 | 452.44 | 451.17 | 451.22 | 24351.0 |
| 2024-08-12 05:00:00 | QQQ | ETF | 451.26 | 451.82 | 451.21 | 451.68 | 5199.0 |
| 2024-08-12 06:00:00 | QQQ | ETF | 451.6 | 452.04 | 451.18 | 451.76 | 10143.0 |
| 2024-08-12 07:00:00 | QQQ | ETF | 451.84 | 452.33 | 451.31 | 451.9 | 108321.0 |
| 2024-08-12 08:00:00 | QQQ | ETF | 451.8614 | 452.55 | 449.46 | 451.86 | 168076.0 |
| 2024-08-12 09:00:00 | QQQ | ETF | 451.87 | 452.14 | 448.5546 | 448.96 | 3406639.0 |
| 2024-08-12 10:00:00 | QQQ | ETF | 448.97 | 453.81 | 448.74 | 453.45 | 3858394.0 |
| 2024-08-12 11:00:00 | QQQ | ETF | 453.45 | 454.37 | 449.85 | 453.285 | 4053467.0 |
| 2024-08-12 12:00:00 | QQQ | ETF | 453.28 | 453.56 | 450.88 | 450.905 | 1965083.0 |
| 2024-08-12 13:00:00 | QQQ | ETF | 450.9225 | 452.53 | 450.05 | 450.82 | 1865778.0 |
| 2024-08-12 14:00:00 | QQQ | ETF | 450.83 | 451.57 | 450.36 | 451.505 | 1327034.0 |
| 2024-08-12 15:00:00 | QQQ | ETF | 451.52 | 451.59 | 449.93 | 451.48 | 3174829.0 |
| 2024-08-12 16:00:00 | QQQ | ETF | 451.49 | 451.77 | 450.85 | 451.11 | 844808.0 |
| 2024-08-12 17:00:00 | QQQ | ETF | 451.15 | 451.34 | 451.0229 | 451.34 | 7005.0 |
| 2024-08-12 18:00:00 | QQQ | ETF | 451.38 | 451.57 | 450.5254 | 451.34 | 35967.0 |
| 2024-08-12 19:00:00 | QQQ | ETF | 451.3799 | 452.0 | 451.2 | 451.66 | 41915.0 |
| 2024-08-12 04:00:00 | IWM | ETF | 206.76 | 206.8 | 205.75 | 205.75 | 29548.0 |
| 2024-08-12 05:00:00 | IWM | ETF | 205.8 | 206.0 | 205.65 | 205.75 | 8945.0 |
| 2024-08-12 06:00:00 | IWM | ETF | 205.75 | 205.94 | 205.5 | 205.73 | 8558.0 |
| 2024-08-12 07:00:00 | IWM | ETF | 205.71 | 206.39 | 205.63 | 206.25 | 46719.0 |
| 2024-08-12 08:00:00 | IWM | ETF | 205.88 | 206.76 | 205.8 | 206.5882 | 75160.0 |
| 2024-08-12 09:00:00 | IWM | ETF | 206.6 | 206.98 | 204.43 | 204.65 | 2529488.0 |
| 2024-08-12 10:00:00 | IWM | ETF | 204.66 | 206.0 | 204.4 | 205.5 | 2421456.0 |
| 2024-08-12 11:00:00 | IWM | ETF | 205.5 | 205.62 | 203.87 | 204.84 | 2326649.0 |
| 2024-08-12 12:00:00 | IWM | ETF | 204.84 | 204.92 | 204.07 | 204.07 | 1197523.0 |
| 2024-08-12 13:00:00 | IWM | ETF | 204.06 | 204.98 | 203.82 | 204.5 | 1181515.0 |
| 2024-08-12 14:00:00 | IWM | ETF | 204.5 | 204.83 | 204.38 | 204.685 | 1049914.0 |
| 2024-08-12 15:00:00 | IWM | ETF | 204.685 | 204.925 | 204.08 | 204.62 | 2954206.0 |
| 2024-08-12 16:00:00 | IWM | ETF | 204.6 | 204.71 | 204.26 | 204.6 | 792629.0 |
| 2024-08-12 17:00:00 | IWM | ETF | 204.62 | 204.75 | 204.56 | 204.66 | 11923.0 |
| 2024-08-12 18:00:00 | IWM | ETF | 204.66 | 204.73 | 204.58 | 204.6 | 19037.0 |
| 2024-08-12 19:00:00 | IWM | ETF | 204.66 | 205.0 | 204.51 | 204.6 | 37459.0 |
| 2024-08-12 04:00:00 | DIA | ETF | 395.15 | 395.15 | 395.09 | 395.09 | 826.0 |
| 2024-08-12 05:00:00 | DIA | ETF | 395.1 | 395.16 | 395.1 | 395.15 | 468.0 |
> showing 50 of 20,620 rows — these rows as CSV