PREVIEW / etf_30min / 2017-06-29

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-29.parquet
  size:    448 KB
  rows:    15,381

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
2017-06-29 04:00:00	SPY	ETF	243.82	243.82	243.77	243.77	8220.0
2017-06-29 04:30:00	SPY	ETF	243.83	243.83	243.82	243.83	1620.0
2017-06-29 05:00:00	SPY	ETF	243.8	243.8	243.76	243.76	1510.0
2017-06-29 05:30:00	SPY	ETF	243.73	243.73	243.59	243.7	9295.0
2017-06-29 06:00:00	SPY	ETF	243.68	243.7	243.58	243.68	14298.0
2017-06-29 06:30:00	SPY	ETF	243.65	243.73	243.59	243.72	17680.0
2017-06-29 07:00:00	SPY	ETF	243.79	243.95	243.69	243.9	161362.0
2017-06-29 07:30:00	SPY	ETF	243.91	244.14	243.91	244.06	90306.0
2017-06-29 08:00:00	SPY	ETF	243.91	244.11	243.67	243.79	326401.0
2017-06-29 08:30:00	SPY	ETF	243.81	243.88	243.54	243.6	279059.0
2017-06-29 09:00:00	SPY	ETF	243.6	243.71	243.51	243.67	436306.0
2017-06-29 09:30:00	SPY	ETF	243.66	243.72	242.77	242.92	8381217.0
2017-06-29 10:00:00	SPY	ETF	242.93	243.02	242.305	242.7099	7171137.0
2017-06-29 10:30:00	SPY	ETF	242.7057	243.03	242.51	242.65	4119584.0
2017-06-29 11:00:00	SPY	ETF	242.66	242.71	241.76	241.9	5536004.0
2017-06-29 11:30:00	SPY	ETF	241.9	241.91	241.31	241.36	7644537.0
2017-06-29 12:00:00	SPY	ETF	241.36	241.79	241.09	241.4499	7784993.0
2017-06-29 12:30:00	SPY	ETF	241.45	241.56	240.98	241.04	5612429.0
2017-06-29 13:00:00	SPY	ETF	241.04	241.29	239.955	240.13	8338645.0
2017-06-29 13:30:00	SPY	ETF	240.13	241.02	240.12	240.87	9317919.0
2017-06-29 14:00:00	SPY	ETF	240.86	241.51	240.58	241.48	6729404.0
2017-06-29 14:30:00	SPY	ETF	241.48	241.5901	241.18	241.42	4422566.0
2017-06-29 15:00:00	SPY	ETF	241.425	241.9	241.33	241.49	6533652.0
2017-06-29 15:30:00	SPY	ETF	241.5	241.98	241.35	241.39	13796991.0
2017-06-29 16:00:00	SPY	ETF	241.39	241.79	241.35	241.72	5383699.0
2017-06-29 16:30:00	SPY	ETF	241.73	241.88	240.7989	241.85	1391245.0
2017-06-29 17:00:00	SPY	ETF	241.8	241.85	241.35	241.73	914195.0
2017-06-29 17:30:00	SPY	ETF	241.73	241.78	241.72	241.74	35844.0
2017-06-29 18:00:00	SPY	ETF	241.75	241.89	241.6	241.63	202474.0
2017-06-29 18:30:00	SPY	ETF	241.61	241.61	241.47	241.47	61764.0
2017-06-29 19:00:00	SPY	ETF	241.49	241.66	241.49	241.59	20892.0
2017-06-29 19:30:00	SPY	ETF	241.6	241.77	241.6	241.68	35859.0
2017-06-29 04:00:00	QQQ	ETF	140.08	140.08	139.9	139.99	12722.0
2017-06-29 04:30:00	QQQ	ETF	140.0	140.05	139.98	140.05	1700.0
2017-06-29 05:00:00	QQQ	ETF	140.05	140.05	139.97	140.01	1500.0
2017-06-29 05:30:00	QQQ	ETF	139.94	139.94	139.83	139.89	1690.0
2017-06-29 06:00:00	QQQ	ETF	139.89	139.89	139.7	139.7	2200.0
2017-06-29 06:30:00	QQQ	ETF	139.73	139.85	139.71	139.82	12400.0
2017-06-29 07:00:00	QQQ	ETF	139.87	140.05	139.87	139.95	10200.0
2017-06-29 07:30:00	QQQ	ETF	139.94	140.0	139.87	139.9	77900.0
2017-06-29 08:00:00	QQQ	ETF	139.92	139.92	139.56	139.62	330254.0
2017-06-29 08:30:00	QQQ	ETF	139.61	139.63	139.29	139.33	300366.0
2017-06-29 09:00:00	QQQ	ETF	139.32	139.49	139.19	139.42	402780.0
2017-06-29 09:30:00	QQQ	ETF	139.4	139.44	138.43	138.6	8052500.0
2017-06-29 10:00:00	QQQ	ETF	138.61	138.75	138.015	138.42	5743242.0
2017-06-29 10:30:00	QQQ	ETF	138.42	138.68	138.22	138.24	4313786.0
2017-06-29 11:00:00	QQQ	ETF	138.24	138.35	137.37	137.52	7468546.0
2017-06-29 11:30:00	QQQ	ETF	137.52	137.72	137.095	137.3	7628011.0
2017-06-29 12:00:00	QQQ	ETF	137.31	137.79	137.15	137.55	4916618.0
2017-06-29 12:30:00	QQQ	ETF	137.55	137.61	136.95	136.98	3563526.0

> showing 50 of 15,381 rows — these rows as CSV

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