PREVIEW / etf_30min / 2016-05-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-13.parquet
  size:    389 KB
  rows:    13,174

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-05-13 04:00:00	SPY	ETF	205.84	205.84	205.34	205.57	46731.0
2016-05-13 04:30:00	SPY	ETF	205.6	205.6	205.44	205.57	36985.0
2016-05-13 05:00:00	SPY	ETF	205.47	205.5	205.37	205.47	1693.0
2016-05-13 05:30:00	SPY	ETF	205.49	205.68	205.44	205.55	12186.0
2016-05-13 06:00:00	SPY	ETF	205.53	205.68	205.46	205.67	9676.0
2016-05-13 06:30:00	SPY	ETF	205.7	205.85	205.7	205.85	56429.0
2016-05-13 07:00:00	SPY	ETF	205.9	205.98	205.8	205.92	120342.0
2016-05-13 07:30:00	SPY	ETF	205.94	205.99	205.68	205.7	132366.0
2016-05-13 08:00:00	SPY	ETF	205.68	205.96	205.29	205.83	762794.0
2016-05-13 08:30:00	SPY	ETF	205.85	206.45	205.85	206.1	1130330.0
2016-05-13 09:00:00	SPY	ETF	206.1	206.27	205.87	206.21	565600.0
2016-05-13 09:30:00	SPY	ETF	206.21	206.86	206.12	206.2263	9771075.0
2016-05-13 10:00:00	SPY	ETF	206.23	206.52	205.82	206.09	7264921.0
2016-05-13 10:30:00	SPY	ETF	206.08	206.18	205.67	205.975	7556614.0
2016-05-13 11:00:00	SPY	ETF	205.97	206.755	205.96	206.6611	5802287.0
2016-05-13 11:30:00	SPY	ETF	206.67	206.7199	206.18	206.23	3835730.0
2016-05-13 12:00:00	SPY	ETF	206.22	206.37	206.06	206.27	2838591.0
2016-05-13 12:30:00	SPY	ETF	206.27	206.39	205.76	205.79	2971582.0
2016-05-13 13:00:00	SPY	ETF	205.8	205.97	205.47	205.52	3079300.0
2016-05-13 13:30:00	SPY	ETF	205.51	205.615	204.92	205.12	8087050.0
2016-05-13 14:00:00	SPY	ETF	205.1275	205.28	204.61	204.79	7211210.0
2016-05-13 14:30:00	SPY	ETF	204.79	204.84	204.38	204.78	7365130.0
2016-05-13 15:00:00	SPY	ETF	204.78	204.94	204.57	204.76	8119918.0
2016-05-13 15:30:00	SPY	ETF	204.75	205.026	204.67	204.76	12503766.0
2016-05-13 16:00:00	SPY	ETF	204.77	204.94	204.72	204.86	4905900.0
2016-05-13 16:30:00	SPY	ETF	204.87	204.91	204.78	204.8	682930.0
2016-05-13 17:00:00	SPY	ETF	204.81	204.82	204.64	204.65	111492.0
2016-05-13 17:30:00	SPY	ETF	204.62	204.76	204.52	204.7	87232.0
2016-05-13 18:00:00	SPY	ETF	204.7	204.72	204.67	204.7	4486.0
2016-05-13 18:30:00	SPY	ETF	204.72	204.72	204.63	204.66	13662.0
2016-05-13 19:00:00	SPY	ETF	204.63	204.7	204.62	204.67	12603.0
2016-05-13 19:30:00	SPY	ETF	204.69	204.73	204.67	204.71	14557.0
2016-05-13 04:00:00	QQQ	ETF	105.49	105.49	105.21	105.25	1600.0
2016-05-13 05:00:00	QQQ	ETF	105.3	105.3	105.3	105.3	200.0
2016-05-13 05:30:00	QQQ	ETF	105.43	105.43	105.33	105.33	5098.0
2016-05-13 06:00:00	QQQ	ETF	105.39	105.44	105.36	105.36	4800.0
2016-05-13 06:30:00	QQQ	ETF	105.54	105.57	105.52	105.52	3600.0
2016-05-13 07:00:00	QQQ	ETF	105.57	105.57	105.55	105.55	9200.0
2016-05-13 07:30:00	QQQ	ETF	105.62	105.63	105.44	105.44	27911.0
2016-05-13 08:00:00	QQQ	ETF	105.45	105.56	105.43	105.49	136127.0
2016-05-13 08:30:00	QQQ	ETF	105.55	105.89	105.55	105.79	130188.0
2016-05-13 09:00:00	QQQ	ETF	105.77	105.91	105.67	105.86	75168.0
2016-05-13 09:30:00	QQQ	ETF	105.85	106.35	105.79	106.025	2690265.0
2016-05-13 10:00:00	QQQ	ETF	106.03	106.2999	105.9	105.97	1823667.0
2016-05-13 10:30:00	QQQ	ETF	105.97	106.1	105.77	105.97	1096915.0
2016-05-13 11:00:00	QQQ	ETF	105.96	106.449	105.96	106.39	1637874.0
2016-05-13 11:30:00	QQQ	ETF	106.381	106.402	106.14	106.17	943965.0
2016-05-13 12:00:00	QQQ	ETF	106.165	106.3	106.075	106.24	799772.0
2016-05-13 12:30:00	QQQ	ETF	106.24	106.31	105.84	105.88	753658.0
2016-05-13 13:00:00	QQQ	ETF	105.89	106.05	105.79	105.82	533177.0

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

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