PREVIEW / etf_1hour / 2017-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-04.parquet
  size:    273 KB
  rows:    8,953

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-08-04 04:00:00	SPY	ETF	247.3	247.33	247.3	247.32	1400.0
2017-08-04 05:00:00	SPY	ETF	247.33	247.43	247.33	247.36	36100.0
2017-08-04 06:00:00	SPY	ETF	247.39	247.42	247.39	247.39	16000.0
2017-08-04 07:00:00	SPY	ETF	247.41	247.58	247.4	247.55	105208.0
2017-08-04 08:00:00	SPY	ETF	247.47	247.73	247.44	247.5	761148.0
2017-08-04 09:00:00	SPY	ETF	247.49	247.79	247.24	247.27	4852887.0
2017-08-04 10:00:00	SPY	ETF	247.26	247.58	246.97	247.315	10512955.0
2017-08-04 11:00:00	SPY	ETF	247.32	247.48	247.18	247.43	6126144.0
2017-08-04 12:00:00	SPY	ETF	247.42	247.45	247.21	247.32	2893989.0
2017-08-04 13:00:00	SPY	ETF	247.33	247.43	247.2544	247.405	2877144.0
2017-08-04 14:00:00	SPY	ETF	247.4	247.44	247.14	247.22	4510683.0
2017-08-04 15:00:00	SPY	ETF	247.22	247.46	247.145	247.4	14432995.0
2017-08-04 16:00:00	SPY	ETF	247.41	247.4646	247.22	247.24	11985987.0
2017-08-04 17:00:00	SPY	ETF	247.23	247.3	247.22	247.3	36491.0
2017-08-04 18:00:00	SPY	ETF	247.3	247.33	247.3	247.3	9990.0
2017-08-04 19:00:00	SPY	ETF	247.3	247.38	247.3	247.32	8941.0
2017-08-04 04:00:00	QQQ	ETF	143.56	143.62	143.55	143.62	7154.0
2017-08-04 06:00:00	QQQ	ETF	143.62	143.68	143.59	143.59	3600.0
2017-08-04 07:00:00	QQQ	ETF	143.6	143.72	143.6	143.67	101818.0
2017-08-04 08:00:00	QQQ	ETF	143.67	143.84	143.46	143.5	245044.0
2017-08-04 09:00:00	QQQ	ETF	143.51	143.97	143.3077	143.327	3184458.0
2017-08-04 10:00:00	QQQ	ETF	143.33	143.8	143.06	143.64	4784743.0
2017-08-04 11:00:00	QQQ	ETF	143.65	143.9	143.56	143.74	1898835.0
2017-08-04 12:00:00	QQQ	ETF	143.75	143.75	143.33	143.51	972635.0
2017-08-04 13:00:00	QQQ	ETF	143.52	143.61	143.39	143.55	966034.0
2017-08-04 14:00:00	QQQ	ETF	143.55	143.59	143.375	143.45	1669090.0
2017-08-04 15:00:00	QQQ	ETF	143.45	143.67	143.37	143.63	6012984.0
2017-08-04 16:00:00	QQQ	ETF	143.63	143.73	143.4318	143.65	2308688.0
2017-08-04 17:00:00	QQQ	ETF	143.64	143.64	143.59	143.63	1650.0
2017-08-04 18:00:00	QQQ	ETF	143.62	143.62	143.6	143.6	800.0
2017-08-04 19:00:00	QQQ	ETF	143.65	143.65	143.65	143.65	1500.0
2017-08-04 04:00:00	IWM	ETF	139.56	139.73	139.56	139.73	200.0
2017-08-04 06:00:00	IWM	ETF	139.7	139.78	139.7	139.78	2503.0
2017-08-04 07:00:00	IWM	ETF	139.77	139.97	139.77	139.97	126921.0
2017-08-04 08:00:00	IWM	ETF	139.89	140.08	139.69	139.86	228808.0
2017-08-04 09:00:00	IWM	ETF	139.88	140.06	139.61	139.76	1224189.0
2017-08-04 10:00:00	IWM	ETF	139.75	140.3	139.49	140.12	2872133.0
2017-08-04 11:00:00	IWM	ETF	140.12	140.3	139.99	140.11	1524983.0
2017-08-04 12:00:00	IWM	ETF	140.12	140.31	140.09	140.25	1027930.0
2017-08-04 13:00:00	IWM	ETF	140.26	140.32	140.11	140.24	1058558.0
2017-08-04 14:00:00	IWM	ETF	140.25	140.3	140.02	140.14	1144474.0
2017-08-04 15:00:00	IWM	ETF	140.14	140.3	140.07	140.22	3170028.0
2017-08-04 16:00:00	IWM	ETF	140.22	140.33	140.07	140.19	1538434.0
2017-08-04 18:00:00	IWM	ETF	140.21	140.21	140.21	140.21	479.0
2017-08-04 19:00:00	IWM	ETF	140.25	140.25	140.23	140.23	721.0
2017-08-04 04:00:00	DIA	ETF	220.33	220.48	220.33	220.48	230.0
2017-08-04 07:00:00	DIA	ETF	220.47	220.47	220.47	220.47	600.0
2017-08-04 08:00:00	DIA	ETF	220.83	220.83	220.57	220.62	12589.0
2017-08-04 09:00:00	DIA	ETF	220.66	220.7	220.19	220.26	385500.0
2017-08-04 10:00:00	DIA	ETF	220.25	220.46	220.03	220.25	491167.0

> showing 50 of 8,953 rows — these rows as CSV

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