PREVIEW / etf_30min / 2005-10-04
file: by_date/etf_30min/2005/2005-10-04.parquet size: 49 KB rows: 1,748
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-04 07:00:00 | SPY | ETF | 122.85 | 122.85 | 122.85 | 122.85 | 59400.0 |
| 2005-10-04 07:30:00 | SPY | ETF | 122.76 | 122.78 | 122.76 | 122.76 | 800.0 |
| 2005-10-04 08:00:00 | SPY | ETF | 122.5 | 122.85 | 122.5 | 122.73 | 114700.0 |
| 2005-10-04 08:30:00 | SPY | ETF | 122.73 | 122.74 | 122.7 | 122.71 | 14700.0 |
| 2005-10-04 09:00:00 | SPY | ETF | 122.73 | 122.79 | 122.73 | 122.79 | 74600.0 |
| 2005-10-04 09:30:00 | SPY | ETF | 122.79 | 122.89 | 122.5 | 122.5 | 4630500.0 |
| 2005-10-04 10:00:00 | SPY | ETF | 122.5 | 123.03 | 122.48 | 122.92 | 8715900.0 |
| 2005-10-04 10:30:00 | SPY | ETF | 122.92 | 122.92 | 122.73 | 122.88 | 2472300.0 |
| 2005-10-04 11:00:00 | SPY | ETF | 122.89 | 122.92 | 122.61 | 122.78 | 1938000.0 |
| 2005-10-04 11:30:00 | SPY | ETF | 122.79 | 122.98 | 122.64 | 122.94 | 2681300.0 |
| 2005-10-04 12:00:00 | SPY | ETF | 122.94 | 122.96 | 122.79 | 122.9 | 2026300.0 |
| 2005-10-04 12:30:00 | SPY | ETF | 122.91 | 122.91 | 122.77 | 122.83 | 675100.0 |
| 2005-10-04 13:00:00 | SPY | ETF | 122.83 | 122.89 | 122.81 | 122.85 | 700000.0 |
| 2005-10-04 13:30:00 | SPY | ETF | 122.84 | 122.85 | 122.54 | 122.6 | 2272800.0 |
| 2005-10-04 14:00:00 | SPY | ETF | 122.59 | 122.66 | 122.18 | 122.22 | 5673700.0 |
| 2005-10-04 14:30:00 | SPY | ETF | 122.22 | 122.27 | 121.78 | 121.82 | 6836100.0 |
| 2005-10-04 15:00:00 | SPY | ETF | 121.82 | 121.99 | 121.56 | 121.71 | 9180500.0 |
| 2005-10-04 15:30:00 | SPY | ETF | 121.71 | 121.82 | 121.33 | 121.4 | 8040100.0 |
| 2005-10-04 16:00:00 | SPY | ETF | 121.39 | 121.39 | 121.13 | 121.13 | 285700.0 |
| 2005-10-04 16:30:00 | SPY | ETF | 121.13 | 121.44 | 121.12 | 121.12 | 649500.0 |
| 2005-10-04 17:00:00 | SPY | ETF | 121.14 | 121.18 | 121.12 | 121.15 | 13800.0 |
| 2005-10-04 17:30:00 | SPY | ETF | 121.16 | 121.2 | 121.16 | 121.2 | 2200.0 |
| 2005-10-04 18:00:00 | SPY | ETF | 121.16 | 121.16 | 121.13 | 121.16 | 3300.0 |
| 2005-10-04 18:30:00 | SPY | ETF | 121.14 | 121.15 | 121.14 | 121.14 | 1300.0 |
| 2005-10-04 19:00:00 | SPY | ETF | 121.14 | 121.14 | 121.12 | 121.12 | 700.0 |
| 2005-10-04 19:30:00 | SPY | ETF | 121.17 | 121.17 | 121.17 | 121.17 | 3000.0 |
| 2005-10-04 09:30:00 | QQQ | ETF | 39.6 | 39.65 | 39.52 | 39.56 | 8375300.0 |
| 2005-10-04 10:00:00 | QQQ | ETF | 39.56 | 39.74 | 39.53 | 39.71 | 8849500.0 |
| 2005-10-04 10:30:00 | QQQ | ETF | 39.71 | 39.74 | 39.65 | 39.73 | 3069200.0 |
| 2005-10-04 11:00:00 | QQQ | ETF | 39.73 | 39.75 | 39.64 | 39.72 | 3067600.0 |
| 2005-10-04 11:30:00 | QQQ | ETF | 39.72 | 39.86 | 39.71 | 39.85 | 6580800.0 |
| 2005-10-04 12:00:00 | QQQ | ETF | 39.85 | 39.88 | 39.81 | 39.86 | 3634500.0 |
| 2005-10-04 12:30:00 | QQQ | ETF | 39.85 | 39.86 | 39.8 | 39.83 | 1776400.0 |
| 2005-10-04 13:00:00 | QQQ | ETF | 39.83 | 39.86 | 39.81 | 39.81 | 1482200.0 |
| 2005-10-04 13:30:00 | QQQ | ETF | 39.81 | 39.82 | 39.65 | 39.66 | 5547900.0 |
| 2005-10-04 14:00:00 | QQQ | ETF | 39.66 | 39.67 | 39.53 | 39.53 | 6668900.0 |
| 2005-10-04 14:30:00 | QQQ | ETF | 39.53 | 39.59 | 39.39 | 39.42 | 7951900.0 |
| 2005-10-04 15:00:00 | QQQ | ETF | 39.41 | 39.48 | 39.32 | 39.37 | 11677700.0 |
| 2005-10-04 15:30:00 | QQQ | ETF | 39.37 | 39.44 | 39.29 | 39.31 | 11804200.0 |
| 2005-10-04 09:00:00 | IWM | ETF | 66.78 | 66.85 | 66.78 | 66.85 | 15100.0 |
| 2005-10-04 09:30:00 | IWM | ETF | 66.88 | 67.0 | 66.59 | 66.6 | 1021000.0 |
| 2005-10-04 10:00:00 | IWM | ETF | 66.6 | 66.93 | 66.54 | 66.86 | 2721600.0 |
| 2005-10-04 10:30:00 | IWM | ETF | 66.86 | 66.86 | 66.66 | 66.8 | 837000.0 |
| 2005-10-04 11:00:00 | IWM | ETF | 66.79 | 66.82 | 66.62 | 66.8 | 290000.0 |
| 2005-10-04 11:30:00 | IWM | ETF | 66.8 | 67.03 | 66.8 | 67.03 | 1087200.0 |
| 2005-10-04 12:00:00 | IWM | ETF | 67.03 | 67.07 | 66.97 | 67.03 | 740100.0 |
| 2005-10-04 12:30:00 | IWM | ETF | 67.03 | 67.03 | 66.96 | 66.99 | 335900.0 |
| 2005-10-04 13:00:00 | IWM | ETF | 66.98 | 67.1 | 66.98 | 67.07 | 376700.0 |
| 2005-10-04 13:30:00 | IWM | ETF | 67.07 | 67.07 | 66.76 | 66.81 | 544700.0 |
| 2005-10-04 14:00:00 | IWM | ETF | 66.82 | 66.87 | 66.62 | 66.66 | 945600.0 |
> showing 50 of 1,748 rows — these rows as CSV