PREVIEW / etf_1hour / 2012-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-09.parquet
  size:    191 KB
  rows:    5,945

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-05-09 04:00:00	SPY	ETF	136.1	136.1	135.41	135.41	26200.0
2012-05-09 05:00:00	SPY	ETF	135.44	135.66	135.44	135.56	45425.0
2012-05-09 06:00:00	SPY	ETF	135.61	135.65	135.16	135.29	90092.0
2012-05-09 07:00:00	SPY	ETF	135.3	135.49	135.06	135.46	780781.0
2012-05-09 08:00:00	SPY	ETF	135.46	135.9	134.96	135.04	2031497.0
2012-05-09 09:00:00	SPY	ETF	135.03	135.94	134.88	135.19	23639422.0
2012-05-09 10:00:00	SPY	ETF	135.19	135.52	134.49	135.2	50443867.0
2012-05-09 11:00:00	SPY	ETF	135.2	136.21	135.03	135.89	31257753.0
2012-05-09 12:00:00	SPY	ETF	135.89	135.93	135.42	135.8	18557970.0
2012-05-09 13:00:00	SPY	ETF	135.8	136.61	135.77	136.32	24801909.0
2012-05-09 14:00:00	SPY	ETF	136.32	136.38	135.88	135.9	18950710.0
2012-05-09 15:00:00	SPY	ETF	135.89	136.19	135.63	135.73	35968935.0
2012-05-09 16:00:00	SPY	ETF	135.73	135.9722	135.32	135.36	10750379.0
2012-05-09 17:00:00	SPY	ETF	135.665	135.665	135.12	135.3	2705912.0
2012-05-09 18:00:00	SPY	ETF	135.3	135.42	135.29	135.42	145925.0
2012-05-09 19:00:00	SPY	ETF	135.41	135.5	135.4	135.48	106881.0
2012-05-09 05:00:00	QQQ	ETF	64.06	64.07	64.05	64.05	1700.0
2012-05-09 06:00:00	QQQ	ETF	64.06	64.06	63.87	63.89	4300.0
2012-05-09 07:00:00	QQQ	ETF	63.92	64.0	63.8	64.0	90880.0
2012-05-09 08:00:00	QQQ	ETF	64.0	64.02	63.77	63.85	384264.0
2012-05-09 09:00:00	QQQ	ETF	63.83	64.15	63.72	64.095	6706603.0
2012-05-09 10:00:00	QQQ	ETF	64.09	64.19	63.51	64.001	16212897.0
2012-05-09 11:00:00	QQQ	ETF	64.0	64.585	63.91	64.43	14775407.0
2012-05-09 12:00:00	QQQ	ETF	64.43	64.4423	64.13	64.32	5471699.0
2012-05-09 13:00:00	QQQ	ETF	64.31	64.68	64.15	64.509	10565470.0
2012-05-09 14:00:00	QQQ	ETF	64.515	64.62	64.38	64.4	5466076.0
2012-05-09 15:00:00	QQQ	ETF	64.39	64.57	64.25	64.37	10042930.0
2012-05-09 16:00:00	QQQ	ETF	64.38	64.5231	64.08	64.09	7731687.0
2012-05-09 17:00:00	QQQ	ETF	64.09	64.31	63.9	63.95	663777.0
2012-05-09 18:00:00	QQQ	ETF	63.96	64.04	63.96	64.04	35800.0
2012-05-09 19:00:00	QQQ	ETF	64.05	64.09	64.04	64.07	6350.0
2012-05-09 04:00:00	IWM	ETF	78.85	78.85	78.5	78.5	8300.0
2012-05-09 05:00:00	IWM	ETF	78.39	78.53	78.39	78.53	4300.0
2012-05-09 06:00:00	IWM	ETF	78.53	78.53	78.25	78.25	12569.0
2012-05-09 07:00:00	IWM	ETF	78.22	78.47	78.2	78.47	128099.0
2012-05-09 08:00:00	IWM	ETF	78.48	78.52	78.14	78.22	534702.0
2012-05-09 09:00:00	IWM	ETF	78.21	78.47	78.02	78.34	6480411.0
2012-05-09 10:00:00	IWM	ETF	78.35	78.6	77.97	78.33	15243883.0
2012-05-09 11:00:00	IWM	ETF	78.34	79.0	78.21	78.76	12192300.0
2012-05-09 12:00:00	IWM	ETF	78.76	78.8	78.37	78.62	5336250.0
2012-05-09 13:00:00	IWM	ETF	78.62	79.26	78.62	79.13	7104346.0
2012-05-09 14:00:00	IWM	ETF	79.12	79.155	78.82	78.85	4114268.0
2012-05-09 15:00:00	IWM	ETF	78.84	79.1	78.71	78.83	7929421.0
2012-05-09 16:00:00	IWM	ETF	78.83	79.11	78.47	78.47	2060318.0
2012-05-09 17:00:00	IWM	ETF	78.47	78.47	78.3	78.35	94170.0
2012-05-09 18:00:00	IWM	ETF	78.47	78.47	78.45	78.47	1100.0
2012-05-09 19:00:00	IWM	ETF	78.46	78.58	78.46	78.58	2500.0
2012-05-09 04:00:00	DIA	ETF	128.8	128.8	128.38	128.38	600.0
2012-05-09 06:00:00	DIA	ETF	128.24	128.24	128.24	128.24	600.0
2012-05-09 07:00:00	DIA	ETF	128.0	128.2	127.97	128.2	2800.0

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

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