PREVIEW / etf_30min / 2003-12-15
file: by_date/etf_30min/2003/2003-12-15.parquet size: 29 KB rows: 892
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-12-15 08:00:00 | SPY | ETF | 109.23 | 109.3 | 109.09 | 109.25 | 212300.0 |
| 2003-12-15 08:30:00 | SPY | ETF | 109.28 | 109.39 | 109.24 | 109.31 | 290800.0 |
| 2003-12-15 09:00:00 | SPY | ETF | 109.3 | 109.31 | 109.19 | 109.19 | 189000.0 |
| 2003-12-15 09:30:00 | SPY | ETF | 109.17 | 109.23 | 108.58 | 108.67 | 8060800.0 |
| 2003-12-15 10:00:00 | SPY | ETF | 108.66 | 108.84 | 108.51 | 108.62 | 2880300.0 |
| 2003-12-15 10:30:00 | SPY | ETF | 108.62 | 108.8 | 108.58 | 108.61 | 1865600.0 |
| 2003-12-15 11:00:00 | SPY | ETF | 108.61 | 108.63 | 108.41 | 108.56 | 2641300.0 |
| 2003-12-15 11:30:00 | SPY | ETF | 108.56 | 108.76 | 108.5 | 108.7 | 1237600.0 |
| 2003-12-15 12:00:00 | SPY | ETF | 108.72 | 108.72 | 108.57 | 108.58 | 805100.0 |
| 2003-12-15 12:30:00 | SPY | ETF | 108.59 | 108.6 | 108.36 | 108.53 | 1121600.0 |
| 2003-12-15 13:00:00 | SPY | ETF | 108.53 | 108.6 | 108.24 | 108.24 | 1093100.0 |
| 2003-12-15 13:30:00 | SPY | ETF | 108.26 | 108.46 | 108.18 | 108.22 | 1757900.0 |
| 2003-12-15 14:00:00 | SPY | ETF | 108.21 | 108.51 | 108.18 | 108.41 | 1939700.0 |
| 2003-12-15 14:30:00 | SPY | ETF | 108.42 | 108.48 | 107.95 | 107.95 | 2575700.0 |
| 2003-12-15 15:00:00 | SPY | ETF | 107.97 | 108.08 | 107.78 | 107.88 | 2505700.0 |
| 2003-12-15 15:30:00 | SPY | ETF | 107.86 | 107.9 | 107.48 | 107.53 | 4580200.0 |
| 2003-12-15 16:00:00 | SPY | ETF | 107.53 | 107.64 | 107.48 | 107.58 | 1235900.0 |
| 2003-12-15 16:30:00 | SPY | ETF | 107.58 | 107.6 | 107.53 | 107.53 | 59200.0 |
| 2003-12-15 17:00:00 | SPY | ETF | 107.54 | 107.57 | 107.48 | 107.53 | 14200.0 |
| 2003-12-15 17:30:00 | SPY | ETF | 107.5 | 107.5 | 107.5 | 107.5 | 300.0 |
| 2003-12-15 18:00:00 | SPY | ETF | 107.54 | 107.54 | 107.47 | 107.47 | 1600.0 |
| 2003-12-15 18:30:00 | SPY | ETF | 107.46 | 107.46 | 107.46 | 107.46 | 600.0 |
| 2003-12-15 08:00:00 | QQQ | ETF | 35.85 | 35.88 | 35.82 | 35.88 | 504800.0 |
| 2003-12-15 08:30:00 | QQQ | ETF | 35.87 | 35.97 | 35.86 | 35.93 | 566000.0 |
| 2003-12-15 09:00:00 | QQQ | ETF | 35.94 | 35.96 | 35.86 | 35.92 | 716000.0 |
| 2003-12-15 09:30:00 | QQQ | ETF | 35.93 | 35.99 | 35.54 | 35.6 | 19306300.0 |
| 2003-12-15 10:00:00 | QQQ | ETF | 35.63 | 35.7 | 35.5 | 35.59 | 8128500.0 |
| 2003-12-15 10:30:00 | QQQ | ETF | 35.6 | 35.67 | 35.52 | 35.54 | 4673200.0 |
| 2003-12-15 11:00:00 | QQQ | ETF | 35.523 | 35.54 | 35.36 | 35.457 | 7187400.0 |
| 2003-12-15 11:30:00 | QQQ | ETF | 35.46 | 35.56 | 35.42 | 35.51 | 3785100.0 |
| 2003-12-15 12:00:00 | QQQ | ETF | 35.5 | 35.54 | 35.41 | 35.46 | 2872000.0 |
| 2003-12-15 12:30:00 | QQQ | ETF | 35.45 | 35.48 | 35.23 | 35.31 | 5907000.0 |
| 2003-12-15 13:00:00 | QQQ | ETF | 35.32 | 35.352 | 35.12 | 35.131 | 5239600.0 |
| 2003-12-15 13:30:00 | QQQ | ETF | 35.14 | 35.28 | 35.07 | 35.148 | 5630000.0 |
| 2003-12-15 14:00:00 | QQQ | ETF | 35.15 | 35.33 | 35.13 | 35.3 | 5279800.0 |
| 2003-12-15 14:30:00 | QQQ | ETF | 35.29 | 35.361 | 35.11 | 35.12 | 4523900.0 |
| 2003-12-15 15:00:00 | QQQ | ETF | 35.13 | 35.242 | 34.987 | 35.032 | 7089100.0 |
| 2003-12-15 15:30:00 | QQQ | ETF | 35.03 | 35.08 | 34.7 | 34.75 | 12062800.0 |
| 2003-12-15 16:00:00 | QQQ | ETF | 34.75 | 34.82 | 34.65 | 34.801 | 4423900.0 |
| 2003-12-15 16:30:00 | QQQ | ETF | 34.801 | 34.9 | 34.72 | 34.74 | 947300.0 |
| 2003-12-15 17:00:00 | QQQ | ETF | 34.74 | 34.75 | 34.7 | 34.7 | 46900.0 |
| 2003-12-15 17:30:00 | QQQ | ETF | 34.72 | 34.72 | 34.7 | 34.7 | 114400.0 |
| 2003-12-15 18:00:00 | QQQ | ETF | 34.69 | 34.73 | 34.68 | 34.72 | 39000.0 |
| 2003-12-15 18:30:00 | QQQ | ETF | 34.7 | 34.7 | 34.7 | 34.7 | 1500.0 |
| 2003-12-15 19:00:00 | QQQ | ETF | 34.72 | 34.74 | 34.7 | 34.74 | 13400.0 |
| 2003-12-15 19:30:00 | QQQ | ETF | 34.73 | 34.75 | 34.72 | 34.72 | 5300.0 |
| 2003-12-15 08:00:00 | IWM | ETF | 55.375 | 55.5 | 55.25 | 55.25 | 15600.0 |
| 2003-12-15 08:30:00 | IWM | ETF | 55.3 | 55.35 | 55.3 | 55.335 | 5000.0 |
| 2003-12-15 09:00:00 | IWM | ETF | 55.425 | 55.425 | 55.35 | 55.4 | 18800.0 |
| 2003-12-15 09:30:00 | IWM | ETF | 55.45 | 55.45 | 54.8205 | 54.85 | 1515000.0 |
> showing 50 of 892 rows — these rows as CSV