PREVIEW / etf_30min / 2001-04-04
file: by_date/etf_30min/2001/2001-04-04.parquet size: 15 KB rows: 355
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-04-04 09:30:00 | SPY | ETF | 110.57 | 111.16 | 110.16 | 110.45 | 1823100.0 |
| 2001-04-04 10:00:00 | SPY | ETF | 110.56 | 110.56 | 109.3 | 109.68 | 1993900.0 |
| 2001-04-04 10:30:00 | SPY | ETF | 109.78 | 111.14 | 109.6 | 110.8 | 1540500.0 |
| 2001-04-04 11:00:00 | SPY | ETF | 110.72 | 112.05 | 110.69 | 111.28 | 1233300.0 |
| 2001-04-04 11:30:00 | SPY | ETF | 111.28 | 111.89 | 111.1 | 111.89 | 904800.0 |
| 2001-04-04 12:00:00 | SPY | ETF | 111.88 | 112.1 | 111.5 | 111.76 | 828800.0 |
| 2001-04-04 12:30:00 | SPY | ETF | 111.74 | 111.85 | 111.3 | 111.31 | 603900.0 |
| 2001-04-04 13:00:00 | SPY | ETF | 111.45 | 111.45 | 110.91 | 111.01 | 758800.0 |
| 2001-04-04 13:30:00 | SPY | ETF | 111.04 | 111.2 | 110.0 | 110.0 | 779800.0 |
| 2001-04-04 14:00:00 | SPY | ETF | 110.0 | 111.0 | 109.85 | 110.9 | 785500.0 |
| 2001-04-04 14:30:00 | SPY | ETF | 110.74 | 111.68 | 110.11 | 110.35 | 608400.0 |
| 2001-04-04 15:00:00 | SPY | ETF | 110.35 | 110.5 | 109.61 | 109.76 | 1117600.0 |
| 2001-04-04 15:30:00 | SPY | ETF | 109.75 | 110.99 | 109.58 | 110.31 | 1303800.0 |
| 2001-04-04 16:00:00 | SPY | ETF | 110.4 | 111.75 | 110.25 | 111.75 | 476200.0 |
| 2001-04-04 16:30:00 | SPY | ETF | 110.95 | 110.95 | 110.9 | 110.9 | 1700.0 |
| 2001-04-04 17:00:00 | SPY | ETF | 110.77 | 111.22 | 110.77 | 111.22 | 12500.0 |
| 2001-04-04 17:30:00 | SPY | ETF | 111.24 | 111.28 | 111.2 | 111.25 | 8500.0 |
| 2001-04-04 18:00:00 | SPY | ETF | 111.5 | 111.75 | 111.5 | 111.62 | 3000.0 |
| 2001-04-04 09:30:00 | QQQ | ETF | 34.71 | 35.38 | 34.5 | 34.55 | 9381100.0 |
| 2001-04-04 10:00:00 | QQQ | ETF | 34.56 | 34.75 | 34.08 | 34.3 | 7984100.0 |
| 2001-04-04 10:30:00 | QQQ | ETF | 34.3 | 35.13 | 34.21 | 34.89 | 6761900.0 |
| 2001-04-04 11:00:00 | QQQ | ETF | 34.89 | 35.81 | 34.76 | 35.35 | 7979200.0 |
| 2001-04-04 11:30:00 | QQQ | ETF | 35.35 | 35.6 | 35.05 | 35.55 | 4004600.0 |
| 2001-04-04 12:00:00 | QQQ | ETF | 35.61 | 35.8 | 35.42 | 35.61 | 3769000.0 |
| 2001-04-04 12:30:00 | QQQ | ETF | 35.69 | 35.69 | 35.21 | 35.3 | 3334700.0 |
| 2001-04-04 13:00:00 | QQQ | ETF | 35.25 | 35.32 | 34.87 | 34.9 | 3200500.0 |
| 2001-04-04 13:30:00 | QQQ | ETF | 34.91 | 34.95 | 34.28 | 34.3 | 5290500.0 |
| 2001-04-04 14:00:00 | QQQ | ETF | 34.31 | 34.8 | 34.19 | 34.5 | 6072200.0 |
| 2001-04-04 14:30:00 | QQQ | ETF | 34.5 | 34.72 | 34.15 | 34.25 | 3706100.0 |
| 2001-04-04 15:00:00 | QQQ | ETF | 34.3 | 34.3 | 33.65 | 33.65 | 6035900.0 |
| 2001-04-04 15:30:00 | QQQ | ETF | 33.7 | 34.33 | 33.6 | 34.1 | 5748500.0 |
| 2001-04-04 16:00:00 | QQQ | ETF | 34.1 | 35.5 | 34.0 | 34.06 | 1329100.0 |
| 2001-04-04 16:30:00 | QQQ | ETF | 34.13 | 34.7 | 34.0 | 34.07 | 210000.0 |
| 2001-04-04 17:00:00 | QQQ | ETF | 34.12 | 34.67 | 34.12 | 34.64 | 358700.0 |
| 2001-04-04 17:30:00 | QQQ | ETF | 34.64 | 35.6 | 34.55 | 34.9 | 142600.0 |
| 2001-04-04 18:00:00 | QQQ | ETF | 34.9 | 35.04 | 34.85 | 35.0 | 62300.0 |
| 2001-04-04 09:30:00 | IWM | ETF | 42.325 | 42.9 | 42.25 | 42.825 | 21400.0 |
| 2001-04-04 10:00:00 | IWM | ETF | 42.425 | 42.485 | 42.25 | 42.25 | 32400.0 |
| 2001-04-04 10:30:00 | IWM | ETF | 42.4 | 42.675 | 42.25 | 42.55 | 31800.0 |
| 2001-04-04 11:00:00 | IWM | ETF | 42.525 | 42.8 | 42.5 | 42.8 | 50000.0 |
| 2001-04-04 11:30:00 | IWM | ETF | 42.75 | 42.8 | 42.65 | 42.65 | 1800.0 |
| 2001-04-04 12:00:00 | IWM | ETF | 42.9 | 42.925 | 42.755 | 42.76 | 2800.0 |
| 2001-04-04 12:30:00 | IWM | ETF | 42.79 | 42.9 | 42.79 | 42.885 | 5400.0 |
| 2001-04-04 13:00:00 | IWM | ETF | 42.7 | 42.91 | 42.7 | 42.91 | 6800.0 |
| 2001-04-04 13:30:00 | IWM | ETF | 42.74 | 42.875 | 42.65 | 42.65 | 23800.0 |
| 2001-04-04 14:00:00 | IWM | ETF | 42.635 | 42.775 | 42.475 | 42.775 | 79200.0 |
| 2001-04-04 14:30:00 | IWM | ETF | 42.65 | 42.65 | 42.45 | 42.575 | 66000.0 |
| 2001-04-04 15:00:00 | IWM | ETF | 42.35 | 42.48 | 42.3 | 42.3 | 11400.0 |
| 2001-04-04 15:30:00 | IWM | ETF | 42.2 | 42.55 | 42.2 | 42.325 | 22000.0 |
| 2001-04-04 16:00:00 | IWM | ETF | 42.4 | 42.4 | 42.4 | 42.4 | 1600.0 |
> showing 50 of 355 rows — these rows as CSV