PREVIEW / etf_1hour / 2011-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-12.parquet
  size:    182 KB
  rows:    5,548

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-05-12 04:00:00	SPY	ETF	134.01	134.02	133.56	133.65	13700.0
2011-05-12 05:00:00	SPY	ETF	133.55	133.75	133.55	133.58	41675.0
2011-05-12 06:00:00	SPY	ETF	133.58	133.75	133.4	133.63	111300.0
2011-05-12 07:00:00	SPY	ETF	133.7	133.87	133.53	133.82	595987.0
2011-05-12 08:00:00	SPY	ETF	133.41	133.96	133.41	133.79	3124296.0
2011-05-12 09:00:00	SPY	ETF	133.78	134.16	133.39	133.69	26147160.0
2011-05-12 10:00:00	SPY	ETF	133.68	134.13	133.42	133.78	31264083.0
2011-05-12 11:00:00	SPY	ETF	133.78	134.55	133.66	134.26	25215385.0
2011-05-12 12:00:00	SPY	ETF	134.26	134.65	134.15	134.6	13169009.0
2011-05-12 13:00:00	SPY	ETF	134.6	135.22	134.595	135.11	21634761.0
2011-05-12 14:00:00	SPY	ETF	135.12	135.36	134.85	134.875	16463791.0
2011-05-12 15:00:00	SPY	ETF	134.87	135.24	134.79	135.11	26238525.0
2011-05-12 16:00:00	SPY	ETF	135.09	135.28	134.4199	135.17	6317304.0
2011-05-12 17:00:00	SPY	ETF	135.17	135.27	135.15	135.2	196362.0
2011-05-12 18:00:00	SPY	ETF	135.21	135.25	135.1	135.16	152016.0
2011-05-12 19:00:00	SPY	ETF	135.19	135.25	135.18	135.25	21723.0
2011-05-12 04:00:00	QQQ	ETF	58.43	58.43	58.36	58.36	1000.0
2011-05-12 05:00:00	QQQ	ETF	58.34	58.5	58.34	58.5	50100.0
2011-05-12 06:00:00	QQQ	ETF	58.36	58.46	58.36	58.46	26000.0
2011-05-12 07:00:00	QQQ	ETF	58.44	58.49	58.39	58.49	61200.0
2011-05-12 08:00:00	QQQ	ETF	58.48	58.52	58.36	58.48	523868.0
2011-05-12 09:00:00	QQQ	ETF	58.47	58.65	58.24	58.475	10858421.0
2011-05-12 10:00:00	QQQ	ETF	58.475	58.76	58.37	58.53	12958874.0
2011-05-12 11:00:00	QQQ	ETF	58.53	58.87	58.48	58.73	7547146.0
2011-05-12 12:00:00	QQQ	ETF	58.73	58.89	58.71	58.87	3884152.0
2011-05-12 13:00:00	QQQ	ETF	58.8601	59.09	58.8601	59.05	4869572.0
2011-05-12 14:00:00	QQQ	ETF	59.058	59.19	58.965	58.995	6321266.0
2011-05-12 15:00:00	QQQ	ETF	58.99	59.15	58.95	59.11	10565031.0
2011-05-12 16:00:00	QQQ	ETF	59.1	59.2	59.07	59.13	2798873.0
2011-05-12 17:00:00	QQQ	ETF	59.16	59.18	59.12	59.13	18793.0
2011-05-12 18:00:00	QQQ	ETF	59.14	59.17	59.11	59.15	106113.0
2011-05-12 19:00:00	QQQ	ETF	59.14	59.16	59.13	59.14	9650.0
2011-05-12 04:00:00	IWM	ETF	83.65	83.65	83.28	83.34	1100.0
2011-05-12 06:00:00	IWM	ETF	83.18	83.29	83.04	83.04	16800.0
2011-05-12 07:00:00	IWM	ETF	83.23	83.3	83.0	83.2	266011.0
2011-05-12 08:00:00	IWM	ETF	83.04	83.3	83.02	83.21	721887.0
2011-05-12 09:00:00	IWM	ETF	83.2	83.57	82.98	83.36	9733007.0
2011-05-12 10:00:00	IWM	ETF	83.37	84.05	83.13	83.61	12156850.0
2011-05-12 11:00:00	IWM	ETF	83.6	84.62	83.49	84.359	11579980.0
2011-05-12 12:00:00	IWM	ETF	84.35	84.62	84.21	84.5	6052725.0
2011-05-12 13:00:00	IWM	ETF	84.51	84.94	84.51	84.76	8107976.0
2011-05-12 14:00:00	IWM	ETF	84.75	84.87	84.46	84.51	6493450.0
2011-05-12 15:00:00	IWM	ETF	84.5	84.78	84.43	84.69	9570608.0
2011-05-12 16:00:00	IWM	ETF	84.68	84.81	84.63	84.71	1939900.0
2011-05-12 17:00:00	IWM	ETF	84.74	84.78	84.74	84.78	700.0
2011-05-12 18:00:00	IWM	ETF	84.69	84.69	84.69	84.69	64066.0
2011-05-12 19:00:00	IWM	ETF	84.68	84.78	84.68	84.75	1800.0
2011-05-12 04:00:00	DIA	ETF	125.64	125.64	125.51	125.51	1400.0
2011-05-12 06:00:00	DIA	ETF	125.55	125.69	125.48	125.69	1700.0
2011-05-12 07:00:00	DIA	ETF	125.72	125.85	125.57	125.85	6561.0

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

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