PREVIEW / etf_1hour / 2025-02-13
file: by_date/etf_1hour/2025/2025-02-13.parquet size: 628 KB rows: 23,744
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-02-13 04:00:00 | SPY | ETF | 602.44 | 603.42 | 601.65 | 603.32 | 33106.0 |
| 2025-02-13 05:00:00 | SPY | ETF | 603.42 | 603.6 | 603.0 | 603.44 | 9189.0 |
| 2025-02-13 06:00:00 | SPY | ETF | 603.53 | 603.91 | 602.79 | 603.4 | 61096.0 |
| 2025-02-13 07:00:00 | SPY | ETF | 603.32 | 603.49 | 602.72 | 603.17 | 105914.0 |
| 2025-02-13 08:00:00 | SPY | ETF | 603.28 | 604.99 | 602.0 | 604.62 | 697475.0 |
| 2025-02-13 09:00:00 | SPY | ETF | 604.5904 | 605.06 | 603.2 | 604.83 | 2754766.0 |
| 2025-02-13 10:00:00 | SPY | ETF | 604.82 | 607.49 | 604.21 | 607.09 | 4298350.0 |
| 2025-02-13 11:00:00 | SPY | ETF | 607.09 | 607.48 | 605.75 | 606.1 | 2001035.0 |
| 2025-02-13 12:00:00 | SPY | ETF | 606.1 | 606.97 | 605.72 | 606.1829 | 1428288.0 |
| 2025-02-13 13:00:00 | SPY | ETF | 606.17 | 607.25 | 604.99 | 607.19 | 2855167.0 |
| 2025-02-13 14:00:00 | SPY | ETF | 607.19 | 609.29 | 607.03 | 608.9 | 4873542.0 |
| 2025-02-13 15:00:00 | SPY | ETF | 608.895 | 609.94 | 608.82 | 609.69 | 8814307.0 |
| 2025-02-13 16:00:00 | SPY | ETF | 609.67 | 609.92 | 609.24 | 609.4 | 2990901.0 |
| 2025-02-13 17:00:00 | SPY | ETF | 609.4 | 609.486 | 609.2 | 609.34 | 45545.0 |
| 2025-02-13 18:00:00 | SPY | ETF | 609.36 | 609.81 | 609.36 | 609.5 | 50841.0 |
| 2025-02-13 19:00:00 | SPY | ETF | 609.58 | 609.77 | 609.38 | 609.65 | 28615.0 |
| 2025-02-13 04:00:00 | QQQ | ETF | 529.88 | 529.88 | 527.22 | 529.11 | 79682.0 |
| 2025-02-13 05:00:00 | QQQ | ETF | 529.16 | 529.43 | 528.61 | 529.29 | 26250.0 |
| 2025-02-13 06:00:00 | QQQ | ETF | 529.21 | 529.75 | 528.35 | 529.0 | 47403.0 |
| 2025-02-13 07:00:00 | QQQ | ETF | 528.92 | 529.1 | 528.15 | 528.86 | 105271.0 |
| 2025-02-13 08:00:00 | QQQ | ETF | 528.34 | 531.17 | 527.349 | 530.24 | 494067.0 |
| 2025-02-13 09:00:00 | QQQ | ETF | 530.21 | 531.9897 | 529.19 | 531.2347 | 2422683.0 |
| 2025-02-13 10:00:00 | QQQ | ETF | 531.22 | 534.57 | 530.22 | 534.09 | 3568087.0 |
| 2025-02-13 11:00:00 | QQQ | ETF | 534.0775 | 534.275 | 531.78 | 532.26 | 1743591.0 |
| 2025-02-13 12:00:00 | QQQ | ETF | 532.26 | 533.16 | 531.8106 | 532.3799 | 1266116.0 |
| 2025-02-13 13:00:00 | QQQ | ETF | 532.3713 | 533.09 | 530.56 | 533.05 | 2295564.0 |
| 2025-02-13 14:00:00 | QQQ | ETF | 533.06 | 534.99 | 532.88 | 534.55 | 2106438.0 |
| 2025-02-13 15:00:00 | QQQ | ETF | 534.53 | 536.22 | 534.4549 | 535.88 | 3947484.0 |
| 2025-02-13 16:00:00 | QQQ | ETF | 535.88 | 535.91 | 534.94 | 535.07 | 1816143.0 |
| 2025-02-13 17:00:00 | QQQ | ETF | 535.03 | 535.21 | 534.95 | 535.13 | 61155.0 |
| 2025-02-13 18:00:00 | QQQ | ETF | 535.06 | 535.62 | 534.9 | 535.18 | 38374.0 |
| 2025-02-13 19:00:00 | QQQ | ETF | 535.3 | 535.6999 | 535.02 | 535.5 | 41211.0 |
| 2025-02-13 04:00:00 | IWM | ETF | 223.42 | 224.17 | 223.21 | 224.17 | 20891.0 |
| 2025-02-13 05:00:00 | IWM | ETF | 224.18 | 224.64 | 224.07 | 224.62 | 13450.0 |
| 2025-02-13 06:00:00 | IWM | ETF | 224.56 | 224.82 | 224.11 | 224.39 | 41167.0 |
| 2025-02-13 07:00:00 | IWM | ETF | 224.34 | 224.49 | 224.02 | 224.28 | 65052.0 |
| 2025-02-13 08:00:00 | IWM | ETF | 224.3615 | 226.22 | 223.5 | 225.2 | 572192.0 |
| 2025-02-13 09:00:00 | IWM | ETF | 225.15 | 225.47 | 223.98 | 224.545 | 2373427.0 |
| 2025-02-13 10:00:00 | IWM | ETF | 224.58 | 225.23 | 224.185 | 224.275 | 2325243.0 |
| 2025-02-13 11:00:00 | IWM | ETF | 224.28 | 224.43 | 223.83 | 224.03 | 1066105.0 |
| 2025-02-13 12:00:00 | IWM | ETF | 224.02 | 224.8 | 223.75 | 224.28 | 1152376.0 |
| 2025-02-13 13:00:00 | IWM | ETF | 224.27 | 224.95 | 223.84 | 224.88 | 1642477.0 |
| 2025-02-13 14:00:00 | IWM | ETF | 224.87 | 225.87 | 224.81 | 225.56 | 1888846.0 |
| 2025-02-13 15:00:00 | IWM | ETF | 225.56 | 226.34 | 225.52 | 226.11 | 3149057.0 |
| 2025-02-13 16:00:00 | IWM | ETF | 226.14 | 226.21 | 226.0 | 226.02 | 869688.0 |
| 2025-02-13 17:00:00 | IWM | ETF | 226.01 | 226.1295 | 225.87 | 225.95 | 19840.0 |
| 2025-02-13 18:00:00 | IWM | ETF | 226.0 | 226.22 | 225.95 | 225.97 | 47339.0 |
| 2025-02-13 19:00:00 | IWM | ETF | 226.12 | 226.16 | 225.95 | 226.0 | 32461.0 |
| 2025-02-13 04:00:00 | DIA | ETF | 443.0 | 443.0 | 442.83 | 442.9 | 900.0 |
| 2025-02-13 07:00:00 | DIA | ETF | 444.0 | 444.09 | 443.74 | 443.85 | 2000.0 |
> showing 50 of 23,744 rows — these rows as CSV