PREVIEW / etf_30min / 2016-05-16

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-16.parquet
  size:    392 KB
  rows:    13,358

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-16 04:00:00	SPY	ETF	204.99	205.09	204.92	204.93	3933.0
2016-05-16 04:30:00	SPY	ETF	204.96	205.1	204.95	205.1	10044.0
2016-05-16 05:00:00	SPY	ETF	205.12	205.12	205.0	205.12	3707.0
2016-05-16 05:30:00	SPY	ETF	205.12	205.17	205.04	205.07	3912.0
2016-05-16 06:00:00	SPY	ETF	205.12	205.12	204.91	204.91	4866.0
2016-05-16 06:30:00	SPY	ETF	204.87	204.94	204.8	204.87	19204.0
2016-05-16 07:00:00	SPY	ETF	204.91	204.99	204.89	204.96	51022.0
2016-05-16 07:30:00	SPY	ETF	204.99	205.29	204.99	205.17	173403.0
2016-05-16 08:00:00	SPY	ETF	205.17	205.425	204.76	205.09	323591.0
2016-05-16 08:30:00	SPY	ETF	205.05	205.09	204.73	204.88	333179.0
2016-05-16 09:00:00	SPY	ETF	204.9	205.01	204.86	204.99	219026.0
2016-05-16 09:30:00	SPY	ETF	204.96	205.71	204.89	205.49	9740227.0
2016-05-16 10:00:00	SPY	ETF	205.51	205.83	205.42	205.71	5528874.0
2016-05-16 10:30:00	SPY	ETF	205.71	206.15	205.67	206.08	4748641.0
2016-05-16 11:00:00	SPY	ETF	206.08	206.35	206.08	206.26	4150721.0
2016-05-16 11:30:00	SPY	ETF	206.26	206.63	206.2492	206.6265	4622465.0
2016-05-16 12:00:00	SPY	ETF	206.6299	206.665	206.31	206.32	3089338.0
2016-05-16 12:30:00	SPY	ETF	206.32	206.64	206.28	206.58	2603379.0
2016-05-16 13:00:00	SPY	ETF	206.6	206.75	206.54	206.68	2637546.0
2016-05-16 13:30:00	SPY	ETF	206.679	206.73	206.48	206.656	2564806.0
2016-05-16 14:00:00	SPY	ETF	206.655	207.21	206.65	207.18	5129559.0
2016-05-16 14:30:00	SPY	ETF	207.17	207.23	207.08	207.185	4204890.0
2016-05-16 15:00:00	SPY	ETF	207.1899	207.34	207.07	207.085	4876725.0
2016-05-16 15:30:00	SPY	ETF	207.09	207.09	206.71	206.78	10935828.0
2016-05-16 16:00:00	SPY	ETF	206.77	206.91	205.884	206.76	5482310.0
2016-05-16 16:30:00	SPY	ETF	206.76	206.81	206.63	206.69	395916.0
2016-05-16 17:00:00	SPY	ETF	206.7	206.74	206.68	206.73	87802.0
2016-05-16 17:30:00	SPY	ETF	206.72	206.72	206.58	206.68	107823.0
2016-05-16 18:00:00	SPY	ETF	206.69	206.7	206.55	206.69	127558.0
2016-05-16 18:30:00	SPY	ETF	206.68	206.78	206.67	206.68	50850.0
2016-05-16 19:00:00	SPY	ETF	206.68	206.71	206.65	206.71	9651.0
2016-05-16 19:30:00	SPY	ETF	206.71	206.74	206.6	206.6	55657.0
2016-05-16 04:00:00	QQQ	ETF	105.66	105.66	105.55	105.55	300.0
2016-05-16 05:00:00	QQQ	ETF	105.61	105.61	105.61	105.61	100.0
2016-05-16 05:30:00	QQQ	ETF	105.63	105.63	105.63	105.63	150.0
2016-05-16 06:00:00	QQQ	ETF	105.59	105.59	105.5	105.5	500.0
2016-05-16 06:30:00	QQQ	ETF	105.45	105.5	105.45	105.5	1500.0
2016-05-16 07:00:00	QQQ	ETF	105.54	105.56	105.54	105.56	1372.0
2016-05-16 07:30:00	QQQ	ETF	105.61	105.93	105.6	105.87	322469.0
2016-05-16 08:00:00	QQQ	ETF	105.86	105.93	105.67	105.79	47692.0
2016-05-16 08:30:00	QQQ	ETF	105.74	105.74	105.6	105.69	46914.0
2016-05-16 09:00:00	QQQ	ETF	105.69	105.72	105.67	105.68	94950.0
2016-05-16 09:30:00	QQQ	ETF	105.67	106.06	105.56	106.02	2670357.0
2016-05-16 10:00:00	QQQ	ETF	106.03	106.09	105.8	105.96	1673265.0
2016-05-16 10:30:00	QQQ	ETF	105.9767	106.32	105.97	106.29	1179502.0
2016-05-16 11:00:00	QQQ	ETF	106.2899	106.46	106.285	106.4	923031.0
2016-05-16 11:30:00	QQQ	ETF	106.41	106.73	106.41	106.69	1084115.0
2016-05-16 12:00:00	QQQ	ETF	106.69	106.72	106.53	106.54	870788.0
2016-05-16 12:30:00	QQQ	ETF	106.5399	106.705	106.51	106.66	563336.0
2016-05-16 13:00:00	QQQ	ETF	106.67	106.76	106.645	106.749	641152.0

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

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