PREVIEW / etf_30min / 2001-10-18
file: by_date/etf_30min/2001/2001-10-18.parquet size: 16 KB rows: 405
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-18 09:30:00 | SPY | ETF | 107.82 | 108.16 | 107.39 | 107.57 | 2946200.0 |
| 2001-10-18 10:00:00 | SPY | ETF | 107.55 | 108.1 | 107.4 | 107.6 | 1657800.0 |
| 2001-10-18 10:30:00 | SPY | ETF | 107.55 | 108.06 | 107.37 | 107.6 | 968800.0 |
| 2001-10-18 11:00:00 | SPY | ETF | 107.52 | 108.12 | 107.52 | 107.77 | 850900.0 |
| 2001-10-18 11:30:00 | SPY | ETF | 107.72 | 108.0 | 107.52 | 107.53 | 1291800.0 |
| 2001-10-18 12:00:00 | SPY | ETF | 107.52 | 107.61 | 107.28 | 107.46 | 1169600.0 |
| 2001-10-18 12:30:00 | SPY | ETF | 107.4 | 107.7 | 107.14 | 107.22 | 1055100.0 |
| 2001-10-18 13:00:00 | SPY | ETF | 107.25 | 107.38 | 106.87 | 107.1 | 1545500.0 |
| 2001-10-18 13:30:00 | SPY | ETF | 107.08 | 107.23 | 106.75 | 106.9 | 589000.0 |
| 2001-10-18 14:00:00 | SPY | ETF | 106.87 | 107.3 | 106.87 | 107.15 | 723600.0 |
| 2001-10-18 14:30:00 | SPY | ETF | 107.15 | 107.55 | 107.05 | 107.08 | 711600.0 |
| 2001-10-18 15:00:00 | SPY | ETF | 107.1 | 107.36 | 106.82 | 106.95 | 609200.0 |
| 2001-10-18 15:30:00 | SPY | ETF | 106.99 | 107.28 | 106.75 | 107.21 | 1456300.0 |
| 2001-10-18 16:00:00 | SPY | ETF | 107.23 | 107.5 | 107.0 | 107.42 | 360500.0 |
| 2001-10-18 16:30:00 | SPY | ETF | 107.45 | 108.0 | 107.42 | 107.67 | 73900.0 |
| 2001-10-18 17:00:00 | SPY | ETF | 107.67 | 107.8 | 107.48 | 107.49 | 12200.0 |
| 2001-10-18 17:30:00 | SPY | ETF | 107.48 | 107.83 | 107.3 | 107.4 | 6900.0 |
| 2001-10-18 18:00:00 | SPY | ETF | 107.4 | 107.4 | 107.22 | 107.22 | 4200.0 |
| 2001-10-18 09:30:00 | QQQ | ETF | 32.7 | 33.15 | 32.4 | 32.69 | 18075800.0 |
| 2001-10-18 10:00:00 | QQQ | ETF | 32.71 | 33.25 | 32.58 | 32.95 | 11676200.0 |
| 2001-10-18 10:30:00 | QQQ | ETF | 32.95 | 33.25 | 32.9 | 33.01 | 5575300.0 |
| 2001-10-18 11:00:00 | QQQ | ETF | 33.02 | 33.54 | 33.01 | 33.28 | 7041800.0 |
| 2001-10-18 11:30:00 | QQQ | ETF | 33.27 | 33.45 | 33.05 | 33.1 | 5385500.0 |
| 2001-10-18 12:00:00 | QQQ | ETF | 33.05 | 33.18 | 32.89 | 33.02 | 4549500.0 |
| 2001-10-18 12:30:00 | QQQ | ETF | 33.01 | 33.19 | 32.89 | 32.9 | 2831900.0 |
| 2001-10-18 13:00:00 | QQQ | ETF | 32.91 | 32.94 | 32.61 | 32.77 | 4303700.0 |
| 2001-10-18 13:30:00 | QQQ | ETF | 32.78 | 32.95 | 32.65 | 32.8 | 4353800.0 |
| 2001-10-18 14:00:00 | QQQ | ETF | 32.77 | 33.15 | 32.77 | 33.05 | 4818400.0 |
| 2001-10-18 14:30:00 | QQQ | ETF | 33.05 | 33.25 | 32.95 | 32.96 | 3802900.0 |
| 2001-10-18 15:00:00 | QQQ | ETF | 32.96 | 33.19 | 32.83 | 32.9 | 4375700.0 |
| 2001-10-18 15:30:00 | QQQ | ETF | 32.9 | 33.19 | 32.76 | 33.17 | 5835000.0 |
| 2001-10-18 16:00:00 | QQQ | ETF | 33.16 | 33.5 | 32.85 | 33.17 | 2024100.0 |
| 2001-10-18 16:30:00 | QQQ | ETF | 33.16 | 33.7 | 32.95 | 33.5 | 1765300.0 |
| 2001-10-18 17:00:00 | QQQ | ETF | 33.51 | 33.56 | 33.25 | 33.33 | 653600.0 |
| 2001-10-18 17:30:00 | QQQ | ETF | 33.3 | 33.4 | 33.1 | 33.1 | 170100.0 |
| 2001-10-18 18:00:00 | QQQ | ETF | 33.2 | 33.25 | 32.95 | 32.99 | 98900.0 |
| 2001-10-18 09:30:00 | IWM | ETF | 42.275 | 42.275 | 42.025 | 42.11 | 28400.0 |
| 2001-10-18 10:00:00 | IWM | ETF | 42.05 | 42.225 | 42.0 | 42.115 | 79400.0 |
| 2001-10-18 10:30:00 | IWM | ETF | 42.0 | 42.135 | 42.0 | 42.09 | 104600.0 |
| 2001-10-18 11:00:00 | IWM | ETF | 42.08 | 42.175 | 42.025 | 42.175 | 90400.0 |
| 2001-10-18 11:30:00 | IWM | ETF | 42.16 | 42.275 | 42.135 | 42.275 | 46200.0 |
| 2001-10-18 12:00:00 | IWM | ETF | 42.13 | 42.13 | 42.13 | 42.13 | 4400.0 |
| 2001-10-18 12:30:00 | IWM | ETF | 42.155 | 42.18 | 42.125 | 42.125 | 112000.0 |
| 2001-10-18 13:00:00 | IWM | ETF | 42.125 | 42.135 | 42.0 | 42.03 | 90400.0 |
| 2001-10-18 13:30:00 | IWM | ETF | 42.0 | 42.05 | 41.935 | 41.935 | 137400.0 |
| 2001-10-18 14:00:00 | IWM | ETF | 42.02 | 42.02 | 41.96 | 42.005 | 27000.0 |
| 2001-10-18 14:30:00 | IWM | ETF | 42.015 | 42.1 | 41.99 | 41.99 | 31600.0 |
| 2001-10-18 15:00:00 | IWM | ETF | 42.055 | 42.055 | 41.85 | 41.85 | 36000.0 |
| 2001-10-18 15:30:00 | IWM | ETF | 41.97 | 41.97 | 41.65 | 41.925 | 175200.0 |
| 2001-10-18 16:00:00 | IWM | ETF | 41.925 | 41.925 | 41.78 | 41.78 | 2400.0 |
> showing 50 of 405 rows — these rows as CSV