PREVIEW / etf_30min / 2013-12-12
file: by_date/etf_30min/2013/2013-12-12.parquet size: 334 KB rows: 11,216
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-12-12 04:00:00 | SPY | ETF | 178.8 | 178.9 | 178.78 | 178.81 | 26543.0 |
| 2013-12-12 04:30:00 | SPY | ETF | 178.85 | 178.85 | 178.77 | 178.84 | 11906.0 |
| 2013-12-12 05:00:00 | SPY | ETF | 178.84 | 178.85 | 178.67 | 178.67 | 6812.0 |
| 2013-12-12 05:30:00 | SPY | ETF | 178.67 | 178.68 | 178.4 | 178.54 | 24300.0 |
| 2013-12-12 06:00:00 | SPY | ETF | 178.49 | 178.5 | 178.31 | 178.37 | 42387.0 |
| 2013-12-12 06:30:00 | SPY | ETF | 178.37 | 178.39 | 178.31 | 178.37 | 47009.0 |
| 2013-12-12 07:00:00 | SPY | ETF | 178.37 | 178.56 | 178.36 | 178.56 | 80237.0 |
| 2013-12-12 07:30:00 | SPY | ETF | 178.53 | 178.56 | 178.42 | 178.55 | 1176928.0 |
| 2013-12-12 08:00:00 | SPY | ETF | 178.55 | 178.6 | 178.38 | 178.53 | 664363.0 |
| 2013-12-12 08:30:00 | SPY | ETF | 178.54 | 178.95 | 178.36 | 178.92 | 3156491.0 |
| 2013-12-12 09:00:00 | SPY | ETF | 178.93 | 178.93 | 178.49 | 178.62 | 1592031.0 |
| 2013-12-12 09:30:00 | SPY | ETF | 178.64 | 178.86 | 178.29 | 178.45 | 14258147.0 |
| 2013-12-12 10:00:00 | SPY | ETF | 178.45 | 178.64 | 178.08 | 178.36 | 8944701.0 |
| 2013-12-12 10:30:00 | SPY | ETF | 178.36 | 178.55 | 178.29 | 178.46 | 6685965.0 |
| 2013-12-12 11:00:00 | SPY | ETF | 178.46 | 178.7894 | 178.22 | 178.32 | 5360192.0 |
| 2013-12-12 11:30:00 | SPY | ETF | 178.31 | 178.465 | 178.25 | 178.26 | 4632354.0 |
| 2013-12-12 12:00:00 | SPY | ETF | 178.26 | 178.35 | 177.76 | 177.92 | 8002372.0 |
| 2013-12-12 12:30:00 | SPY | ETF | 177.925 | 178.12 | 177.7901 | 178.028 | 5021333.0 |
| 2013-12-12 13:00:00 | SPY | ETF | 178.02 | 178.32 | 178.0 | 178.2395 | 3785219.0 |
| 2013-12-12 13:30:00 | SPY | ETF | 178.26 | 178.449 | 178.179 | 178.33 | 3668706.0 |
| 2013-12-12 14:00:00 | SPY | ETF | 178.33 | 178.72 | 178.32 | 178.63 | 5003822.0 |
| 2013-12-12 14:30:00 | SPY | ETF | 178.64 | 178.84 | 178.49 | 178.7201 | 4783651.0 |
| 2013-12-12 15:00:00 | SPY | ETF | 178.73 | 178.745 | 178.4 | 178.62 | 6097607.0 |
| 2013-12-12 15:30:00 | SPY | ETF | 178.63 | 178.69 | 178.03 | 178.18 | 19167152.0 |
| 2013-12-12 16:00:00 | SPY | ETF | 178.17 | 178.7816 | 177.96 | 178.06 | 7687817.0 |
| 2013-12-12 16:30:00 | SPY | ETF | 178.07 | 178.07 | 177.93 | 177.94 | 568767.0 |
| 2013-12-12 17:00:00 | SPY | ETF | 177.95 | 178.7816 | 177.88 | 177.91 | 2124547.0 |
| 2013-12-12 17:30:00 | SPY | ETF | 177.94 | 177.96 | 177.93 | 177.94 | 23014.0 |
| 2013-12-12 18:00:00 | SPY | ETF | 177.95 | 178.1 | 177.93 | 178.09 | 195531.0 |
| 2013-12-12 18:30:00 | SPY | ETF | 178.1 | 178.14 | 178.04 | 178.04 | 41502.0 |
| 2013-12-12 19:00:00 | SPY | ETF | 178.01 | 178.06 | 177.98 | 178.04 | 26708.0 |
| 2013-12-12 19:30:00 | SPY | ETF | 178.06 | 178.11 | 177.98 | 178.04 | 23695.0 |
| 2013-12-12 04:00:00 | QQQ | ETF | 85.32 | 85.32 | 85.32 | 85.32 | 2000.0 |
| 2013-12-12 04:30:00 | QQQ | ETF | 85.26 | 85.26 | 85.25 | 85.26 | 10700.0 |
| 2013-12-12 05:00:00 | QQQ | ETF | 85.28 | 85.28 | 85.22 | 85.22 | 2600.0 |
| 2013-12-12 05:30:00 | QQQ | ETF | 85.19 | 85.19 | 85.1 | 85.13 | 3200.0 |
| 2013-12-12 06:00:00 | QQQ | ETF | 85.16 | 85.16 | 85.1 | 85.1 | 2400.0 |
| 2013-12-12 06:30:00 | QQQ | ETF | 85.1 | 85.11 | 85.1 | 85.11 | 25000.0 |
| 2013-12-12 07:00:00 | QQQ | ETF | 85.11 | 85.14 | 85.1 | 85.14 | 9300.0 |
| 2013-12-12 07:30:00 | QQQ | ETF | 85.13 | 85.17 | 85.11 | 85.17 | 150355.0 |
| 2013-12-12 08:00:00 | QQQ | ETF | 85.17 | 85.19 | 85.13 | 85.16 | 278278.0 |
| 2013-12-12 08:30:00 | QQQ | ETF | 85.14 | 85.37 | 85.11 | 85.32 | 1147012.0 |
| 2013-12-12 09:00:00 | QQQ | ETF | 85.33 | 85.33 | 85.18 | 85.25 | 456254.0 |
| 2013-12-12 09:30:00 | QQQ | ETF | 85.24 | 85.4201 | 85.08 | 85.195 | 5103217.0 |
| 2013-12-12 10:00:00 | QQQ | ETF | 85.18 | 85.3 | 85.02 | 85.16 | 2721999.0 |
| 2013-12-12 10:30:00 | QQQ | ETF | 85.16 | 85.38 | 85.14 | 85.3 | 2475955.0 |
| 2013-12-12 11:00:00 | QQQ | ETF | 85.3 | 85.4 | 85.14 | 85.1593 | 1444695.0 |
| 2013-12-12 11:30:00 | QQQ | ETF | 85.16 | 85.21 | 85.07 | 85.07 | 985177.0 |
| 2013-12-12 12:00:00 | QQQ | ETF | 85.06 | 85.14 | 84.93 | 85.01 | 2430881.0 |
| 2013-12-12 12:30:00 | QQQ | ETF | 85.01 | 85.11 | 84.9 | 85.055 | 1691190.0 |
> showing 50 of 11,216 rows — these rows as CSV