PREVIEW / etf_1hour / 2011-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-13.parquet
  size:    185 KB
  rows:    5,655

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-07-13 04:00:00	SPY	ETF	131.94	132.31	131.94	132.19	14000.0
2011-07-13 05:00:00	SPY	ETF	132.25	132.56	132.25	132.55	9990.0
2011-07-13 06:00:00	SPY	ETF	132.49	132.54	132.21	132.27	63011.0
2011-07-13 07:00:00	SPY	ETF	132.27	132.41	132.14	132.19	499001.0
2011-07-13 08:00:00	SPY	ETF	132.19	132.49	131.4	131.95	2120292.0
2011-07-13 09:00:00	SPY	ETF	131.94	132.33	131.85	131.93	21105966.0
2011-07-13 10:00:00	SPY	ETF	131.93	133.12	131.9	133.07	39827267.0
2011-07-13 11:00:00	SPY	ETF	133.08	133.22	132.86	132.94	20941716.0
2011-07-13 12:00:00	SPY	ETF	132.94	133.12	132.83	132.93	15208911.0
2011-07-13 13:00:00	SPY	ETF	132.93	132.96	132.56	132.59	16519741.0
2011-07-13 14:00:00	SPY	ETF	132.6	132.72	132.23	132.41	19535732.0
2011-07-13 15:00:00	SPY	ETF	132.42	132.6	131.519	131.84	43737911.0
2011-07-13 16:00:00	SPY	ETF	131.86	132.4684	131.4168	131.71	13429561.0
2011-07-13 17:00:00	SPY	ETF	131.71	131.71	130.69	131.08	4719095.0
2011-07-13 18:00:00	SPY	ETF	131.04	131.85	130.94	131.33	1811322.0
2011-07-13 19:00:00	SPY	ETF	131.33	131.38	131.07	131.29	344430.0
2011-07-13 04:00:00	QQQ	ETF	57.69	58.01	57.69	58.01	4586.0
2011-07-13 05:00:00	QQQ	ETF	57.96	58.11	57.95	58.05	2680.0
2011-07-13 06:00:00	QQQ	ETF	57.98	57.98	57.98	57.98	600.0
2011-07-13 07:00:00	QQQ	ETF	57.95	58.03	57.93	57.95	66925.0
2011-07-13 08:00:00	QQQ	ETF	57.95	57.97	57.86	57.88	412695.0
2011-07-13 09:00:00	QQQ	ETF	57.87	58.05	57.74	57.78	9714738.0
2011-07-13 10:00:00	QQQ	ETF	57.785	58.34	57.78	58.31	14855949.0
2011-07-13 11:00:00	QQQ	ETF	58.31	58.34	58.2	58.25	7026044.0
2011-07-13 12:00:00	QQQ	ETF	58.25	58.3	58.17	58.2	6459861.0
2011-07-13 13:00:00	QQQ	ETF	58.2	58.22	58.02	58.05	4025151.0
2011-07-13 14:00:00	QQQ	ETF	58.05	58.11	57.9	57.985	4268008.0
2011-07-13 15:00:00	QQQ	ETF	57.99	58.06	57.55	57.73	15259422.0
2011-07-13 16:00:00	QQQ	ETF	57.74	57.9994	57.59	57.64	3264437.0
2011-07-13 17:00:00	QQQ	ETF	57.63	57.63	57.2	57.32	486375.0
2011-07-13 18:00:00	QQQ	ETF	57.3	57.72	57.29	57.44	52439.0
2011-07-13 19:00:00	QQQ	ETF	57.41	57.43	57.35	57.42	18853.0
2011-07-13 04:00:00	IWM	ETF	82.9	83.5	82.9	83.4	1431.0
2011-07-13 05:00:00	IWM	ETF	83.46	83.75	83.46	83.75	2140.0
2011-07-13 06:00:00	IWM	ETF	83.67	83.78	83.46	83.46	6600.0
2011-07-13 07:00:00	IWM	ETF	83.44	83.62	83.44	83.47	8338.0
2011-07-13 08:00:00	IWM	ETF	83.55	83.55	83.26	83.36	784403.0
2011-07-13 09:00:00	IWM	ETF	83.35	83.7	82.88	83.3	9811649.0
2011-07-13 10:00:00	IWM	ETF	83.3	84.3	83.29	84.18	15279990.0
2011-07-13 11:00:00	IWM	ETF	84.18	84.47	84.08	84.24	6957208.0
2011-07-13 12:00:00	IWM	ETF	84.24	84.31	84.08	84.158	5249795.0
2011-07-13 13:00:00	IWM	ETF	84.16	84.185	83.76	83.83	5706209.0
2011-07-13 14:00:00	IWM	ETF	83.82	83.91	83.64	83.87	4734690.0
2011-07-13 15:00:00	IWM	ETF	83.88	83.96	83.24	83.62	12826577.0
2011-07-13 16:00:00	IWM	ETF	83.61	83.6527	83.41	83.5	6396135.0
2011-07-13 17:00:00	IWM	ETF	83.48	83.48	82.97	83.02	513858.0
2011-07-13 18:00:00	IWM	ETF	83.08	83.11	82.97	83.09	48747.0
2011-07-13 19:00:00	IWM	ETF	83.08	83.22	82.98	83.02	8867.0
2011-07-13 04:00:00	DIA	ETF	125.1	125.1	125.1	125.1	100.0
2011-07-13 06:00:00	DIA	ETF	125.22	125.22	125.22	125.22	100.0

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

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