PREVIEW / etf_1hour / 2012-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-12.parquet
  size:    192 KB
  rows:    5,914

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-12-12 04:00:00	SPY	ETF	143.88	144.09	143.88	144.03	72376.0
2012-12-12 05:00:00	SPY	ETF	144.07	144.09	143.95	143.97	22471.0
2012-12-12 06:00:00	SPY	ETF	143.97	144.0	143.92	143.96	38429.0
2012-12-12 07:00:00	SPY	ETF	143.98	144.23	143.93	144.11	257952.0
2012-12-12 08:00:00	SPY	ETF	144.11	144.14	143.9	144.07	1211902.0
2012-12-12 09:00:00	SPY	ETF	144.07	144.16	143.76	143.81	11689010.0
2012-12-12 10:00:00	SPY	ETF	143.82	143.855	143.58	143.6799	13750750.0
2012-12-12 11:00:00	SPY	ETF	143.68	143.83	143.59	143.6299	8713331.0
2012-12-12 12:00:00	SPY	ETF	143.62	144.5	143.52	144.3975	24957689.0
2012-12-12 13:00:00	SPY	ETF	144.395	144.55	144.18	144.33	16529534.0
2012-12-12 14:00:00	SPY	ETF	144.3399	144.41	143.99	144.045	16886484.0
2012-12-12 15:00:00	SPY	ETF	144.04	144.065	143.31	143.51	27676817.0
2012-12-12 16:00:00	SPY	ETF	143.5	144.34	142.0336	143.29	20553919.0
2012-12-12 17:00:00	SPY	ETF	143.29	143.4386	143.25	143.29	1632935.0
2012-12-12 18:00:00	SPY	ETF	143.29	143.51	143.19	143.5	98329.0
2012-12-12 19:00:00	SPY	ETF	143.49	143.58	143.44	143.47	43616.0
2012-12-12 04:00:00	QQQ	ETF	66.21	66.21	66.21	66.21	900.0
2012-12-12 06:00:00	QQQ	ETF	66.17	66.17	66.17	66.17	100.0
2012-12-12 07:00:00	QQQ	ETF	66.25	66.28	66.2	66.28	29216.0
2012-12-12 08:00:00	QQQ	ETF	66.28	66.29	66.22	66.28	1523316.0
2012-12-12 09:00:00	QQQ	ETF	66.27	66.33	66.035	66.07	4341718.0
2012-12-12 10:00:00	QQQ	ETF	66.065	66.08	65.88	65.93	4781253.0
2012-12-12 11:00:00	QQQ	ETF	65.925	66.02	65.83	65.849	1922787.0
2012-12-12 12:00:00	QQQ	ETF	65.84	66.27	65.79	66.2099	5906893.0
2012-12-12 13:00:00	QQQ	ETF	66.205	66.26	66.01	66.16	6787098.0
2012-12-12 14:00:00	QQQ	ETF	66.16	66.26	66.01	66.04	4818767.0
2012-12-12 15:00:00	QQQ	ETF	66.05	66.06	65.65	65.81	10340385.0
2012-12-12 16:00:00	QQQ	ETF	65.81	66.1513	65.68	65.68	1883031.0
2012-12-12 17:00:00	QQQ	ETF	65.7	65.75	65.7	65.75	3103.0
2012-12-12 18:00:00	QQQ	ETF	65.73	65.79	65.72	65.79	13020.0
2012-12-12 19:00:00	QQQ	ETF	65.77	65.78	65.75	65.77	9323.0
2012-12-12 04:00:00	IWM	ETF	83.65	83.81	83.65	83.78	2600.0
2012-12-12 07:00:00	IWM	ETF	83.86	83.86	83.7	83.77	50485.0
2012-12-12 08:00:00	IWM	ETF	83.76	83.77	83.61	83.67	334350.0
2012-12-12 09:00:00	IWM	ETF	83.67	83.72	83.42	83.47	6617989.0
2012-12-12 10:00:00	IWM	ETF	83.46	83.659	83.38	83.55	3566167.0
2012-12-12 11:00:00	IWM	ETF	83.56	83.5899	83.39	83.4	1892952.0
2012-12-12 12:00:00	IWM	ETF	83.4	83.8	83.32	83.68	5250882.0
2012-12-12 13:00:00	IWM	ETF	83.686	83.75	83.52	83.53	3674337.0
2012-12-12 14:00:00	IWM	ETF	83.53	83.57	83.34	83.36	3506331.0
2012-12-12 15:00:00	IWM	ETF	83.36	83.38	82.77	82.95	9097449.0
2012-12-12 16:00:00	IWM	ETF	82.94	83.05	82.8	82.81	1756342.0
2012-12-12 17:00:00	IWM	ETF	82.83	82.83	82.83	82.83	1100.0
2012-12-12 18:00:00	IWM	ETF	82.87	82.91	82.85	82.91	1819.0
2012-12-12 19:00:00	IWM	ETF	82.91	82.92	82.91	82.92	3300.0
2012-12-12 07:00:00	DIA	ETF	132.99	133.07	132.99	133.07	243.0
2012-12-12 08:00:00	DIA	ETF	133.03	133.03	132.94	133.01	108750.0
2012-12-12 09:00:00	DIA	ETF	133.02	133.03	132.83	132.88	844739.0
2012-12-12 10:00:00	DIA	ETF	132.89	132.89	132.605	132.68	1011431.0
2012-12-12 11:00:00	DIA	ETF	132.69	132.79	132.55	132.57	550262.0

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

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