PREVIEW / etf_30min / 2004-02-06
file: by_date/etf_30min/2004/2004-02-06.parquet size: 36 KB rows: 1,210
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-02-06 08:00:00 | SPY | ETF | 113.36 | 113.46 | 113.35 | 113.42 | 39000.0 |
| 2004-02-06 08:30:00 | SPY | ETF | 113.41 | 113.66 | 112.93 | 113.36 | 1177200.0 |
| 2004-02-06 09:00:00 | SPY | ETF | 113.33 | 113.41 | 113.27 | 113.38 | 38100.0 |
| 2004-02-06 09:30:00 | SPY | ETF | 113.42 | 113.62 | 113.2 | 113.38 | 5114200.0 |
| 2004-02-06 10:00:00 | SPY | ETF | 113.37 | 114.15 | 113.34 | 114.04 | 5482500.0 |
| 2004-02-06 10:30:00 | SPY | ETF | 114.04 | 114.47 | 114.04 | 114.35 | 3757100.0 |
| 2004-02-06 11:00:00 | SPY | ETF | 114.36 | 114.38 | 114.18 | 114.32 | 1261800.0 |
| 2004-02-06 11:30:00 | SPY | ETF | 114.36 | 114.37 | 114.08 | 114.18 | 1166100.0 |
| 2004-02-06 12:00:00 | SPY | ETF | 114.16 | 114.3 | 114.09 | 114.16 | 826900.0 |
| 2004-02-06 12:30:00 | SPY | ETF | 114.2 | 114.36 | 114.15 | 114.22 | 1249300.0 |
| 2004-02-06 13:00:00 | SPY | ETF | 114.21 | 114.35 | 114.15 | 114.23 | 765700.0 |
| 2004-02-06 13:30:00 | SPY | ETF | 114.265 | 114.4 | 114.14 | 114.33 | 994200.0 |
| 2004-02-06 14:00:00 | SPY | ETF | 114.32 | 114.37 | 114.19 | 114.27 | 693600.0 |
| 2004-02-06 14:30:00 | SPY | ETF | 114.27 | 114.57 | 114.27 | 114.471 | 1181600.0 |
| 2004-02-06 15:00:00 | SPY | ETF | 114.45 | 114.67 | 114.4 | 114.52 | 1538100.0 |
| 2004-02-06 15:30:00 | SPY | ETF | 114.5 | 114.69 | 114.42 | 114.66 | 2640100.0 |
| 2004-02-06 16:00:00 | SPY | ETF | 114.66 | 114.7 | 114.39 | 114.5 | 2027300.0 |
| 2004-02-06 16:30:00 | SPY | ETF | 114.48 | 114.5 | 114.3 | 114.4 | 89800.0 |
| 2004-02-06 17:00:00 | SPY | ETF | 114.39 | 114.45 | 114.39 | 114.43 | 19000.0 |
| 2004-02-06 17:30:00 | SPY | ETF | 114.42 | 114.45 | 114.42 | 114.45 | 21600.0 |
| 2004-02-06 18:00:00 | SPY | ETF | 114.44 | 114.45 | 114.4 | 114.4 | 6300.0 |
| 2004-02-06 18:30:00 | SPY | ETF | 114.4 | 114.45 | 114.4 | 114.45 | 1600.0 |
| 2004-02-06 19:00:00 | SPY | ETF | 114.46 | 114.47 | 114.45 | 114.45 | 1000.0 |
| 2004-02-06 08:00:00 | QQQ | ETF | 36.61 | 36.66 | 36.57 | 36.57 | 96600.0 |
| 2004-02-06 08:30:00 | QQQ | ETF | 36.58 | 36.67 | 36.39 | 36.54 | 749000.0 |
| 2004-02-06 09:00:00 | QQQ | ETF | 36.53 | 36.61 | 36.5 | 36.6 | 171900.0 |
| 2004-02-06 09:30:00 | QQQ | ETF | 36.6 | 36.84 | 36.53 | 36.68 | 19848900.0 |
| 2004-02-06 10:00:00 | QQQ | ETF | 36.66 | 36.97 | 36.64 | 36.896 | 13749000.0 |
| 2004-02-06 10:30:00 | QQQ | ETF | 36.9 | 37.1 | 36.89 | 36.98 | 10446500.0 |
| 2004-02-06 11:00:00 | QQQ | ETF | 37.0 | 37.05 | 36.92 | 37.05 | 4054500.0 |
| 2004-02-06 11:30:00 | QQQ | ETF | 37.05 | 37.06 | 36.93 | 36.99 | 3897400.0 |
| 2004-02-06 12:00:00 | QQQ | ETF | 36.99 | 37.04 | 36.95 | 36.979 | 2886000.0 |
| 2004-02-06 12:30:00 | QQQ | ETF | 36.97 | 37.06 | 36.96 | 37.001 | 2526000.0 |
| 2004-02-06 13:00:00 | QQQ | ETF | 37.002 | 37.06 | 36.95 | 37.0 | 2556700.0 |
| 2004-02-06 13:30:00 | QQQ | ETF | 37.0 | 37.13 | 37.0 | 37.1 | 6328800.0 |
| 2004-02-06 14:00:00 | QQQ | ETF | 37.09 | 37.1 | 37.0 | 37.06 | 3947900.0 |
| 2004-02-06 14:30:00 | QQQ | ETF | 37.05 | 37.176 | 37.05 | 37.123 | 5121100.0 |
| 2004-02-06 15:00:00 | QQQ | ETF | 37.13 | 37.24 | 37.11 | 37.198 | 8857000.0 |
| 2004-02-06 15:30:00 | QQQ | ETF | 37.19 | 37.27 | 37.17 | 37.25 | 12444000.0 |
| 2004-02-06 16:00:00 | QQQ | ETF | 37.25 | 37.28 | 37.11 | 37.19 | 3174000.0 |
| 2004-02-06 16:30:00 | QQQ | ETF | 37.19 | 37.19 | 37.14 | 37.16 | 50200.0 |
| 2004-02-06 17:00:00 | QQQ | ETF | 37.16 | 37.18 | 37.15 | 37.15 | 18400.0 |
| 2004-02-06 17:30:00 | QQQ | ETF | 37.16 | 37.17 | 37.13 | 37.14 | 29900.0 |
| 2004-02-06 18:00:00 | QQQ | ETF | 37.14 | 37.18 | 37.14 | 37.17 | 41000.0 |
| 2004-02-06 18:30:00 | QQQ | ETF | 37.15 | 37.17 | 37.15 | 37.17 | 13400.0 |
| 2004-02-06 19:00:00 | QQQ | ETF | 37.17 | 37.17 | 37.15 | 37.15 | 3000.0 |
| 2004-02-06 19:30:00 | QQQ | ETF | 37.18 | 37.18 | 37.18 | 37.18 | 100.0 |
| 2004-02-06 09:00:00 | IWM | ETF | 56.77 | 56.8 | 56.745 | 56.78 | 30400.0 |
| 2004-02-06 09:30:00 | IWM | ETF | 56.725 | 57.22 | 56.725 | 56.85 | 2225400.0 |
| 2004-02-06 10:00:00 | IWM | ETF | 56.861 | 57.345 | 56.811 | 57.25 | 1875000.0 |
> showing 50 of 1,210 rows — these rows as CSV