PREVIEW / etf_30min / 2015-11-12

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-12.parquet
  size:    382 KB
  rows:    12,814

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-11-12 04:00:00	SPY	ETF	208.16	208.16	207.62	207.66	16348.0
2015-11-12 04:30:00	SPY	ETF	207.71	207.92	207.71	207.92	1502.0
2015-11-12 05:00:00	SPY	ETF	207.62	207.62	207.3	207.32	19342.0
2015-11-12 05:30:00	SPY	ETF	207.46	207.57	207.38	207.38	5465.0
2015-11-12 06:00:00	SPY	ETF	207.35	207.45	207.3	207.45	4291.0
2015-11-12 06:30:00	SPY	ETF	207.45	207.8	207.45	207.64	26590.0
2015-11-12 07:00:00	SPY	ETF	207.72	207.72	207.6	207.66	28250.0
2015-11-12 07:30:00	SPY	ETF	207.67	207.74	207.29	207.29	137127.0
2015-11-12 08:00:00	SPY	ETF	207.59	207.67	206.96	207.16	689810.0
2015-11-12 08:30:00	SPY	ETF	207.15	207.22	206.88	207.07	496749.0
2015-11-12 09:00:00	SPY	ETF	207.06	207.1	206.26	206.49	2051760.0
2015-11-12 09:30:00	SPY	ETF	206.5	206.72	206.13	206.525	15270180.0
2015-11-12 10:00:00	SPY	ETF	206.525	206.66	206.08	206.31	10679655.0
2015-11-12 10:30:00	SPY	ETF	206.31	206.94	206.06	206.9	8320386.0
2015-11-12 11:00:00	SPY	ETF	206.91	207.06	206.34	206.39	7498238.0
2015-11-12 11:30:00	SPY	ETF	206.38	206.44	206.1	206.37	6507390.0
2015-11-12 12:00:00	SPY	ETF	206.36	206.47	205.62	205.825	7765325.0
2015-11-12 12:30:00	SPY	ETF	205.82	206.245	205.68	206.1273	6918226.0
2015-11-12 13:00:00	SPY	ETF	206.13	206.48	206.02	206.31	4355794.0
2015-11-12 13:30:00	SPY	ETF	206.309	206.48	205.97	206.24	4220207.0
2015-11-12 14:00:00	SPY	ETF	206.24	206.3	205.76	206.15	4068736.0
2015-11-12 14:30:00	SPY	ETF	206.13	206.16	205.3	205.54	8596888.0
2015-11-12 15:00:00	SPY	ETF	205.54	205.73	205.36	205.6	6562999.0
2015-11-12 15:30:00	SPY	ETF	205.6	205.65	204.82	204.89	19866999.0
2015-11-12 16:00:00	SPY	ETF	204.87	205.4	204.75	204.76	3540846.0
2015-11-12 16:30:00	SPY	ETF	204.77	206.93	204.7	204.77	1948933.0
2015-11-12 17:00:00	SPY	ETF	204.75	204.82	204.68	204.7	83087.0
2015-11-12 17:30:00	SPY	ETF	204.72	207.02	204.69	204.74	122404.0
2015-11-12 18:00:00	SPY	ETF	204.76	204.83	204.57	204.76	136853.0
2015-11-12 18:30:00	SPY	ETF	204.84	205.03	204.78	204.99	63486.0
2015-11-12 19:00:00	SPY	ETF	205.0	205.14	204.97	205.05	45407.0
2015-11-12 19:30:00	SPY	ETF	205.02	205.02	204.89	204.9	24022.0
2015-11-12 04:00:00	QQQ	ETF	113.14	113.14	113.14	113.14	2323.0
2015-11-12 05:00:00	QQQ	ETF	112.97	112.97	112.97	112.97	100.0
2015-11-12 06:00:00	QQQ	ETF	112.95	113.01	112.9	112.96	800.0
2015-11-12 06:30:00	QQQ	ETF	113.0	113.15	112.98	113.15	600.0
2015-11-12 07:00:00	QQQ	ETF	113.12	113.14	113.06	113.09	8900.0
2015-11-12 07:30:00	QQQ	ETF	113.11	113.11	112.92	112.92	14000.0
2015-11-12 08:00:00	QQQ	ETF	112.91	113.04	112.7295	112.81	64470.0
2015-11-12 08:30:00	QQQ	ETF	112.81	112.91	112.71	112.88	43187.0
2015-11-12 09:00:00	QQQ	ETF	112.88	112.88	112.51	112.61	222756.0
2015-11-12 09:30:00	QQQ	ETF	112.65	112.87	112.44	112.87	3350197.0
2015-11-12 10:00:00	QQQ	ETF	112.86	113.08	112.65	112.77	2524853.0
2015-11-12 10:30:00	QQQ	ETF	112.765	113.155	112.65	113.132	2089423.0
2015-11-12 11:00:00	QQQ	ETF	113.13	113.23	112.84	112.89	1791800.0
2015-11-12 11:30:00	QQQ	ETF	112.88	112.925	112.71	112.8906	1791082.0
2015-11-12 12:00:00	QQQ	ETF	112.8901	112.96	112.56	112.7	1587153.0
2015-11-12 12:30:00	QQQ	ETF	112.695	112.91	112.61	112.8322	1079801.0
2015-11-12 13:00:00	QQQ	ETF	112.84	113.02	112.78	112.91	1132783.0
2015-11-12 13:30:00	QQQ	ETF	112.92	112.97	112.71	112.8193	907310.0

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

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