PREVIEW / etf_1hour / 2012-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-12.parquet
  size:    183 KB
  rows:    5,671

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-12 04:00:00	SPY	ETF	131.61	132.09	131.52	132.09	8330.0
2012-06-12 05:00:00	SPY	ETF	132.09	132.09	131.66	131.92	37110.0
2012-06-12 06:00:00	SPY	ETF	131.92	132.12	131.84	131.89	174275.0
2012-06-12 07:00:00	SPY	ETF	131.9	131.9	131.62	131.67	487244.0
2012-06-12 08:00:00	SPY	ETF	131.67	132.09	131.45	131.68	2026208.0
2012-06-12 09:00:00	SPY	ETF	131.69	132.1	131.45	131.79	27416427.0
2012-06-12 10:00:00	SPY	ETF	131.79	132.13	131.16	131.65	38201327.0
2012-06-12 11:00:00	SPY	ETF	131.65	132.64	131.64	132.24	28898536.0
2012-06-12 12:00:00	SPY	ETF	132.23	132.38	131.98	132.059	11573356.0
2012-06-12 13:00:00	SPY	ETF	132.06	132.46	131.98	132.19	14657931.0
2012-06-12 14:00:00	SPY	ETF	132.19	132.6	132.07	132.43	14015211.0
2012-06-12 15:00:00	SPY	ETF	132.43	132.99	132.29	132.95	27484814.0
2012-06-12 16:00:00	SPY	ETF	132.94	133.28	131.4246	133.09	12711782.0
2012-06-12 17:00:00	SPY	ETF	133.09	133.13	133.04	133.07	238505.0
2012-06-12 18:00:00	SPY	ETF	133.09	133.1	133.03	133.07	29799.0
2012-06-12 19:00:00	SPY	ETF	133.06	133.14	133.01	133.01	126623.0
2012-06-12 04:00:00	QQQ	ETF	61.95	62.15	61.93	62.15	500.0
2012-06-12 05:00:00	QQQ	ETF	62.22	62.22	62.22	62.22	100.0
2012-06-12 06:00:00	QQQ	ETF	62.21	62.24	62.16	62.18	3900.0
2012-06-12 07:00:00	QQQ	ETF	62.15	62.15	62.02	62.03	37415.0
2012-06-12 08:00:00	QQQ	ETF	62.03	62.12	61.93	62.06	222754.0
2012-06-12 09:00:00	QQQ	ETF	62.07	62.27	61.9818	62.08	8619512.0
2012-06-12 10:00:00	QQQ	ETF	62.09	62.18	61.68	61.93	10228462.0
2012-06-12 11:00:00	QQQ	ETF	61.93	62.49	61.9289	62.33	6250060.0
2012-06-12 12:00:00	QQQ	ETF	62.33	62.4401	62.1	62.15	3644711.0
2012-06-12 13:00:00	QQQ	ETF	62.15	62.33	62.11	62.1892	3420527.0
2012-06-12 14:00:00	QQQ	ETF	62.19	62.4	62.14	62.29	3536579.0
2012-06-12 15:00:00	QQQ	ETF	62.295	62.59	62.24	62.56	6315106.0
2012-06-12 16:00:00	QQQ	ETF	62.56	62.71	61.8546	62.6	2906851.0
2012-06-12 17:00:00	QQQ	ETF	62.61	62.62	62.59	62.6	16146.0
2012-06-12 18:00:00	QQQ	ETF	62.6	62.62	62.58	62.61	12300.0
2012-06-12 19:00:00	QQQ	ETF	62.6	62.61	62.58	62.6	9026.0
2012-06-12 04:00:00	IWM	ETF	75.44	75.59	75.44	75.59	1000.0
2012-06-12 05:00:00	IWM	ETF	75.56	75.56	75.3	75.3	3100.0
2012-06-12 06:00:00	IWM	ETF	75.62	75.74	75.43	75.59	9900.0
2012-06-12 07:00:00	IWM	ETF	75.4	75.49	75.35	75.37	91976.0
2012-06-12 08:00:00	IWM	ETF	75.34	75.53	75.23	75.32	284866.0
2012-06-12 09:00:00	IWM	ETF	75.35	75.79	75.34	75.45	6822331.0
2012-06-12 10:00:00	IWM	ETF	75.45	75.76	74.78	75.19	15325029.0
2012-06-12 11:00:00	IWM	ETF	75.19	75.98	75.18	75.6	7788584.0
2012-06-12 12:00:00	IWM	ETF	75.61	75.74	75.38	75.62	3486317.0
2012-06-12 13:00:00	IWM	ETF	75.62	76.02	75.6	75.76	4085597.0
2012-06-12 14:00:00	IWM	ETF	75.76	76.06	75.7199	75.98	3382002.0
2012-06-12 15:00:00	IWM	ETF	75.98	76.25	75.83	76.21	7030409.0
2012-06-12 16:00:00	IWM	ETF	76.23	76.56	75.5679	76.38	2766508.0
2012-06-12 17:00:00	IWM	ETF	76.42	76.42	76.34	76.36	15600.0
2012-06-12 07:00:00	DIA	ETF	124.36	124.38	124.35	124.38	3600.0
2012-06-12 08:00:00	DIA	ETF	124.16	124.44	124.16	124.3	4700.0
2012-06-12 09:00:00	DIA	ETF	124.62	124.62	124.115	124.42	777587.0
2012-06-12 10:00:00	DIA	ETF	124.44	124.75	124.035	124.436	947440.0

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

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