PREVIEW / etf_30min / 2016-02-04

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-04.parquet
  size:    397 KB
  rows:    13,430

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-04 04:00:00	SPY	ETF	191.77	191.96	191.54	191.84	34190.0
2016-02-04 04:30:00	SPY	ETF	191.93	192.42	191.89	192.42	6389.0
2016-02-04 05:00:00	SPY	ETF	192.43	192.52	192.0	192.1	230456.0
2016-02-04 05:30:00	SPY	ETF	192.04	192.32	191.83	192.02	13631.0
2016-02-04 06:00:00	SPY	ETF	191.96	191.99	191.8	191.92	36696.0
2016-02-04 06:30:00	SPY	ETF	191.92	192.08	191.47	191.55	23100.0
2016-02-04 07:00:00	SPY	ETF	191.57	191.86	191.33	191.33	81629.0
2016-02-04 07:30:00	SPY	ETF	191.33	191.4	190.72	190.93	276278.0
2016-02-04 08:00:00	SPY	ETF	190.91	191.8	190.09	190.47	2613167.0
2016-02-04 08:30:00	SPY	ETF	190.5	190.66	189.62	190.08	1322455.0
2016-02-04 09:00:00	SPY	ETF	190.07	191.05	190.03	190.71	2408810.0
2016-02-04 09:30:00	SPY	ETF	190.71	191.37	189.96	191.02	16783117.0
2016-02-04 10:00:00	SPY	ETF	191.02	192.33	190.155	192.2	17294509.0
2016-02-04 10:30:00	SPY	ETF	192.2	192.75	191.96	192.685	10384578.0
2016-02-04 11:00:00	SPY	ETF	192.67	192.7	190.98	191.17	11254108.0
2016-02-04 11:30:00	SPY	ETF	191.17	191.34	190.3	190.64	10646819.0
2016-02-04 12:00:00	SPY	ETF	190.64	191.715	190.5	191.19	7924795.0
2016-02-04 12:30:00	SPY	ETF	191.19	191.86	190.91	191.29	6684889.0
2016-02-04 13:00:00	SPY	ETF	191.3	192.0	191.2	191.63	6489499.0
2016-02-04 13:30:00	SPY	ETF	191.64	191.97	190.87	191.07	5157345.0
2016-02-04 14:00:00	SPY	ETF	191.08	191.17	190.54	190.66	7497656.0
2016-02-04 14:30:00	SPY	ETF	190.6575	191.12	190.36	191.12	6076793.0
2016-02-04 15:00:00	SPY	ETF	191.13	191.4701	190.62	191.035	8183401.0
2016-02-04 15:30:00	SPY	ETF	191.04	191.63	190.81	191.55	10798790.0
2016-02-04 16:00:00	SPY	ETF	191.56	191.61	190.95	191.32	4412591.0
2016-02-04 16:30:00	SPY	ETF	191.32	191.53	191.13	191.13	1881583.0
2016-02-04 17:00:00	SPY	ETF	191.12	191.18	191.01	191.08	149432.0
2016-02-04 17:30:00	SPY	ETF	191.11	191.13	191.03	191.08	68716.0
2016-02-04 18:00:00	SPY	ETF	191.05	191.07	190.76	190.9	91703.0
2016-02-04 18:30:00	SPY	ETF	190.89	190.99	190.85	190.94	26809.0
2016-02-04 19:00:00	SPY	ETF	190.9	191.09	190.81	191.07	30795.0
2016-02-04 19:30:00	SPY	ETF	191.0201	191.06	190.85	190.85	27362.0
2016-02-04 20:00:00	SPY	ETF	191.5132	191.5132	191.5132	191.5132	228000.0
2016-02-04 04:00:00	QQQ	ETF	101.97	102.0	101.88	101.88	310.0
2016-02-04 04:30:00	QQQ	ETF	102.08	102.33	102.08	102.33	3200.0
2016-02-04 05:30:00	QQQ	ETF	102.17	102.39	102.17	102.22	3200.0
2016-02-04 06:00:00	QQQ	ETF	102.21	102.21	102.15	102.21	4300.0
2016-02-04 06:30:00	QQQ	ETF	102.16	102.26	102.01	102.01	1600.0
2016-02-04 07:00:00	QQQ	ETF	101.95	102.09	101.87	101.87	2359.0
2016-02-04 07:30:00	QQQ	ETF	101.84	101.87	101.57	101.61	57900.0
2016-02-04 08:00:00	QQQ	ETF	101.57	101.75	101.08	101.26	89408.0
2016-02-04 08:30:00	QQQ	ETF	101.31	101.38	100.82	101.06	220336.0
2016-02-04 09:00:00	QQQ	ETF	101.07	101.5	101.06	101.35	299388.0
2016-02-04 09:30:00	QQQ	ETF	101.35	101.65	100.44	101.04	8391253.0
2016-02-04 10:00:00	QQQ	ETF	101.02	102.18	100.54	102.17	7330710.0
2016-02-04 10:30:00	QQQ	ETF	102.17	102.455	101.97	102.29	3718807.0
2016-02-04 11:00:00	QQQ	ETF	102.28	102.31	101.14	101.29	2706223.0
2016-02-04 11:30:00	QQQ	ETF	101.28	101.58	100.87	100.96	3148572.0
2016-02-04 12:00:00	QQQ	ETF	101.01	101.65	100.87	101.35	2687107.0
2016-02-04 12:30:00	QQQ	ETF	101.35	101.75	101.13	101.38	1443317.0

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

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