PREVIEW / etf_1hour / 2011-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-12.parquet
  size:    186 KB
  rows:    5,766

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-10-12 04:00:00	SPY	ETF	119.45	120.34	119.45	120.25	77778.0
2011-10-12 05:00:00	SPY	ETF	120.32	120.85	120.32	120.72	119714.0
2011-10-12 06:00:00	SPY	ETF	120.72	120.9	120.51	120.67	370250.0
2011-10-12 07:00:00	SPY	ETF	120.63	120.75	120.3	120.3	1405866.0
2011-10-12 08:00:00	SPY	ETF	120.67	120.73	120.2	120.67	4478353.0
2011-10-12 09:00:00	SPY	ETF	120.68	120.9	120.33	120.8	31653100.0
2011-10-12 10:00:00	SPY	ETF	120.8	121.51	120.5	121.0198	46586180.0
2011-10-12 11:00:00	SPY	ETF	121.0	121.5	121.0	121.24	25330626.0
2011-10-12 12:00:00	SPY	ETF	121.23	121.73	121.05	121.65	18740306.0
2011-10-12 13:00:00	SPY	ETF	121.65	121.92	121.48	121.55	21286683.0
2011-10-12 14:00:00	SPY	ETF	121.55	122.14	121.3	121.4	37346405.0
2011-10-12 15:00:00	SPY	ETF	121.4	121.64	120.71	120.71	69504911.0
2011-10-12 16:00:00	SPY	ETF	120.72	121.43	119.6361	120.45	18386656.0
2011-10-12 17:00:00	SPY	ETF	120.48	120.52	120.4	120.43	201774.0
2011-10-12 18:00:00	SPY	ETF	120.45	120.67	120.45	120.5	101328.0
2011-10-12 19:00:00	SPY	ETF	120.54	120.57	120.38	120.4	141210.0
2011-10-12 04:00:00	QQQ	ETF	56.65	56.66	56.62	56.62	15600.0
2011-10-12 05:00:00	QQQ	ETF	56.65	56.88	56.65	56.84	17200.0
2011-10-12 06:00:00	QQQ	ETF	56.88	56.94	56.73	56.82	21050.0
2011-10-12 07:00:00	QQQ	ETF	56.8	56.97	56.75	56.77	570860.0
2011-10-12 08:00:00	QQQ	ETF	56.76	56.97	56.73	56.95	2128317.0
2011-10-12 09:00:00	QQQ	ETF	56.95	57.01	56.71	56.954	9784132.0
2011-10-12 10:00:00	QQQ	ETF	56.96	57.21	56.76	56.9	12495305.0
2011-10-12 11:00:00	QQQ	ETF	56.902	57.16	56.902	56.98	5235029.0
2011-10-12 12:00:00	QQQ	ETF	56.99	57.11	56.89	57.0899	4341219.0
2011-10-12 13:00:00	QQQ	ETF	57.09	57.23	56.98	57.01	6566075.0
2011-10-12 14:00:00	QQQ	ETF	57.01	57.22	56.72	56.8	12173905.0
2011-10-12 15:00:00	QQQ	ETF	56.79	56.98	56.56	56.61	16141853.0
2011-10-12 16:00:00	QQQ	ETF	56.62	56.87	56.36	56.54	2378614.0
2011-10-12 17:00:00	QQQ	ETF	56.52	56.64	56.45	56.49	63788.0
2011-10-12 18:00:00	QQQ	ETF	56.49	56.6	56.46	56.54	67080.0
2011-10-12 19:00:00	QQQ	ETF	56.57	56.62	56.51	56.62	78209.0
2011-10-12 05:00:00	IWM	ETF	69.07	69.37	69.07	69.37	766.0
2011-10-12 07:00:00	IWM	ETF	69.21	69.37	69.1	69.23	498072.0
2011-10-12 08:00:00	IWM	ETF	69.21	69.52	69.17	69.5	1011122.0
2011-10-12 09:00:00	IWM	ETF	69.49	69.74	69.19	69.71	11550231.0
2011-10-12 10:00:00	IWM	ETF	69.71	70.17	69.4	69.74	12629931.0
2011-10-12 11:00:00	IWM	ETF	69.75	70.02	69.7	69.7	3942943.0
2011-10-12 12:00:00	IWM	ETF	69.72	70.15	69.61	70.0401	3058130.0
2011-10-12 13:00:00	IWM	ETF	70.05	70.24	69.91	70.01	4770050.0
2011-10-12 14:00:00	IWM	ETF	70.01	70.53	69.73	69.88	10424371.0
2011-10-12 15:00:00	IWM	ETF	69.875	70.45	69.75	69.76	20268349.0
2011-10-12 16:00:00	IWM	ETF	69.76	70.3	68.8213	69.54	8683276.0
2011-10-12 17:00:00	IWM	ETF	69.6	69.6	69.48	69.6	79798.0
2011-10-12 18:00:00	IWM	ETF	69.64	69.69	69.64	69.68	25600.0
2011-10-12 19:00:00	IWM	ETF	69.63	69.71	69.63	69.69	20555.0
2011-10-12 05:00:00	DIA	ETF	114.59	114.97	114.59	114.97	600.0
2011-10-12 06:00:00	DIA	ETF	115.12	115.12	114.97	114.98	700.0
2011-10-12 07:00:00	DIA	ETF	114.82	114.82	114.68	114.68	1100.0
2011-10-12 08:00:00	DIA	ETF	114.63	114.95	114.6	114.95	23300.0

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

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