PREVIEW / etf_30min / 2006-01-11
file: by_date/etf_30min/2006/2006-01-11.parquet size: 59 KB rows: 2,130
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-01-11 06:30:00 | SPY | ETF | 129.13 | 129.13 | 129.13 | 129.13 | 200.0 |
| 2006-01-11 07:00:00 | SPY | ETF | 129.02 | 129.04 | 128.99 | 129.0 | 27400.0 |
| 2006-01-11 07:30:00 | SPY | ETF | 129.03 | 129.06 | 129.0 | 129.0 | 89500.0 |
| 2006-01-11 08:00:00 | SPY | ETF | 129.04 | 129.06 | 128.99 | 129.03 | 402700.0 |
| 2006-01-11 08:30:00 | SPY | ETF | 129.04 | 129.14 | 129.04 | 129.1 | 379700.0 |
| 2006-01-11 09:00:00 | SPY | ETF | 129.1 | 129.12 | 129.01 | 129.01 | 144600.0 |
| 2006-01-11 09:30:00 | SPY | ETF | 129.02 | 129.03 | 128.76 | 128.88 | 3170900.0 |
| 2006-01-11 10:00:00 | SPY | ETF | 128.87 | 129.14 | 128.76 | 129.05 | 3661600.0 |
| 2006-01-11 10:30:00 | SPY | ETF | 129.06 | 129.09 | 128.73 | 128.8 | 6264400.0 |
| 2006-01-11 11:00:00 | SPY | ETF | 128.8 | 129.0 | 128.74 | 128.95 | 2504700.0 |
| 2006-01-11 11:30:00 | SPY | ETF | 128.95 | 129.2 | 128.9 | 128.93 | 6089100.0 |
| 2006-01-11 12:00:00 | SPY | ETF | 128.93 | 129.18 | 128.91 | 129.05 | 2017400.0 |
| 2006-01-11 12:30:00 | SPY | ETF | 129.06 | 129.23 | 129.01 | 129.11 | 1924400.0 |
| 2006-01-11 13:00:00 | SPY | ETF | 129.11 | 129.15 | 128.82 | 128.89 | 3755800.0 |
| 2006-01-11 13:30:00 | SPY | ETF | 128.9 | 129.09 | 128.86 | 129.03 | 2456500.0 |
| 2006-01-11 14:00:00 | SPY | ETF | 129.05 | 129.27 | 128.97 | 129.15 | 4453300.0 |
| 2006-01-11 14:30:00 | SPY | ETF | 129.15 | 129.44 | 129.11 | 129.41 | 5280500.0 |
| 2006-01-11 15:00:00 | SPY | ETF | 129.39 | 129.44 | 129.28 | 129.38 | 2049300.0 |
| 2006-01-11 15:30:00 | SPY | ETF | 129.39 | 129.42 | 129.25 | 129.35 | 3255100.0 |
| 2006-01-11 16:00:00 | SPY | ETF | 129.37 | 129.38 | 129.28 | 129.35 | 511000.0 |
| 2006-01-11 16:30:00 | SPY | ETF | 129.31 | 129.31 | 129.25 | 129.3 | 23600.0 |
| 2006-01-11 17:00:00 | SPY | ETF | 129.29 | 129.32 | 129.27 | 129.3 | 38000.0 |
| 2006-01-11 17:30:00 | SPY | ETF | 129.3 | 129.34 | 129.3 | 129.33 | 12400.0 |
| 2006-01-11 18:00:00 | SPY | ETF | 129.31 | 129.33 | 129.27 | 129.27 | 4600.0 |
| 2006-01-11 18:30:00 | SPY | ETF | 129.28 | 129.29 | 129.27 | 129.27 | 4000.0 |
| 2006-01-11 19:00:00 | SPY | ETF | 129.28 | 129.28 | 129.28 | 129.28 | 200.0 |
| 2006-01-11 09:30:00 | QQQ | ETF | 43.01 | 43.02 | 42.87 | 42.95 | 13224600.0 |
| 2006-01-11 10:00:00 | QQQ | ETF | 42.95 | 43.1 | 42.89 | 43.05 | 11499700.0 |
| 2006-01-11 10:30:00 | QQQ | ETF | 43.05 | 43.1 | 42.97 | 43.02 | 8089800.0 |
| 2006-01-11 11:00:00 | QQQ | ETF | 43.02 | 43.11 | 42.99 | 43.09 | 5230000.0 |
| 2006-01-11 11:30:00 | QQQ | ETF | 43.09 | 43.23 | 43.07 | 43.09 | 8024100.0 |
| 2006-01-11 12:00:00 | QQQ | ETF | 43.08 | 43.24 | 43.06 | 43.18 | 6961200.0 |
| 2006-01-11 12:30:00 | QQQ | ETF | 43.19 | 43.2 | 43.14 | 43.16 | 3284100.0 |
| 2006-01-11 13:00:00 | QQQ | ETF | 43.16 | 43.17 | 43.05 | 43.11 | 6561400.0 |
| 2006-01-11 13:30:00 | QQQ | ETF | 43.1 | 43.2 | 42.17 | 43.18 | 5108300.0 |
| 2006-01-11 14:00:00 | QQQ | ETF | 43.18 | 43.25 | 43.15 | 43.22 | 5533300.0 |
| 2006-01-11 14:30:00 | QQQ | ETF | 43.21 | 43.31 | 43.19 | 43.29 | 6346400.0 |
| 2006-01-11 15:00:00 | QQQ | ETF | 43.29 | 43.31 | 43.24 | 43.28 | 4302500.0 |
| 2006-01-11 15:30:00 | QQQ | ETF | 43.28 | 43.3 | 43.19 | 43.21 | 8233100.0 |
| 2006-01-11 05:00:00 | IWM | ETF | 70.78 | 70.78 | 70.78 | 70.78 | 200.0 |
| 2006-01-11 07:30:00 | IWM | ETF | 70.7 | 70.7 | 70.7 | 70.7 | 2200.0 |
| 2006-01-11 08:00:00 | IWM | ETF | 70.71 | 70.71 | 70.65 | 70.65 | 16000.0 |
| 2006-01-11 08:30:00 | IWM | ETF | 70.7 | 70.73 | 70.69 | 70.73 | 135800.0 |
| 2006-01-11 09:00:00 | IWM | ETF | 70.7 | 70.75 | 70.68 | 70.69 | 189300.0 |
| 2006-01-11 09:30:00 | IWM | ETF | 70.71 | 70.73 | 70.34 | 70.45 | 2429300.0 |
| 2006-01-11 10:00:00 | IWM | ETF | 70.45 | 70.57 | 70.35 | 70.49 | 1277300.0 |
| 2006-01-11 10:30:00 | IWM | ETF | 70.49 | 70.53 | 70.25 | 70.32 | 3719100.0 |
| 2006-01-11 11:00:00 | IWM | ETF | 70.33 | 70.53 | 70.29 | 70.47 | 1381100.0 |
| 2006-01-11 11:30:00 | IWM | ETF | 70.45 | 70.49 | 70.11 | 70.15 | 2460400.0 |
| 2006-01-11 12:00:00 | IWM | ETF | 70.14 | 70.23 | 70.08 | 70.15 | 1711400.0 |
> showing 50 of 2,130 rows — these rows as CSV