PREVIEW / etf_1hour / 2012-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-25.parquet
  size:    182 KB
  rows:    5,628

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-07-25 04:00:00	SPY	ETF	133.4	133.85	133.4	133.66	3260.0
2012-07-25 05:00:00	SPY	ETF	133.75	134.03	133.74	134.0	10604.0
2012-07-25 06:00:00	SPY	ETF	134.07	134.26	133.93	134.13	261179.0
2012-07-25 07:00:00	SPY	ETF	134.15	134.29	134.05	134.17	574550.0
2012-07-25 08:00:00	SPY	ETF	134.18	134.62	133.8	134.41	1966706.0
2012-07-25 09:00:00	SPY	ETF	134.41	134.56	133.92	134.07	16134322.0
2012-07-25 10:00:00	SPY	ETF	134.08	134.08	133.25	133.3399	23120902.0
2012-07-25 11:00:00	SPY	ETF	133.33	133.81	133.32	133.64	14163152.0
2012-07-25 12:00:00	SPY	ETF	133.64	133.97	133.56	133.83	8108978.0
2012-07-25 13:00:00	SPY	ETF	133.83	134.5	133.82	134.39	13577599.0
2012-07-25 14:00:00	SPY	ETF	134.39	134.51	134.21	134.35	7958230.0
2012-07-25 15:00:00	SPY	ETF	134.35	134.37	133.69	133.96	21987545.0
2012-07-25 16:00:00	SPY	ETF	133.96	134.17	133.7151	134.06	13700981.0
2012-07-25 17:00:00	SPY	ETF	133.9549	134.15	133.9549	134.14	3900903.0
2012-07-25 18:00:00	SPY	ETF	134.15	134.16	134.05	134.05	28850.0
2012-07-25 19:00:00	SPY	ETF	134.05	134.06	134.0	134.01	52393.0
2012-07-25 04:00:00	QQQ	ETF	62.32	62.32	62.24	62.25	2300.0
2012-07-25 05:00:00	QQQ	ETF	62.25	62.37	62.25	62.35	4550.0
2012-07-25 06:00:00	QQQ	ETF	62.34	62.42	62.34	62.4	11700.0
2012-07-25 07:00:00	QQQ	ETF	62.38	62.51	62.34	62.44	363354.0
2012-07-25 08:00:00	QQQ	ETF	62.45	62.62	62.03	62.59	1053538.0
2012-07-25 09:00:00	QQQ	ETF	62.58	62.89	62.43	62.69	7119992.0
2012-07-25 10:00:00	QQQ	ETF	62.69	62.74	62.15	62.21	9307263.0
2012-07-25 11:00:00	QQQ	ETF	62.21	62.57	62.2	62.51	4633870.0
2012-07-25 12:00:00	QQQ	ETF	62.5099	62.62	62.44	62.585	3221873.0
2012-07-25 13:00:00	QQQ	ETF	62.57	62.93	62.57	62.85	3634621.0
2012-07-25 14:00:00	QQQ	ETF	62.86	62.95	62.735	62.81	2299962.0
2012-07-25 15:00:00	QQQ	ETF	62.81	62.85	62.41	62.53	7632621.0
2012-07-25 16:00:00	QQQ	ETF	62.53	62.745	62.44	62.53	999364.0
2012-07-25 17:00:00	QQQ	ETF	62.53	62.59	62.53	62.55	26723.0
2012-07-25 18:00:00	QQQ	ETF	62.59	62.59	62.54	62.54	6000.0
2012-07-25 19:00:00	QQQ	ETF	62.55	62.58	62.54	62.57	2750.0
2012-07-25 04:00:00	IWM	ETF	76.55	76.6	76.53	76.6	848.0
2012-07-25 06:00:00	IWM	ETF	76.87	76.87	76.77	76.77	942.0
2012-07-25 07:00:00	IWM	ETF	76.81	77.0	76.66	77.0	96455.0
2012-07-25 08:00:00	IWM	ETF	76.98	77.21	76.71	77.15	389054.0
2012-07-25 09:00:00	IWM	ETF	77.13	77.375	76.78	76.96	5648133.0
2012-07-25 10:00:00	IWM	ETF	76.94	76.96	76.48	76.53	7977425.0
2012-07-25 11:00:00	IWM	ETF	76.53	76.82	76.475	76.68	5297062.0
2012-07-25 12:00:00	IWM	ETF	76.68	76.84	76.64	76.74	3179675.0
2012-07-25 13:00:00	IWM	ETF	76.74	77.105	76.72	76.96	3617877.0
2012-07-25 14:00:00	IWM	ETF	76.96	77.08	76.87	76.93	2068620.0
2012-07-25 15:00:00	IWM	ETF	76.92	76.94	76.51	76.8	5808695.0
2012-07-25 16:00:00	IWM	ETF	76.81	76.84	76.71	76.72	1028014.0
2012-07-25 17:00:00	IWM	ETF	76.74	76.75	76.74	76.75	5200.0
2012-07-25 18:00:00	IWM	ETF	76.85	76.85	76.85	76.85	100.0
2012-07-25 07:00:00	DIA	ETF	126.05	126.69	126.05	126.52	3200.0
2012-07-25 08:00:00	DIA	ETF	126.7	126.86	126.36	126.83	15505.0
2012-07-25 09:00:00	DIA	ETF	126.77	126.99	126.37	126.66	629814.0
2012-07-25 10:00:00	DIA	ETF	126.63	126.66	126.0	126.06	892385.0

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

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