PREVIEW / etf_1hour / 2016-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-18.parquet
  size:    247 KB
  rows:    7,908

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-02-18 04:00:00	SPY	ETF	192.56	193.0	192.47	192.74	17834.0
2016-02-18 05:00:00	SPY	ETF	192.77	193.41	192.71	193.32	31954.0
2016-02-18 06:00:00	SPY	ETF	193.35	193.92	193.35	193.54	120770.0
2016-02-18 07:00:00	SPY	ETF	193.54	193.71	193.19	193.44	454888.0
2016-02-18 08:00:00	SPY	ETF	193.42	193.65	193.22	193.42	849207.0
2016-02-18 09:00:00	SPY	ETF	193.45	193.48	192.43	192.72	13438732.0
2016-02-18 10:00:00	SPY	ETF	192.73	192.99	192.13	192.38	13850372.0
2016-02-18 11:00:00	SPY	ETF	192.37	193.22	191.8	192.66	17376405.0
2016-02-18 12:00:00	SPY	ETF	192.66	192.82	192.35	192.3668	9202378.0
2016-02-18 13:00:00	SPY	ETF	192.37	192.62	191.75	192.05	8863574.0
2016-02-18 14:00:00	SPY	ETF	192.04	192.79	192.01	192.58	10786592.0
2016-02-18 15:00:00	SPY	ETF	192.587	192.68	191.72	192.04	21580611.0
2016-02-18 16:00:00	SPY	ETF	192.04	192.6009	191.99	192.4	4481909.0
2016-02-18 17:00:00	SPY	ETF	192.4	192.4	192.2306	192.31	579394.0
2016-02-18 18:00:00	SPY	ETF	192.32	192.35	192.14	192.26	77246.0
2016-02-18 19:00:00	SPY	ETF	192.3	192.34	191.96	191.98	119110.0
2016-02-18 20:00:00	SPY	ETF	192.0172	192.0172	192.0172	192.0172	562000.0
2016-02-18 04:00:00	QQQ	ETF	102.49	102.57	102.49	102.57	900.0
2016-02-18 05:00:00	QQQ	ETF	102.54	102.82	102.54	102.82	3000.0
2016-02-18 06:00:00	QQQ	ETF	102.96	103.18	102.96	103.0	22299.0
2016-02-18 07:00:00	QQQ	ETF	103.03	103.11	102.83	102.91	68374.0
2016-02-18 08:00:00	QQQ	ETF	102.95	103.01	102.83	102.95	126482.0
2016-02-18 09:00:00	QQQ	ETF	102.95	102.95	102.19	102.29	5059180.0
2016-02-18 10:00:00	QQQ	ETF	102.29	102.38	101.82	101.85	4803438.0
2016-02-18 11:00:00	QQQ	ETF	101.85	102.16	101.59	102.12	5226237.0
2016-02-18 12:00:00	QQQ	ETF	102.13	102.16	101.81	101.82	2698245.0
2016-02-18 13:00:00	QQQ	ETF	101.83	101.97	101.42	101.54	2767999.0
2016-02-18 14:00:00	QQQ	ETF	101.54	102.01	101.53	101.82	3371771.0
2016-02-18 15:00:00	QQQ	ETF	101.83	101.87	101.2	101.34	6672912.0
2016-02-18 16:00:00	QQQ	ETF	101.34	101.782	101.31	101.56	3373351.0
2016-02-18 17:00:00	QQQ	ETF	101.57	101.59	101.51	101.52	62229.0
2016-02-18 18:00:00	QQQ	ETF	101.52	101.56	101.41	101.53	22205.0
2016-02-18 19:00:00	QQQ	ETF	101.52	101.53	101.3	101.3	18261.0
2016-02-18 20:00:00	QQQ	ETF	101.3399	101.3399	101.3399	101.3399	300000.0
2016-02-18 05:00:00	IWM	ETF	100.9	100.92	100.9	100.92	1100.0
2016-02-18 06:00:00	IWM	ETF	101.03	101.22	101.01	101.01	12957.0
2016-02-18 07:00:00	IWM	ETF	101.01	101.09	100.73	100.89	112071.0
2016-02-18 08:00:00	IWM	ETF	100.87	100.96	100.7	100.77	212973.0
2016-02-18 09:00:00	IWM	ETF	100.77	100.77	99.82	100.42	4763036.0
2016-02-18 10:00:00	IWM	ETF	100.41	100.56	100.08	100.31	4016661.0
2016-02-18 11:00:00	IWM	ETF	100.33	100.425	99.78	100.3101	3854170.0
2016-02-18 12:00:00	IWM	ETF	100.31	100.49	100.07	100.145	2070272.0
2016-02-18 13:00:00	IWM	ETF	100.14	100.25	99.54	99.8	4651476.0
2016-02-18 14:00:00	IWM	ETF	99.8099	100.35	99.77	100.19	3656710.0
2016-02-18 15:00:00	IWM	ETF	100.2	100.27	99.79	99.92	5015944.0
2016-02-18 16:00:00	IWM	ETF	99.92	100.14	99.9	100.07	2252076.0
2016-02-18 17:00:00	IWM	ETF	100.12	100.13	100.12	100.13	1485.0
2016-02-18 18:00:00	IWM	ETF	100.06	100.06	100.0	100.0	3000.0
2016-02-18 19:00:00	IWM	ETF	100.05	100.05	100.03	100.03	2800.0
2016-02-18 20:00:00	IWM	ETF	99.9033	99.9033	99.9033	99.9033	190000.0

> showing 50 of 7,908 rows — these rows as CSV

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