PREVIEW / etf_1hour / 2024-10-16
file: by_date/etf_1hour/2024/2024-10-16.parquet size: 571 KB rows: 21,206
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-10-16 04:00:00 | SPY | ETF | 580.14 | 580.23 | 579.6 | 579.8 | 26623.0 |
| 2024-10-16 05:00:00 | SPY | ETF | 580.0 | 580.17 | 579.8 | 580.04 | 22962.0 |
| 2024-10-16 06:00:00 | SPY | ETF | 580.06 | 580.21 | 579.85 | 580.21 | 24156.0 |
| 2024-10-16 07:00:00 | SPY | ETF | 580.14 | 580.5 | 580.11 | 580.42 | 171811.0 |
| 2024-10-16 08:00:00 | SPY | ETF | 580.1516 | 580.5 | 579.5 | 579.89 | 187694.0 |
| 2024-10-16 09:00:00 | SPY | ETF | 579.92 | 580.25 | 578.96 | 579.15 | 2641511.0 |
| 2024-10-16 10:00:00 | SPY | ETF | 579.1401 | 581.1501 | 579.07 | 580.0999 | 3281625.0 |
| 2024-10-16 11:00:00 | SPY | ETF | 580.12 | 580.9 | 579.78 | 580.24 | 1854088.0 |
| 2024-10-16 12:00:00 | SPY | ETF | 580.235 | 581.4 | 580.2 | 581.39 | 1369858.0 |
| 2024-10-16 13:00:00 | SPY | ETF | 581.4 | 581.69 | 580.935 | 581.635 | 1353021.0 |
| 2024-10-16 14:00:00 | SPY | ETF | 581.63 | 582.83 | 581.48 | 582.4 | 2295250.0 |
| 2024-10-16 15:00:00 | SPY | ETF | 582.42 | 582.65 | 582.1 | 582.24 | 5993274.0 |
| 2024-10-16 16:00:00 | SPY | ETF | 582.24 | 582.3415 | 581.93 | 581.93 | 2666447.0 |
| 2024-10-16 17:00:00 | SPY | ETF | 582.0 | 582.3 | 581.9 | 582.0 | 35944.0 |
| 2024-10-16 18:00:00 | SPY | ETF | 582.0 | 582.04 | 581.73 | 581.86 | 36098.0 |
| 2024-10-16 19:00:00 | SPY | ETF | 581.88 | 581.88 | 581.5 | 581.54 | 23725.0 |
| 2024-10-16 04:00:00 | QQQ | ETF | 491.97 | 492.08 | 490.7 | 491.38 | 42387.0 |
| 2024-10-16 05:00:00 | QQQ | ETF | 491.33 | 491.77 | 491.12 | 491.34 | 33618.0 |
| 2024-10-16 06:00:00 | QQQ | ETF | 491.41 | 491.49 | 491.05 | 491.4 | 25924.0 |
| 2024-10-16 07:00:00 | QQQ | ETF | 491.37 | 491.87 | 491.22 | 491.64 | 57749.0 |
| 2024-10-16 08:00:00 | QQQ | ETF | 491.73 | 492.13 | 490.482 | 491.13 | 472736.0 |
| 2024-10-16 09:00:00 | QQQ | ETF | 491.09 | 491.74 | 487.79 | 487.9999 | 3253184.0 |
| 2024-10-16 10:00:00 | QQQ | ETF | 487.97 | 491.02 | 487.57 | 489.155 | 3496599.0 |
| 2024-10-16 11:00:00 | QQQ | ETF | 489.195 | 490.5 | 488.98 | 489.22 | 1564343.0 |
| 2024-10-16 12:00:00 | QQQ | ETF | 489.2 | 490.7 | 489.12 | 490.645 | 1433677.0 |
| 2024-10-16 13:00:00 | QQQ | ETF | 490.65 | 490.93 | 489.89 | 490.68 | 1261559.0 |
| 2024-10-16 14:00:00 | QQQ | ETF | 490.68 | 491.69 | 490.25 | 491.26 | 1487264.0 |
| 2024-10-16 15:00:00 | QQQ | ETF | 491.26 | 491.48 | 490.57 | 490.93 | 2670555.0 |
| 2024-10-16 16:00:00 | QQQ | ETF | 490.92 | 491.16 | 490.27 | 490.51 | 918357.0 |
| 2024-10-16 17:00:00 | QQQ | ETF | 490.51 | 490.6 | 490.479 | 490.51 | 4279.0 |
| 2024-10-16 18:00:00 | QQQ | ETF | 490.55 | 490.61 | 490.2725 | 490.56 | 29049.0 |
| 2024-10-16 19:00:00 | QQQ | ETF | 490.55 | 490.55 | 490.12 | 490.15 | 66518.0 |
| 2024-10-16 04:00:00 | IWM | ETF | 223.6 | 223.93 | 223.54 | 223.72 | 17641.0 |
| 2024-10-16 05:00:00 | IWM | ETF | 223.74 | 224.16 | 223.73 | 223.88 | 6874.0 |
| 2024-10-16 06:00:00 | IWM | ETF | 224.03 | 224.43 | 223.96 | 224.43 | 42661.0 |
| 2024-10-16 07:00:00 | IWM | ETF | 224.5 | 225.1 | 224.36 | 225.03 | 64714.0 |
| 2024-10-16 08:00:00 | IWM | ETF | 224.45 | 225.27 | 223.5 | 224.75 | 128424.0 |
| 2024-10-16 09:00:00 | IWM | ETF | 224.75 | 225.29 | 224.39 | 225.27 | 2788247.0 |
| 2024-10-16 10:00:00 | IWM | ETF | 225.26 | 226.915 | 225.22 | 226.6 | 5683312.0 |
| 2024-10-16 11:00:00 | IWM | ETF | 226.6 | 226.82 | 226.11 | 226.6609 | 1854634.0 |
| 2024-10-16 12:00:00 | IWM | ETF | 226.655 | 226.97 | 226.505 | 226.615 | 1400927.0 |
| 2024-10-16 13:00:00 | IWM | ETF | 226.62 | 226.86 | 226.17 | 226.82 | 1553929.0 |
| 2024-10-16 14:00:00 | IWM | ETF | 226.83 | 227.17 | 226.42 | 226.545 | 1746125.0 |
| 2024-10-16 15:00:00 | IWM | ETF | 226.54 | 227.03 | 226.41 | 226.72 | 3302944.0 |
| 2024-10-16 16:00:00 | IWM | ETF | 226.74 | 226.97 | 226.62 | 226.72 | 1056164.0 |
| 2024-10-16 17:00:00 | IWM | ETF | 226.79 | 226.95 | 226.78 | 226.8 | 12198.0 |
| 2024-10-16 18:00:00 | IWM | ETF | 226.8 | 226.87 | 226.69 | 226.83 | 16953.0 |
| 2024-10-16 19:00:00 | IWM | ETF | 226.79 | 226.79 | 226.68 | 226.7 | 12667.0 |
| 2024-10-16 04:00:00 | DIA | ETF | 427.33 | 427.34 | 427.21 | 427.21 | 946.0 |
| 2024-10-16 05:00:00 | DIA | ETF | 427.31 | 427.38 | 427.28 | 427.38 | 834.0 |
> showing 50 of 21,206 rows — these rows as CSV