PREVIEW / etf_30min / 2003-04-11
file: by_date/etf_30min/2003/2003-04-11.parquet size: 21 KB rows: 642
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-04-11 08:00:00 | SPY | ETF | 87.76 | 87.99 | 87.74 | 87.9 | 59800.0 |
| 2003-04-11 08:30:00 | SPY | ETF | 87.9 | 88.38 | 87.9 | 88.36 | 176500.0 |
| 2003-04-11 09:00:00 | SPY | ETF | 88.32 | 88.41 | 88.19 | 88.19 | 73900.0 |
| 2003-04-11 09:30:00 | SPY | ETF | 88.16 | 88.7 | 88.14 | 88.31 | 7763900.0 |
| 2003-04-11 10:00:00 | SPY | ETF | 88.33 | 88.38 | 87.35 | 87.6 | 9301100.0 |
| 2003-04-11 10:30:00 | SPY | ETF | 87.61 | 87.76 | 87.08 | 87.29 | 4650400.0 |
| 2003-04-11 11:00:00 | SPY | ETF | 87.3 | 87.47 | 87.1 | 87.16 | 1817200.0 |
| 2003-04-11 11:30:00 | SPY | ETF | 87.18 | 87.38 | 87.07 | 87.35 | 1879100.0 |
| 2003-04-11 12:00:00 | SPY | ETF | 87.34 | 87.51 | 87.25 | 87.35 | 2175200.0 |
| 2003-04-11 12:30:00 | SPY | ETF | 87.35 | 87.46 | 87.2 | 87.24 | 1332800.0 |
| 2003-04-11 13:00:00 | SPY | ETF | 87.24 | 87.4 | 87.0 | 87.05 | 1781400.0 |
| 2003-04-11 13:30:00 | SPY | ETF | 87.01 | 87.11 | 86.86 | 86.89 | 2327600.0 |
| 2003-04-11 14:00:00 | SPY | ETF | 86.9 | 87.21 | 86.87 | 87.12 | 1344500.0 |
| 2003-04-11 14:30:00 | SPY | ETF | 87.14 | 87.38 | 87.08 | 87.08 | 829400.0 |
| 2003-04-11 15:00:00 | SPY | ETF | 87.08 | 87.31 | 86.95 | 87.23 | 1246900.0 |
| 2003-04-11 15:30:00 | SPY | ETF | 87.25 | 87.31 | 87.01 | 87.17 | 2675300.0 |
| 2003-04-11 16:00:00 | SPY | ETF | 87.17 | 87.24 | 87.03 | 87.14 | 3119100.0 |
| 2003-04-11 16:30:00 | SPY | ETF | 87.15 | 87.22 | 87.15 | 87.19 | 24000.0 |
| 2003-04-11 17:00:00 | SPY | ETF | 87.18 | 87.21 | 87.18 | 87.2 | 17100.0 |
| 2003-04-11 17:30:00 | SPY | ETF | 87.2 | 87.23 | 87.19 | 87.19 | 5400.0 |
| 2003-04-11 18:00:00 | SPY | ETF | 87.2 | 87.2 | 87.19 | 87.2 | 2300.0 |
| 2003-04-11 18:30:00 | SPY | ETF | 87.2 | 87.21 | 87.19 | 87.21 | 4500.0 |
| 2003-04-11 19:00:00 | SPY | ETF | 87.2 | 87.21 | 87.2 | 87.21 | 1400.0 |
| 2003-04-11 19:30:00 | SPY | ETF | 87.21 | 87.21 | 87.19 | 87.21 | 700.0 |
| 2003-04-11 08:00:00 | QQQ | ETF | 25.86 | 25.92 | 25.86 | 25.9 | 74800.0 |
| 2003-04-11 08:30:00 | QQQ | ETF | 25.95 | 26.07 | 25.95 | 26.03 | 185500.0 |
| 2003-04-11 09:00:00 | QQQ | ETF | 26.02 | 26.08 | 26.02 | 26.03 | 104800.0 |
| 2003-04-11 09:30:00 | QQQ | ETF | 26.02 | 26.16 | 25.84 | 25.91 | 15277700.0 |
| 2003-04-11 10:00:00 | QQQ | ETF | 25.92 | 25.94 | 25.53 | 25.69 | 10920500.0 |
| 2003-04-11 10:30:00 | QQQ | ETF | 25.7 | 25.74 | 25.47 | 25.56 | 6976400.0 |
| 2003-04-11 11:00:00 | QQQ | ETF | 25.55 | 25.65 | 25.5 | 25.51 | 3422700.0 |
| 2003-04-11 11:30:00 | QQQ | ETF | 25.51 | 25.56 | 25.44 | 25.54 | 4181000.0 |
| 2003-04-11 12:00:00 | QQQ | ETF | 25.53 | 25.6 | 25.51 | 25.58 | 1960500.0 |
| 2003-04-11 12:30:00 | QQQ | ETF | 25.57 | 25.6 | 25.49 | 25.5 | 982900.0 |
| 2003-04-11 13:00:00 | QQQ | ETF | 25.5 | 25.55 | 25.37 | 25.41 | 1834000.0 |
| 2003-04-11 13:30:00 | QQQ | ETF | 25.4 | 25.5 | 25.36 | 25.41 | 3498900.0 |
| 2003-04-11 14:00:00 | QQQ | ETF | 25.41 | 25.52 | 25.37 | 25.48 | 1963800.0 |
| 2003-04-11 14:30:00 | QQQ | ETF | 25.48 | 25.59 | 25.44 | 25.46 | 2444200.0 |
| 2003-04-11 15:00:00 | QQQ | ETF | 25.45 | 25.54 | 25.39 | 25.52 | 2087100.0 |
| 2003-04-11 15:30:00 | QQQ | ETF | 25.53 | 25.53 | 25.41 | 25.51 | 4464500.0 |
| 2003-04-11 16:00:00 | QQQ | ETF | 25.5 | 25.55 | 25.47 | 25.52 | 2261600.0 |
| 2003-04-11 16:30:00 | QQQ | ETF | 25.51 | 25.55 | 25.47 | 25.54 | 49000.0 |
| 2003-04-11 17:00:00 | QQQ | ETF | 25.54 | 25.54 | 25.5 | 25.51 | 9700.0 |
| 2003-04-11 17:30:00 | QQQ | ETF | 25.51 | 25.54 | 25.49 | 25.5 | 35500.0 |
| 2003-04-11 18:00:00 | QQQ | ETF | 25.49 | 25.54 | 25.48 | 25.52 | 9600.0 |
| 2003-04-11 18:30:00 | QQQ | ETF | 25.54 | 25.54 | 25.5 | 25.51 | 5400.0 |
| 2003-04-11 19:00:00 | QQQ | ETF | 25.51 | 25.54 | 25.51 | 25.54 | 7800.0 |
| 2003-04-11 19:30:00 | QQQ | ETF | 25.53 | 25.54 | 25.51 | 25.54 | 9100.0 |
| 2003-04-11 09:30:00 | IWM | ETF | 37.385 | 37.495 | 37.23 | 37.25 | 234000.0 |
| 2003-04-11 10:00:00 | IWM | ETF | 37.295 | 37.295 | 36.945 | 37.065 | 529600.0 |
> showing 50 of 642 rows — these rows as CSV