PREVIEW / etf_1hour / 2012-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-13.parquet
  size:    180 KB
  rows:    5,517

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
2012-06-13 04:00:00	SPY	ETF	133.01	133.02	132.89	132.89	735.0
2012-06-13 05:00:00	SPY	ETF	132.86	133.18	132.81	132.87	10600.0
2012-06-13 06:00:00	SPY	ETF	132.87	133.1	132.83	132.83	85909.0
2012-06-13 07:00:00	SPY	ETF	132.86	132.98	132.68	132.96	334230.0
2012-06-13 08:00:00	SPY	ETF	132.92	132.98	132.39	132.56	2109483.0
2012-06-13 09:00:00	SPY	ETF	132.56	132.6	132.09	132.25	20829418.0
2012-06-13 10:00:00	SPY	ETF	132.25	133.3	132.23	133.2	28439170.0
2012-06-13 11:00:00	SPY	ETF	133.2	133.2	132.77	132.86	20474165.0
2012-06-13 12:00:00	SPY	ETF	132.86	133.36	132.59	133.11	16184883.0
2012-06-13 13:00:00	SPY	ETF	133.1	133.29	132.75	132.8	20095264.0
2012-06-13 14:00:00	SPY	ETF	132.81	132.87	132.28	132.3399	18415338.0
2012-06-13 15:00:00	SPY	ETF	132.33	132.43	131.62	132.09	33416133.0
2012-06-13 16:00:00	SPY	ETF	132.09	133.1499	131.79	131.91	10842407.0
2012-06-13 17:00:00	SPY	ETF	131.91	132.11	131.9	132.04	134578.0
2012-06-13 18:00:00	SPY	ETF	132.06	132.19	132.01	132.1	159367.0
2012-06-13 19:00:00	SPY	ETF	132.1	132.19	132.01	132.19	123420.0
2012-06-13 05:00:00	QQQ	ETF	62.5	62.5	62.5	62.5	1000.0
2012-06-13 07:00:00	QQQ	ETF	62.55	62.57	62.44	62.57	29650.0
2012-06-13 08:00:00	QQQ	ETF	62.57	62.63	62.35	62.43	352948.0
2012-06-13 09:00:00	QQQ	ETF	62.41	62.57	62.19	62.285	5884970.0
2012-06-13 10:00:00	QQQ	ETF	62.28	62.85	62.27	62.82	8184228.0
2012-06-13 11:00:00	QQQ	ETF	62.82	62.85	62.61	62.64	4035277.0
2012-06-13 12:00:00	QQQ	ETF	62.6377	62.78	62.465	62.68	3765151.0
2012-06-13 13:00:00	QQQ	ETF	62.68	62.77	62.47	62.5	4692149.0
2012-06-13 14:00:00	QQQ	ETF	62.5	62.54	62.23	62.27	4971865.0
2012-06-13 15:00:00	QQQ	ETF	62.26	62.31	61.92	62.11	9459227.0
2012-06-13 16:00:00	QQQ	ETF	62.11	62.8	61.9758	62.06	3376174.0
2012-06-13 17:00:00	QQQ	ETF	62.12	62.18	62.1	62.1	12025.0
2012-06-13 18:00:00	QQQ	ETF	62.15	62.2	62.15	62.17	15026.0
2012-06-13 19:00:00	QQQ	ETF	62.17	62.2	62.14	62.19	9150.0
2012-06-13 05:00:00	IWM	ETF	76.48	76.48	76.48	76.48	200.0
2012-06-13 06:00:00	IWM	ETF	76.52	76.52	76.46	76.46	1000.0
2012-06-13 07:00:00	IWM	ETF	76.37	76.42	76.22	76.4	30200.0
2012-06-13 08:00:00	IWM	ETF	76.38	76.42	75.99	76.13	267332.0
2012-06-13 09:00:00	IWM	ETF	76.06	76.13	75.47	75.61	7945645.0
2012-06-13 10:00:00	IWM	ETF	75.6	76.52	75.5	76.48	9476929.0
2012-06-13 11:00:00	IWM	ETF	76.476	76.476	76.08	76.19	4548161.0
2012-06-13 12:00:00	IWM	ETF	76.19	76.54	75.88	76.39	4067764.0
2012-06-13 13:00:00	IWM	ETF	76.38	76.525	76.0	76.04	5851604.0
2012-06-13 14:00:00	IWM	ETF	76.04	76.11	75.53	75.65	6188545.0
2012-06-13 15:00:00	IWM	ETF	75.65	75.7	74.995	75.38	14129935.0
2012-06-13 16:00:00	IWM	ETF	75.39	75.45	75.2	75.22	1569889.0
2012-06-13 17:00:00	IWM	ETF	75.28	75.4	75.28	75.39	41317.0
2012-06-13 18:00:00	IWM	ETF	75.39	75.4	75.39	75.4	951.0
2012-06-13 19:00:00	IWM	ETF	75.39	75.5	75.39	75.5	986.0
2012-06-13 08:00:00	DIA	ETF	125.49	125.55	125.28	125.39	3300.0
2012-06-13 09:00:00	DIA	ETF	125.35	125.39	124.93	125.04	641280.0
2012-06-13 10:00:00	DIA	ETF	125.02	125.86	125.02	125.79	549052.0
2012-06-13 11:00:00	DIA	ETF	125.77	125.77	125.46	125.5415	597224.0
2012-06-13 12:00:00	DIA	ETF	125.54	125.94	125.32	125.73	636214.0

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

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