PREVIEW / etf_30min / 2003-09-17
file: by_date/etf_30min/2003/2003-09-17.parquet size: 24 KB rows: 731
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-09-17 08:00:00 | SPY | ETF | 103.56 | 103.56 | 103.38 | 103.44 | 41900.0 |
| 2003-09-17 08:30:00 | SPY | ETF | 103.41 | 103.5 | 103.4 | 103.48 | 9500.0 |
| 2003-09-17 09:00:00 | SPY | ETF | 103.48 | 103.53 | 103.39 | 103.51 | 94000.0 |
| 2003-09-17 09:30:00 | SPY | ETF | 103.48 | 103.75 | 103.38 | 103.73 | 3812600.0 |
| 2003-09-17 10:00:00 | SPY | ETF | 103.72 | 103.778 | 103.52 | 103.69 | 1639900.0 |
| 2003-09-17 10:30:00 | SPY | ETF | 103.7 | 103.785 | 103.32 | 103.44 | 2170100.0 |
| 2003-09-17 11:00:00 | SPY | ETF | 103.4 | 103.61 | 103.4 | 103.51 | 909400.0 |
| 2003-09-17 11:30:00 | SPY | ETF | 103.51 | 103.64 | 103.45 | 103.611 | 725400.0 |
| 2003-09-17 12:00:00 | SPY | ETF | 103.63 | 103.68 | 103.51 | 103.65 | 793900.0 |
| 2003-09-17 12:30:00 | SPY | ETF | 103.623 | 103.76 | 103.623 | 103.685 | 956400.0 |
| 2003-09-17 13:00:00 | SPY | ETF | 103.7 | 103.71 | 103.31 | 103.35 | 2076800.0 |
| 2003-09-17 13:30:00 | SPY | ETF | 103.35 | 103.43 | 103.22 | 103.25 | 2465400.0 |
| 2003-09-17 14:00:00 | SPY | ETF | 103.26 | 103.33 | 103.06 | 103.17 | 4272000.0 |
| 2003-09-17 14:30:00 | SPY | ETF | 103.2 | 103.38 | 103.12 | 103.161 | 2426900.0 |
| 2003-09-17 15:00:00 | SPY | ETF | 103.161 | 103.382 | 103.16 | 103.29 | 1200700.0 |
| 2003-09-17 15:30:00 | SPY | ETF | 103.28 | 103.36 | 103.19 | 103.22 | 2058400.0 |
| 2003-09-17 16:00:00 | SPY | ETF | 103.22 | 103.38 | 103.21 | 103.3 | 1355500.0 |
| 2003-09-17 16:30:00 | SPY | ETF | 103.29 | 103.36 | 103.28 | 103.29 | 49300.0 |
| 2003-09-17 17:00:00 | SPY | ETF | 103.31 | 103.34 | 103.249 | 103.34 | 183100.0 |
| 2003-09-17 17:30:00 | SPY | ETF | 103.36 | 103.36 | 103.36 | 103.36 | 500.0 |
| 2003-09-17 18:00:00 | SPY | ETF | 103.36 | 103.38 | 103.35 | 103.35 | 3800.0 |
| 2003-09-17 19:00:00 | SPY | ETF | 103.28 | 103.28 | 103.28 | 103.28 | 500.0 |
| 2003-09-17 08:00:00 | QQQ | ETF | 34.37 | 34.37 | 34.22 | 34.26 | 83400.0 |
| 2003-09-17 08:30:00 | QQQ | ETF | 34.26 | 34.34 | 34.24 | 34.33 | 119500.0 |
| 2003-09-17 09:00:00 | QQQ | ETF | 34.32 | 34.35 | 34.29 | 34.33 | 168100.0 |
| 2003-09-17 09:30:00 | QQQ | ETF | 34.33 | 34.49 | 34.28 | 34.43 | 9122900.0 |
| 2003-09-17 10:00:00 | QQQ | ETF | 34.425 | 34.501 | 34.305 | 34.453 | 5888500.0 |
| 2003-09-17 10:30:00 | QQQ | ETF | 34.453 | 34.5 | 34.26 | 34.29 | 5544200.0 |
| 2003-09-17 11:00:00 | QQQ | ETF | 34.29 | 34.38 | 34.28 | 34.33 | 2671300.0 |
| 2003-09-17 11:30:00 | QQQ | ETF | 34.337 | 34.43 | 34.28 | 34.4 | 3715400.0 |
| 2003-09-17 12:00:00 | QQQ | ETF | 34.43 | 34.45 | 34.35 | 34.41 | 2531500.0 |
| 2003-09-17 12:30:00 | QQQ | ETF | 34.4 | 34.48 | 34.39 | 34.43 | 1941100.0 |
| 2003-09-17 13:00:00 | QQQ | ETF | 34.42 | 34.43 | 34.238 | 34.24 | 3836900.0 |
| 2003-09-17 13:30:00 | QQQ | ETF | 34.24 | 34.27 | 34.1 | 34.13 | 10263700.0 |
| 2003-09-17 14:00:00 | QQQ | ETF | 34.13 | 34.17 | 34.03 | 34.146 | 6182300.0 |
| 2003-09-17 14:30:00 | QQQ | ETF | 34.146 | 34.24 | 34.11 | 34.14 | 5536300.0 |
| 2003-09-17 15:00:00 | QQQ | ETF | 34.14 | 34.27 | 34.13 | 34.2 | 3888700.0 |
| 2003-09-17 15:30:00 | QQQ | ETF | 34.2 | 34.26 | 34.11 | 34.171 | 6807500.0 |
| 2003-09-17 16:00:00 | QQQ | ETF | 34.17 | 34.26 | 34.17 | 34.24 | 961800.0 |
| 2003-09-17 16:30:00 | QQQ | ETF | 34.24 | 34.259 | 34.23 | 34.25 | 130200.0 |
| 2003-09-17 17:00:00 | QQQ | ETF | 34.25 | 34.27 | 34.1781 | 34.246 | 185200.0 |
| 2003-09-17 17:30:00 | QQQ | ETF | 34.25 | 34.28 | 34.24 | 34.26 | 11400.0 |
| 2003-09-17 18:00:00 | QQQ | ETF | 34.25 | 34.27 | 34.25 | 34.27 | 4000.0 |
| 2003-09-17 18:30:00 | QQQ | ETF | 34.25 | 34.25 | 34.24 | 34.24 | 3700.0 |
| 2003-09-17 19:00:00 | QQQ | ETF | 34.26 | 34.26 | 34.26 | 34.26 | 200.0 |
| 2003-09-17 19:30:00 | QQQ | ETF | 34.26 | 34.28 | 34.25 | 34.25 | 7000.0 |
| 2003-09-17 08:00:00 | IWM | ETF | 51.185 | 51.185 | 51.185 | 51.185 | 1800.0 |
| 2003-09-17 09:00:00 | IWM | ETF | 51.315 | 51.315 | 51.315 | 51.315 | 200.0 |
| 2003-09-17 09:30:00 | IWM | ETF | 51.285 | 51.44 | 51.09 | 51.44 | 798400.0 |
| 2003-09-17 10:00:00 | IWM | ETF | 51.44 | 51.485 | 51.27 | 51.47 | 255400.0 |
> showing 50 of 731 rows — these rows as CSV