PREVIEW / etf_1hour / 2011-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-08.parquet
  size:    184 KB
  rows:    5,635

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-11-08 04:00:00	SPY	ETF	126.2	126.9	126.2	126.52	110295.0
2011-11-08 05:00:00	SPY	ETF	126.48	126.75	126.46	126.6	17380.0
2011-11-08 06:00:00	SPY	ETF	126.67	126.87	126.46	126.74	59680.0
2011-11-08 07:00:00	SPY	ETF	126.82	127.26	126.61	127.2	851275.0
2011-11-08 08:00:00	SPY	ETF	127.2	127.27	126.9	127.0	1773567.0
2011-11-08 09:00:00	SPY	ETF	127.0	127.35	126.66	127.34	19245035.0
2011-11-08 10:00:00	SPY	ETF	127.33	127.39	126.17	126.47	43050332.0
2011-11-08 11:00:00	SPY	ETF	126.46	126.6	125.71	126.0699	25489597.0
2011-11-08 12:00:00	SPY	ETF	126.06	126.48	125.86	126.23	15235920.0
2011-11-08 13:00:00	SPY	ETF	126.23	127.31	126.0	127.11	28441840.0
2011-11-08 14:00:00	SPY	ETF	127.11	127.6	126.86	127.489	28188313.0
2011-11-08 15:00:00	SPY	ETF	127.49	128.02	127.2	127.87	42580276.0
2011-11-08 16:00:00	SPY	ETF	127.88	128.06	126.02	127.88	16241757.0
2011-11-08 17:00:00	SPY	ETF	127.88	127.92	126.3548	127.85	420818.0
2011-11-08 18:00:00	SPY	ETF	127.84	127.86	127.7	127.83	264217.0
2011-11-08 19:00:00	SPY	ETF	127.81	127.84	127.72	127.84	78837.0
2011-11-08 04:00:00	QQQ	ETF	58.53	58.53	58.53	58.53	200.0
2011-11-08 05:00:00	QQQ	ETF	58.59	58.59	58.59	58.59	400.0
2011-11-08 06:00:00	QQQ	ETF	58.57	58.63	58.56	58.59	5100.0
2011-11-08 07:00:00	QQQ	ETF	58.5	58.84	58.5	58.82	41268.0
2011-11-08 08:00:00	QQQ	ETF	58.82	58.87	58.67	58.72	1344713.0
2011-11-08 09:00:00	QQQ	ETF	58.72	58.85	58.54	58.84	6408661.0
2011-11-08 10:00:00	QQQ	ETF	58.8401	58.86	58.27	58.37	11014399.0
2011-11-08 11:00:00	QQQ	ETF	58.35	58.43	57.97	58.23	6430392.0
2011-11-08 12:00:00	QQQ	ETF	58.23	58.39	58.16	58.2637	5026161.0
2011-11-08 13:00:00	QQQ	ETF	58.26	58.75	58.17	58.6999	6208482.0
2011-11-08 14:00:00	QQQ	ETF	58.7	58.85	58.56	58.79	8191859.0
2011-11-08 15:00:00	QQQ	ETF	58.78	58.98	58.68	58.89	10685840.0
2011-11-08 16:00:00	QQQ	ETF	58.88	58.97	58.82	58.88	879015.0
2011-11-08 17:00:00	QQQ	ETF	58.9	58.96	58.87	58.88	6134.0
2011-11-08 18:00:00	QQQ	ETF	58.9	58.91	58.85	58.87	10700.0
2011-11-08 19:00:00	QQQ	ETF	58.88	58.9	58.86	58.9	31062.0
2011-11-08 04:00:00	IWM	ETF	74.84	74.84	74.84	74.84	100.0
2011-11-08 07:00:00	IWM	ETF	74.89	75.32	74.85	75.25	192800.0
2011-11-08 08:00:00	IWM	ETF	75.22	75.3	75.0	75.13	102425.0
2011-11-08 09:00:00	IWM	ETF	75.13	75.32	74.73	75.25	6387247.0
2011-11-08 10:00:00	IWM	ETF	75.24	75.3	74.13	74.42	10851278.0
2011-11-08 11:00:00	IWM	ETF	74.41	74.52	73.46	73.85	11905073.0
2011-11-08 12:00:00	IWM	ETF	73.85	74.23	73.7	74.1016	2396664.0
2011-11-08 13:00:00	IWM	ETF	74.1	74.94	73.88	74.83	6992196.0
2011-11-08 14:00:00	IWM	ETF	74.83	75.28	74.63	75.19	8403141.0
2011-11-08 15:00:00	IWM	ETF	75.19	75.64	74.92	75.5	12935675.0
2011-11-08 16:00:00	IWM	ETF	75.5	75.62	74.4622	75.44	5044430.0
2011-11-08 17:00:00	IWM	ETF	75.39	75.39	75.35	75.37	1499.0
2011-11-08 18:00:00	IWM	ETF	75.39	75.4	75.28	75.38	10568.0
2011-11-08 19:00:00	IWM	ETF	75.38	75.38	75.36	75.38	2109.0
2011-11-08 05:00:00	DIA	ETF	120.85	120.85	120.85	120.85	200.0
2011-11-08 07:00:00	DIA	ETF	121.0	121.31	121.0	121.28	3600.0
2011-11-08 08:00:00	DIA	ETF	121.26	121.32	121.05	121.11	18420.0
2011-11-08 09:00:00	DIA	ETF	121.14	121.28	120.78	121.17	724120.0

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

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