PREVIEW / etf_1hour / 2017-06-06

all etf 1-hour files

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

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-06 04:00:00	SPY	ETF	243.73	243.73	243.5	243.65	49013.0
2017-06-06 05:00:00	SPY	ETF	243.65	243.67	243.55	243.57	4601.0
2017-06-06 06:00:00	SPY	ETF	243.52	243.57	243.38	243.4	57765.0
2017-06-06 07:00:00	SPY	ETF	243.42	243.43	243.05	243.24	300435.0
2017-06-06 08:00:00	SPY	ETF	243.1	243.42	243.07	243.3	282905.0
2017-06-06 09:00:00	SPY	ETF	243.29	243.7	243.12	243.66	5490363.0
2017-06-06 10:00:00	SPY	ETF	243.66	243.933	243.47	243.53	6628514.0
2017-06-06 11:00:00	SPY	ETF	243.53	243.82	243.375	243.66	4184356.0
2017-06-06 12:00:00	SPY	ETF	243.66	243.73	243.55	243.665	2847134.0
2017-06-06 13:00:00	SPY	ETF	243.67	243.69	243.4	243.501	3398473.0
2017-06-06 14:00:00	SPY	ETF	243.51	243.98	243.51	243.87	6385056.0
2017-06-06 15:00:00	SPY	ETF	243.88	243.93	243.17	243.25	12871046.0
2017-06-06 16:00:00	SPY	ETF	243.26	243.52	243.21	243.39	6259734.0
2017-06-06 17:00:00	SPY	ETF	243.21	243.36	243.21	243.34	124850.0
2017-06-06 18:00:00	SPY	ETF	243.34	243.5	243.34	243.48	40747.0
2017-06-06 19:00:00	SPY	ETF	243.47	243.48	243.2566	243.47	455269.0
2017-06-06 04:00:00	QQQ	ETF	143.41	143.41	143.33	143.33	3095.0
2017-06-06 05:00:00	QQQ	ETF	143.33	143.4	143.33	143.4	2400.0
2017-06-06 06:00:00	QQQ	ETF	143.35	143.36	143.32	143.33	15900.0
2017-06-06 07:00:00	QQQ	ETF	143.3	143.31	143.06	143.14	54500.0
2017-06-06 08:00:00	QQQ	ETF	143.11	143.2	143.08	143.2	65290.0
2017-06-06 09:00:00	QQQ	ETF	143.19	143.59	143.16	143.51	3098890.0
2017-06-06 10:00:00	QQQ	ETF	143.52	143.73	143.34	143.55	1813948.0
2017-06-06 11:00:00	QQQ	ETF	143.555	143.58	143.35	143.5	1332719.0
2017-06-06 12:00:00	QQQ	ETF	143.5	143.53	143.4	143.49	602763.0
2017-06-06 13:00:00	QQQ	ETF	143.49	143.5	143.2999	143.38	1100399.0
2017-06-06 14:00:00	QQQ	ETF	143.39	143.609	143.365	143.5417	1324253.0
2017-06-06 15:00:00	QQQ	ETF	143.55	143.6	142.65	142.86	7052970.0
2017-06-06 16:00:00	QQQ	ETF	142.86	143.01	142.85	142.97	424720.0
2017-06-06 17:00:00	QQQ	ETF	142.86	142.95	142.86	142.91	229766.0
2017-06-06 18:00:00	QQQ	ETF	142.95	143.07	142.95	143.05	17663.0
2017-06-06 19:00:00	QQQ	ETF	143.01	143.08	143.01	143.08	5010.0
2017-06-06 06:00:00	IWM	ETF	138.24	138.24	138.24	138.24	103.0
2017-06-06 07:00:00	IWM	ETF	138.26	138.27	137.74	137.91	100505.0
2017-06-06 08:00:00	IWM	ETF	137.95	138.1	137.84	137.99	155251.0
2017-06-06 09:00:00	IWM	ETF	137.99	138.75	137.81	138.72	4146953.0
2017-06-06 10:00:00	IWM	ETF	138.73	138.8	138.4	138.41	3629746.0
2017-06-06 11:00:00	IWM	ETF	138.42	138.63	138.11	138.42	2202127.0
2017-06-06 12:00:00	IWM	ETF	138.42	138.71	138.41	138.6	1412241.0
2017-06-06 13:00:00	IWM	ETF	138.6039	138.76	138.51	138.74	2194199.0
2017-06-06 14:00:00	IWM	ETF	138.74	139.65	138.74	139.52	4067751.0
2017-06-06 15:00:00	IWM	ETF	139.53	139.66	138.81	138.85	4755729.0
2017-06-06 16:00:00	IWM	ETF	138.85	138.99	138.76	138.85	811841.0
2017-06-06 17:00:00	IWM	ETF	138.8	138.81	138.7	138.78	201142.0
2017-06-06 18:00:00	IWM	ETF	138.85	139.04	138.78	139.04	7111.0
2017-06-06 19:00:00	IWM	ETF	138.93	139.02	138.88	139.02	6153.0
2017-06-06 04:00:00	DIA	ETF	211.66	211.66	211.56	211.56	300.0
2017-06-06 06:00:00	DIA	ETF	211.5	211.5	211.4	211.4	1135.0
2017-06-06 07:00:00	DIA	ETF	211.36	211.36	211.25	211.27	10505.0
2017-06-06 08:00:00	DIA	ETF	211.2	211.27	211.2	211.27	3364.0

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

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