PREVIEW / etf_1hour / 2013-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-10.parquet
  size:    205 KB
  rows:    6,492

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
2013-06-10 04:00:00	SPY	ETF	164.85	165.17	164.5	165.08	53600.0
2013-06-10 05:00:00	SPY	ETF	165.08	165.14	165.0	165.1	77425.0
2013-06-10 06:00:00	SPY	ETF	165.05	165.08	164.96	165.06	83673.0
2013-06-10 07:00:00	SPY	ETF	165.03	165.24	164.96	165.0	276562.0
2013-06-10 08:00:00	SPY	ETF	165.06	165.16	164.5	165.06	1988548.0
2013-06-10 09:00:00	SPY	ETF	165.05	165.4	164.21	164.76	18307305.0
2013-06-10 10:00:00	SPY	ETF	164.77	165.17	164.37	165.02	17863031.0
2013-06-10 11:00:00	SPY	ETF	165.02	165.24	164.85	165.07	10531937.0
2013-06-10 12:00:00	SPY	ETF	165.07	165.29	164.72	164.78	7904810.0
2013-06-10 13:00:00	SPY	ETF	164.79	164.92	164.54	164.78	7480180.0
2013-06-10 14:00:00	SPY	ETF	164.79	164.99	164.47	164.97	9477558.0
2013-06-10 15:00:00	SPY	ETF	164.96	164.98	164.54	164.76	13748856.0
2013-06-10 16:00:00	SPY	ETF	164.77	164.8585	164.5	164.76	7281523.0
2013-06-10 17:00:00	SPY	ETF	164.77	164.88	164.75	164.76	6019735.0
2013-06-10 18:00:00	SPY	ETF	164.75	164.8	164.69	164.76	89625.0
2013-06-10 19:00:00	SPY	ETF	164.75	164.77	164.71	164.75	34329.0
2013-06-10 04:00:00	QQQ	ETF	73.46	73.52	73.44	73.48	8900.0
2013-06-10 05:00:00	QQQ	ETF	73.46	73.48	73.44	73.48	2400.0
2013-06-10 06:00:00	QQQ	ETF	73.46	73.46	73.42	73.46	2600.0
2013-06-10 07:00:00	QQQ	ETF	73.47	73.52	73.44	73.44	24429.0
2013-06-10 08:00:00	QQQ	ETF	73.46	73.52	73.3	73.42	737771.0
2013-06-10 09:00:00	QQQ	ETF	73.43	73.55	73.35	73.47	4212382.0
2013-06-10 10:00:00	QQQ	ETF	73.48	73.71	73.33	73.64	4187948.0
2013-06-10 11:00:00	QQQ	ETF	73.64	73.74	73.58	73.68	3696112.0
2013-06-10 12:00:00	QQQ	ETF	73.69	73.76	73.49	73.5	2110643.0
2013-06-10 13:00:00	QQQ	ETF	73.509	73.59	73.36	73.48	2200070.0
2013-06-10 14:00:00	QQQ	ETF	73.49	73.5471	73.26	73.49	2057171.0
2013-06-10 15:00:00	QQQ	ETF	73.49	73.49	73.31	73.42	2880245.0
2013-06-10 16:00:00	QQQ	ETF	73.41	73.42	73.37	73.4083	2714426.0
2013-06-10 17:00:00	QQQ	ETF	73.37	73.4	73.37	73.4	700.0
2013-06-10 18:00:00	QQQ	ETF	73.39	73.39	73.34	73.34	3900.0
2013-06-10 19:00:00	QQQ	ETF	73.37	73.37	73.35	73.35	2500.0
2013-06-10 06:00:00	IWM	ETF	98.21	98.25	98.21	98.25	2400.0
2013-06-10 07:00:00	IWM	ETF	98.3	98.45	98.3	98.4	397798.0
2013-06-10 08:00:00	IWM	ETF	98.4	98.43	98.08	98.3	156437.0
2013-06-10 09:00:00	IWM	ETF	98.36	98.75	97.81	98.07	5748082.0
2013-06-10 10:00:00	IWM	ETF	98.09	98.6601	97.85	98.47	6173374.0
2013-06-10 11:00:00	IWM	ETF	98.465	98.78	98.42	98.61	4078758.0
2013-06-10 12:00:00	IWM	ETF	98.605	98.8	98.39	98.49	2841472.0
2013-06-10 13:00:00	IWM	ETF	98.48	98.63	98.43	98.57	2192920.0
2013-06-10 14:00:00	IWM	ETF	98.57	98.74	98.38	98.72	2306871.0
2013-06-10 15:00:00	IWM	ETF	98.72	98.8	98.54	98.79	4888201.0
2013-06-10 16:00:00	IWM	ETF	98.8	98.81	98.4578	98.74	1282617.0
2013-06-10 17:00:00	IWM	ETF	98.73	98.73	98.73	98.73	120.0
2013-06-10 18:00:00	IWM	ETF	98.73	98.73	98.73	98.73	100.0
2013-06-10 05:00:00	DIA	ETF	152.56	152.56	152.5	152.53	2684.0
2013-06-10 07:00:00	DIA	ETF	152.55	152.57	152.54	152.54	5084.0
2013-06-10 08:00:00	DIA	ETF	152.52	152.59	152.28	152.59	35187.0
2013-06-10 09:00:00	DIA	ETF	152.61	152.88	152.24	152.32	1040291.0
2013-06-10 10:00:00	DIA	ETF	152.33	152.61	151.98	152.48	958828.0

> showing 50 of 6,492 rows — these rows as CSV

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