PREVIEW / etf_30min / 2006-02-09
file: by_date/etf_30min/2006/2006-02-09.parquet size: 59 KB rows: 2,154
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-02-09 06:00:00 | SPY | ETF | 126.83 | 126.83 | 126.83 | 126.83 | 300.0 |
| 2006-02-09 07:00:00 | SPY | ETF | 126.84 | 126.84 | 126.8 | 126.8 | 10300.0 |
| 2006-02-09 07:30:00 | SPY | ETF | 126.82 | 126.83 | 126.78 | 126.83 | 66900.0 |
| 2006-02-09 08:00:00 | SPY | ETF | 126.81 | 126.88 | 126.75 | 126.87 | 645100.0 |
| 2006-02-09 08:30:00 | SPY | ETF | 126.86 | 126.92 | 126.5 | 126.9 | 383400.0 |
| 2006-02-09 09:00:00 | SPY | ETF | 126.9 | 126.95 | 126.85 | 126.91 | 244900.0 |
| 2006-02-09 09:30:00 | SPY | ETF | 126.92 | 127.24 | 126.81 | 127.18 | 6670600.0 |
| 2006-02-09 10:00:00 | SPY | ETF | 127.2 | 127.4 | 127.14 | 127.33 | 5921000.0 |
| 2006-02-09 10:30:00 | SPY | ETF | 127.32 | 127.43 | 127.16 | 127.29 | 5675100.0 |
| 2006-02-09 11:00:00 | SPY | ETF | 127.29 | 127.34 | 127.1 | 127.25 | 3153500.0 |
| 2006-02-09 11:30:00 | SPY | ETF | 127.25 | 127.34 | 127.21 | 127.26 | 3315600.0 |
| 2006-02-09 12:00:00 | SPY | ETF | 127.26 | 127.41 | 127.18 | 127.4 | 1185400.0 |
| 2006-02-09 12:30:00 | SPY | ETF | 127.4 | 127.55 | 127.29 | 127.33 | 2563000.0 |
| 2006-02-09 13:00:00 | SPY | ETF | 127.34 | 127.6 | 127.13 | 127.15 | 3608400.0 |
| 2006-02-09 13:30:00 | SPY | ETF | 127.15 | 127.36 | 127.11 | 127.26 | 3623700.0 |
| 2006-02-09 14:00:00 | SPY | ETF | 127.26 | 127.29 | 126.91 | 127.03 | 4830100.0 |
| 2006-02-09 14:30:00 | SPY | ETF | 127.03 | 127.08 | 126.91 | 126.92 | 2519600.0 |
| 2006-02-09 15:00:00 | SPY | ETF | 126.93 | 126.95 | 126.66 | 126.74 | 4751100.0 |
| 2006-02-09 15:30:00 | SPY | ETF | 126.74 | 126.75 | 126.37 | 126.5 | 8722000.0 |
| 2006-02-09 16:00:00 | SPY | ETF | 126.5 | 126.6 | 126.37 | 126.39 | 559800.0 |
| 2006-02-09 16:30:00 | SPY | ETF | 126.42 | 126.55 | 126.42 | 126.55 | 129400.0 |
| 2006-02-09 17:00:00 | SPY | ETF | 126.5 | 126.55 | 126.5 | 126.52 | 15800.0 |
| 2006-02-09 17:30:00 | SPY | ETF | 126.5 | 126.5 | 126.43 | 126.49 | 5000.0 |
| 2006-02-09 18:30:00 | SPY | ETF | 126.5 | 126.5 | 126.5 | 126.5 | 1000.0 |
| 2006-02-09 19:00:00 | SPY | ETF | 126.54 | 126.55 | 126.54 | 126.55 | 500.0 |
| 2006-02-09 09:30:00 | QQQ | ETF | 41.2 | 41.33 | 41.12 | 41.3 | 9097600.0 |
| 2006-02-09 10:00:00 | QQQ | ETF | 41.31 | 41.37 | 41.28 | 41.35 | 6409700.0 |
| 2006-02-09 10:30:00 | QQQ | ETF | 41.34 | 41.37 | 41.23 | 41.28 | 4247300.0 |
| 2006-02-09 11:00:00 | QQQ | ETF | 41.28 | 41.3 | 41.14 | 41.22 | 4916700.0 |
| 2006-02-09 11:30:00 | QQQ | ETF | 41.21 | 41.27 | 41.19 | 41.22 | 3126300.0 |
| 2006-02-09 12:00:00 | QQQ | ETF | 41.22 | 41.29 | 41.2 | 41.29 | 1811700.0 |
| 2006-02-09 12:30:00 | QQQ | ETF | 41.29 | 41.31 | 41.21 | 41.21 | 4331000.0 |
| 2006-02-09 13:00:00 | QQQ | ETF | 41.21 | 41.31 | 41.14 | 41.16 | 6172200.0 |
| 2006-02-09 13:30:00 | QQQ | ETF | 41.15 | 41.21 | 41.1 | 41.14 | 5022100.0 |
| 2006-02-09 14:00:00 | QQQ | ETF | 41.14 | 41.16 | 40.97 | 41.04 | 6933200.0 |
| 2006-02-09 14:30:00 | QQQ | ETF | 41.04 | 41.05 | 40.93 | 40.94 | 4707000.0 |
| 2006-02-09 15:00:00 | QQQ | ETF | 40.94 | 40.96 | 40.76 | 40.78 | 6225600.0 |
| 2006-02-09 15:30:00 | QQQ | ETF | 40.79 | 40.79 | 40.63 | 40.7 | 10076300.0 |
| 2006-02-09 08:00:00 | IWM | ETF | 71.74 | 71.79 | 71.74 | 71.79 | 16300.0 |
| 2006-02-09 08:30:00 | IWM | ETF | 71.79 | 71.82 | 71.74 | 71.82 | 100000.0 |
| 2006-02-09 09:00:00 | IWM | ETF | 71.82 | 71.83 | 71.78 | 71.79 | 63700.0 |
| 2006-02-09 09:30:00 | IWM | ETF | 71.78 | 72.07 | 71.66 | 72.05 | 2729200.0 |
| 2006-02-09 10:00:00 | IWM | ETF | 72.05 | 72.2 | 72.0 | 72.17 | 3092800.0 |
| 2006-02-09 10:30:00 | IWM | ETF | 72.16 | 72.23 | 72.08 | 72.18 | 2600800.0 |
| 2006-02-09 11:00:00 | IWM | ETF | 72.18 | 72.25 | 71.93 | 72.04 | 2440500.0 |
| 2006-02-09 11:30:00 | IWM | ETF | 72.04 | 72.12 | 72.02 | 72.09 | 795200.0 |
| 2006-02-09 12:00:00 | IWM | ETF | 72.09 | 72.21 | 71.99 | 72.2 | 1133900.0 |
| 2006-02-09 12:30:00 | IWM | ETF | 72.19 | 72.33 | 72.09 | 72.22 | 1366700.0 |
| 2006-02-09 13:00:00 | IWM | ETF | 72.23 | 72.34 | 72.12 | 72.132 | 1427100.0 |
| 2006-02-09 13:30:00 | IWM | ETF | 72.14 | 72.22 | 72.04 | 72.13 | 2428700.0 |
> showing 50 of 2,154 rows — these rows as CSV