PREVIEW / etf_30min / 2004-10-26
file: by_date/etf_30min/2004/2004-10-26.parquet size: 38 KB rows: 1,252
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-26 08:00:00 | SPY | ETF | 110.22 | 110.3 | 110.2 | 110.3 | 190800.0 |
| 2004-10-26 08:30:00 | SPY | ETF | 110.27 | 110.28 | 110.24 | 110.28 | 34800.0 |
| 2004-10-26 09:00:00 | SPY | ETF | 110.28 | 110.28 | 110.13 | 110.14 | 23700.0 |
| 2004-10-26 09:30:00 | SPY | ETF | 110.13 | 110.2 | 109.88 | 109.93 | 5690500.0 |
| 2004-10-26 10:00:00 | SPY | ETF | 109.93 | 110.61 | 109.9 | 110.49 | 8172800.0 |
| 2004-10-26 10:30:00 | SPY | ETF | 110.49 | 110.55 | 110.37 | 110.43 | 3116800.0 |
| 2004-10-26 11:00:00 | SPY | ETF | 110.43 | 110.61 | 110.28 | 110.52 | 2773300.0 |
| 2004-10-26 11:30:00 | SPY | ETF | 110.53 | 110.63 | 110.34 | 110.58 | 1744700.0 |
| 2004-10-26 12:00:00 | SPY | ETF | 110.59 | 110.91 | 110.53 | 110.81 | 3295600.0 |
| 2004-10-26 12:30:00 | SPY | ETF | 110.81 | 111.01 | 110.78 | 110.87 | 1727000.0 |
| 2004-10-26 13:00:00 | SPY | ETF | 110.88 | 111.17 | 110.86 | 110.93 | 3311200.0 |
| 2004-10-26 13:30:00 | SPY | ETF | 110.93 | 111.03 | 110.8 | 110.95 | 2933800.0 |
| 2004-10-26 14:00:00 | SPY | ETF | 110.95 | 111.1 | 110.93 | 110.99 | 2149300.0 |
| 2004-10-26 14:30:00 | SPY | ETF | 110.96 | 111.24 | 110.92 | 111.17 | 2251700.0 |
| 2004-10-26 15:00:00 | SPY | ETF | 111.18 | 111.29 | 111.07 | 111.1 | 3129900.0 |
| 2004-10-26 15:30:00 | SPY | ETF | 111.1 | 111.43 | 111.07 | 111.4 | 5838100.0 |
| 2004-10-26 16:00:00 | SPY | ETF | 111.43 | 111.6 | 111.4 | 111.57 | 3390500.0 |
| 2004-10-26 16:30:00 | SPY | ETF | 111.52 | 111.57 | 111.47 | 111.47 | 1404500.0 |
| 2004-10-26 17:00:00 | SPY | ETF | 111.51 | 111.51 | 111.45 | 111.46 | 58200.0 |
| 2004-10-26 17:30:00 | SPY | ETF | 111.5 | 111.5 | 111.49 | 111.49 | 1500.0 |
| 2004-10-26 18:00:00 | SPY | ETF | 111.51 | 111.59 | 111.5 | 111.5 | 93000.0 |
| 2004-10-26 18:30:00 | SPY | ETF | 111.5 | 111.5 | 111.48 | 111.48 | 7800.0 |
| 2004-10-26 19:00:00 | SPY | ETF | 111.48 | 111.49 | 111.48 | 111.49 | 1900.0 |
| 2004-10-26 19:30:00 | SPY | ETF | 111.47 | 111.49 | 111.45 | 111.45 | 2000.0 |
| 2004-10-26 08:00:00 | QQQ | ETF | 35.73 | 35.76 | 35.71 | 35.74 | 216700.0 |
| 2004-10-26 08:30:00 | QQQ | ETF | 35.74 | 35.76 | 35.7 | 35.73 | 110900.0 |
| 2004-10-26 09:00:00 | QQQ | ETF | 35.73 | 35.73 | 35.65 | 35.66 | 129000.0 |
| 2004-10-26 09:30:00 | QQQ | ETF | 35.65 | 35.684 | 35.43 | 35.43 | 11308000.0 |
| 2004-10-26 10:00:00 | QQQ | ETF | 35.44 | 35.734 | 35.41 | 35.68 | 15958600.0 |
| 2004-10-26 10:30:00 | QQQ | ETF | 35.68 | 35.73 | 35.54 | 35.58 | 6880900.0 |
| 2004-10-26 11:00:00 | QQQ | ETF | 35.57 | 35.67 | 35.474 | 35.642 | 7612900.0 |
| 2004-10-26 11:30:00 | QQQ | ETF | 35.64 | 35.649 | 35.51 | 35.63 | 8072500.0 |
| 2004-10-26 12:00:00 | QQQ | ETF | 35.638 | 35.76 | 35.6 | 35.675 | 5856600.0 |
| 2004-10-26 12:30:00 | QQQ | ETF | 35.68 | 35.764 | 35.65 | 35.67 | 4349900.0 |
| 2004-10-26 13:00:00 | QQQ | ETF | 35.67 | 35.796 | 35.63 | 35.647 | 6506100.0 |
| 2004-10-26 13:30:00 | QQQ | ETF | 35.647 | 35.68 | 35.59 | 35.63 | 4511200.0 |
| 2004-10-26 14:00:00 | QQQ | ETF | 35.62 | 35.7 | 35.61 | 35.62 | 5230600.0 |
| 2004-10-26 14:30:00 | QQQ | ETF | 35.62 | 35.75 | 35.61 | 35.698 | 4400000.0 |
| 2004-10-26 15:00:00 | QQQ | ETF | 35.7 | 35.76 | 35.68 | 35.69 | 5569300.0 |
| 2004-10-26 15:30:00 | QQQ | ETF | 35.69 | 35.79 | 35.66 | 35.789 | 6716000.0 |
| 2004-10-26 16:00:00 | QQQ | ETF | 35.79 | 35.85 | 35.77 | 35.85 | 2592900.0 |
| 2004-10-26 16:30:00 | QQQ | ETF | 35.84 | 35.85 | 35.8 | 35.84 | 226900.0 |
| 2004-10-26 17:00:00 | QQQ | ETF | 35.855 | 35.861 | 35.84 | 35.85 | 33800.0 |
| 2004-10-26 17:30:00 | QQQ | ETF | 35.85 | 35.85 | 35.83 | 35.84 | 16400.0 |
| 2004-10-26 18:00:00 | QQQ | ETF | 35.85 | 35.882 | 35.85 | 35.85 | 26300.0 |
| 2004-10-26 18:30:00 | QQQ | ETF | 35.85 | 35.85 | 35.84 | 35.84 | 2000.0 |
| 2004-10-26 19:30:00 | QQQ | ETF | 35.84 | 35.84 | 35.84 | 35.84 | 2400.0 |
| 2004-10-26 08:00:00 | IWM | ETF | 57.305 | 57.305 | 57.305 | 57.305 | 1000.0 |
| 2004-10-26 08:30:00 | IWM | ETF | 57.275 | 57.285 | 57.275 | 57.285 | 19800.0 |
| 2004-10-26 09:00:00 | IWM | ETF | 57.3 | 57.3 | 57.2 | 57.2 | 26800.0 |
> showing 50 of 1,252 rows — these rows as CSV