PREVIEW / etf_1hour / 2011-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-29.parquet
  size:    182 KB
  rows:    5,652

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-29 04:00:00	SPY	ETF	119.5	120.2	119.5	120.2	98300.0
2011-11-29 05:00:00	SPY	ETF	120.24	121.18	120.24	120.92	46433.0
2011-11-29 06:00:00	SPY	ETF	120.88	120.99	120.7	120.75	202200.0
2011-11-29 07:00:00	SPY	ETF	120.73	120.73	120.2	120.28	2168021.0
2011-11-29 08:00:00	SPY	ETF	120.25	120.69	119.83	120.1	4326190.0
2011-11-29 09:00:00	SPY	ETF	120.1	120.31	119.61	120.21	24119647.0
2011-11-29 10:00:00	SPY	ETF	120.21	120.86	119.99	120.485	47244660.0
2011-11-29 11:00:00	SPY	ETF	120.48	120.8	120.17	120.43	24715058.0
2011-11-29 12:00:00	SPY	ETF	120.4304	121.0	120.21	120.39	17161370.0
2011-11-29 13:00:00	SPY	ETF	120.4	120.49	119.83	119.9206	18269415.0
2011-11-29 14:00:00	SPY	ETF	119.92	120.33	119.77	120.17	16621649.0
2011-11-29 15:00:00	SPY	ETF	120.18	120.63	119.95	120.03	30461082.0
2011-11-29 16:00:00	SPY	ETF	120.03	120.3	119.48	119.63	9743980.0
2011-11-29 17:00:00	SPY	ETF	119.61	119.85	119.47	119.73	2917091.0
2011-11-29 18:00:00	SPY	ETF	119.74	120.08	119.47	119.55	304752.0
2011-11-29 19:00:00	SPY	ETF	119.58	119.83	119.5	119.77	208729.0
2011-11-29 04:00:00	QQQ	ETF	54.77	54.77	54.77	54.77	600.0
2011-11-29 05:00:00	QQQ	ETF	54.88	55.19	54.88	55.09	15958.0
2011-11-29 06:00:00	QQQ	ETF	55.14	55.14	55.0	55.0	10838.0
2011-11-29 07:00:00	QQQ	ETF	55.0	55.0	54.7	54.71	860979.0
2011-11-29 08:00:00	QQQ	ETF	54.71	54.83	54.59	54.69	2984987.0
2011-11-29 09:00:00	QQQ	ETF	54.67	54.91	54.5	54.89	4031059.0
2011-11-29 10:00:00	QQQ	ETF	54.88	55.1	54.71	54.81	9297870.0
2011-11-29 11:00:00	QQQ	ETF	54.8	54.879	54.51	54.59	6522920.0
2011-11-29 12:00:00	QQQ	ETF	54.595	54.74	54.4	54.5	5230401.0
2011-11-29 13:00:00	QQQ	ETF	54.49	54.57	54.26	54.275	5016460.0
2011-11-29 14:00:00	QQQ	ETF	54.28	54.65	54.22	54.526	7537492.0
2011-11-29 15:00:00	QQQ	ETF	54.53	54.73	54.34	54.36	5811793.0
2011-11-29 16:00:00	QQQ	ETF	54.36	54.46	54.16	54.21	1177401.0
2011-11-29 17:00:00	QQQ	ETF	54.21	54.28	54.13	54.26	49000.0
2011-11-29 18:00:00	QQQ	ETF	54.25	54.32	54.17	54.17	26730.0
2011-11-29 19:00:00	QQQ	ETF	54.21	54.3	54.21	54.29	12900.0
2011-11-29 04:00:00	IWM	ETF	69.99	70.17	69.99	70.17	1300.0
2011-11-29 05:00:00	IWM	ETF	70.35	70.73	70.35	70.65	3208.0
2011-11-29 07:00:00	IWM	ETF	70.26	70.33	70.05	70.15	168245.0
2011-11-29 08:00:00	IWM	ETF	70.12	70.25	69.8	69.84	1359982.0
2011-11-29 09:00:00	IWM	ETF	69.83	69.98	69.42	69.74	5094124.0
2011-11-29 10:00:00	IWM	ETF	69.79	70.18	69.6	69.72	12432417.0
2011-11-29 11:00:00	IWM	ETF	69.71	70.02	69.5	69.69	6772644.0
2011-11-29 12:00:00	IWM	ETF	69.69	70.11	69.6	69.82	5157349.0
2011-11-29 13:00:00	IWM	ETF	69.81	69.89	69.235	69.315	4092699.0
2011-11-29 14:00:00	IWM	ETF	69.33	69.69	69.12	69.54	5902212.0
2011-11-29 15:00:00	IWM	ETF	69.54	69.96	69.415	69.62	10218860.0
2011-11-29 16:00:00	IWM	ETF	69.61	69.79	69.3	69.44	2074113.0
2011-11-29 17:00:00	IWM	ETF	69.37	69.52	69.25	69.5	545502.0
2011-11-29 18:00:00	IWM	ETF	69.53	69.53	69.26	69.26	32032.0
2011-11-29 19:00:00	IWM	ETF	69.36	69.44	69.29	69.44	3100.0
2011-11-29 05:00:00	DIA	ETF	115.98	115.98	115.98	115.98	1000.0
2011-11-29 07:00:00	DIA	ETF	115.65	115.65	115.65	115.65	100.0
2011-11-29 08:00:00	DIA	ETF	115.1	115.6	115.1	115.29	56870.0

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

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