PREVIEW / etf_1hour / 2012-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-12.parquet
  size:    187 KB
  rows:    5,908

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-09-12 04:00:00	SPY	ETF	143.93	144.6	143.93	144.4	132370.0
2012-09-12 05:00:00	SPY	ETF	144.4	144.54	144.33	144.54	36289.0
2012-09-12 06:00:00	SPY	ETF	144.52	144.52	144.25	144.28	120900.0
2012-09-12 07:00:00	SPY	ETF	144.3	144.42	144.11	144.19	378306.0
2012-09-12 08:00:00	SPY	ETF	144.22	144.4	144.1	144.24	890685.0
2012-09-12 09:00:00	SPY	ETF	144.22	144.55	144.15	144.35	12987450.0
2012-09-12 10:00:00	SPY	ETF	144.36	144.47	143.95	144.18	15279419.0
2012-09-12 11:00:00	SPY	ETF	144.18	144.42	144.171	144.2701	9809101.0
2012-09-12 12:00:00	SPY	ETF	144.28	144.34	144.14	144.32	5200290.0
2012-09-12 13:00:00	SPY	ETF	144.32	144.53	144.25	144.35	9235727.0
2012-09-12 14:00:00	SPY	ETF	144.36	144.409	144.1	144.16	8307907.0
2012-09-12 15:00:00	SPY	ETF	144.155	144.33	143.9	144.33	17052110.0
2012-09-12 16:00:00	SPY	ETF	144.33	144.65	144.33	144.44	5615934.0
2012-09-12 17:00:00	SPY	ETF	144.43	144.53	144.43	144.44	2122962.0
2012-09-12 18:00:00	SPY	ETF	144.49	144.53	144.46	144.5	14766.0
2012-09-12 19:00:00	SPY	ETF	144.53	144.57	144.48	144.53	29616.0
2012-09-12 04:00:00	QQQ	ETF	68.63	68.7	68.63	68.7	3200.0
2012-09-12 05:00:00	QQQ	ETF	68.79	68.79	68.75	68.75	700.0
2012-09-12 06:00:00	QQQ	ETF	68.81	68.81	68.7	68.7	16540.0
2012-09-12 07:00:00	QQQ	ETF	68.7	68.72	68.59	68.6	30339.0
2012-09-12 08:00:00	QQQ	ETF	68.63	68.7	68.59	68.65	97783.0
2012-09-12 09:00:00	QQQ	ETF	68.66	68.81	68.55	68.599	4365781.0
2012-09-12 10:00:00	QQQ	ETF	68.6	68.64	68.34	68.48	4822859.0
2012-09-12 11:00:00	QQQ	ETF	68.48	68.59	68.4	68.53	3873838.0
2012-09-12 12:00:00	QQQ	ETF	68.54	68.57	68.4001	68.56	1880644.0
2012-09-12 13:00:00	QQQ	ETF	68.558	68.75	68.44	68.61	5074403.0
2012-09-12 14:00:00	QQQ	ETF	68.61	68.69	68.38	68.41	3307231.0
2012-09-12 15:00:00	QQQ	ETF	68.41	68.64	68.21	68.64	6623274.0
2012-09-12 16:00:00	QQQ	ETF	68.65	68.78	68.3995	68.71	1398361.0
2012-09-12 17:00:00	QQQ	ETF	68.73	68.75	68.71	68.71	9385.0
2012-09-12 18:00:00	QQQ	ETF	68.72	68.75	68.72	68.73	4700.0
2012-09-12 19:00:00	QQQ	ETF	68.75	68.82	68.73	68.73	7741.0
2012-09-12 04:00:00	IWM	ETF	84.4	84.47	84.4	84.47	200.0
2012-09-12 05:00:00	IWM	ETF	84.44	84.44	84.44	84.44	2000.0
2012-09-12 06:00:00	IWM	ETF	84.45	84.45	84.45	84.45	200.0
2012-09-12 07:00:00	IWM	ETF	84.38	84.43	84.31	84.33	35280.0
2012-09-12 08:00:00	IWM	ETF	84.34	84.4	84.26	84.33	102032.0
2012-09-12 09:00:00	IWM	ETF	84.32	84.65	84.25	84.3	3868529.0
2012-09-12 10:00:00	IWM	ETF	84.31	84.4	83.9	84.13	5303710.0
2012-09-12 11:00:00	IWM	ETF	84.13	84.54	84.13	84.37	3712857.0
2012-09-12 12:00:00	IWM	ETF	84.37	84.47	84.27	84.42	1450041.0
2012-09-12 13:00:00	IWM	ETF	84.42	84.49	84.3	84.34	1548965.0
2012-09-12 14:00:00	IWM	ETF	84.35	84.43	84.1	84.21	3786341.0
2012-09-12 15:00:00	IWM	ETF	84.22	84.49	84.06	84.49	6196282.0
2012-09-12 16:00:00	IWM	ETF	84.49	84.7	84.35	84.61	2447201.0
2012-09-12 17:00:00	IWM	ETF	84.62	84.65	84.62	84.65	4800.0
2012-09-12 18:00:00	IWM	ETF	84.65	84.65	84.65	84.65	800.0
2012-09-12 19:00:00	IWM	ETF	84.64	84.69	84.64	84.69	1060.0
2012-09-12 07:00:00	DIA	ETF	133.3	133.3	133.3	133.3	500.0
2012-09-12 08:00:00	DIA	ETF	133.3	133.38	133.29	133.31	6100.0

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

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