PREVIEW / etf_1hour / 2012-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-19.parquet
  size:    195 KB
  rows:    6,191

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
2012-12-19 04:00:00	SPY	ETF	145.3	145.41	145.26	145.41	6248.0
2012-12-19 05:00:00	SPY	ETF	145.48	145.59	145.48	145.56	38900.0
2012-12-19 06:00:00	SPY	ETF	145.57	145.6	145.49	145.57	43690.0
2012-12-19 07:00:00	SPY	ETF	145.54	145.63	145.5	145.56	876925.0
2012-12-19 08:00:00	SPY	ETF	145.56	145.72	145.52	145.65	1609031.0
2012-12-19 09:00:00	SPY	ETF	145.64	145.75	145.07	145.08	13582530.0
2012-12-19 10:00:00	SPY	ETF	145.09	145.2626	144.86	145.14	27392034.0
2012-12-19 11:00:00	SPY	ETF	145.14	145.34	145.07	145.12	17814210.0
2012-12-19 12:00:00	SPY	ETF	145.12	145.34	144.97	145.125	11757245.0
2012-12-19 13:00:00	SPY	ETF	145.12	145.19	144.84	145.005	9782085.0
2012-12-19 14:00:00	SPY	ETF	145.0	145.0	144.49	144.68	20601313.0
2012-12-19 15:00:00	SPY	ETF	144.68	144.95	144.24	144.28	29218291.0
2012-12-19 16:00:00	SPY	ETF	144.3	144.9353	144.16	144.18	14139210.0
2012-12-19 17:00:00	SPY	ETF	144.16	144.2	143.96	144.03	630662.0
2012-12-19 18:00:00	SPY	ETF	144.03	144.05	143.91	144.03	156305.0
2012-12-19 19:00:00	SPY	ETF	144.02	144.09	143.97	144.09	82860.0
2012-12-19 04:00:00	QQQ	ETF	66.69	66.69	66.69	66.69	100.0
2012-12-19 05:00:00	QQQ	ETF	66.75	66.75	66.75	66.75	12588.0
2012-12-19 06:00:00	QQQ	ETF	66.73	66.74	66.69	66.73	35700.0
2012-12-19 07:00:00	QQQ	ETF	66.71	66.78	66.71	66.77	17000.0
2012-12-19 08:00:00	QQQ	ETF	66.76	66.78	66.67	66.75	138403.0
2012-12-19 09:00:00	QQQ	ETF	66.74	66.78	66.52	66.525	3525941.0
2012-12-19 10:00:00	QQQ	ETF	66.51	66.62	66.37	66.5462	5240539.0
2012-12-19 11:00:00	QQQ	ETF	66.54	66.73	66.53	66.539	4851469.0
2012-12-19 12:00:00	QQQ	ETF	66.535	66.64	66.47	66.53	3413599.0
2012-12-19 13:00:00	QQQ	ETF	66.54	66.57	66.34	66.45	2310249.0
2012-12-19 14:00:00	QQQ	ETF	66.45	66.46	66.24	66.359	4143882.0
2012-12-19 15:00:00	QQQ	ETF	66.36	66.529	66.22	66.23	7418590.0
2012-12-19 16:00:00	QQQ	ETF	66.24	66.391	66.2157	66.23	1537204.0
2012-12-19 17:00:00	QQQ	ETF	66.26	66.26	66.15	66.18	32500.0
2012-12-19 18:00:00	QQQ	ETF	66.18	66.18	66.12	66.16	16963.0
2012-12-19 19:00:00	QQQ	ETF	66.16	66.2	66.15	66.17	14850.0
2012-12-19 04:00:00	IWM	ETF	84.32	84.32	83.86	84.03	3550.0
2012-12-19 05:00:00	IWM	ETF	84.03	84.13	84.03	84.13	3471.0
2012-12-19 06:00:00	IWM	ETF	84.13	84.13	84.05	84.1	1200.0
2012-12-19 07:00:00	IWM	ETF	84.1	84.16	84.09	84.16	57832.0
2012-12-19 08:00:00	IWM	ETF	84.06	84.14	84.0	84.11	579304.0
2012-12-19 09:00:00	IWM	ETF	84.11	84.21	83.82	83.84	4887285.0
2012-12-19 10:00:00	IWM	ETF	83.83	84.1	83.76	84.06	6194133.0
2012-12-19 11:00:00	IWM	ETF	84.06	84.37	84.05	84.195	4694908.0
2012-12-19 12:00:00	IWM	ETF	84.208	84.5	84.05	84.4	3653675.0
2012-12-19 13:00:00	IWM	ETF	84.41	84.52	84.23	84.388	2740469.0
2012-12-19 14:00:00	IWM	ETF	84.38	84.385	84.05	84.1584	5216224.0
2012-12-19 15:00:00	IWM	ETF	84.155	84.265	84.05	84.06	11406713.0
2012-12-19 16:00:00	IWM	ETF	84.06	84.32	83.97	83.97	1433008.0
2012-12-19 17:00:00	IWM	ETF	83.96	83.97	83.84	83.87	11730.0
2012-12-19 18:00:00	IWM	ETF	83.82	83.82	83.82	83.82	1650.0
2012-12-19 19:00:00	IWM	ETF	83.84	83.88	83.84	83.88	1663.0
2012-12-19 07:00:00	DIA	ETF	133.65	133.65	133.65	133.65	300.0
2012-12-19 08:00:00	DIA	ETF	133.53	133.81	133.53	133.77	4724.0

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

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