PREVIEW / etf_1hour / 2014-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-21.parquet
  size:    211 KB
  rows:    6,720

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
2014-04-21 05:00:00	SPY	ETF	186.58	186.58	186.54	186.54	3380.0
2014-04-21 06:00:00	SPY	ETF	186.53	186.61	186.49	186.59	3600.0
2014-04-21 07:00:00	SPY	ETF	186.61	186.69	186.55	186.58	73279.0
2014-04-21 08:00:00	SPY	ETF	186.58	186.67	186.3	186.44	746524.0
2014-04-21 09:00:00	SPY	ETF	186.44	186.84	186.34	186.77	7709756.0
2014-04-21 10:00:00	SPY	ETF	186.77	187.0	186.21	186.45	11633967.0
2014-04-21 11:00:00	SPY	ETF	186.45	186.86	186.38	186.83	6812152.0
2014-04-21 12:00:00	SPY	ETF	186.82	186.91	186.66	186.8	4361262.0
2014-04-21 13:00:00	SPY	ETF	186.8	186.97	186.72	186.97	4694814.0
2014-04-21 14:00:00	SPY	ETF	186.98	187.1	186.9	187.055	6627322.0
2014-04-21 15:00:00	SPY	ETF	187.06	187.08	186.79	187.05	12535321.0
2014-04-21 16:00:00	SPY	ETF	187.06	187.12	186.95	187.02	4584061.0
2014-04-21 17:00:00	SPY	ETF	187.03	187.11	186.97	187.05	189178.0
2014-04-21 18:00:00	SPY	ETF	187.03	187.12	187.02	187.08	38519.0
2014-04-21 19:00:00	SPY	ETF	187.06	187.07	187.05	187.07	77620.0
2014-04-21 06:00:00	QQQ	ETF	86.37	86.37	86.37	86.37	200.0
2014-04-21 07:00:00	QQQ	ETF	86.36	86.44	86.36	86.44	1900.0
2014-04-21 08:00:00	QQQ	ETF	86.36	86.47	86.32	86.36	131430.0
2014-04-21 09:00:00	QQQ	ETF	86.35	86.6	86.22	86.43	4665015.0
2014-04-21 10:00:00	QQQ	ETF	86.42	86.73	86.0	86.2701	6258103.0
2014-04-21 11:00:00	QQQ	ETF	86.27	86.62	86.22	86.57	2572253.0
2014-04-21 12:00:00	QQQ	ETF	86.575	86.63	86.44	86.59	1705967.0
2014-04-21 13:00:00	QQQ	ETF	86.6	86.75	86.53	86.75	1895264.0
2014-04-21 14:00:00	QQQ	ETF	86.74	86.84	86.69	86.81	2072642.0
2014-04-21 15:00:00	QQQ	ETF	86.82	86.84	86.63	86.83	3758480.0
2014-04-21 16:00:00	QQQ	ETF	86.84	86.92	86.4909	86.91	769486.0
2014-04-21 17:00:00	QQQ	ETF	86.89	86.9	86.85	86.89	2750.0
2014-04-21 18:00:00	QQQ	ETF	86.9	86.93	86.9	86.91	19005.0
2014-04-21 19:00:00	QQQ	ETF	86.9	86.92	86.9	86.9	39424.0
2014-04-21 05:00:00	IWM	ETF	112.91	112.91	112.91	112.91	347.0
2014-04-21 06:00:00	IWM	ETF	113.03	113.03	113.03	113.03	300.0
2014-04-21 07:00:00	IWM	ETF	113.18	113.2	113.11	113.11	5585.0
2014-04-21 08:00:00	IWM	ETF	113.17	113.17	112.96	112.99	129000.0
2014-04-21 09:00:00	IWM	ETF	113.01	113.32	112.84	113.219	3524784.0
2014-04-21 10:00:00	IWM	ETF	113.22	113.53	112.28	112.74	5417569.0
2014-04-21 11:00:00	IWM	ETF	112.74	113.3	112.62	113.25	3699811.0
2014-04-21 12:00:00	IWM	ETF	113.24	113.3	112.88	113.08	1321248.0
2014-04-21 13:00:00	IWM	ETF	113.08	113.21	112.98	113.19	1085407.0
2014-04-21 14:00:00	IWM	ETF	113.19	113.37	113.0	113.26	2153067.0
2014-04-21 15:00:00	IWM	ETF	113.27	113.47	113.07	113.46	3130977.0
2014-04-21 16:00:00	IWM	ETF	113.46	113.55	112.54	113.55	7020940.0
2014-04-21 18:00:00	IWM	ETF	113.45	113.47	113.45	113.47	1000.0
2014-04-21 19:00:00	IWM	ETF	113.45	113.49	113.36	113.48	11900.0
2014-04-21 08:00:00	DIA	ETF	163.78	163.78	163.77	163.77	430.0
2014-04-21 09:00:00	DIA	ETF	163.94	164.18	163.72	164.1	676825.0
2014-04-21 10:00:00	DIA	ETF	164.08	164.25	163.7	163.8054	493793.0
2014-04-21 11:00:00	DIA	ETF	163.8	164.07	163.76	163.975	364225.0
2014-04-21 12:00:00	DIA	ETF	163.98	164.06	163.9	164.01	327878.0
2014-04-21 13:00:00	DIA	ETF	164.02	164.11	163.92	164.1	116635.0
2014-04-21 14:00:00	DIA	ETF	164.11	164.19	164.032	164.135	336905.0

> showing 50 of 6,720 rows — these rows as CSV

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