PREVIEW / etf_1hour / 2024-07-16
file: by_date/etf_1hour/2024/2024-07-16.parquet size: 562 KB rows: 21,074
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-07-16 04:00:00 | SPY | ETF | 561.5 | 561.73 | 560.51 | 561.73 | 42216.0 |
| 2024-07-16 05:00:00 | SPY | ETF | 561.71 | 561.84 | 561.5 | 561.8 | 9125.0 |
| 2024-07-16 06:00:00 | SPY | ETF | 561.8 | 562.32 | 561.8 | 562.21 | 14232.0 |
| 2024-07-16 07:00:00 | SPY | ETF | 562.16 | 562.29 | 561.95 | 562.2 | 60199.0 |
| 2024-07-16 08:00:00 | SPY | ETF | 562.32 | 562.85 | 561.42 | 562.49 | 329562.0 |
| 2024-07-16 09:00:00 | SPY | ETF | 562.34 | 563.61 | 562.2 | 563.08 | 2996568.0 |
| 2024-07-16 10:00:00 | SPY | ETF | 563.075 | 563.71 | 562.1 | 563.23 | 3621364.0 |
| 2024-07-16 11:00:00 | SPY | ETF | 563.24 | 564.47 | 562.8 | 563.13 | 2489723.0 |
| 2024-07-16 12:00:00 | SPY | ETF | 563.105 | 563.59 | 562.23 | 563.54 | 1983364.0 |
| 2024-07-16 13:00:00 | SPY | ETF | 563.54 | 563.54 | 562.48 | 563.2097 | 1730418.0 |
| 2024-07-16 14:00:00 | SPY | ETF | 563.2007 | 564.57 | 562.5901 | 564.54 | 3096439.0 |
| 2024-07-16 15:00:00 | SPY | ETF | 564.555 | 565.16 | 564.0099 | 564.845 | 7398733.0 |
| 2024-07-16 16:00:00 | SPY | ETF | 564.82 | 565.39 | 564.27 | 564.64 | 2449914.0 |
| 2024-07-16 17:00:00 | SPY | ETF | 564.59 | 564.73 | 564.41 | 564.66 | 65051.0 |
| 2024-07-16 18:00:00 | SPY | ETF | 564.64 | 564.85 | 564.53 | 564.77 | 44359.0 |
| 2024-07-16 19:00:00 | SPY | ETF | 564.71 | 564.71 | 564.26 | 564.4 | 32342.0 |
| 2024-07-16 04:00:00 | QQQ | ETF | 497.23 | 497.23 | 495.04 | 496.54 | 51132.0 |
| 2024-07-16 05:00:00 | QQQ | ETF | 496.6 | 496.68 | 495.91 | 496.41 | 21171.0 |
| 2024-07-16 06:00:00 | QQQ | ETF | 496.5 | 497.28 | 496.37 | 496.85 | 39299.0 |
| 2024-07-16 07:00:00 | QQQ | ETF | 496.93 | 497.32 | 496.86 | 497.15 | 46027.0 |
| 2024-07-16 08:00:00 | QQQ | ETF | 497.12 | 497.7 | 495.67 | 497.35 | 193851.0 |
| 2024-07-16 09:00:00 | QQQ | ETF | 497.35 | 498.44 | 495.6 | 495.91 | 2475898.0 |
| 2024-07-16 10:00:00 | QQQ | ETF | 495.94 | 496.26 | 493.64 | 494.98 | 3609694.0 |
| 2024-07-16 11:00:00 | QQQ | ETF | 494.96 | 496.58 | 494.55 | 495.22 | 1814633.0 |
| 2024-07-16 12:00:00 | QQQ | ETF | 495.26 | 495.59 | 493.15 | 495.0916 | 2451961.0 |
| 2024-07-16 13:00:00 | QQQ | ETF | 495.08 | 495.08 | 493.88 | 494.6 | 1335457.0 |
| 2024-07-16 14:00:00 | QQQ | ETF | 494.58 | 496.13 | 493.66 | 496.13 | 2015744.0 |
| 2024-07-16 15:00:00 | QQQ | ETF | 496.12 | 496.73 | 495.41 | 496.38 | 3715032.0 |
| 2024-07-16 16:00:00 | QQQ | ETF | 496.36 | 496.57 | 493.8686 | 496.14 | 682705.0 |
| 2024-07-16 17:00:00 | QQQ | ETF | 496.14 | 496.34 | 496.0 | 496.22 | 71497.0 |
| 2024-07-16 18:00:00 | QQQ | ETF | 496.14 | 496.26 | 495.95 | 496.17 | 51959.0 |
| 2024-07-16 19:00:00 | QQQ | ETF | 496.09 | 496.09 | 495.4 | 495.52 | 63091.0 |
| 2024-07-16 04:00:00 | IWM | ETF | 217.45 | 218.7 | 217.11 | 218.7 | 37395.0 |
| 2024-07-16 05:00:00 | IWM | ETF | 218.66 | 219.37 | 218.52 | 219.05 | 67989.0 |
| 2024-07-16 06:00:00 | IWM | ETF | 219.01 | 219.58 | 219.01 | 219.45 | 100588.0 |
| 2024-07-16 07:00:00 | IWM | ETF | 219.45 | 219.6 | 218.91 | 219.05 | 167673.0 |
| 2024-07-16 08:00:00 | IWM | ETF | 219.44 | 220.08 | 217.23 | 219.2688 | 664405.0 |
| 2024-07-16 09:00:00 | IWM | ETF | 219.23 | 221.78 | 218.98 | 221.78 | 8019403.0 |
| 2024-07-16 10:00:00 | IWM | ETF | 221.775 | 221.87 | 220.52 | 221.7 | 7580610.0 |
| 2024-07-16 11:00:00 | IWM | ETF | 221.69 | 222.61 | 221.52 | 221.769 | 6079868.0 |
| 2024-07-16 12:00:00 | IWM | ETF | 221.76 | 222.67 | 221.73 | 222.29 | 3806655.0 |
| 2024-07-16 13:00:00 | IWM | ETF | 222.29 | 223.335 | 222.23 | 223.0786 | 3993767.0 |
| 2024-07-16 14:00:00 | IWM | ETF | 223.07 | 224.24 | 223.035 | 224.235 | 4659898.0 |
| 2024-07-16 15:00:00 | IWM | ETF | 224.23 | 224.86 | 224.0 | 224.56 | 9539301.0 |
| 2024-07-16 16:00:00 | IWM | ETF | 224.55 | 224.94 | 224.4 | 224.73 | 3610589.0 |
| 2024-07-16 17:00:00 | IWM | ETF | 224.73 | 224.97 | 224.6 | 224.87 | 393064.0 |
| 2024-07-16 18:00:00 | IWM | ETF | 224.8 | 225.07 | 224.36 | 224.5799 | 158078.0 |
| 2024-07-16 19:00:00 | IWM | ETF | 224.55 | 224.62 | 224.15 | 224.36 | 124693.0 |
| 2024-07-16 04:00:00 | DIA | ETF | 402.09 | 402.5 | 401.8 | 402.5 | 898.0 |
| 2024-07-16 05:00:00 | DIA | ETF | 402.73 | 402.73 | 402.26 | 402.26 | 800.0 |
> showing 50 of 21,074 rows — these rows as CSV