PREVIEW / etf_30min / 2006-05-08
file: by_date/etf_30min/2006/2006-05-08.parquet size: 62 KB rows: 2,340
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-05-08 07:00:00 | SPY | ETF | 132.61 | 132.61 | 132.5 | 132.59 | 7200.0 |
| 2006-05-08 07:30:00 | SPY | ETF | 132.6 | 132.62 | 132.58 | 132.6 | 42400.0 |
| 2006-05-08 08:00:00 | SPY | ETF | 132.59 | 132.66 | 132.56 | 132.59 | 242300.0 |
| 2006-05-08 08:30:00 | SPY | ETF | 132.57 | 132.64 | 132.54 | 132.62 | 52900.0 |
| 2006-05-08 09:00:00 | SPY | ETF | 132.6 | 132.62 | 132.47 | 132.5 | 300200.0 |
| 2006-05-08 09:30:00 | SPY | ETF | 132.51 | 132.77 | 132.46 | 132.69 | 3598500.0 |
| 2006-05-08 10:00:00 | SPY | ETF | 132.69 | 132.75 | 132.62 | 132.73 | 2319400.0 |
| 2006-05-08 10:30:00 | SPY | ETF | 132.73 | 132.77 | 132.45 | 132.49 | 2684600.0 |
| 2006-05-08 11:00:00 | SPY | ETF | 132.47 | 132.57 | 132.37 | 132.43 | 3590800.0 |
| 2006-05-08 11:30:00 | SPY | ETF | 132.41 | 132.54 | 132.4 | 132.47 | 1541300.0 |
| 2006-05-08 12:00:00 | SPY | ETF | 132.46 | 132.52 | 132.42 | 132.48 | 989600.0 |
| 2006-05-08 12:30:00 | SPY | ETF | 132.48 | 132.66 | 132.45 | 132.6 | 1516100.0 |
| 2006-05-08 13:00:00 | SPY | ETF | 132.6 | 132.63 | 132.57 | 132.6 | 339700.0 |
| 2006-05-08 13:30:00 | SPY | ETF | 132.59 | 132.65 | 132.55 | 132.62 | 749600.0 |
| 2006-05-08 14:00:00 | SPY | ETF | 132.62 | 132.72 | 132.57 | 132.69 | 1413100.0 |
| 2006-05-08 14:30:00 | SPY | ETF | 132.68 | 132.77 | 132.64 | 132.71 | 1014300.0 |
| 2006-05-08 15:00:00 | SPY | ETF | 132.72 | 132.73 | 132.52 | 132.61 | 1543900.0 |
| 2006-05-08 15:30:00 | SPY | ETF | 132.6 | 132.65 | 132.51 | 132.56 | 2100700.0 |
| 2006-05-08 16:00:00 | SPY | ETF | 132.55 | 132.57 | 132.34 | 132.37 | 2534000.0 |
| 2006-05-08 16:30:00 | SPY | ETF | 132.39 | 132.42 | 132.36 | 132.36 | 326100.0 |
| 2006-05-08 17:00:00 | SPY | ETF | 132.37 | 132.37 | 132.36 | 132.37 | 5500.0 |
| 2006-05-08 17:30:00 | SPY | ETF | 132.38 | 132.38 | 132.38 | 132.38 | 200.0 |
| 2006-05-08 18:00:00 | SPY | ETF | 132.39 | 132.39 | 132.39 | 132.39 | 600.0 |
| 2006-05-08 19:00:00 | SPY | ETF | 132.37 | 132.38 | 132.37 | 132.38 | 800.0 |
| 2006-05-08 09:30:00 | QQQ | ETF | 42.1 | 42.26 | 42.07 | 42.23 | 9907600.0 |
| 2006-05-08 10:00:00 | QQQ | ETF | 42.24 | 42.28 | 42.19 | 42.23 | 3017600.0 |
| 2006-05-08 10:30:00 | QQQ | ETF | 42.24 | 42.26 | 42.13 | 42.15 | 4851100.0 |
| 2006-05-08 11:00:00 | QQQ | ETF | 42.15 | 42.19 | 42.1 | 42.11 | 2921300.0 |
| 2006-05-08 11:30:00 | QQQ | ETF | 42.11 | 42.21 | 42.1 | 42.16 | 2856800.0 |
| 2006-05-08 12:00:00 | QQQ | ETF | 42.15 | 42.19 | 42.13 | 42.15 | 1216700.0 |
| 2006-05-08 12:30:00 | QQQ | ETF | 42.16 | 42.25 | 42.16 | 42.22 | 2358600.0 |
| 2006-05-08 13:00:00 | QQQ | ETF | 42.22 | 42.23 | 42.2 | 42.22 | 675700.0 |
| 2006-05-08 13:30:00 | QQQ | ETF | 42.22 | 42.22 | 42.17 | 42.18 | 823700.0 |
| 2006-05-08 14:00:00 | QQQ | ETF | 42.19 | 42.24 | 42.18 | 42.22 | 1331400.0 |
| 2006-05-08 14:30:00 | QQQ | ETF | 42.22 | 42.25 | 42.19 | 42.23 | 2786300.0 |
| 2006-05-08 15:00:00 | QQQ | ETF | 42.22 | 42.23 | 42.16 | 42.19 | 1600400.0 |
| 2006-05-08 15:30:00 | QQQ | ETF | 42.18 | 42.21 | 42.18 | 42.19 | 3368900.0 |
| 2006-05-08 06:30:00 | IWM | ETF | 77.5 | 77.5 | 77.5 | 77.5 | 500.0 |
| 2006-05-08 07:00:00 | IWM | ETF | 77.15 | 77.2 | 77.15 | 77.2 | 200.0 |
| 2006-05-08 07:30:00 | IWM | ETF | 77.3 | 77.5 | 77.3 | 77.5 | 400.0 |
| 2006-05-08 08:00:00 | IWM | ETF | 77.52 | 77.62 | 77.52 | 77.55 | 6600.0 |
| 2006-05-08 08:30:00 | IWM | ETF | 77.53 | 77.59 | 77.53 | 77.59 | 9300.0 |
| 2006-05-08 09:00:00 | IWM | ETF | 77.59 | 77.59 | 77.5 | 77.52 | 13800.0 |
| 2006-05-08 09:30:00 | IWM | ETF | 77.52 | 77.74 | 77.39 | 77.59 | 4006300.0 |
| 2006-05-08 10:00:00 | IWM | ETF | 77.59 | 77.77 | 77.59 | 77.75 | 1783400.0 |
| 2006-05-08 10:30:00 | IWM | ETF | 77.74 | 77.78 | 77.45 | 77.48 | 1825700.0 |
| 2006-05-08 11:00:00 | IWM | ETF | 77.48 | 77.57 | 77.33 | 77.4 | 1943300.0 |
| 2006-05-08 11:30:00 | IWM | ETF | 77.4 | 77.64 | 77.38 | 77.5 | 1757600.0 |
| 2006-05-08 12:00:00 | IWM | ETF | 77.49 | 77.56 | 77.47 | 77.51 | 434200.0 |
| 2006-05-08 12:30:00 | IWM | ETF | 77.51 | 77.74 | 77.48 | 77.69 | 2286600.0 |
> showing 50 of 2,340 rows — these rows as CSV