PREVIEW / etf_1hour / 2011-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-06.parquet
  size:    190 KB
  rows:    5,888

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-09-06 04:00:00	SPY	ETF	116.0	116.2	115.27	115.75	16717.0
2011-09-06 05:00:00	SPY	ETF	115.75	115.99	115.45	115.79	34275.0
2011-09-06 06:00:00	SPY	ETF	115.75	115.96	115.49	115.76	37483.0
2011-09-06 07:00:00	SPY	ETF	115.75	115.92	114.8	114.84	967096.0
2011-09-06 08:00:00	SPY	ETF	114.84	115.86	114.05	114.47	3738938.0
2011-09-06 09:00:00	SPY	ETF	114.47	115.419	114.19	115.29	37642054.0
2011-09-06 10:00:00	SPY	ETF	115.31	115.95	114.41	115.0865	54474300.0
2011-09-06 11:00:00	SPY	ETF	115.08	115.75	114.86	115.62	28669539.0
2011-09-06 12:00:00	SPY	ETF	115.6295	116.08	115.535	115.76	17513756.0
2011-09-06 13:00:00	SPY	ETF	115.76	116.44	115.64	116.23	30196655.0
2011-09-06 14:00:00	SPY	ETF	116.23	116.885	116.14	116.21	26553311.0
2011-09-06 15:00:00	SPY	ETF	116.2	117.16	115.72	117.02	60202094.0
2011-09-06 16:00:00	SPY	ETF	117.01	117.8324	114.7	117.15	22020400.0
2011-09-06 17:00:00	SPY	ETF	117.15	117.3	117.08	117.26	235625.0
2011-09-06 18:00:00	SPY	ETF	117.25	117.27	116.99	117.2	143444.0
2011-09-06 19:00:00	SPY	ETF	117.17	117.4	117.16	117.26	103955.0
2011-09-06 04:00:00	QQQ	ETF	52.9	52.9	52.7	52.7	1031.0
2011-09-06 05:00:00	QQQ	ETF	53.0	53.0	53.0	53.0	200.0
2011-09-06 06:00:00	QQQ	ETF	52.63	52.7	52.63	52.65	4303.0
2011-09-06 07:00:00	QQQ	ETF	52.67	52.72	52.25	52.25	96773.0
2011-09-06 08:00:00	QQQ	ETF	52.25	52.4	52.14	52.17	432669.0
2011-09-06 09:00:00	QQQ	ETF	52.19	52.36	52.01	52.305	7399483.0
2011-09-06 10:00:00	QQQ	ETF	52.3	52.5	51.91	52.271	11939520.0
2011-09-06 11:00:00	QQQ	ETF	52.2622	52.58	52.12	52.44	6880127.0
2011-09-06 12:00:00	QQQ	ETF	52.43	52.65	52.39	52.46	3069456.0
2011-09-06 13:00:00	QQQ	ETF	52.46	52.89	52.41	52.8001	4799482.0
2011-09-06 14:00:00	QQQ	ETF	52.81	53.16	52.78	52.88	5644824.0
2011-09-06 15:00:00	QQQ	ETF	52.88	53.366	52.62	53.28	10450350.0
2011-09-06 16:00:00	QQQ	ETF	53.29	53.35	53.13	53.29	715170.0
2011-09-06 17:00:00	QQQ	ETF	53.28	53.36	53.26	53.34	18790.0
2011-09-06 18:00:00	QQQ	ETF	53.32	53.33	53.27	53.3	19500.0
2011-09-06 19:00:00	QQQ	ETF	53.31	53.4	53.31	53.36	28100.0
2011-09-06 04:00:00	IWM	ETF	67.4	67.4	66.92	66.92	570.0
2011-09-06 05:00:00	IWM	ETF	67.5	67.5	67.5	67.5	15000.0
2011-09-06 06:00:00	IWM	ETF	67.1	67.35	67.1	67.19	1899.0
2011-09-06 07:00:00	IWM	ETF	67.32	67.37	66.61	66.65	48887.0
2011-09-06 08:00:00	IWM	ETF	66.6	66.8	66.35	66.43	639056.0
2011-09-06 09:00:00	IWM	ETF	66.42	67.3	65.91	67.2	11421771.0
2011-09-06 10:00:00	IWM	ETF	67.21	67.61	66.29	66.82	11899737.0
2011-09-06 11:00:00	IWM	ETF	66.81	67.43	66.71	67.02	6953020.0
2011-09-06 12:00:00	IWM	ETF	67.02	67.38	66.91	67.14	4678574.0
2011-09-06 13:00:00	IWM	ETF	67.14	67.77	67.04	67.59	4707341.0
2011-09-06 14:00:00	IWM	ETF	67.59	68.08	67.29	67.335	6263239.0
2011-09-06 15:00:00	IWM	ETF	67.34	68.31	66.97	68.24	12592727.0
2011-09-06 16:00:00	IWM	ETF	68.24	68.38	68.02	68.21	3578757.0
2011-09-06 17:00:00	IWM	ETF	68.14	68.28	68.12	68.28	30956.0
2011-09-06 18:00:00	IWM	ETF	68.3	68.3	68.3	68.3	7338.0
2011-09-06 19:00:00	IWM	ETF	68.31	68.42	68.31	68.39	8000.0
2011-09-06 04:00:00	DIA	ETF	110.46	110.46	110.46	110.46	800.0
2011-09-06 07:00:00	DIA	ETF	110.53	110.53	109.8	109.8	12183.0

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

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