PREVIEW / etf_30min / 2016-09-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-12.parquet
  size:    421 KB
  rows:    14,271

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-09-12 04:00:00	SPY	ETF	211.7	211.76	211.52	211.52	36217.0
2016-09-12 04:30:00	SPY	ETF	211.5	211.61	211.3	211.59	77532.0
2016-09-12 05:00:00	SPY	ETF	211.59	211.83	211.59	211.76	26812.0
2016-09-12 05:30:00	SPY	ETF	211.72	211.83	211.45	211.49	27953.0
2016-09-12 06:00:00	SPY	ETF	211.52	211.54	211.36	211.54	32783.0
2016-09-12 06:30:00	SPY	ETF	211.44	211.64	211.39	211.6	45299.0
2016-09-12 07:00:00	SPY	ETF	211.6	211.72	211.41	211.54	465927.0
2016-09-12 07:30:00	SPY	ETF	211.51	212.21	211.49	212.11	767009.0
2016-09-12 08:00:00	SPY	ETF	212.11	212.5	211.45	212.37	813494.0
2016-09-12 08:30:00	SPY	ETF	212.37	212.65	212.25	212.48	677990.0
2016-09-12 09:00:00	SPY	ETF	212.47	212.64	212.38	212.38	643023.0
2016-09-12 09:30:00	SPY	ETF	212.39	213.66	212.31	213.46	23173161.0
2016-09-12 10:00:00	SPY	ETF	213.45	214.13	213.3865	214.09	10630451.0
2016-09-12 10:30:00	SPY	ETF	214.095	214.19	213.545	213.95	7540275.0
2016-09-12 11:00:00	SPY	ETF	213.94	214.28	213.87	214.18	7547289.0
2016-09-12 11:30:00	SPY	ETF	214.17	214.61	213.91	214.45	6793952.0
2016-09-12 12:00:00	SPY	ETF	214.4489	214.48	214.22	214.45	5118041.0
2016-09-12 12:30:00	SPY	ETF	214.45	215.03	214.44	214.95	7862968.0
2016-09-12 13:00:00	SPY	ETF	214.96	215.58	214.39	214.49	14535475.0
2016-09-12 13:30:00	SPY	ETF	214.5	215.6	214.3	215.5052	9393535.0
2016-09-12 14:00:00	SPY	ETF	215.5	216.3	215.44	216.04	15279974.0
2016-09-12 14:30:00	SPY	ETF	216.04	216.62	216.01	216.31	12666319.0
2016-09-12 15:00:00	SPY	ETF	216.31	216.6	216.18	216.45	8939401.0
2016-09-12 15:30:00	SPY	ETF	216.44	216.81	216.21	216.34	25110401.0
2016-09-12 16:00:00	SPY	ETF	216.34	216.64	215.05	216.32	5598302.0
2016-09-12 16:30:00	SPY	ETF	216.32	216.4	216.24	216.37	392586.0
2016-09-12 17:00:00	SPY	ETF	216.36	216.42	216.33	216.37	197286.0
2016-09-12 17:30:00	SPY	ETF	216.37	216.39	216.22	216.27	118353.0
2016-09-12 18:00:00	SPY	ETF	216.27	216.31	215.96	216.14	273300.0
2016-09-12 18:30:00	SPY	ETF	216.12	216.18	216.08	216.11	34872.0
2016-09-12 19:00:00	SPY	ETF	216.11	216.16	216.1	216.13	17916.0
2016-09-12 19:30:00	SPY	ETF	216.2	216.24	216.17	216.17	31815.0
2016-09-12 04:00:00	QQQ	ETF	113.6	113.6	113.26	113.35	1228.0
2016-09-12 04:30:00	QQQ	ETF	113.12	113.18	113.08	113.18	21397.0
2016-09-12 05:00:00	QQQ	ETF	113.29	113.29	113.29	113.29	300.0
2016-09-12 05:30:00	QQQ	ETF	113.25	113.28	113.21	113.22	2700.0
2016-09-12 06:00:00	QQQ	ETF	113.13	113.13	113.09	113.13	499.0
2016-09-12 06:30:00	QQQ	ETF	113.11	113.19	113.08	113.17	10985.0
2016-09-12 07:00:00	QQQ	ETF	113.13	113.24	113.09	113.15	91248.0
2016-09-12 07:30:00	QQQ	ETF	113.12	113.52	113.12	113.48	370602.0
2016-09-12 08:00:00	QQQ	ETF	113.48	113.67	113.14	113.61	132409.0
2016-09-12 08:30:00	QQQ	ETF	113.64	113.81	113.59	113.72	128458.0
2016-09-12 09:00:00	QQQ	ETF	113.74	113.83	113.66	113.67	113736.0
2016-09-12 09:30:00	QQQ	ETF	113.64	114.71	113.63	114.65	6062323.0
2016-09-12 10:00:00	QQQ	ETF	114.63	115.09	114.63	115.05	2784312.0
2016-09-12 10:30:00	QQQ	ETF	115.05	115.14	114.85	115.115	2441361.0
2016-09-12 11:00:00	QQQ	ETF	115.11	115.38	115.11	115.346	2543195.0
2016-09-12 11:30:00	QQQ	ETF	115.33	115.52	115.15	115.41	1300216.0
2016-09-12 12:00:00	QQQ	ETF	115.41	115.41	115.23	115.35	1371845.0
2016-09-12 12:30:00	QQQ	ETF	115.36	115.69	115.28	115.62	1526473.0

> showing 50 of 14,271 rows — these rows as CSV

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