PREVIEW / etf_30min / 2017-07-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-10.parquet
  size:    421 KB
  rows:    14,790

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-07-10 04:00:00	SPY	ETF	242.41	242.44	242.32	242.42	1500.0
2017-07-10 04:30:00	SPY	ETF	242.48	242.53	242.48	242.5	8859.0
2017-07-10 05:00:00	SPY	ETF	242.41	242.41	242.32	242.32	1707.0
2017-07-10 05:30:00	SPY	ETF	242.31	242.31	242.31	242.31	6001.0
2017-07-10 06:00:00	SPY	ETF	242.4	242.48	242.38	242.48	14384.0
2017-07-10 06:30:00	SPY	ETF	242.44	242.47	242.36	242.36	9693.0
2017-07-10 07:00:00	SPY	ETF	242.35	242.36	242.13	242.2	20969.0
2017-07-10 07:30:00	SPY	ETF	242.14	242.22	242.1	242.16	10857.0
2017-07-10 08:00:00	SPY	ETF	242.16	242.25	242.13	242.19	50014.0
2017-07-10 08:30:00	SPY	ETF	242.17	242.17	242.04	242.04	91187.0
2017-07-10 09:00:00	SPY	ETF	242.04	242.04	241.85	241.95	1695497.0
2017-07-10 09:30:00	SPY	ETF	241.95	242.22	241.76	241.85	4121621.0
2017-07-10 10:00:00	SPY	ETF	241.85	242.25	241.83	242.17	3073275.0
2017-07-10 10:30:00	SPY	ETF	242.17	242.46	242.03	242.455	2240148.0
2017-07-10 11:00:00	SPY	ETF	242.45	242.5699	242.375	242.39	2200829.0
2017-07-10 11:30:00	SPY	ETF	242.39	242.55	242.37	242.54	1520592.0
2017-07-10 12:00:00	SPY	ETF	242.54	242.68	242.51	242.6	2035651.0
2017-07-10 12:30:00	SPY	ETF	242.6	242.66	242.53	242.66	1090636.0
2017-07-10 13:00:00	SPY	ETF	242.66	242.72	242.59	242.63	1506014.0
2017-07-10 13:30:00	SPY	ETF	242.63	242.74	242.56	242.71	1185906.0
2017-07-10 14:00:00	SPY	ETF	242.705	242.73	242.58	242.58	1004748.0
2017-07-10 14:30:00	SPY	ETF	242.58	242.64	242.54	242.5501	1453432.0
2017-07-10 15:00:00	SPY	ETF	242.56	242.63	242.44	242.5505	1726363.0
2017-07-10 15:30:00	SPY	ETF	242.55	242.8	242.35	242.36	7882326.0
2017-07-10 16:00:00	SPY	ETF	242.36	242.4	242.26	242.29	2355631.0
2017-07-10 16:30:00	SPY	ETF	242.29	242.37	242.21	242.22	523560.0
2017-07-10 17:00:00	SPY	ETF	242.23	242.24	242.18	242.21	16220.0
2017-07-10 17:30:00	SPY	ETF	242.23	242.25	242.19	242.22	40459.0
2017-07-10 18:00:00	SPY	ETF	242.21	242.21	242.08	242.19	65594.0
2017-07-10 18:30:00	SPY	ETF	242.18	242.22	242.18	242.22	4168.0
2017-07-10 19:00:00	SPY	ETF	242.21	242.22	242.2	242.21	6378.0
2017-07-10 19:30:00	SPY	ETF	242.22	242.25	242.21	242.25	22482.0
2017-07-10 04:00:00	QQQ	ETF	138.18	138.29	138.15	138.15	3400.0
2017-07-10 04:30:00	QQQ	ETF	138.19	138.21	138.16	138.18	6300.0
2017-07-10 05:00:00	QQQ	ETF	138.11	138.11	138.1	138.1	2143.0
2017-07-10 05:30:00	QQQ	ETF	138.02	138.06	138.02	138.06	2899.0
2017-07-10 06:00:00	QQQ	ETF	138.11	138.2	138.11	138.2	1674.0
2017-07-10 06:30:00	QQQ	ETF	138.18	138.19	138.16	138.16	12848.0
2017-07-10 07:00:00	QQQ	ETF	138.15	138.15	137.94	137.97	12667.0
2017-07-10 07:30:00	QQQ	ETF	137.91	137.99	137.82	137.97	116619.0
2017-07-10 08:00:00	QQQ	ETF	137.88	138.1	137.88	138.0	54270.0
2017-07-10 08:30:00	QQQ	ETF	138.0	138.0	137.74	137.78	77683.0
2017-07-10 09:00:00	QQQ	ETF	137.77	137.85	137.67	137.85	103351.0
2017-07-10 09:30:00	QQQ	ETF	137.84	138.26	137.5	137.61	3480345.0
2017-07-10 10:00:00	QQQ	ETF	137.61	138.07	137.57	137.985	1555356.0
2017-07-10 10:30:00	QQQ	ETF	137.985	138.36	137.88	138.34	1711713.0
2017-07-10 11:00:00	QQQ	ETF	138.345	138.42	138.245	138.275	1529472.0
2017-07-10 11:30:00	QQQ	ETF	138.2755	138.42	138.26	138.401	647697.0
2017-07-10 12:00:00	QQQ	ETF	138.405	138.58	138.4	138.51	1082975.0
2017-07-10 12:30:00	QQQ	ETF	138.515	138.55	138.425	138.54	535579.0

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

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