PREVIEW / etf_1hour / 2017-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-04.parquet
  size:    271 KB
  rows:    8,741

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-04-04 04:00:00	SPY	ETF	234.76	234.88	234.6	234.8	7940.0
2017-04-04 05:00:00	SPY	ETF	234.75	234.8	234.7	234.8	7303.0
2017-04-04 06:00:00	SPY	ETF	234.85	235.07	234.85	234.93	33746.0
2017-04-04 07:00:00	SPY	ETF	235.03	235.07	234.49	234.56	217550.0
2017-04-04 08:00:00	SPY	ETF	234.76	235.03	234.41	234.7	590277.0
2017-04-04 09:00:00	SPY	ETF	234.72	235.33	234.71	235.06	7192632.0
2017-04-04 10:00:00	SPY	ETF	235.06	235.15	234.555	234.885	9982806.0
2017-04-04 11:00:00	SPY	ETF	234.87	235.51	234.83	235.315	5664158.0
2017-04-04 12:00:00	SPY	ETF	235.31	235.43	235.02	235.07	4133709.0
2017-04-04 13:00:00	SPY	ETF	235.05	235.33	234.94	235.27	3334792.0
2017-04-04 14:00:00	SPY	ETF	235.275	235.54	235.23	235.245	4438993.0
2017-04-04 15:00:00	SPY	ETF	235.24	235.58	235.11	235.51	11787712.0
2017-04-04 16:00:00	SPY	ETF	235.52	235.76	235.2115	235.73	7660373.0
2017-04-04 17:00:00	SPY	ETF	235.73	235.76	235.7	235.73	88221.0
2017-04-04 18:00:00	SPY	ETF	235.74	235.83	235.73	235.74	122759.0
2017-04-04 19:00:00	SPY	ETF	235.74	235.78	235.71	235.74	25969.0
2017-04-04 04:00:00	QQQ	ETF	131.99	131.99	131.87	131.94	4600.0
2017-04-04 05:00:00	QQQ	ETF	131.95	131.95	131.9	131.9	500.0
2017-04-04 06:00:00	QQQ	ETF	132.06	132.06	132.03	132.03	400.0
2017-04-04 07:00:00	QQQ	ETF	131.99	132.03	131.73	131.73	35744.0
2017-04-04 08:00:00	QQQ	ETF	131.76	132.0	131.66	131.81	99289.0
2017-04-04 09:00:00	QQQ	ETF	131.82	132.35	131.81	132.15	2066170.0
2017-04-04 10:00:00	QQQ	ETF	132.159	132.24	131.87	132.035	2050652.0
2017-04-04 11:00:00	QQQ	ETF	132.03	132.39	132.01	132.23	1272921.0
2017-04-04 12:00:00	QQQ	ETF	132.23	132.32	132.13	132.159	1225411.0
2017-04-04 13:00:00	QQQ	ETF	132.15	132.33	132.07	132.26	895625.0
2017-04-04 14:00:00	QQQ	ETF	132.26	132.46	132.25	132.315	1124490.0
2017-04-04 15:00:00	QQQ	ETF	132.31	132.53	132.28	132.5	2089799.0
2017-04-04 16:00:00	QQQ	ETF	132.51	132.65	132.5	132.64	404811.0
2017-04-04 17:00:00	QQQ	ETF	132.61	132.63	132.6	132.61	7552.0
2017-04-04 18:00:00	QQQ	ETF	132.62	132.64	132.58	132.63	15536.0
2017-04-04 19:00:00	QQQ	ETF	132.59	132.63	132.59	132.62	1857.0
2017-04-04 04:00:00	IWM	ETF	135.85	135.85	135.5	135.5	2168.0
2017-04-04 05:00:00	IWM	ETF	135.66	135.66	135.63	135.63	6000.0
2017-04-04 06:00:00	IWM	ETF	135.9	135.9	135.9	135.9	3000.0
2017-04-04 07:00:00	IWM	ETF	135.85	135.85	135.38	135.5	80200.0
2017-04-04 08:00:00	IWM	ETF	135.5	135.69	135.33	135.57	350943.0
2017-04-04 09:00:00	IWM	ETF	135.62	136.55	135.62	136.29	2920162.0
2017-04-04 10:00:00	IWM	ETF	136.3	136.44	135.835	135.94	3533501.0
2017-04-04 11:00:00	IWM	ETF	135.93	136.47	135.92	136.18	1907672.0
2017-04-04 12:00:00	IWM	ETF	136.19	136.22	135.63	135.71	2189442.0
2017-04-04 13:00:00	IWM	ETF	135.71	135.89	135.54	135.87	1994656.0
2017-04-04 14:00:00	IWM	ETF	135.86	136.1	135.69	135.69	2012582.0
2017-04-04 15:00:00	IWM	ETF	135.7	135.89	135.35	135.89	4928124.0
2017-04-04 16:00:00	IWM	ETF	135.89	136.2	135.6127	136.2	1308413.0
2017-04-04 17:00:00	IWM	ETF	136.19	136.19	136.15	136.16	4891.0
2017-04-04 18:00:00	IWM	ETF	136.17	136.17	136.17	136.17	1600.0
2017-04-04 19:00:00	IWM	ETF	136.18	136.18	136.14	136.15	4204.0
2017-04-04 07:00:00	DIA	ETF	205.83	205.83	205.83	205.83	250.0
2017-04-04 08:00:00	DIA	ETF	205.7	205.7	205.48	205.48	4152.0

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

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