PREVIEW / etf_1hour / 2011-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-16.parquet
  size:    186 KB
  rows:    5,723

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-08-16 04:00:00	SPY	ETF	119.76	119.76	118.78	118.85	27635.0
2011-08-16 05:00:00	SPY	ETF	118.95	119.26	118.92	119.17	43465.0
2011-08-16 06:00:00	SPY	ETF	119.16	119.16	118.61	118.64	265410.0
2011-08-16 07:00:00	SPY	ETF	118.72	119.06	118.66	118.78	671969.0
2011-08-16 08:00:00	SPY	ETF	118.82	120.24	118.5	118.98	4444739.0
2011-08-16 09:00:00	SPY	ETF	118.96	119.84	118.94	119.23	32388696.0
2011-08-16 10:00:00	SPY	ETF	119.23	120.13	119.14	120.111	34076209.0
2011-08-16 11:00:00	SPY	ETF	120.115	120.33	119.64	120.2	19986758.0
2011-08-16 12:00:00	SPY	ETF	120.21	120.69	119.02	119.14	57417529.0
2011-08-16 13:00:00	SPY	ETF	119.14	119.4	118.31	119.26	36426273.0
2011-08-16 14:00:00	SPY	ETF	119.26	119.82	118.93	119.005	34589370.0
2011-08-16 15:00:00	SPY	ETF	119.005	120.15	118.95	119.57	45270979.0
2011-08-16 16:00:00	SPY	ETF	119.57	120.732	118.54	119.71	26809862.0
2011-08-16 17:00:00	SPY	ETF	119.7	119.75	119.5	119.53	310736.0
2011-08-16 18:00:00	SPY	ETF	119.54	119.6	119.16	119.16	577104.0
2011-08-16 19:00:00	SPY	ETF	119.18	119.33	119.16	119.32	67739.0
2011-08-16 04:00:00	QQQ	ETF	53.96	53.96	53.51	53.51	49943.0
2011-08-16 05:00:00	QQQ	ETF	53.57	53.6	53.57	53.6	1100.0
2011-08-16 06:00:00	QQQ	ETF	53.6	53.6	53.5	53.55	4789.0
2011-08-16 07:00:00	QQQ	ETF	53.54	53.66	53.52	53.57	64150.0
2011-08-16 08:00:00	QQQ	ETF	53.6	53.68	53.48	53.66	1447191.0
2011-08-16 09:00:00	QQQ	ETF	53.66	53.97	53.65	53.73	9955710.0
2011-08-16 10:00:00	QQQ	ETF	53.72	54.22	53.68	54.21	9208158.0
2011-08-16 11:00:00	QQQ	ETF	54.21	54.211	53.96	54.125	4660717.0
2011-08-16 12:00:00	QQQ	ETF	54.123	54.35	53.53	53.57	22396483.0
2011-08-16 13:00:00	QQQ	ETF	53.58	53.76	53.18	53.69	13292678.0
2011-08-16 14:00:00	QQQ	ETF	53.69	53.85	53.55	53.57	9491332.0
2011-08-16 15:00:00	QQQ	ETF	53.57	54.15	53.54	53.88	12798317.0
2011-08-16 16:00:00	QQQ	ETF	53.89	54.09	53.88	53.92	2092248.0
2011-08-16 17:00:00	QQQ	ETF	53.92	53.94	53.86	53.87	46426.0
2011-08-16 18:00:00	QQQ	ETF	53.9	53.91	53.76	53.76	52677.0
2011-08-16 19:00:00	QQQ	ETF	53.77	53.8	53.63	53.63	27513.0
2011-08-16 04:00:00	IWM	ETF	71.18	71.18	70.47	70.58	19103.0
2011-08-16 06:00:00	IWM	ETF	70.79	70.79	70.4	70.44	14100.0
2011-08-16 07:00:00	IWM	ETF	70.46	70.76	70.4	70.58	111731.0
2011-08-16 08:00:00	IWM	ETF	70.62	70.75	70.38	70.64	1066553.0
2011-08-16 09:00:00	IWM	ETF	70.63	71.14	70.11	70.38	12674099.0
2011-08-16 10:00:00	IWM	ETF	70.37	71.1	70.24	71.069	8395610.0
2011-08-16 11:00:00	IWM	ETF	71.08	71.14	70.69	71.04	5453746.0
2011-08-16 12:00:00	IWM	ETF	71.04	71.41	70.2	70.3	13191261.0
2011-08-16 13:00:00	IWM	ETF	70.31	70.6	69.66	70.44	8680706.0
2011-08-16 14:00:00	IWM	ETF	70.448	70.83	70.1	70.15	6657813.0
2011-08-16 15:00:00	IWM	ETF	70.14	71.03	70.1	70.43	11825146.0
2011-08-16 16:00:00	IWM	ETF	70.44	71.8484	70.44	70.67	2859403.0
2011-08-16 17:00:00	IWM	ETF	70.62	70.65	70.57	70.64	62701.0
2011-08-16 18:00:00	IWM	ETF	70.54	70.84	70.46	70.51	150797.0
2011-08-16 19:00:00	IWM	ETF	70.52	70.52	70.43	70.46	9815.0
2011-08-16 04:00:00	DIA	ETF	113.3	113.3	113.26	113.26	600.0
2011-08-16 06:00:00	DIA	ETF	113.26	113.26	113.2	113.2	1392.0
2011-08-16 07:00:00	DIA	ETF	113.3	113.8	113.3	113.33	3512.0

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

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