PREVIEW / etf_30min / 2016-04-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-29.parquet
  size:    402 KB
  rows:    13,537

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-04-29 04:00:00	SPY	ETF	207.4	207.55	207.34	207.55	4540.0
2016-04-29 04:30:00	SPY	ETF	207.58	207.58	207.44	207.44	3311.0
2016-04-29 05:00:00	SPY	ETF	207.49	207.81	207.49	207.74	3909.0
2016-04-29 05:30:00	SPY	ETF	207.73	207.89	207.69	207.69	7064.0
2016-04-29 06:00:00	SPY	ETF	207.77	207.78	207.43	207.44	16890.0
2016-04-29 06:30:00	SPY	ETF	207.4	207.49	207.29	207.45	42138.0
2016-04-29 07:00:00	SPY	ETF	207.39	207.54	207.37	207.37	78311.0
2016-04-29 07:30:00	SPY	ETF	207.39	207.44	207.3	207.37	70840.0
2016-04-29 08:00:00	SPY	ETF	207.39	207.71	207.27	207.45	563995.0
2016-04-29 08:30:00	SPY	ETF	207.45	207.49	206.8	206.96	650799.0
2016-04-29 09:00:00	SPY	ETF	206.96	207.08	206.62	206.71	593724.0
2016-04-29 09:30:00	SPY	ETF	206.72	207.13	206.1	206.12	12021215.0
2016-04-29 10:00:00	SPY	ETF	206.11	206.5	205.82	206.35	8932138.0
2016-04-29 10:30:00	SPY	ETF	206.35	206.78	205.84	205.98	8211614.0
2016-04-29 11:00:00	SPY	ETF	205.98	206.21	205.55	205.5525	6993141.0
2016-04-29 11:30:00	SPY	ETF	205.56	205.61	205.06	205.52	9243454.0
2016-04-29 12:00:00	SPY	ETF	205.52	205.72	205.2	205.64	6087836.0
2016-04-29 12:30:00	SPY	ETF	205.63	206.0	205.53	205.665	6343659.0
2016-04-29 13:00:00	SPY	ETF	205.66	206.2	205.63	206.007	4854978.0
2016-04-29 13:30:00	SPY	ETF	206.015	206.05	205.3	205.35	7223142.0
2016-04-29 14:00:00	SPY	ETF	205.35	205.63	205.03	205.54	6502526.0
2016-04-29 14:30:00	SPY	ETF	205.54	205.58	205.18	205.269	5991787.0
2016-04-29 15:00:00	SPY	ETF	205.2675	206.0	205.23	205.675	10763951.0
2016-04-29 15:30:00	SPY	ETF	205.68	206.81	205.675	206.33	26563275.0
2016-04-29 16:00:00	SPY	ETF	206.33	206.67	206.21	206.5	16099549.0
2016-04-29 16:30:00	SPY	ETF	206.51	206.56	206.45	206.49	592510.0
2016-04-29 17:00:00	SPY	ETF	206.48	206.48	206.15	206.24	296808.0
2016-04-29 17:30:00	SPY	ETF	206.23	206.36	206.22	206.32	1555112.0
2016-04-29 18:00:00	SPY	ETF	206.3	206.3	206.27	206.3	10721.0
2016-04-29 18:30:00	SPY	ETF	206.3	206.33	206.3	206.33	9771.0
2016-04-29 19:00:00	SPY	ETF	206.33	206.34	206.31	206.31	5388.0
2016-04-29 19:30:00	SPY	ETF	206.34	206.34	206.25	206.28	16752.0
2016-04-29 04:00:00	QQQ	ETF	106.77	106.77	106.61	106.66	1250.0
2016-04-29 04:30:00	QQQ	ETF	106.72	106.72	106.7	106.7	300.0
2016-04-29 05:00:00	QQQ	ETF	106.89	106.89	106.89	106.89	100.0
2016-04-29 05:30:00	QQQ	ETF	106.95	106.95	106.95	106.95	2000.0
2016-04-29 06:00:00	QQQ	ETF	106.74	106.74	106.7	106.7	500.0
2016-04-29 06:30:00	QQQ	ETF	106.69	106.71	106.64	106.71	1100.0
2016-04-29 07:00:00	QQQ	ETF	106.72	106.73	106.61	106.61	6799.0
2016-04-29 07:30:00	QQQ	ETF	106.6	106.64	106.53	106.58	48740.0
2016-04-29 08:00:00	QQQ	ETF	106.7	106.72	106.54	106.59	58172.0
2016-04-29 08:30:00	QQQ	ETF	106.6	106.64	106.32	106.38	113680.0
2016-04-29 09:00:00	QQQ	ETF	106.45	106.49	106.21	106.21	228524.0
2016-04-29 09:30:00	QQQ	ETF	106.22	106.495	105.63	105.71	5816362.0
2016-04-29 10:00:00	QQQ	ETF	105.7	105.92	105.46	105.65	4054360.0
2016-04-29 10:30:00	QQQ	ETF	105.64	105.98	105.39	105.51	4149803.0
2016-04-29 11:00:00	QQQ	ETF	105.51	105.62	105.12	105.1301	3397685.0
2016-04-29 11:30:00	QQQ	ETF	105.14	105.28	104.88	105.21	3725439.0
2016-04-29 12:00:00	QQQ	ETF	105.21	105.44	105.06	105.37	2127311.0
2016-04-29 12:30:00	QQQ	ETF	105.38	105.644	105.32	105.48	1906035.0

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

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