PREVIEW / etf_1hour / 2013-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-14.parquet
  size:    196 KB
  rows:    6,141

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
2013-03-14 04:00:00	SPY	ETF	156.33	156.38	156.33	156.33	19354.0
2013-03-14 05:00:00	SPY	ETF	156.33	156.33	156.25	156.25	1800.0
2013-03-14 06:00:00	SPY	ETF	156.28	156.3	156.2	156.22	46341.0
2013-03-14 07:00:00	SPY	ETF	156.23	156.39	156.23	156.38	212933.0
2013-03-14 08:00:00	SPY	ETF	156.39	156.49	156.26	156.45	998820.0
2013-03-14 09:00:00	SPY	ETF	156.45	156.59	156.25	156.56	13208756.0
2013-03-14 10:00:00	SPY	ETF	156.56	156.6	156.22	156.44	14557643.0
2013-03-14 11:00:00	SPY	ETF	156.43	156.55	156.32	156.49	12411262.0
2013-03-14 12:00:00	SPY	ETF	156.48	156.69	156.48	156.53	12698313.0
2013-03-14 13:00:00	SPY	ETF	156.53	156.63	156.37	156.38	10451794.0
2013-03-14 14:00:00	SPY	ETF	156.38	156.57	156.38	156.56	10968609.0
2013-03-14 15:00:00	SPY	ETF	156.57	156.8	156.53	156.73	27843443.0
2013-03-14 16:00:00	SPY	ETF	156.73	156.78	155.9086	156.62	13176267.0
2013-03-14 17:00:00	SPY	ETF	156.6	156.7692	156.51	156.56	3643995.0
2013-03-14 18:00:00	SPY	ETF	156.56	156.64	156.53	156.62	1141749.0
2013-03-14 19:00:00	SPY	ETF	156.64	156.68	156.61	156.67	44628.0
2013-03-14 05:00:00	QQQ	ETF	68.83	68.83	68.83	68.83	8000.0
2013-03-14 06:00:00	QQQ	ETF	68.77	68.77	68.77	68.77	1000.0
2013-03-14 07:00:00	QQQ	ETF	68.78	68.88	68.78	68.88	39286.0
2013-03-14 08:00:00	QQQ	ETF	68.89	68.97	68.86	68.93	304631.0
2013-03-14 09:00:00	QQQ	ETF	68.93	69.01	68.845	68.92	2913208.0
2013-03-14 10:00:00	QQQ	ETF	68.92	68.97	68.718	68.83	3323857.0
2013-03-14 11:00:00	QQQ	ETF	68.83	68.87	68.751	68.84	991209.0
2013-03-14 12:00:00	QQQ	ETF	68.84	68.95	68.835	68.8799	1419246.0
2013-03-14 13:00:00	QQQ	ETF	68.88	68.92	68.76	68.781	1835041.0
2013-03-14 14:00:00	QQQ	ETF	68.78	68.84	68.76	68.84	1941669.0
2013-03-14 15:00:00	QQQ	ETF	68.84	68.885	68.8	68.87	6814647.0
2013-03-14 16:00:00	QQQ	ETF	68.87	68.89	68.83	68.85	4106201.0
2013-03-14 17:00:00	QQQ	ETF	68.84	68.85	68.83	68.85	6300.0
2013-03-14 18:00:00	QQQ	ETF	68.85	68.86	68.83	68.85	14300.0
2013-03-14 19:00:00	QQQ	ETF	68.85	68.89	68.85	68.89	4056.0
2013-03-14 07:00:00	IWM	ETF	94.06	94.13	94.06	94.13	65300.0
2013-03-14 08:00:00	IWM	ETF	94.1	94.15	94.07	94.1	231505.0
2013-03-14 09:00:00	IWM	ETF	94.1	94.3	93.97	94.27	2738607.0
2013-03-14 10:00:00	IWM	ETF	94.265	94.44	94.155	94.4	3148171.0
2013-03-14 11:00:00	IWM	ETF	94.4	94.44	94.315	94.42	979466.0
2013-03-14 12:00:00	IWM	ETF	94.42	94.54	94.41	94.45	1818710.0
2013-03-14 13:00:00	IWM	ETF	94.46	94.52	94.39	94.4445	1315442.0
2013-03-14 14:00:00	IWM	ETF	94.449	94.585	94.44	94.58	1512783.0
2013-03-14 15:00:00	IWM	ETF	94.58	94.81	94.57	94.79	6803852.0
2013-03-14 16:00:00	IWM	ETF	94.78	94.81	94.2	94.8	2506818.0
2013-03-14 17:00:00	IWM	ETF	94.79	94.79	94.72	94.77	18364.0
2013-03-14 18:00:00	IWM	ETF	94.72	94.72	94.72	94.72	1135.0
2013-03-14 19:00:00	IWM	ETF	94.77	94.77	94.74	94.74	2700.0
2013-03-14 04:00:00	DIA	ETF	144.9	144.9	144.9	144.9	100.0
2013-03-14 07:00:00	DIA	ETF	144.75	144.82	144.75	144.8	13311.0
2013-03-14 08:00:00	DIA	ETF	144.82	144.88	144.76	144.88	21495.0
2013-03-14 09:00:00	DIA	ETF	144.85	145.22	144.75	145.16	972444.0
2013-03-14 10:00:00	DIA	ETF	145.16	145.18	144.93	145.08	958890.0
2013-03-14 11:00:00	DIA	ETF	145.08	145.168	145.03	145.13	597634.0

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

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