PREVIEW / etf_30min / 2006-06-15
file: by_date/etf_30min/2006/2006-06-15.parquet size: 71 KB rows: 2,463
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-15 04:00:00 | SPY | ETF | 123.83 | 123.92 | 123.83 | 123.92 | 2000.0 |
| 2006-06-15 04:30:00 | SPY | ETF | 124.0 | 124.0 | 124.0 | 124.0 | 1000.0 |
| 2006-06-15 05:00:00 | SPY | ETF | 124.07 | 124.1 | 124.07 | 124.1 | 2000.0 |
| 2006-06-15 05:30:00 | SPY | ETF | 124.1 | 124.15 | 124.1 | 124.15 | 1100.0 |
| 2006-06-15 06:00:00 | SPY | ETF | 124.12 | 124.12 | 124.06 | 124.06 | 1600.0 |
| 2006-06-15 06:30:00 | SPY | ETF | 123.99 | 124.1 | 123.99 | 124.1 | 2200.0 |
| 2006-06-15 07:00:00 | SPY | ETF | 124.03 | 124.1 | 123.99 | 124.1 | 38300.0 |
| 2006-06-15 07:30:00 | SPY | ETF | 124.05 | 124.1 | 124.01 | 124.08 | 205300.0 |
| 2006-06-15 08:00:00 | SPY | ETF | 124.1 | 124.16 | 123.76 | 124.09 | 2412100.0 |
| 2006-06-15 08:30:00 | SPY | ETF | 124.09 | 124.09 | 123.77 | 123.92 | 3285400.0 |
| 2006-06-15 09:00:00 | SPY | ETF | 123.91 | 123.99 | 123.88 | 123.9 | 1277800.0 |
| 2006-06-15 09:30:00 | SPY | ETF | 123.92 | 124.38 | 123.86 | 124.32 | 13814700.0 |
| 2006-06-15 10:00:00 | SPY | ETF | 124.32 | 124.51 | 124.14 | 124.33 | 12386700.0 |
| 2006-06-15 10:30:00 | SPY | ETF | 124.34 | 124.84 | 124.31 | 124.68 | 7177400.0 |
| 2006-06-15 11:00:00 | SPY | ETF | 124.69 | 124.88 | 124.32 | 124.7 | 3759000.0 |
| 2006-06-15 11:30:00 | SPY | ETF | 124.71 | 124.75 | 124.5 | 124.72 | 5243200.0 |
| 2006-06-15 12:00:00 | SPY | ETF | 124.7 | 124.72 | 124.55 | 124.66 | 3294500.0 |
| 2006-06-15 12:30:00 | SPY | ETF | 124.66 | 124.76 | 124.59 | 124.61 | 7376500.0 |
| 2006-06-15 13:00:00 | SPY | ETF | 124.6 | 124.69 | 124.49 | 124.5 | 3483100.0 |
| 2006-06-15 13:30:00 | SPY | ETF | 124.51 | 124.8 | 124.31 | 124.8 | 8089500.0 |
| 2006-06-15 14:00:00 | SPY | ETF | 124.78 | 125.29 | 124.78 | 125.1501 | 12829400.0 |
| 2006-06-15 14:30:00 | SPY | ETF | 125.15 | 125.73 | 125.13 | 125.65 | 9095000.0 |
| 2006-06-15 15:00:00 | SPY | ETF | 125.66 | 125.86 | 125.2 | 125.74 | 6502200.0 |
| 2006-06-15 15:30:00 | SPY | ETF | 125.74 | 126.36 | 124.09 | 126.0 | 21621600.0 |
| 2006-06-15 16:00:00 | SPY | ETF | 126.0 | 126.26 | 125.95 | 126.08 | 2632400.0 |
| 2006-06-15 16:30:00 | SPY | ETF | 126.08 | 126.18 | 124.8133 | 126.06 | 2880400.0 |
| 2006-06-15 17:00:00 | SPY | ETF | 126.05 | 126.16 | 126.02 | 126.08 | 178800.0 |
| 2006-06-15 17:30:00 | SPY | ETF | 126.12 | 126.12 | 125.9 | 125.9 | 230500.0 |
| 2006-06-15 18:00:00 | SPY | ETF | 125.9 | 126.08 | 125.68 | 125.9 | 346600.0 |
| 2006-06-15 18:30:00 | SPY | ETF | 125.98 | 126.06 | 125.98 | 126.06 | 3500.0 |
| 2006-06-15 19:00:00 | SPY | ETF | 126.01 | 126.01 | 126.01 | 126.01 | 6000.0 |
| 2006-06-15 19:30:00 | SPY | ETF | 125.98 | 126.09 | 125.98 | 126.09 | 7600.0 |
| 2006-06-15 09:30:00 | QQQ | ETF | 37.84 | 38.0 | 37.8 | 37.98 | 24237900.0 |
| 2006-06-15 10:00:00 | QQQ | ETF | 37.97 | 38.13 | 37.91 | 38.05 | 24227100.0 |
| 2006-06-15 10:30:00 | QQQ | ETF | 38.05 | 38.24 | 38.03 | 38.17 | 12787200.0 |
| 2006-06-15 11:00:00 | QQQ | ETF | 38.17 | 38.28 | 38.06 | 38.21 | 11885500.0 |
| 2006-06-15 11:30:00 | QQQ | ETF | 38.21 | 38.21 | 38.13 | 38.19 | 6354200.0 |
| 2006-06-15 12:00:00 | QQQ | ETF | 38.18 | 38.19 | 38.1 | 38.16 | 3983700.0 |
| 2006-06-15 12:30:00 | QQQ | ETF | 38.15 | 38.19 | 38.13 | 38.13 | 5464500.0 |
| 2006-06-15 13:00:00 | QQQ | ETF | 38.14 | 38.15 | 38.09 | 38.1 | 2585700.0 |
| 2006-06-15 13:30:00 | QQQ | ETF | 38.1 | 38.26 | 38.02 | 38.24 | 10498700.0 |
| 2006-06-15 14:00:00 | QQQ | ETF | 38.25 | 38.43 | 38.22 | 38.42 | 14656800.0 |
| 2006-06-15 14:30:00 | QQQ | ETF | 38.42 | 38.6 | 38.39 | 38.56 | 19167800.0 |
| 2006-06-15 15:00:00 | QQQ | ETF | 38.56 | 38.66 | 38.36 | 38.62 | 13876200.0 |
| 2006-06-15 15:30:00 | QQQ | ETF | 38.61 | 38.79 | 38.6 | 38.66 | 26357900.0 |
| 2006-06-15 07:00:00 | IWM | ETF | 67.9 | 67.9 | 67.9 | 67.9 | 3200.0 |
| 2006-06-15 07:30:00 | IWM | ETF | 67.99 | 68.09 | 67.85 | 67.9 | 15500.0 |
| 2006-06-15 08:00:00 | IWM | ETF | 68.0 | 68.21 | 67.95 | 68.0 | 1149400.0 |
| 2006-06-15 08:30:00 | IWM | ETF | 68.04 | 68.07 | 67.9 | 68.04 | 1325100.0 |
| 2006-06-15 09:00:00 | IWM | ETF | 68.04 | 68.11 | 67.99 | 68.04 | 1057200.0 |
> showing 50 of 2,463 rows — these rows as CSV