PREVIEW / etf_1hour / 2024-06-10
file: by_date/etf_1hour/2024/2024-06-10.parquet size: 531 KB rows: 19,628
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-06-10 04:00:00 | SPY | ETF | 533.49 | 533.54 | 532.88 | 532.88 | 9887.0 |
| 2024-06-10 05:00:00 | SPY | ETF | 532.83 | 533.0 | 532.5 | 532.8 | 27434.0 |
| 2024-06-10 06:00:00 | SPY | ETF | 532.85 | 533.62 | 532.83 | 533.34 | 21861.0 |
| 2024-06-10 07:00:00 | SPY | ETF | 533.33 | 533.78 | 533.26 | 533.62 | 87651.0 |
| 2024-06-10 08:00:00 | SPY | ETF | 533.3593 | 534.28 | 533.0 | 533.08 | 153217.0 |
| 2024-06-10 09:00:00 | SPY | ETF | 533.12 | 533.27 | 532.57 | 533.09 | 2748294.0 |
| 2024-06-10 10:00:00 | SPY | ETF | 533.1 | 533.9 | 533.03 | 533.74 | 2326613.0 |
| 2024-06-10 11:00:00 | SPY | ETF | 533.75 | 535.05 | 533.73 | 534.605 | 3010583.0 |
| 2024-06-10 12:00:00 | SPY | ETF | 534.61 | 535.14 | 534.56 | 534.845 | 1749737.0 |
| 2024-06-10 13:00:00 | SPY | ETF | 534.85 | 535.72 | 534.23 | 535.305 | 2614137.0 |
| 2024-06-10 14:00:00 | SPY | ETF | 535.305 | 535.58 | 534.29 | 535.01 | 2232434.0 |
| 2024-06-10 15:00:00 | SPY | ETF | 535.005 | 535.99 | 534.7 | 535.65 | 10052280.0 |
| 2024-06-10 16:00:00 | SPY | ETF | 535.65 | 535.78 | 534.89 | 535.38 | 3227492.0 |
| 2024-06-10 17:00:00 | SPY | ETF | 535.36 | 535.52 | 535.35 | 535.4596 | 34158.0 |
| 2024-06-10 18:00:00 | SPY | ETF | 535.45 | 535.59 | 535.35 | 535.39 | 28743.0 |
| 2024-06-10 19:00:00 | SPY | ETF | 535.3 | 535.3 | 534.98 | 535.148 | 25337.0 |
| 2024-06-10 04:00:00 | QQQ | ETF | 462.52 | 462.59 | 461.98 | 461.98 | 91049.0 |
| 2024-06-10 05:00:00 | QQQ | ETF | 461.99 | 462.17 | 461.55 | 462.05 | 51400.0 |
| 2024-06-10 06:00:00 | QQQ | ETF | 462.18 | 463.01 | 462.0 | 462.5 | 55794.0 |
| 2024-06-10 07:00:00 | QQQ | ETF | 462.44 | 463.03 | 462.44 | 462.72 | 74249.0 |
| 2024-06-10 08:00:00 | QQQ | ETF | 462.82 | 463.17 | 461.83 | 461.93 | 193584.0 |
| 2024-06-10 09:00:00 | QQQ | ETF | 461.92 | 462.66 | 461.53 | 461.89 | 1750739.0 |
| 2024-06-10 10:00:00 | QQQ | ETF | 461.91 | 463.75 | 461.81 | 463.67 | 2074691.0 |
| 2024-06-10 11:00:00 | QQQ | ETF | 463.69 | 464.81 | 463.59 | 464.1925 | 1717107.0 |
| 2024-06-10 12:00:00 | QQQ | ETF | 464.2 | 465.02 | 464.08 | 464.63 | 1397589.0 |
| 2024-06-10 13:00:00 | QQQ | ETF | 464.635 | 464.9002 | 463.3563 | 464.52 | 1750610.0 |
| 2024-06-10 14:00:00 | QQQ | ETF | 464.5289 | 464.64 | 462.87 | 463.93 | 2276849.0 |
| 2024-06-10 15:00:00 | QQQ | ETF | 463.94 | 465.19 | 463.83 | 464.81 | 3567052.0 |
| 2024-06-10 16:00:00 | QQQ | ETF | 464.77 | 464.83 | 464.09 | 464.63 | 851646.0 |
| 2024-06-10 17:00:00 | QQQ | ETF | 464.51 | 464.83 | 464.4704 | 464.58 | 141512.0 |
| 2024-06-10 18:00:00 | QQQ | ETF | 464.58 | 464.83 | 464.34 | 464.43 | 31316.0 |
| 2024-06-10 19:00:00 | QQQ | ETF | 464.35 | 464.35 | 463.95 | 464.1 | 32923.0 |
| 2024-06-10 04:00:00 | IWM | ETF | 200.15 | 200.19 | 199.7 | 199.72 | 35677.0 |
| 2024-06-10 05:00:00 | IWM | ETF | 199.73 | 199.84 | 199.48 | 199.75 | 33051.0 |
| 2024-06-10 06:00:00 | IWM | ETF | 199.82 | 200.2 | 199.82 | 200.07 | 16622.0 |
| 2024-06-10 07:00:00 | IWM | ETF | 200.06 | 200.38 | 200.0 | 200.26 | 27624.0 |
| 2024-06-10 08:00:00 | IWM | ETF | 200.08 | 200.79 | 199.33 | 199.38 | 173983.0 |
| 2024-06-10 09:00:00 | IWM | ETF | 199.37 | 200.03 | 199.01 | 200.02 | 2853710.0 |
| 2024-06-10 10:00:00 | IWM | ETF | 200.03 | 201.21 | 199.92 | 200.78 | 3243804.0 |
| 2024-06-10 11:00:00 | IWM | ETF | 200.8 | 201.45 | 200.66 | 201.26 | 1482881.0 |
| 2024-06-10 12:00:00 | IWM | ETF | 201.27 | 201.41 | 201.04 | 201.33 | 932726.0 |
| 2024-06-10 13:00:00 | IWM | ETF | 201.32 | 201.99 | 201.07 | 201.71 | 1328605.0 |
| 2024-06-10 14:00:00 | IWM | ETF | 201.71 | 202.05 | 201.395 | 201.85 | 1721816.0 |
| 2024-06-10 15:00:00 | IWM | ETF | 201.84 | 202.13 | 201.6 | 201.94 | 3071546.0 |
| 2024-06-10 16:00:00 | IWM | ETF | 201.89 | 201.93 | 201.56 | 201.93 | 656125.0 |
| 2024-06-10 17:00:00 | IWM | ETF | 201.87 | 202.0 | 201.81 | 201.87 | 253355.0 |
| 2024-06-10 18:00:00 | IWM | ETF | 201.89 | 202.0 | 201.82 | 201.89 | 11425.0 |
| 2024-06-10 19:00:00 | IWM | ETF | 201.9 | 201.92 | 201.59 | 201.68 | 27757.0 |
| 2024-06-10 04:00:00 | DIA | ETF | 387.87 | 387.87 | 387.45 | 387.45 | 531.0 |
| 2024-06-10 05:00:00 | DIA | ETF | 387.31 | 387.35 | 387.25 | 387.35 | 3050.0 |
> showing 50 of 19,628 rows — these rows as CSV