PREVIEW / etf_1hour / 2017-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-12.parquet
  size:    278 KB
  rows:    9,126

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-10-12 04:00:00	SPY	ETF	254.77	254.77	254.63	254.63	48000.0
2017-10-12 05:00:00	SPY	ETF	254.63	254.8	254.6	254.78	25850.0
2017-10-12 06:00:00	SPY	ETF	254.8	254.82	254.7	254.7	20300.0
2017-10-12 07:00:00	SPY	ETF	254.74	254.74	254.51	254.59	118536.0
2017-10-12 08:00:00	SPY	ETF	254.7	254.7	254.54	254.56	258812.0
2017-10-12 09:00:00	SPY	ETF	254.56	254.73	254.46	254.5676	4661573.0
2017-10-12 10:00:00	SPY	ETF	254.57	254.959	254.5	254.8	5751088.0
2017-10-12 11:00:00	SPY	ETF	254.8	255.03	254.77	255.01	2693789.0
2017-10-12 12:00:00	SPY	ETF	255.01	255.06	254.78	254.88	3013686.0
2017-10-12 13:00:00	SPY	ETF	254.88	255.05	254.86	254.915	3328981.0
2017-10-12 14:00:00	SPY	ETF	254.915	255.045	254.59	254.71	4520699.0
2017-10-12 15:00:00	SPY	ETF	254.71	254.86	254.365	254.6	14104246.0
2017-10-12 16:00:00	SPY	ETF	254.6	254.85	253.1659	254.59	6623803.0
2017-10-12 17:00:00	SPY	ETF	254.59	254.62	254.53	254.53	115673.0
2017-10-12 18:00:00	SPY	ETF	254.54	254.57	254.51	254.57	149355.0
2017-10-12 19:00:00	SPY	ETF	254.6	254.6	254.46	254.49	66467.0
2017-10-12 04:00:00	QQQ	ETF	147.95	147.95	147.87	147.88	15200.0
2017-10-12 05:00:00	QQQ	ETF	147.91	147.91	147.91	147.91	1900.0
2017-10-12 06:00:00	QQQ	ETF	147.97	147.99	147.95	147.95	1700.0
2017-10-12 07:00:00	QQQ	ETF	147.99	147.99	147.79	147.86	49849.0
2017-10-12 08:00:00	QQQ	ETF	147.96	147.96	147.75	147.76	34686.0
2017-10-12 09:00:00	QQQ	ETF	147.79	148.005	147.66	147.9	2095676.0
2017-10-12 10:00:00	QQQ	ETF	147.9	148.16	147.77	148.0	2067669.0
2017-10-12 11:00:00	QQQ	ETF	148.0	148.22	147.96	148.2	1251335.0
2017-10-12 12:00:00	QQQ	ETF	148.21	148.355	148.04	148.104	1343035.0
2017-10-12 13:00:00	QQQ	ETF	148.1	148.23	148.09	148.121	982519.0
2017-10-12 14:00:00	QQQ	ETF	148.1285	148.195	147.8	147.88	1226852.0
2017-10-12 15:00:00	QQQ	ETF	147.88	148.02	147.615	147.77	3214631.0
2017-10-12 16:00:00	QQQ	ETF	147.78	148.1	147.75	147.82	452985.0
2017-10-12 17:00:00	QQQ	ETF	147.76	147.77	147.68	147.7	12568.0
2017-10-12 18:00:00	QQQ	ETF	147.72	147.8	147.72	147.79	34041.0
2017-10-12 19:00:00	QQQ	ETF	147.79	147.79	147.73	147.75	13423.0
2017-10-12 04:00:00	IWM	ETF	149.51	149.52	149.51	149.52	1946.0
2017-10-12 05:00:00	IWM	ETF	149.5	149.55	149.5	149.55	6000.0
2017-10-12 07:00:00	IWM	ETF	149.54	149.54	149.34	149.38	31257.0
2017-10-12 08:00:00	IWM	ETF	149.41	149.48	149.34	149.46	48532.0
2017-10-12 09:00:00	IWM	ETF	149.39	149.701	149.03	149.2	2325347.0
2017-10-12 10:00:00	IWM	ETF	149.19	149.91	149.02	149.7642	2113529.0
2017-10-12 11:00:00	IWM	ETF	149.77	150.01	149.68	149.71	1321910.0
2017-10-12 12:00:00	IWM	ETF	149.71	149.84	149.54	149.63	719619.0
2017-10-12 13:00:00	IWM	ETF	149.62	149.86	149.61	149.73	611726.0
2017-10-12 14:00:00	IWM	ETF	149.739	149.86	149.55	149.69	845756.0
2017-10-12 15:00:00	IWM	ETF	149.69	149.86	149.44	149.63	2601573.0
2017-10-12 16:00:00	IWM	ETF	149.63	149.76	149.61	149.7	1194507.0
2017-10-12 17:00:00	IWM	ETF	149.7	149.75	149.67	149.67	8132.0
2017-10-12 18:00:00	IWM	ETF	149.68	149.68	149.59	149.61	13930.0
2017-10-12 19:00:00	IWM	ETF	149.5453	149.61	149.5453	149.61	100221.0
2017-10-12 08:00:00	DIA	ETF	228.41	228.44	228.41	228.41	2437.0
2017-10-12 09:00:00	DIA	ETF	228.4	228.51	228.27	228.36	222207.0
2017-10-12 10:00:00	DIA	ETF	228.34	228.63	228.32	228.53	184291.0

> showing 50 of 9,126 rows — these rows as CSV

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