PREVIEW / etf_30min / 2006-02-16
file: by_date/etf_30min/2006/2006-02-16.parquet size: 60 KB rows: 2,152
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-16 07:00:00 | SPY | ETF | 128.22 | 128.22 | 128.22 | 128.22 | 4000.0 |
| 2006-02-16 07:30:00 | SPY | ETF | 128.29 | 128.31 | 128.29 | 128.31 | 9400.0 |
| 2006-02-16 08:00:00 | SPY | ETF | 128.31 | 128.34 | 128.2 | 128.28 | 657600.0 |
| 2006-02-16 08:30:00 | SPY | ETF | 128.25 | 128.36 | 128.2 | 128.33 | 2353800.0 |
| 2006-02-16 09:00:00 | SPY | ETF | 128.33 | 128.4 | 128.32 | 128.34 | 937700.0 |
| 2006-02-16 09:30:00 | SPY | ETF | 128.34 | 128.48 | 128.23 | 128.24 | 6685000.0 |
| 2006-02-16 10:00:00 | SPY | ETF | 128.24 | 128.42 | 128.2 | 128.35 | 4818600.0 |
| 2006-02-16 10:30:00 | SPY | ETF | 128.35 | 128.38 | 128.18 | 128.32 | 3317500.0 |
| 2006-02-16 11:00:00 | SPY | ETF | 128.32 | 128.46 | 128.3 | 128.46 | 2661400.0 |
| 2006-02-16 11:30:00 | SPY | ETF | 128.46 | 128.65 | 128.46 | 128.59 | 7845300.0 |
| 2006-02-16 12:00:00 | SPY | ETF | 128.59 | 128.86 | 128.51 | 128.8099 | 6935100.0 |
| 2006-02-16 12:30:00 | SPY | ETF | 128.81 | 128.85 | 128.71 | 128.76 | 1564800.0 |
| 2006-02-16 13:00:00 | SPY | ETF | 128.75 | 128.79 | 128.62 | 128.66 | 2013900.0 |
| 2006-02-16 13:30:00 | SPY | ETF | 128.66 | 128.83 | 128.47 | 128.57 | 4039800.0 |
| 2006-02-16 14:00:00 | SPY | ETF | 128.56 | 128.67 | 128.5 | 128.55 | 1783900.0 |
| 2006-02-16 14:30:00 | SPY | ETF | 128.55 | 128.7 | 128.39 | 128.69 | 2483100.0 |
| 2006-02-16 15:00:00 | SPY | ETF | 128.69 | 128.83 | 128.67 | 128.78 | 2729500.0 |
| 2006-02-16 15:30:00 | SPY | ETF | 128.77 | 129.12 | 128.77 | 129.08 | 6394300.0 |
| 2006-02-16 16:00:00 | SPY | ETF | 129.07 | 129.21 | 129.06 | 129.09 | 2294900.0 |
| 2006-02-16 16:30:00 | SPY | ETF | 129.13 | 129.15 | 129.07 | 129.1 | 155200.0 |
| 2006-02-16 17:00:00 | SPY | ETF | 129.13 | 129.13 | 129.1 | 129.1 | 3700.0 |
| 2006-02-16 17:30:00 | SPY | ETF | 129.11 | 129.13 | 129.09 | 129.13 | 1600.0 |
| 2006-02-16 18:00:00 | SPY | ETF | 129.12 | 129.12 | 129.12 | 129.12 | 100.0 |
| 2006-02-16 18:30:00 | SPY | ETF | 129.12 | 129.14 | 129.12 | 129.14 | 17200.0 |
| 2006-02-16 19:30:00 | SPY | ETF | 129.08 | 129.08 | 129.08 | 129.08 | 100.0 |
| 2006-02-16 09:30:00 | QQQ | ETF | 41.3 | 41.45 | 41.23 | 41.24 | 17500800.0 |
| 2006-02-16 10:00:00 | QQQ | ETF | 41.25 | 41.35 | 41.23 | 41.31 | 3984000.0 |
| 2006-02-16 10:30:00 | QQQ | ETF | 41.31 | 41.33 | 41.24 | 41.28 | 3075100.0 |
| 2006-02-16 11:00:00 | QQQ | ETF | 41.27 | 41.41 | 41.27 | 41.4 | 4946900.0 |
| 2006-02-16 11:30:00 | QQQ | ETF | 41.4 | 41.5 | 41.4 | 41.45 | 6495900.0 |
| 2006-02-16 12:00:00 | QQQ | ETF | 41.45 | 41.54 | 41.44 | 41.54 | 5256200.0 |
| 2006-02-16 12:30:00 | QQQ | ETF | 41.54 | 41.55 | 41.45 | 41.47 | 3404600.0 |
| 2006-02-16 13:00:00 | QQQ | ETF | 41.46 | 41.49 | 41.39 | 41.41 | 2895500.0 |
| 2006-02-16 13:30:00 | QQQ | ETF | 41.41 | 41.47 | 41.2 | 41.27 | 7888200.0 |
| 2006-02-16 14:00:00 | QQQ | ETF | 41.27 | 41.36 | 41.24 | 41.26 | 5329200.0 |
| 2006-02-16 14:30:00 | QQQ | ETF | 41.25 | 41.38 | 41.15 | 41.36 | 13118200.0 |
| 2006-02-16 15:00:00 | QQQ | ETF | 41.37 | 41.43 | 41.3 | 41.41 | 8339000.0 |
| 2006-02-16 15:30:00 | QQQ | ETF | 41.42 | 41.54 | 41.41 | 41.54 | 9103800.0 |
| 2006-02-16 08:30:00 | IWM | ETF | 72.28 | 72.33 | 72.28 | 72.3 | 22600.0 |
| 2006-02-16 09:00:00 | IWM | ETF | 72.3 | 72.39 | 72.29 | 72.36 | 48900.0 |
| 2006-02-16 09:30:00 | IWM | ETF | 72.37 | 72.58 | 72.24 | 72.25 | 4424000.0 |
| 2006-02-16 10:00:00 | IWM | ETF | 72.25 | 72.51 | 72.16 | 72.34 | 3369500.0 |
| 2006-02-16 10:30:00 | IWM | ETF | 72.33 | 72.39 | 72.12 | 72.32 | 2154000.0 |
| 2006-02-16 11:00:00 | IWM | ETF | 72.32 | 72.46 | 72.31 | 72.44 | 1370300.0 |
| 2006-02-16 11:30:00 | IWM | ETF | 72.44 | 72.58 | 72.44 | 72.48 | 1555200.0 |
| 2006-02-16 12:00:00 | IWM | ETF | 72.49 | 72.65 | 72.43 | 72.58 | 1485800.0 |
| 2006-02-16 12:30:00 | IWM | ETF | 72.58 | 72.65 | 72.54 | 72.58 | 943800.0 |
| 2006-02-16 13:00:00 | IWM | ETF | 72.58 | 72.61 | 72.51 | 72.54 | 1479800.0 |
| 2006-02-16 13:30:00 | IWM | ETF | 72.53 | 72.58 | 72.36 | 72.43 | 2716400.0 |
| 2006-02-16 14:00:00 | IWM | ETF | 72.41 | 72.45 | 72.32 | 72.34 | 1652800.0 |
> showing 50 of 2,152 rows — these rows as CSV