PREVIEW / etf_30min / 2001-12-13
file: by_date/etf_30min/2001/2001-12-13.parquet size: 18 KB rows: 475
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-12-13 09:30:00 | SPY | ETF | 113.45 | 113.45 | 112.73 | 113.13 | 4826900.0 |
| 2001-12-13 10:00:00 | SPY | ETF | 113.11 | 113.3 | 112.87 | 113.06 | 974200.0 |
| 2001-12-13 10:30:00 | SPY | ETF | 113.03 | 113.53 | 112.91 | 113.5 | 2094900.0 |
| 2001-12-13 11:00:00 | SPY | ETF | 113.48 | 113.7 | 113.24 | 113.56 | 1249000.0 |
| 2001-12-13 11:30:00 | SPY | ETF | 113.55 | 113.68 | 113.3 | 113.4 | 1095500.0 |
| 2001-12-13 12:00:00 | SPY | ETF | 113.4 | 113.46 | 113.2 | 113.33 | 686200.0 |
| 2001-12-13 12:30:00 | SPY | ETF | 113.33 | 113.39 | 113.2 | 113.24 | 323600.0 |
| 2001-12-13 13:00:00 | SPY | ETF | 113.24 | 113.66 | 113.22 | 113.57 | 470100.0 |
| 2001-12-13 13:30:00 | SPY | ETF | 113.58 | 113.58 | 113.0 | 113.12 | 636700.0 |
| 2001-12-13 14:00:00 | SPY | ETF | 113.14 | 113.29 | 112.95 | 113.02 | 874600.0 |
| 2001-12-13 14:30:00 | SPY | ETF | 113.02 | 113.12 | 112.6 | 112.7 | 1020700.0 |
| 2001-12-13 15:00:00 | SPY | ETF | 112.74 | 112.82 | 112.28 | 112.64 | 1530900.0 |
| 2001-12-13 15:30:00 | SPY | ETF | 112.59 | 112.79 | 112.36 | 112.36 | 1321900.0 |
| 2001-12-13 16:00:00 | SPY | ETF | 112.36 | 112.99 | 111.9 | 112.2 | 1720100.0 |
| 2001-12-13 16:30:00 | SPY | ETF | 112.0 | 112.2 | 112.0 | 112.13 | 38600.0 |
| 2001-12-13 17:00:00 | SPY | ETF | 112.13 | 112.13 | 112.0 | 112.06 | 159800.0 |
| 2001-12-13 17:30:00 | SPY | ETF | 111.93 | 112.1 | 111.93 | 112.1 | 4700.0 |
| 2001-12-13 18:00:00 | SPY | ETF | 112.05 | 112.25 | 112.05 | 112.25 | 6300.0 |
| 2001-12-13 09:30:00 | QQQ | ETF | 40.71 | 41.0 | 40.6 | 40.8 | 12473300.0 |
| 2001-12-13 10:00:00 | QQQ | ETF | 40.78 | 40.95 | 40.37 | 40.46 | 8294900.0 |
| 2001-12-13 10:30:00 | QQQ | ETF | 40.49 | 40.8 | 40.37 | 40.76 | 7229400.0 |
| 2001-12-13 11:00:00 | QQQ | ETF | 40.78 | 40.94 | 40.62 | 40.75 | 4408500.0 |
| 2001-12-13 11:30:00 | QQQ | ETF | 40.75 | 40.89 | 40.66 | 40.75 | 2478900.0 |
| 2001-12-13 12:00:00 | QQQ | ETF | 40.74 | 40.8 | 40.55 | 40.66 | 2156600.0 |
| 2001-12-13 12:30:00 | QQQ | ETF | 40.67 | 40.72 | 40.48 | 40.5 | 2276000.0 |
| 2001-12-13 13:00:00 | QQQ | ETF | 40.51 | 40.76 | 40.49 | 40.75 | 3195200.0 |
| 2001-12-13 13:30:00 | QQQ | ETF | 40.75 | 40.78 | 40.37 | 40.53 | 4176200.0 |
| 2001-12-13 14:00:00 | QQQ | ETF | 40.53 | 40.6 | 40.24 | 40.28 | 4334300.0 |
| 2001-12-13 14:30:00 | QQQ | ETF | 40.28 | 40.35 | 40.01 | 40.1 | 6909500.0 |
| 2001-12-13 15:00:00 | QQQ | ETF | 40.1 | 40.17 | 39.85 | 40.07 | 9196400.0 |
| 2001-12-13 15:30:00 | QQQ | ETF | 40.06 | 40.22 | 39.86 | 39.87 | 8879700.0 |
| 2001-12-13 16:00:00 | QQQ | ETF | 39.9 | 40.1 | 39.74 | 39.78 | 3239900.0 |
| 2001-12-13 16:30:00 | QQQ | ETF | 39.77 | 39.9 | 39.63 | 39.63 | 159600.0 |
| 2001-12-13 17:00:00 | QQQ | ETF | 39.62 | 39.9 | 39.57 | 39.61 | 88000.0 |
| 2001-12-13 17:30:00 | QQQ | ETF | 39.6 | 39.8 | 39.56 | 39.8 | 51300.0 |
| 2001-12-13 18:00:00 | QQQ | ETF | 39.8 | 39.9 | 39.75 | 39.88 | 56200.0 |
| 2001-12-13 09:30:00 | IWM | ETF | 46.975 | 47.02 | 46.705 | 47.02 | 28200.0 |
| 2001-12-13 10:00:00 | IWM | ETF | 47.025 | 47.025 | 46.84 | 46.925 | 68400.0 |
| 2001-12-13 10:30:00 | IWM | ETF | 46.945 | 47.1 | 46.945 | 47.07 | 13400.0 |
| 2001-12-13 11:00:00 | IWM | ETF | 47.125 | 47.22 | 47.0 | 47.14 | 14000.0 |
| 2001-12-13 11:30:00 | IWM | ETF | 47.14 | 47.22 | 47.125 | 47.125 | 5800.0 |
| 2001-12-13 12:00:00 | IWM | ETF | 47.18 | 47.18 | 47.125 | 47.18 | 8600.0 |
| 2001-12-13 12:30:00 | IWM | ETF | 47.125 | 47.205 | 47.125 | 47.125 | 3200.0 |
| 2001-12-13 13:00:00 | IWM | ETF | 47.125 | 47.22 | 47.11 | 47.11 | 5600.0 |
| 2001-12-13 13:30:00 | IWM | ETF | 47.27 | 47.27 | 47.165 | 47.175 | 6000.0 |
| 2001-12-13 14:00:00 | IWM | ETF | 47.1 | 47.145 | 47.075 | 47.1 | 24600.0 |
| 2001-12-13 14:30:00 | IWM | ETF | 46.975 | 47.025 | 46.86 | 47.0 | 385200.0 |
| 2001-12-13 15:00:00 | IWM | ETF | 46.85 | 47.0 | 46.75 | 46.865 | 87000.0 |
| 2001-12-13 15:30:00 | IWM | ETF | 46.8 | 46.8 | 46.625 | 46.625 | 31800.0 |
| 2001-12-13 16:00:00 | IWM | ETF | 46.55 | 46.66 | 46.55 | 46.555 | 114600.0 |
> showing 50 of 475 rows — these rows as CSV