PREVIEW / etf_30min / 2003-10-10
file: by_date/etf_30min/2003/2003-10-10.parquet size: 25 KB rows: 781
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-10 08:00:00 | SPY | ETF | 104.46 | 104.7 | 104.41 | 104.65 | 146700.0 |
| 2003-10-10 08:30:00 | SPY | ETF | 104.65 | 104.7 | 104.31 | 104.31 | 87100.0 |
| 2003-10-10 09:00:00 | SPY | ETF | 104.31 | 104.35 | 104.17 | 104.23 | 31400.0 |
| 2003-10-10 09:30:00 | SPY | ETF | 104.27 | 104.42 | 104.14 | 104.2 | 3912400.0 |
| 2003-10-10 10:00:00 | SPY | ETF | 104.2 | 104.45 | 104.11 | 104.4 | 1603900.0 |
| 2003-10-10 10:30:00 | SPY | ETF | 104.4 | 104.48 | 103.97 | 104.06 | 2270200.0 |
| 2003-10-10 11:00:00 | SPY | ETF | 104.04 | 104.18 | 103.94 | 104.12 | 1381500.0 |
| 2003-10-10 11:30:00 | SPY | ETF | 104.11 | 104.23 | 103.91 | 104.18 | 1257000.0 |
| 2003-10-10 12:00:00 | SPY | ETF | 104.18 | 104.29 | 104.06 | 104.14 | 990800.0 |
| 2003-10-10 12:30:00 | SPY | ETF | 104.16 | 104.19 | 104.01 | 104.15 | 790400.0 |
| 2003-10-10 13:00:00 | SPY | ETF | 104.15 | 104.38 | 104.13 | 104.3 | 994300.0 |
| 2003-10-10 13:30:00 | SPY | ETF | 104.3 | 104.38 | 104.15 | 104.23 | 644400.0 |
| 2003-10-10 14:00:00 | SPY | ETF | 104.16 | 104.29 | 104.12 | 104.22 | 844400.0 |
| 2003-10-10 14:30:00 | SPY | ETF | 104.22 | 104.24 | 103.96 | 104.0 | 1369900.0 |
| 2003-10-10 15:00:00 | SPY | ETF | 103.98 | 104.16 | 103.93 | 104.05 | 1415000.0 |
| 2003-10-10 15:30:00 | SPY | ETF | 104.03 | 104.22 | 104.0 | 104.2 | 1533000.0 |
| 2003-10-10 16:00:00 | SPY | ETF | 104.22 | 104.6 | 104.18 | 104.5 | 1364600.0 |
| 2003-10-10 16:30:00 | SPY | ETF | 104.5 | 104.55 | 104.5 | 104.5 | 5300.0 |
| 2003-10-10 17:00:00 | SPY | ETF | 104.54 | 104.58 | 104.52 | 104.52 | 6500.0 |
| 2003-10-10 17:30:00 | SPY | ETF | 104.52 | 104.54 | 104.52 | 104.54 | 1500.0 |
| 2003-10-10 18:00:00 | SPY | ETF | 104.5 | 104.54 | 104.5 | 104.54 | 1700.0 |
| 2003-10-10 19:00:00 | SPY | ETF | 104.51 | 104.51 | 104.51 | 104.51 | 200.0 |
| 2003-10-10 08:00:00 | QQQ | ETF | 34.81 | 34.93 | 34.81 | 34.89 | 155400.0 |
| 2003-10-10 08:30:00 | QQQ | ETF | 34.88 | 34.93 | 34.77 | 34.79 | 226500.0 |
| 2003-10-10 09:00:00 | QQQ | ETF | 34.78 | 34.8 | 34.74 | 34.76 | 128300.0 |
| 2003-10-10 09:30:00 | QQQ | ETF | 34.77 | 34.95 | 34.72 | 34.81 | 15304400.0 |
| 2003-10-10 10:00:00 | QQQ | ETF | 34.809 | 34.961 | 34.763 | 34.93 | 6090500.0 |
| 2003-10-10 10:30:00 | QQQ | ETF | 34.92 | 34.97 | 34.68 | 34.7 | 5535900.0 |
| 2003-10-10 11:00:00 | QQQ | ETF | 34.71 | 34.825 | 34.65 | 34.8 | 4356000.0 |
| 2003-10-10 11:30:00 | QQQ | ETF | 34.8 | 34.82 | 34.64 | 34.794 | 4166000.0 |
| 2003-10-10 12:00:00 | QQQ | ETF | 34.79 | 34.87 | 34.74 | 34.81 | 2647900.0 |
| 2003-10-10 12:30:00 | QQQ | ETF | 34.82 | 34.85 | 34.73 | 34.81 | 1354300.0 |
| 2003-10-10 13:00:00 | QQQ | ETF | 34.81 | 34.97 | 34.809 | 34.92 | 3007700.0 |
| 2003-10-10 13:30:00 | QQQ | ETF | 34.93 | 34.96 | 34.823 | 34.844 | 2918100.0 |
| 2003-10-10 14:00:00 | QQQ | ETF | 34.85 | 34.92 | 34.81 | 34.835 | 1854500.0 |
| 2003-10-10 14:30:00 | QQQ | ETF | 34.835 | 34.84 | 34.7 | 34.755 | 2400800.0 |
| 2003-10-10 15:00:00 | QQQ | ETF | 34.759 | 34.84 | 34.71 | 34.818 | 3822300.0 |
| 2003-10-10 15:30:00 | QQQ | ETF | 34.818 | 34.93 | 34.8 | 34.93 | 4995800.0 |
| 2003-10-10 16:00:00 | QQQ | ETF | 34.92 | 35.03 | 34.67 | 35.01 | 4255000.0 |
| 2003-10-10 16:30:00 | QQQ | ETF | 35.01 | 35.01 | 34.99 | 35.01 | 82900.0 |
| 2003-10-10 17:00:00 | QQQ | ETF | 35.01 | 35.02 | 34.98 | 35.01 | 35300.0 |
| 2003-10-10 17:30:00 | QQQ | ETF | 35.0 | 35.02 | 35.0 | 35.0 | 37300.0 |
| 2003-10-10 18:00:00 | QQQ | ETF | 35.01 | 35.01 | 34.99 | 34.99 | 3300.0 |
| 2003-10-10 18:30:00 | QQQ | ETF | 35.02 | 35.03 | 35.0 | 35.02 | 3400.0 |
| 2003-10-10 19:00:00 | QQQ | ETF | 35.02 | 35.03 | 35.02 | 35.03 | 3600.0 |
| 2003-10-10 19:30:00 | QQQ | ETF | 35.03 | 35.04 | 35.02 | 35.04 | 5700.0 |
| 2003-10-10 09:30:00 | IWM | ETF | 51.925 | 52.08 | 51.8 | 51.905 | 1620400.0 |
| 2003-10-10 10:00:00 | IWM | ETF | 51.905 | 52.0 | 51.875 | 51.93 | 469600.0 |
| 2003-10-10 10:30:00 | IWM | ETF | 51.975 | 51.975 | 51.415 | 51.415 | 642400.0 |
| 2003-10-10 11:00:00 | IWM | ETF | 51.445 | 51.51 | 51.3 | 51.46 | 549600.0 |
> showing 50 of 781 rows — these rows as CSV