PREVIEW / etf_30min / 2006-05-12
file: by_date/etf_30min/2006/2006-05-12.parquet size: 71 KB rows: 2,441
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-05-12 05:30:00 | SPY | ETF | 130.37 | 130.4 | 130.37 | 130.4 | 8500.0 |
| 2006-05-12 06:00:00 | SPY | ETF | 130.55 | 130.55 | 130.53 | 130.53 | 20700.0 |
| 2006-05-12 06:30:00 | SPY | ETF | 130.45 | 130.48 | 130.43 | 130.43 | 16500.0 |
| 2006-05-12 07:00:00 | SPY | ETF | 130.5 | 130.51 | 130.46 | 130.49 | 38600.0 |
| 2006-05-12 07:30:00 | SPY | ETF | 130.55 | 130.6 | 130.46 | 130.52 | 59900.0 |
| 2006-05-12 08:00:00 | SPY | ETF | 130.443 | 130.69 | 130.443 | 130.68 | 808300.0 |
| 2006-05-12 08:30:00 | SPY | ETF | 130.67 | 130.8 | 130.53 | 130.54 | 486600.0 |
| 2006-05-12 09:00:00 | SPY | ETF | 130.55 | 130.63 | 130.46 | 130.46 | 245700.0 |
| 2006-05-12 09:30:00 | SPY | ETF | 130.48 | 130.6 | 130.15 | 130.58 | 18664500.0 |
| 2006-05-12 10:00:00 | SPY | ETF | 130.59 | 130.72 | 130.09 | 130.18 | 12162000.0 |
| 2006-05-12 10:30:00 | SPY | ETF | 130.18 | 130.2 | 129.82 | 130.11 | 12754500.0 |
| 2006-05-12 11:00:00 | SPY | ETF | 130.08 | 130.23 | 129.98 | 130.07 | 5159600.0 |
| 2006-05-12 11:30:00 | SPY | ETF | 130.07 | 130.1 | 129.8 | 130.04 | 3830400.0 |
| 2006-05-12 12:00:00 | SPY | ETF | 130.03 | 130.28 | 130.01 | 130.05 | 3377100.0 |
| 2006-05-12 12:30:00 | SPY | ETF | 130.03 | 130.07 | 129.54 | 129.67 | 5580300.0 |
| 2006-05-12 13:00:00 | SPY | ETF | 129.65 | 129.78 | 129.47 | 129.69 | 4207800.0 |
| 2006-05-12 13:30:00 | SPY | ETF | 129.67 | 129.77 | 129.56 | 129.6 | 1671300.0 |
| 2006-05-12 14:00:00 | SPY | ETF | 129.61 | 130.1 | 129.57 | 129.87 | 3494800.0 |
| 2006-05-12 14:30:00 | SPY | ETF | 129.88 | 129.88 | 129.5 | 129.5 | 3803900.0 |
| 2006-05-12 15:00:00 | SPY | ETF | 129.5 | 129.71 | 129.43 | 129.58 | 5317300.0 |
| 2006-05-12 15:30:00 | SPY | ETF | 129.56 | 129.57 | 129.19 | 129.25 | 6771200.0 |
| 2006-05-12 16:00:00 | SPY | ETF | 129.249 | 129.37 | 129.18 | 129.23 | 812200.0 |
| 2006-05-12 16:30:00 | SPY | ETF | 129.23 | 129.31 | 129.23 | 129.28 | 179600.0 |
| 2006-05-12 17:00:00 | SPY | ETF | 129.29 | 129.29 | 129.18 | 129.18 | 7100.0 |
| 2006-05-12 17:30:00 | SPY | ETF | 129.18 | 129.21 | 129.18 | 129.2 | 5600.0 |
| 2006-05-12 18:00:00 | SPY | ETF | 129.19 | 129.19 | 129.18 | 129.18 | 2400.0 |
| 2006-05-12 18:30:00 | SPY | ETF | 129.24 | 129.24 | 129.24 | 129.24 | 100.0 |
| 2006-05-12 19:00:00 | SPY | ETF | 129.18 | 129.18 | 129.16 | 129.18 | 2800.0 |
| 2006-05-12 09:30:00 | QQQ | ETF | 40.57 | 40.62 | 39.96 | 40.59 | 36885100.0 |
| 2006-05-12 10:00:00 | QQQ | ETF | 40.59 | 40.61 | 40.35 | 40.39 | 17541200.0 |
| 2006-05-12 10:30:00 | QQQ | ETF | 40.39 | 40.4 | 40.2 | 40.34 | 17180600.0 |
| 2006-05-12 11:00:00 | QQQ | ETF | 40.35 | 40.45 | 40.29 | 40.4 | 8823100.0 |
| 2006-05-12 11:30:00 | QQQ | ETF | 40.4 | 40.42 | 40.23 | 40.4 | 8271300.0 |
| 2006-05-12 12:00:00 | QQQ | ETF | 40.4 | 40.56 | 40.39 | 40.4 | 8814500.0 |
| 2006-05-12 12:30:00 | QQQ | ETF | 40.4 | 40.4 | 40.21 | 40.29 | 10309200.0 |
| 2006-05-12 13:00:00 | QQQ | ETF | 40.28 | 40.35 | 40.19 | 40.32 | 6682000.0 |
| 2006-05-12 13:30:00 | QQQ | ETF | 40.32 | 40.34 | 40.27 | 40.3 | 3409900.0 |
| 2006-05-12 14:00:00 | QQQ | ETF | 40.29 | 40.5 | 40.29 | 40.39 | 5991400.0 |
| 2006-05-12 14:30:00 | QQQ | ETF | 40.39 | 40.4 | 40.25 | 40.27 | 4990000.0 |
| 2006-05-12 15:00:00 | QQQ | ETF | 40.27 | 40.34 | 40.24 | 40.31 | 4866900.0 |
| 2006-05-12 15:30:00 | QQQ | ETF | 40.31 | 40.31 | 40.18 | 40.2 | 10357000.0 |
| 2006-05-12 08:00:00 | IWM | ETF | 74.94 | 74.96 | 74.85 | 74.96 | 33700.0 |
| 2006-05-12 08:30:00 | IWM | ETF | 74.98 | 75.0 | 74.91 | 74.91 | 176700.0 |
| 2006-05-12 09:00:00 | IWM | ETF | 74.9 | 74.9 | 74.82 | 74.82 | 630600.0 |
| 2006-05-12 09:30:00 | IWM | ETF | 74.81 | 74.85 | 74.18 | 74.6 | 13028900.0 |
| 2006-05-12 10:00:00 | IWM | ETF | 74.61 | 74.73 | 74.25 | 74.27 | 6318800.0 |
| 2006-05-12 10:30:00 | IWM | ETF | 74.27 | 74.27 | 73.6 | 74.0 | 7283900.0 |
| 2006-05-12 11:00:00 | IWM | ETF | 74.0 | 74.17 | 73.84 | 74.05 | 4667100.0 |
| 2006-05-12 11:30:00 | IWM | ETF | 74.05 | 74.14 | 73.74 | 74.03 | 2766100.0 |
| 2006-05-12 12:00:00 | IWM | ETF | 74.02 | 74.33 | 74.0 | 74.12 | 2124100.0 |
> showing 50 of 2,441 rows — these rows as CSV