PREVIEW / etf_1hour / 2011-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-03.parquet
  size:    186 KB
  rows:    5,627

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-03 04:00:00	SPY	ETF	135.96	136.08	135.87	135.94	4300.0
2011-05-03 05:00:00	SPY	ETF	135.88	135.95	135.64	135.66	4500.0
2011-05-03 06:00:00	SPY	ETF	135.72	135.72	135.49	135.49	139320.0
2011-05-03 07:00:00	SPY	ETF	135.52	135.72	135.46	135.54	383529.0
2011-05-03 08:00:00	SPY	ETF	135.55	135.88	135.47	135.85	1153896.0
2011-05-03 09:00:00	SPY	ETF	135.85	136.25	135.67	136.06	18109724.0
2011-05-03 10:00:00	SPY	ETF	136.07	136.19	135.6	135.7	22993154.0
2011-05-03 11:00:00	SPY	ETF	135.695	136.16	135.66	136.04	11274812.0
2011-05-03 12:00:00	SPY	ETF	136.05	136.14	135.71	135.73	7363977.0
2011-05-03 13:00:00	SPY	ETF	135.73	135.82	135.32	135.47	16605988.0
2011-05-03 14:00:00	SPY	ETF	135.47	135.48	135.045	135.16	18320151.0
2011-05-03 15:00:00	SPY	ETF	135.16	135.81	135.15	135.72	30843245.0
2011-05-03 16:00:00	SPY	ETF	135.72	135.78	135.46	135.51	10203785.0
2011-05-03 17:00:00	SPY	ETF	135.53	135.56	135.45	135.51	241761.0
2011-05-03 18:00:00	SPY	ETF	135.51	135.71	135.33	135.39	170238.0
2011-05-03 19:00:00	SPY	ETF	135.39	135.63	135.3	135.63	122429.0
2011-05-03 04:00:00	QQQ	ETF	58.9	58.9	58.9	58.9	200.0
2011-05-03 05:00:00	QQQ	ETF	58.8	58.83	58.8	58.83	30000.0
2011-05-03 06:00:00	QQQ	ETF	58.8	58.82	58.76	58.76	2900.0
2011-05-03 07:00:00	QQQ	ETF	58.76	58.82	58.75	58.77	35750.0
2011-05-03 08:00:00	QQQ	ETF	58.78	58.92	58.77	58.91	176687.0
2011-05-03 09:00:00	QQQ	ETF	58.91	59.0	58.75	58.93	3747921.0
2011-05-03 10:00:00	QQQ	ETF	58.93	58.98	58.68	58.758	5300425.0
2011-05-03 11:00:00	QQQ	ETF	58.75	58.89	58.72	58.8388	2449517.0
2011-05-03 12:00:00	QQQ	ETF	58.83	58.85	58.541	58.56	3399995.0
2011-05-03 13:00:00	QQQ	ETF	58.5599	58.64	58.35	58.48	4156628.0
2011-05-03 14:00:00	QQQ	ETF	58.48	58.5	58.33	58.45	5202973.0
2011-05-03 15:00:00	QQQ	ETF	58.45	58.74	58.45	58.69	6683372.0
2011-05-03 16:00:00	QQQ	ETF	58.7	58.74	58.63	58.64	3440553.0
2011-05-03 17:00:00	QQQ	ETF	58.66	58.73	58.65	58.68	54375.0
2011-05-03 18:00:00	QQQ	ETF	58.66	58.67	58.58	58.59	52725.0
2011-05-03 19:00:00	QQQ	ETF	58.61	58.72	58.57	58.71	13788.0
2011-05-03 05:00:00	IWM	ETF	85.11	85.11	85.11	85.11	100.0
2011-05-03 06:00:00	IWM	ETF	85.05	85.05	84.89	84.9	22500.0
2011-05-03 07:00:00	IWM	ETF	84.89	85.03	84.88	84.9	36000.0
2011-05-03 08:00:00	IWM	ETF	84.9	85.21	84.9	85.19	99393.0
2011-05-03 09:00:00	IWM	ETF	85.18	85.45	84.84	85.24	6038949.0
2011-05-03 10:00:00	IWM	ETF	85.25	85.49	84.35	84.47	13090410.0
2011-05-03 11:00:00	IWM	ETF	84.46	84.75	84.41	84.5071	4516099.0
2011-05-03 12:00:00	IWM	ETF	84.51	84.59	84.31	84.32	3204200.0
2011-05-03 13:00:00	IWM	ETF	84.32	84.48	83.92	84.0785	6225342.0
2011-05-03 14:00:00	IWM	ETF	84.075	84.08	83.72	83.865	6825850.0
2011-05-03 15:00:00	IWM	ETF	83.86	84.42	83.86	84.34	9071601.0
2011-05-03 16:00:00	IWM	ETF	84.34	85.3926	83.832	84.18	2014650.0
2011-05-03 17:00:00	IWM	ETF	84.22	84.23	84.18	84.18	7499.0
2011-05-03 18:00:00	IWM	ETF	84.16	84.18	84.1	84.15	7414.0
2011-05-03 19:00:00	IWM	ETF	84.17	84.23	84.16	84.23	29100.0
2011-05-03 04:00:00	DIA	ETF	127.67	127.75	127.67	127.7	2300.0
2011-05-03 05:00:00	DIA	ETF	127.63	127.63	127.43	127.43	1700.0
2011-05-03 06:00:00	DIA	ETF	127.44	127.44	127.32	127.35	2600.0

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

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