PREVIEW / etf_30min / 2013-08-28
file: by_date/etf_30min/2013/2013-08-28.parquet size: 326 KB rows: 10,865
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-28 04:00:00 | SPY | ETF | 163.58 | 163.92 | 163.58 | 163.84 | 27230.0 |
| 2013-08-28 04:30:00 | SPY | ETF | 163.82 | 163.86 | 163.68 | 163.76 | 7200.0 |
| 2013-08-28 05:00:00 | SPY | ETF | 163.74 | 163.74 | 163.56 | 163.59 | 6200.0 |
| 2013-08-28 05:30:00 | SPY | ETF | 163.58 | 163.64 | 163.44 | 163.5 | 7800.0 |
| 2013-08-28 06:00:00 | SPY | ETF | 163.52 | 163.56 | 163.38 | 163.42 | 6800.0 |
| 2013-08-28 06:30:00 | SPY | ETF | 163.4 | 163.55 | 163.34 | 163.46 | 34600.0 |
| 2013-08-28 07:00:00 | SPY | ETF | 163.46 | 163.49 | 163.34 | 163.4 | 66115.0 |
| 2013-08-28 07:30:00 | SPY | ETF | 163.38 | 163.38 | 163.18 | 163.19 | 528458.0 |
| 2013-08-28 08:00:00 | SPY | ETF | 163.94 | 163.94 | 163.18 | 163.57 | 408359.0 |
| 2013-08-28 08:30:00 | SPY | ETF | 163.57 | 163.59 | 163.37 | 163.4 | 300915.0 |
| 2013-08-28 09:00:00 | SPY | ETF | 163.4 | 163.48 | 163.26 | 163.27 | 569062.0 |
| 2013-08-28 09:30:00 | SPY | ETF | 163.26 | 163.78 | 163.05 | 163.53 | 14533170.0 |
| 2013-08-28 10:00:00 | SPY | ETF | 163.53 | 163.85 | 163.39 | 163.73 | 8705448.0 |
| 2013-08-28 10:30:00 | SPY | ETF | 163.74 | 164.02 | 163.62 | 163.989 | 6229213.0 |
| 2013-08-28 11:00:00 | SPY | ETF | 163.99 | 164.132 | 163.92 | 163.92 | 5384084.0 |
| 2013-08-28 11:30:00 | SPY | ETF | 163.925 | 164.28 | 163.84 | 164.24 | 5930335.0 |
| 2013-08-28 12:00:00 | SPY | ETF | 164.231 | 164.339 | 164.12 | 164.3 | 3489883.0 |
| 2013-08-28 12:30:00 | SPY | ETF | 164.3001 | 164.47 | 164.26 | 164.381 | 3599831.0 |
| 2013-08-28 13:00:00 | SPY | ETF | 164.385 | 164.49 | 164.23 | 164.3897 | 5806601.0 |
| 2013-08-28 13:30:00 | SPY | ETF | 164.39 | 164.42 | 164.23 | 164.409 | 2579440.0 |
| 2013-08-28 14:00:00 | SPY | ETF | 164.4 | 164.45 | 164.06 | 164.11 | 4605046.0 |
| 2013-08-28 14:30:00 | SPY | ETF | 164.12 | 164.14 | 163.86 | 164.001 | 5364538.0 |
| 2013-08-28 15:00:00 | SPY | ETF | 164.01 | 164.39 | 163.96 | 164.27 | 6509283.0 |
| 2013-08-28 15:30:00 | SPY | ETF | 164.27 | 164.4 | 163.85 | 163.92 | 10863842.0 |
| 2013-08-28 16:00:00 | SPY | ETF | 163.92 | 164.372 | 163.41 | 163.72 | 10497944.0 |
| 2013-08-28 16:30:00 | SPY | ETF | 163.7 | 163.8576 | 163.41 | 163.62 | 5889306.0 |
| 2013-08-28 17:00:00 | SPY | ETF | 163.62 | 163.65 | 163.57 | 163.6 | 76540.0 |
| 2013-08-28 17:30:00 | SPY | ETF | 163.6 | 163.62 | 163.58 | 163.62 | 29657.0 |
| 2013-08-28 18:00:00 | SPY | ETF | 163.62 | 163.69 | 163.62 | 163.66 | 158161.0 |
| 2013-08-28 18:30:00 | SPY | ETF | 163.67 | 163.7 | 163.64 | 163.7 | 161590.0 |
| 2013-08-28 19:00:00 | SPY | ETF | 163.7 | 163.71 | 163.63 | 163.64 | 12516.0 |
| 2013-08-28 19:30:00 | SPY | ETF | 163.64 | 163.65 | 163.51 | 163.62 | 61690.0 |
| 2013-08-28 04:00:00 | QQQ | ETF | 75.3 | 75.36 | 75.3 | 75.31 | 16500.0 |
| 2013-08-28 04:30:00 | QQQ | ETF | 75.34 | 75.34 | 75.25 | 75.31 | 11400.0 |
| 2013-08-28 05:00:00 | QQQ | ETF | 75.28 | 75.28 | 75.24 | 75.24 | 3800.0 |
| 2013-08-28 05:30:00 | QQQ | ETF | 75.26 | 75.26 | 75.2 | 75.2 | 5900.0 |
| 2013-08-28 06:00:00 | QQQ | ETF | 75.24 | 75.24 | 75.2 | 75.2 | 6900.0 |
| 2013-08-28 06:30:00 | QQQ | ETF | 75.18 | 75.22 | 75.15 | 75.2 | 5800.0 |
| 2013-08-28 07:00:00 | QQQ | ETF | 75.22 | 75.22 | 75.18 | 75.18 | 6380.0 |
| 2013-08-28 07:30:00 | QQQ | ETF | 75.17 | 75.17 | 75.08 | 75.09 | 57730.0 |
| 2013-08-28 08:00:00 | QQQ | ETF | 75.08 | 75.33 | 75.08 | 75.23 | 45860.0 |
| 2013-08-28 08:30:00 | QQQ | ETF | 75.23 | 75.28 | 75.17 | 75.18 | 73547.0 |
| 2013-08-28 09:00:00 | QQQ | ETF | 75.15 | 75.21 | 75.08 | 75.08 | 179881.0 |
| 2013-08-28 09:30:00 | QQQ | ETF | 75.08 | 75.46 | 75.05 | 75.34 | 3254511.0 |
| 2013-08-28 10:00:00 | QQQ | ETF | 75.3432 | 75.44 | 75.2 | 75.369 | 1902242.0 |
| 2013-08-28 10:30:00 | QQQ | ETF | 75.36 | 75.5314 | 75.31 | 75.5 | 1113445.0 |
| 2013-08-28 11:00:00 | QQQ | ETF | 75.51 | 75.53 | 75.4 | 75.4 | 1208934.0 |
| 2013-08-28 11:30:00 | QQQ | ETF | 75.4 | 75.57 | 75.35 | 75.55 | 1306499.0 |
| 2013-08-28 12:00:00 | QQQ | ETF | 75.55 | 75.595 | 75.5 | 75.58 | 940452.0 |
| 2013-08-28 12:30:00 | QQQ | ETF | 75.5801 | 75.72 | 75.58 | 75.68 | 959114.0 |
> showing 50 of 10,865 rows — these rows as CSV