PREVIEW / etf_30min / 2006-07-06
file: by_date/etf_30min/2006/2006-07-06.parquet size: 71 KB rows: 2,560
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-07-06 04:30:00 | SPY | ETF | 127.35 | 127.4 | 127.35 | 127.4 | 400.0 |
| 2006-07-06 05:30:00 | SPY | ETF | 127.39 | 127.39 | 127.38 | 127.38 | 200.0 |
| 2006-07-06 06:30:00 | SPY | ETF | 127.32 | 127.34 | 127.32 | 127.34 | 1100.0 |
| 2006-07-06 07:00:00 | SPY | ETF | 127.29 | 127.3 | 127.22 | 127.22 | 2300.0 |
| 2006-07-06 07:30:00 | SPY | ETF | 127.23 | 127.3 | 127.23 | 127.3 | 20900.0 |
| 2006-07-06 08:00:00 | SPY | ETF | 127.29 | 127.38 | 127.19 | 127.35 | 407100.0 |
| 2006-07-06 08:30:00 | SPY | ETF | 127.36 | 127.44 | 127.25 | 127.28 | 625400.0 |
| 2006-07-06 09:00:00 | SPY | ETF | 127.28 | 127.3 | 127.2 | 127.2 | 114400.0 |
| 2006-07-06 09:30:00 | SPY | ETF | 127.2 | 127.51 | 127.17 | 127.37 | 3445300.0 |
| 2006-07-06 10:00:00 | SPY | ETF | 127.37 | 127.83 | 127.33 | 127.74 | 5414000.0 |
| 2006-07-06 10:30:00 | SPY | ETF | 127.73 | 127.8 | 127.52 | 127.64 | 4853700.0 |
| 2006-07-06 11:00:00 | SPY | ETF | 127.63 | 127.85 | 127.56 | 127.72 | 6303700.0 |
| 2006-07-06 11:30:00 | SPY | ETF | 127.73 | 127.77 | 127.47 | 127.51 | 3270400.0 |
| 2006-07-06 12:00:00 | SPY | ETF | 127.5 | 127.6 | 127.24 | 127.37 | 3013300.0 |
| 2006-07-06 12:30:00 | SPY | ETF | 127.3794 | 127.49 | 127.28 | 127.37 | 1759000.0 |
| 2006-07-06 13:00:00 | SPY | ETF | 127.38 | 127.53 | 127.35 | 127.45 | 2733200.0 |
| 2006-07-06 13:30:00 | SPY | ETF | 127.4494 | 127.66 | 127.41 | 127.41 | 2402900.0 |
| 2006-07-06 14:00:00 | SPY | ETF | 127.41 | 127.47 | 127.21 | 127.26 | 2453100.0 |
| 2006-07-06 14:30:00 | SPY | ETF | 127.26 | 127.33 | 127.08 | 127.15 | 3030400.0 |
| 2006-07-06 15:00:00 | SPY | ETF | 127.15 | 127.39 | 127.0875 | 127.24 | 2952700.0 |
| 2006-07-06 15:30:00 | SPY | ETF | 127.23 | 127.47 | 127.16 | 127.37 | 4772900.0 |
| 2006-07-06 16:00:00 | SPY | ETF | 127.36 | 127.7 | 127.29 | 127.38 | 701000.0 |
| 2006-07-06 16:30:00 | SPY | ETF | 127.4 | 127.45 | 127.36 | 127.45 | 60200.0 |
| 2006-07-06 17:00:00 | SPY | ETF | 127.45 | 127.47 | 127.37 | 127.44 | 169600.0 |
| 2006-07-06 17:30:00 | SPY | ETF | 127.37 | 127.49 | 127.37 | 127.44 | 93000.0 |
| 2006-07-06 18:00:00 | SPY | ETF | 127.45 | 127.45 | 127.33 | 127.35 | 1189200.0 |
| 2006-07-06 18:30:00 | SPY | ETF | 127.36 | 127.36 | 127.36 | 127.36 | 200.0 |
| 2006-07-06 19:00:00 | SPY | ETF | 127.34 | 127.34 | 127.33 | 127.33 | 1000.0 |
| 2006-07-06 09:30:00 | QQQ | ETF | 38.26 | 38.64 | 38.2 | 38.23 | 6873400.0 |
| 2006-07-06 10:00:00 | QQQ | ETF | 38.23 | 38.48 | 38.21 | 38.44 | 9124400.0 |
| 2006-07-06 10:30:00 | QQQ | ETF | 38.44 | 38.46 | 38.29 | 38.32 | 6152000.0 |
| 2006-07-06 11:00:00 | QQQ | ETF | 38.33 | 38.42 | 38.29 | 38.38 | 3767100.0 |
| 2006-07-06 11:30:00 | QQQ | ETF | 38.38 | 38.38 | 38.22 | 38.24 | 4000300.0 |
| 2006-07-06 12:00:00 | QQQ | ETF | 38.24 | 38.27 | 38.11 | 38.17 | 4575400.0 |
| 2006-07-06 12:30:00 | QQQ | ETF | 38.18 | 38.21 | 38.13 | 38.16 | 2820200.0 |
| 2006-07-06 13:00:00 | QQQ | ETF | 38.17 | 38.26 | 38.15 | 38.18 | 3098600.0 |
| 2006-07-06 13:30:00 | QQQ | ETF | 38.18 | 38.29 | 38.17 | 38.18 | 2387600.0 |
| 2006-07-06 14:00:00 | QQQ | ETF | 38.18 | 38.19 | 38.08 | 38.09 | 4290500.0 |
| 2006-07-06 14:30:00 | QQQ | ETF | 38.09 | 38.11 | 38.01 | 38.05 | 4780000.0 |
| 2006-07-06 15:00:00 | QQQ | ETF | 38.05 | 38.15 | 38.03 | 38.07 | 3841700.0 |
| 2006-07-06 15:30:00 | QQQ | ETF | 38.07 | 38.2 | 38.05 | 38.1 | 8566700.0 |
| 2006-07-06 08:00:00 | IWM | ETF | 71.67 | 71.75 | 71.67 | 71.74 | 20200.0 |
| 2006-07-06 08:30:00 | IWM | ETF | 71.75 | 71.9 | 71.71 | 71.73 | 33400.0 |
| 2006-07-06 09:00:00 | IWM | ETF | 71.69 | 71.74 | 71.66 | 71.71 | 48500.0 |
| 2006-07-06 09:30:00 | IWM | ETF | 71.71 | 72.15 | 71.66 | 71.82 | 5602800.0 |
| 2006-07-06 10:00:00 | IWM | ETF | 71.81 | 72.15 | 71.77 | 72.09 | 2945600.0 |
| 2006-07-06 10:30:00 | IWM | ETF | 72.09 | 72.2 | 71.77 | 71.88 | 2779300.0 |
| 2006-07-06 11:00:00 | IWM | ETF | 71.88 | 72.04 | 71.8 | 71.95 | 1497300.0 |
| 2006-07-06 11:30:00 | IWM | ETF | 71.98 | 72.01 | 71.8 | 71.84 | 1458100.0 |
| 2006-07-06 12:00:00 | IWM | ETF | 71.84 | 71.88 | 71.54 | 71.67 | 1998600.0 |
> showing 50 of 2,560 rows — these rows as CSV