PREVIEW / etf_30min / 2005-04-06
file: by_date/etf_30min/2005/2005-04-06.parquet size: 43 KB rows: 1,490
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-04-06 08:00:00 | SPY | ETF | 118.53 | 118.55 | 118.46 | 118.55 | 46000.0 |
| 2005-04-06 08:30:00 | SPY | ETF | 118.55 | 118.55 | 118.39 | 118.39 | 40200.0 |
| 2005-04-06 09:00:00 | SPY | ETF | 118.41 | 118.47 | 118.4 | 118.45 | 115100.0 |
| 2005-04-06 09:30:00 | SPY | ETF | 118.45 | 118.58 | 118.35 | 118.43 | 5695200.0 |
| 2005-04-06 10:00:00 | SPY | ETF | 118.43 | 118.6 | 118.38 | 118.4805 | 3193700.0 |
| 2005-04-06 10:30:00 | SPY | ETF | 118.48 | 118.68 | 118.3 | 118.63 | 5898200.0 |
| 2005-04-06 11:00:00 | SPY | ETF | 118.62 | 118.91 | 118.36 | 118.84 | 5596600.0 |
| 2005-04-06 11:30:00 | SPY | ETF | 118.84 | 118.9 | 118.64 | 118.74 | 2782300.0 |
| 2005-04-06 12:00:00 | SPY | ETF | 118.74 | 118.86 | 118.68 | 118.81 | 2681300.0 |
| 2005-04-06 12:30:00 | SPY | ETF | 118.81 | 118.95 | 118.71 | 118.76 | 2942500.0 |
| 2005-04-06 13:00:00 | SPY | ETF | 118.78 | 118.86 | 118.73 | 118.75 | 2022900.0 |
| 2005-04-06 13:30:00 | SPY | ETF | 118.75 | 118.79 | 118.36 | 118.52 | 4777600.0 |
| 2005-04-06 14:00:00 | SPY | ETF | 118.5 | 118.75 | 118.45 | 118.72 | 2084200.0 |
| 2005-04-06 14:30:00 | SPY | ETF | 118.72 | 118.74 | 118.51 | 118.53 | 1930900.0 |
| 2005-04-06 15:00:00 | SPY | ETF | 118.53 | 118.6 | 118.23 | 118.33 | 4209900.0 |
| 2005-04-06 15:30:00 | SPY | ETF | 118.33 | 118.4 | 118.18 | 118.4 | 4360400.0 |
| 2005-04-06 16:00:00 | SPY | ETF | 118.38 | 118.67 | 118.33 | 118.67 | 2710300.0 |
| 2005-04-06 16:30:00 | SPY | ETF | 118.67 | 118.67 | 118.1364 | 118.56 | 745600.0 |
| 2005-04-06 17:00:00 | SPY | ETF | 118.57 | 118.57 | 118.54 | 118.55 | 12600.0 |
| 2005-04-06 17:30:00 | SPY | ETF | 118.55 | 118.57 | 118.53 | 118.57 | 2200.0 |
| 2005-04-06 18:00:00 | SPY | ETF | 118.52 | 118.56 | 118.52 | 118.56 | 2400.0 |
| 2005-04-06 09:30:00 | QQQ | ETF | 36.68 | 37.0 | 36.65 | 36.7 | 8592500.0 |
| 2005-04-06 10:00:00 | QQQ | ETF | 36.7 | 36.78 | 36.69 | 36.75 | 5611300.0 |
| 2005-04-06 10:30:00 | QQQ | ETF | 36.76 | 36.81 | 36.64 | 36.76 | 8993500.0 |
| 2005-04-06 11:00:00 | QQQ | ETF | 36.76 | 36.9 | 36.73 | 36.89 | 11454200.0 |
| 2005-04-06 11:30:00 | QQQ | ETF | 36.89 | 36.9 | 36.8 | 36.82 | 3205800.0 |
| 2005-04-06 12:00:00 | QQQ | ETF | 36.81 | 36.9 | 36.77 | 36.79 | 3157000.0 |
| 2005-04-06 12:30:00 | QQQ | ETF | 36.79 | 36.83 | 36.69 | 36.72 | 5008600.0 |
| 2005-04-06 13:00:00 | QQQ | ETF | 36.72 | 36.77 | 36.71 | 36.72 | 2138400.0 |
| 2005-04-06 13:30:00 | QQQ | ETF | 36.72 | 36.73 | 36.51 | 36.58 | 7763100.0 |
| 2005-04-06 14:00:00 | QQQ | ETF | 36.58 | 36.65 | 36.56 | 36.64 | 5571700.0 |
| 2005-04-06 14:30:00 | QQQ | ETF | 36.64 | 36.65 | 36.56 | 36.57 | 3139700.0 |
| 2005-04-06 15:00:00 | QQQ | ETF | 36.57 | 36.6 | 36.45 | 36.49 | 8470000.0 |
| 2005-04-06 15:30:00 | QQQ | ETF | 36.49 | 36.5 | 36.42 | 36.5 | 6162500.0 |
| 2005-04-06 08:30:00 | IWM | ETF | 61.385 | 61.39 | 61.365 | 61.365 | 10000.0 |
| 2005-04-06 09:00:00 | IWM | ETF | 61.315 | 61.315 | 61.315 | 61.315 | 1200.0 |
| 2005-04-06 09:30:00 | IWM | ETF | 61.315 | 61.485 | 61.26 | 61.41 | 1728600.0 |
| 2005-04-06 10:00:00 | IWM | ETF | 61.405 | 61.565 | 61.4 | 61.51 | 2227800.0 |
| 2005-04-06 10:30:00 | IWM | ETF | 61.505 | 61.655 | 61.395 | 61.595 | 1562800.0 |
| 2005-04-06 11:00:00 | IWM | ETF | 61.595 | 61.805 | 61.59 | 61.74 | 2772600.0 |
| 2005-04-06 11:30:00 | IWM | ETF | 61.74 | 61.765 | 61.65 | 61.675 | 1135400.0 |
| 2005-04-06 12:00:00 | IWM | ETF | 61.67 | 61.685 | 61.56 | 61.655 | 495400.0 |
| 2005-04-06 12:30:00 | IWM | ETF | 61.625 | 61.665 | 61.515 | 61.555 | 1539200.0 |
| 2005-04-06 13:00:00 | IWM | ETF | 61.555 | 61.59 | 61.475 | 61.495 | 1222000.0 |
| 2005-04-06 13:30:00 | IWM | ETF | 61.48 | 61.49 | 61.245 | 61.3 | 1659800.0 |
| 2005-04-06 14:00:00 | IWM | ETF | 61.295 | 61.48 | 61.285 | 61.46 | 1380600.0 |
| 2005-04-06 14:30:00 | IWM | ETF | 61.445 | 61.515 | 61.37 | 61.385 | 657000.0 |
| 2005-04-06 15:00:00 | IWM | ETF | 61.38 | 61.43 | 61.205 | 61.255 | 1202000.0 |
| 2005-04-06 15:30:00 | IWM | ETF | 61.25 | 61.3 | 61.175 | 61.3 | 1600400.0 |
| 2005-04-06 16:00:00 | IWM | ETF | 61.3 | 61.355 | 61.28 | 61.345 | 245200.0 |
> showing 50 of 1,490 rows — these rows as CSV