PREVIEW / etf_30min / 2004-12-27
file: by_date/etf_30min/2004/2004-12-27.parquet size: 39 KB rows: 1,333
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-27 08:00:00 | SPY | ETF | 121.18 | 121.25 | 121.18 | 121.24 | 8700.0 |
| 2004-12-27 08:30:00 | SPY | ETF | 121.22 | 121.22 | 121.19 | 121.22 | 8500.0 |
| 2004-12-27 09:00:00 | SPY | ETF | 121.21 | 121.28 | 121.21 | 121.22 | 40300.0 |
| 2004-12-27 09:30:00 | SPY | ETF | 121.2 | 121.36 | 121.15 | 121.23 | 3900700.0 |
| 2004-12-27 10:00:00 | SPY | ETF | 121.23 | 121.24 | 120.9 | 121.1 | 3333600.0 |
| 2004-12-27 10:30:00 | SPY | ETF | 121.1 | 121.24 | 121.07 | 121.12 | 1624400.0 |
| 2004-12-27 11:00:00 | SPY | ETF | 121.11 | 121.18 | 120.72 | 120.81 | 2434600.0 |
| 2004-12-27 11:30:00 | SPY | ETF | 120.81 | 120.81 | 120.47 | 120.66 | 3529400.0 |
| 2004-12-27 12:00:00 | SPY | ETF | 120.65 | 120.82 | 120.65 | 120.74 | 1139300.0 |
| 2004-12-27 12:30:00 | SPY | ETF | 120.74 | 120.77 | 120.62 | 120.67 | 813500.0 |
| 2004-12-27 13:00:00 | SPY | ETF | 120.67 | 120.68 | 120.55 | 120.65 | 883900.0 |
| 2004-12-27 13:30:00 | SPY | ETF | 120.66 | 120.79 | 120.6 | 120.76 | 546300.0 |
| 2004-12-27 14:00:00 | SPY | ETF | 120.77 | 120.86 | 120.61 | 120.7 | 1438200.0 |
| 2004-12-27 14:30:00 | SPY | ETF | 120.7 | 120.82 | 120.62 | 120.75 | 916100.0 |
| 2004-12-27 15:00:00 | SPY | ETF | 120.76 | 120.81 | 120.61 | 120.71 | 1488600.0 |
| 2004-12-27 15:30:00 | SPY | ETF | 120.71 | 120.74 | 120.41 | 120.42 | 2742800.0 |
| 2004-12-27 16:00:00 | SPY | ETF | 120.43 | 120.69 | 120.38 | 120.5 | 1205600.0 |
| 2004-12-27 16:30:00 | SPY | ETF | 120.48 | 120.51 | 120.38 | 120.46 | 1980900.0 |
| 2004-12-27 17:00:00 | SPY | ETF | 120.46 | 120.47 | 120.46 | 120.47 | 30500.0 |
| 2004-12-27 17:30:00 | SPY | ETF | 120.47 | 120.48 | 120.45 | 120.45 | 2300.0 |
| 2004-12-27 18:00:00 | SPY | ETF | 120.47 | 120.52 | 120.47 | 120.5 | 2700.0 |
| 2004-12-27 18:30:00 | SPY | ETF | 120.51 | 120.51 | 120.51 | 120.51 | 300.0 |
| 2004-12-27 19:30:00 | SPY | ETF | 120.54 | 120.54 | 120.54 | 120.54 | 300.0 |
| 2004-12-27 08:00:00 | QQQ | ETF | 39.86 | 39.89 | 39.845 | 39.87 | 29621.0 |
| 2004-12-27 08:30:00 | QQQ | ETF | 39.87 | 39.92 | 39.86 | 39.92 | 171172.0 |
| 2004-12-27 09:00:00 | QQQ | ETF | 39.92 | 39.999 | 39.89 | 39.97 | 348791.0 |
| 2004-12-27 09:30:00 | QQQ | ETF | 39.98 | 40.02 | 39.85 | 39.93 | 7540142.0 |
| 2004-12-27 10:00:00 | QQQ | ETF | 39.931 | 39.94 | 39.71 | 39.86 | 7228112.0 |
| 2004-12-27 10:30:00 | QQQ | ETF | 39.86 | 39.933 | 39.84 | 39.84 | 3645973.0 |
| 2004-12-27 11:00:00 | QQQ | ETF | 39.843 | 39.88 | 39.43 | 39.51 | 9370002.0 |
| 2004-12-27 11:30:00 | QQQ | ETF | 39.512 | 39.59 | 39.4 | 39.57 | 8023977.0 |
| 2004-12-27 12:00:00 | QQQ | ETF | 39.561 | 39.63 | 39.56 | 39.6 | 3740986.0 |
| 2004-12-27 12:30:00 | QQQ | ETF | 39.601 | 39.62 | 39.56 | 39.61 | 2439004.0 |
| 2004-12-27 13:00:00 | QQQ | ETF | 39.62 | 39.62 | 39.54 | 39.57 | 2804028.0 |
| 2004-12-27 13:30:00 | QQQ | ETF | 39.57 | 39.643 | 39.53 | 39.6301 | 1794538.0 |
| 2004-12-27 14:00:00 | QQQ | ETF | 39.64 | 39.72 | 39.61 | 39.66 | 4098222.0 |
| 2004-12-27 14:30:00 | QQQ | ETF | 39.67 | 39.74 | 39.63 | 39.702 | 3675457.0 |
| 2004-12-27 15:00:00 | QQQ | ETF | 39.703 | 39.711 | 39.62 | 39.653 | 3191153.0 |
| 2004-12-27 15:30:00 | QQQ | ETF | 39.654 | 39.69 | 39.58 | 39.59 | 5251123.0 |
| 2004-12-27 16:00:00 | QQQ | ETF | 39.59 | 39.66 | 39.57 | 39.63 | 1560321.0 |
| 2004-12-27 16:30:00 | QQQ | ETF | 39.62 | 39.65 | 39.6 | 39.6 | 60633.0 |
| 2004-12-27 17:00:00 | QQQ | ETF | 39.6 | 39.63 | 39.59 | 39.6 | 86294.0 |
| 2004-12-27 17:30:00 | QQQ | ETF | 39.59 | 39.6 | 39.589 | 39.6 | 11012.0 |
| 2004-12-27 18:00:00 | QQQ | ETF | 39.602 | 39.62 | 39.6 | 39.61 | 41706.0 |
| 2004-12-27 09:00:00 | IWM | ETF | 64.86 | 65.005 | 64.86 | 65.005 | 5600.0 |
| 2004-12-27 09:30:00 | IWM | ETF | 65.0 | 65.0 | 64.725 | 64.83 | 1857800.0 |
| 2004-12-27 10:00:00 | IWM | ETF | 64.83 | 64.83 | 64.445 | 64.565 | 1088600.0 |
| 2004-12-27 10:30:00 | IWM | ETF | 64.575 | 64.64 | 64.54 | 64.565 | 661200.0 |
| 2004-12-27 11:00:00 | IWM | ETF | 64.565 | 64.605 | 64.08 | 64.09 | 603400.0 |
| 2004-12-27 11:30:00 | IWM | ETF | 64.09 | 64.125 | 63.825 | 64.085 | 1776800.0 |
> showing 50 of 1,333 rows — these rows as CSV