PREVIEW / etf_30min / 2004-10-14
file: by_date/etf_30min/2004/2004-10-14.parquet size: 37 KB rows: 1,199
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-10-14 08:00:00 | SPY | ETF | 111.64 | 111.66 | 111.64 | 111.65 | 30300.0 |
| 2004-10-14 08:30:00 | SPY | ETF | 111.62 | 111.62 | 111.49 | 111.54 | 71100.0 |
| 2004-10-14 09:00:00 | SPY | ETF | 111.54 | 111.7 | 111.54 | 111.66 | 39700.0 |
| 2004-10-14 09:30:00 | SPY | ETF | 111.68 | 111.79 | 111.52 | 111.55 | 4854900.0 |
| 2004-10-14 10:00:00 | SPY | ETF | 111.55 | 111.82 | 111.52 | 111.73 | 3236600.0 |
| 2004-10-14 10:30:00 | SPY | ETF | 111.72 | 111.93 | 111.49 | 111.5 | 4635600.0 |
| 2004-10-14 11:00:00 | SPY | ETF | 111.5 | 111.58 | 111.29 | 111.48 | 6423600.0 |
| 2004-10-14 11:30:00 | SPY | ETF | 111.47 | 111.5 | 111.02 | 111.09 | 4791200.0 |
| 2004-10-14 12:00:00 | SPY | ETF | 111.1 | 111.24 | 110.95 | 111.17 | 5372600.0 |
| 2004-10-14 12:30:00 | SPY | ETF | 111.17 | 111.22 | 110.99 | 111.01 | 1918100.0 |
| 2004-10-14 13:00:00 | SPY | ETF | 111.02 | 111.12 | 110.9 | 111.03 | 4238100.0 |
| 2004-10-14 13:30:00 | SPY | ETF | 111.03 | 111.16 | 110.94 | 111.08 | 3328100.0 |
| 2004-10-14 14:00:00 | SPY | ETF | 111.08 | 111.1 | 110.77 | 110.88 | 2954100.0 |
| 2004-10-14 14:30:00 | SPY | ETF | 110.88 | 110.93 | 110.71 | 110.78 | 1801900.0 |
| 2004-10-14 15:00:00 | SPY | ETF | 110.79 | 110.87 | 110.58 | 110.63 | 6339000.0 |
| 2004-10-14 15:30:00 | SPY | ETF | 110.63 | 110.92 | 110.6 | 110.7 | 8653100.0 |
| 2004-10-14 16:00:00 | SPY | ETF | 110.71 | 110.74 | 110.61 | 110.62 | 1920600.0 |
| 2004-10-14 16:30:00 | SPY | ETF | 110.62 | 110.77 | 110.61 | 110.7 | 601400.0 |
| 2004-10-14 17:00:00 | SPY | ETF | 110.68 | 110.71 | 110.65 | 110.66 | 441300.0 |
| 2004-10-14 17:30:00 | SPY | ETF | 110.6386 | 110.6386 | 110.63 | 110.63 | 23200.0 |
| 2004-10-14 18:00:00 | SPY | ETF | 110.62 | 110.71 | 110.62 | 110.69 | 5500.0 |
| 2004-10-14 18:30:00 | SPY | ETF | 110.69 | 110.69 | 110.69 | 110.69 | 500.0 |
| 2004-10-14 19:00:00 | SPY | ETF | 110.71 | 110.71 | 110.71 | 110.71 | 500.0 |
| 2004-10-14 19:30:00 | SPY | ETF | 110.73 | 110.73 | 110.73 | 110.73 | 300.0 |
| 2004-10-14 08:00:00 | QQQ | ETF | 35.63 | 35.63 | 35.59 | 35.59 | 85600.0 |
| 2004-10-14 08:30:00 | QQQ | ETF | 35.61 | 35.61 | 35.56 | 35.59 | 162400.0 |
| 2004-10-14 09:00:00 | QQQ | ETF | 35.59 | 35.7 | 35.59 | 35.69 | 282200.0 |
| 2004-10-14 09:30:00 | QQQ | ETF | 35.69 | 35.76 | 35.54 | 35.55 | 10885700.0 |
| 2004-10-14 10:00:00 | QQQ | ETF | 35.55 | 35.7 | 35.54 | 35.61 | 8638600.0 |
| 2004-10-14 10:30:00 | QQQ | ETF | 35.63 | 35.78 | 35.542 | 35.549 | 9003000.0 |
| 2004-10-14 11:00:00 | QQQ | ETF | 35.549 | 35.61 | 35.47 | 35.582 | 7776200.0 |
| 2004-10-14 11:30:00 | QQQ | ETF | 35.58 | 35.59 | 35.4 | 35.46 | 8308800.0 |
| 2004-10-14 12:00:00 | QQQ | ETF | 35.46 | 35.54 | 35.41 | 35.51 | 5851800.0 |
| 2004-10-14 12:30:00 | QQQ | ETF | 35.51 | 35.54 | 35.43 | 35.439 | 3374200.0 |
| 2004-10-14 13:00:00 | QQQ | ETF | 35.438 | 35.494 | 35.4 | 35.47 | 6029000.0 |
| 2004-10-14 13:30:00 | QQQ | ETF | 35.473 | 35.54 | 35.45 | 35.52 | 3150600.0 |
| 2004-10-14 14:00:00 | QQQ | ETF | 35.52 | 35.52 | 35.38 | 35.42 | 5646400.0 |
| 2004-10-14 14:30:00 | QQQ | ETF | 35.43 | 35.472 | 35.379 | 35.43 | 4814600.0 |
| 2004-10-14 15:00:00 | QQQ | ETF | 35.43 | 35.46 | 35.35 | 35.37 | 7774400.0 |
| 2004-10-14 15:30:00 | QQQ | ETF | 35.37 | 35.51 | 35.33 | 35.43 | 10410600.0 |
| 2004-10-14 16:00:00 | QQQ | ETF | 35.44 | 35.49 | 35.41 | 35.43 | 2696100.0 |
| 2004-10-14 16:30:00 | QQQ | ETF | 35.43 | 35.44 | 35.39 | 35.43 | 696700.0 |
| 2004-10-14 17:00:00 | QQQ | ETF | 35.43 | 35.45 | 35.39 | 35.39 | 72100.0 |
| 2004-10-14 17:30:00 | QQQ | ETF | 35.4 | 35.46 | 35.39 | 35.4 | 13800.0 |
| 2004-10-14 18:00:00 | QQQ | ETF | 35.42 | 35.44 | 35.42 | 35.43 | 17400.0 |
| 2004-10-14 19:00:00 | QQQ | ETF | 35.42 | 35.44 | 35.42 | 35.44 | 2600.0 |
| 2004-10-14 19:30:00 | QQQ | ETF | 35.44 | 35.44 | 35.44 | 35.44 | 200.0 |
| 2004-10-14 08:00:00 | IWM | ETF | 56.675 | 56.705 | 56.675 | 56.705 | 9400.0 |
| 2004-10-14 08:30:00 | IWM | ETF | 56.57 | 56.62 | 56.54 | 56.605 | 8400.0 |
| 2004-10-14 09:00:00 | IWM | ETF | 56.675 | 56.735 | 56.655 | 56.655 | 13000.0 |
> showing 50 of 1,199 rows — these rows as CSV