PREVIEW / etf_30min / 2007-12-07
file: by_date/etf_30min/2007/2007-12-07.parquet size: 137 KB rows: 5,190
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-07 05:30:00 | SPY | ETF | 150.63 | 150.63 | 150.55 | 150.55 | 10500.0 |
| 2007-12-07 06:00:00 | SPY | ETF | 150.75 | 150.94 | 150.75 | 150.94 | 11700.0 |
| 2007-12-07 06:30:00 | SPY | ETF | 150.94 | 150.94 | 150.8 | 150.8 | 11500.0 |
| 2007-12-07 07:00:00 | SPY | ETF | 150.91 | 151.03 | 150.69 | 150.73 | 216800.0 |
| 2007-12-07 07:30:00 | SPY | ETF | 150.71 | 150.91 | 150.71 | 150.88 | 113200.0 |
| 2007-12-07 08:00:00 | SPY | ETF | 150.88 | 151.3 | 150.85 | 151.19 | 7226300.0 |
| 2007-12-07 08:30:00 | SPY | ETF | 151.21 | 151.68 | 150.33 | 151.41 | 15129900.0 |
| 2007-12-07 09:00:00 | SPY | ETF | 151.41 | 151.63 | 151.37 | 151.41 | 1738100.0 |
| 2007-12-07 09:30:00 | SPY | ETF | 151.42 | 151.5 | 151.0 | 151.17 | 23405539.0 |
| 2007-12-07 10:00:00 | SPY | ETF | 151.17 | 151.36 | 150.89 | 150.94 | 11971737.0 |
| 2007-12-07 10:30:00 | SPY | ETF | 150.93 | 151.01 | 150.75 | 150.93 | 10393254.0 |
| 2007-12-07 11:00:00 | SPY | ETF | 150.9399 | 151.07 | 150.84 | 150.92 | 7257102.0 |
| 2007-12-07 11:30:00 | SPY | ETF | 150.93 | 151.42 | 150.92 | 151.29 | 9218703.0 |
| 2007-12-07 12:00:00 | SPY | ETF | 151.29 | 151.36 | 151.18 | 151.23 | 5918631.0 |
| 2007-12-07 12:30:00 | SPY | ETF | 151.23 | 151.29 | 151.11 | 151.12 | 2144903.0 |
| 2007-12-07 13:00:00 | SPY | ETF | 151.12 | 151.15 | 150.68 | 150.8 | 5949045.0 |
| 2007-12-07 13:30:00 | SPY | ETF | 150.81 | 151.1 | 150.71 | 150.98 | 5873382.0 |
| 2007-12-07 14:00:00 | SPY | ETF | 150.99 | 151.18 | 150.84 | 150.95 | 3601371.0 |
| 2007-12-07 14:30:00 | SPY | ETF | 150.96 | 151.28 | 150.9 | 151.0 | 4818854.0 |
| 2007-12-07 15:00:00 | SPY | ETF | 151.01 | 151.34 | 150.91 | 151.08 | 7100781.0 |
| 2007-12-07 15:30:00 | SPY | ETF | 151.08 | 151.1 | 150.62 | 150.74 | 13240653.0 |
| 2007-12-07 16:00:00 | SPY | ETF | 150.7 | 151.0438 | 150.59 | 150.85 | 3741900.0 |
| 2007-12-07 16:30:00 | SPY | ETF | 150.86 | 151.62 | 150.81 | 150.86 | 6083500.0 |
| 2007-12-07 17:00:00 | SPY | ETF | 150.88 | 150.93 | 150.63 | 150.63 | 4900.0 |
| 2007-12-07 17:30:00 | SPY | ETF | 150.85 | 150.85 | 150.8 | 150.8 | 7600.0 |
| 2007-12-07 18:00:00 | SPY | ETF | 150.79 | 150.85 | 150.75 | 150.75 | 13500.0 |
| 2007-12-07 18:30:00 | SPY | ETF | 150.74 | 150.75 | 150.7 | 150.7 | 5700.0 |
| 2007-12-07 19:00:00 | SPY | ETF | 150.77 | 150.77 | 150.77 | 150.77 | 100.0 |
| 2007-12-07 19:30:00 | SPY | ETF | 150.78 | 150.8 | 150.77 | 150.8 | 1700.0 |
| 2007-12-07 06:00:00 | QQQ | ETF | 52.2 | 52.2 | 52.2 | 52.2 | 2000.0 |
| 2007-12-07 06:30:00 | QQQ | ETF | 52.2 | 52.21 | 52.2 | 52.21 | 1200.0 |
| 2007-12-07 07:00:00 | QQQ | ETF | 52.2 | 52.24 | 52.19 | 52.2 | 30000.0 |
| 2007-12-07 07:30:00 | QQQ | ETF | 52.2 | 52.2 | 52.14 | 52.14 | 57518.0 |
| 2007-12-07 08:00:00 | QQQ | ETF | 52.32 | 52.36 | 52.17 | 52.32 | 1891678.0 |
| 2007-12-07 08:30:00 | QQQ | ETF | 52.31 | 52.49 | 52.02 | 52.34 | 3295219.0 |
| 2007-12-07 09:00:00 | QQQ | ETF | 52.36 | 52.4 | 52.29 | 52.3 | 737394.0 |
| 2007-12-07 09:30:00 | QQQ | ETF | 52.29 | 52.33 | 52.08 | 52.1774 | 12756170.0 |
| 2007-12-07 10:00:00 | QQQ | ETF | 52.17 | 52.28 | 52.1099 | 52.17 | 10165504.0 |
| 2007-12-07 10:30:00 | QQQ | ETF | 52.17 | 52.25 | 52.1286 | 52.22 | 5677050.0 |
| 2007-12-07 11:00:00 | QQQ | ETF | 52.23 | 52.29 | 52.18 | 52.21 | 4606706.0 |
| 2007-12-07 11:30:00 | QQQ | ETF | 52.21 | 52.45 | 52.21 | 52.35 | 10584476.0 |
| 2007-12-07 12:00:00 | QQQ | ETF | 52.3501 | 52.41 | 52.28 | 52.34 | 2718341.0 |
| 2007-12-07 12:30:00 | QQQ | ETF | 52.35 | 52.36 | 52.25 | 52.25 | 1813166.0 |
| 2007-12-07 13:00:00 | QQQ | ETF | 52.2526 | 52.3 | 52.16 | 52.2 | 6419438.0 |
| 2007-12-07 13:30:00 | QQQ | ETF | 52.2 | 52.29 | 52.17 | 52.27 | 3324165.0 |
| 2007-12-07 14:00:00 | QQQ | ETF | 52.28 | 52.35 | 52.27 | 52.31 | 2952500.0 |
| 2007-12-07 14:30:00 | QQQ | ETF | 52.31 | 52.46 | 52.3 | 52.38 | 3507268.0 |
| 2007-12-07 15:00:00 | QQQ | ETF | 52.38 | 52.54 | 52.33 | 52.44 | 6966213.0 |
| 2007-12-07 15:30:00 | QQQ | ETF | 52.43 | 52.5 | 52.32 | 52.37 | 7996090.0 |
| 2007-12-07 16:00:00 | QQQ | ETF | 52.36 | 52.44 | 52.32 | 52.38 | 2293877.0 |
> showing 50 of 5,190 rows — these rows as CSV