PREVIEW / etf_30min / 2016-02-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-02.parquet
  size:    401 KB
  rows:    13,644

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-02 04:00:00	SPY	ETF	192.25	192.41	192.07	192.29	24220.0
2016-02-02 04:30:00	SPY	ETF	192.15	192.2	191.55	191.96	39581.0
2016-02-02 05:00:00	SPY	ETF	192.03	192.27	191.7	192.24	22706.0
2016-02-02 05:30:00	SPY	ETF	192.24	192.29	192.14	192.18	3541.0
2016-02-02 06:00:00	SPY	ETF	192.17	192.41	192.12	192.38	73076.0
2016-02-02 06:30:00	SPY	ETF	192.32	192.56	192.21	192.21	75325.0
2016-02-02 07:00:00	SPY	ETF	192.23	192.58	192.19	192.38	86435.0
2016-02-02 07:30:00	SPY	ETF	192.45	192.55	192.24	192.55	168150.0
2016-02-02 08:00:00	SPY	ETF	192.58	192.945	191.89	191.98	540707.0
2016-02-02 08:30:00	SPY	ETF	191.98	193.65	191.72	191.81	618177.0
2016-02-02 09:00:00	SPY	ETF	191.8	192.02	191.71	191.96	826108.0
2016-02-02 09:30:00	SPY	ETF	191.96	191.97	190.87	191.19	19069972.0
2016-02-02 10:00:00	SPY	ETF	191.2	191.58	190.75	191.1	16116483.0
2016-02-02 10:30:00	SPY	ETF	191.09	191.355	190.88	191.0	13151210.0
2016-02-02 11:00:00	SPY	ETF	191.0	191.66	190.87	191.385	7450725.0
2016-02-02 11:30:00	SPY	ETF	191.38	191.73	190.94	190.9699	10032454.0
2016-02-02 12:00:00	SPY	ETF	190.96	191.04	190.3	190.69	13823834.0
2016-02-02 12:30:00	SPY	ETF	190.69	191.06	190.51	190.8	8121271.0
2016-02-02 13:00:00	SPY	ETF	190.8	190.89	190.44	190.89	7009951.0
2016-02-02 13:30:00	SPY	ETF	190.8829	190.89	190.06	190.085	8240021.0
2016-02-02 14:00:00	SPY	ETF	190.085	190.44	189.86	189.935	12817258.0
2016-02-02 14:30:00	SPY	ETF	189.94	190.65	189.87	189.98	11753792.0
2016-02-02 15:00:00	SPY	ETF	189.98	190.135	189.54	189.98	13341651.0
2016-02-02 15:30:00	SPY	ETF	189.98	190.54	189.975	190.13	21554366.0
2016-02-02 16:00:00	SPY	ETF	190.13	190.51	190.04	190.31	8361851.0
2016-02-02 16:30:00	SPY	ETF	190.31	190.31	190.07	190.22	3180654.0
2016-02-02 17:00:00	SPY	ETF	190.25	190.27	190.14	190.14	3603404.0
2016-02-02 17:30:00	SPY	ETF	190.15	190.27	190.15	190.15	41919.0
2016-02-02 18:00:00	SPY	ETF	190.13	190.15	189.91	190.12	130033.0
2016-02-02 18:30:00	SPY	ETF	190.15	190.22	190.01	190.01	25689.0
2016-02-02 19:00:00	SPY	ETF	190.06	190.16	189.87	189.91	22435.0
2016-02-02 19:30:00	SPY	ETF	189.88	189.97	189.78	189.95	66789.0
2016-02-02 04:00:00	QQQ	ETF	103.86	103.89	103.8	103.8	15930.0
2016-02-02 04:30:00	QQQ	ETF	103.73	103.73	103.41	103.57	20300.0
2016-02-02 05:00:00	QQQ	ETF	103.61	103.8	103.61	103.78	1300.0
2016-02-02 05:30:00	QQQ	ETF	103.85	103.85	103.77	103.77	500.0
2016-02-02 06:00:00	QQQ	ETF	103.8	103.91	103.78	103.82	2700.0
2016-02-02 06:30:00	QQQ	ETF	103.9	104.12	103.9	104.0	2000.0
2016-02-02 07:00:00	QQQ	ETF	103.96	104.13	103.96	104.05	13100.0
2016-02-02 07:30:00	QQQ	ETF	104.06	104.16	103.95	104.16	21100.0
2016-02-02 08:00:00	QQQ	ETF	104.17	104.2	103.82	103.86	60273.0
2016-02-02 08:30:00	QQQ	ETF	103.86	104.41	103.72	103.77	114116.0
2016-02-02 09:00:00	QQQ	ETF	103.71	103.98	103.71	103.97	201439.0
2016-02-02 09:30:00	QQQ	ETF	103.97	103.97	103.18	103.44	7180576.0
2016-02-02 10:00:00	QQQ	ETF	103.44	103.74	103.32	103.48	3064149.0
2016-02-02 10:30:00	QQQ	ETF	103.48	103.64	103.29	103.4	3039282.0
2016-02-02 11:00:00	QQQ	ETF	103.4	103.65	103.29	103.53	2067932.0
2016-02-02 11:30:00	QQQ	ETF	103.51	103.7	103.18	103.18	1639659.0
2016-02-02 12:00:00	QQQ	ETF	103.18	103.225	102.72	102.9	2485589.0
2016-02-02 12:30:00	QQQ	ETF	102.9	103.19	102.81	103.06	1589053.0

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

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