PREVIEW / etf_30min / 2006-02-03
file: by_date/etf_30min/2006/2006-02-03.parquet size: 60 KB rows: 2,132
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-03 06:30:00 | SPY | ETF | 127.17 | 127.17 | 127.16 | 127.16 | 7200.0 |
| 2006-02-03 07:00:00 | SPY | ETF | 127.18 | 127.21 | 127.07 | 127.07 | 18600.0 |
| 2006-02-03 07:30:00 | SPY | ETF | 127.1 | 127.18 | 127.1 | 127.18 | 78600.0 |
| 2006-02-03 08:00:00 | SPY | ETF | 127.2 | 127.29 | 127.0 | 127.26 | 2239900.0 |
| 2006-02-03 08:30:00 | SPY | ETF | 127.22 | 127.39 | 126.63 | 126.66 | 4871800.0 |
| 2006-02-03 09:00:00 | SPY | ETF | 126.69 | 126.77 | 126.49 | 126.62 | 2158100.0 |
| 2006-02-03 09:30:00 | SPY | ETF | 126.58 | 126.66 | 126.2 | 126.25 | 11341800.0 |
| 2006-02-03 10:00:00 | SPY | ETF | 126.25 | 126.49 | 126.14 | 126.37 | 8661600.0 |
| 2006-02-03 10:30:00 | SPY | ETF | 126.37 | 126.67 | 126.16 | 126.63 | 9043500.0 |
| 2006-02-03 11:00:00 | SPY | ETF | 126.62 | 126.7 | 126.38 | 126.54 | 3277900.0 |
| 2006-02-03 11:30:00 | SPY | ETF | 126.57 | 126.89 | 126.47 | 126.73 | 4258700.0 |
| 2006-02-03 12:00:00 | SPY | ETF | 126.71 | 126.8 | 126.58 | 126.6699 | 1420800.0 |
| 2006-02-03 12:30:00 | SPY | ETF | 126.67 | 126.77 | 126.59 | 126.74 | 776200.0 |
| 2006-02-03 13:00:00 | SPY | ETF | 126.74 | 127.13 | 126.66 | 127.01 | 6356200.0 |
| 2006-02-03 13:30:00 | SPY | ETF | 127.01 | 127.15 | 126.81 | 126.85 | 5877800.0 |
| 2006-02-03 14:00:00 | SPY | ETF | 126.85 | 127.0 | 126.51 | 126.57 | 4482800.0 |
| 2006-02-03 14:30:00 | SPY | ETF | 126.57 | 126.74 | 126.49 | 126.6 | 5062400.0 |
| 2006-02-03 15:00:00 | SPY | ETF | 126.59 | 126.83 | 126.51 | 126.54 | 3529900.0 |
| 2006-02-03 15:30:00 | SPY | ETF | 126.53 | 126.61 | 126.24 | 126.41 | 7634200.0 |
| 2006-02-03 16:00:00 | SPY | ETF | 126.39 | 127.138 | 126.25 | 126.27 | 2178200.0 |
| 2006-02-03 16:30:00 | SPY | ETF | 126.3 | 126.3 | 126.18 | 126.26 | 405900.0 |
| 2006-02-03 17:00:00 | SPY | ETF | 126.27 | 126.27 | 126.2 | 126.2 | 2500.0 |
| 2006-02-03 17:30:00 | SPY | ETF | 126.22 | 126.27 | 126.2 | 126.27 | 5900.0 |
| 2006-02-03 18:00:00 | SPY | ETF | 126.27 | 126.28 | 126.27 | 126.27 | 1400.0 |
| 2006-02-03 18:30:00 | SPY | ETF | 126.25 | 126.25 | 126.25 | 126.25 | 200.0 |
| 2006-02-03 19:30:00 | SPY | ETF | 126.25 | 126.3 | 126.25 | 126.3 | 1500.0 |
| 2006-02-03 09:30:00 | QQQ | ETF | 41.11 | 41.13 | 40.96 | 41.02 | 21599100.0 |
| 2006-02-03 10:00:00 | QQQ | ETF | 41.02 | 41.12 | 41.0 | 41.05 | 13001700.0 |
| 2006-02-03 10:30:00 | QQQ | ETF | 41.04 | 41.08 | 40.88 | 41.04 | 11409000.0 |
| 2006-02-03 11:00:00 | QQQ | ETF | 41.04 | 41.06 | 40.94 | 40.99 | 5344300.0 |
| 2006-02-03 11:30:00 | QQQ | ETF | 40.99 | 41.14 | 40.96 | 41.02 | 5089000.0 |
| 2006-02-03 12:00:00 | QQQ | ETF | 41.03 | 41.04 | 40.95 | 40.98 | 2609100.0 |
| 2006-02-03 12:30:00 | QQQ | ETF | 40.98 | 41.02 | 40.94 | 40.98 | 2275100.0 |
| 2006-02-03 13:00:00 | QQQ | ETF | 40.97 | 41.23 | 40.97 | 41.16 | 6524500.0 |
| 2006-02-03 13:30:00 | QQQ | ETF | 41.16 | 41.23 | 41.06 | 41.07 | 4560600.0 |
| 2006-02-03 14:00:00 | QQQ | ETF | 41.08 | 41.1 | 40.91 | 40.95 | 5777200.0 |
| 2006-02-03 14:30:00 | QQQ | ETF | 40.96 | 41.03 | 40.9 | 40.92 | 3391300.0 |
| 2006-02-03 15:00:00 | QQQ | ETF | 40.93 | 41.02 | 40.89 | 40.93 | 6488400.0 |
| 2006-02-03 15:30:00 | QQQ | ETF | 40.93 | 40.96 | 40.78 | 40.93 | 11641700.0 |
| 2006-02-03 07:30:00 | IWM | ETF | 72.07 | 72.08 | 72.07 | 72.08 | 1000.0 |
| 2006-02-03 08:00:00 | IWM | ETF | 72.1 | 72.2 | 72.1 | 72.2 | 35200.0 |
| 2006-02-03 08:30:00 | IWM | ETF | 72.2 | 72.27 | 71.8 | 71.84 | 530300.0 |
| 2006-02-03 09:00:00 | IWM | ETF | 71.81 | 71.81 | 71.69 | 71.77 | 349200.0 |
| 2006-02-03 09:30:00 | IWM | ETF | 71.81 | 72.17 | 71.63 | 71.65 | 6279800.0 |
| 2006-02-03 10:00:00 | IWM | ETF | 71.65 | 71.89 | 71.52 | 71.65 | 4095700.0 |
| 2006-02-03 10:30:00 | IWM | ETF | 71.64 | 71.82 | 71.51 | 71.75 | 5104600.0 |
| 2006-02-03 11:00:00 | IWM | ETF | 71.75 | 71.87 | 71.67 | 71.86 | 2778500.0 |
| 2006-02-03 11:30:00 | IWM | ETF | 71.86 | 72.11 | 71.84 | 72.01 | 2313500.0 |
| 2006-02-03 12:00:00 | IWM | ETF | 72.01 | 72.04 | 71.85 | 71.97 | 1313200.0 |
| 2006-02-03 12:30:00 | IWM | ETF | 71.98 | 72.05 | 71.9 | 72.01 | 870700.0 |
> showing 50 of 2,132 rows — these rows as CSV