PREVIEW / etf_30min / 2016-02-16

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-16.parquet
  size:    410 KB
  rows:    14,023

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-02-16 04:00:00	SPY	ETF	189.47	189.49	188.64	189.22	64938.0
2016-02-16 04:30:00	SPY	ETF	189.24	189.4	188.67	188.68	42732.0
2016-02-16 05:00:00	SPY	ETF	188.82	188.89	188.42	188.67	38152.0
2016-02-16 05:30:00	SPY	ETF	188.58	188.69	188.48	188.5	37037.0
2016-02-16 06:00:00	SPY	ETF	188.68	188.72	188.48	188.51	28133.0
2016-02-16 06:30:00	SPY	ETF	188.6	189.04	188.49	189.04	46880.0
2016-02-16 07:00:00	SPY	ETF	189.04	189.12	188.86	189.04	118873.0
2016-02-16 07:30:00	SPY	ETF	189.05	189.11	188.74	188.75	270372.0
2016-02-16 08:00:00	SPY	ETF	188.75	189.962	188.32	188.47	1991934.0
2016-02-16 08:30:00	SPY	ETF	188.45	188.67	188.13	188.46	628393.0
2016-02-16 09:00:00	SPY	ETF	188.4	188.93	188.36	188.77	771303.0
2016-02-16 09:30:00	SPY	ETF	188.77	189.02	188.15	188.29	14561419.0
2016-02-16 10:00:00	SPY	ETF	188.3	188.53	187.84	188.13	8722868.0
2016-02-16 10:30:00	SPY	ETF	188.14	188.635	187.97	188.07	5743702.0
2016-02-16 11:00:00	SPY	ETF	188.06	188.26	187.63	188.13	7051725.0
2016-02-16 11:30:00	SPY	ETF	188.14	188.94	188.12	188.9	5604902.0
2016-02-16 12:00:00	SPY	ETF	188.89	189.28	188.85	189.08	5508164.0
2016-02-16 12:30:00	SPY	ETF	189.07	189.47	188.85	189.45	5032050.0
2016-02-16 13:00:00	SPY	ETF	189.45	189.73	189.4038	189.48	5986082.0
2016-02-16 13:30:00	SPY	ETF	189.495	189.55	189.29	189.45	4547723.0
2016-02-16 14:00:00	SPY	ETF	189.45	189.72	189.41	189.7	5412736.0
2016-02-16 14:30:00	SPY	ETF	189.7	189.78	189.37	189.425	6128491.0
2016-02-16 15:00:00	SPY	ETF	189.43	189.69	189.17	189.67	6938661.0
2016-02-16 15:30:00	SPY	ETF	189.68	189.77	189.19	189.77	16677602.0
2016-02-16 16:00:00	SPY	ETF	189.76	189.86	186.6965	189.43	9564563.0
2016-02-16 16:30:00	SPY	ETF	189.43	189.81	189.31	189.5	3981107.0
2016-02-16 17:00:00	SPY	ETF	189.48	189.53	189.4	189.48	25515.0
2016-02-16 17:30:00	SPY	ETF	189.78	189.81	189.44	189.45	275528.0
2016-02-16 18:00:00	SPY	ETF	189.43	189.48	189.27	189.33	62376.0
2016-02-16 18:30:00	SPY	ETF	189.35	189.5	189.16	189.5	38961.0
2016-02-16 19:00:00	SPY	ETF	189.53	189.75	189.53	189.72	58463.0
2016-02-16 19:30:00	SPY	ETF	189.73	190.29	189.72	190.22	265769.0
2016-02-16 04:00:00	QQQ	ETF	99.82	99.82	99.5	99.82	8808.0
2016-02-16 04:30:00	QQQ	ETF	99.9	99.91	99.46	99.46	4800.0
2016-02-16 05:00:00	QQQ	ETF	99.53	99.53	99.31	99.47	2100.0
2016-02-16 05:30:00	QQQ	ETF	99.32	99.35	99.32	99.35	2200.0
2016-02-16 06:00:00	QQQ	ETF	99.46	99.48	99.3	99.48	5455.0
2016-02-16 06:30:00	QQQ	ETF	99.38	99.56	99.38	99.56	1600.0
2016-02-16 07:00:00	QQQ	ETF	99.59	99.61	99.52	99.6	37026.0
2016-02-16 07:30:00	QQQ	ETF	99.6	99.62	99.41	99.43	29139.0
2016-02-16 08:00:00	QQQ	ETF	99.41	100.17	99.23	99.33	1108466.0
2016-02-16 08:30:00	QQQ	ETF	99.33	99.39	99.1	99.28	69108.0
2016-02-16 09:00:00	QQQ	ETF	99.3	99.55	99.24	99.44	148106.0
2016-02-16 09:30:00	QQQ	ETF	99.44	99.95	99.42	99.57	6147398.0
2016-02-16 10:00:00	QQQ	ETF	99.55	99.7	99.21	99.32	2988059.0
2016-02-16 10:30:00	QQQ	ETF	99.33	99.64	99.15	99.21	1676197.0
2016-02-16 11:00:00	QQQ	ETF	99.21	99.33	98.85	99.12	2108435.0
2016-02-16 11:30:00	QQQ	ETF	99.13	99.63	99.13	99.609	1291786.0
2016-02-16 12:00:00	QQQ	ETF	99.61	99.8	99.56	99.66	1971128.0
2016-02-16 12:30:00	QQQ	ETF	99.66	99.87	99.49	99.85	1343400.0

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

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