PREVIEW / etf_1hour / 2011-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-14.parquet
  size:    180 KB
  rows:    5,517

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-10-14 04:00:00	SPY	ETF	120.37	121.29	120.37	121.27	95100.0
2011-10-14 05:00:00	SPY	ETF	121.18	121.52	121.1	121.49	176793.0
2011-10-14 06:00:00	SPY	ETF	121.4	121.52	121.31	121.44	144600.0
2011-10-14 07:00:00	SPY	ETF	121.39	121.5	121.11	121.41	2028126.0
2011-10-14 08:00:00	SPY	ETF	121.41	122.0	120.47	121.66	7261583.0
2011-10-14 09:00:00	SPY	ETF	121.66	122.28	120.47	121.99	33060877.0
2011-10-14 10:00:00	SPY	ETF	122.0	122.06	121.44	121.75	35108157.0
2011-10-14 11:00:00	SPY	ETF	121.75	121.85	121.26	121.371	21618193.0
2011-10-14 12:00:00	SPY	ETF	121.371	121.619	121.23	121.5	12089808.0
2011-10-14 13:00:00	SPY	ETF	121.499	121.95	121.49	121.92	14339764.0
2011-10-14 14:00:00	SPY	ETF	121.92	122.12	121.3	122.1	13845897.0
2011-10-14 15:00:00	SPY	ETF	122.1	122.6	121.91	122.58	45169776.0
2011-10-14 16:00:00	SPY	ETF	122.57	122.74	120.4565	122.7	20292189.0
2011-10-14 17:00:00	SPY	ETF	122.71	122.75	120.4566	122.7	4607361.0
2011-10-14 18:00:00	SPY	ETF	122.7	122.76	122.56	122.69	171387.0
2011-10-14 19:00:00	SPY	ETF	122.69	122.76	122.68	122.73	87512.0
2011-10-14 04:00:00	QQQ	ETF	57.37	57.57	57.37	57.57	1000.0
2011-10-14 05:00:00	QQQ	ETF	57.57	57.7	57.56	57.65	3807.0
2011-10-14 06:00:00	QQQ	ETF	57.63	57.65	57.57	57.57	1000.0
2011-10-14 07:00:00	QQQ	ETF	57.62	57.62	57.48	57.62	144647.0
2011-10-14 08:00:00	QQQ	ETF	57.6	57.88	57.52	57.77	3625810.0
2011-10-14 09:00:00	QQQ	ETF	57.76	58.04	57.76	57.94	12181362.0
2011-10-14 10:00:00	QQQ	ETF	57.93	58.03	57.69	57.83	9448888.0
2011-10-14 11:00:00	QQQ	ETF	57.83	57.91	57.51	57.64	9754222.0
2011-10-14 12:00:00	QQQ	ETF	57.6307	57.74	57.55	57.64	3626777.0
2011-10-14 13:00:00	QQQ	ETF	57.64	57.92	57.64	57.88	4043609.0
2011-10-14 14:00:00	QQQ	ETF	57.87	58.0	57.8	57.98	3611454.0
2011-10-14 15:00:00	QQQ	ETF	57.98	58.18	57.89	58.17	14193723.0
2011-10-14 16:00:00	QQQ	ETF	58.19	59.35	58.0602	58.3	1696707.0
2011-10-14 17:00:00	QQQ	ETF	58.29	58.29	58.22	58.22	256056.0
2011-10-14 18:00:00	QQQ	ETF	58.23	58.27	58.21	58.21	10349.0
2011-10-14 19:00:00	QQQ	ETF	58.22	58.26	58.2	58.26	18154.0
2011-10-14 06:00:00	IWM	ETF	70.29	70.29	70.17	70.29	37200.0
2011-10-14 07:00:00	IWM	ETF	70.25	70.27	70.09	70.21	40080.0
2011-10-14 08:00:00	IWM	ETF	70.25	70.59	69.73	70.31	3116841.0
2011-10-14 09:00:00	IWM	ETF	70.32	70.71	70.31	70.54	10390899.0
2011-10-14 10:00:00	IWM	ETF	70.54	70.58	70.05	70.44	7025376.0
2011-10-14 11:00:00	IWM	ETF	70.44	70.52	70.06	70.09	3883169.0
2011-10-14 12:00:00	IWM	ETF	70.08	70.25	69.9	70.12	3007892.0
2011-10-14 13:00:00	IWM	ETF	70.13	70.74	70.12	70.69	5086356.0
2011-10-14 14:00:00	IWM	ETF	70.69	70.97	70.52	70.96	4462683.0
2011-10-14 15:00:00	IWM	ETF	70.96	71.34	70.78	71.15	16266775.0
2011-10-14 16:00:00	IWM	ETF	71.15	71.3443	69.8052	71.23	5804588.0
2011-10-14 17:00:00	IWM	ETF	71.23	71.44	69.8052	71.44	1087844.0
2011-10-14 18:00:00	IWM	ETF	71.3	71.3	71.28	71.28	573.0
2011-10-14 19:00:00	IWM	ETF	71.23	71.23	71.23	71.23	400.0
2011-10-14 05:00:00	DIA	ETF	115.18	115.41	115.18	115.39	1200.0
2011-10-14 07:00:00	DIA	ETF	115.18	115.3	115.18	115.3	1112.0
2011-10-14 08:00:00	DIA	ETF	115.44	115.8	115.38	115.56	20840.0
2011-10-14 09:00:00	DIA	ETF	115.61	116.01	115.59	115.79	659206.0

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

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