PREVIEW / etf_1hour / 2016-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-03.parquet
  size:    254 KB
  rows:    8,129

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-03 04:00:00	SPY	ETF	190.96	191.49	190.32	190.41	71334.0
2016-02-03 05:00:00	SPY	ETF	190.48	190.68	190.0	190.04	81407.0
2016-02-03 06:00:00	SPY	ETF	190.04	191.0	190.04	190.71	89166.0
2016-02-03 07:00:00	SPY	ETF	190.79	191.23	190.31	190.44	496111.0
2016-02-03 08:00:00	SPY	ETF	190.76	191.54	189.56	191.36	2003572.0
2016-02-03 09:00:00	SPY	ETF	191.36	191.64	189.98	190.08	16077461.0
2016-02-03 10:00:00	SPY	ETF	190.08	190.08	187.1	188.93	49597995.0
2016-02-03 11:00:00	SPY	ETF	188.93	189.82	187.76	189.26	29840008.0
2016-02-03 12:00:00	SPY	ETF	189.28	189.62	188.44	189.2	16672296.0
2016-02-03 13:00:00	SPY	ETF	189.2	189.5	187.97	187.985	13246166.0
2016-02-03 14:00:00	SPY	ETF	187.985	191.44	187.98	191.34	35094310.0
2016-02-03 15:00:00	SPY	ETF	191.34	191.78	190.3	191.19	33986971.0
2016-02-03 16:00:00	SPY	ETF	191.19	191.48	190.21	191.41	6199701.0
2016-02-03 17:00:00	SPY	ETF	191.4	191.48	191.35	191.36	144023.0
2016-02-03 18:00:00	SPY	ETF	191.36	191.74	191.22	191.41	179302.0
2016-02-03 19:00:00	SPY	ETF	191.49	191.6	191.21	191.27	127959.0
2016-02-03 04:00:00	QQQ	ETF	102.5	102.73	102.08	102.08	3200.0
2016-02-03 05:00:00	QQQ	ETF	102.03	102.24	101.9	102.01	12100.0
2016-02-03 06:00:00	QQQ	ETF	102.11	102.48	102.11	102.35	10300.0
2016-02-03 07:00:00	QQQ	ETF	102.42	102.63	102.2	102.24	65739.0
2016-02-03 08:00:00	QQQ	ETF	102.24	102.84	102.21	102.75	229545.0
2016-02-03 09:00:00	QQQ	ETF	102.77	102.91	101.78	101.85	5368098.0
2016-02-03 10:00:00	QQQ	ETF	101.84	101.84	100.04	101.06	14204625.0
2016-02-03 11:00:00	QQQ	ETF	101.06	101.4	100.23	101.08	9242180.0
2016-02-03 12:00:00	QQQ	ETF	101.08	101.3156	100.36	100.8	4873368.0
2016-02-03 13:00:00	QQQ	ETF	100.795	101.0	99.88	99.88	4253208.0
2016-02-03 14:00:00	QQQ	ETF	99.89	102.04	99.89	101.99	9695490.0
2016-02-03 15:00:00	QQQ	ETF	101.98	102.22	101.28	101.66	7307016.0
2016-02-03 16:00:00	QQQ	ETF	101.67	101.88	101.3696	101.86	570273.0
2016-02-03 17:00:00	QQQ	ETF	101.84	101.89	101.65	101.81	57751.0
2016-02-03 18:00:00	QQQ	ETF	101.8	102.0	101.72	101.9	68264.0
2016-02-03 19:00:00	QQQ	ETF	101.9	102.0	101.76	101.78	22744.0
2016-02-03 04:00:00	IWM	ETF	100.83	100.93	100.83	100.93	209.0
2016-02-03 05:00:00	IWM	ETF	100.45	100.45	100.44	100.44	4000.0
2016-02-03 06:00:00	IWM	ETF	100.67	100.7	100.42	100.42	3898.0
2016-02-03 07:00:00	IWM	ETF	100.53	100.77	100.32	100.42	114042.0
2016-02-03 08:00:00	IWM	ETF	100.7	101.17	100.34	101.09	244303.0
2016-02-03 09:00:00	IWM	ETF	101.13	101.25	99.68	99.77	4339500.0
2016-02-03 10:00:00	IWM	ETF	99.75	99.765	98.14	99.34	12302990.0
2016-02-03 11:00:00	IWM	ETF	99.35	100.035	98.55	99.705	7720695.0
2016-02-03 12:00:00	IWM	ETF	99.71	100.055	99.405	99.71	4998295.0
2016-02-03 13:00:00	IWM	ETF	99.7	99.82	98.79	98.855	4344791.0
2016-02-03 14:00:00	IWM	ETF	98.85	100.57	98.85	100.51	8230371.0
2016-02-03 15:00:00	IWM	ETF	100.5	100.66	100.0	100.4	7847979.0
2016-02-03 16:00:00	IWM	ETF	100.42	100.43	99.76	100.39	815366.0
2016-02-03 17:00:00	IWM	ETF	100.39	100.44	100.39	100.44	2000.0
2016-02-03 18:00:00	IWM	ETF	100.48	100.54	100.4	100.54	9620.0
2016-02-03 19:00:00	IWM	ETF	100.26	100.35	100.26	100.26	2050.0
2016-02-03 07:00:00	DIA	ETF	162.11	162.11	161.7	161.71	1075.0
2016-02-03 08:00:00	DIA	ETF	161.63	162.37	161.63	162.36	68182.0

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

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