PREVIEW / etf_30min / 2016-02-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-19.parquet
  size:    379 KB
  rows:    12,862

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
2016-02-19 04:00:00	SPY	ETF	192.78	192.78	192.53	192.53	13917.0
2016-02-19 04:30:00	SPY	ETF	192.49	192.63	192.44	192.58	5439.0
2016-02-19 05:00:00	SPY	ETF	192.61	192.61	192.29	192.5	12455.0
2016-02-19 05:30:00	SPY	ETF	192.29	192.29	192.0	192.0	2951.0
2016-02-19 06:00:00	SPY	ETF	192.07	192.07	191.75	191.9	14466.0
2016-02-19 06:30:00	SPY	ETF	191.9	191.9	191.22	191.47	83453.0
2016-02-19 07:00:00	SPY	ETF	191.39	191.56	191.34	191.5	96540.0
2016-02-19 07:30:00	SPY	ETF	191.5	191.92	191.5	191.87	473223.0
2016-02-19 08:00:00	SPY	ETF	191.4936	192.2042	191.34	191.65	2074156.0
2016-02-19 08:30:00	SPY	ETF	191.65	191.83	191.02	191.15	1041805.0
2016-02-19 09:00:00	SPY	ETF	191.14	191.18	190.82	191.17	2074845.0
2016-02-19 09:30:00	SPY	ETF	191.17	191.46	190.48	190.96	17116963.0
2016-02-19 10:00:00	SPY	ETF	190.96	191.65	190.45	191.35	15806316.0
2016-02-19 10:30:00	SPY	ETF	191.36	191.79	191.3	191.34	7994568.0
2016-02-19 11:00:00	SPY	ETF	191.33	191.98	191.01	191.92	8742198.0
2016-02-19 11:30:00	SPY	ETF	191.92	192.18	191.655	191.7	6389929.0
2016-02-19 12:00:00	SPY	ETF	191.7	191.84	191.53	191.63	7358851.0
2016-02-19 12:30:00	SPY	ETF	191.63	191.94	191.6	191.7	3322365.0
2016-02-19 13:00:00	SPY	ETF	191.7	191.87	191.55	191.73	3417202.0
2016-02-19 13:30:00	SPY	ETF	191.73	191.89	191.65	191.81	2646251.0
2016-02-19 14:00:00	SPY	ETF	191.81	192.06	191.71	191.81	4074919.0
2016-02-19 14:30:00	SPY	ETF	191.81	191.829	191.4	191.45	4977318.0
2016-02-19 15:00:00	SPY	ETF	191.45	191.91	191.42	191.8738	4740837.0
2016-02-19 15:30:00	SPY	ETF	191.87	192.11	191.745	192.02	15211714.0
2016-02-19 16:00:00	SPY	ETF	192.02	192.08	191.92	191.98	5784710.0
2016-02-19 16:30:00	SPY	ETF	191.98	192.05	191.95	192.01	394347.0
2016-02-19 17:00:00	SPY	ETF	191.99	192.04	191.97	192.0	162618.0
2016-02-19 17:30:00	SPY	ETF	192.0	192.01	191.96	191.97	37946.0
2016-02-19 18:00:00	SPY	ETF	191.96	192.07	191.95	192.07	50317.0
2016-02-19 18:30:00	SPY	ETF	192.05	192.07	192.0	192.0	8717.0
2016-02-19 19:00:00	SPY	ETF	192.02	192.11	192.02	192.11	21213.0
2016-02-19 19:30:00	SPY	ETF	192.1	192.12	192.07	192.08	10673.0
2016-02-19 04:00:00	QQQ	ETF	101.75	101.75	101.75	101.75	183.0
2016-02-19 05:00:00	QQQ	ETF	101.58	101.58	101.55	101.55	500.0
2016-02-19 05:30:00	QQQ	ETF	101.53	101.53	101.37	101.37	1200.0
2016-02-19 06:00:00	QQQ	ETF	101.29	101.29	101.1	101.1	1060.0
2016-02-19 06:30:00	QQQ	ETF	101.2	101.2	100.9	100.9	2874.0
2016-02-19 07:00:00	QQQ	ETF	100.96	101.06	100.93	101.03	22963.0
2016-02-19 07:30:00	QQQ	ETF	101.1	101.25	101.05	101.23	30874.0
2016-02-19 08:00:00	QQQ	ETF	101.23	101.25	101.07	101.12	67683.0
2016-02-19 08:30:00	QQQ	ETF	101.11	101.27	100.83	100.85	121975.0
2016-02-19 09:00:00	QQQ	ETF	100.84	100.93	100.7	100.92	308212.0
2016-02-19 09:30:00	QQQ	ETF	100.91	101.29	100.615	101.08	5184527.0
2016-02-19 10:00:00	QQQ	ETF	101.08	101.65	100.75	101.459	3265441.0
2016-02-19 10:30:00	QQQ	ETF	101.46	101.75	101.38	101.38	1864938.0
2016-02-19 11:00:00	QQQ	ETF	101.37	101.77	101.16	101.72	2860113.0
2016-02-19 11:30:00	QQQ	ETF	101.73	101.94	101.57	101.59	1923341.0
2016-02-19 12:00:00	QQQ	ETF	101.58	101.75	101.54	101.631	938560.0
2016-02-19 12:30:00	QQQ	ETF	101.63	101.79	101.57	101.63	724110.0
2016-02-19 13:00:00	QQQ	ETF	101.63	101.74	101.49	101.61	704040.0

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

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