PREVIEW / etf_30min / 2006-07-11
file: by_date/etf_30min/2006/2006-07-11.parquet size: 75 KB rows: 2,595
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-11 04:00:00 | SPY | ETF | 126.63 | 126.63 | 126.63 | 126.63 | 500.0 |
| 2006-07-11 05:00:00 | SPY | ETF | 126.65 | 126.65 | 126.65 | 126.65 | 1000.0 |
| 2006-07-11 06:00:00 | SPY | ETF | 126.66 | 126.66 | 126.66 | 126.66 | 25000.0 |
| 2006-07-11 06:30:00 | SPY | ETF | 126.65 | 126.65 | 126.63 | 126.63 | 25000.0 |
| 2006-07-11 07:00:00 | SPY | ETF | 126.73 | 126.78 | 126.73 | 126.78 | 8500.0 |
| 2006-07-11 07:30:00 | SPY | ETF | 126.75 | 126.86 | 126.75 | 126.78 | 42500.0 |
| 2006-07-11 08:00:00 | SPY | ETF | 126.76 | 126.86 | 126.51 | 126.74 | 411300.0 |
| 2006-07-11 08:30:00 | SPY | ETF | 126.7 | 126.77 | 126.62 | 126.74 | 385500.0 |
| 2006-07-11 09:00:00 | SPY | ETF | 126.74 | 126.74 | 126.58 | 126.64 | 409000.0 |
| 2006-07-11 09:30:00 | SPY | ETF | 126.61 | 126.66 | 126.42 | 126.54 | 7654400.0 |
| 2006-07-11 10:00:00 | SPY | ETF | 126.52 | 126.58 | 126.28 | 126.41 | 6815300.0 |
| 2006-07-11 10:30:00 | SPY | ETF | 126.41 | 126.41 | 125.94 | 126.04 | 12734100.0 |
| 2006-07-11 11:00:00 | SPY | ETF | 126.03 | 126.24 | 126.03 | 126.24 | 4614000.0 |
| 2006-07-11 11:30:00 | SPY | ETF | 126.24 | 126.33 | 126.15 | 126.2 | 2394700.0 |
| 2006-07-11 12:00:00 | SPY | ETF | 126.2 | 126.42 | 126.12 | 126.31 | 2528800.0 |
| 2006-07-11 12:30:00 | SPY | ETF | 126.32 | 126.32 | 126.12 | 126.12 | 1027700.0 |
| 2006-07-11 13:00:00 | SPY | ETF | 126.12 | 126.22 | 126.07 | 126.13 | 1967900.0 |
| 2006-07-11 13:30:00 | SPY | ETF | 126.13 | 126.56 | 126.01 | 126.46 | 3555200.0 |
| 2006-07-11 14:00:00 | SPY | ETF | 126.45 | 126.89 | 126.39 | 126.75 | 6563200.0 |
| 2006-07-11 14:30:00 | SPY | ETF | 126.75 | 126.75 | 126.55 | 126.68 | 4401800.0 |
| 2006-07-11 15:00:00 | SPY | ETF | 126.68 | 127.26 | 126.57 | 127.13 | 7753400.0 |
| 2006-07-11 15:30:00 | SPY | ETF | 127.13 | 127.41 | 127.1 | 127.27 | 8192000.0 |
| 2006-07-11 16:00:00 | SPY | ETF | 127.27 | 127.41 | 127.25 | 127.36 | 525200.0 |
| 2006-07-11 16:30:00 | SPY | ETF | 127.36 | 127.4 | 127.25 | 127.4 | 457200.0 |
| 2006-07-11 17:00:00 | SPY | ETF | 127.4 | 127.48 | 127.38 | 127.44 | 70000.0 |
| 2006-07-11 17:30:00 | SPY | ETF | 127.48 | 127.48 | 127.48 | 127.48 | 400.0 |
| 2006-07-11 18:00:00 | SPY | ETF | 127.47 | 127.49 | 127.38 | 127.4 | 3800.0 |
| 2006-07-11 09:30:00 | QQQ | ETF | 37.28 | 37.37 | 37.19 | 37.28 | 14152500.0 |
| 2006-07-11 10:00:00 | QQQ | ETF | 37.28 | 37.29 | 37.09 | 37.23 | 15318900.0 |
| 2006-07-11 10:30:00 | QQQ | ETF | 37.23 | 37.23 | 37.08 | 37.16 | 9582400.0 |
| 2006-07-11 11:00:00 | QQQ | ETF | 37.17 | 37.22 | 37.13 | 37.22 | 4660600.0 |
| 2006-07-11 11:30:00 | QQQ | ETF | 37.21 | 37.28 | 37.18 | 37.19 | 5574900.0 |
| 2006-07-11 12:00:00 | QQQ | ETF | 37.19 | 37.26 | 37.15 | 37.22 | 3656300.0 |
| 2006-07-11 12:30:00 | QQQ | ETF | 37.23 | 37.23 | 37.11 | 37.12 | 2508000.0 |
| 2006-07-11 13:00:00 | QQQ | ETF | 37.12 | 37.16 | 37.08 | 37.13 | 3738600.0 |
| 2006-07-11 13:30:00 | QQQ | ETF | 37.14 | 37.42 | 37.11 | 37.36 | 11700100.0 |
| 2006-07-11 14:00:00 | QQQ | ETF | 37.36 | 37.58 | 37.31 | 37.52 | 20562300.0 |
| 2006-07-11 14:30:00 | QQQ | ETF | 37.52 | 37.52 | 37.37 | 37.43 | 7209800.0 |
| 2006-07-11 15:00:00 | QQQ | ETF | 37.43 | 37.7 | 37.38 | 37.63 | 13932400.0 |
| 2006-07-11 15:30:00 | QQQ | ETF | 37.64 | 37.74 | 37.63 | 37.64 | 14552200.0 |
| 2006-07-11 08:00:00 | IWM | ETF | 70.15 | 70.34 | 70.15 | 70.25 | 139000.0 |
| 2006-07-11 08:30:00 | IWM | ETF | 70.23 | 70.26 | 70.16 | 70.25 | 64900.0 |
| 2006-07-11 09:00:00 | IWM | ETF | 70.24 | 70.24 | 70.08 | 70.08 | 488400.0 |
| 2006-07-11 09:30:00 | IWM | ETF | 70.11 | 70.22 | 69.96 | 70.03 | 6861200.0 |
| 2006-07-11 10:00:00 | IWM | ETF | 70.04 | 70.06 | 69.72 | 69.85 | 4418300.0 |
| 2006-07-11 10:30:00 | IWM | ETF | 69.86 | 69.86 | 69.6 | 69.67 | 2378400.0 |
| 2006-07-11 11:00:00 | IWM | ETF | 69.69 | 69.78 | 69.65 | 69.73 | 5168900.0 |
| 2006-07-11 11:30:00 | IWM | ETF | 69.73 | 69.84 | 69.67 | 69.74 | 3193800.0 |
| 2006-07-11 12:00:00 | IWM | ETF | 69.74 | 69.92 | 69.66 | 69.86 | 1859900.0 |
| 2006-07-11 12:30:00 | IWM | ETF | 69.86 | 69.9 | 69.69 | 69.7 | 2416100.0 |
> showing 50 of 2,595 rows — these rows as CSV