PREVIEW / etf_30min / 2003-08-11
file: by_date/etf_30min/2003/2003-08-11.parquet size: 23 KB rows: 688
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-11 08:00:00 | SPY | ETF | 98.41 | 98.41 | 98.3 | 98.3 | 11800.0 |
| 2003-08-11 08:30:00 | SPY | ETF | 98.35 | 98.35 | 98.25 | 98.25 | 3700.0 |
| 2003-08-11 09:00:00 | SPY | ETF | 98.28 | 98.31 | 98.2 | 98.28 | 5100.0 |
| 2003-08-11 09:30:00 | SPY | ETF | 98.26 | 98.72 | 98.19 | 98.66 | 2643800.0 |
| 2003-08-11 10:00:00 | SPY | ETF | 98.66 | 98.99 | 98.49 | 98.93 | 3352900.0 |
| 2003-08-11 10:30:00 | SPY | ETF | 98.92 | 99.04 | 98.62 | 98.72 | 4037200.0 |
| 2003-08-11 11:00:00 | SPY | ETF | 98.73 | 98.76 | 98.269 | 98.41 | 2648800.0 |
| 2003-08-11 11:30:00 | SPY | ETF | 98.415 | 98.43 | 97.84 | 97.98 | 3974600.0 |
| 2003-08-11 12:00:00 | SPY | ETF | 98.0 | 98.12 | 97.95 | 98.091 | 1262400.0 |
| 2003-08-11 12:30:00 | SPY | ETF | 98.11 | 98.3 | 98.06 | 98.1 | 1089700.0 |
| 2003-08-11 13:00:00 | SPY | ETF | 98.1 | 98.43 | 98.07 | 98.33 | 1900400.0 |
| 2003-08-11 13:30:00 | SPY | ETF | 98.34 | 98.5 | 98.27 | 98.33 | 1944700.0 |
| 2003-08-11 14:00:00 | SPY | ETF | 98.31 | 98.36 | 98.2 | 98.349 | 703600.0 |
| 2003-08-11 14:30:00 | SPY | ETF | 98.34 | 98.47 | 98.16 | 98.24 | 804400.0 |
| 2003-08-11 15:00:00 | SPY | ETF | 98.23 | 98.582 | 98.23 | 98.313 | 2006800.0 |
| 2003-08-11 15:30:00 | SPY | ETF | 98.31 | 98.57 | 98.25 | 98.509 | 1255000.0 |
| 2003-08-11 16:00:00 | SPY | ETF | 98.51 | 98.72 | 98.48 | 98.69 | 1403600.0 |
| 2003-08-11 16:30:00 | SPY | ETF | 98.65 | 98.72 | 98.6 | 98.659 | 95800.0 |
| 2003-08-11 17:00:00 | SPY | ETF | 98.67 | 98.68 | 98.66 | 98.68 | 50400.0 |
| 2003-08-11 17:30:00 | SPY | ETF | 98.65 | 98.65 | 98.63 | 98.63 | 1800.0 |
| 2003-08-11 18:00:00 | SPY | ETF | 98.61 | 98.61 | 98.61 | 98.61 | 200.0 |
| 2003-08-11 18:30:00 | SPY | ETF | 98.62 | 98.65 | 98.62 | 98.65 | 3100.0 |
| 2003-08-11 19:30:00 | SPY | ETF | 98.66 | 98.66 | 98.66 | 98.66 | 500.0 |
| 2003-08-11 08:00:00 | QQQ | ETF | 30.14 | 30.14 | 30.09 | 30.12 | 20100.0 |
| 2003-08-11 08:30:00 | QQQ | ETF | 30.11 | 30.14 | 30.09 | 30.11 | 40200.0 |
| 2003-08-11 09:00:00 | QQQ | ETF | 30.13 | 30.13 | 30.08 | 30.09 | 30300.0 |
| 2003-08-11 09:30:00 | QQQ | ETF | 30.08 | 30.375 | 30.03 | 30.33 | 8587900.0 |
| 2003-08-11 10:00:00 | QQQ | ETF | 30.33 | 30.55 | 30.214 | 30.5 | 10605300.0 |
| 2003-08-11 10:30:00 | QQQ | ETF | 30.51 | 30.6 | 30.46 | 30.52 | 6517700.0 |
| 2003-08-11 11:00:00 | QQQ | ETF | 30.52 | 30.55 | 30.36 | 30.45 | 3143900.0 |
| 2003-08-11 11:30:00 | QQQ | ETF | 30.44 | 30.47 | 30.11 | 30.2 | 7432000.0 |
| 2003-08-11 12:00:00 | QQQ | ETF | 30.218 | 30.28 | 30.17 | 30.27 | 2289200.0 |
| 2003-08-11 12:30:00 | QQQ | ETF | 30.26 | 30.35 | 30.2 | 30.22 | 2075300.0 |
| 2003-08-11 13:00:00 | QQQ | ETF | 30.22 | 30.4 | 30.2 | 30.34 | 3918700.0 |
| 2003-08-11 13:30:00 | QQQ | ETF | 30.34 | 30.41 | 30.319 | 30.33 | 1732400.0 |
| 2003-08-11 14:00:00 | QQQ | ETF | 30.33 | 30.38 | 30.274 | 30.38 | 1408400.0 |
| 2003-08-11 14:30:00 | QQQ | ETF | 30.36 | 30.41 | 30.25 | 30.3 | 1951300.0 |
| 2003-08-11 15:00:00 | QQQ | ETF | 30.304 | 30.455 | 30.29 | 30.333 | 2993500.0 |
| 2003-08-11 15:30:00 | QQQ | ETF | 30.327 | 30.47 | 30.318 | 30.4 | 4145500.0 |
| 2003-08-11 16:00:00 | QQQ | ETF | 30.422 | 30.46 | 30.37 | 30.37 | 1434800.0 |
| 2003-08-11 16:30:00 | QQQ | ETF | 30.37 | 30.41 | 30.37 | 30.39 | 54700.0 |
| 2003-08-11 17:00:00 | QQQ | ETF | 30.38 | 30.42 | 30.38 | 30.4 | 17500.0 |
| 2003-08-11 17:30:00 | QQQ | ETF | 30.41 | 30.45 | 30.4 | 30.43 | 12600.0 |
| 2003-08-11 18:00:00 | QQQ | ETF | 30.43 | 30.44 | 30.42 | 30.44 | 9500.0 |
| 2003-08-11 18:30:00 | QQQ | ETF | 30.44 | 30.45 | 30.43 | 30.45 | 6000.0 |
| 2003-08-11 19:30:00 | QQQ | ETF | 30.47 | 30.48 | 30.47 | 30.48 | 5800.0 |
| 2003-08-11 08:30:00 | IWM | ETF | 45.3 | 45.3 | 45.3 | 45.3 | 600.0 |
| 2003-08-11 09:30:00 | IWM | ETF | 45.22 | 45.555 | 45.22 | 45.55 | 372200.0 |
| 2003-08-11 10:00:00 | IWM | ETF | 45.535 | 45.77 | 45.46 | 45.765 | 1348000.0 |
| 2003-08-11 10:30:00 | IWM | ETF | 45.775 | 45.775 | 45.715 | 45.73 | 253800.0 |
> showing 50 of 688 rows — these rows as CSV