PREVIEW / etf_1hour / 2011-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-08.parquet
  size:    177 KB
  rows:    5,415

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
2011-03-08 04:00:00	SPY	ETF	132.01	132.25	131.95	131.95	9944.0
2011-03-08 05:00:00	SPY	ETF	131.89	132.01	131.7	131.9	22200.0
2011-03-08 06:00:00	SPY	ETF	131.92	132.01	131.74	131.82	27725.0
2011-03-08 07:00:00	SPY	ETF	131.81	131.86	131.45	131.58	447467.0
2011-03-08 08:00:00	SPY	ETF	131.58	131.82	131.27	131.45	2528272.0
2011-03-08 09:00:00	SPY	ETF	131.44	131.75	131.07	131.585	23289052.0
2011-03-08 10:00:00	SPY	ETF	131.59	132.34	131.585	132.23	34443385.0
2011-03-08 11:00:00	SPY	ETF	132.23	132.93	132.0	132.92	22456937.0
2011-03-08 12:00:00	SPY	ETF	132.93	133.0	132.62	132.67	14274125.0
2011-03-08 13:00:00	SPY	ETF	132.67	132.84	132.65	132.76	8733702.0
2011-03-08 14:00:00	SPY	ETF	132.75	132.82	132.37	132.78	14251263.0
2011-03-08 15:00:00	SPY	ETF	132.78	132.9	132.55	132.57	23242828.0
2011-03-08 16:00:00	SPY	ETF	132.57	132.83	131.4082	132.48	18329601.0
2011-03-08 17:00:00	SPY	ETF	132.47	132.52	132.38	132.45	5195292.0
2011-03-08 18:00:00	SPY	ETF	132.45	132.58	132.38	132.54	250491.0
2011-03-08 19:00:00	SPY	ETF	132.48	132.54	132.43	132.49	29647.0
2011-03-08 05:00:00	QQQ	ETF	57.24	57.26	57.16	57.26	12600.0
2011-03-08 06:00:00	QQQ	ETF	57.25	57.29	57.23	57.23	2800.0
2011-03-08 07:00:00	QQQ	ETF	57.22	57.22	57.05	57.12	170298.0
2011-03-08 08:00:00	QQQ	ETF	57.12	57.13	56.93	57.03	801408.0
2011-03-08 09:00:00	QQQ	ETF	57.02	57.17	56.77	57.08	11007391.0
2011-03-08 10:00:00	QQQ	ETF	57.08	57.48	57.08	57.4	13239213.0
2011-03-08 11:00:00	QQQ	ETF	57.3901	57.66	57.3	57.64	9177956.0
2011-03-08 12:00:00	QQQ	ETF	57.645	57.68	57.59	57.61	4138822.0
2011-03-08 13:00:00	QQQ	ETF	57.61	57.66	57.58	57.601	2856184.0
2011-03-08 14:00:00	QQQ	ETF	57.61	57.625	57.32	57.55	6307860.0
2011-03-08 15:00:00	QQQ	ETF	57.56	57.63	57.41	57.42	6024754.0
2011-03-08 16:00:00	QQQ	ETF	57.42	57.43	57.27	57.31	2591582.0
2011-03-08 17:00:00	QQQ	ETF	57.3	57.33	57.26	57.27	1087886.0
2011-03-08 18:00:00	QQQ	ETF	57.3	57.491	57.26	57.35	119763.0
2011-03-08 19:00:00	QQQ	ETF	57.31	57.33	57.28	57.33	52071.0
2011-03-08 04:00:00	IWM	ETF	80.0	81.54	80.0	81.54	212.0
2011-03-08 05:00:00	IWM	ETF	81.41	81.41	81.35	81.35	30000.0
2011-03-08 06:00:00	IWM	ETF	81.34	81.34	81.34	81.34	300.0
2011-03-08 07:00:00	IWM	ETF	81.35	81.35	81.0	81.14	178785.0
2011-03-08 08:00:00	IWM	ETF	81.15	81.76	80.84	81.03	471184.0
2011-03-08 09:00:00	IWM	ETF	81.03	81.27	80.55	81.23	6914791.0
2011-03-08 10:00:00	IWM	ETF	81.22	82.42	81.21	82.31	16587358.0
2011-03-08 11:00:00	IWM	ETF	82.31	82.78	82.18	82.77	10287578.0
2011-03-08 12:00:00	IWM	ETF	82.77	82.81	82.57	82.5912	5146625.0
2011-03-08 13:00:00	IWM	ETF	82.6	82.73	82.57	82.7	2789807.0
2011-03-08 14:00:00	IWM	ETF	82.71	82.73	82.14	82.47	7922950.0
2011-03-08 15:00:00	IWM	ETF	82.47	82.65	82.3675	82.4	9082866.0
2011-03-08 16:00:00	IWM	ETF	82.44	82.645	80.94	82.35	1865166.0
2011-03-08 17:00:00	IWM	ETF	82.35	82.43	82.35	82.38	20310.0
2011-03-08 18:00:00	IWM	ETF	82.38	82.45	82.37	82.45	1200.0
2011-03-08 19:00:00	IWM	ETF	82.45	82.45	82.4	82.4	2700.0
2011-03-08 04:00:00	DIA	ETF	121.12	121.12	121.12	121.12	100.0
2011-03-08 05:00:00	DIA	ETF	121.08	121.08	121.08	121.08	100.0
2011-03-08 07:00:00	DIA	ETF	120.93	120.93	120.72	120.72	400.0

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

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