PREVIEW / etf_30min / 2003-01-14
file: by_date/etf_30min/2003/2003-01-14.parquet size: 21 KB rows: 650
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-01-14 08:00:00 | SPY | ETF | 93.24 | 93.34 | 93.1 | 93.27 | 45700.0 |
| 2003-01-14 08:30:00 | SPY | ETF | 93.33 | 93.33 | 92.6 | 92.77 | 112400.0 |
| 2003-01-14 09:00:00 | SPY | ETF | 92.7 | 92.82 | 92.68 | 92.71 | 56900.0 |
| 2003-01-14 09:30:00 | SPY | ETF | 92.69 | 92.97 | 92.41 | 92.8 | 4001900.0 |
| 2003-01-14 10:00:00 | SPY | ETF | 92.81 | 93.09 | 92.52 | 93.02 | 3518500.0 |
| 2003-01-14 10:30:00 | SPY | ETF | 93.07 | 93.28 | 92.87 | 92.9 | 2497100.0 |
| 2003-01-14 11:00:00 | SPY | ETF | 92.95 | 93.12 | 92.88 | 92.97 | 1316000.0 |
| 2003-01-14 11:30:00 | SPY | ETF | 92.97 | 93.25 | 92.91 | 93.16 | 734900.0 |
| 2003-01-14 12:00:00 | SPY | ETF | 93.13 | 93.26 | 93.01 | 93.1 | 459400.0 |
| 2003-01-14 12:30:00 | SPY | ETF | 93.11 | 93.23 | 93.03 | 93.11 | 843900.0 |
| 2003-01-14 13:00:00 | SPY | ETF | 93.08 | 93.34 | 93.07 | 93.22 | 950900.0 |
| 2003-01-14 13:30:00 | SPY | ETF | 93.22 | 93.33 | 93.14 | 93.27 | 958200.0 |
| 2003-01-14 14:00:00 | SPY | ETF | 93.28 | 93.37 | 93.0 | 93.02 | 943700.0 |
| 2003-01-14 14:30:00 | SPY | ETF | 93.02 | 93.12 | 92.92 | 93.01 | 906100.0 |
| 2003-01-14 15:00:00 | SPY | ETF | 93.05 | 93.23 | 92.99 | 93.14 | 1329900.0 |
| 2003-01-14 15:30:00 | SPY | ETF | 93.14 | 93.49 | 93.13 | 93.43 | 1900200.0 |
| 2003-01-14 16:00:00 | SPY | ETF | 93.47 | 93.7 | 92.45 | 93.21 | 1274600.0 |
| 2003-01-14 16:30:00 | SPY | ETF | 93.33 | 93.33 | 93.05 | 93.22 | 246500.0 |
| 2003-01-14 17:00:00 | SPY | ETF | 93.28 | 93.37 | 93.22 | 93.28 | 221900.0 |
| 2003-01-14 17:30:00 | SPY | ETF | 93.28 | 93.35 | 92.32 | 93.27 | 23300.0 |
| 2003-01-14 18:00:00 | SPY | ETF | 93.26 | 93.29 | 93.23 | 93.29 | 5000.0 |
| 2003-01-14 18:30:00 | SPY | ETF | 93.27 | 93.4 | 93.27 | 93.36 | 18800.0 |
| 2003-01-14 19:30:00 | SPY | ETF | 93.44 | 93.55 | 93.44 | 93.51 | 2600.0 |
| 2003-01-14 08:00:00 | QQQ | ETF | 27.09 | 27.12 | 27.05 | 27.09 | 26500.0 |
| 2003-01-14 08:30:00 | QQQ | ETF | 27.1 | 27.13 | 26.86 | 26.88 | 124300.0 |
| 2003-01-14 09:00:00 | QQQ | ETF | 26.88 | 26.94 | 26.85 | 26.92 | 48800.0 |
| 2003-01-14 09:30:00 | QQQ | ETF | 26.92 | 27.17 | 26.85 | 27.14 | 7254200.0 |
| 2003-01-14 10:00:00 | QQQ | ETF | 27.15 | 27.24 | 26.95 | 27.24 | 6027900.0 |
| 2003-01-14 10:30:00 | QQQ | ETF | 27.24 | 27.32 | 27.05 | 27.06 | 4997600.0 |
| 2003-01-14 11:00:00 | QQQ | ETF | 27.06 | 27.18 | 27.04 | 27.12 | 2662900.0 |
| 2003-01-14 11:30:00 | QQQ | ETF | 27.11 | 27.2 | 27.07 | 27.18 | 1473700.0 |
| 2003-01-14 12:00:00 | QQQ | ETF | 27.17 | 27.2 | 27.12 | 27.15 | 1357500.0 |
| 2003-01-14 12:30:00 | QQQ | ETF | 27.15 | 27.17 | 27.08 | 27.09 | 887800.0 |
| 2003-01-14 13:00:00 | QQQ | ETF | 27.1 | 27.15 | 27.06 | 27.11 | 1149400.0 |
| 2003-01-14 13:30:00 | QQQ | ETF | 27.12 | 27.13 | 27.03 | 27.12 | 1645200.0 |
| 2003-01-14 14:00:00 | QQQ | ETF | 27.13 | 27.19 | 27.05 | 27.06 | 1250600.0 |
| 2003-01-14 14:30:00 | QQQ | ETF | 27.06 | 27.09 | 26.98 | 27.06 | 2370800.0 |
| 2003-01-14 15:00:00 | QQQ | ETF | 27.06 | 27.18 | 27.05 | 27.13 | 2053100.0 |
| 2003-01-14 15:30:00 | QQQ | ETF | 27.13 | 27.21 | 27.11 | 27.19 | 4691000.0 |
| 2003-01-14 16:00:00 | QQQ | ETF | 27.17 | 27.28 | 27.02 | 27.1 | 3631500.0 |
| 2003-01-14 16:30:00 | QQQ | ETF | 27.1 | 27.16 | 26.94 | 27.08 | 893100.0 |
| 2003-01-14 17:00:00 | QQQ | ETF | 27.1 | 27.16 | 27.06 | 27.16 | 335100.0 |
| 2003-01-14 17:30:00 | QQQ | ETF | 27.16 | 27.22 | 27.11 | 27.11 | 184000.0 |
| 2003-01-14 18:00:00 | QQQ | ETF | 27.15 | 27.19 | 27.12 | 27.19 | 22700.0 |
| 2003-01-14 18:30:00 | QQQ | ETF | 27.18 | 27.2 | 27.15 | 27.2 | 12400.0 |
| 2003-01-14 19:00:00 | QQQ | ETF | 27.21 | 27.21 | 27.18 | 27.18 | 4900.0 |
| 2003-01-14 19:30:00 | QQQ | ETF | 27.18 | 27.24 | 27.18 | 27.24 | 32800.0 |
| 2003-01-14 09:30:00 | IWM | ETF | 39.45 | 39.54 | 39.32 | 39.445 | 181200.0 |
| 2003-01-14 10:00:00 | IWM | ETF | 39.495 | 39.515 | 39.26 | 39.475 | 315800.0 |
| 2003-01-14 10:30:00 | IWM | ETF | 39.485 | 39.535 | 39.37 | 39.37 | 328800.0 |
> showing 50 of 650 rows — these rows as CSV