PREVIEW / etf_1hour / 2017-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-06.parquet
  size:    278 KB
  rows:    9,168

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-06 04:00:00	SPY	ETF	242.31	242.38	242.3	242.3	1459.0
2017-07-06 05:00:00	SPY	ETF	242.18	242.2	241.78	241.81	17073.0
2017-07-06 06:00:00	SPY	ETF	241.81	241.81	241.44	241.77	88680.0
2017-07-06 07:00:00	SPY	ETF	241.8	241.8	241.44	241.52	405742.0
2017-07-06 08:00:00	SPY	ETF	241.56	241.89	241.5	241.85	518116.0
2017-07-06 09:00:00	SPY	ETF	241.86	242.03	241.23	241.3	7875094.0
2017-07-06 10:00:00	SPY	ETF	241.3	241.49	240.84	241.24	10052969.0
2017-07-06 11:00:00	SPY	ETF	241.235	241.75	241.23	241.72	5735748.0
2017-07-06 12:00:00	SPY	ETF	241.71	241.8	241.38	241.655	3461644.0
2017-07-06 13:00:00	SPY	ETF	241.65	241.95	241.3	241.38	4477344.0
2017-07-06 14:00:00	SPY	ETF	241.38	241.38	240.85	241.11	6960533.0
2017-07-06 15:00:00	SPY	ETF	241.11	241.36	240.34	240.58	17133859.0
2017-07-06 16:00:00	SPY	ETF	240.57	241.626	240.55	240.66	7081007.0
2017-07-06 17:00:00	SPY	ETF	240.66	240.68	240.6	240.67	83768.0
2017-07-06 18:00:00	SPY	ETF	240.68	240.84	240.68	240.81	85246.0
2017-07-06 19:00:00	SPY	ETF	240.79	240.82	240.69	240.71	25934.0
2017-07-06 04:00:00	QQQ	ETF	137.28	137.28	137.15	137.17	2113.0
2017-07-06 05:00:00	QQQ	ETF	137.07	137.07	136.59	136.61	30781.0
2017-07-06 06:00:00	QQQ	ETF	136.54	136.64	136.34	136.62	47565.0
2017-07-06 07:00:00	QQQ	ETF	136.6	136.6	136.11	136.2	178870.0
2017-07-06 08:00:00	QQQ	ETF	136.65	136.65	136.09	136.46	284113.0
2017-07-06 09:00:00	QQQ	ETF	136.53	136.78	136.05	136.32	7043882.0
2017-07-06 10:00:00	QQQ	ETF	136.27	136.43	135.8	136.18	7928116.0
2017-07-06 11:00:00	QQQ	ETF	136.18	136.87	136.09	136.72	5570973.0
2017-07-06 12:00:00	QQQ	ETF	136.72	137.06	136.525	136.926	3017906.0
2017-07-06 13:00:00	QQQ	ETF	136.925	137.04	136.62	136.7	2258045.0
2017-07-06 14:00:00	QQQ	ETF	136.705	136.725	136.34	136.535	4445574.0
2017-07-06 15:00:00	QQQ	ETF	136.53	136.5701	136.09	136.3	8444078.0
2017-07-06 16:00:00	QQQ	ETF	136.3	136.4546	136.18	136.22	2155857.0
2017-07-06 17:00:00	QQQ	ETF	136.22	136.27	136.2	136.25	13490.0
2017-07-06 18:00:00	QQQ	ETF	136.27	136.34	136.27	136.34	9503.0
2017-07-06 19:00:00	QQQ	ETF	136.3	136.37	136.28	136.28	12700.0
2017-07-06 04:00:00	IWM	ETF	140.71	140.71	140.58	140.59	2454.0
2017-07-06 05:00:00	IWM	ETF	140.53	140.53	140.32	140.32	9449.0
2017-07-06 06:00:00	IWM	ETF	140.22	140.22	139.84	139.98	7735.0
2017-07-06 07:00:00	IWM	ETF	139.97	139.97	139.63	139.64	209483.0
2017-07-06 08:00:00	IWM	ETF	139.64	139.93	139.64	139.91	152235.0
2017-07-06 09:00:00	IWM	ETF	139.93	140.12	139.48	139.57	2955436.0
2017-07-06 10:00:00	IWM	ETF	139.58	139.97	139.36	139.72	3658385.0
2017-07-06 11:00:00	IWM	ETF	139.72	140.47	139.72	140.28	2765585.0
2017-07-06 12:00:00	IWM	ETF	140.28	140.38	140.09	140.14	1247385.0
2017-07-06 13:00:00	IWM	ETF	140.14	140.24	139.74	139.85	1323890.0
2017-07-06 14:00:00	IWM	ETF	139.85	139.86	139.415	139.609	2332183.0
2017-07-06 15:00:00	IWM	ETF	139.605	139.605	138.83	139.13	5852298.0
2017-07-06 16:00:00	IWM	ETF	139.14	139.23	138.87	139.07	4018108.0
2017-07-06 17:00:00	IWM	ETF	139.0	139.14	138.97	138.97	31201.0
2017-07-06 18:00:00	IWM	ETF	139.09	139.2	139.09	139.2	1097.0
2017-07-06 19:00:00	IWM	ETF	139.2	139.21	139.19	139.19	2481.0
2017-07-06 06:00:00	DIA	ETF	214.13	214.13	214.13	214.13	100.0
2017-07-06 07:00:00	DIA	ETF	213.75	213.88	213.7	213.76	8350.0

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

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