PREVIEW / etf_30min / 2015-07-10

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-10.parquet
  size:    386 KB
  rows:    13,212

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-07-10 04:00:00	SPY	ETF	206.97	207.2	206.59	206.59	12880.0
2015-07-10 04:30:00	SPY	ETF	206.68	206.85	206.59	206.59	46596.0
2015-07-10 05:00:00	SPY	ETF	206.6	206.91	206.44	206.85	64668.0
2015-07-10 05:30:00	SPY	ETF	206.88	206.91	206.71	206.8	16614.0
2015-07-10 06:00:00	SPY	ETF	206.8	207.05	206.8	207.0	62991.0
2015-07-10 06:30:00	SPY	ETF	207.01	207.26	206.93	207.2	105306.0
2015-07-10 07:00:00	SPY	ETF	207.2	207.4	207.2	207.2	353398.0
2015-07-10 07:30:00	SPY	ETF	207.2	207.22	206.99	207.2	664486.0
2015-07-10 08:00:00	SPY	ETF	206.64	207.3	206.64	207.2	778549.0
2015-07-10 08:30:00	SPY	ETF	207.19	207.43	207.18	207.39	610093.0
2015-07-10 09:00:00	SPY	ETF	207.38	207.41	207.16	207.29	711376.0
2015-07-10 09:30:00	SPY	ETF	207.29	207.49	206.85	206.88	17958413.0
2015-07-10 10:00:00	SPY	ETF	206.87	207.2	206.78	206.965	7396706.0
2015-07-10 10:30:00	SPY	ETF	206.965	207.06	206.49	206.94	7531183.0
2015-07-10 11:00:00	SPY	ETF	206.945	207.44	206.9	207.3	7640408.0
2015-07-10 11:30:00	SPY	ETF	207.29	207.74	207.1	207.57	7914462.0
2015-07-10 12:00:00	SPY	ETF	207.56	207.69	207.52	207.62	3391087.0
2015-07-10 12:30:00	SPY	ETF	207.62	207.63	207.22	207.51	7701514.0
2015-07-10 13:00:00	SPY	ETF	207.51	207.61	207.18	207.35	5935260.0
2015-07-10 13:30:00	SPY	ETF	207.35	207.4669	207.11	207.26	5965942.0
2015-07-10 14:00:00	SPY	ETF	207.26	207.67	207.205	207.54	7909877.0
2015-07-10 14:30:00	SPY	ETF	207.535	207.83	207.52	207.765	8039076.0
2015-07-10 15:00:00	SPY	ETF	207.76	207.98	207.66	207.74	12765693.0
2015-07-10 15:30:00	SPY	ETF	207.74	207.785	207.44	207.46	16583370.0
2015-07-10 16:00:00	SPY	ETF	207.47	207.61	207.25	207.51	6817203.0
2015-07-10 16:30:00	SPY	ETF	207.51	207.57	206.5	207.51	720487.0
2015-07-10 17:00:00	SPY	ETF	207.51	207.65	204.9517	207.55	841134.0
2015-07-10 17:30:00	SPY	ETF	207.52	207.65	207.4	207.49	237281.0
2015-07-10 18:00:00	SPY	ETF	207.48	207.8	207.41	207.8	70444.0
2015-07-10 18:30:00	SPY	ETF	207.8	207.86	207.65	207.747	57362.0
2015-07-10 19:00:00	SPY	ETF	207.7	207.78	207.68	207.74	6048.0
2015-07-10 19:30:00	SPY	ETF	207.71	207.79	207.71	207.79	15261.0
2015-07-10 04:00:00	QQQ	ETF	107.02	107.02	107.02	107.02	500.0
2015-07-10 04:30:00	QQQ	ETF	106.96	106.96	106.95	106.95	6350.0
2015-07-10 05:00:00	QQQ	ETF	106.9	107.01	106.9	107.01	11200.0
2015-07-10 05:30:00	QQQ	ETF	107.09	107.09	107.09	107.09	300.0
2015-07-10 06:00:00	QQQ	ETF	107.14	107.2	107.14	107.15	15598.0
2015-07-10 06:30:00	QQQ	ETF	107.12	107.28	107.12	107.28	19500.0
2015-07-10 07:00:00	QQQ	ETF	107.29	107.37	107.29	107.33	85022.0
2015-07-10 07:30:00	QQQ	ETF	107.33	107.34	107.24	107.31	28864.0
2015-07-10 08:00:00	QQQ	ETF	107.29	107.34	107.25	107.29	54129.0
2015-07-10 08:30:00	QQQ	ETF	107.28	107.38	107.26	107.363	169025.0
2015-07-10 09:00:00	QQQ	ETF	107.36	107.45	107.27	107.44	270529.0
2015-07-10 09:30:00	QQQ	ETF	107.44	107.475	107.19	107.2155	4179433.0
2015-07-10 10:00:00	QQQ	ETF	107.22	107.4	107.21	107.38	2012229.0
2015-07-10 10:30:00	QQQ	ETF	107.38	107.45	107.05	107.37	1520444.0
2015-07-10 11:00:00	QQQ	ETF	107.37	107.71	107.35	107.6	1591452.0
2015-07-10 11:30:00	QQQ	ETF	107.605	107.86	107.5	107.72	1671025.0
2015-07-10 12:00:00	QQQ	ETF	107.73	107.82	107.69	107.76	435875.0
2015-07-10 12:30:00	QQQ	ETF	107.76	107.77	107.56	107.74	856390.0

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

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