PREVIEW / etf_1hour / 2016-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-13.parquet
  size:    259 KB
  rows:    8,221

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-01-13 04:00:00	SPY	ETF	194.82	195.07	194.5	194.51	175289.0
2016-01-13 05:00:00	SPY	ETF	194.53	194.71	194.36	194.52	32915.0
2016-01-13 06:00:00	SPY	ETF	194.46	194.46	193.97	194.11	180783.0
2016-01-13 07:00:00	SPY	ETF	194.13	194.41	193.96	194.05	610995.0
2016-01-13 08:00:00	SPY	ETF	195.44	195.44	193.8	194.55	1835817.0
2016-01-13 09:00:00	SPY	ETF	194.56	194.86	193.6383	194.09	17525928.0
2016-01-13 10:00:00	SPY	ETF	194.1	194.4025	192.84	193.66	25743833.0
2016-01-13 11:00:00	SPY	ETF	193.67	193.9	192.35	192.5	17073816.0
2016-01-13 12:00:00	SPY	ETF	192.49	192.75	191.615	191.74	14627669.0
2016-01-13 13:00:00	SPY	ETF	191.73	192.02	190.25	190.35	21989788.0
2016-01-13 14:00:00	SPY	ETF	190.34	190.7	188.38	189.34	42219261.0
2016-01-13 15:00:00	SPY	ETF	189.34	190.18	188.54	188.84	62997646.0
2016-01-13 16:00:00	SPY	ETF	188.85	189.6153	188.65	188.86	13392383.0
2016-01-13 17:00:00	SPY	ETF	188.88	188.94	188.77	188.93	436280.0
2016-01-13 18:00:00	SPY	ETF	188.99	189.18	188.82	188.85	282316.0
2016-01-13 19:00:00	SPY	ETF	188.84	189.15	188.76	188.86	185653.0
2016-01-13 04:00:00	QQQ	ETF	106.3	106.45	106.13	106.13	22834.0
2016-01-13 05:00:00	QQQ	ETF	106.11	106.22	106.09	106.22	21700.0
2016-01-13 06:00:00	QQQ	ETF	106.08	106.11	105.92	105.95	14554.0
2016-01-13 07:00:00	QQQ	ETF	105.94	106.1	105.87	105.89	30377.0
2016-01-13 08:00:00	QQQ	ETF	105.92	106.25	105.77	106.07	183657.0
2016-01-13 09:00:00	QQQ	ETF	106.05	106.23	105.54	105.65	5753823.0
2016-01-13 10:00:00	QQQ	ETF	105.65	105.81	105.05	105.34	7964300.0
2016-01-13 11:00:00	QQQ	ETF	105.34	105.59	104.53	104.61	5917788.0
2016-01-13 12:00:00	QQQ	ETF	104.6101	104.75	104.08	104.15	4534897.0
2016-01-13 13:00:00	QQQ	ETF	104.1435	104.33	102.92	102.98	5582071.0
2016-01-13 14:00:00	QQQ	ETF	102.98	103.1364	101.75	102.5	12252399.0
2016-01-13 15:00:00	QQQ	ETF	102.52	103.03	101.74	101.9	16190167.0
2016-01-13 16:00:00	QQQ	ETF	101.88	102.2	101.83	102.0	1887178.0
2016-01-13 17:00:00	QQQ	ETF	101.99	102.02	101.86	101.95	60437.0
2016-01-13 18:00:00	QQQ	ETF	102.0	102.15	101.95	101.98	65655.0
2016-01-13 19:00:00	QQQ	ETF	101.93	102.09	101.83	101.95	181811.0
2016-01-13 04:00:00	IWM	ETF	104.3	104.39	104.11	104.11	2700.0
2016-01-13 05:00:00	IWM	ETF	103.98	104.03	103.9	103.9	2520.0
2016-01-13 06:00:00	IWM	ETF	103.92	103.92	103.83	103.9	2520.0
2016-01-13 07:00:00	IWM	ETF	103.76	103.85	103.63	103.63	18391.0
2016-01-13 08:00:00	IWM	ETF	103.65	104.11	103.53	103.95	305905.0
2016-01-13 09:00:00	IWM	ETF	103.95	104.42	103.6	103.7	4638487.0
2016-01-13 10:00:00	IWM	ETF	103.71	103.95	102.71	103.26	7997935.0
2016-01-13 11:00:00	IWM	ETF	103.26	103.49	102.16	102.3299	5101401.0
2016-01-13 12:00:00	IWM	ETF	102.32	102.54	101.74	101.82	4805309.0
2016-01-13 13:00:00	IWM	ETF	101.81	101.97	100.8526	100.94	6406303.0
2016-01-13 14:00:00	IWM	ETF	100.94	101.25	99.65	100.515	14725248.0
2016-01-13 15:00:00	IWM	ETF	100.52	100.96	99.94	100.39	15014174.0
2016-01-13 16:00:00	IWM	ETF	100.38	100.73	100.31	100.47	2208000.0
2016-01-13 17:00:00	IWM	ETF	100.47	100.5	100.37	100.37	117514.0
2016-01-13 18:00:00	IWM	ETF	100.36	100.4	100.15	100.15	9150.0
2016-01-13 19:00:00	IWM	ETF	100.07	100.25	100.07	100.15	4701.0
2016-01-13 20:00:00	IWM	ETF	100.312	100.312	100.312	100.312	230000.0
2016-01-13 04:00:00	DIA	ETF	166.02	166.02	166.02	166.02	100.0

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

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