PREVIEW / etf_1hour / 2011-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-13.parquet
  size:    179 KB
  rows:    5,452

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-13 06:00:00	SPY	ETF	135.32	135.73	135.32	135.5	77742.0
2011-05-13 07:00:00	SPY	ETF	135.49	135.49	135.35	135.45	94906.0
2011-05-13 08:00:00	SPY	ETF	135.45	135.73	135.04	135.39	1814916.0
2011-05-13 09:00:00	SPY	ETF	135.38	135.41	134.83	134.91	17621401.0
2011-05-13 10:00:00	SPY	ETF	134.9	135.19	134.57	134.84	22225218.0
2011-05-13 11:00:00	SPY	ETF	134.84	134.84	134.08	134.16	24050306.0
2011-05-13 12:00:00	SPY	ETF	134.15	134.24	133.56	133.89	29215404.0
2011-05-13 13:00:00	SPY	ETF	133.89	134.13	133.76	133.89	10709748.0
2011-05-13 14:00:00	SPY	ETF	133.89	134.34	133.835	134.0908	13073680.0
2011-05-13 15:00:00	SPY	ETF	134.09	135.1069	133.88	134.03	26133455.0
2011-05-13 16:00:00	SPY	ETF	134.02	134.8847	133.78	133.91	9998655.0
2011-05-13 17:00:00	SPY	ETF	133.93	134.06	133.63	134.01	421101.0
2011-05-13 18:00:00	SPY	ETF	134.02	134.04	133.84	133.84	95227.0
2011-05-13 19:00:00	SPY	ETF	133.9	133.9	133.8	133.84	13410.0
2011-05-13 04:00:00	QQQ	ETF	59.25	59.25	59.25	59.25	100.0
2011-05-13 05:00:00	QQQ	ETF	59.2	59.2	59.12	59.18	28500.0
2011-05-13 06:00:00	QQQ	ETF	59.2	59.2	59.16	59.16	3400.0
2011-05-13 07:00:00	QQQ	ETF	59.19	59.22	59.19	59.21	1773.0
2011-05-13 08:00:00	QQQ	ETF	59.22	59.3	59.1	59.15	305679.0
2011-05-13 09:00:00	QQQ	ETF	59.15	59.15	58.84	58.8999	6709332.0
2011-05-13 10:00:00	QQQ	ETF	58.89	59.07	58.75	58.9294	6780048.0
2011-05-13 11:00:00	QQQ	ETF	58.92	58.92	58.55	58.595	10389380.0
2011-05-13 12:00:00	QQQ	ETF	58.605	58.65	58.39	58.47	13271770.0
2011-05-13 13:00:00	QQQ	ETF	58.48	58.58	58.43	58.48	2809830.0
2011-05-13 14:00:00	QQQ	ETF	58.48	58.66	58.46	58.54	4489779.0
2011-05-13 15:00:00	QQQ	ETF	58.55	58.61	58.39	58.41	7759537.0
2011-05-13 16:00:00	QQQ	ETF	58.42	58.4572	58.21	58.32	2090111.0
2011-05-13 17:00:00	QQQ	ETF	58.32	58.33	58.29	58.3	13215.0
2011-05-13 18:00:00	QQQ	ETF	58.32	58.41	58.29	58.29	49820.0
2011-05-13 19:00:00	QQQ	ETF	58.3	58.34	58.29	58.29	6010.0
2011-05-13 04:00:00	IWM	ETF	85.05	85.05	85.05	85.05	400.0
2011-05-13 05:00:00	IWM	ETF	85.11	85.11	85.11	85.11	1000.0
2011-05-13 06:00:00	IWM	ETF	85.03	85.1	85.03	85.1	10000.0
2011-05-13 07:00:00	IWM	ETF	85.2	85.2	85.0	85.16	111900.0
2011-05-13 08:00:00	IWM	ETF	85.14	85.27	84.97	85.04	260025.0
2011-05-13 09:00:00	IWM	ETF	85.03	85.03	84.31	84.5	5727404.0
2011-05-13 10:00:00	IWM	ETF	84.5	84.87	83.99	84.58	11424857.0
2011-05-13 11:00:00	IWM	ETF	84.58	84.58	83.72	83.75	9509182.0
2011-05-13 12:00:00	IWM	ETF	83.75	83.85	83.27	83.54	12337974.0
2011-05-13 13:00:00	IWM	ETF	83.55	83.65	83.35	83.46	3980528.0
2011-05-13 14:00:00	IWM	ETF	83.46	83.86	83.4	83.6	5195863.0
2011-05-13 15:00:00	IWM	ETF	83.61	83.71	83.47	83.55	7497732.0
2011-05-13 16:00:00	IWM	ETF	83.55	84.7023	83.25	83.4	7839756.0
2011-05-13 17:00:00	IWM	ETF	83.4	83.4	83.3	83.33	15400.0
2011-05-13 18:00:00	IWM	ETF	83.39	83.39	83.33	83.33	3300.0
2011-05-13 19:00:00	IWM	ETF	83.34	83.39	83.26	83.26	1500.0
2011-05-13 04:00:00	DIA	ETF	127.24	127.24	127.24	127.24	100.0
2011-05-13 05:00:00	DIA	ETF	127.31	127.31	127.31	127.31	400.0
2011-05-13 07:00:00	DIA	ETF	127.27	127.27	127.23	127.23	3800.0
2011-05-13 08:00:00	DIA	ETF	127.21	127.45	127.05	127.05	8600.0

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

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