PREVIEW / etf_30min / 2015-05-11

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-11.parquet
  size:    375 KB
  rows:    12,677

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-05-11 04:00:00	SPY	ETF	211.26	211.4	211.19	211.25	18795.0
2015-05-11 04:30:00	SPY	ETF	211.3	211.3	211.08	211.15	10721.0
2015-05-11 05:00:00	SPY	ETF	211.15	211.26	211.1	211.14	6700.0
2015-05-11 05:30:00	SPY	ETF	211.15	211.24	211.1	211.13	6130.0
2015-05-11 06:00:00	SPY	ETF	211.16	211.25	211.11	211.25	21600.0
2015-05-11 06:30:00	SPY	ETF	211.22	211.3	211.19	211.3	79077.0
2015-05-11 07:00:00	SPY	ETF	211.3	211.35	211.2	211.34	50405.0
2015-05-11 07:30:00	SPY	ETF	211.35	211.55	211.32	211.51	227396.0
2015-05-11 08:00:00	SPY	ETF	211.39	211.54	211.21	211.47	165817.0
2015-05-11 08:30:00	SPY	ETF	211.48	211.48	211.35	211.47	175398.0
2015-05-11 09:00:00	SPY	ETF	211.47	211.57	211.38	211.57	368022.0
2015-05-11 09:30:00	SPY	ETF	211.57	211.85	211.27	211.66	9368325.0
2015-05-11 10:00:00	SPY	ETF	211.67	211.89	211.38	211.38	5399914.0
2015-05-11 10:30:00	SPY	ETF	211.38	211.62	211.11	211.53	5349286.0
2015-05-11 11:00:00	SPY	ETF	211.52	211.68	211.25	211.435	4087714.0
2015-05-11 11:30:00	SPY	ETF	211.43	211.61	211.3	211.54	2734055.0
2015-05-11 12:00:00	SPY	ETF	211.54	211.58	211.03	211.19	4212018.0
2015-05-11 12:30:00	SPY	ETF	211.19	211.29	211.07	211.185	2817061.0
2015-05-11 13:00:00	SPY	ETF	211.185	211.42	211.16	211.35	2001561.0
2015-05-11 13:30:00	SPY	ETF	211.35	211.38	211.13	211.13	2817384.0
2015-05-11 14:00:00	SPY	ETF	211.14	211.25	210.94	211.1	4237155.0
2015-05-11 14:30:00	SPY	ETF	211.09	211.1099	210.68	210.725	4603440.0
2015-05-11 15:00:00	SPY	ETF	210.72	211.08	210.52	210.95	5613760.0
2015-05-11 15:30:00	SPY	ETF	210.96	211.01	210.59	210.61	11903389.0
2015-05-11 16:00:00	SPY	ETF	210.59	211.6634	210.32	210.35	4882374.0
2015-05-11 16:30:00	SPY	ETF	210.35	210.6	210.15	210.28	3143438.0
2015-05-11 17:00:00	SPY	ETF	210.28	210.31	210.23	210.27	139485.0
2015-05-11 17:30:00	SPY	ETF	210.27	210.33	210.26	210.33	62845.0
2015-05-11 18:00:00	SPY	ETF	210.34	210.4	210.28	210.4	37633.0
2015-05-11 18:30:00	SPY	ETF	210.4	210.4	210.38	210.39	4238.0
2015-05-11 19:00:00	SPY	ETF	210.38	210.38	210.31	210.33	13365.0
2015-05-11 19:30:00	SPY	ETF	210.37	210.38	210.22	210.22	158084.0
2015-05-11 06:00:00	QQQ	ETF	108.49	108.54	108.47	108.54	12060.0
2015-05-11 06:30:00	QQQ	ETF	108.57	108.62	108.55	108.62	15300.0
2015-05-11 07:00:00	QQQ	ETF	108.61	108.63	108.54	108.63	5800.0
2015-05-11 07:30:00	QQQ	ETF	108.64	108.74	108.63	108.7	22745.0
2015-05-11 08:00:00	QQQ	ETF	108.7	108.72	108.57	108.7	44040.0
2015-05-11 08:30:00	QQQ	ETF	108.69	108.71	108.63	108.71	23570.0
2015-05-11 09:00:00	QQQ	ETF	108.7	108.77	108.69	108.75	130275.0
2015-05-11 09:30:00	QQQ	ETF	108.76	108.98	108.5	108.75	3553669.0
2015-05-11 10:00:00	QQQ	ETF	108.765	108.9	108.57	108.58	1137840.0
2015-05-11 10:30:00	QQQ	ETF	108.57	108.61	108.34	108.558	1565680.0
2015-05-11 11:00:00	QQQ	ETF	108.565	108.71	108.39	108.577	1255818.0
2015-05-11 11:30:00	QQQ	ETF	108.575	108.72	108.4608	108.7062	834181.0
2015-05-11 12:00:00	QQQ	ETF	108.71	108.745	108.44	108.555	730204.0
2015-05-11 12:30:00	QQQ	ETF	108.555	108.58	108.44	108.53	635037.0
2015-05-11 13:00:00	QQQ	ETF	108.52	108.705	108.49	108.6763	586732.0
2015-05-11 13:30:00	QQQ	ETF	108.68	108.715	108.54	108.54	348080.0
2015-05-11 14:00:00	QQQ	ETF	108.541	108.625	108.41	108.535	827717.0
2015-05-11 14:30:00	QQQ	ETF	108.535	108.58	108.38	108.385	677927.0

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

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