PREVIEW / etf_30min / 2008-11-25
file: by_date/etf_30min/2008/2008-11-25.parquet size: 187 KB rows: 6,651
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-25 04:00:00 | SPY | ETF | 84.33 | 84.46 | 84.33 | 84.41 | 400.0 |
| 2008-11-25 04:30:00 | SPY | ETF | 84.69 | 84.77 | 84.69 | 84.77 | 400.0 |
| 2008-11-25 05:00:00 | SPY | ETF | 84.82 | 84.82 | 84.33 | 84.77 | 1000.0 |
| 2008-11-25 05:30:00 | SPY | ETF | 84.71 | 85.08 | 84.71 | 84.77 | 4425.0 |
| 2008-11-25 06:00:00 | SPY | ETF | 84.82 | 85.38 | 84.82 | 85.38 | 18752.0 |
| 2008-11-25 06:30:00 | SPY | ETF | 85.41 | 86.36 | 85.41 | 86.28 | 54940.0 |
| 2008-11-25 07:00:00 | SPY | ETF | 86.3 | 86.35 | 85.65 | 85.65 | 580877.0 |
| 2008-11-25 07:30:00 | SPY | ETF | 85.67 | 85.8 | 85.05 | 85.15 | 563933.0 |
| 2008-11-25 08:00:00 | SPY | ETF | 85.13 | 86.92 | 84.7 | 86.39 | 8522609.0 |
| 2008-11-25 08:30:00 | SPY | ETF | 86.39 | 87.75 | 86.22 | 87.27 | 9000089.0 |
| 2008-11-25 09:00:00 | SPY | ETF | 87.27 | 87.79 | 87.08 | 87.29 | 6733229.0 |
| 2008-11-25 09:30:00 | SPY | ETF | 87.3 | 87.51 | 85.96 | 86.55 | 58576999.0 |
| 2008-11-25 10:00:00 | SPY | ETF | 86.38 | 87.36 | 86.05 | 86.66 | 45488686.0 |
| 2008-11-25 10:30:00 | SPY | ETF | 86.66 | 86.78 | 85.02 | 85.42 | 30341351.0 |
| 2008-11-25 11:00:00 | SPY | ETF | 85.42 | 85.68 | 84.43 | 85.5595 | 26247323.0 |
| 2008-11-25 11:30:00 | SPY | ETF | 85.55 | 86.22 | 85.32 | 85.85 | 18787594.0 |
| 2008-11-25 12:00:00 | SPY | ETF | 85.85 | 86.15 | 84.8 | 85.1 | 21991032.0 |
| 2008-11-25 12:30:00 | SPY | ETF | 85.1 | 85.5427 | 84.08 | 84.48 | 26103410.0 |
| 2008-11-25 13:00:00 | SPY | ETF | 84.5 | 85.35 | 84.19 | 85.19 | 19972466.0 |
| 2008-11-25 13:30:00 | SPY | ETF | 85.19 | 85.6 | 84.85 | 84.87 | 22483208.0 |
| 2008-11-25 14:00:00 | SPY | ETF | 84.878 | 85.15 | 83.82 | 84.24 | 22826263.0 |
| 2008-11-25 14:30:00 | SPY | ETF | 84.24 | 85.9 | 84.11 | 85.73 | 25132675.0 |
| 2008-11-25 15:00:00 | SPY | ETF | 85.7725 | 86.58 | 85.2 | 85.76 | 38474362.0 |
| 2008-11-25 15:30:00 | SPY | ETF | 85.76 | 86.86 | 85.48 | 86.05 | 59773430.0 |
| 2008-11-25 16:00:00 | SPY | ETF | 86.08 | 86.17 | 85.71 | 85.74 | 7326987.0 |
| 2008-11-25 16:30:00 | SPY | ETF | 85.75 | 85.75 | 85.4 | 85.68 | 2470476.0 |
| 2008-11-25 17:00:00 | SPY | ETF | 85.66 | 85.68 | 85.39 | 85.39 | 123366.0 |
| 2008-11-25 17:30:00 | SPY | ETF | 85.39 | 85.52 | 85.37 | 85.4 | 26534.0 |
| 2008-11-25 18:00:00 | SPY | ETF | 85.36 | 85.36 | 85.2 | 85.2 | 84019.0 |
| 2008-11-25 18:30:00 | SPY | ETF | 85.24 | 85.42 | 85.2 | 85.41 | 17863.0 |
| 2008-11-25 19:00:00 | SPY | ETF | 85.43 | 85.58 | 85.24 | 85.3 | 17067.0 |
| 2008-11-25 19:30:00 | SPY | ETF | 85.41 | 85.52 | 85.36 | 85.36 | 9645.0 |
| 2008-11-25 04:00:00 | QQQ | ETF | 27.95 | 27.95 | 27.95 | 27.95 | 100.0 |
| 2008-11-25 06:00:00 | QQQ | ETF | 28.11 | 28.11 | 28.09 | 28.09 | 15000.0 |
| 2008-11-25 06:30:00 | QQQ | ETF | 28.25 | 28.45 | 28.25 | 28.45 | 3660.0 |
| 2008-11-25 07:00:00 | QQQ | ETF | 28.48 | 28.48 | 28.32 | 28.33 | 36049.0 |
| 2008-11-25 07:30:00 | QQQ | ETF | 28.28 | 28.28 | 28.1 | 28.16 | 85128.0 |
| 2008-11-25 08:00:00 | QQQ | ETF | 28.15 | 28.69 | 27.85 | 28.43 | 3898881.0 |
| 2008-11-25 08:30:00 | QQQ | ETF | 28.49 | 28.8 | 28.4 | 28.68 | 2729356.0 |
| 2008-11-25 09:00:00 | QQQ | ETF | 28.68 | 28.78 | 28.59 | 28.63 | 1985836.0 |
| 2008-11-25 09:30:00 | QQQ | ETF | 28.63 | 28.64 | 28.04 | 28.17 | 22871597.0 |
| 2008-11-25 10:00:00 | QQQ | ETF | 28.18 | 28.33 | 27.96 | 28.07 | 22021156.0 |
| 2008-11-25 10:30:00 | QQQ | ETF | 28.07 | 28.12 | 27.72 | 27.78 | 17356640.0 |
| 2008-11-25 11:00:00 | QQQ | ETF | 27.78 | 27.99 | 27.55 | 27.98 | 13851228.0 |
| 2008-11-25 11:30:00 | QQQ | ETF | 27.98 | 28.17 | 27.89 | 28.0799 | 13356796.0 |
| 2008-11-25 12:00:00 | QQQ | ETF | 28.08 | 28.11 | 27.75 | 27.82 | 8134229.0 |
| 2008-11-25 12:30:00 | QQQ | ETF | 27.81 | 27.89 | 27.53 | 27.65 | 9545180.0 |
| 2008-11-25 13:00:00 | QQQ | ETF | 27.66 | 27.9 | 27.6 | 27.84 | 8869402.0 |
| 2008-11-25 13:30:00 | QQQ | ETF | 27.85 | 28.0 | 27.77 | 27.78 | 9119046.0 |
| 2008-11-25 14:00:00 | QQQ | ETF | 27.79 | 27.85 | 27.52 | 27.6279 | 12046201.0 |
> showing 50 of 6,651 rows — these rows as CSV