PREVIEW / etf_30min / 2001-10-10
file: by_date/etf_30min/2001/2001-10-10.parquet size: 16 KB rows: 407
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-10 09:30:00 | SPY | ETF | 105.8 | 106.67 | 105.52 | 106.47 | 2253100.0 |
| 2001-10-10 10:00:00 | SPY | ETF | 106.53 | 107.25 | 106.46 | 107.11 | 2781100.0 |
| 2001-10-10 10:30:00 | SPY | ETF | 107.15 | 107.58 | 107.07 | 107.42 | 3129600.0 |
| 2001-10-10 11:00:00 | SPY | ETF | 107.48 | 107.48 | 107.11 | 107.29 | 914400.0 |
| 2001-10-10 11:30:00 | SPY | ETF | 107.3 | 107.69 | 107.07 | 107.56 | 715400.0 |
| 2001-10-10 12:00:00 | SPY | ETF | 107.53 | 107.87 | 107.52 | 107.77 | 571800.0 |
| 2001-10-10 12:30:00 | SPY | ETF | 107.71 | 108.05 | 107.6 | 107.86 | 1282200.0 |
| 2001-10-10 13:00:00 | SPY | ETF | 107.9 | 108.13 | 107.75 | 107.91 | 1150900.0 |
| 2001-10-10 13:30:00 | SPY | ETF | 107.92 | 108.2 | 107.72 | 107.88 | 856200.0 |
| 2001-10-10 14:00:00 | SPY | ETF | 107.85 | 108.08 | 107.65 | 107.8 | 899800.0 |
| 2001-10-10 14:30:00 | SPY | ETF | 107.81 | 108.1 | 107.67 | 108.09 | 650200.0 |
| 2001-10-10 15:00:00 | SPY | ETF | 108.1 | 108.55 | 107.94 | 108.41 | 1351600.0 |
| 2001-10-10 15:30:00 | SPY | ETF | 108.42 | 108.55 | 108.25 | 108.4 | 1595200.0 |
| 2001-10-10 16:00:00 | SPY | ETF | 108.4 | 108.5 | 108.3 | 108.5 | 1414000.0 |
| 2001-10-10 16:30:00 | SPY | ETF | 108.6 | 108.6 | 108.32 | 108.32 | 15500.0 |
| 2001-10-10 17:00:00 | SPY | ETF | 108.5 | 108.5 | 108.0 | 108.0 | 3000.0 |
| 2001-10-10 17:30:00 | SPY | ETF | 108.4 | 108.4 | 108.35 | 108.35 | 600.0 |
| 2001-10-10 18:00:00 | SPY | ETF | 108.35 | 108.35 | 108.35 | 108.35 | 5000.0 |
| 2001-10-10 09:30:00 | QQQ | ETF | 30.87 | 31.52 | 30.75 | 31.48 | 10562900.0 |
| 2001-10-10 10:00:00 | QQQ | ETF | 31.44 | 31.93 | 31.32 | 31.8 | 11241900.0 |
| 2001-10-10 10:30:00 | QQQ | ETF | 31.85 | 31.93 | 31.61 | 31.78 | 5788800.0 |
| 2001-10-10 11:00:00 | QQQ | ETF | 31.8 | 31.81 | 31.52 | 31.69 | 4914500.0 |
| 2001-10-10 11:30:00 | QQQ | ETF | 31.66 | 31.86 | 31.53 | 31.77 | 3034500.0 |
| 2001-10-10 12:00:00 | QQQ | ETF | 31.77 | 31.85 | 31.67 | 31.79 | 2322900.0 |
| 2001-10-10 12:30:00 | QQQ | ETF | 31.78 | 32.0 | 31.74 | 31.93 | 3081100.0 |
| 2001-10-10 13:00:00 | QQQ | ETF | 31.9 | 32.2 | 31.9 | 32.09 | 4589900.0 |
| 2001-10-10 13:30:00 | QQQ | ETF | 32.08 | 32.23 | 31.96 | 32.01 | 2982100.0 |
| 2001-10-10 14:00:00 | QQQ | ETF | 32.01 | 32.11 | 31.8 | 31.9 | 3357700.0 |
| 2001-10-10 14:30:00 | QQQ | ETF | 31.89 | 32.19 | 31.86 | 32.18 | 2921100.0 |
| 2001-10-10 15:00:00 | QQQ | ETF | 32.18 | 32.47 | 32.09 | 32.41 | 6479000.0 |
| 2001-10-10 15:30:00 | QQQ | ETF | 32.42 | 32.5 | 32.31 | 32.49 | 7466400.0 |
| 2001-10-10 16:00:00 | QQQ | ETF | 32.48 | 32.58 | 31.55 | 32.58 | 2583700.0 |
| 2001-10-10 16:30:00 | QQQ | ETF | 32.55 | 32.7 | 32.55 | 32.61 | 150000.0 |
| 2001-10-10 17:00:00 | QQQ | ETF | 32.72 | 32.75 | 32.55 | 32.65 | 65200.0 |
| 2001-10-10 17:30:00 | QQQ | ETF | 32.65 | 32.67 | 32.6 | 32.62 | 30100.0 |
| 2001-10-10 18:00:00 | QQQ | ETF | 32.6 | 32.68 | 32.52 | 32.62 | 27100.0 |
| 2001-10-10 09:30:00 | IWM | ETF | 40.55 | 41.15 | 40.55 | 41.135 | 10600.0 |
| 2001-10-10 10:00:00 | IWM | ETF | 41.075 | 41.465 | 41.075 | 41.44 | 18000.0 |
| 2001-10-10 10:30:00 | IWM | ETF | 41.465 | 41.59 | 41.465 | 41.59 | 49400.0 |
| 2001-10-10 11:00:00 | IWM | ETF | 41.585 | 41.585 | 41.5 | 41.53 | 29400.0 |
| 2001-10-10 11:30:00 | IWM | ETF | 41.47 | 41.47 | 41.27 | 41.35 | 43000.0 |
| 2001-10-10 12:00:00 | IWM | ETF | 41.425 | 41.425 | 41.35 | 41.385 | 4400.0 |
| 2001-10-10 12:30:00 | IWM | ETF | 41.365 | 41.39 | 41.305 | 41.33 | 4600.0 |
| 2001-10-10 13:00:00 | IWM | ETF | 41.33 | 41.375 | 41.33 | 41.35 | 13400.0 |
| 2001-10-10 13:30:00 | IWM | ETF | 41.425 | 41.455 | 41.345 | 41.395 | 5000.0 |
| 2001-10-10 14:00:00 | IWM | ETF | 41.42 | 41.425 | 41.315 | 41.4 | 19400.0 |
| 2001-10-10 14:30:00 | IWM | ETF | 41.37 | 41.44 | 41.315 | 41.365 | 18400.0 |
| 2001-10-10 15:00:00 | IWM | ETF | 41.46 | 41.7 | 41.46 | 41.695 | 110400.0 |
| 2001-10-10 15:30:00 | IWM | ETF | 41.635 | 41.915 | 41.635 | 41.915 | 55000.0 |
| 2001-10-10 16:00:00 | IWM | ETF | 41.94 | 42.0 | 41.875 | 42.0 | 253400.0 |
> showing 50 of 407 rows — these rows as CSV