PREVIEW / etf_30min / 2003-09-09
file: by_date/etf_30min/2003/2003-09-09.parquet size: 24 KB rows: 743
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-09 08:00:00 | SPY | ETF | 103.65 | 103.65 | 103.57 | 103.59 | 14400.0 |
| 2003-09-09 08:30:00 | SPY | ETF | 103.58 | 103.62 | 103.48 | 103.51 | 16100.0 |
| 2003-09-09 09:00:00 | SPY | ETF | 103.49 | 103.49 | 103.36 | 103.39 | 21600.0 |
| 2003-09-09 09:30:00 | SPY | ETF | 103.37 | 103.46 | 103.2 | 103.25 | 5471700.0 |
| 2003-09-09 10:00:00 | SPY | ETF | 103.25 | 103.38 | 102.72 | 102.9 | 3671600.0 |
| 2003-09-09 10:30:00 | SPY | ETF | 102.9 | 103.16 | 102.83 | 103.11 | 3058600.0 |
| 2003-09-09 11:00:00 | SPY | ETF | 103.12 | 103.22 | 103.02 | 103.18 | 1721700.0 |
| 2003-09-09 11:30:00 | SPY | ETF | 103.17 | 103.46 | 103.17 | 103.27 | 2222400.0 |
| 2003-09-09 12:00:00 | SPY | ETF | 103.31 | 103.44 | 103.16 | 103.19 | 1300900.0 |
| 2003-09-09 12:30:00 | SPY | ETF | 103.2 | 103.35 | 103.17 | 103.25 | 694100.0 |
| 2003-09-09 13:00:00 | SPY | ETF | 103.22 | 103.25 | 103.01 | 103.14 | 1133200.0 |
| 2003-09-09 13:30:00 | SPY | ETF | 103.14 | 103.23 | 103.04 | 103.21 | 1507300.0 |
| 2003-09-09 14:00:00 | SPY | ETF | 103.19 | 103.33 | 103.096 | 103.21 | 927200.0 |
| 2003-09-09 14:30:00 | SPY | ETF | 103.2 | 103.23 | 103.05 | 103.14 | 1375900.0 |
| 2003-09-09 15:00:00 | SPY | ETF | 103.11 | 103.16 | 102.8 | 102.82 | 2086600.0 |
| 2003-09-09 15:30:00 | SPY | ETF | 102.81 | 102.96 | 102.68 | 102.927 | 2180400.0 |
| 2003-09-09 16:00:00 | SPY | ETF | 102.93 | 103.93 | 102.9 | 103.02 | 1001100.0 |
| 2003-09-09 16:30:00 | SPY | ETF | 103.02 | 103.03 | 102.85 | 102.875 | 177100.0 |
| 2003-09-09 17:00:00 | SPY | ETF | 102.87 | 102.93 | 102.87 | 102.93 | 116100.0 |
| 2003-09-09 17:30:00 | SPY | ETF | 102.93 | 102.96 | 102.92 | 102.96 | 15500.0 |
| 2003-09-09 18:00:00 | SPY | ETF | 102.95 | 102.95 | 102.92 | 102.92 | 11000.0 |
| 2003-09-09 18:30:00 | SPY | ETF | 102.97 | 102.97 | 102.97 | 102.97 | 1200.0 |
| 2003-09-09 19:00:00 | SPY | ETF | 102.91 | 102.91 | 102.91 | 102.91 | 200.0 |
| 2003-09-09 19:30:00 | SPY | ETF | 102.96 | 102.96 | 102.94 | 102.94 | 400.0 |
| 2003-09-09 08:00:00 | QQQ | ETF | 34.4 | 34.46 | 34.4 | 34.41 | 20000.0 |
| 2003-09-09 08:30:00 | QQQ | ETF | 34.41 | 34.43 | 34.39 | 34.41 | 41500.0 |
| 2003-09-09 09:00:00 | QQQ | ETF | 34.4 | 34.4 | 34.31 | 34.32 | 149700.0 |
| 2003-09-09 09:30:00 | QQQ | ETF | 34.32 | 34.34 | 34.17 | 34.19 | 9505600.0 |
| 2003-09-09 10:00:00 | QQQ | ETF | 34.19 | 34.29 | 33.93 | 34.02 | 14471700.0 |
| 2003-09-09 10:30:00 | QQQ | ETF | 34.03 | 34.19 | 33.98 | 34.16 | 7889400.0 |
| 2003-09-09 11:00:00 | QQQ | ETF | 34.17 | 34.22 | 34.108 | 34.2 | 5223200.0 |
| 2003-09-09 11:30:00 | QQQ | ETF | 34.19 | 34.32 | 34.19 | 34.27 | 4690900.0 |
| 2003-09-09 12:00:00 | QQQ | ETF | 34.27 | 34.386 | 34.26 | 34.27 | 3551000.0 |
| 2003-09-09 12:30:00 | QQQ | ETF | 34.273 | 34.34 | 34.25 | 34.28 | 1453600.0 |
| 2003-09-09 13:00:00 | QQQ | ETF | 34.28 | 34.28 | 34.16 | 34.24 | 4149000.0 |
| 2003-09-09 13:30:00 | QQQ | ETF | 34.24 | 34.292 | 34.19 | 34.29 | 1650300.0 |
| 2003-09-09 14:00:00 | QQQ | ETF | 34.29 | 34.3 | 34.2 | 34.22 | 2110500.0 |
| 2003-09-09 14:30:00 | QQQ | ETF | 34.23 | 34.24 | 34.07 | 34.14 | 4267600.0 |
| 2003-09-09 15:00:00 | QQQ | ETF | 34.14 | 34.16 | 33.97 | 33.99 | 4369300.0 |
| 2003-09-09 15:30:00 | QQQ | ETF | 33.983 | 34.08 | 33.92 | 34.05 | 5891700.0 |
| 2003-09-09 16:00:00 | QQQ | ETF | 34.044 | 34.11 | 34.02 | 34.07 | 2122200.0 |
| 2003-09-09 16:30:00 | QQQ | ETF | 34.08 | 34.09 | 33.86 | 33.93 | 1953000.0 |
| 2003-09-09 17:00:00 | QQQ | ETF | 33.93 | 34.4763 | 33.91 | 33.93 | 2576700.0 |
| 2003-09-09 17:30:00 | QQQ | ETF | 33.93 | 33.95 | 33.92 | 33.94 | 177400.0 |
| 2003-09-09 18:00:00 | QQQ | ETF | 33.95 | 33.98 | 33.94 | 33.94 | 18000.0 |
| 2003-09-09 18:30:00 | QQQ | ETF | 33.95 | 33.97 | 33.95 | 33.95 | 5100.0 |
| 2003-09-09 19:00:00 | QQQ | ETF | 33.98 | 33.98 | 33.98 | 33.98 | 5800.0 |
| 2003-09-09 19:30:00 | QQQ | ETF | 33.98 | 34.0 | 33.98 | 34.0 | 12000.0 |
| 2003-09-09 08:30:00 | IWM | ETF | 51.555 | 51.555 | 51.555 | 51.555 | 200.0 |
| 2003-09-09 09:30:00 | IWM | ETF | 51.525 | 51.59 | 51.4 | 51.445 | 498800.0 |
> showing 50 of 743 rows — these rows as CSV