PREVIEW / etf_30min / 2006-12-27
file: by_date/etf_30min/2006/2006-12-27.parquet size: 87 KB rows: 3,118
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-12-27 04:00:00 | SPY | ETF | 142.1 | 142.1 | 142.09 | 142.09 | 1700.0 |
| 2006-12-27 06:00:00 | SPY | ETF | 142.17 | 142.17 | 142.17 | 142.17 | 5000.0 |
| 2006-12-27 06:30:00 | SPY | ETF | 142.11 | 142.11 | 142.06 | 142.06 | 80000.0 |
| 2006-12-27 07:00:00 | SPY | ETF | 142.1 | 142.13 | 142.1 | 142.12 | 20400.0 |
| 2006-12-27 07:30:00 | SPY | ETF | 142.05 | 142.06 | 142.01 | 142.01 | 700.0 |
| 2006-12-27 08:00:00 | SPY | ETF | 142.03 | 142.1 | 141.95 | 141.96 | 345600.0 |
| 2006-12-27 08:30:00 | SPY | ETF | 141.97 | 142.01 | 141.95 | 142.0 | 45600.0 |
| 2006-12-27 09:00:00 | SPY | ETF | 142.02 | 142.02 | 141.85 | 141.86 | 189300.0 |
| 2006-12-27 09:30:00 | SPY | ETF | 141.87 | 142.34 | 141.83 | 142.13 | 6550400.0 |
| 2006-12-27 10:00:00 | SPY | ETF | 142.13 | 142.25 | 141.99 | 142.16 | 5844300.0 |
| 2006-12-27 10:30:00 | SPY | ETF | 142.16 | 142.2 | 141.97 | 142.17 | 2942800.0 |
| 2006-12-27 11:00:00 | SPY | ETF | 142.17 | 142.29 | 142.15 | 142.21 | 2016100.0 |
| 2006-12-27 11:30:00 | SPY | ETF | 142.21 | 142.3 | 142.15 | 142.21 | 1501700.0 |
| 2006-12-27 12:00:00 | SPY | ETF | 142.21 | 142.24 | 142.16 | 142.18 | 1379800.0 |
| 2006-12-27 12:30:00 | SPY | ETF | 142.17 | 142.26 | 142.15 | 142.17 | 931500.0 |
| 2006-12-27 13:00:00 | SPY | ETF | 142.17 | 142.23 | 142.16 | 142.22 | 620100.0 |
| 2006-12-27 13:30:00 | SPY | ETF | 142.23 | 142.31 | 142.2 | 142.3 | 1077600.0 |
| 2006-12-27 14:00:00 | SPY | ETF | 142.29 | 142.45 | 142.28 | 142.37 | 3042200.0 |
| 2006-12-27 14:30:00 | SPY | ETF | 142.36 | 142.46 | 142.35 | 142.43 | 1910900.0 |
| 2006-12-27 15:00:00 | SPY | ETF | 142.438 | 142.56 | 142.42 | 142.5 | 2262200.0 |
| 2006-12-27 15:30:00 | SPY | ETF | 142.5 | 142.6 | 142.44 | 142.59 | 3387300.0 |
| 2006-12-27 16:00:00 | SPY | ETF | 142.6 | 142.6 | 142.48 | 142.5 | 696800.0 |
| 2006-12-27 16:30:00 | SPY | ETF | 142.51 | 142.52 | 142.42 | 142.44 | 1939400.0 |
| 2006-12-27 17:00:00 | SPY | ETF | 142.46 | 142.46 | 142.45 | 142.45 | 6500.0 |
| 2006-12-27 17:30:00 | SPY | ETF | 142.4 | 142.51 | 142.29 | 142.38 | 772200.0 |
| 2006-12-27 18:00:00 | SPY | ETF | 142.45 | 142.45 | 142.42 | 142.42 | 4600.0 |
| 2006-12-27 18:30:00 | SPY | ETF | 142.43 | 142.43 | 142.42 | 142.43 | 2000.0 |
| 2006-12-27 19:00:00 | SPY | ETF | 142.45 | 142.46 | 142.45 | 142.46 | 800.0 |
| 2006-12-27 19:30:00 | SPY | ETF | 142.46 | 142.46 | 142.45 | 142.45 | 1500.0 |
| 2006-12-27 09:30:00 | QQQ | ETF | 43.19 | 43.35 | 43.16 | 43.27 | 10736900.0 |
| 2006-12-27 10:00:00 | QQQ | ETF | 43.26 | 43.31 | 43.15 | 43.21 | 6487300.0 |
| 2006-12-27 10:30:00 | QQQ | ETF | 43.21 | 43.24 | 43.1 | 43.23 | 4908700.0 |
| 2006-12-27 11:00:00 | QQQ | ETF | 43.23 | 43.28 | 43.21 | 43.28 | 3721000.0 |
| 2006-12-27 11:30:00 | QQQ | ETF | 43.27 | 43.33 | 43.24 | 43.28 | 2325400.0 |
| 2006-12-27 12:00:00 | QQQ | ETF | 43.28 | 43.31 | 43.27 | 43.3 | 1203000.0 |
| 2006-12-27 12:30:00 | QQQ | ETF | 43.31 | 43.35 | 43.27 | 43.31 | 3323600.0 |
| 2006-12-27 13:00:00 | QQQ | ETF | 43.31 | 43.34 | 43.28 | 43.34 | 2931900.0 |
| 2006-12-27 13:30:00 | QQQ | ETF | 43.34 | 43.35 | 43.29 | 43.33 | 1517100.0 |
| 2006-12-27 14:00:00 | QQQ | ETF | 43.34 | 43.38 | 43.31 | 43.32 | 3502300.0 |
| 2006-12-27 14:30:00 | QQQ | ETF | 43.32 | 43.36 | 43.3 | 43.35 | 1865600.0 |
| 2006-12-27 15:00:00 | QQQ | ETF | 43.35 | 43.4 | 43.34 | 43.34 | 2465900.0 |
| 2006-12-27 15:30:00 | QQQ | ETF | 43.34 | 43.38 | 43.32 | 43.34 | 4945000.0 |
| 2006-12-27 08:00:00 | IWM | ETF | 78.52 | 78.54 | 78.41 | 78.42 | 64700.0 |
| 2006-12-27 08:30:00 | IWM | ETF | 78.42 | 78.45 | 78.42 | 78.45 | 55500.0 |
| 2006-12-27 09:00:00 | IWM | ETF | 78.44 | 78.44 | 78.36 | 78.37 | 23300.0 |
| 2006-12-27 09:30:00 | IWM | ETF | 78.37 | 78.93 | 78.35 | 78.76 | 8834100.0 |
| 2006-12-27 10:00:00 | IWM | ETF | 78.76 | 78.92 | 78.64 | 78.75 | 5166000.0 |
| 2006-12-27 10:30:00 | IWM | ETF | 78.7494 | 78.88 | 78.58 | 78.87 | 3648700.0 |
| 2006-12-27 11:00:00 | IWM | ETF | 78.87 | 78.98 | 78.86 | 78.91 | 3295400.0 |
| 2006-12-27 11:30:00 | IWM | ETF | 78.91 | 78.97 | 78.83 | 78.87 | 1972300.0 |
> showing 50 of 3,118 rows — these rows as CSV