PREVIEW / etf_1hour / 2011-05-06

all etf 1-hour files

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

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-06 04:00:00	SPY	ETF	133.97	134.23	133.9	134.2	3400.0
2011-05-06 05:00:00	SPY	ETF	134.32	134.56	134.32	134.39	7400.0
2011-05-06 06:00:00	SPY	ETF	134.46	134.52	134.3	134.35	20150.0
2011-05-06 07:00:00	SPY	ETF	134.35	134.37	134.07	134.21	465776.0
2011-05-06 08:00:00	SPY	ETF	134.18	135.26	134.11	135.12	9765702.0
2011-05-06 09:00:00	SPY	ETF	135.13	135.44	134.83	135.01	28054204.0
2011-05-06 10:00:00	SPY	ETF	135.01	135.3	134.8	135.11	21206363.0
2011-05-06 11:00:00	SPY	ETF	135.11	135.63	135.1	135.29	24271214.0
2011-05-06 12:00:00	SPY	ETF	135.3	135.42	134.38	134.71	37923322.0
2011-05-06 13:00:00	SPY	ETF	134.72	134.87	134.05	134.27	26592032.0
2011-05-06 14:00:00	SPY	ETF	134.26	134.6	133.22	133.9701	25433211.0
2011-05-06 15:00:00	SPY	ETF	133.98	134.45	133.94	134.17	34174361.0
2011-05-06 16:00:00	SPY	ETF	134.17	134.6869	133.92	133.97	14763317.0
2011-05-06 17:00:00	SPY	ETF	133.99	134.01	133.93	134.0	87852.0
2011-05-06 18:00:00	SPY	ETF	134.0	134.2	133.97	134.02	123670.0
2011-05-06 19:00:00	SPY	ETF	134.03	134.06	133.98	134.06	24828.0
2011-05-06 04:00:00	QQQ	ETF	58.39	58.42	58.38	58.42	450.0
2011-05-06 06:00:00	QQQ	ETF	58.69	58.7	58.67	58.7	1300.0
2011-05-06 07:00:00	QQQ	ETF	58.63	58.64	58.52	58.54	72863.0
2011-05-06 08:00:00	QQQ	ETF	58.52	59.09	58.52	59.04	2790373.0
2011-05-06 09:00:00	QQQ	ETF	59.05	59.14	58.67	58.818	11155745.0
2011-05-06 10:00:00	QQQ	ETF	58.8162	58.9601	58.71	58.94	8403680.0
2011-05-06 11:00:00	QQQ	ETF	58.95	59.2	58.94	59.131	7658840.0
2011-05-06 12:00:00	QQQ	ETF	59.13	59.16	58.76	58.8601	9015072.0
2011-05-06 13:00:00	QQQ	ETF	58.87	58.91	58.56	58.6	8832890.0
2011-05-06 14:00:00	QQQ	ETF	58.6	58.75	58.31	58.43	7455734.0
2011-05-06 15:00:00	QQQ	ETF	58.42	58.65	58.415	58.48	8267343.0
2011-05-06 16:00:00	QQQ	ETF	58.48	58.51	58.303	58.33	6027762.0
2011-05-06 17:00:00	QQQ	ETF	58.34	58.36	58.31	58.36	24114.0
2011-05-06 18:00:00	QQQ	ETF	58.35	58.5	58.35	58.37	31423.0
2011-05-06 19:00:00	QQQ	ETF	58.43	58.43	58.38	58.38	7300.0
2011-05-06 04:00:00	IWM	ETF	83.21	83.21	83.21	83.21	600.0
2011-05-06 05:00:00	IWM	ETF	83.35	83.35	83.33	83.33	450.0
2011-05-06 07:00:00	IWM	ETF	83.34	83.34	83.11	83.14	45900.0
2011-05-06 08:00:00	IWM	ETF	83.23	84.12	83.12	84.07	2717320.0
2011-05-06 09:00:00	IWM	ETF	84.07	84.15	83.4299	83.7	11380154.0
2011-05-06 10:00:00	IWM	ETF	83.7	84.08	83.45	83.82	9423743.0
2011-05-06 11:00:00	IWM	ETF	83.82	84.34	83.82	84.11	8721806.0
2011-05-06 12:00:00	IWM	ETF	84.11	84.12	83.4	83.6584	8839768.0
2011-05-06 13:00:00	IWM	ETF	83.65	84.06	83.31	83.39	8432437.0
2011-05-06 14:00:00	IWM	ETF	83.39	83.57	82.84	83.04	8730963.0
2011-05-06 15:00:00	IWM	ETF	83.03	83.52	83.015	83.23	9849684.0
2011-05-06 16:00:00	IWM	ETF	83.24	83.29	82.853	83.08	2056342.0
2011-05-06 17:00:00	IWM	ETF	83.08	83.08	83.03	83.03	6674.0
2011-05-06 18:00:00	IWM	ETF	83.06	83.08	83.06	83.08	966.0
2011-05-06 19:00:00	IWM	ETF	83.08	83.1	83.05	83.08	9900.0
2011-05-06 04:00:00	DIA	ETF	125.92	126.12	125.92	126.12	500.0
2011-05-06 05:00:00	DIA	ETF	126.2	126.44	126.2	126.44	2100.0
2011-05-06 06:00:00	DIA	ETF	126.28	126.28	126.28	126.28	500.0
2011-05-06 07:00:00	DIA	ETF	126.24	126.24	126.09	126.09	13125.0

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

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