PREVIEW / etf_30min / 2015-12-22

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-22.parquet
  size:    394 KB
  rows:    13,232

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
2015-12-22 04:00:00	SPY	ETF	202.12	202.22	201.77	201.78	27269.0
2015-12-22 04:30:00	SPY	ETF	201.69	201.81	201.25	201.47	125523.0
2015-12-22 05:00:00	SPY	ETF	201.43	201.78	201.43	201.75	6950.0
2015-12-22 05:30:00	SPY	ETF	201.79	202.12	201.7	202.1	15189.0
2015-12-22 06:00:00	SPY	ETF	201.95	202.34	201.95	202.15	13323.0
2015-12-22 06:30:00	SPY	ETF	202.36	202.36	202.0	202.01	20272.0
2015-12-22 07:00:00	SPY	ETF	202.03	202.03	201.76	201.96	92804.0
2015-12-22 07:30:00	SPY	ETF	201.97	202.46	201.9	202.43	259805.0
2015-12-22 08:00:00	SPY	ETF	202.41	202.45	202.19	202.3	214428.0
2015-12-22 08:30:00	SPY	ETF	202.28	202.35	202.09	202.28	214485.0
2015-12-22 09:00:00	SPY	ETF	202.32	202.83	202.32	202.72	708245.0
2015-12-22 09:30:00	SPY	ETF	202.715	202.73	201.65	201.92	12383407.0
2015-12-22 10:00:00	SPY	ETF	201.9289	202.34	201.55	202.22	9447087.0
2015-12-22 10:30:00	SPY	ETF	202.23	202.4	202.0	202.1	4499626.0
2015-12-22 11:00:00	SPY	ETF	202.1	202.4	201.8	201.97	3858304.0
2015-12-22 11:30:00	SPY	ETF	201.97	202.67	201.96	202.48	6164479.0
2015-12-22 12:00:00	SPY	ETF	202.49	202.58	202.13	202.47	3343148.0
2015-12-22 12:30:00	SPY	ETF	202.48	202.95	202.48	202.95	3915038.0
2015-12-22 13:00:00	SPY	ETF	202.95	203.0	202.65	202.9	4712280.0
2015-12-22 13:30:00	SPY	ETF	202.88	203.27	202.69	203.24	5339264.0
2015-12-22 14:00:00	SPY	ETF	203.24	203.39	203.12	203.18	6678006.0
2015-12-22 14:30:00	SPY	ETF	203.18	203.345	203.0601	203.34	6703518.0
2015-12-22 15:00:00	SPY	ETF	203.34	203.85	203.3	203.71	10626087.0
2015-12-22 15:30:00	SPY	ETF	203.7	203.78	202.99	203.51	18454114.0
2015-12-22 16:00:00	SPY	ETF	203.51	204.03	203.39	204.0	5926887.0
2015-12-22 16:30:00	SPY	ETF	204.0	204.0	203.81	203.82	4848757.0
2015-12-22 17:00:00	SPY	ETF	203.82	203.88	203.82	203.88	113239.0
2015-12-22 17:30:00	SPY	ETF	203.88	203.9	203.85	203.85	41446.0
2015-12-22 18:00:00	SPY	ETF	203.81	203.98	203.46	203.85	396326.0
2015-12-22 18:30:00	SPY	ETF	203.85	203.85	203.78	203.81	63720.0
2015-12-22 19:00:00	SPY	ETF	203.82	203.82	203.7	203.71	63289.0
2015-12-22 19:30:00	SPY	ETF	203.7	203.74	203.66	203.72	44250.0
2015-12-22 04:00:00	QQQ	ETF	111.33	111.36	111.15	111.15	8800.0
2015-12-22 04:30:00	QQQ	ETF	111.1	111.1	110.85	110.85	300.0
2015-12-22 05:00:00	QQQ	ETF	110.95	111.0	110.95	110.97	400.0
2015-12-22 05:30:00	QQQ	ETF	111.15	111.15	111.15	111.15	2200.0
2015-12-22 06:00:00	QQQ	ETF	111.3	111.42	111.3	111.42	600.0
2015-12-22 06:30:00	QQQ	ETF	111.33	111.33	111.2	111.2	500.0
2015-12-22 07:00:00	QQQ	ETF	111.15	111.2	111.1	111.19	27426.0
2015-12-22 07:30:00	QQQ	ETF	111.19	111.47	111.16	111.45	88372.0
2015-12-22 08:00:00	QQQ	ETF	111.45	111.46	111.19	111.42	42771.0
2015-12-22 08:30:00	QQQ	ETF	111.37	111.4	111.28	111.33	42422.0
2015-12-22 09:00:00	QQQ	ETF	111.39	111.67	111.39	111.62	104453.0
2015-12-22 09:30:00	QQQ	ETF	111.65	111.66	111.09	111.24	2865032.0
2015-12-22 10:00:00	QQQ	ETF	111.232	111.57	111.11	111.51	1631677.0
2015-12-22 10:30:00	QQQ	ETF	111.52	111.5799	111.21	111.241	1508828.0
2015-12-22 11:00:00	QQQ	ETF	111.2496	111.42	111.05	111.15	968957.0
2015-12-22 11:30:00	QQQ	ETF	111.15	111.53	111.135	111.361	1372243.0
2015-12-22 12:00:00	QQQ	ETF	111.38	111.38	111.0782	111.26	939831.0
2015-12-22 12:30:00	QQQ	ETF	111.26	111.52	111.24	111.5015	1620886.0

> showing 50 of 13,232 rows — these rows as CSV

> unlock the full archive -- $79 one-time