PREVIEW / etf_30min / 2005-08-12
file: by_date/etf_30min/2005/2005-08-12.parquet size: 46 KB rows: 1,624
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-12 07:30:00 | SPY | ETF | 123.7 | 123.7 | 123.69 | 123.69 | 5500.0 |
| 2005-08-12 08:00:00 | SPY | ETF | 123.7 | 123.7 | 123.67 | 123.7 | 19900.0 |
| 2005-08-12 08:30:00 | SPY | ETF | 123.69 | 123.69 | 123.47 | 123.6 | 270100.0 |
| 2005-08-12 09:00:00 | SPY | ETF | 123.56 | 123.59 | 123.55 | 123.57 | 27700.0 |
| 2005-08-12 09:30:00 | SPY | ETF | 123.57 | 123.67 | 123.25 | 123.37 | 6148400.0 |
| 2005-08-12 10:00:00 | SPY | ETF | 123.37 | 123.53 | 123.25 | 123.47 | 3722100.0 |
| 2005-08-12 10:30:00 | SPY | ETF | 123.47 | 123.51 | 123.28 | 123.45 | 1717900.0 |
| 2005-08-12 11:00:00 | SPY | ETF | 123.45 | 123.61 | 123.25 | 123.26 | 3897900.0 |
| 2005-08-12 11:30:00 | SPY | ETF | 123.25 | 123.34 | 122.89 | 123.0 | 8500700.0 |
| 2005-08-12 12:00:00 | SPY | ETF | 123.0 | 123.03 | 122.86 | 122.88 | 3878100.0 |
| 2005-08-12 12:30:00 | SPY | ETF | 122.88 | 123.0 | 122.75 | 122.9 | 3206600.0 |
| 2005-08-12 13:00:00 | SPY | ETF | 122.9 | 123.02 | 122.83 | 123.0 | 1839400.0 |
| 2005-08-12 13:30:00 | SPY | ETF | 123.0 | 123.0 | 122.84 | 122.89 | 1400200.0 |
| 2005-08-12 14:00:00 | SPY | ETF | 122.88 | 123.19 | 122.87 | 123.12 | 3284200.0 |
| 2005-08-12 14:30:00 | SPY | ETF | 123.12 | 123.2 | 123.03 | 123.1 | 1748000.0 |
| 2005-08-12 15:00:00 | SPY | ETF | 123.1 | 123.6 | 123.05 | 123.57 | 4195500.0 |
| 2005-08-12 15:30:00 | SPY | ETF | 123.56 | 123.69 | 123.19 | 123.24 | 7044600.0 |
| 2005-08-12 16:00:00 | SPY | ETF | 123.23 | 123.4 | 123.06 | 123.09 | 1622000.0 |
| 2005-08-12 16:30:00 | SPY | ETF | 123.1 | 123.19 | 123.1 | 123.13 | 23200.0 |
| 2005-08-12 17:00:00 | SPY | ETF | 123.1 | 123.12 | 123.0 | 123.0 | 5700.0 |
| 2005-08-12 17:30:00 | SPY | ETF | 123.12 | 123.14 | 123.09 | 123.14 | 1200.0 |
| 2005-08-12 18:00:00 | SPY | ETF | 123.11 | 123.11 | 123.11 | 123.11 | 600.0 |
| 2005-08-12 09:30:00 | QQQ | ETF | 39.12 | 39.18 | 39.05 | 39.08 | 10489500.0 |
| 2005-08-12 10:00:00 | QQQ | ETF | 39.08 | 39.15 | 39.01 | 39.12 | 5942400.0 |
| 2005-08-12 10:30:00 | QQQ | ETF | 39.12 | 39.14 | 39.04 | 39.13 | 3616800.0 |
| 2005-08-12 11:00:00 | QQQ | ETF | 39.13 | 39.17 | 39.08 | 39.1 | 7371100.0 |
| 2005-08-12 11:30:00 | QQQ | ETF | 39.09 | 39.15 | 39.01 | 39.06 | 5656800.0 |
| 2005-08-12 12:00:00 | QQQ | ETF | 39.06 | 39.08 | 38.99 | 39.01 | 4492000.0 |
| 2005-08-12 12:30:00 | QQQ | ETF | 39.01 | 39.06 | 38.97 | 39.05 | 5483300.0 |
| 2005-08-12 13:00:00 | QQQ | ETF | 39.04 | 39.1 | 39.01 | 39.09 | 3254600.0 |
| 2005-08-12 13:30:00 | QQQ | ETF | 39.09 | 39.09 | 39.01 | 39.01 | 3533700.0 |
| 2005-08-12 14:00:00 | QQQ | ETF | 39.01 | 39.16 | 38.98 | 39.12 | 7183300.0 |
| 2005-08-12 14:30:00 | QQQ | ETF | 39.13 | 39.15 | 39.07 | 39.1 | 4514600.0 |
| 2005-08-12 15:00:00 | QQQ | ETF | 39.1 | 39.27 | 39.07 | 39.26 | 6262800.0 |
| 2005-08-12 15:30:00 | QQQ | ETF | 39.25 | 39.32 | 39.15 | 39.19 | 10845200.0 |
| 2005-08-12 08:30:00 | IWM | ETF | 66.14 | 66.15 | 66.04 | 66.04 | 15100.0 |
| 2005-08-12 09:00:00 | IWM | ETF | 66.08 | 66.09 | 66.04 | 66.04 | 6700.0 |
| 2005-08-12 09:30:00 | IWM | ETF | 66.04 | 66.07 | 65.4 | 65.47 | 3413200.0 |
| 2005-08-12 10:00:00 | IWM | ETF | 65.48 | 65.68 | 65.44 | 65.63 | 1987400.0 |
| 2005-08-12 10:30:00 | IWM | ETF | 65.62 | 65.65 | 65.48 | 65.61 | 413400.0 |
| 2005-08-12 11:00:00 | IWM | ETF | 65.64 | 65.72 | 65.49 | 65.5 | 629200.0 |
| 2005-08-12 11:30:00 | IWM | ETF | 65.49 | 65.56 | 65.16 | 65.24 | 5240700.0 |
| 2005-08-12 12:00:00 | IWM | ETF | 65.24 | 65.34 | 65.2 | 65.23 | 1339000.0 |
| 2005-08-12 12:30:00 | IWM | ETF | 65.23 | 65.31 | 65.13 | 65.27 | 1216800.0 |
| 2005-08-12 13:00:00 | IWM | ETF | 65.27 | 65.33 | 65.23 | 65.33 | 490000.0 |
| 2005-08-12 13:30:00 | IWM | ETF | 65.32 | 65.33 | 65.21 | 65.29 | 1130900.0 |
| 2005-08-12 14:00:00 | IWM | ETF | 65.29 | 65.57 | 65.29 | 65.49 | 1566500.0 |
| 2005-08-12 14:30:00 | IWM | ETF | 65.5 | 65.56 | 65.45 | 65.49 | 552900.0 |
| 2005-08-12 15:00:00 | IWM | ETF | 65.49 | 66.02 | 65.43 | 65.97 | 2138500.0 |
| 2005-08-12 15:30:00 | IWM | ETF | 65.97 | 66.07 | 65.57 | 65.65 | 3938000.0 |
> showing 50 of 1,624 rows — these rows as CSV