PREVIEW / etf_1hour / 2012-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-24.parquet
  size:    188 KB
  rows:    5,793

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
2012-07-24 04:00:00	SPY	ETF	134.74	135.05	134.68	134.95	11000.0
2012-07-24 05:00:00	SPY	ETF	134.94	135.01	134.83	134.93	32850.0
2012-07-24 06:00:00	SPY	ETF	134.89	134.98	134.49	134.68	68627.0
2012-07-24 07:00:00	SPY	ETF	134.64	134.91	134.56	134.7	388380.0
2012-07-24 08:00:00	SPY	ETF	134.7	134.88	134.6	134.87	739258.0
2012-07-24 09:00:00	SPY	ETF	134.87	135.27	134.65	134.66	12717112.0
2012-07-24 10:00:00	SPY	ETF	134.66	135.21	134.13	134.33	18962259.0
2012-07-24 11:00:00	SPY	ETF	134.33	135.1	133.86	133.92	20669884.0
2012-07-24 12:00:00	SPY	ETF	133.92	135.02	133.25	133.72	21227525.0
2012-07-24 13:00:00	SPY	ETF	133.725	134.97	133.36	133.55	11047988.0
2012-07-24 14:00:00	SPY	ETF	133.55	134.95	133.03	133.32	17763506.0
2012-07-24 15:00:00	SPY	ETF	133.32	135.1719	133.05	133.99	44577312.0
2012-07-24 16:00:00	SPY	ETF	134.0	135.1715	132.76	132.84	19470661.0
2012-07-24 17:00:00	SPY	ETF	132.84	133.05	132.82	132.96	1504106.0
2012-07-24 18:00:00	SPY	ETF	132.98	133.02	132.87	132.93	183779.0
2012-07-24 19:00:00	SPY	ETF	132.91	133.06	132.91	132.98	88123.0
2012-07-24 06:00:00	QQQ	ETF	63.24	63.24	63.16	63.23	900.0
2012-07-24 07:00:00	QQQ	ETF	63.2	63.4	63.2	63.27	22297.0
2012-07-24 08:00:00	QQQ	ETF	63.25	63.49	63.25	63.49	572526.0
2012-07-24 09:00:00	QQQ	ETF	63.5	63.66	63.29	63.37	4000799.0
2012-07-24 10:00:00	QQQ	ETF	63.37	63.46	63.14	63.27	5336981.0
2012-07-24 11:00:00	QQQ	ETF	63.275	63.46	63.15	63.17	3780182.0
2012-07-24 12:00:00	QQQ	ETF	63.175	63.18	62.78	63.06	4171303.0
2012-07-24 13:00:00	QQQ	ETF	63.05	63.08	62.83	62.96	2643460.0
2012-07-24 14:00:00	QQQ	ETF	62.97	62.97	62.68	62.77	7275357.0
2012-07-24 15:00:00	QQQ	ETF	62.76	62.99	62.55	62.97	17182161.0
2012-07-24 16:00:00	QQQ	ETF	62.96	63.5116	61.88	61.89	4272453.0
2012-07-24 17:00:00	QQQ	ETF	61.91	62.04	61.89	61.99	313033.0
2012-07-24 18:00:00	QQQ	ETF	62.0	62.0	61.94	61.94	20871.0
2012-07-24 19:00:00	QQQ	ETF	61.95	61.97	61.9	61.9	28846.0
2012-07-24 05:00:00	IWM	ETF	77.65	77.7	77.65	77.67	2700.0
2012-07-24 06:00:00	IWM	ETF	77.67	77.67	77.52	77.55	11400.0
2012-07-24 07:00:00	IWM	ETF	77.55	77.63	77.44	77.47	69499.0
2012-07-24 08:00:00	IWM	ETF	77.47	77.64	77.47	77.64	190116.0
2012-07-24 09:00:00	IWM	ETF	77.64	77.98	77.23	77.33	4214602.0
2012-07-24 10:00:00	IWM	ETF	77.33	77.45	77.04	77.13	7156390.0
2012-07-24 11:00:00	IWM	ETF	77.13	77.36	76.93	76.965	4842701.0
2012-07-24 12:00:00	IWM	ETF	76.97	76.97	76.63	76.86	5171649.0
2012-07-24 13:00:00	IWM	ETF	76.86	76.86	76.48	76.6	3289479.0
2012-07-24 14:00:00	IWM	ETF	76.6	76.63	76.32	76.43	5277508.0
2012-07-24 15:00:00	IWM	ETF	76.42	76.68	76.22	76.68	13725825.0
2012-07-24 16:00:00	IWM	ETF	76.68	76.76	76.01	76.08	3456602.0
2012-07-24 17:00:00	IWM	ETF	76.14	76.25	76.14	76.15	34336.0
2012-07-24 18:00:00	IWM	ETF	76.01	76.22	76.01	76.04	2370.0
2012-07-24 19:00:00	IWM	ETF	76.05	76.22	76.05	76.05	2741.0
2012-07-24 08:00:00	DIA	ETF	126.59	126.67	126.52	126.67	8700.0
2012-07-24 09:00:00	DIA	ETF	126.73	127.01	126.3	126.3	315074.0
2012-07-24 10:00:00	DIA	ETF	126.351	126.414	125.92	126.13	494256.0
2012-07-24 11:00:00	DIA	ETF	126.13	126.3	125.61	125.66	658289.0
2012-07-24 12:00:00	DIA	ETF	125.64	125.64	125.16	125.54	820759.0

> showing 50 of 5,793 rows — these rows as CSV

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