PREVIEW / etf_30min / 2014-11-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-17.parquet
  size:    355 KB
  rows:    12,058

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
2014-11-17 04:00:00	SPY	ETF	203.89	203.89	203.41	203.5	8901.0
2014-11-17 04:30:00	SPY	ETF	203.43	203.51	203.32	203.48	13354.0
2014-11-17 05:00:00	SPY	ETF	203.52	203.74	203.48	203.74	10911.0
2014-11-17 05:30:00	SPY	ETF	203.71	203.85	203.71	203.74	6265.0
2014-11-17 06:00:00	SPY	ETF	203.74	203.81	203.66	203.81	43930.0
2014-11-17 06:30:00	SPY	ETF	203.81	203.88	203.69	203.77	224285.0
2014-11-17 07:00:00	SPY	ETF	203.72	203.82	203.63	203.73	130504.0
2014-11-17 07:30:00	SPY	ETF	203.8	203.93	203.75	203.85	77508.0
2014-11-17 08:00:00	SPY	ETF	203.85	203.92	203.46	203.8	296463.0
2014-11-17 08:30:00	SPY	ETF	203.81	204.24	203.65	203.91	372584.0
2014-11-17 09:00:00	SPY	ETF	203.9	203.94	203.69	203.83	2204634.0
2014-11-17 09:30:00	SPY	ETF	203.85	204.13	203.74	204.03	8882674.0
2014-11-17 10:00:00	SPY	ETF	204.03	204.49	203.85	204.35	8506887.0
2014-11-17 10:30:00	SPY	ETF	204.36	204.39	203.96	204.26	5176630.0
2014-11-17 11:00:00	SPY	ETF	204.265	204.28	203.78	203.78	4564567.0
2014-11-17 11:30:00	SPY	ETF	203.79	203.9775	203.65	203.94	3353901.0
2014-11-17 12:00:00	SPY	ETF	203.93	204.21	203.81	204.155	2355352.0
2014-11-17 12:30:00	SPY	ETF	204.15	204.39	204.1101	204.21	2804240.0
2014-11-17 13:00:00	SPY	ETF	204.219	204.58	204.2	204.48	4432112.0
2014-11-17 13:30:00	SPY	ETF	204.47	204.52	204.2275	204.412	2818718.0
2014-11-17 14:00:00	SPY	ETF	204.41	204.485	204.33	204.385	2082327.0
2014-11-17 14:30:00	SPY	ETF	204.38	204.54	204.35	204.45	2562172.0
2014-11-17 15:00:00	SPY	ETF	204.45	204.5	204.27	204.365	3974136.0
2014-11-17 15:30:00	SPY	ETF	204.369	204.46	204.23	204.38	7808504.0
2014-11-17 16:00:00	SPY	ETF	204.39	204.5	204.04	204.47	13220362.0
2014-11-17 16:30:00	SPY	ETF	204.47	204.51	204.37	204.47	3588265.0
2014-11-17 17:00:00	SPY	ETF	204.48	204.5	204.4	204.42	35975.0
2014-11-17 17:30:00	SPY	ETF	204.43	204.44	204.42	204.44	2330.0
2014-11-17 18:00:00	SPY	ETF	204.44	204.44	204.37	204.37	33700.0
2014-11-17 18:30:00	SPY	ETF	204.4	204.41	204.37	204.4	7835.0
2014-11-17 19:00:00	SPY	ETF	204.41	204.46	204.39	204.45	4895.0
2014-11-17 19:30:00	SPY	ETF	204.43	204.44	204.41	204.42	18907.0
2014-11-17 04:00:00	QQQ	ETF	102.83	102.95	102.77	102.77	9100.0
2014-11-17 04:30:00	QQQ	ETF	102.66	102.81	102.66	102.72	900.0
2014-11-17 05:00:00	QQQ	ETF	102.8	102.81	102.8	102.81	800.0
2014-11-17 05:30:00	QQQ	ETF	102.95	102.97	102.91	102.91	15850.0
2014-11-17 06:00:00	QQQ	ETF	102.9	102.92	102.88	102.92	6762.0
2014-11-17 06:30:00	QQQ	ETF	103.0	103.0	102.94	102.94	2885.0
2014-11-17 07:00:00	QQQ	ETF	102.96	102.96	102.88	102.94	19295.0
2014-11-17 07:30:00	QQQ	ETF	102.95	103.05	102.95	103.03	71525.0
2014-11-17 08:00:00	QQQ	ETF	103.01	103.06	102.95	103.01	66514.0
2014-11-17 08:30:00	QQQ	ETF	103.01	103.06	102.87	103.03	81236.0
2014-11-17 09:00:00	QQQ	ETF	103.01	103.01	102.92	102.96	82548.0
2014-11-17 09:30:00	QQQ	ETF	102.97	103.17	102.881	103.125	2932453.0
2014-11-17 10:00:00	QQQ	ETF	103.13	103.21	102.88	103.04	1554386.0
2014-11-17 10:30:00	QQQ	ETF	103.05	103.07	102.73	102.901	1698034.0
2014-11-17 11:00:00	QQQ	ETF	102.9	102.919	102.46	102.48	2152762.0
2014-11-17 11:30:00	QQQ	ETF	102.48	102.69	102.42	102.6767	1537446.0
2014-11-17 12:00:00	QQQ	ETF	102.67	102.85	102.58	102.82	896233.0
2014-11-17 12:30:00	QQQ	ETF	102.811	103.02	102.75	102.8	892579.0

> showing 50 of 12,058 rows — these rows as CSV

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