PREVIEW / etf_30min / 2004-05-25
file: by_date/etf_30min/2004/2004-05-25.parquet size: 37 KB rows: 1,187
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-05-25 08:00:00 | SPY | ETF | 109.88 | 109.93 | 109.88 | 109.9 | 6900.0 |
| 2004-05-25 08:30:00 | SPY | ETF | 109.94 | 109.98 | 109.93 | 109.96 | 116500.0 |
| 2004-05-25 09:00:00 | SPY | ETF | 109.95 | 109.95 | 109.85 | 109.93 | 118200.0 |
| 2004-05-25 09:30:00 | SPY | ETF | 109.9 | 110.0 | 109.66 | 109.71 | 3278700.0 |
| 2004-05-25 10:00:00 | SPY | ETF | 109.71 | 110.24 | 109.6 | 110.21 | 6356700.0 |
| 2004-05-25 10:30:00 | SPY | ETF | 110.2 | 110.45 | 110.13 | 110.26 | 4607900.0 |
| 2004-05-25 11:00:00 | SPY | ETF | 110.27 | 110.27 | 110.09 | 110.2 | 2557000.0 |
| 2004-05-25 11:30:00 | SPY | ETF | 110.22 | 110.49 | 110.16 | 110.36 | 1705700.0 |
| 2004-05-25 12:00:00 | SPY | ETF | 110.37 | 110.7 | 110.34 | 110.58 | 2566600.0 |
| 2004-05-25 12:30:00 | SPY | ETF | 110.58 | 110.97 | 110.56 | 110.93 | 1845900.0 |
| 2004-05-25 13:00:00 | SPY | ETF | 110.94 | 111.14 | 110.9 | 111.09 | 2908200.0 |
| 2004-05-25 13:30:00 | SPY | ETF | 111.1 | 111.48 | 111.06 | 111.33 | 3852800.0 |
| 2004-05-25 14:00:00 | SPY | ETF | 111.33 | 111.43 | 111.21 | 111.28 | 2876200.0 |
| 2004-05-25 14:30:00 | SPY | ETF | 111.28 | 111.4 | 111.14 | 111.34 | 2550800.0 |
| 2004-05-25 15:00:00 | SPY | ETF | 111.35 | 111.79 | 111.27 | 111.7 | 2993000.0 |
| 2004-05-25 15:30:00 | SPY | ETF | 111.7 | 111.98 | 111.68 | 111.92 | 4693100.0 |
| 2004-05-25 16:00:00 | SPY | ETF | 111.9 | 111.95 | 111.77 | 111.82 | 1979900.0 |
| 2004-05-25 16:30:00 | SPY | ETF | 111.81 | 111.85 | 111.75 | 111.82 | 196700.0 |
| 2004-05-25 17:00:00 | SPY | ETF | 111.85 | 111.87 | 111.85 | 111.87 | 3400.0 |
| 2004-05-25 17:30:00 | SPY | ETF | 111.85 | 111.88 | 111.81 | 111.88 | 3200.0 |
| 2004-05-25 18:00:00 | SPY | ETF | 111.84 | 111.88 | 110.0852 | 110.0852 | 3045100.0 |
| 2004-05-25 18:30:00 | SPY | ETF | 111.88 | 111.88 | 111.88 | 111.88 | 2100.0 |
| 2004-05-25 19:00:00 | SPY | ETF | 111.88 | 111.88 | 111.82 | 111.82 | 2000.0 |
| 2004-05-25 19:30:00 | SPY | ETF | 111.85 | 111.9 | 111.76 | 111.78 | 1500.0 |
| 2004-05-25 08:00:00 | QQQ | ETF | 35.08 | 35.1 | 35.07 | 35.09 | 31400.0 |
| 2004-05-25 08:30:00 | QQQ | ETF | 35.09 | 35.16 | 35.09 | 35.14 | 209000.0 |
| 2004-05-25 09:00:00 | QQQ | ETF | 35.13 | 35.15 | 35.09 | 35.14 | 106600.0 |
| 2004-05-25 09:30:00 | QQQ | ETF | 35.15 | 35.17 | 35.03 | 35.06 | 9788100.0 |
| 2004-05-25 10:00:00 | QQQ | ETF | 35.06 | 35.18 | 34.949 | 35.15 | 12616700.0 |
| 2004-05-25 10:30:00 | QQQ | ETF | 35.15 | 35.28 | 35.131 | 35.17 | 7511300.0 |
| 2004-05-25 11:00:00 | QQQ | ETF | 35.16 | 35.16 | 35.06 | 35.12 | 3849500.0 |
| 2004-05-25 11:30:00 | QQQ | ETF | 35.13 | 35.277 | 35.1 | 35.24 | 5695800.0 |
| 2004-05-25 12:00:00 | QQQ | ETF | 35.25 | 35.478 | 35.21 | 35.411 | 15781500.0 |
| 2004-05-25 12:30:00 | QQQ | ETF | 35.413 | 35.5 | 35.37 | 35.5 | 6192800.0 |
| 2004-05-25 13:00:00 | QQQ | ETF | 35.5 | 35.58 | 35.43 | 35.509 | 11258200.0 |
| 2004-05-25 13:30:00 | QQQ | ETF | 35.51 | 35.75 | 35.5 | 35.68 | 12894400.0 |
| 2004-05-25 14:00:00 | QQQ | ETF | 35.68 | 35.73 | 35.64 | 35.66 | 6625000.0 |
| 2004-05-25 14:30:00 | QQQ | ETF | 35.68 | 35.735 | 35.608 | 35.72 | 9688000.0 |
| 2004-05-25 15:00:00 | QQQ | ETF | 35.72 | 35.97 | 35.71 | 35.93 | 11210100.0 |
| 2004-05-25 15:30:00 | QQQ | ETF | 35.92 | 36.08 | 35.9 | 36.02 | 16404300.0 |
| 2004-05-25 16:00:00 | QQQ | ETF | 36.02 | 36.04 | 35.93 | 35.975 | 3997600.0 |
| 2004-05-25 16:30:00 | QQQ | ETF | 35.96 | 35.98 | 35.92 | 35.94 | 631200.0 |
| 2004-05-25 17:00:00 | QQQ | ETF | 35.94 | 35.99 | 35.94 | 35.99 | 201200.0 |
| 2004-05-25 17:30:00 | QQQ | ETF | 35.96 | 35.97 | 35.93 | 35.96 | 97700.0 |
| 2004-05-25 18:00:00 | QQQ | ETF | 35.96 | 36.025 | 35.96 | 36.0 | 58200.0 |
| 2004-05-25 18:30:00 | QQQ | ETF | 35.98 | 36.0 | 35.96 | 36.0 | 2700.0 |
| 2004-05-25 19:00:00 | QQQ | ETF | 35.96 | 35.96 | 35.88 | 35.88 | 46600.0 |
| 2004-05-25 19:30:00 | QQQ | ETF | 35.94 | 35.94 | 35.92 | 35.93 | 3000.0 |
| 2004-05-25 08:30:00 | IWM | ETF | 55.005 | 55.01 | 55.005 | 55.01 | 4000.0 |
| 2004-05-25 09:00:00 | IWM | ETF | 55.025 | 55.025 | 54.965 | 54.965 | 3800.0 |
> showing 50 of 1,187 rows — these rows as CSV