PREVIEW / etf_1hour / 2015-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-26.parquet
  size:    263 KB
  rows:    8,353

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
2015-08-26 04:00:00	SPY	ETF	189.3	191.64	189.3	190.57	227907.0
2015-08-26 05:00:00	SPY	ETF	190.56	190.9	190.15	190.34	151631.0
2015-08-26 06:00:00	SPY	ETF	190.45	191.43	190.04	191.32	592855.0
2015-08-26 07:00:00	SPY	ETF	191.3	192.25	191.01	191.13	1974712.0
2015-08-26 08:00:00	SPY	ETF	191.16	193.03	191.04	192.3	5349434.0
2015-08-26 09:00:00	SPY	ETF	192.3	192.59	190.29	190.94	37023229.0
2015-08-26 10:00:00	SPY	ETF	190.92	191.62	189.26	190.23	54107455.0
2015-08-26 11:00:00	SPY	ETF	190.23	190.55	188.77	189.53	41454866.0
2015-08-26 12:00:00	SPY	ETF	189.51	189.79	188.37	189.76	35116160.0
2015-08-26 13:00:00	SPY	ETF	189.76	191.42	189.26	191.27	34517899.0
2015-08-26 14:00:00	SPY	ETF	191.27	192.34	190.03	191.999	33372652.0
2015-08-26 15:00:00	SPY	ETF	192.0	194.79	191.61	194.56	72856177.0
2015-08-26 16:00:00	SPY	ETF	194.55	195.04	189.2725	194.43	18892555.0
2015-08-26 17:00:00	SPY	ETF	194.41	194.88	191.3319	194.88	1500731.0
2015-08-26 18:00:00	SPY	ETF	194.86	194.93	194.61	194.77	269514.0
2015-08-26 19:00:00	SPY	ETF	194.7	195.0	194.48	194.96	133186.0
2015-08-26 04:00:00	QQQ	ETF	98.82	99.91	98.82	99.7	9148.0
2015-08-26 05:00:00	QQQ	ETF	99.65	99.75	99.36	99.55	91602.0
2015-08-26 06:00:00	QQQ	ETF	99.64	100.1	99.36	100.08	60500.0
2015-08-26 07:00:00	QQQ	ETF	100.05	100.61	100.05	100.22	254651.0
2015-08-26 08:00:00	QQQ	ETF	99.68	101.3	99.68	100.96	914779.0
2015-08-26 09:00:00	QQQ	ETF	101.01	101.41	100.22	100.58	10041059.0
2015-08-26 10:00:00	QQQ	ETF	100.59	101.02	99.66	100.255	13767530.0
2015-08-26 11:00:00	QQQ	ETF	100.265	100.33	99.15	99.71	10365706.0
2015-08-26 12:00:00	QQQ	ETF	99.7	99.94	98.93	99.78	8173004.0
2015-08-26 13:00:00	QQQ	ETF	99.78	100.99	99.56	100.9	10692754.0
2015-08-26 14:00:00	QQQ	ETF	100.89	101.63	100.15	101.41	10444231.0
2015-08-26 15:00:00	QQQ	ETF	101.41	103.23	101.175	102.99	20746652.0
2015-08-26 16:00:00	QQQ	ETF	103.0	103.33	102.85	102.87	1651913.0
2015-08-26 17:00:00	QQQ	ETF	102.86	103.15	102.85	103.15	39179.0
2015-08-26 18:00:00	QQQ	ETF	103.15	103.17	102.97	103.08	22785.0
2015-08-26 19:00:00	QQQ	ETF	103.08	103.13	102.91	103.09	137024.0
2015-08-26 04:00:00	IWM	ETF	110.98	111.52	110.98	111.5	1000.0
2015-08-26 05:00:00	IWM	ETF	111.5	111.5	111.2	111.24	2900.0
2015-08-26 06:00:00	IWM	ETF	111.82	111.85	111.82	111.85	1100.0
2015-08-26 07:00:00	IWM	ETF	111.84	112.15	111.5	111.5	193331.0
2015-08-26 08:00:00	IWM	ETF	111.51	112.5	111.47	112.05	284459.0
2015-08-26 09:00:00	IWM	ETF	112.07	112.3	110.4	110.77	5551983.0
2015-08-26 10:00:00	IWM	ETF	110.78	111.1799	110.14	110.32	6136311.0
2015-08-26 11:00:00	IWM	ETF	110.33	110.56	109.79	110.2	5134467.0
2015-08-26 12:00:00	IWM	ETF	110.17	110.36	109.42	110.33	5372384.0
2015-08-26 13:00:00	IWM	ETF	110.31	111.41	110.12	111.17	6193248.0
2015-08-26 14:00:00	IWM	ETF	111.21	111.39	110.39	111.25	4437502.0
2015-08-26 15:00:00	IWM	ETF	111.2776	112.69	111.04	112.4401	10077582.0
2015-08-26 16:00:00	IWM	ETF	112.44	112.74	112.26	112.35	1700512.0
2015-08-26 17:00:00	IWM	ETF	112.44	112.54	112.44	112.54	641000.0
2015-08-26 18:00:00	IWM	ETF	112.48	112.74	112.48	112.74	23300.0
2015-08-26 19:00:00	IWM	ETF	112.6	112.6	112.6	112.6	600.0
2015-08-26 04:00:00	DIA	ETF	159.2	159.79	159.2	159.79	800.0
2015-08-26 06:00:00	DIA	ETF	159.79	159.79	159.79	159.79	1000.0

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

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