PREVIEW / etf_1hour / 2011-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-10.parquet
  size:    180 KB
  rows:    5,611

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
2011-10-10 04:00:00	SPY	ETF	116.91	117.43	116.91	117.4	24287.0
2011-10-10 05:00:00	SPY	ETF	117.4	117.46	117.35	117.46	3468.0
2011-10-10 06:00:00	SPY	ETF	117.42	117.77	117.42	117.47	145389.0
2011-10-10 07:00:00	SPY	ETF	117.45	117.71	117.35	117.48	1214901.0
2011-10-10 08:00:00	SPY	ETF	117.45	117.7	117.4	117.46	1620254.0
2011-10-10 09:00:00	SPY	ETF	117.46	118.38	117.44	118.34	28366035.0
2011-10-10 10:00:00	SPY	ETF	118.33	119.11	118.21	118.82	43569114.0
2011-10-10 11:00:00	SPY	ETF	118.82	119.03	118.65	118.941	25808189.0
2011-10-10 12:00:00	SPY	ETF	118.95	119.03	118.73	118.841	15136928.0
2011-10-10 13:00:00	SPY	ETF	118.84	119.23	118.78	118.97	14905245.0
2011-10-10 14:00:00	SPY	ETF	118.98	119.06	118.74	118.763	14282129.0
2011-10-10 15:00:00	SPY	ETF	118.76	119.59	118.24	119.59	60962697.0
2011-10-10 16:00:00	SPY	ETF	119.6	119.78	118.3556	119.56	19825571.0
2011-10-10 17:00:00	SPY	ETF	119.54	119.59	119.42	119.5	439861.0
2011-10-10 18:00:00	SPY	ETF	119.49	119.58	119.26	119.47	219067.0
2011-10-10 19:00:00	SPY	ETF	119.46	119.59	119.41	119.48	343217.0
2011-10-10 04:00:00	QQQ	ETF	54.68	54.75	54.68	54.75	3217.0
2011-10-10 05:00:00	QQQ	ETF	54.82	54.82	54.75	54.75	1100.0
2011-10-10 06:00:00	QQQ	ETF	54.9	54.96	54.89	54.9	1300.0
2011-10-10 07:00:00	QQQ	ETF	54.76	54.95	54.76	54.85	92558.0
2011-10-10 08:00:00	QQQ	ETF	54.84	54.93	54.84	54.88	182971.0
2011-10-10 09:00:00	QQQ	ETF	54.88	55.38	54.88	55.36	6980190.0
2011-10-10 10:00:00	QQQ	ETF	55.37	55.82	55.29	55.68	8708739.0
2011-10-10 11:00:00	QQQ	ETF	55.69	55.76	55.58	55.72	5221574.0
2011-10-10 12:00:00	QQQ	ETF	55.73	55.76	55.55	55.6	2957988.0
2011-10-10 13:00:00	QQQ	ETF	55.6	55.78	55.58	55.71	3372142.0
2011-10-10 14:00:00	QQQ	ETF	55.71	55.75	55.52	55.53	3756494.0
2011-10-10 15:00:00	QQQ	ETF	55.53	55.89	55.24	55.89	11507280.0
2011-10-10 16:00:00	QQQ	ETF	55.9	56.02	55.2801	55.96	2882743.0
2011-10-10 17:00:00	QQQ	ETF	55.96	55.96	55.9	55.93	82330.0
2011-10-10 18:00:00	QQQ	ETF	55.92	55.94	55.86	55.92	24814.0
2011-10-10 19:00:00	QQQ	ETF	55.9	55.95	55.9	55.94	25106.0
2011-10-10 04:00:00	IWM	ETF	65.95	66.83	65.95	66.77	1700.0
2011-10-10 05:00:00	IWM	ETF	66.8	66.8	66.8	66.8	100.0
2011-10-10 06:00:00	IWM	ETF	67.02	67.02	66.9	66.9	600.0
2011-10-10 07:00:00	IWM	ETF	66.9	67.11	66.87	66.89	93802.0
2011-10-10 08:00:00	IWM	ETF	66.91	67.04	66.7867	66.87	300706.0
2011-10-10 09:00:00	IWM	ETF	66.87	67.29	66.69	67.2799	7815181.0
2011-10-10 10:00:00	IWM	ETF	67.27	68.0	67.16	67.75	11336356.0
2011-10-10 11:00:00	IWM	ETF	67.76	67.96	67.58	67.93	5124891.0
2011-10-10 12:00:00	IWM	ETF	67.94	68.08	67.7	67.82	4395347.0
2011-10-10 13:00:00	IWM	ETF	67.82	68.04	67.77	67.962	3582839.0
2011-10-10 14:00:00	IWM	ETF	67.96	68.02	67.74	67.85	6238116.0
2011-10-10 15:00:00	IWM	ETF	67.85	68.38	66.85	68.35	16593501.0
2011-10-10 16:00:00	IWM	ETF	68.34	68.69	67.55	68.54	7076350.0
2011-10-10 17:00:00	IWM	ETF	68.48	68.6	68.43	68.48	44519.0
2011-10-10 18:00:00	IWM	ETF	68.54	68.56	68.42	68.46	7037.0
2011-10-10 19:00:00	IWM	ETF	68.39	68.46	68.35	68.35	15655.0
2011-10-10 06:00:00	DIA	ETF	112.5	112.55	112.5	112.55	200.0
2011-10-10 07:00:00	DIA	ETF	112.34	112.6	112.34	112.46	116916.0

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

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