PREVIEW / etf_1hour / 2011-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-21.parquet
  size:    183 KB
  rows:    5,671

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-21 04:00:00	SPY	ETF	120.41	120.41	120.08	120.33	3600.0
2011-09-21 05:00:00	SPY	ETF	120.35	120.63	120.35	120.42	1140.0
2011-09-21 06:00:00	SPY	ETF	120.5	120.5	119.76	120.38	71097.0
2011-09-21 07:00:00	SPY	ETF	120.48	120.48	119.76	119.76	618603.0
2011-09-21 08:00:00	SPY	ETF	119.75	120.96	119.51	120.13	3486899.0
2011-09-21 09:00:00	SPY	ETF	120.14	120.57	119.9	120.39	19706158.0
2011-09-21 10:00:00	SPY	ETF	120.38	120.6	119.25	119.49	30049528.0
2011-09-21 11:00:00	SPY	ETF	119.48	119.85	119.23	119.66	21825269.0
2011-09-21 12:00:00	SPY	ETF	119.66	119.78	119.05	119.37	29159662.0
2011-09-21 13:00:00	SPY	ETF	119.37	119.65	119.22	119.435	12559691.0
2011-09-21 14:00:00	SPY	ETF	119.42	120.17	118.19	118.64	78237998.0
2011-09-21 15:00:00	SPY	ETF	118.64	119.32	116.5	116.51	86880758.0
2011-09-21 16:00:00	SPY	ETF	116.5	120.1295	116.09	116.29	30385419.0
2011-09-21 17:00:00	SPY	ETF	116.3	116.5994	116.23	116.23	1640990.0
2011-09-21 18:00:00	SPY	ETF	116.23	116.51	116.05	116.19	426020.0
2011-09-21 19:00:00	SPY	ETF	116.22	116.32	116.14	116.25	212575.0
2011-09-21 04:00:00	QQQ	ETF	56.58	56.58	56.5	56.5	870.0
2011-09-21 05:00:00	QQQ	ETF	56.59	56.59	56.59	56.59	200.0
2011-09-21 06:00:00	QQQ	ETF	56.54	56.56	56.51	56.56	500.0
2011-09-21 07:00:00	QQQ	ETF	56.45	56.52	56.19	56.25	141500.0
2011-09-21 08:00:00	QQQ	ETF	56.23	56.47	56.16	56.45	1028594.0
2011-09-21 09:00:00	QQQ	ETF	56.44	56.93	56.37	56.8	6856553.0
2011-09-21 10:00:00	QQQ	ETF	56.81	56.88	56.24	56.36	8500209.0
2011-09-21 11:00:00	QQQ	ETF	56.35	56.68	56.33	56.67	6219711.0
2011-09-21 12:00:00	QQQ	ETF	56.67	56.76	56.48	56.63	8375803.0
2011-09-21 13:00:00	QQQ	ETF	56.62	56.71	56.56	56.59	2783517.0
2011-09-21 14:00:00	QQQ	ETF	56.58	56.92	56.05	56.36	20474576.0
2011-09-21 15:00:00	QQQ	ETF	56.35	56.71	55.37	55.4	17265163.0
2011-09-21 16:00:00	QQQ	ETF	55.37	55.4163	55.18	55.24	3678881.0
2011-09-21 17:00:00	QQQ	ETF	55.23	55.29	55.22	55.29	49689.0
2011-09-21 18:00:00	QQQ	ETF	55.23	55.38	55.13	55.17	60997.0
2011-09-21 19:00:00	QQQ	ETF	55.15	55.38	55.15	55.3	19855.0
2011-09-21 04:00:00	IWM	ETF	69.29	69.29	69.13	69.13	600.0
2011-09-21 05:00:00	IWM	ETF	69.19	69.33	69.19	69.33	1200.0
2011-09-21 07:00:00	IWM	ETF	69.17	69.17	68.72	68.72	27700.0
2011-09-21 08:00:00	IWM	ETF	68.72	69.38	68.57	68.99	307009.0
2011-09-21 09:00:00	IWM	ETF	68.97	69.5	68.84	69.414	5995877.0
2011-09-21 10:00:00	IWM	ETF	69.45	69.63	68.51	68.68	8459349.0
2011-09-21 11:00:00	IWM	ETF	68.67	69.08	68.54	68.92	5606756.0
2011-09-21 12:00:00	IWM	ETF	68.92	69.11	68.52	68.77	5889197.0
2011-09-21 13:00:00	IWM	ETF	68.76	69.01	68.64	68.81	3818067.0
2011-09-21 14:00:00	IWM	ETF	68.8	69.25	67.88	68.14	18371078.0
2011-09-21 15:00:00	IWM	ETF	68.13	68.6	66.54	66.56	20271311.0
2011-09-21 16:00:00	IWM	ETF	66.56	66.61	66.22	66.51	2452807.0
2011-09-21 17:00:00	IWM	ETF	66.5	66.53	66.34	66.35	69153.0
2011-09-21 18:00:00	IWM	ETF	66.34	66.46	66.2	66.4	11422.0
2011-09-21 19:00:00	IWM	ETF	66.41	66.47	66.37	66.41	16395.0
2011-09-21 07:00:00	DIA	ETF	113.53	113.53	113.53	113.53	2293.0
2011-09-21 08:00:00	DIA	ETF	114.05	114.05	113.48	113.86	110725.0
2011-09-21 09:00:00	DIA	ETF	113.76	114.18	113.64	114.01	1087995.0

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

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