PREVIEW / etf_1hour / 2017-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-14.parquet
  size:    277 KB
  rows:    9,010

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-14 04:00:00	SPY	ETF	244.57	244.66	244.57	244.59	300.0
2017-06-14 05:00:00	SPY	ETF	244.54	244.76	244.54	244.64	9745.0
2017-06-14 06:00:00	SPY	ETF	244.67	244.79	244.63	244.78	51100.0
2017-06-14 07:00:00	SPY	ETF	244.76	244.93	244.7	244.79	329819.0
2017-06-14 08:00:00	SPY	ETF	244.79	245.02	244.38	244.82	802288.0
2017-06-14 09:00:00	SPY	ETF	244.81	244.97	244.31	244.56	6385513.0
2017-06-14 10:00:00	SPY	ETF	244.55	244.645	243.965	244.13	8049848.0
2017-06-14 11:00:00	SPY	ETF	244.14	244.36	244.04	244.34	5782984.0
2017-06-14 12:00:00	SPY	ETF	244.34	244.48	244.12	244.32	3608422.0
2017-06-14 13:00:00	SPY	ETF	244.32	244.51	244.21	244.29	6844313.0
2017-06-14 14:00:00	SPY	ETF	244.29	244.78	243.56	243.71	16486419.0
2017-06-14 15:00:00	SPY	ETF	243.71	244.41	243.29	244.26	19907684.0
2017-06-14 16:00:00	SPY	ETF	244.25	244.36	244.09	244.13	9073933.0
2017-06-14 17:00:00	SPY	ETF	244.17	244.2	243.4999	244.12	145949.0
2017-06-14 18:00:00	SPY	ETF	244.12	244.12	243.5	243.65	263865.0
2017-06-14 19:00:00	SPY	ETF	243.6	243.77	243.45	243.72	152505.0
2017-06-14 04:00:00	QQQ	ETF	140.45	140.57	140.39	140.49	600.0
2017-06-14 05:00:00	QQQ	ETF	140.5	140.65	140.5	140.59	6100.0
2017-06-14 06:00:00	QQQ	ETF	140.59	140.61	140.56	140.59	5400.0
2017-06-14 07:00:00	QQQ	ETF	140.62	140.78	140.56	140.62	109981.0
2017-06-14 08:00:00	QQQ	ETF	140.63	140.97	140.36	140.77	384455.0
2017-06-14 09:00:00	QQQ	ETF	140.8	141.05	140.31	140.7	5551497.0
2017-06-14 10:00:00	QQQ	ETF	140.7	140.8	140.24	140.5	5613629.0
2017-06-14 11:00:00	QQQ	ETF	140.51	140.815	140.38	140.815	2491804.0
2017-06-14 12:00:00	QQQ	ETF	140.81	140.85	140.41	140.51	2591756.0
2017-06-14 13:00:00	QQQ	ETF	140.52	140.69	140.375	140.46	2494935.0
2017-06-14 14:00:00	QQQ	ETF	140.46	140.85	139.23	139.46	15269221.0
2017-06-14 15:00:00	QQQ	ETF	139.4517	139.84	138.62	139.75	15798363.0
2017-06-14 16:00:00	QQQ	ETF	139.75	139.87	139.57	139.65	1276478.0
2017-06-14 17:00:00	QQQ	ETF	139.65	139.76	139.2776	139.6	151761.0
2017-06-14 18:00:00	QQQ	ETF	139.6	139.7	139.09	139.21	40805.0
2017-06-14 19:00:00	QQQ	ETF	139.19	139.27	139.07	139.22	96440.0
2017-06-14 05:00:00	IWM	ETF	142.03	142.24	142.03	142.19	3281.0
2017-06-14 06:00:00	IWM	ETF	142.19	142.3	142.1	142.3	6500.0
2017-06-14 07:00:00	IWM	ETF	142.39	142.4	142.23	142.27	39579.0
2017-06-14 08:00:00	IWM	ETF	142.27	142.32	141.84	142.07	131969.0
2017-06-14 09:00:00	IWM	ETF	142.09	142.1	141.29	141.5	2638351.0
2017-06-14 10:00:00	IWM	ETF	141.51	141.76	140.95	141.115	3883479.0
2017-06-14 11:00:00	IWM	ETF	141.12	141.52	140.94	141.35	2750518.0
2017-06-14 12:00:00	IWM	ETF	141.35	141.365	140.81	141.2	1912024.0
2017-06-14 13:00:00	IWM	ETF	141.21	141.495	141.0	141.22	1438832.0
2017-06-14 14:00:00	IWM	ETF	141.22	141.485	140.45	140.88	6171094.0
2017-06-14 15:00:00	IWM	ETF	140.89	141.28	140.5	141.26	6220974.0
2017-06-14 16:00:00	IWM	ETF	141.26	141.3	141.03	141.05	2579782.0
2017-06-14 17:00:00	IWM	ETF	141.03	141.26	141.0049	141.01	550874.0
2017-06-14 18:00:00	IWM	ETF	141.02	141.02	140.82	140.82	6150.0
2017-06-14 19:00:00	IWM	ETF	140.82	140.82	140.68	140.75	9572.0
2017-06-14 04:00:00	DIA	ETF	213.37	213.37	213.37	213.37	100.0
2017-06-14 08:00:00	DIA	ETF	213.76	213.76	213.76	213.76	500.0
2017-06-14 09:00:00	DIA	ETF	213.78	213.78	213.31	213.44	229828.0

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

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