PREVIEW / etf_30min / 2024-12-16
file: by_date/etf_30min/2024/2024-12-16.parquet size: 937 KB rows: 37,712
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-12-16 04:00:00 | SPY | ETF | 604.12 | 604.93 | 604.12 | 604.88 | 4708.0 |
| 2024-12-16 04:30:00 | SPY | ETF | 604.93 | 605.16 | 604.93 | 605.16 | 4040.0 |
| 2024-12-16 05:00:00 | SPY | ETF | 605.25 | 605.55 | 605.18 | 605.55 | 7291.0 |
| 2024-12-16 05:30:00 | SPY | ETF | 605.57 | 605.67 | 605.43 | 605.44 | 10003.0 |
| 2024-12-16 06:00:00 | SPY | ETF | 605.31 | 605.31 | 604.99 | 605.15 | 6967.0 |
| 2024-12-16 06:30:00 | SPY | ETF | 605.19 | 605.39 | 605.12 | 605.34 | 4825.0 |
| 2024-12-16 07:00:00 | SPY | ETF | 605.34 | 605.75 | 605.301 | 605.71 | 33599.0 |
| 2024-12-16 07:30:00 | SPY | ETF | 605.74 | 605.77 | 605.52 | 605.62 | 26902.0 |
| 2024-12-16 08:00:00 | SPY | ETF | 605.6588 | 606.21 | 604.42 | 606.15 | 44136.0 |
| 2024-12-16 08:30:00 | SPY | ETF | 606.12 | 606.38 | 605.99 | 606.38 | 101671.0 |
| 2024-12-16 09:00:00 | SPY | ETF | 606.37 | 606.391 | 605.66 | 606.0 | 174559.0 |
| 2024-12-16 09:30:00 | SPY | ETF | 606.0 | 606.4 | 605.5801 | 606.27 | 2625644.0 |
| 2024-12-16 10:00:00 | SPY | ETF | 606.3 | 606.6772 | 605.21 | 606.46 | 1631681.0 |
| 2024-12-16 10:30:00 | SPY | ETF | 606.45 | 607.11 | 606.36 | 606.71 | 1372465.0 |
| 2024-12-16 11:00:00 | SPY | ETF | 606.71 | 606.98 | 606.535 | 606.72 | 1044248.0 |
| 2024-12-16 11:30:00 | SPY | ETF | 606.73 | 606.96 | 606.4 | 606.95 | 823716.0 |
| 2024-12-16 12:00:00 | SPY | ETF | 606.96 | 607.03 | 606.56 | 606.95 | 509923.0 |
| 2024-12-16 12:30:00 | SPY | ETF | 606.95 | 607.34 | 606.86 | 607.255 | 977561.0 |
| 2024-12-16 13:00:00 | SPY | ETF | 607.26 | 607.72 | 607.16 | 607.72 | 1030806.0 |
| 2024-12-16 13:30:00 | SPY | ETF | 607.71 | 607.7795 | 607.42 | 607.62 | 874229.0 |
| 2024-12-16 14:00:00 | SPY | ETF | 607.61 | 607.66 | 607.32 | 607.35 | 1279306.0 |
| 2024-12-16 14:30:00 | SPY | ETF | 607.34 | 607.66 | 607.29 | 607.5 | 1035782.0 |
| 2024-12-16 15:00:00 | SPY | ETF | 607.51 | 607.775 | 607.41 | 607.59 | 1373236.0 |
| 2024-12-16 15:30:00 | SPY | ETF | 607.58 | 607.581 | 606.055 | 606.775 | 7329533.0 |
| 2024-12-16 16:00:00 | SPY | ETF | 606.76 | 607.8704 | 606.08 | 606.13 | 3948540.0 |
| 2024-12-16 16:30:00 | SPY | ETF | 606.14 | 606.39 | 606.12 | 606.32 | 43359.0 |
| 2024-12-16 17:00:00 | SPY | ETF | 606.45 | 606.6959 | 606.21 | 606.24 | 79561.0 |
| 2024-12-16 17:30:00 | SPY | ETF | 606.24 | 606.34 | 606.15 | 606.3 | 22297.0 |
| 2024-12-16 18:00:00 | SPY | ETF | 606.34 | 606.35 | 605.79 | 605.9442 | 31741.0 |
| 2024-12-16 18:30:00 | SPY | ETF | 605.99 | 606.22 | 605.99 | 606.12 | 9847.0 |
| 2024-12-16 19:00:00 | SPY | ETF | 606.1 | 606.1 | 605.95 | 606.03 | 5077.0 |
| 2024-12-16 19:30:00 | SPY | ETF | 606.03 | 606.08 | 605.9 | 605.98 | 6788.0 |
| 2024-12-16 04:00:00 | QQQ | ETF | 530.87 | 531.48 | 530.84 | 531.4 | 16527.0 |
| 2024-12-16 04:30:00 | QQQ | ETF | 531.26 | 531.83 | 531.26 | 531.82 | 9746.0 |
| 2024-12-16 05:00:00 | QQQ | ETF | 531.92 | 532.17 | 531.8 | 532.17 | 13636.0 |
| 2024-12-16 05:30:00 | QQQ | ETF | 532.24 | 532.25 | 532.02 | 532.25 | 11913.0 |
| 2024-12-16 06:00:00 | QQQ | ETF | 531.9 | 532.03 | 531.61 | 531.9 | 15039.0 |
| 2024-12-16 06:30:00 | QQQ | ETF | 531.88 | 532.31 | 531.65 | 532.26 | 60486.0 |
| 2024-12-16 07:00:00 | QQQ | ETF | 532.15 | 532.66 | 532.02 | 532.6 | 37739.0 |
| 2024-12-16 07:30:00 | QQQ | ETF | 532.6 | 532.68 | 532.29 | 532.51 | 62664.0 |
| 2024-12-16 08:00:00 | QQQ | ETF | 532.1502 | 533.23 | 530.133 | 533.17 | 174151.0 |
| 2024-12-16 08:30:00 | QQQ | ETF | 533.15 | 533.4 | 533.06 | 533.35 | 153459.0 |
| 2024-12-16 09:00:00 | QQQ | ETF | 533.36 | 533.36 | 532.6 | 533.0304 | 151899.0 |
| 2024-12-16 09:30:00 | QQQ | ETF | 533.08 | 534.85 | 533.0 | 534.83 | 3108117.0 |
| 2024-12-16 10:00:00 | QQQ | ETF | 534.85 | 535.4 | 533.78 | 535.38 | 1841643.0 |
| 2024-12-16 10:30:00 | QQQ | ETF | 535.38 | 536.08 | 535.09 | 535.26 | 1249697.0 |
| 2024-12-16 11:00:00 | QQQ | ETF | 535.27 | 536.64 | 535.26 | 536.33 | 1045297.0 |
| 2024-12-16 11:30:00 | QQQ | ETF | 536.34 | 536.86 | 535.5799 | 536.832 | 1091345.0 |
| 2024-12-16 12:00:00 | QQQ | ETF | 536.82 | 536.97 | 536.39 | 536.94 | 788970.0 |
| 2024-12-16 12:30:00 | QQQ | ETF | 536.95 | 537.57 | 536.92 | 537.54 | 1084938.0 |
> showing 50 of 37,712 rows — these rows as CSV