PREVIEW / etf_1hour / 2011-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-05.parquet
  size:    200 KB
  rows:    6,221

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-08-05 04:00:00	SPY	ETF	120.26	120.51	119.44	119.93	15180.0
2011-08-05 05:00:00	SPY	ETF	119.88	120.15	119.59	119.59	3200.0
2011-08-05 06:00:00	SPY	ETF	119.55	120.42	119.45	120.16	80730.0
2011-08-05 07:00:00	SPY	ETF	120.11	120.58	119.78	120.56	1763211.0
2011-08-05 08:00:00	SPY	ETF	120.53	122.5	119.82	121.41	28149949.0
2011-08-05 09:00:00	SPY	ETF	121.41	122.21	119.01	119.07	88276275.0
2011-08-05 10:00:00	SPY	ETF	119.07	120.82	118.81	119.95	98972339.0
2011-08-05 11:00:00	SPY	ETF	119.94	119.95	116.86	117.21	94726705.0
2011-08-05 12:00:00	SPY	ETF	117.21	121.53	117.06	120.95	126792923.0
2011-08-05 13:00:00	SPY	ETF	120.95	121.75	119.94	121.33	60098223.0
2011-08-05 14:00:00	SPY	ETF	121.33	121.4	120.01	120.36	43279796.0
2011-08-05 15:00:00	SPY	ETF	120.35	120.54	118.98	120.03	86259170.0
2011-08-05 16:00:00	SPY	ETF	120.01	121.8518	119.04	119.57	21040884.0
2011-08-05 17:00:00	SPY	ETF	119.58	120.1744	119.55	119.94	1925639.0
2011-08-05 18:00:00	SPY	ETF	119.9	120.01	119.8	120.01	440604.0
2011-08-05 19:00:00	SPY	ETF	120.0	120.05	119.12	119.52	280079.0
2011-08-05 04:00:00	QQQ	ETF	54.21	54.21	53.98	53.98	1795.0
2011-08-05 05:00:00	QQQ	ETF	54.08	54.08	53.9	53.9	600.0
2011-08-05 06:00:00	QQQ	ETF	53.8	54.17	53.8	54.15	21887.0
2011-08-05 07:00:00	QQQ	ETF	54.08	54.28	53.96	54.26	789500.0
2011-08-05 08:00:00	QQQ	ETF	54.28	55.07	53.97	54.62	6155336.0
2011-08-05 09:00:00	QQQ	ETF	54.62	55.03	53.37	53.5095	33040184.0
2011-08-05 10:00:00	QQQ	ETF	53.5	54.455	53.3	53.9801	35528285.0
2011-08-05 11:00:00	QQQ	ETF	53.98	53.99	52.32	52.529	29702050.0
2011-08-05 12:00:00	QQQ	ETF	52.54	54.6	52.46	54.32	42818949.0
2011-08-05 13:00:00	QQQ	ETF	54.32	54.65	53.81	54.44	18529965.0
2011-08-05 14:00:00	QQQ	ETF	54.43	54.48	53.735	53.9	10593668.0
2011-08-05 15:00:00	QQQ	ETF	53.89	54.06	53.33	53.84	17247425.0
2011-08-05 16:00:00	QQQ	ETF	53.85	53.93	53.58	53.6	1953768.0
2011-08-05 17:00:00	QQQ	ETF	53.6	53.76	53.51	53.6	189731.0
2011-08-05 18:00:00	QQQ	ETF	53.65	53.72	53.6	53.7	25073.0
2011-08-05 19:00:00	QQQ	ETF	53.63	53.7	53.55	53.7	23100.0
2011-08-05 04:00:00	IWM	ETF	72.5	72.5	72.01	72.01	543.0
2011-08-05 05:00:00	IWM	ETF	72.0	72.0	72.0	72.0	5750.0
2011-08-05 06:00:00	IWM	ETF	71.92	72.46	71.89	72.4	2400.0
2011-08-05 07:00:00	IWM	ETF	72.37	72.7	72.01	72.69	85983.0
2011-08-05 08:00:00	IWM	ETF	72.55	74.0	72.4	73.27	3226320.0
2011-08-05 09:00:00	IWM	ETF	73.24	73.85	70.75	70.94	25779577.0
2011-08-05 10:00:00	IWM	ETF	70.93	72.74	70.66	71.93	31850733.0
2011-08-05 11:00:00	IWM	ETF	71.94	71.94	69.66	69.95	28846877.0
2011-08-05 12:00:00	IWM	ETF	69.94	72.89	69.825	72.35	37355632.0
2011-08-05 13:00:00	IWM	ETF	72.34	72.9	71.58	72.58	15794420.0
2011-08-05 14:00:00	IWM	ETF	72.57	72.64	71.66	71.81	9468978.0
2011-08-05 15:00:00	IWM	ETF	71.81	72.01	70.91	71.33	18711934.0
2011-08-05 16:00:00	IWM	ETF	71.3	71.87	71.24	71.41	3468716.0
2011-08-05 17:00:00	IWM	ETF	71.43	71.75	71.41	71.58	73643.0
2011-08-05 18:00:00	IWM	ETF	71.5	71.58	71.45	71.55	16700.0
2011-08-05 19:00:00	IWM	ETF	71.46	71.53	71.3	71.38	40986.0
2011-08-05 04:00:00	DIA	ETF	114.0	114.0	114.0	114.0	100.0
2011-08-05 05:00:00	DIA	ETF	113.3	113.3	113.23	113.23	400.0

> showing 50 of 6,221 rows — these rows as CSV

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