PREVIEW / etf_1hour / 2016-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-01.parquet
  size:    255 KB
  rows:    8,143

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
2016-03-01 04:00:00	SPY	ETF	194.61	194.72	194.35	194.64	39610.0
2016-03-01 05:00:00	SPY	ETF	194.53	195.22	194.5	195.14	24306.0
2016-03-01 06:00:00	SPY	ETF	194.99	195.37	194.85	194.95	176596.0
2016-03-01 07:00:00	SPY	ETF	194.95	195.25	194.95	195.06	367696.0
2016-03-01 08:00:00	SPY	ETF	195.06	195.24	193.055	194.93	850440.0
2016-03-01 09:00:00	SPY	ETF	194.96	195.28	193.56	194.93	12781987.0
2016-03-01 10:00:00	SPY	ETF	194.93	196.2	194.93	195.7889	22399298.0
2016-03-01 11:00:00	SPY	ETF	195.79	197.02	195.75	196.97	16658992.0
2016-03-01 12:00:00	SPY	ETF	196.97	197.41	196.93	197.36	15506319.0
2016-03-01 13:00:00	SPY	ETF	197.35	197.73	197.12	197.46	13161218.0
2016-03-01 14:00:00	SPY	ETF	197.46	197.97	197.23	197.96	13274824.0
2016-03-01 15:00:00	SPY	ETF	197.965	198.18	197.62	198.18	30821422.0
2016-03-01 16:00:00	SPY	ETF	198.17	198.49	193.35	198.35	7524560.0
2016-03-01 17:00:00	SPY	ETF	198.35	198.37	198.11	198.28	940704.0
2016-03-01 18:00:00	SPY	ETF	198.26	198.3	198.15	198.22	168607.0
2016-03-01 19:00:00	SPY	ETF	198.17	198.22	198.04	198.19	190681.0
2016-03-01 04:00:00	QQQ	ETF	103.26	103.28	103.19	103.28	2903.0
2016-03-01 05:00:00	QQQ	ETF	103.2	103.57	103.2	103.57	7500.0
2016-03-01 06:00:00	QQQ	ETF	103.32	103.58	103.32	103.38	10500.0
2016-03-01 07:00:00	QQQ	ETF	103.36	103.49	103.35	103.39	142944.0
2016-03-01 08:00:00	QQQ	ETF	103.34	103.4	103.17	103.3	72438.0
2016-03-01 09:00:00	QQQ	ETF	103.34	103.6	103.16	103.53	3958665.0
2016-03-01 10:00:00	QQQ	ETF	103.53	104.5	103.53	104.272	7367847.0
2016-03-01 11:00:00	QQQ	ETF	104.27	105.0299	104.27	104.98	4291678.0
2016-03-01 12:00:00	QQQ	ETF	104.97	105.26	104.97	105.17	3165497.0
2016-03-01 13:00:00	QQQ	ETF	105.17	105.4146	105.0	105.3	2565348.0
2016-03-01 14:00:00	QQQ	ETF	105.3	105.61	105.25	105.5971	3237526.0
2016-03-01 15:00:00	QQQ	ETF	105.595	105.79	105.37	105.78	5643106.0
2016-03-01 16:00:00	QQQ	ETF	105.76	105.94	102.5	105.92	1830874.0
2016-03-01 17:00:00	QQQ	ETF	105.94	105.94	105.87	105.87	68471.0
2016-03-01 18:00:00	QQQ	ETF	105.84	105.9	105.82	105.83	15264.0
2016-03-01 19:00:00	QQQ	ETF	105.88	105.88	105.76	105.85	35875.0
2016-03-01 05:00:00	IWM	ETF	103.6	103.79	103.59	103.78	3496.0
2016-03-01 06:00:00	IWM	ETF	103.61	103.86	103.61	103.79	1500.0
2016-03-01 07:00:00	IWM	ETF	103.82	103.85	103.76	103.77	16437.0
2016-03-01 08:00:00	IWM	ETF	103.73	103.8	103.53	103.57	69386.0
2016-03-01 09:00:00	IWM	ETF	103.64	103.81	102.75	103.22	2797517.0
2016-03-01 10:00:00	IWM	ETF	103.23	104.14	103.23	103.77	6301345.0
2016-03-01 11:00:00	IWM	ETF	103.78	104.23	103.69	104.13	4616675.0
2016-03-01 12:00:00	IWM	ETF	104.13	104.38	104.04	104.27	2550593.0
2016-03-01 13:00:00	IWM	ETF	104.24	104.5	104.1	104.29	2857239.0
2016-03-01 14:00:00	IWM	ETF	104.3	104.56	104.11	104.56	2721771.0
2016-03-01 15:00:00	IWM	ETF	104.56	104.93	104.51	104.91	6059631.0
2016-03-01 16:00:00	IWM	ETF	104.92	105.1	102.73	105.08	1578341.0
2016-03-01 17:00:00	IWM	ETF	105.08	105.1	104.94	104.95	650822.0
2016-03-01 18:00:00	IWM	ETF	104.86	105.02	104.83	104.83	3369.0
2016-03-01 19:00:00	IWM	ETF	104.82	104.94	104.82	104.94	6200.0
2016-03-01 06:00:00	DIA	ETF	166.4	166.4	166.4	166.4	300.0
2016-03-01 07:00:00	DIA	ETF	166.3	166.35	166.3	166.35	800.0
2016-03-01 08:00:00	DIA	ETF	166.23	166.41	166.07	166.07	1100.0

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

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