PREVIEW / etf_30min / 2015-12-17

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-17.parquet
  size:    399 KB
  rows:    13,319

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-17 04:00:00	SPY	ETF	208.03	208.39	208.02	208.21	34780.0
2015-12-17 04:30:00	SPY	ETF	208.23	208.56	208.23	208.56	25213.0
2015-12-17 05:00:00	SPY	ETF	208.5	208.75	208.4	208.67	116961.0
2015-12-17 05:30:00	SPY	ETF	208.66	208.74	208.57	208.67	27531.0
2015-12-17 06:00:00	SPY	ETF	208.7	208.87	208.56	208.87	25007.0
2015-12-17 06:30:00	SPY	ETF	208.86	208.89	208.59	208.65	62904.0
2015-12-17 07:00:00	SPY	ETF	208.62	208.79	208.56	208.56	237494.0
2015-12-17 07:30:00	SPY	ETF	208.56	208.61	208.36	208.38	239936.0
2015-12-17 08:00:00	SPY	ETF	208.65	208.67	208.15	208.28	299494.0
2015-12-17 08:30:00	SPY	ETF	208.3	208.48	208.13	208.43	269778.0
2015-12-17 09:00:00	SPY	ETF	208.45	208.59	208.37	208.39	533869.0
2015-12-17 09:30:00	SPY	ETF	208.4	208.48	207.17	207.65	16392563.0
2015-12-17 10:00:00	SPY	ETF	207.65	207.66	206.64	207.06	16052404.0
2015-12-17 10:30:00	SPY	ETF	207.065	207.32	205.93	206.3	14761514.0
2015-12-17 11:00:00	SPY	ETF	206.31	206.5	205.44	205.791	11707380.0
2015-12-17 11:30:00	SPY	ETF	205.79	206.4	205.54	206.11	14225551.0
2015-12-17 12:00:00	SPY	ETF	206.1	206.39	205.7	205.9999	7239687.0
2015-12-17 12:30:00	SPY	ETF	205.99	206.18	205.415	205.87	7587743.0
2015-12-17 13:00:00	SPY	ETF	205.87	206.43	205.79	206.18	6497074.0
2015-12-17 13:30:00	SPY	ETF	206.1895	206.67	206.06	206.57	8290703.0
2015-12-17 14:00:00	SPY	ETF	206.58	206.69	206.13	206.31	6608572.0
2015-12-17 14:30:00	SPY	ETF	206.3	206.37	205.72	206.02	8332772.0
2015-12-17 15:00:00	SPY	ETF	206.02	206.19	205.52	205.85	10611350.0
2015-12-17 15:30:00	SPY	ETF	205.85	206.34	204.84	204.89	18996605.0
2015-12-17 16:00:00	SPY	ETF	204.88	205.41	204.07	204.2	9786444.0
2015-12-17 16:30:00	SPY	ETF	204.19	204.3	203.99	204.03	2509425.0
2015-12-17 17:00:00	SPY	ETF	204.03	204.17	204.01	204.11	1363001.0
2015-12-17 17:30:00	SPY	ETF	204.12	204.86	204.08	204.1	153029.0
2015-12-17 18:00:00	SPY	ETF	204.16	204.19	203.96	204.07	93781.0
2015-12-17 18:30:00	SPY	ETF	204.08	204.22	204.02	204.07	123695.0
2015-12-17 19:00:00	SPY	ETF	204.12	204.33	204.12	204.25	116932.0
2015-12-17 19:30:00	SPY	ETF	204.25	204.26	203.24	203.4	268696.0
2015-12-17 20:00:00	SPY	ETF	204.9095	204.9095	204.9095	204.9095	50000.0
2015-12-17 04:00:00	QQQ	ETF	114.1	114.25	113.9	114.11	14500.0
2015-12-17 04:30:00	QQQ	ETF	114.24	114.35	114.24	114.35	11350.0
2015-12-17 05:00:00	QQQ	ETF	114.33	114.37	114.33	114.37	7450.0
2015-12-17 05:30:00	QQQ	ETF	114.35	114.44	114.35	114.44	3600.0
2015-12-17 06:00:00	QQQ	ETF	114.32	114.52	114.32	114.52	4700.0
2015-12-17 06:30:00	QQQ	ETF	114.51	114.51	114.39	114.39	30300.0
2015-12-17 07:00:00	QQQ	ETF	114.43	114.49	114.42	114.44	101775.0
2015-12-17 07:30:00	QQQ	ETF	114.44	114.48	114.4	114.4	55100.0
2015-12-17 08:00:00	QQQ	ETF	114.45	114.46	114.28	114.35	95031.0
2015-12-17 08:30:00	QQQ	ETF	114.37	114.44	114.29	114.44	50125.0
2015-12-17 09:00:00	QQQ	ETF	114.46	114.52	114.45	114.45	103334.0
2015-12-17 09:30:00	QQQ	ETF	114.46	114.48	113.78	114.06	4906655.0
2015-12-17 10:00:00	QQQ	ETF	114.06	114.12	113.6	113.85	5097713.0
2015-12-17 10:30:00	QQQ	ETF	113.8698	113.98	113.03	113.25	3043261.0
2015-12-17 11:00:00	QQQ	ETF	113.25	113.395	112.68	112.94	2888154.0
2015-12-17 11:30:00	QQQ	ETF	112.93	113.32	112.77	113.17	2224741.0
2015-12-17 12:00:00	QQQ	ETF	113.17	113.35	112.91	113.12	1059174.0

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

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