PREVIEW / etf_1hour / 2025-03-27
file: by_date/etf_1hour/2025/2025-03-27.parquet size: 618 KB rows: 23,461
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 |
|---|---|---|---|---|---|---|---|
| 2025-03-27 04:00:00 | SPY | ETF | 568.46 | 569.25 | 567.27 | 569.22 | 71768.0 |
| 2025-03-27 05:00:00 | SPY | ETF | 569.17 | 569.62 | 568.87 | 569.5 | 30587.0 |
| 2025-03-27 06:00:00 | SPY | ETF | 569.53 | 569.82 | 568.4 | 568.44 | 54954.0 |
| 2025-03-27 07:00:00 | SPY | ETF | 568.3 | 568.87 | 567.4 | 568.71 | 153122.0 |
| 2025-03-27 08:00:00 | SPY | ETF | 567.91 | 570.0 | 567.41 | 568.25 | 326551.0 |
| 2025-03-27 09:00:00 | SPY | ETF | 568.0 | 568.43 | 564.94 | 568.33 | 4865168.0 |
| 2025-03-27 10:00:00 | SPY | ETF | 568.31 | 570.8 | 567.53 | 570.8 | 4752756.0 |
| 2025-03-27 11:00:00 | SPY | ETF | 570.8 | 570.9 | 567.85 | 567.94 | 3265427.0 |
| 2025-03-27 12:00:00 | SPY | ETF | 567.96 | 569.9102 | 566.6001 | 566.66 | 2630593.0 |
| 2025-03-27 13:00:00 | SPY | ETF | 566.66 | 568.19 | 566.38 | 566.635 | 2726374.0 |
| 2025-03-27 14:00:00 | SPY | ETF | 566.65 | 569.1875 | 566.56 | 567.56 | 2671508.0 |
| 2025-03-27 15:00:00 | SPY | ETF | 567.54 | 570.03 | 566.72 | 567.0 | 8928663.0 |
| 2025-03-27 16:00:00 | SPY | ETF | 567.02 | 567.51 | 566.92 | 567.0 | 2169983.0 |
| 2025-03-27 17:00:00 | SPY | ETF | 567.14 | 567.14 | 566.871 | 567.05 | 93666.0 |
| 2025-03-27 18:00:00 | SPY | ETF | 566.99 | 567.34 | 566.85 | 566.93 | 78786.0 |
| 2025-03-27 19:00:00 | SPY | ETF | 566.9 | 566.9 | 566.17 | 566.57 | 62283.0 |
| 2025-03-27 04:00:00 | QQQ | ETF | 483.54 | 484.45 | 482.3 | 484.41 | 155359.0 |
| 2025-03-27 05:00:00 | QQQ | ETF | 484.45 | 484.8 | 484.04 | 484.53 | 89387.0 |
| 2025-03-27 06:00:00 | QQQ | ETF | 484.63 | 485.1 | 483.55 | 483.55 | 72621.0 |
| 2025-03-27 07:00:00 | QQQ | ETF | 483.59 | 484.09 | 482.52 | 483.86 | 264745.0 |
| 2025-03-27 08:00:00 | QQQ | ETF | 483.45 | 485.21 | 482.61 | 483.35 | 557167.0 |
| 2025-03-27 09:00:00 | QQQ | ETF | 483.35 | 483.91 | 480.25 | 483.59 | 4704477.0 |
| 2025-03-27 10:00:00 | QQQ | ETF | 483.57 | 486.5799 | 482.41 | 486.35 | 4106104.0 |
| 2025-03-27 11:00:00 | QQQ | ETF | 486.385 | 486.45 | 482.78 | 482.91 | 2931193.0 |
| 2025-03-27 12:00:00 | QQQ | ETF | 482.92 | 485.48 | 481.91 | 481.97 | 2793695.0 |
| 2025-03-27 13:00:00 | QQQ | ETF | 481.96 | 483.43 | 481.79 | 482.09 | 1824406.0 |
| 2025-03-27 14:00:00 | QQQ | ETF | 482.06 | 484.39 | 482.025 | 482.87 | 1960765.0 |
| 2025-03-27 15:00:00 | QQQ | ETF | 482.84 | 484.89 | 481.12 | 481.58 | 3767323.0 |
| 2025-03-27 16:00:00 | QQQ | ETF | 481.6 | 482.17 | 481.48 | 481.66 | 885654.0 |
| 2025-03-27 17:00:00 | QQQ | ETF | 481.62 | 481.85 | 481.6 | 481.7 | 26191.0 |
| 2025-03-27 18:00:00 | QQQ | ETF | 481.7 | 481.95 | 481.37 | 481.54 | 46975.0 |
| 2025-03-27 19:00:00 | QQQ | ETF | 481.6 | 481.6 | 480.65 | 480.91 | 87933.0 |
| 2025-03-27 04:00:00 | IWM | ETF | 205.85 | 206.1 | 205.42 | 206.1 | 65686.0 |
| 2025-03-27 05:00:00 | IWM | ETF | 206.11 | 206.26 | 206.01 | 206.19 | 18347.0 |
| 2025-03-27 06:00:00 | IWM | ETF | 206.28 | 206.28 | 205.81 | 205.87 | 27512.0 |
| 2025-03-27 07:00:00 | IWM | ETF | 205.79 | 206.05 | 205.5 | 205.82 | 55056.0 |
| 2025-03-27 08:00:00 | IWM | ETF | 205.54 | 206.34 | 205.54 | 205.72 | 64844.0 |
| 2025-03-27 09:00:00 | IWM | ETF | 205.67 | 205.8781 | 203.76 | 205.174 | 2482655.0 |
| 2025-03-27 10:00:00 | IWM | ETF | 205.14 | 206.35 | 204.82 | 206.1 | 2088874.0 |
| 2025-03-27 11:00:00 | IWM | ETF | 206.13 | 206.3 | 204.505 | 204.52 | 2147603.0 |
| 2025-03-27 12:00:00 | IWM | ETF | 204.53 | 205.77 | 204.24 | 204.255 | 1634664.0 |
| 2025-03-27 13:00:00 | IWM | ETF | 204.28 | 205.09 | 204.17 | 204.42 | 1218644.0 |
| 2025-03-27 14:00:00 | IWM | ETF | 204.42 | 205.31 | 204.375 | 204.72 | 875423.0 |
| 2025-03-27 15:00:00 | IWM | ETF | 204.72 | 205.845 | 204.42 | 204.63 | 4245232.0 |
| 2025-03-27 16:00:00 | IWM | ETF | 204.61 | 204.98 | 204.6 | 204.85 | 1797336.0 |
| 2025-03-27 17:00:00 | IWM | ETF | 204.85 | 204.85 | 204.58 | 204.75 | 43541.0 |
| 2025-03-27 18:00:00 | IWM | ETF | 204.74 | 204.89 | 204.61 | 204.61 | 21439.0 |
| 2025-03-27 19:00:00 | IWM | ETF | 204.56 | 204.7 | 204.42 | 204.58 | 8607.0 |
| 2025-03-27 04:00:00 | DIA | ETF | 424.16 | 425.06 | 424.16 | 425.06 | 3867.0 |
| 2025-03-27 05:00:00 | DIA | ETF | 425.08 | 425.26 | 425.08 | 425.26 | 500.0 |
> showing 50 of 23,461 rows — these rows as CSV