PREVIEW / etf_30min / 2011-02-15
file: by_date/etf_30min/2011/2011-02-15.parquet size: 270 KB rows: 9,136
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-15 04:00:00 | SPY | ETF | 133.15 | 133.23 | 133.15 | 133.23 | 1800.0 |
| 2011-02-15 04:30:00 | SPY | ETF | 133.2 | 133.2 | 133.13 | 133.13 | 5100.0 |
| 2011-02-15 05:00:00 | SPY | ETF | 133.21 | 133.32 | 133.21 | 133.26 | 700.0 |
| 2011-02-15 05:30:00 | SPY | ETF | 133.33 | 133.33 | 133.28 | 133.28 | 2400.0 |
| 2011-02-15 06:00:00 | SPY | ETF | 133.28 | 133.28 | 133.24 | 133.24 | 700.0 |
| 2011-02-15 06:30:00 | SPY | ETF | 133.2 | 133.25 | 133.2 | 133.25 | 83100.0 |
| 2011-02-15 07:00:00 | SPY | ETF | 133.24 | 133.25 | 133.15 | 133.18 | 23769.0 |
| 2011-02-15 07:30:00 | SPY | ETF | 133.18 | 133.18 | 133.02 | 133.03 | 1441629.0 |
| 2011-02-15 08:00:00 | SPY | ETF | 133.01 | 133.24 | 133.0 | 133.12 | 2233309.0 |
| 2011-02-15 08:30:00 | SPY | ETF | 133.11 | 133.11 | 132.87 | 132.96 | 908451.0 |
| 2011-02-15 09:00:00 | SPY | ETF | 132.95 | 133.02 | 132.84 | 133.02 | 950245.0 |
| 2011-02-15 09:30:00 | SPY | ETF | 133.02 | 133.2 | 132.85 | 133.16 | 13471717.0 |
| 2011-02-15 10:00:00 | SPY | ETF | 133.16 | 133.22 | 132.66 | 132.69 | 13989023.0 |
| 2011-02-15 10:30:00 | SPY | ETF | 132.69 | 133.0 | 132.67 | 132.9102 | 7682868.0 |
| 2011-02-15 11:00:00 | SPY | ETF | 132.92 | 133.12 | 132.91 | 133.09 | 7961973.0 |
| 2011-02-15 11:30:00 | SPY | ETF | 133.1 | 133.13 | 132.89 | 132.94 | 5077895.0 |
| 2011-02-15 12:00:00 | SPY | ETF | 132.95 | 133.12 | 132.85 | 133.12 | 3565436.0 |
| 2011-02-15 12:30:00 | SPY | ETF | 133.12 | 133.19 | 133.08 | 133.0985 | 3258660.0 |
| 2011-02-15 13:00:00 | SPY | ETF | 133.09 | 133.15 | 133.02 | 133.041 | 7307312.0 |
| 2011-02-15 13:30:00 | SPY | ETF | 133.045 | 133.16 | 132.98 | 133.02 | 3559954.0 |
| 2011-02-15 14:00:00 | SPY | ETF | 133.01 | 133.02 | 132.68 | 132.71 | 7559977.0 |
| 2011-02-15 14:30:00 | SPY | ETF | 132.7 | 132.96 | 132.66 | 132.91 | 5111638.0 |
| 2011-02-15 15:00:00 | SPY | ETF | 132.91 | 133.02 | 132.85 | 132.9 | 5883151.0 |
| 2011-02-15 15:30:00 | SPY | ETF | 132.9 | 133.05 | 132.78 | 133.01 | 15335557.0 |
| 2011-02-15 16:00:00 | SPY | ETF | 133.01 | 133.4574 | 132.9 | 133.02 | 12670781.0 |
| 2011-02-15 16:30:00 | SPY | ETF | 133.03 | 133.04 | 132.92 | 133.03 | 481523.0 |
| 2011-02-15 17:00:00 | SPY | ETF | 133.06 | 133.11 | 133.03 | 133.1 | 201869.0 |
| 2011-02-15 17:30:00 | SPY | ETF | 133.11 | 133.11 | 133.05 | 133.09 | 28775.0 |
| 2011-02-15 18:00:00 | SPY | ETF | 133.09 | 133.09 | 133.03 | 133.07 | 19286.0 |
| 2011-02-15 18:30:00 | SPY | ETF | 133.05 | 133.12 | 133.05 | 133.12 | 48700.0 |
| 2011-02-15 19:00:00 | SPY | ETF | 133.1 | 133.18 | 133.1 | 133.15 | 24100.0 |
| 2011-02-15 19:30:00 | SPY | ETF | 133.14 | 133.19 | 133.12 | 133.18 | 34645.0 |
| 2011-02-15 05:30:00 | QQQ | ETF | 58.58 | 58.58 | 58.58 | 58.58 | 2500.0 |
| 2011-02-15 06:00:00 | QQQ | ETF | 58.56 | 58.56 | 58.56 | 58.56 | 500.0 |
| 2011-02-15 06:30:00 | QQQ | ETF | 58.55 | 58.55 | 58.55 | 58.55 | 100.0 |
| 2011-02-15 07:00:00 | QQQ | ETF | 58.53 | 58.54 | 58.52 | 58.53 | 175045.0 |
| 2011-02-15 07:30:00 | QQQ | ETF | 58.52 | 58.52 | 58.45 | 58.45 | 645560.0 |
| 2011-02-15 08:00:00 | QQQ | ETF | 58.46 | 58.53 | 58.4 | 58.45 | 2628065.0 |
| 2011-02-15 08:30:00 | QQQ | ETF | 58.45 | 58.45 | 58.35 | 58.41 | 597324.0 |
| 2011-02-15 09:00:00 | QQQ | ETF | 58.4 | 58.46 | 58.38 | 58.45 | 227594.0 |
| 2011-02-15 09:30:00 | QQQ | ETF | 58.44 | 58.57 | 58.32 | 58.55 | 6408470.0 |
| 2011-02-15 10:00:00 | QQQ | ETF | 58.545 | 58.57 | 58.23 | 58.24 | 5776040.0 |
| 2011-02-15 10:30:00 | QQQ | ETF | 58.25 | 58.43 | 58.24 | 58.35 | 2071792.0 |
| 2011-02-15 11:00:00 | QQQ | ETF | 58.36 | 58.47 | 58.35 | 58.46 | 1485198.0 |
| 2011-02-15 11:30:00 | QQQ | ETF | 58.46 | 58.4795 | 58.34 | 58.38 | 1409989.0 |
| 2011-02-15 12:00:00 | QQQ | ETF | 58.38 | 58.5197 | 58.34 | 58.5075 | 1476339.0 |
| 2011-02-15 12:30:00 | QQQ | ETF | 58.51 | 58.55 | 58.49 | 58.52 | 993461.0 |
| 2011-02-15 13:00:00 | QQQ | ETF | 58.52 | 58.54 | 58.48 | 58.5005 | 1019791.0 |
| 2011-02-15 13:30:00 | QQQ | ETF | 58.5 | 58.54 | 58.45 | 58.48 | 1105349.0 |
| 2011-02-15 14:00:00 | QQQ | ETF | 58.485 | 58.49 | 58.32 | 58.33 | 2438737.0 |
> showing 50 of 9,136 rows — these rows as CSV