PREVIEW / etf_30min / 2004-05-11
file: by_date/etf_30min/2004/2004-05-11.parquet size: 36 KB rows: 1,212
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-11 08:00:00 | SPY | ETF | 109.35 | 109.46 | 109.3 | 109.39 | 142700.0 |
| 2004-05-11 08:30:00 | SPY | ETF | 109.37 | 109.51 | 109.36 | 109.48 | 105300.0 |
| 2004-05-11 09:00:00 | SPY | ETF | 109.47 | 109.53 | 109.45 | 109.47 | 112000.0 |
| 2004-05-11 09:30:00 | SPY | ETF | 109.46 | 109.89 | 109.35 | 109.74 | 7983800.0 |
| 2004-05-11 10:00:00 | SPY | ETF | 109.76 | 109.85 | 109.54 | 109.55 | 2945500.0 |
| 2004-05-11 10:30:00 | SPY | ETF | 109.53 | 109.96 | 109.52 | 109.72 | 2000000.0 |
| 2004-05-11 11:00:00 | SPY | ETF | 109.73 | 110.01 | 109.7 | 109.95 | 1894800.0 |
| 2004-05-11 11:30:00 | SPY | ETF | 109.96 | 110.05 | 109.77 | 109.82 | 2778100.0 |
| 2004-05-11 12:00:00 | SPY | ETF | 109.82 | 109.94 | 109.77 | 109.84 | 1019000.0 |
| 2004-05-11 12:30:00 | SPY | ETF | 109.85 | 109.87 | 109.7 | 109.79 | 1522200.0 |
| 2004-05-11 13:00:00 | SPY | ETF | 109.78 | 109.83 | 109.55 | 109.67 | 1909000.0 |
| 2004-05-11 13:30:00 | SPY | ETF | 109.68 | 109.73 | 109.33 | 109.47 | 2603600.0 |
| 2004-05-11 14:00:00 | SPY | ETF | 109.47 | 109.85 | 109.42 | 109.78 | 3399100.0 |
| 2004-05-11 14:30:00 | SPY | ETF | 109.77 | 109.9 | 109.65 | 109.7 | 1492000.0 |
| 2004-05-11 15:00:00 | SPY | ETF | 109.71 | 109.9 | 109.58 | 109.66 | 1257900.0 |
| 2004-05-11 15:30:00 | SPY | ETF | 109.7 | 110.04 | 109.52 | 110.01 | 3579000.0 |
| 2004-05-11 16:00:00 | SPY | ETF | 110.01 | 110.05 | 109.59 | 109.84 | 3062300.0 |
| 2004-05-11 16:30:00 | SPY | ETF | 109.81 | 109.9 | 109.77 | 109.82 | 35700.0 |
| 2004-05-11 17:00:00 | SPY | ETF | 109.84 | 109.85 | 108.2 | 109.44 | 416300.0 |
| 2004-05-11 17:30:00 | SPY | ETF | 109.45 | 109.63 | 109.45 | 109.51 | 7200.0 |
| 2004-05-11 18:00:00 | SPY | ETF | 109.5 | 109.51 | 109.41 | 109.47 | 14800.0 |
| 2004-05-11 18:30:00 | SPY | ETF | 109.56 | 109.56 | 109.55 | 109.55 | 25100.0 |
| 2004-05-11 19:00:00 | SPY | ETF | 109.55 | 109.55 | 109.5 | 109.5 | 400.0 |
| 2004-05-11 19:30:00 | SPY | ETF | 109.52 | 109.52 | 109.52 | 109.52 | 1000.0 |
| 2004-05-11 08:00:00 | QQQ | ETF | 34.86 | 34.9 | 34.86 | 34.89 | 365300.0 |
| 2004-05-11 08:30:00 | QQQ | ETF | 34.9 | 34.98 | 34.9 | 34.95 | 248500.0 |
| 2004-05-11 09:00:00 | QQQ | ETF | 34.96 | 34.97 | 34.91 | 34.97 | 178500.0 |
| 2004-05-11 09:30:00 | QQQ | ETF | 34.968 | 35.164 | 34.92 | 35.117 | 16374800.0 |
| 2004-05-11 10:00:00 | QQQ | ETF | 35.12 | 35.17 | 35.03 | 35.041 | 8834700.0 |
| 2004-05-11 10:30:00 | QQQ | ETF | 35.05 | 35.29 | 35.037 | 35.2 | 12404600.0 |
| 2004-05-11 11:00:00 | QQQ | ETF | 35.185 | 35.37 | 35.17 | 35.33 | 9253900.0 |
| 2004-05-11 11:30:00 | QQQ | ETF | 35.335 | 35.38 | 35.27 | 35.28 | 4485800.0 |
| 2004-05-11 12:00:00 | QQQ | ETF | 35.28 | 35.34 | 35.24 | 35.26 | 2238800.0 |
| 2004-05-11 12:30:00 | QQQ | ETF | 35.26 | 35.28 | 35.19 | 35.25 | 2464800.0 |
| 2004-05-11 13:00:00 | QQQ | ETF | 35.242 | 35.28 | 35.14 | 35.212 | 3346800.0 |
| 2004-05-11 13:30:00 | QQQ | ETF | 35.22 | 35.23 | 35.06 | 35.128 | 5897800.0 |
| 2004-05-11 14:00:00 | QQQ | ETF | 35.129 | 35.31 | 35.1 | 35.284 | 5846200.0 |
| 2004-05-11 14:30:00 | QQQ | ETF | 35.289 | 35.33 | 35.25 | 35.28 | 5870500.0 |
| 2004-05-11 15:00:00 | QQQ | ETF | 35.28 | 35.34 | 35.182 | 35.23 | 5852200.0 |
| 2004-05-11 15:30:00 | QQQ | ETF | 35.23 | 35.35 | 35.16 | 35.3 | 9863200.0 |
| 2004-05-11 16:00:00 | QQQ | ETF | 35.3 | 35.35 | 35.098 | 35.25 | 4735200.0 |
| 2004-05-11 16:30:00 | QQQ | ETF | 35.26 | 35.34 | 35.248 | 35.281 | 776800.0 |
| 2004-05-11 17:00:00 | QQQ | ETF | 35.28 | 35.29 | 35.1 | 35.1 | 724500.0 |
| 2004-05-11 17:30:00 | QQQ | ETF | 35.11 | 35.15 | 35.06 | 35.1 | 208200.0 |
| 2004-05-11 18:00:00 | QQQ | ETF | 35.1 | 35.13 | 35.08 | 35.12 | 65100.0 |
| 2004-05-11 18:30:00 | QQQ | ETF | 35.11 | 35.13 | 35.11 | 35.13 | 8500.0 |
| 2004-05-11 19:00:00 | QQQ | ETF | 35.13 | 35.13 | 35.1 | 35.13 | 5200.0 |
| 2004-05-11 19:30:00 | QQQ | ETF | 35.1 | 35.12 | 35.1 | 35.11 | 28500.0 |
| 2004-05-11 08:00:00 | IWM | ETF | 53.87 | 53.91 | 53.87 | 53.91 | 18000.0 |
| 2004-05-11 08:30:00 | IWM | ETF | 53.93 | 53.99 | 53.93 | 53.97 | 26400.0 |
> showing 50 of 1,212 rows — these rows as CSV