PREVIEW / etf_1hour / 2014-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-23.parquet
  size:    208 KB
  rows:    6,652

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-23 04:00:00	SPY	ETF	189.75	189.77	189.69	189.77	32471.0
2014-05-23 05:00:00	SPY	ETF	189.64	189.83	189.64	189.83	10139.0
2014-05-23 06:00:00	SPY	ETF	189.84	189.88	189.72	189.76	4036.0
2014-05-23 07:00:00	SPY	ETF	189.77	189.83	189.72	189.76	126010.0
2014-05-23 08:00:00	SPY	ETF	189.75	189.76	189.7	189.7	231224.0
2014-05-23 09:00:00	SPY	ETF	189.69	189.92	189.58	189.8599	7153056.0
2014-05-23 10:00:00	SPY	ETF	189.85	190.21	189.8	190.18	11103425.0
2014-05-23 11:00:00	SPY	ETF	190.18	190.26	190.09	190.2	6158225.0
2014-05-23 12:00:00	SPY	ETF	190.19	190.34	190.18	190.27	3880550.0
2014-05-23 13:00:00	SPY	ETF	190.27	190.29	190.15	190.24	3607279.0
2014-05-23 14:00:00	SPY	ETF	190.24	190.34	190.18	190.32	4540679.0
2014-05-23 15:00:00	SPY	ETF	190.32	190.48	190.3	190.37	14688451.0
2014-05-23 16:00:00	SPY	ETF	190.38	190.3886	190.199	190.32	8096734.0
2014-05-23 17:00:00	SPY	ETF	190.32	190.32	190.23	190.26	107995.0
2014-05-23 18:00:00	SPY	ETF	190.25	190.25	190.23	190.24	28995.0
2014-05-23 19:00:00	SPY	ETF	190.25	190.26	190.22	190.22	18642.0
2014-05-23 05:00:00	QQQ	ETF	89.39	89.39	89.39	89.39	200.0
2014-05-23 06:00:00	QQQ	ETF	89.4	89.44	89.4	89.44	200.0
2014-05-23 07:00:00	QQQ	ETF	89.35	89.35	89.3	89.3	42290.0
2014-05-23 08:00:00	QQQ	ETF	89.23	89.33	89.23	89.3	45152.0
2014-05-23 09:00:00	QQQ	ETF	89.27	89.48	89.12	89.35	4042478.0
2014-05-23 10:00:00	QQQ	ETF	89.37	89.48	89.3	89.43	3255149.0
2014-05-23 11:00:00	QQQ	ETF	89.43	89.605	89.41	89.57	1935912.0
2014-05-23 12:00:00	QQQ	ETF	89.57	89.66	89.56	89.64	1408525.0
2014-05-23 13:00:00	QQQ	ETF	89.64	89.73	89.6	89.69	1246290.0
2014-05-23 14:00:00	QQQ	ETF	89.69	89.83	89.69	89.805	1485052.0
2014-05-23 15:00:00	QQQ	ETF	89.802	89.9	89.8	89.87	4806848.0
2014-05-23 16:00:00	QQQ	ETF	89.88	89.91	89.4801	89.89	2533354.0
2014-05-23 17:00:00	QQQ	ETF	89.88	89.88	89.85	89.85	1400.0
2014-05-23 18:00:00	QQQ	ETF	89.88	89.88	89.88	89.88	3388.0
2014-05-23 19:00:00	QQQ	ETF	89.87	89.88	89.87	89.88	600.0
2014-05-23 07:00:00	IWM	ETF	110.8	110.82	110.74	110.74	33500.0
2014-05-23 08:00:00	IWM	ETF	110.73	110.73	110.64	110.64	41422.0
2014-05-23 09:00:00	IWM	ETF	110.56	111.09	110.49	110.89	3665260.0
2014-05-23 10:00:00	IWM	ETF	110.891	111.59	110.88	111.39	6053474.0
2014-05-23 11:00:00	IWM	ETF	111.4	111.67	111.21	111.582	2277023.0
2014-05-23 12:00:00	IWM	ETF	111.59	111.8	111.59	111.76	2841883.0
2014-05-23 13:00:00	IWM	ETF	111.76	111.761	111.56	111.68	1696703.0
2014-05-23 14:00:00	IWM	ETF	111.6823	111.865	111.67	111.82	2164949.0
2014-05-23 15:00:00	IWM	ETF	111.829	112.02	111.8	111.96	6060397.0
2014-05-23 16:00:00	IWM	ETF	111.95	111.99	111.48	111.99	1530723.0
2014-05-23 17:00:00	IWM	ETF	111.98	111.98	111.95	111.95	6980.0
2014-05-23 18:00:00	IWM	ETF	111.95	111.95	111.95	111.95	300.0
2014-05-23 19:00:00	IWM	ETF	111.95	111.97	111.9	111.9	990.0
2014-05-23 07:00:00	DIA	ETF	165.25	165.3	165.25	165.25	1500.0
2014-05-23 09:00:00	DIA	ETF	165.2	165.59	165.16	165.51	658513.0
2014-05-23 10:00:00	DIA	ETF	165.51	165.77	165.44	165.67	500135.0
2014-05-23 11:00:00	DIA	ETF	165.67	165.74	165.61	165.66	326675.0
2014-05-23 12:00:00	DIA	ETF	165.66	165.76	165.64	165.65	166213.0
2014-05-23 13:00:00	DIA	ETF	165.65	165.72	165.61	165.71	194373.0

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

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