PREVIEW / etf_30min / 2001-10-15
file: by_date/etf_30min/2001/2001-10-15.parquet size: 16 KB rows: 408
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-15 09:30:00 | SPY | ETF | 108.63 | 108.87 | 108.17 | 108.3 | 1792300.0 |
| 2001-10-15 10:00:00 | SPY | ETF | 108.35 | 108.6 | 108.13 | 108.5 | 879700.0 |
| 2001-10-15 10:30:00 | SPY | ETF | 108.46 | 108.76 | 108.25 | 108.34 | 1449800.0 |
| 2001-10-15 11:00:00 | SPY | ETF | 108.27 | 108.67 | 108.06 | 108.66 | 1777100.0 |
| 2001-10-15 11:30:00 | SPY | ETF | 108.66 | 108.86 | 108.5 | 108.5 | 763500.0 |
| 2001-10-15 12:00:00 | SPY | ETF | 108.55 | 108.57 | 108.21 | 108.3 | 960800.0 |
| 2001-10-15 12:30:00 | SPY | ETF | 108.27 | 108.55 | 108.2 | 108.31 | 472900.0 |
| 2001-10-15 13:00:00 | SPY | ETF | 108.3 | 108.79 | 108.23 | 108.61 | 850400.0 |
| 2001-10-15 13:30:00 | SPY | ETF | 108.61 | 109.16 | 108.55 | 109.09 | 1034600.0 |
| 2001-10-15 14:00:00 | SPY | ETF | 109.16 | 109.33 | 108.92 | 109.23 | 1694400.0 |
| 2001-10-15 14:30:00 | SPY | ETF | 109.21 | 109.45 | 108.82 | 108.92 | 996100.0 |
| 2001-10-15 15:00:00 | SPY | ETF | 108.91 | 109.3 | 108.85 | 109.1 | 1125000.0 |
| 2001-10-15 15:30:00 | SPY | ETF | 109.12 | 109.43 | 109.04 | 109.34 | 898500.0 |
| 2001-10-15 16:00:00 | SPY | ETF | 109.3 | 109.45 | 108.26 | 109.4 | 1367900.0 |
| 2001-10-15 16:30:00 | SPY | ETF | 109.25 | 109.25 | 109.06 | 109.16 | 3400.0 |
| 2001-10-15 17:00:00 | SPY | ETF | 109.16 | 109.16 | 109.1 | 109.1 | 200.0 |
| 2001-10-15 17:30:00 | SPY | ETF | 109.1 | 109.34 | 109.0 | 109.0 | 4900.0 |
| 2001-10-15 09:30:00 | QQQ | ETF | 34.12 | 34.3 | 33.66 | 33.81 | 12453800.0 |
| 2001-10-15 10:00:00 | QQQ | ETF | 33.81 | 34.08 | 33.72 | 33.99 | 6780800.0 |
| 2001-10-15 10:30:00 | QQQ | ETF | 33.99 | 34.2 | 33.86 | 33.93 | 6595100.0 |
| 2001-10-15 11:00:00 | QQQ | ETF | 33.91 | 34.17 | 33.81 | 34.14 | 4907000.0 |
| 2001-10-15 11:30:00 | QQQ | ETF | 34.14 | 34.35 | 34.02 | 34.06 | 4495200.0 |
| 2001-10-15 12:00:00 | QQQ | ETF | 34.06 | 34.15 | 33.88 | 33.94 | 3054300.0 |
| 2001-10-15 12:30:00 | QQQ | ETF | 33.93 | 33.98 | 33.77 | 33.88 | 2175300.0 |
| 2001-10-15 13:00:00 | QQQ | ETF | 33.85 | 34.11 | 33.83 | 34.03 | 3222400.0 |
| 2001-10-15 13:30:00 | QQQ | ETF | 34.04 | 34.37 | 33.93 | 34.35 | 6789600.0 |
| 2001-10-15 14:00:00 | QQQ | ETF | 34.33 | 34.55 | 34.23 | 34.38 | 7316900.0 |
| 2001-10-15 14:30:00 | QQQ | ETF | 34.42 | 34.54 | 34.11 | 34.19 | 5913700.0 |
| 2001-10-15 15:00:00 | QQQ | ETF | 34.17 | 34.4 | 34.15 | 34.25 | 4504100.0 |
| 2001-10-15 15:30:00 | QQQ | ETF | 34.22 | 34.52 | 34.2 | 34.32 | 5601500.0 |
| 2001-10-15 16:00:00 | QQQ | ETF | 34.34 | 34.5 | 33.95 | 34.4 | 935300.0 |
| 2001-10-15 16:30:00 | QQQ | ETF | 34.42 | 34.44 | 34.23 | 34.25 | 56200.0 |
| 2001-10-15 17:00:00 | QQQ | ETF | 34.26 | 34.4 | 34.25 | 34.26 | 311100.0 |
| 2001-10-15 17:30:00 | QQQ | ETF | 34.28 | 34.28 | 34.2 | 34.22 | 42200.0 |
| 2001-10-15 18:00:00 | QQQ | ETF | 34.21 | 34.4 | 34.21 | 34.33 | 27700.0 |
| 2001-10-15 09:30:00 | IWM | ETF | 42.375 | 42.375 | 42.15 | 42.19 | 139200.0 |
| 2001-10-15 10:00:00 | IWM | ETF | 42.205 | 42.325 | 42.2 | 42.32 | 29400.0 |
| 2001-10-15 10:30:00 | IWM | ETF | 42.39 | 42.455 | 42.39 | 42.455 | 3600.0 |
| 2001-10-15 11:00:00 | IWM | ETF | 42.405 | 42.465 | 42.405 | 42.415 | 1800.0 |
| 2001-10-15 11:30:00 | IWM | ETF | 42.415 | 42.6 | 42.415 | 42.51 | 6200.0 |
| 2001-10-15 12:00:00 | IWM | ETF | 42.435 | 42.455 | 42.37 | 42.39 | 63800.0 |
| 2001-10-15 12:30:00 | IWM | ETF | 42.395 | 42.395 | 42.35 | 42.39 | 800.0 |
| 2001-10-15 13:00:00 | IWM | ETF | 42.39 | 42.485 | 42.37 | 42.415 | 5200.0 |
| 2001-10-15 13:30:00 | IWM | ETF | 42.505 | 42.65 | 42.505 | 42.65 | 4200.0 |
| 2001-10-15 14:00:00 | IWM | ETF | 42.635 | 42.635 | 42.525 | 42.59 | 5200.0 |
| 2001-10-15 14:30:00 | IWM | ETF | 42.61 | 42.73 | 42.545 | 42.545 | 90600.0 |
| 2001-10-15 15:00:00 | IWM | ETF | 42.585 | 42.75 | 42.585 | 42.675 | 26800.0 |
| 2001-10-15 15:30:00 | IWM | ETF | 42.685 | 42.785 | 42.685 | 42.7 | 75200.0 |
| 2001-10-15 16:00:00 | IWM | ETF | 42.76 | 42.76 | 42.7 | 42.7 | 119000.0 |
| 2001-10-15 09:30:00 | DIA | ETF | 93.0 | 93.05 | 92.56 | 92.7 | 407700.0 |
> showing 50 of 408 rows — these rows as CSV