PREVIEW / etf_30min / 2017-06-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-01.parquet
  size:    439 KB
  rows:    14,960

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-01 04:00:00	SPY	ETF	241.64	241.78	241.64	241.75	10513.0
2017-06-01 04:30:00	SPY	ETF	241.78	241.78	241.72	241.75	4945.0
2017-06-01 05:00:00	SPY	ETF	241.74	241.75	241.66	241.71	13345.0
2017-06-01 05:30:00	SPY	ETF	241.7	241.7	241.6	241.6	2300.0
2017-06-01 06:00:00	SPY	ETF	241.65	241.65	241.57	241.63	4320.0
2017-06-01 06:30:00	SPY	ETF	241.64	241.67	241.64	241.65	1300.0
2017-06-01 07:00:00	SPY	ETF	241.65	241.7	241.58	241.61	52345.0
2017-06-01 07:30:00	SPY	ETF	241.61	241.61	241.51	241.56	77716.0
2017-06-01 08:00:00	SPY	ETF	241.51	241.85	241.51	241.83	211189.0
2017-06-01 08:30:00	SPY	ETF	241.81	241.87	241.44	241.85	180928.0
2017-06-01 09:00:00	SPY	ETF	241.86	242.02	241.84	241.96	221141.0
2017-06-01 09:30:00	SPY	ETF	241.97	242.11	241.64	241.96	7530851.0
2017-06-01 10:00:00	SPY	ETF	241.955	242.06	241.76	241.92	5277082.0
2017-06-01 10:30:00	SPY	ETF	241.92	241.93	241.7	241.84	2399730.0
2017-06-01 11:00:00	SPY	ETF	241.84	242.06	241.79	241.9989	2833259.0
2017-06-01 11:30:00	SPY	ETF	241.99	242.35	241.98	242.33	3485782.0
2017-06-01 12:00:00	SPY	ETF	242.335	242.48	242.315	242.375	3845554.0
2017-06-01 12:30:00	SPY	ETF	242.38	242.72	242.38	242.66	2963181.0
2017-06-01 13:00:00	SPY	ETF	242.665	242.93	242.66	242.91	3767632.0
2017-06-01 13:30:00	SPY	ETF	242.91	242.93	242.78	242.82	2387057.0
2017-06-01 14:00:00	SPY	ETF	242.82	243.03	242.79	242.925	3341070.0
2017-06-01 14:30:00	SPY	ETF	242.925	242.93	242.785	242.8	2542329.0
2017-06-01 15:00:00	SPY	ETF	242.8	242.95	242.72	242.875	3424141.0
2017-06-01 15:30:00	SPY	ETF	242.88	243.34	242.83	243.32	10847566.0
2017-06-01 16:00:00	SPY	ETF	243.32	243.43	242.8659	243.3	8520210.0
2017-06-01 16:30:00	SPY	ETF	243.3	243.36	241.44	243.31	233358.0
2017-06-01 17:00:00	SPY	ETF	243.31	243.35	243.24	243.28	134834.0
2017-06-01 17:30:00	SPY	ETF	243.28	243.36	243.25	243.28	517336.0
2017-06-01 18:00:00	SPY	ETF	243.28	243.43	243.27	243.35	89729.0
2017-06-01 18:30:00	SPY	ETF	243.35	243.48	243.34	243.34	58325.0
2017-06-01 19:00:00	SPY	ETF	243.34	243.34	243.27	243.28	53087.0
2017-06-01 19:30:00	SPY	ETF	243.28	243.37	243.28	243.37	24966.0
2017-06-01 04:00:00	QQQ	ETF	141.6	141.6	141.6	141.6	100.0
2017-06-01 06:30:00	QQQ	ETF	141.53	141.56	141.53	141.54	1000.0
2017-06-01 07:00:00	QQQ	ETF	141.53	141.53	141.47	141.49	4586.0
2017-06-01 07:30:00	QQQ	ETF	141.48	141.49	141.39	141.42	4670.0
2017-06-01 08:00:00	QQQ	ETF	141.42	141.57	141.42	141.55	35241.0
2017-06-01 08:30:00	QQQ	ETF	141.55	141.57	141.29	141.55	74542.0
2017-06-01 09:00:00	QQQ	ETF	141.57	141.62	141.55	141.59	75431.0
2017-06-01 09:30:00	QQQ	ETF	141.57	141.76	141.38	141.481	2229033.0
2017-06-01 10:00:00	QQQ	ETF	141.48	141.5499	140.98	141.1	2554146.0
2017-06-01 10:30:00	QQQ	ETF	141.1	141.26	141.07	141.15	751925.0
2017-06-01 11:00:00	QQQ	ETF	141.15	141.39	141.12	141.39	873397.0
2017-06-01 11:30:00	QQQ	ETF	141.39	141.51	141.28	141.5	842829.0
2017-06-01 12:00:00	QQQ	ETF	141.49	141.58	141.43	141.5008	1299536.0
2017-06-01 12:30:00	QQQ	ETF	141.51	141.69	141.5	141.62	1032573.0
2017-06-01 13:00:00	QQQ	ETF	141.625	141.69	141.6	141.65	983411.0
2017-06-01 13:30:00	QQQ	ETF	141.64	141.65	141.54	141.585	634428.0
2017-06-01 14:00:00	QQQ	ETF	141.58	141.69	141.57	141.6457	879598.0
2017-06-01 14:30:00	QQQ	ETF	141.64	141.66	141.521	141.54	1002133.0

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

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