PREVIEW / etf_1hour / 2014-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-01.parquet
  size:    216 KB
  rows:    6,851

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-05-01 04:00:00	SPY	ETF	188.58	188.58	188.48	188.48	200.0
2014-05-01 05:00:00	SPY	ETF	188.55	188.55	188.52	188.52	200.0
2014-05-01 06:00:00	SPY	ETF	188.49	188.55	188.48	188.55	11850.0
2014-05-01 07:00:00	SPY	ETF	188.55	188.6	188.32	188.34	111132.0
2014-05-01 08:00:00	SPY	ETF	188.34	188.55	188.22	188.26	399411.0
2014-05-01 09:00:00	SPY	ETF	188.24	188.53	188.0	188.15	11764004.0
2014-05-01 10:00:00	SPY	ETF	188.16	188.56	187.73	188.44	18701540.0
2014-05-01 11:00:00	SPY	ETF	188.45	188.84	188.32	188.47	10803915.0
2014-05-01 12:00:00	SPY	ETF	188.47	188.69	188.405	188.53	6476650.0
2014-05-01 13:00:00	SPY	ETF	188.53	188.63	188.0	188.08	10041251.0
2014-05-01 14:00:00	SPY	ETF	188.082	188.39	187.92	188.13	9424833.0
2014-05-01 15:00:00	SPY	ETF	188.13	188.36	187.96	188.32	16342874.0
2014-05-01 16:00:00	SPY	ETF	188.34	188.45	188.22	188.44	6746769.0
2014-05-01 17:00:00	SPY	ETF	188.44	188.5	188.41	188.45	291746.0
2014-05-01 18:00:00	SPY	ETF	188.45	188.5	188.37	188.43	28997.0
2014-05-01 19:00:00	SPY	ETF	188.44	188.48	188.4	188.41	19554.0
2014-05-01 06:00:00	QQQ	ETF	87.65	87.65	87.63	87.63	1000.0
2014-05-01 07:00:00	QQQ	ETF	87.73	87.73	87.53	87.56	72200.0
2014-05-01 08:00:00	QQQ	ETF	87.57	87.6	87.5	87.51	70079.0
2014-05-01 09:00:00	QQQ	ETF	87.49	87.74	87.31	87.58	4521762.0
2014-05-01 10:00:00	QQQ	ETF	87.59	87.96	87.37	87.893	7083567.0
2014-05-01 11:00:00	QQQ	ETF	87.89	88.15	87.79	87.84	5532455.0
2014-05-01 12:00:00	QQQ	ETF	87.84	88.0	87.77	87.86	2730603.0
2014-05-01 13:00:00	QQQ	ETF	87.86	87.93	87.55	87.61	3432115.0
2014-05-01 14:00:00	QQQ	ETF	87.6101	87.77	87.47	87.6	3098147.0
2014-05-01 15:00:00	QQQ	ETF	87.59	87.72	87.48	87.66	4616121.0
2014-05-01 16:00:00	QQQ	ETF	87.67	87.7824	87.3841	87.75	1076496.0
2014-05-01 17:00:00	QQQ	ETF	87.76	87.82	87.3841	87.8	539750.0
2014-05-01 18:00:00	QQQ	ETF	87.77	87.77	87.72	87.74	8330.0
2014-05-01 19:00:00	QQQ	ETF	87.77	87.78	87.73	87.73	3320.0
2014-05-01 07:00:00	IWM	ETF	112.2	112.23	112.1	112.14	48831.0
2014-05-01 08:00:00	IWM	ETF	112.14	112.15	111.86	111.86	183199.0
2014-05-01 09:00:00	IWM	ETF	111.83	111.9	110.89	110.93	7983334.0
2014-05-01 10:00:00	IWM	ETF	110.8901	111.9	110.54	111.7	11054708.0
2014-05-01 11:00:00	IWM	ETF	111.69	112.61	111.55	112.41	6672153.0
2014-05-01 12:00:00	IWM	ETF	112.42	112.77	112.02	112.17	4767992.0
2014-05-01 13:00:00	IWM	ETF	112.17	112.24	110.95	111.055	6759229.0
2014-05-01 14:00:00	IWM	ETF	111.055	111.64	111.03	111.16	7647854.0
2014-05-01 15:00:00	IWM	ETF	111.155	111.89	110.95	111.89	12260349.0
2014-05-01 16:00:00	IWM	ETF	111.89	112.01	111.74	111.91	2551361.0
2014-05-01 17:00:00	IWM	ETF	111.91	111.96	111.85	111.85	64357.0
2014-05-01 18:00:00	IWM	ETF	111.85	111.85	111.8	111.8	9362.0
2014-05-01 19:00:00	IWM	ETF	111.8	111.94	111.8	111.87	1500.0
2014-05-01 08:00:00	DIA	ETF	165.46	165.59	165.4	165.41	7824.0
2014-05-01 09:00:00	DIA	ETF	165.39	165.71	165.14	165.271	452381.0
2014-05-01 10:00:00	DIA	ETF	165.29	165.5	164.97	165.41	813801.0
2014-05-01 11:00:00	DIA	ETF	165.42	165.65	165.27	165.39	559069.0
2014-05-01 12:00:00	DIA	ETF	165.39	165.58	165.345	165.4	266552.0
2014-05-01 13:00:00	DIA	ETF	165.42	165.48	164.92	165.0	419892.0
2014-05-01 14:00:00	DIA	ETF	165.0	165.26	164.9	165.1	397195.0

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

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