PREVIEW / etf_1hour / 2016-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-15.parquet
  size:    248 KB
  rows:    7,963

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-06-15 04:00:00	SPY	ETF	208.25	208.64	208.17	208.48	45266.0
2016-06-15 05:00:00	SPY	ETF	208.66	208.75	208.49	208.58	13582.0
2016-06-15 06:00:00	SPY	ETF	208.57	208.64	208.41	208.51	66347.0
2016-06-15 07:00:00	SPY	ETF	208.48	208.5	208.27	208.42	419731.0
2016-06-15 08:00:00	SPY	ETF	208.38	208.56	207.69	208.38	642391.0
2016-06-15 09:00:00	SPY	ETF	208.38	208.79	208.15	208.64	10732148.0
2016-06-15 10:00:00	SPY	ETF	208.64	208.95	208.59	208.7189	12223593.0
2016-06-15 11:00:00	SPY	ETF	208.72	208.93	208.41	208.71	10317042.0
2016-06-15 12:00:00	SPY	ETF	208.71	208.75	208.42	208.43	7890647.0
2016-06-15 13:00:00	SPY	ETF	208.43	208.91	208.42	208.8	6538177.0
2016-06-15 14:00:00	SPY	ETF	208.82	209.36	208.27	208.8	20905356.0
2016-06-15 15:00:00	SPY	ETF	208.8	208.92	207.53	207.75	25986419.0
2016-06-15 16:00:00	SPY	ETF	207.75	207.82	207.59	207.65	8198812.0
2016-06-15 17:00:00	SPY	ETF	207.63	207.78	207.51	207.63	4105943.0
2016-06-15 18:00:00	SPY	ETF	207.64	207.65	207.44	207.6	94475.0
2016-06-15 19:00:00	SPY	ETF	207.6	207.89	207.55	207.82	130327.0
2016-06-15 04:00:00	QQQ	ETF	108.17	108.41	108.17	108.41	5799.0
2016-06-15 05:00:00	QQQ	ETF	108.42	108.43	108.32	108.34	51198.0
2016-06-15 06:00:00	QQQ	ETF	108.35	108.41	108.25	108.33	11630.0
2016-06-15 07:00:00	QQQ	ETF	108.31	108.31	108.2	108.27	76391.0
2016-06-15 08:00:00	QQQ	ETF	108.25	108.34	108.03	108.25	138973.0
2016-06-15 09:00:00	QQQ	ETF	108.23	108.36	108.13	108.2	1910598.0
2016-06-15 10:00:00	QQQ	ETF	108.19	108.37	108.019	108.22	2136920.0
2016-06-15 11:00:00	QQQ	ETF	108.22	108.3311	107.92	108.21	1800140.0
2016-06-15 12:00:00	QQQ	ETF	108.2	108.22	108.0167	108.0167	1019350.0
2016-06-15 13:00:00	QQQ	ETF	108.02	108.25	108.02	108.21	1087507.0
2016-06-15 14:00:00	QQQ	ETF	108.26	108.44	107.96	108.26	4556476.0
2016-06-15 15:00:00	QQQ	ETF	108.26	108.31	107.54	107.72	4580865.0
2016-06-15 16:00:00	QQQ	ETF	107.71	107.78	107.64	107.69	611616.0
2016-06-15 17:00:00	QQQ	ETF	107.67	107.69	107.65	107.67	25182.0
2016-06-15 18:00:00	QQQ	ETF	107.67	107.7	107.61	107.67	33111.0
2016-06-15 19:00:00	QQQ	ETF	107.69	107.8	107.69	107.78	9698.0
2016-06-15 04:00:00	IWM	ETF	114.46	114.9	114.46	114.88	2267.0
2016-06-15 05:00:00	IWM	ETF	114.89	114.94	114.88	114.88	9918.0
2016-06-15 06:00:00	IWM	ETF	114.82	114.82	114.7	114.74	5100.0
2016-06-15 07:00:00	IWM	ETF	114.69	114.85	114.62	114.82	116399.0
2016-06-15 08:00:00	IWM	ETF	114.8	114.97	114.8	114.85	199044.0
2016-06-15 09:00:00	IWM	ETF	114.82	114.89	114.49	114.7	2196420.0
2016-06-15 10:00:00	IWM	ETF	114.7	115.3	114.7	115.1801	3522706.0
2016-06-15 11:00:00	IWM	ETF	115.18	115.4	114.98	115.34	1930700.0
2016-06-15 12:00:00	IWM	ETF	115.335	115.46	115.23	115.23	1931944.0
2016-06-15 13:00:00	IWM	ETF	115.24	115.456	115.17	115.34	1338552.0
2016-06-15 14:00:00	IWM	ETF	115.36	115.56	114.78	115.23	5208029.0
2016-06-15 15:00:00	IWM	ETF	115.23	115.38	114.46	114.57	5017484.0
2016-06-15 16:00:00	IWM	ETF	114.56	114.59	114.4	114.46	421760.0
2016-06-15 17:00:00	IWM	ETF	114.45	116.62	114.31	114.35	45865.0
2016-06-15 18:00:00	IWM	ETF	114.34	114.36	114.34	114.35	14500.0
2016-06-15 19:00:00	IWM	ETF	114.44	114.55	114.44	114.52	11089.0
2016-06-15 04:00:00	DIA	ETF	177.3	177.3	177.3	177.3	100.0
2016-06-15 07:00:00	DIA	ETF	177.09	177.09	177.09	177.09	240.0

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

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