PREVIEW / etf_1hour / 2016-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-21.parquet
  size:    260 KB
  rows:    8,338

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-01-21 04:00:00	SPY	ETF	185.32	185.32	184.29	185.1	14621.0
2016-01-21 05:00:00	SPY	ETF	185.14	185.75	185.07	185.59	17034.0
2016-01-21 06:00:00	SPY	ETF	185.4	185.62	184.72	185.19	111509.0
2016-01-21 07:00:00	SPY	ETF	185.19	185.99	184.84	185.75	685661.0
2016-01-21 08:00:00	SPY	ETF	185.75	187.97	184.85	186.74	3978857.0
2016-01-21 09:00:00	SPY	ETF	186.73	187.16	184.64	185.11	24257793.0
2016-01-21 10:00:00	SPY	ETF	185.105	187.91	185.06	186.88	31612239.0
2016-01-21 11:00:00	SPY	ETF	186.89	188.27	186.46	188.16	23022532.0
2016-01-21 12:00:00	SPY	ETF	188.16	188.87	187.89	188.12	18280031.0
2016-01-21 13:00:00	SPY	ETF	188.1101	188.62	186.79	187.27	23918278.0
2016-01-21 14:00:00	SPY	ETF	187.3	187.5499	185.77	187.36	26675708.0
2016-01-21 15:00:00	SPY	ETF	187.365	187.68	186.305	186.68	26817052.0
2016-01-21 16:00:00	SPY	ETF	186.68	187.0	186.39	186.66	11786849.0
2016-01-21 17:00:00	SPY	ETF	186.64	186.67	186.38	186.38	524633.0
2016-01-21 18:00:00	SPY	ETF	186.41	187.0	186.17	186.92	374631.0
2016-01-21 19:00:00	SPY	ETF	186.94	187.44	186.42	186.97	287672.0
2016-01-21 04:00:00	QQQ	ETF	100.2	100.41	99.81	100.02	10870.0
2016-01-21 05:00:00	QQQ	ETF	100.31	100.53	100.21	100.42	3425.0
2016-01-21 06:00:00	QQQ	ETF	100.56	100.56	100.21	100.44	13228.0
2016-01-21 07:00:00	QQQ	ETF	100.42	100.91	100.25	100.78	69835.0
2016-01-21 08:00:00	QQQ	ETF	100.43	102.06	100.39	101.4	889380.0
2016-01-21 09:00:00	QQQ	ETF	101.45	101.54	99.82	100.095	8372924.0
2016-01-21 10:00:00	QQQ	ETF	100.1	101.87	100.07	101.29	10740702.0
2016-01-21 11:00:00	QQQ	ETF	101.3	102.01	101.06	101.95	7574982.0
2016-01-21 12:00:00	QQQ	ETF	101.96	102.349	101.82	101.9	4429964.0
2016-01-21 13:00:00	QQQ	ETF	101.8962	102.175	101.17	101.36	5010530.0
2016-01-21 14:00:00	QQQ	ETF	101.37	101.57	100.49	101.42	6858779.0
2016-01-21 15:00:00	QQQ	ETF	101.44	101.58	100.76	100.88	7221197.0
2016-01-21 16:00:00	QQQ	ETF	100.87	102.0507	100.66	100.83	845116.0
2016-01-21 17:00:00	QQQ	ETF	100.75	100.85	100.7	100.7	29104.0
2016-01-21 18:00:00	QQQ	ETF	100.75	101.0	100.62	101.0	54883.0
2016-01-21 19:00:00	QQQ	ETF	101.0	101.26	100.8	101.1	36111.0
2016-01-21 04:00:00	IWM	ETF	98.2	98.51	98.1	98.51	9250.0
2016-01-21 05:00:00	IWM	ETF	99.0	99.0	99.0	99.0	500.0
2016-01-21 06:00:00	IWM	ETF	98.5	98.89	98.5	98.8	4430.0
2016-01-21 07:00:00	IWM	ETF	98.76	99.05	98.54	98.9	84115.0
2016-01-21 08:00:00	IWM	ETF	99.0	100.5	98.98	99.54	581130.0
2016-01-21 09:00:00	IWM	ETF	99.61	99.7	98.38	98.73	8882636.0
2016-01-21 10:00:00	IWM	ETF	98.74	100.28	98.71	99.31	10379902.0
2016-01-21 11:00:00	IWM	ETF	99.31	100.46	99.1	100.35	7995046.0
2016-01-21 12:00:00	IWM	ETF	100.37	100.91	99.96	100.119	6187344.0
2016-01-21 13:00:00	IWM	ETF	100.11	100.55	99.16	99.58	6224225.0
2016-01-21 14:00:00	IWM	ETF	99.59	99.95	98.68	99.745	7996448.0
2016-01-21 15:00:00	IWM	ETF	99.75	99.765	98.95	98.96	8291189.0
2016-01-21 16:00:00	IWM	ETF	98.94	99.2	98.7	98.86	1903974.0
2016-01-21 17:00:00	IWM	ETF	98.79	98.79	98.79	98.79	228.0
2016-01-21 18:00:00	IWM	ETF	98.7	98.87	98.7	98.87	5157.0
2016-01-21 19:00:00	IWM	ETF	98.89	99.0	98.82	99.0	2388.0
2016-01-21 20:00:00	IWM	ETF	99.0527	99.0527	99.0527	99.0527	350000.0
2016-01-21 04:00:00	DIA	ETF	156.99	156.99	156.99	156.99	300.0

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

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