PREVIEW / etf_30min / 2001-09-06
file: by_date/etf_30min/2001/2001-09-06.parquet size: 16 KB rows: 412
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-09-06 09:30:00 | SPY | ETF | 112.65 | 113.12 | 112.41 | 112.47 | 1754500.0 |
| 2001-09-06 10:00:00 | SPY | ETF | 112.46 | 113.3 | 111.91 | 112.4 | 3653600.0 |
| 2001-09-06 10:30:00 | SPY | ETF | 112.4 | 112.74 | 112.18 | 112.6 | 956200.0 |
| 2001-09-06 11:00:00 | SPY | ETF | 112.65 | 112.67 | 112.11 | 112.31 | 1124500.0 |
| 2001-09-06 11:30:00 | SPY | ETF | 112.29 | 112.3 | 111.95 | 112.01 | 951600.0 |
| 2001-09-06 12:00:00 | SPY | ETF | 112.0 | 112.04 | 111.5 | 111.51 | 1211600.0 |
| 2001-09-06 12:30:00 | SPY | ETF | 111.5 | 111.7 | 111.12 | 111.6 | 2576500.0 |
| 2001-09-06 13:00:00 | SPY | ETF | 111.63 | 111.86 | 111.41 | 111.82 | 1511000.0 |
| 2001-09-06 13:30:00 | SPY | ETF | 111.88 | 111.96 | 111.59 | 111.64 | 842700.0 |
| 2001-09-06 14:00:00 | SPY | ETF | 111.66 | 111.67 | 111.23 | 111.4 | 1031100.0 |
| 2001-09-06 14:30:00 | SPY | ETF | 111.41 | 111.9 | 111.26 | 111.62 | 986800.0 |
| 2001-09-06 15:00:00 | SPY | ETF | 111.65 | 111.73 | 111.1 | 111.3 | 1005700.0 |
| 2001-09-06 15:30:00 | SPY | ETF | 111.3 | 111.59 | 111.09 | 111.1 | 1368000.0 |
| 2001-09-06 16:00:00 | SPY | ETF | 111.15 | 111.25 | 110.25 | 111.2 | 1279300.0 |
| 2001-09-06 16:30:00 | SPY | ETF | 110.8 | 111.15 | 110.75 | 110.92 | 177400.0 |
| 2001-09-06 17:00:00 | SPY | ETF | 110.92 | 111.25 | 110.9 | 110.9 | 900.0 |
| 2001-09-06 17:30:00 | SPY | ETF | 111.05 | 111.11 | 111.0 | 111.04 | 2900.0 |
| 2001-09-06 18:00:00 | SPY | ETF | 111.06 | 111.1 | 111.06 | 111.1 | 1400.0 |
| 2001-09-06 09:30:00 | QQQ | ETF | 34.74 | 35.11 | 34.59 | 34.74 | 8460600.0 |
| 2001-09-06 10:00:00 | QQQ | ETF | 34.73 | 35.5 | 34.45 | 34.65 | 15361300.0 |
| 2001-09-06 10:30:00 | QQQ | ETF | 34.63 | 34.85 | 34.49 | 34.8 | 4843000.0 |
| 2001-09-06 11:00:00 | QQQ | ETF | 34.79 | 34.84 | 34.34 | 34.48 | 4979400.0 |
| 2001-09-06 11:30:00 | QQQ | ETF | 34.49 | 34.53 | 34.26 | 34.4 | 4562800.0 |
| 2001-09-06 12:00:00 | QQQ | ETF | 34.4 | 34.42 | 34.19 | 34.27 | 4112900.0 |
| 2001-09-06 12:30:00 | QQQ | ETF | 34.27 | 34.55 | 34.08 | 34.49 | 7270500.0 |
| 2001-09-06 13:00:00 | QQQ | ETF | 34.49 | 34.6 | 34.27 | 34.58 | 3731700.0 |
| 2001-09-06 13:30:00 | QQQ | ETF | 34.58 | 34.71 | 34.44 | 34.5 | 3835100.0 |
| 2001-09-06 14:00:00 | QQQ | ETF | 34.46 | 34.52 | 34.15 | 34.29 | 5028100.0 |
| 2001-09-06 14:30:00 | QQQ | ETF | 34.26 | 34.52 | 34.19 | 34.34 | 4745400.0 |
| 2001-09-06 15:00:00 | QQQ | ETF | 34.37 | 34.42 | 33.92 | 34.09 | 5924300.0 |
| 2001-09-06 15:30:00 | QQQ | ETF | 34.05 | 34.24 | 33.9 | 33.96 | 7729500.0 |
| 2001-09-06 16:00:00 | QQQ | ETF | 33.94 | 34.45 | 33.78 | 34.2 | 2764500.0 |
| 2001-09-06 16:30:00 | QQQ | ETF | 34.17 | 34.34 | 34.03 | 34.09 | 380500.0 |
| 2001-09-06 17:00:00 | QQQ | ETF | 34.08 | 34.25 | 34.08 | 34.22 | 78900.0 |
| 2001-09-06 17:30:00 | QQQ | ETF | 34.22 | 34.29 | 34.09 | 34.25 | 81400.0 |
| 2001-09-06 18:00:00 | QQQ | ETF | 34.2 | 34.43 | 34.2 | 34.36 | 103800.0 |
| 2001-09-06 09:30:00 | IWM | ETF | 45.75 | 45.885 | 45.55 | 45.55 | 5000.0 |
| 2001-09-06 10:00:00 | IWM | ETF | 45.62 | 45.9 | 45.5 | 45.505 | 46200.0 |
| 2001-09-06 10:30:00 | IWM | ETF | 45.5 | 45.6 | 45.48 | 45.6 | 21600.0 |
| 2001-09-06 11:00:00 | IWM | ETF | 45.655 | 45.655 | 45.475 | 45.575 | 20200.0 |
| 2001-09-06 11:30:00 | IWM | ETF | 45.49 | 45.49 | 45.425 | 45.425 | 31000.0 |
| 2001-09-06 12:00:00 | IWM | ETF | 45.41 | 45.41 | 45.36 | 45.36 | 8600.0 |
| 2001-09-06 12:30:00 | IWM | ETF | 45.415 | 45.415 | 45.25 | 45.25 | 6400.0 |
| 2001-09-06 13:00:00 | IWM | ETF | 45.21 | 45.39 | 45.16 | 45.3 | 20000.0 |
| 2001-09-06 13:30:00 | IWM | ETF | 45.3 | 45.32 | 45.255 | 45.32 | 83000.0 |
| 2001-09-06 14:00:00 | IWM | ETF | 45.25 | 45.325 | 45.25 | 45.25 | 11200.0 |
| 2001-09-06 14:30:00 | IWM | ETF | 45.19 | 45.345 | 45.19 | 45.2 | 600.0 |
| 2001-09-06 15:00:00 | IWM | ETF | 45.325 | 45.325 | 45.125 | 45.25 | 8600.0 |
| 2001-09-06 15:30:00 | IWM | ETF | 45.11 | 45.345 | 45.105 | 45.27 | 18800.0 |
| 2001-09-06 16:00:00 | IWM | ETF | 45.175 | 45.175 | 45.175 | 45.175 | 600.0 |
> showing 50 of 412 rows — these rows as CSV