PREVIEW / etf_1hour / 2016-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-24.parquet
  size:    250 KB
  rows:    7,915

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-02-24 04:00:00	SPY	ETF	192.04	192.04	191.06	191.47	40452.0
2016-02-24 05:00:00	SPY	ETF	191.46	191.5	190.8	190.9	98969.0
2016-02-24 06:00:00	SPY	ETF	190.94	191.04	190.55	190.59	236760.0
2016-02-24 07:00:00	SPY	ETF	190.56	190.74	190.2	190.56	687850.0
2016-02-24 08:00:00	SPY	ETF	190.59	192.33	190.28	190.71	1000724.0
2016-02-24 09:00:00	SPY	ETF	190.7	190.7	189.55	189.795	18544917.0
2016-02-24 10:00:00	SPY	ETF	189.8	190.39	189.32	190.18	26296487.0
2016-02-24 11:00:00	SPY	ETF	190.18	191.07	189.59	190.98	19073601.0
2016-02-24 12:00:00	SPY	ETF	190.98	191.43	190.58	191.0201	14209726.0
2016-02-24 13:00:00	SPY	ETF	191.025	191.59	190.97	191.24	14749243.0
2016-02-24 14:00:00	SPY	ETF	191.24	192.66	191.16	192.32	19801424.0
2016-02-24 15:00:00	SPY	ETF	192.32	193.53	192.32	193.22	23649942.0
2016-02-24 16:00:00	SPY	ETF	193.22	193.95	193.18	193.95	3837787.0
2016-02-24 17:00:00	SPY	ETF	193.91	193.94	193.82	193.86	220078.0
2016-02-24 18:00:00	SPY	ETF	193.86	194.24	193.6	194.2	369649.0
2016-02-24 19:00:00	SPY	ETF	194.18	194.43	193.93	194.03	356953.0
2016-02-24 04:00:00	QQQ	ETF	101.4	101.4	100.8	100.8	400.0
2016-02-24 05:00:00	QQQ	ETF	100.79	100.83	100.62	100.7	4870.0
2016-02-24 06:00:00	QQQ	ETF	100.75	100.75	100.34	100.42	60165.0
2016-02-24 07:00:00	QQQ	ETF	100.36	100.43	100.16	100.34	69369.0
2016-02-24 08:00:00	QQQ	ETF	100.37	100.48	100.21	100.44	141014.0
2016-02-24 09:00:00	QQQ	ETF	100.39	100.5	99.87	100.04	5299242.0
2016-02-24 10:00:00	QQQ	ETF	100.035	100.395	99.77	100.28	7022938.0
2016-02-24 11:00:00	QQQ	ETF	100.29	100.94	99.97	100.85	4436740.0
2016-02-24 12:00:00	QQQ	ETF	100.85	101.13	100.69	100.95	3620367.0
2016-02-24 13:00:00	QQQ	ETF	100.96	101.44	100.96	101.29	3133186.0
2016-02-24 14:00:00	QQQ	ETF	101.3	102.2	101.26	101.94	4354531.0
2016-02-24 15:00:00	QQQ	ETF	101.95	102.68	101.94	102.55	7162995.0
2016-02-24 16:00:00	QQQ	ETF	102.54	103.0	102.5	102.98	956016.0
2016-02-24 17:00:00	QQQ	ETF	102.94	102.97	102.88	102.97	45741.0
2016-02-24 18:00:00	QQQ	ETF	102.94	103.11	102.81	103.1	31089.0
2016-02-24 19:00:00	QQQ	ETF	103.08	103.24	103.0	103.09	40618.0
2016-02-24 04:00:00	IWM	ETF	100.25	100.25	99.88	99.95	1700.0
2016-02-24 05:00:00	IWM	ETF	100.02	100.02	99.69	99.69	6200.0
2016-02-24 06:00:00	IWM	ETF	99.85	99.85	99.66	99.66	15360.0
2016-02-24 07:00:00	IWM	ETF	99.6	99.69	99.44	99.58	41463.0
2016-02-24 08:00:00	IWM	ETF	99.66	100.62	99.41	99.57	175594.0
2016-02-24 09:00:00	IWM	ETF	99.52	99.865	99.02	99.17	3647891.0
2016-02-24 10:00:00	IWM	ETF	99.18	99.83	98.97	99.59	4615391.0
2016-02-24 11:00:00	IWM	ETF	99.6025	100.25	99.34	100.16	3196967.0
2016-02-24 12:00:00	IWM	ETF	100.17	100.5523	100.13	100.38	4262298.0
2016-02-24 13:00:00	IWM	ETF	100.385	100.88	100.38	100.64	3027926.0
2016-02-24 14:00:00	IWM	ETF	100.65	101.45	100.64	101.115	5024456.0
2016-02-24 15:00:00	IWM	ETF	101.12	101.819	101.12	101.61	7270114.0
2016-02-24 16:00:00	IWM	ETF	101.62	101.93	101.55	101.91	918687.0
2016-02-24 17:00:00	IWM	ETF	101.89	101.89	101.6	101.86	24291.0
2016-02-24 19:00:00	IWM	ETF	101.91	102.0	101.9	101.99	6350.0
2016-02-24 07:00:00	DIA	ETF	162.5	162.5	162.39	162.39	3769.0
2016-02-24 08:00:00	DIA	ETF	162.75	162.75	162.47	162.61	3671.0
2016-02-24 09:00:00	DIA	ETF	162.52	162.68	161.68	161.8711	865874.0

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

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