PREVIEW / etf_30min / 2006-04-11
file: by_date/etf_30min/2006/2006-04-11.parquet size: 62 KB rows: 2,229
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-04-11 06:30:00 | SPY | ETF | 129.51 | 129.51 | 129.51 | 129.51 | 3000.0 |
| 2006-04-11 07:00:00 | SPY | ETF | 129.53 | 129.61 | 129.53 | 129.61 | 27800.0 |
| 2006-04-11 07:30:00 | SPY | ETF | 129.58 | 129.64 | 129.58 | 129.61 | 166100.0 |
| 2006-04-11 08:00:00 | SPY | ETF | 129.64 | 129.86 | 129.51 | 129.86 | 464400.0 |
| 2006-04-11 08:30:00 | SPY | ETF | 129.85 | 129.9 | 129.77 | 129.88 | 533200.0 |
| 2006-04-11 09:00:00 | SPY | ETF | 129.85 | 129.87 | 129.83 | 129.85 | 114400.0 |
| 2006-04-11 09:30:00 | SPY | ETF | 129.85 | 130.06 | 129.63 | 129.681 | 5818700.0 |
| 2006-04-11 10:00:00 | SPY | ETF | 129.68 | 129.76 | 129.0 | 129.13 | 9063700.0 |
| 2006-04-11 10:30:00 | SPY | ETF | 129.13 | 129.18 | 128.67 | 128.91 | 11227100.0 |
| 2006-04-11 11:00:00 | SPY | ETF | 128.9 | 129.1 | 128.85 | 128.98 | 4395700.0 |
| 2006-04-11 11:30:00 | SPY | ETF | 128.98 | 129.03 | 128.76 | 128.81 | 3100000.0 |
| 2006-04-11 12:00:00 | SPY | ETF | 128.81 | 128.9 | 128.67 | 128.86 | 2813900.0 |
| 2006-04-11 12:30:00 | SPY | ETF | 128.87 | 128.98 | 128.79 | 128.8 | 1364800.0 |
| 2006-04-11 13:00:00 | SPY | ETF | 128.79 | 129.0 | 128.76 | 128.87 | 1622200.0 |
| 2006-04-11 13:30:00 | SPY | ETF | 128.89 | 128.92 | 128.57 | 128.68 | 4525500.0 |
| 2006-04-11 14:00:00 | SPY | ETF | 128.68 | 128.82 | 128.56 | 128.69 | 2527800.0 |
| 2006-04-11 14:30:00 | SPY | ETF | 128.68 | 128.87 | 128.54 | 128.59 | 3645300.0 |
| 2006-04-11 15:00:00 | SPY | ETF | 128.59 | 128.6 | 128.25 | 128.38 | 9304000.0 |
| 2006-04-11 15:30:00 | SPY | ETF | 128.38 | 129.6617 | 128.32 | 128.65 | 8608000.0 |
| 2006-04-11 16:00:00 | SPY | ETF | 128.65 | 128.7 | 128.57 | 128.65 | 1098400.0 |
| 2006-04-11 16:30:00 | SPY | ETF | 128.67 | 128.78 | 128.64 | 128.73 | 453100.0 |
| 2006-04-11 17:00:00 | SPY | ETF | 128.78 | 128.78 | 128.64 | 128.64 | 194800.0 |
| 2006-04-11 17:30:00 | SPY | ETF | 128.74 | 128.81 | 128.64 | 128.75 | 20700.0 |
| 2006-04-11 18:00:00 | SPY | ETF | 128.75 | 128.77 | 128.72 | 128.72 | 4600.0 |
| 2006-04-11 18:30:00 | SPY | ETF | 128.74 | 128.8 | 128.74 | 128.8 | 1000.0 |
| 2006-04-11 19:00:00 | SPY | ETF | 128.78 | 128.78 | 128.73 | 128.73 | 1200.0 |
| 2006-04-11 19:30:00 | SPY | ETF | 128.73 | 128.73 | 128.73 | 128.73 | 100.0 |
| 2006-04-11 09:30:00 | QQQ | ETF | 42.4 | 42.43 | 42.17 | 42.18 | 9203700.0 |
| 2006-04-11 10:00:00 | QQQ | ETF | 42.18 | 42.25 | 42.0 | 42.03 | 9778400.0 |
| 2006-04-11 10:30:00 | QQQ | ETF | 42.03 | 42.03 | 41.8 | 41.9 | 13664300.0 |
| 2006-04-11 11:00:00 | QQQ | ETF | 41.9 | 41.98 | 41.87 | 41.95 | 6663800.0 |
| 2006-04-11 11:30:00 | QQQ | ETF | 41.94 | 41.99 | 41.87 | 41.88 | 4264300.0 |
| 2006-04-11 12:00:00 | QQQ | ETF | 41.88 | 41.88 | 41.82 | 41.87 | 3357900.0 |
| 2006-04-11 12:30:00 | QQQ | ETF | 41.87 | 41.91 | 41.86 | 41.88 | 2075200.0 |
| 2006-04-11 13:00:00 | QQQ | ETF | 41.88 | 41.98 | 41.87 | 41.94 | 3477400.0 |
| 2006-04-11 13:30:00 | QQQ | ETF | 41.93 | 41.95 | 41.83 | 41.86 | 4254500.0 |
| 2006-04-11 14:00:00 | QQQ | ETF | 41.85 | 41.93 | 41.84 | 41.88 | 2575300.0 |
| 2006-04-11 14:30:00 | QQQ | ETF | 41.88 | 41.99 | 41.85 | 41.85 | 6047500.0 |
| 2006-04-11 15:00:00 | QQQ | ETF | 41.86 | 41.86 | 41.71 | 41.74 | 6736500.0 |
| 2006-04-11 15:30:00 | QQQ | ETF | 41.75 | 41.93 | 41.74 | 41.93 | 8735900.0 |
| 2006-04-11 08:00:00 | IWM | ETF | 74.76 | 75.0 | 74.76 | 75.0 | 511100.0 |
| 2006-04-11 08:30:00 | IWM | ETF | 75.0 | 75.05 | 74.99 | 74.99 | 57400.0 |
| 2006-04-11 09:00:00 | IWM | ETF | 74.98 | 75.02 | 74.96 | 75.01 | 84200.0 |
| 2006-04-11 09:30:00 | IWM | ETF | 75.0 | 75.06 | 74.56 | 74.56 | 3545000.0 |
| 2006-04-11 10:00:00 | IWM | ETF | 74.55 | 74.57 | 74.15 | 74.16 | 6006100.0 |
| 2006-04-11 10:30:00 | IWM | ETF | 74.17 | 74.22 | 73.83 | 73.86 | 6205300.0 |
| 2006-04-11 11:00:00 | IWM | ETF | 73.87 | 74.06 | 73.86 | 74.03 | 4191100.0 |
| 2006-04-11 11:30:00 | IWM | ETF | 74.03 | 74.08 | 73.92 | 73.92 | 1554200.0 |
| 2006-04-11 12:00:00 | IWM | ETF | 73.92 | 73.95 | 73.74 | 73.94 | 2694500.0 |
| 2006-04-11 12:30:00 | IWM | ETF | 73.94 | 74.03 | 73.9 | 73.9 | 1157600.0 |
> showing 50 of 2,229 rows — these rows as CSV