PREVIEW / etf_30min / 2001-04-03
file: by_date/etf_30min/2001/2001-04-03.parquet size: 15 KB rows: 369
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-03 09:30:00 | SPY | ETF | 113.98 | 114.15 | 113.22 | 113.25 | 1915200.0 |
| 2001-04-03 10:00:00 | SPY | ETF | 113.22 | 113.49 | 112.55 | 113.17 | 1478400.0 |
| 2001-04-03 10:30:00 | SPY | ETF | 113.15 | 113.3 | 112.55 | 112.75 | 774100.0 |
| 2001-04-03 11:00:00 | SPY | ETF | 112.72 | 112.76 | 111.67 | 111.85 | 832000.0 |
| 2001-04-03 11:30:00 | SPY | ETF | 111.8 | 112.2 | 111.55 | 111.85 | 883000.0 |
| 2001-04-03 12:00:00 | SPY | ETF | 111.81 | 112.43 | 111.51 | 112.29 | 647600.0 |
| 2001-04-03 12:30:00 | SPY | ETF | 112.27 | 112.58 | 111.87 | 112.23 | 428500.0 |
| 2001-04-03 13:00:00 | SPY | ETF | 112.24 | 112.24 | 111.56 | 111.7 | 310200.0 |
| 2001-04-03 13:30:00 | SPY | ETF | 111.87 | 112.2 | 111.48 | 111.74 | 396500.0 |
| 2001-04-03 14:00:00 | SPY | ETF | 111.75 | 111.89 | 111.09 | 111.2 | 773900.0 |
| 2001-04-03 14:30:00 | SPY | ETF | 111.12 | 111.45 | 110.48 | 111.03 | 1162000.0 |
| 2001-04-03 15:00:00 | SPY | ETF | 111.19 | 111.19 | 110.25 | 110.25 | 903000.0 |
| 2001-04-03 15:30:00 | SPY | ETF | 110.26 | 110.93 | 110.1 | 110.67 | 1705200.0 |
| 2001-04-03 16:00:00 | SPY | ETF | 110.66 | 110.85 | 110.06 | 110.39 | 474600.0 |
| 2001-04-03 16:30:00 | SPY | ETF | 110.89 | 110.89 | 110.02 | 110.2 | 48100.0 |
| 2001-04-03 17:00:00 | SPY | ETF | 110.32 | 110.32 | 110.13 | 110.15 | 101700.0 |
| 2001-04-03 17:30:00 | SPY | ETF | 110.1 | 110.1 | 110.05 | 110.1 | 700.0 |
| 2001-04-03 18:00:00 | SPY | ETF | 110.05 | 110.05 | 110.05 | 110.05 | 2000.0 |
| 2001-04-03 09:30:00 | QQQ | ETF | 37.2 | 37.3 | 36.19 | 36.3 | 9382500.0 |
| 2001-04-03 10:00:00 | QQQ | ETF | 36.44 | 36.78 | 36.19 | 36.65 | 7133700.0 |
| 2001-04-03 10:30:00 | QQQ | ETF | 36.61 | 36.75 | 36.01 | 36.09 | 6319000.0 |
| 2001-04-03 11:00:00 | QQQ | ETF | 36.06 | 36.1 | 35.3 | 35.45 | 10184700.0 |
| 2001-04-03 11:30:00 | QQQ | ETF | 35.47 | 35.83 | 35.2 | 35.58 | 9722500.0 |
| 2001-04-03 12:00:00 | QQQ | ETF | 35.52 | 36.1 | 35.37 | 35.93 | 5638100.0 |
| 2001-04-03 12:30:00 | QQQ | ETF | 35.95 | 36.15 | 35.68 | 35.89 | 3313700.0 |
| 2001-04-03 13:00:00 | QQQ | ETF | 35.86 | 35.96 | 35.39 | 35.55 | 3162900.0 |
| 2001-04-03 13:30:00 | QQQ | ETF | 35.57 | 35.7 | 35.33 | 35.46 | 3578600.0 |
| 2001-04-03 14:00:00 | QQQ | ETF | 35.43 | 35.58 | 35.1 | 35.24 | 5327900.0 |
| 2001-04-03 14:30:00 | QQQ | ETF | 35.26 | 35.49 | 35.01 | 35.27 | 5094600.0 |
| 2001-04-03 15:00:00 | QQQ | ETF | 35.26 | 35.37 | 34.78 | 34.8 | 5943700.0 |
| 2001-04-03 15:30:00 | QQQ | ETF | 34.8 | 35.15 | 34.62 | 34.86 | 8914600.0 |
| 2001-04-03 16:00:00 | QQQ | ETF | 34.89 | 37.0 | 34.54 | 34.65 | 2930900.0 |
| 2001-04-03 16:30:00 | QQQ | ETF | 34.65 | 35.0 | 34.55 | 34.66 | 138800.0 |
| 2001-04-03 17:00:00 | QQQ | ETF | 34.66 | 34.85 | 34.6 | 34.72 | 125900.0 |
| 2001-04-03 17:30:00 | QQQ | ETF | 34.69 | 34.7 | 34.57 | 34.62 | 38800.0 |
| 2001-04-03 18:00:00 | QQQ | ETF | 34.58 | 34.6 | 34.4 | 34.44 | 46700.0 |
| 2001-04-03 09:30:00 | IWM | ETF | 43.65 | 43.65 | 43.225 | 43.25 | 71800.0 |
| 2001-04-03 10:00:00 | IWM | ETF | 43.05 | 43.05 | 42.85 | 42.85 | 57600.0 |
| 2001-04-03 10:30:00 | IWM | ETF | 42.89 | 42.89 | 42.75 | 42.75 | 1600.0 |
| 2001-04-03 11:00:00 | IWM | ETF | 42.75 | 42.75 | 42.4 | 42.42 | 99000.0 |
| 2001-04-03 11:30:00 | IWM | ETF | 42.4 | 42.65 | 42.4 | 42.6 | 54000.0 |
| 2001-04-03 12:00:00 | IWM | ETF | 42.5 | 42.675 | 42.475 | 42.51 | 137600.0 |
| 2001-04-03 12:30:00 | IWM | ETF | 42.4 | 42.5 | 42.4 | 42.5 | 20000.0 |
| 2001-04-03 13:00:00 | IWM | ETF | 42.575 | 42.575 | 42.325 | 42.325 | 6200.0 |
| 2001-04-03 13:30:00 | IWM | ETF | 42.375 | 42.575 | 42.375 | 42.405 | 4600.0 |
| 2001-04-03 14:00:00 | IWM | ETF | 42.55 | 42.55 | 42.55 | 42.55 | 200.0 |
| 2001-04-03 14:30:00 | IWM | ETF | 42.325 | 42.45 | 42.25 | 42.445 | 24400.0 |
| 2001-04-03 15:00:00 | IWM | ETF | 42.45 | 42.475 | 42.275 | 42.3 | 13200.0 |
| 2001-04-03 15:30:00 | IWM | ETF | 42.325 | 42.395 | 42.125 | 42.395 | 15200.0 |
| 2001-04-03 16:00:00 | IWM | ETF | 42.265 | 42.265 | 42.265 | 42.265 | 2000.0 |
> showing 50 of 369 rows — these rows as CSV