PREVIEW / etf_30min / 2006-09-12
file: by_date/etf_30min/2006/2006-09-12.parquet size: 82 KB rows: 2,836
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-09-12 05:00:00 | SPY | ETF | 130.33 | 130.34 | 130.33 | 130.34 | 200.0 |
| 2006-09-12 06:30:00 | SPY | ETF | 130.21 | 130.23 | 130.17 | 130.17 | 2400.0 |
| 2006-09-12 07:00:00 | SPY | ETF | 130.19 | 130.26 | 130.19 | 130.26 | 53500.0 |
| 2006-09-12 07:30:00 | SPY | ETF | 130.24 | 130.25 | 130.19 | 130.25 | 5100.0 |
| 2006-09-12 08:00:00 | SPY | ETF | 130.17 | 130.46 | 130.17 | 130.37 | 274900.0 |
| 2006-09-12 08:30:00 | SPY | ETF | 130.35 | 130.39 | 130.27 | 130.39 | 163900.0 |
| 2006-09-12 09:00:00 | SPY | ETF | 130.33 | 130.57 | 130.32 | 130.57 | 276900.0 |
| 2006-09-12 09:30:00 | SPY | ETF | 130.56 | 130.73 | 130.51 | 130.61 | 5621600.0 |
| 2006-09-12 10:00:00 | SPY | ETF | 130.62 | 131.0 | 130.6 | 130.98 | 8165200.0 |
| 2006-09-12 10:30:00 | SPY | ETF | 130.97 | 131.03 | 130.9 | 131.0 | 5114300.0 |
| 2006-09-12 11:00:00 | SPY | ETF | 131.01 | 131.21 | 131.0 | 131.11 | 5165600.0 |
| 2006-09-12 11:30:00 | SPY | ETF | 131.1 | 131.26 | 131.1 | 131.13 | 2749900.0 |
| 2006-09-12 12:00:00 | SPY | ETF | 131.13 | 131.16 | 131.07 | 131.11 | 1849200.0 |
| 2006-09-12 12:30:00 | SPY | ETF | 131.1 | 131.18 | 130.99 | 131.15 | 1832600.0 |
| 2006-09-12 13:00:00 | SPY | ETF | 131.17 | 131.18 | 130.97 | 131.06 | 2884800.0 |
| 2006-09-12 13:30:00 | SPY | ETF | 131.06 | 131.39 | 131.05 | 131.31 | 5335900.0 |
| 2006-09-12 14:00:00 | SPY | ETF | 131.3 | 131.46 | 130.3681 | 131.43 | 3696300.0 |
| 2006-09-12 14:30:00 | SPY | ETF | 131.43 | 131.84 | 131.42 | 131.78 | 6060400.0 |
| 2006-09-12 15:00:00 | SPY | ETF | 131.78 | 131.8 | 131.63 | 131.74 | 5301200.0 |
| 2006-09-12 15:30:00 | SPY | ETF | 131.75 | 131.8 | 131.6 | 131.64 | 7545600.0 |
| 2006-09-12 16:00:00 | SPY | ETF | 131.64 | 131.8 | 131.59 | 131.74 | 4528100.0 |
| 2006-09-12 16:30:00 | SPY | ETF | 131.73 | 131.73 | 131.62 | 131.64 | 180500.0 |
| 2006-09-12 17:00:00 | SPY | ETF | 131.64 | 131.69 | 131.63 | 131.68 | 34700.0 |
| 2006-09-12 17:30:00 | SPY | ETF | 131.7 | 131.71 | 131.67 | 131.67 | 8800.0 |
| 2006-09-12 18:00:00 | SPY | ETF | 131.69 | 131.69 | 131.65 | 131.65 | 12100.0 |
| 2006-09-12 18:30:00 | SPY | ETF | 131.65 | 131.71 | 131.65 | 131.71 | 11000.0 |
| 2006-09-12 19:00:00 | SPY | ETF | 131.72 | 131.72 | 131.72 | 131.72 | 800.0 |
| 2006-09-12 09:30:00 | QQQ | ETF | 38.95 | 39.11 | 38.95 | 39.05 | 14626200.0 |
| 2006-09-12 10:00:00 | QQQ | ETF | 39.05 | 39.26 | 39.04 | 39.24 | 12095500.0 |
| 2006-09-12 10:30:00 | QQQ | ETF | 39.24 | 39.3 | 39.21 | 39.29 | 6141500.0 |
| 2006-09-12 11:00:00 | QQQ | ETF | 39.29 | 39.37 | 39.25 | 39.28 | 8421400.0 |
| 2006-09-12 11:30:00 | QQQ | ETF | 39.29 | 39.36 | 39.27 | 39.32 | 4383800.0 |
| 2006-09-12 12:00:00 | QQQ | ETF | 39.32 | 39.33 | 39.25 | 39.25 | 4056700.0 |
| 2006-09-12 12:30:00 | QQQ | ETF | 39.25 | 39.34 | 39.21 | 39.33 | 4533800.0 |
| 2006-09-12 13:00:00 | QQQ | ETF | 39.33 | 39.33 | 39.2 | 39.25 | 3938300.0 |
| 2006-09-12 13:30:00 | QQQ | ETF | 39.25 | 39.41 | 39.24 | 39.38 | 6513200.0 |
| 2006-09-12 14:00:00 | QQQ | ETF | 39.38 | 39.51 | 39.34 | 39.5 | 7204200.0 |
| 2006-09-12 14:30:00 | QQQ | ETF | 39.49 | 39.8 | 39.46 | 39.78 | 17978100.0 |
| 2006-09-12 15:00:00 | QQQ | ETF | 39.78 | 39.79 | 39.66 | 39.73 | 9448700.0 |
| 2006-09-12 15:30:00 | QQQ | ETF | 39.73 | 39.77 | 39.67 | 39.69 | 15063900.0 |
| 2006-09-12 08:00:00 | IWM | ETF | 70.46 | 70.53 | 70.4 | 70.53 | 193500.0 |
| 2006-09-12 08:30:00 | IWM | ETF | 70.5 | 70.51 | 70.42 | 70.47 | 70800.0 |
| 2006-09-12 09:00:00 | IWM | ETF | 70.49 | 70.62 | 70.46 | 70.62 | 100900.0 |
| 2006-09-12 09:30:00 | IWM | ETF | 70.64 | 70.85 | 70.58 | 70.81 | 3487700.0 |
| 2006-09-12 10:00:00 | IWM | ETF | 70.81 | 71.1 | 70.75 | 71.05 | 3708800.0 |
| 2006-09-12 10:30:00 | IWM | ETF | 71.05 | 71.12 | 70.98 | 71.1 | 1609800.0 |
| 2006-09-12 11:00:00 | IWM | ETF | 71.11 | 71.32 | 71.1 | 71.25 | 3029400.0 |
| 2006-09-12 11:30:00 | IWM | ETF | 71.26 | 71.46 | 71.25 | 71.41 | 2314200.0 |
| 2006-09-12 12:00:00 | IWM | ETF | 71.41 | 71.43 | 71.31 | 71.39 | 1509400.0 |
| 2006-09-12 12:30:00 | IWM | ETF | 71.38 | 71.56 | 71.29 | 71.52 | 1617600.0 |
> showing 50 of 2,836 rows — these rows as CSV