PREVIEW / etf_1hour / 2013-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-06.parquet
  size:    199 KB
  rows:    6,236

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-03-06 04:00:00	SPY	ETF	154.55	154.86	154.55	154.69	23285.0
2013-03-06 05:00:00	SPY	ETF	154.78	154.78	154.65	154.65	27900.0
2013-03-06 06:00:00	SPY	ETF	154.62	154.75	154.59	154.72	59350.0
2013-03-06 07:00:00	SPY	ETF	154.72	154.76	154.65	154.72	469165.0
2013-03-06 08:00:00	SPY	ETF	154.72	154.93	154.67	154.87	1157701.0
2013-03-06 09:00:00	SPY	ETF	154.86	154.92	154.52	154.83	16548207.0
2013-03-06 10:00:00	SPY	ETF	154.82	154.829	154.35	154.36	16903855.0
2013-03-06 11:00:00	SPY	ETF	154.35	154.54	154.33	154.36	10922057.0
2013-03-06 12:00:00	SPY	ETF	154.37	154.52	154.16	154.318	8575328.0
2013-03-06 13:00:00	SPY	ETF	154.32	154.6	154.25	154.51	5695511.0
2013-03-06 14:00:00	SPY	ETF	154.519	154.86	154.38	154.765	10933393.0
2013-03-06 15:00:00	SPY	ETF	154.76	154.79	154.33	154.51	14329749.0
2013-03-06 16:00:00	SPY	ETF	154.51	154.691	154.31	154.39	8044900.0
2013-03-06 17:00:00	SPY	ETF	154.4	154.44	154.38	154.41	73628.0
2013-03-06 18:00:00	SPY	ETF	154.41	154.41	154.33	154.38	45134.0
2013-03-06 19:00:00	SPY	ETF	154.37	154.38	154.29	154.31	68740.0
2013-03-06 04:00:00	QQQ	ETF	68.8	68.9	68.8	68.87	1100.0
2013-03-06 05:00:00	QQQ	ETF	68.86	68.86	68.83	68.83	1400.0
2013-03-06 06:00:00	QQQ	ETF	68.82	68.82	68.8	68.8	6600.0
2013-03-06 07:00:00	QQQ	ETF	68.77	68.8	68.75	68.77	2772.0
2013-03-06 08:00:00	QQQ	ETF	68.77	68.85	68.74	68.83	434248.0
2013-03-06 09:00:00	QQQ	ETF	68.82	68.908	68.57	68.65	4460501.0
2013-03-06 10:00:00	QQQ	ETF	68.66	68.7	68.44	68.45	6992356.0
2013-03-06 11:00:00	QQQ	ETF	68.4599	68.61	68.4401	68.51	4098292.0
2013-03-06 12:00:00	QQQ	ETF	68.509	68.55	68.42	68.43	1378135.0
2013-03-06 13:00:00	QQQ	ETF	68.45	68.58	68.42	68.539	1445299.0
2013-03-06 14:00:00	QQQ	ETF	68.53	68.69	68.46	68.63	1921672.0
2013-03-06 15:00:00	QQQ	ETF	68.62	68.63	68.42	68.51	3016293.0
2013-03-06 16:00:00	QQQ	ETF	68.51	68.62	68.42	68.45	576304.0
2013-03-06 17:00:00	QQQ	ETF	68.46	68.47	68.45	68.45	10910.0
2013-03-06 18:00:00	QQQ	ETF	68.45	68.45	68.43	68.43	7490.0
2013-03-06 19:00:00	QQQ	ETF	68.46	68.53	68.46	68.51	109250.0
2013-03-06 04:00:00	IWM	ETF	92.3	92.3	92.3	92.3	100.0
2013-03-06 07:00:00	IWM	ETF	92.3	92.4	92.3	92.37	61050.0
2013-03-06 08:00:00	IWM	ETF	92.38	92.47	92.36	92.47	259170.0
2013-03-06 09:00:00	IWM	ETF	92.46	92.6	92.22	92.55	4302079.0
2013-03-06 10:00:00	IWM	ETF	92.55	92.6	92.23	92.255	5876374.0
2013-03-06 11:00:00	IWM	ETF	92.258	92.5	92.21	92.28	4582557.0
2013-03-06 12:00:00	IWM	ETF	92.2801	92.35	92.12	92.16	2631120.0
2013-03-06 13:00:00	IWM	ETF	92.16	92.36	92.14	92.32	881275.0
2013-03-06 14:00:00	IWM	ETF	92.31	92.55	92.24	92.49	1789664.0
2013-03-06 15:00:00	IWM	ETF	92.48	92.5	92.24	92.44	3864261.0
2013-03-06 16:00:00	IWM	ETF	92.43	92.43	92.27	92.33	920147.0
2013-03-06 17:00:00	IWM	ETF	92.3	92.38	92.3	92.38	45000.0
2013-03-06 18:00:00	IWM	ETF	92.33	92.33	92.33	92.33	100.0
2013-03-06 19:00:00	IWM	ETF	92.3	92.3	92.3	92.3	500.0
2013-03-06 06:00:00	DIA	ETF	142.76	142.76	142.76	142.76	500.0
2013-03-06 07:00:00	DIA	ETF	142.76	142.8	142.76	142.8	400.0
2013-03-06 08:00:00	DIA	ETF	142.77	142.93	142.77	142.93	24338.0
2013-03-06 09:00:00	DIA	ETF	142.89	143.07	142.61	143.0	807559.0

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

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