PREVIEW / etf_1hour / 2016-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-29.parquet
  size:    258 KB
  rows:    8,213

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-29 04:00:00	SPY	ETF	190.13	190.82	190.13	190.58	47311.0
2016-01-29 05:00:00	SPY	ETF	190.54	190.75	189.73	190.0	42190.0
2016-01-29 06:00:00	SPY	ETF	189.92	190.1	189.69	189.99	69095.0
2016-01-29 07:00:00	SPY	ETF	190.04	190.38	189.83	189.84	466073.0
2016-01-29 08:00:00	SPY	ETF	189.99	190.75	189.08	190.14	1713897.0
2016-01-29 09:00:00	SPY	ETF	190.15	191.24	189.81	191.1525	19558994.0
2016-01-29 10:00:00	SPY	ETF	191.15	191.7	190.84	191.05	23787145.0
2016-01-29 11:00:00	SPY	ETF	191.045	191.97	190.99	191.91	22034134.0
2016-01-29 12:00:00	SPY	ETF	191.92	192.5	191.75	192.42	17572577.0
2016-01-29 13:00:00	SPY	ETF	192.42	192.76	192.18	192.52	15194432.0
2016-01-29 14:00:00	SPY	ETF	192.53	192.94	192.21	192.62	15748978.0
2016-01-29 15:00:00	SPY	ETF	192.62	193.75	192.54	193.69	55006171.0
2016-01-29 16:00:00	SPY	ETF	193.71	193.88	193.39	193.7	24862172.0
2016-01-29 17:00:00	SPY	ETF	193.7	194.01	193.66	194.0	3238068.0
2016-01-29 18:00:00	SPY	ETF	193.98	194.01	193.91	193.91	85810.0
2016-01-29 19:00:00	SPY	ETF	193.91	194.05	193.91	194.05	66145.0
2016-01-29 04:00:00	QQQ	ETF	102.06	102.4	102.06	102.4	2250.0
2016-01-29 05:00:00	QQQ	ETF	102.37	102.37	101.9	101.9	11200.0
2016-01-29 06:00:00	QQQ	ETF	102.04	102.07	101.84	101.97	20153.0
2016-01-29 07:00:00	QQQ	ETF	102.01	102.2	101.96	101.99	96912.0
2016-01-29 08:00:00	QQQ	ETF	101.91	102.43	101.64	102.02	766636.0
2016-01-29 09:00:00	QQQ	ETF	102.02	103.01	101.82	102.89	7338847.0
2016-01-29 10:00:00	QQQ	ETF	102.88	103.27	102.67	102.75	6620964.0
2016-01-29 11:00:00	QQQ	ETF	102.75	103.3	102.69	103.21	4730581.0
2016-01-29 12:00:00	QQQ	ETF	103.22	103.65	103.15	103.59	4014996.0
2016-01-29 13:00:00	QQQ	ETF	103.59	103.71	103.37	103.6	3328860.0
2016-01-29 14:00:00	QQQ	ETF	103.595	103.82	103.42	103.5301	3363176.0
2016-01-29 15:00:00	QQQ	ETF	103.54	104.17	103.5176	104.12	11210807.0
2016-01-29 16:00:00	QQQ	ETF	104.13	104.253	104.01	104.2	3664529.0
2016-01-29 17:00:00	QQQ	ETF	104.19	104.29	104.13	104.25	1353498.0
2016-01-29 18:00:00	QQQ	ETF	104.25	104.33	104.25	104.33	9913.0
2016-01-29 19:00:00	QQQ	ETF	104.28	104.29	104.24	104.25	11998.0
2016-01-29 04:00:00	IWM	ETF	99.73	100.45	99.73	100.33	4737.0
2016-01-29 05:00:00	IWM	ETF	100.38	100.38	99.8	99.8	1000.0
2016-01-29 06:00:00	IWM	ETF	99.97	99.97	99.97	99.97	400.0
2016-01-29 07:00:00	IWM	ETF	99.99	100.21	99.9	99.95	80098.0
2016-01-29 08:00:00	IWM	ETF	100.01	100.09	99.78	100.04	165857.0
2016-01-29 09:00:00	IWM	ETF	100.02	101.49	99.89	101.44	5987405.0
2016-01-29 10:00:00	IWM	ETF	101.43	101.81	101.13	101.3	6403492.0
2016-01-29 11:00:00	IWM	ETF	101.32	101.72	101.0	101.34	4674607.0
2016-01-29 12:00:00	IWM	ETF	101.34	101.97	101.24	101.57	3516611.0
2016-01-29 13:00:00	IWM	ETF	101.57	101.72	101.38	101.54	3019836.0
2016-01-29 14:00:00	IWM	ETF	101.535	101.8	101.3	101.639	3531976.0
2016-01-29 15:00:00	IWM	ETF	101.64	102.95	101.61	102.94	9733857.0
2016-01-29 16:00:00	IWM	ETF	102.95	103.0	102.5	102.96	2243579.0
2016-01-29 17:00:00	IWM	ETF	103.0	103.16	102.98	103.1	4382.0
2016-01-29 18:00:00	IWM	ETF	103.07	103.1	103.02	103.02	5186.0
2016-01-29 19:00:00	IWM	ETF	103.15	103.15	102.94	103.0	7282.0
2016-01-29 04:00:00	DIA	ETF	161.9	161.9	161.9	161.9	400.0
2016-01-29 05:00:00	DIA	ETF	161.65	161.65	161.65	161.65	350.0

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

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