PREVIEW / etf_1hour / 2017-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-27.parquet
  size:    282 KB
  rows:    9,218

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-27 04:00:00	SPY	ETF	243.03	243.03	242.66	242.98	5000.0
2017-06-27 05:00:00	SPY	ETF	243.06	243.22	242.99	243.01	1603.0
2017-06-27 06:00:00	SPY	ETF	243.01	243.12	242.94	243.1	57555.0
2017-06-27 07:00:00	SPY	ETF	243.07	243.1	242.88	243.1	165249.0
2017-06-27 08:00:00	SPY	ETF	242.92	243.16	242.92	243.1	137200.0
2017-06-27 09:00:00	SPY	ETF	243.06	243.1	242.6	242.82	5913683.0
2017-06-27 10:00:00	SPY	ETF	242.82	243.33	242.7783	243.23	8930441.0
2017-06-27 11:00:00	SPY	ETF	243.22	243.38	243.14	243.21	4297624.0
2017-06-27 12:00:00	SPY	ETF	243.21	243.27	242.68	242.76	4977168.0
2017-06-27 13:00:00	SPY	ETF	242.765	242.8	241.76	242.13	13281960.0
2017-06-27 14:00:00	SPY	ETF	242.135	242.4	241.72	242.1642	12017230.0
2017-06-27 15:00:00	SPY	ETF	242.16	242.25	241.31	241.36	21421671.0
2017-06-27 16:00:00	SPY	ETF	241.37	243.2538	241.3002	241.44	9382605.0
2017-06-27 17:00:00	SPY	ETF	241.44	241.48	241.33	241.35	90842.0
2017-06-27 18:00:00	SPY	ETF	241.39	241.61	241.39	241.53	67025.0
2017-06-27 19:00:00	SPY	ETF	241.51	241.57	241.4	241.4	20957.0
2017-06-27 04:00:00	QQQ	ETF	140.25	140.25	139.74	139.91	9460.0
2017-06-27 05:00:00	QQQ	ETF	139.94	140.12	139.92	139.93	54763.0
2017-06-27 06:00:00	QQQ	ETF	139.94	140.05	139.86	139.99	40145.0
2017-06-27 07:00:00	QQQ	ETF	139.9	140.07	139.84	140.07	52370.0
2017-06-27 08:00:00	QQQ	ETF	139.92	140.09	139.88	139.9	173634.0
2017-06-27 09:00:00	QQQ	ETF	139.9	140.08	139.49	139.74	5384990.0
2017-06-27 10:00:00	QQQ	ETF	139.74	140.22	139.72	140.0599	4627233.0
2017-06-27 11:00:00	QQQ	ETF	140.05	140.19	139.76	139.8	2606198.0
2017-06-27 12:00:00	QQQ	ETF	139.8	139.905	139.16	139.29	3620245.0
2017-06-27 13:00:00	QQQ	ETF	139.28	139.325	138.36	138.63	7110802.0
2017-06-27 14:00:00	QQQ	ETF	138.64	138.95	138.28	138.751	7493240.0
2017-06-27 15:00:00	QQQ	ETF	138.76	138.885	138.02	138.02	13402452.0
2017-06-27 16:00:00	QQQ	ETF	138.03	139.7158	137.89	138.03	4485226.0
2017-06-27 17:00:00	QQQ	ETF	138.05	138.05	137.92	137.93	176279.0
2017-06-27 18:00:00	QQQ	ETF	137.96	138.14	137.87	137.98	76255.0
2017-06-27 19:00:00	QQQ	ETF	137.97	138.05	137.9	137.95	38664.0
2017-06-27 04:00:00	IWM	ETF	140.55	140.72	140.55	140.72	200.0
2017-06-27 05:00:00	IWM	ETF	140.9	141.0	140.9	141.0	1220.0
2017-06-27 06:00:00	IWM	ETF	140.95	140.95	140.95	140.95	694.0
2017-06-27 07:00:00	IWM	ETF	140.73	140.98	140.72	140.98	11435.0
2017-06-27 08:00:00	IWM	ETF	141.0	141.18	140.89	141.18	21126.0
2017-06-27 09:00:00	IWM	ETF	141.14	141.15	140.62	140.67	2512141.0
2017-06-27 10:00:00	IWM	ETF	140.67	141.33	140.64	141.2599	2941115.0
2017-06-27 11:00:00	IWM	ETF	141.2501	141.62	141.16	141.57	1472231.0
2017-06-27 12:00:00	IWM	ETF	141.56	141.57	141.08	141.1701	2185050.0
2017-06-27 13:00:00	IWM	ETF	141.17	141.26	140.26	140.41	3090852.0
2017-06-27 14:00:00	IWM	ETF	140.42	140.58	140.05	140.41	2819810.0
2017-06-27 15:00:00	IWM	ETF	140.41	140.51	139.75	139.84	4997456.0
2017-06-27 16:00:00	IWM	ETF	139.83	141.2503	139.83	139.84	832955.0
2017-06-27 17:00:00	IWM	ETF	139.89	139.94	139.84	139.84	1641.0
2017-06-27 18:00:00	IWM	ETF	139.92	139.92	139.87	139.87	4277.0
2017-06-27 19:00:00	IWM	ETF	139.88	139.88	139.88	139.88	100.0
2017-06-27 07:00:00	DIA	ETF	213.65	213.65	213.65	213.65	100.0
2017-06-27 08:00:00	DIA	ETF	213.9	213.9	213.8	213.8	3417.0

> showing 50 of 9,218 rows — these rows as CSV

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