PREVIEW / etf_30min / 2004-09-30
file: by_date/etf_30min/2004/2004-09-30.parquet size: 36 KB rows: 1,201
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-30 08:00:00 | SPY | ETF | 111.9 | 111.9 | 111.7 | 111.75 | 78000.0 |
| 2004-09-30 08:30:00 | SPY | ETF | 111.71 | 111.77 | 111.62 | 111.62 | 60800.0 |
| 2004-09-30 09:00:00 | SPY | ETF | 111.57 | 111.66 | 111.55 | 111.59 | 48400.0 |
| 2004-09-30 09:30:00 | SPY | ETF | 111.55 | 111.76 | 111.43 | 111.67 | 5899400.0 |
| 2004-09-30 10:00:00 | SPY | ETF | 111.67 | 111.82 | 111.61 | 111.69 | 3413700.0 |
| 2004-09-30 10:30:00 | SPY | ETF | 111.69 | 111.76 | 111.51 | 111.52 | 3010400.0 |
| 2004-09-30 11:00:00 | SPY | ETF | 111.53 | 111.57 | 111.38 | 111.49 | 2001000.0 |
| 2004-09-30 11:30:00 | SPY | ETF | 111.48 | 111.52 | 111.33 | 111.36 | 1888400.0 |
| 2004-09-30 12:00:00 | SPY | ETF | 111.37 | 111.42 | 111.26 | 111.37 | 2670100.0 |
| 2004-09-30 12:30:00 | SPY | ETF | 111.38 | 111.5 | 111.37 | 111.38 | 899400.0 |
| 2004-09-30 13:00:00 | SPY | ETF | 111.38 | 111.5 | 111.31 | 111.48 | 990200.0 |
| 2004-09-30 13:30:00 | SPY | ETF | 111.49 | 111.69 | 111.45 | 111.67 | 1627200.0 |
| 2004-09-30 14:00:00 | SPY | ETF | 111.67 | 111.78 | 111.6 | 111.76 | 1739500.0 |
| 2004-09-30 14:30:00 | SPY | ETF | 111.76 | 111.93 | 111.63 | 111.9 | 1216600.0 |
| 2004-09-30 15:00:00 | SPY | ETF | 111.9 | 111.98 | 111.54 | 111.56 | 4342500.0 |
| 2004-09-30 15:30:00 | SPY | ETF | 111.55 | 111.8 | 111.48 | 111.74 | 4951700.0 |
| 2004-09-30 16:00:00 | SPY | ETF | 111.74 | 111.8 | 111.64 | 111.78 | 6176400.0 |
| 2004-09-30 16:30:00 | SPY | ETF | 111.75 | 111.75 | 111.65 | 111.71 | 172400.0 |
| 2004-09-30 17:00:00 | SPY | ETF | 111.71 | 111.81 | 111.71 | 111.75 | 62000.0 |
| 2004-09-30 17:30:00 | SPY | ETF | 111.78 | 111.8 | 111.78 | 111.8 | 3600.0 |
| 2004-09-30 18:00:00 | SPY | ETF | 111.81 | 111.81 | 111.79 | 111.81 | 15300.0 |
| 2004-09-30 18:30:00 | SPY | ETF | 111.81 | 111.81 | 111.81 | 111.81 | 200.0 |
| 2004-09-30 19:00:00 | SPY | ETF | 111.8 | 111.8 | 111.8 | 111.8 | 1000.0 |
| 2004-09-30 19:30:00 | SPY | ETF | 111.79 | 111.79 | 111.79 | 111.79 | 300.0 |
| 2004-09-30 08:00:00 | QQQ | ETF | 35.14 | 35.15 | 35.11 | 35.11 | 59600.0 |
| 2004-09-30 08:30:00 | QQQ | ETF | 35.11 | 35.14 | 35.05 | 35.06 | 165000.0 |
| 2004-09-30 09:00:00 | QQQ | ETF | 35.05 | 35.05 | 35.01 | 35.02 | 266200.0 |
| 2004-09-30 09:30:00 | QQQ | ETF | 35.02 | 35.24 | 34.99 | 35.172 | 13095000.0 |
| 2004-09-30 10:00:00 | QQQ | ETF | 35.173 | 35.27 | 35.11 | 35.15 | 7849200.0 |
| 2004-09-30 10:30:00 | QQQ | ETF | 35.15 | 35.2 | 35.07 | 35.092 | 6428600.0 |
| 2004-09-30 11:00:00 | QQQ | ETF | 35.098 | 35.116 | 35.01 | 35.06 | 4992300.0 |
| 2004-09-30 11:30:00 | QQQ | ETF | 35.05 | 35.07 | 34.91 | 34.93 | 5040700.0 |
| 2004-09-30 12:00:00 | QQQ | ETF | 34.93 | 34.991 | 34.89 | 34.965 | 3067800.0 |
| 2004-09-30 12:30:00 | QQQ | ETF | 34.965 | 35.02 | 34.96 | 34.988 | 2630300.0 |
| 2004-09-30 13:00:00 | QQQ | ETF | 34.99 | 35.07 | 34.95 | 35.057 | 3200200.0 |
| 2004-09-30 13:30:00 | QQQ | ETF | 35.057 | 35.17 | 35.03 | 35.13 | 3204200.0 |
| 2004-09-30 14:00:00 | QQQ | ETF | 35.13 | 35.183 | 35.1 | 35.17 | 3428100.0 |
| 2004-09-30 14:30:00 | QQQ | ETF | 35.18 | 35.23 | 35.11 | 35.22 | 3017500.0 |
| 2004-09-30 15:00:00 | QQQ | ETF | 35.21 | 35.25 | 35.07 | 35.08 | 6077200.0 |
| 2004-09-30 15:30:00 | QQQ | ETF | 35.08 | 35.17 | 35.05 | 35.12 | 7108000.0 |
| 2004-09-30 16:00:00 | QQQ | ETF | 35.12 | 35.1696 | 35.05 | 35.08 | 2680400.0 |
| 2004-09-30 16:30:00 | QQQ | ETF | 35.099 | 35.11 | 35.08 | 35.11 | 125900.0 |
| 2004-09-30 17:00:00 | QQQ | ETF | 35.1 | 35.15 | 35.09 | 35.15 | 164200.0 |
| 2004-09-30 17:30:00 | QQQ | ETF | 35.14 | 35.14 | 35.12 | 35.12 | 28100.0 |
| 2004-09-30 18:00:00 | QQQ | ETF | 35.11 | 35.14 | 35.1 | 35.12 | 128400.0 |
| 2004-09-30 19:30:00 | QQQ | ETF | 35.13 | 35.14 | 35.13 | 35.14 | 800.0 |
| 2004-09-30 08:30:00 | IWM | ETF | 56.88 | 56.9 | 56.88 | 56.88 | 50600.0 |
| 2004-09-30 09:00:00 | IWM | ETF | 56.88 | 56.88 | 56.88 | 56.88 | 67400.0 |
| 2004-09-30 09:30:00 | IWM | ETF | 56.67 | 57.125 | 56.655 | 57.065 | 4440000.0 |
| 2004-09-30 10:00:00 | IWM | ETF | 57.065 | 57.2 | 57.015 | 57.095 | 790200.0 |
> showing 50 of 1,201 rows — these rows as CSV