PREVIEW / etf_1hour / 2011-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-25.parquet
  size:    178 KB
  rows:    5,438

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-25 04:00:00	SPY	ETF	131.3	131.47	131.25	131.25	1300.0
2011-03-25 05:00:00	SPY	ETF	131.4	131.5	131.38	131.5	4300.0
2011-03-25 06:00:00	SPY	ETF	131.49	131.59	131.42	131.43	33550.0
2011-03-25 07:00:00	SPY	ETF	131.49	131.49	131.28	131.31	150279.0
2011-03-25 08:00:00	SPY	ETF	131.32	131.36	131.14	131.2	2412213.0
2011-03-25 09:00:00	SPY	ETF	131.19	131.3	130.94	131.1289	17746730.0
2011-03-25 10:00:00	SPY	ETF	131.12	131.73	131.02	131.69	22279848.0
2011-03-25 11:00:00	SPY	ETF	131.69	131.825	131.61	131.75	18650260.0
2011-03-25 12:00:00	SPY	ETF	131.75	131.87	131.6	131.61	14149114.0
2011-03-25 13:00:00	SPY	ETF	131.61	131.71	131.47	131.54	12055951.0
2011-03-25 14:00:00	SPY	ETF	131.535	131.65	131.33	131.555	12525065.0
2011-03-25 15:00:00	SPY	ETF	131.56	131.62	131.27	131.28	29682025.0
2011-03-25 16:00:00	SPY	ETF	131.28	131.611	130.8921	131.5	22887125.0
2011-03-25 17:00:00	SPY	ETF	131.49	131.53	131.42	131.5	207400.0
2011-03-25 18:00:00	SPY	ETF	131.46	131.53	131.29	131.45	107750.0
2011-03-25 19:00:00	SPY	ETF	131.5	131.58	131.47	131.51	29500.0
2011-03-25 04:00:00	QQQ	ETF	56.99	56.99	56.91	56.93	1598.0
2011-03-25 06:00:00	QQQ	ETF	56.96	56.98	56.94	56.94	4187.0
2011-03-25 07:00:00	QQQ	ETF	56.96	56.98	56.89	56.9	39931.0
2011-03-25 08:00:00	QQQ	ETF	56.9	56.92	56.82	56.86	1369874.0
2011-03-25 09:00:00	QQQ	ETF	56.86	56.94	56.76	56.905	7332301.0
2011-03-25 10:00:00	QQQ	ETF	56.91	57.2	56.78	57.17	15230786.0
2011-03-25 11:00:00	QQQ	ETF	57.1784	57.22	57.09	57.2	5601943.0
2011-03-25 12:00:00	QQQ	ETF	57.19	57.21	57.05	57.07	7307612.0
2011-03-25 13:00:00	QQQ	ETF	57.065	57.12	56.99	57.0	4658859.0
2011-03-25 14:00:00	QQQ	ETF	57.005	57.0186	56.83	56.922	6607371.0
2011-03-25 15:00:00	QQQ	ETF	56.93	56.97	56.81	56.83	9825713.0
2011-03-25 16:00:00	QQQ	ETF	56.83	56.94	56.7898	56.9	3776987.0
2011-03-25 17:00:00	QQQ	ETF	56.93	56.95	56.89	56.93	15400.0
2011-03-25 18:00:00	QQQ	ETF	56.94	56.96	56.94	56.95	1190.0
2011-03-25 19:00:00	QQQ	ETF	56.93	56.94	56.91	56.94	2800.0
2011-03-25 04:00:00	IWM	ETF	81.96	82.04	81.96	82.04	600.0
2011-03-25 06:00:00	IWM	ETF	82.27	82.32	82.27	82.29	9600.0
2011-03-25 07:00:00	IWM	ETF	82.3	82.3	82.11	82.14	66957.0
2011-03-25 08:00:00	IWM	ETF	82.12	82.15	81.63	81.94	1302740.0
2011-03-25 09:00:00	IWM	ETF	81.93	82.02	81.59	81.84	5820589.0
2011-03-25 10:00:00	IWM	ETF	81.84	82.82	81.78	82.76	9113393.0
2011-03-25 11:00:00	IWM	ETF	82.75	83.05	82.75	82.98	9968567.0
2011-03-25 12:00:00	IWM	ETF	82.981	83.06	82.7	82.73	5066261.0
2011-03-25 13:00:00	IWM	ETF	82.74	82.89	82.66	82.72	3448140.0
2011-03-25 14:00:00	IWM	ETF	82.73	82.79	82.48	82.6	6008808.0
2011-03-25 15:00:00	IWM	ETF	82.6	82.77	82.2	82.22	13341433.0
2011-03-25 16:00:00	IWM	ETF	82.22	82.9	82.18	82.31	1608903.0
2011-03-25 17:00:00	IWM	ETF	82.29	82.35	82.27	82.27	21881.0
2011-03-25 18:00:00	IWM	ETF	82.34	82.34	82.32	82.32	1200.0
2011-03-25 19:00:00	IWM	ETF	82.32	82.34	82.31	82.34	8800.0
2011-03-25 07:00:00	DIA	ETF	121.95	121.97	121.9	121.9	5700.0
2011-03-25 08:00:00	DIA	ETF	121.86	121.86	121.7	121.73	16250.0
2011-03-25 09:00:00	DIA	ETF	121.71	121.84	121.6	121.71	380952.0
2011-03-25 10:00:00	DIA	ETF	121.72	122.17	121.62	122.14	708004.0

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

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