PREVIEW / etf_30min / 2016-02-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-12.parquet
  size:    406 KB
  rows:    13,685

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-12 04:00:00	SPY	ETF	184.35	184.85	184.1	184.54	27893.0
2016-02-12 04:30:00	SPY	ETF	184.61	184.77	184.23	184.54	18862.0
2016-02-12 05:00:00	SPY	ETF	184.61	184.87	184.41	184.6	29900.0
2016-02-12 05:30:00	SPY	ETF	184.62	184.62	184.33	184.39	20387.0
2016-02-12 06:00:00	SPY	ETF	184.35	184.66	184.35	184.61	14261.0
2016-02-12 06:30:00	SPY	ETF	184.66	185.35	184.64	185.17	181626.0
2016-02-12 07:00:00	SPY	ETF	185.17	185.17	184.77	184.9	223492.0
2016-02-12 07:30:00	SPY	ETF	184.92	185.05	184.61	184.73	152271.0
2016-02-12 08:00:00	SPY	ETF	184.73	185.12	182.86	184.61	754383.0
2016-02-12 08:30:00	SPY	ETF	184.59	185.43	184.55	185.02	1359730.0
2016-02-12 09:00:00	SPY	ETF	185.04	185.15	184.67	184.98	1346101.0
2016-02-12 09:30:00	SPY	ETF	184.96	185.15	184.13	184.29	15646511.0
2016-02-12 10:00:00	SPY	ETF	184.3	185.02	183.96	184.82	13099568.0
2016-02-12 10:30:00	SPY	ETF	184.82	185.13	184.6	184.74	7203255.0
2016-02-12 11:00:00	SPY	ETF	184.74	185.96	184.74	185.8801	10643887.0
2016-02-12 11:30:00	SPY	ETF	185.89	186.13	185.53	185.62	8431069.0
2016-02-12 12:00:00	SPY	ETF	185.62	185.98	185.53	185.85	4956478.0
2016-02-12 12:30:00	SPY	ETF	185.86	185.99	185.67	185.69	4136098.0
2016-02-12 13:00:00	SPY	ETF	185.68	185.87	185.16	185.39	5944519.0
2016-02-12 13:30:00	SPY	ETF	185.38	185.66	185.29	185.45	4326583.0
2016-02-12 14:00:00	SPY	ETF	185.46	186.2	185.39	186.0836	6305749.0
2016-02-12 14:30:00	SPY	ETF	186.0872	186.35	185.91	186.1858	5803146.0
2016-02-12 15:00:00	SPY	ETF	186.18	186.62	186.06	186.6	8859952.0
2016-02-12 15:30:00	SPY	ETF	186.6	186.65	186.03	186.64	15352076.0
2016-02-12 16:00:00	SPY	ETF	186.65	186.65	185.35	186.42	7896438.0
2016-02-12 16:30:00	SPY	ETF	186.45	186.65	186.43	186.56	315968.0
2016-02-12 17:00:00	SPY	ETF	186.54	186.57	186.45	186.51	114233.0
2016-02-12 17:30:00	SPY	ETF	186.5	186.56	186.5	186.55	38469.0
2016-02-12 18:00:00	SPY	ETF	186.55	186.59	186.5	186.5	18845.0
2016-02-12 18:30:00	SPY	ETF	186.51	186.55	186.51	186.55	1510.0
2016-02-12 19:00:00	SPY	ETF	186.58	186.61	186.53	186.54	7740.0
2016-02-12 19:30:00	SPY	ETF	186.6	186.75	186.6	186.74	41074.0
2016-02-12 04:00:00	QQQ	ETF	97.4	97.7	97.36	97.59	1872.0
2016-02-12 04:30:00	QQQ	ETF	97.62	97.62	97.5	97.57	6500.0
2016-02-12 05:00:00	QQQ	ETF	97.62	97.62	97.54	97.54	2200.0
2016-02-12 05:30:00	QQQ	ETF	97.55	97.55	97.48	97.48	5100.0
2016-02-12 06:00:00	QQQ	ETF	97.45	97.59	97.45	97.59	3865.0
2016-02-12 06:30:00	QQQ	ETF	97.59	97.9	97.59	97.88	14990.0
2016-02-12 07:00:00	QQQ	ETF	97.8	97.8	97.61	97.65	12593.0
2016-02-12 07:30:00	QQQ	ETF	97.69	97.72	97.5	97.59	16050.0
2016-02-12 08:00:00	QQQ	ETF	97.52	97.57	96.55	97.5	58572.0
2016-02-12 08:30:00	QQQ	ETF	97.54	97.94	97.54	97.68	141788.0
2016-02-12 09:00:00	QQQ	ETF	97.65	97.79	97.49	97.69	394756.0
2016-02-12 09:30:00	QQQ	ETF	97.68	97.79	96.79	96.8599	5267160.0
2016-02-12 10:00:00	QQQ	ETF	96.83	97.31	96.73	97.1732	3124142.0
2016-02-12 10:30:00	QQQ	ETF	97.18	97.4	96.962	97.05	2222263.0
2016-02-12 11:00:00	QQQ	ETF	97.06	97.97	97.06	97.93	3407129.0
2016-02-12 11:30:00	QQQ	ETF	97.93	98.06	97.57	97.64	3129558.0
2016-02-12 12:00:00	QQQ	ETF	97.65	97.86	97.59	97.78	2123442.0
2016-02-12 12:30:00	QQQ	ETF	97.79	97.872	97.61	97.61	1211046.0

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

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