PREVIEW / etf_1hour / 2011-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-16.parquet
  size:    175 KB
  rows:    5,393

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-09-16 04:00:00	SPY	ETF	120.6	120.6	120.12	120.15	21809.0
2011-09-16 05:00:00	SPY	ETF	120.36	120.7	120.36	120.68	14286.0
2011-09-16 06:00:00	SPY	ETF	120.61	120.98	120.3	120.65	112730.0
2011-09-16 07:00:00	SPY	ETF	120.65	120.78	120.23	120.52	1431934.0
2011-09-16 08:00:00	SPY	ETF	120.52	120.95	120.22	120.87	3918681.0
2011-09-16 09:00:00	SPY	ETF	120.87	121.97	120.76	121.47	44019502.0
2011-09-16 10:00:00	SPY	ETF	121.48	121.94	120.32	120.65	56484336.0
2011-09-16 11:00:00	SPY	ETF	120.64	121.5714	120.38	121.16	36825479.0
2011-09-16 12:00:00	SPY	ETF	121.17	121.63	121.04	121.4112	21742286.0
2011-09-16 13:00:00	SPY	ETF	121.4111	121.44	120.8	121.05	18405837.0
2011-09-16 14:00:00	SPY	ETF	121.06	121.43	121.0	121.42	18927949.0
2011-09-16 15:00:00	SPY	ETF	121.42	121.58	120.95	121.52	53710488.0
2011-09-16 16:00:00	SPY	ETF	121.52	121.825	120.823	121.7	24891412.0
2011-09-16 17:00:00	SPY	ETF	121.7	121.78	121.63	121.67	437417.0
2011-09-16 18:00:00	SPY	ETF	121.72	121.76	121.5	121.5	292261.0
2011-09-16 19:00:00	SPY	ETF	121.5	121.5	121.2	121.25	361271.0
2011-09-16 04:00:00	QQQ	ETF	56.05	56.05	55.9	55.9	1900.0
2011-09-16 05:00:00	QQQ	ETF	56.02	56.02	56.0	56.0	242.0
2011-09-16 06:00:00	QQQ	ETF	55.98	56.16	55.95	56.16	14615.0
2011-09-16 07:00:00	QQQ	ETF	56.08	56.13	55.93	55.97	78227.0
2011-09-16 08:00:00	QQQ	ETF	56.02	56.18	55.92	56.18	440496.0
2011-09-16 09:00:00	QQQ	ETF	56.17	56.52	56.11	56.36	23424326.0
2011-09-16 10:00:00	QQQ	ETF	56.36	56.65	56.09	56.2	13802916.0
2011-09-16 11:00:00	QQQ	ETF	56.21	56.52	56.17	56.4695	7065696.0
2011-09-16 12:00:00	QQQ	ETF	56.47	56.6201	56.39	56.53	5984277.0
2011-09-16 13:00:00	QQQ	ETF	56.53	56.54	56.29	56.37	4643310.0
2011-09-16 14:00:00	QQQ	ETF	56.37	56.53	56.3629	56.53	4314229.0
2011-09-16 15:00:00	QQQ	ETF	56.535	56.58	56.37	56.57	9210481.0
2011-09-16 16:00:00	QQQ	ETF	56.56	56.77	56.0856	56.63	3819953.0
2011-09-16 17:00:00	QQQ	ETF	56.63	56.66	56.57	56.61	62195.0
2011-09-16 18:00:00	QQQ	ETF	56.61	56.66	56.61	56.66	14315.0
2011-09-16 19:00:00	QQQ	ETF	56.66	56.66	56.6	56.6	17797.0
2011-09-16 04:00:00	IWM	ETF	71.08	71.08	71.0	71.0	465.0
2011-09-16 05:00:00	IWM	ETF	71.25	71.28	71.25	71.28	1131.0
2011-09-16 06:00:00	IWM	ETF	71.25	71.52	71.25	71.46	600.0
2011-09-16 07:00:00	IWM	ETF	71.41	71.52	71.2	71.22	5580.0
2011-09-16 08:00:00	IWM	ETF	71.29	71.62	71.1	71.52	398755.0
2011-09-16 09:00:00	IWM	ETF	71.53	72.03	71.51	71.63	10900274.0
2011-09-16 10:00:00	IWM	ETF	71.62	71.99	70.93	71.16	14638827.0
2011-09-16 11:00:00	IWM	ETF	71.17	71.5	70.97	71.4	6629482.0
2011-09-16 12:00:00	IWM	ETF	71.41	71.62	71.29	71.44	3845467.0
2011-09-16 13:00:00	IWM	ETF	71.44	71.442	70.88	71.02	4043004.0
2011-09-16 14:00:00	IWM	ETF	71.03	71.42	71.0	71.4	5022077.0
2011-09-16 15:00:00	IWM	ETF	71.4099	71.59	71.05	71.5	12035447.0
2011-09-16 16:00:00	IWM	ETF	71.49	71.86	71.2957	71.77	7062434.0
2011-09-16 17:00:00	IWM	ETF	71.8	71.83	71.52	71.7	618635.0
2011-09-16 18:00:00	IWM	ETF	71.73	71.73	71.65	71.65	2200.0
2011-09-16 19:00:00	IWM	ETF	71.58	71.68	71.49	71.49	18700.0
2011-09-16 07:00:00	DIA	ETF	113.91	113.91	113.71	113.71	200.0
2011-09-16 08:00:00	DIA	ETF	113.95	114.24	113.63	114.24	7390.0

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

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