PREVIEW / etf_1hour / 2012-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-28.parquet
  size:    185 KB
  rows:    5,732

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-09-28 04:00:00	SPY	ETF	144.68	144.68	144.61	144.68	8100.0
2012-09-28 05:00:00	SPY	ETF	144.7	144.76	144.52	144.52	8500.0
2012-09-28 06:00:00	SPY	ETF	144.52	144.52	144.1	144.18	206334.0
2012-09-28 07:00:00	SPY	ETF	144.12	144.22	144.06	144.22	218248.0
2012-09-28 08:00:00	SPY	ETF	144.18	144.83	143.75	144.01	2587060.0
2012-09-28 09:00:00	SPY	ETF	144.01	144.7	143.53	143.66	20782942.0
2012-09-28 10:00:00	SPY	ETF	143.65	143.92	143.46	143.75	19860768.0
2012-09-28 11:00:00	SPY	ETF	143.75	143.88	143.5	143.83	15369677.0
2012-09-28 12:00:00	SPY	ETF	143.84	144.31	143.78	144.1099	15705778.0
2012-09-28 13:00:00	SPY	ETF	144.1	144.56	143.89	144.37	13537004.0
2012-09-28 14:00:00	SPY	ETF	144.36	144.47	143.97	144.09	11582481.0
2012-09-28 15:00:00	SPY	ETF	144.09	144.3	143.7	143.9	30373212.0
2012-09-28 16:00:00	SPY	ETF	143.93	144.648	143.7678	144.05	15646420.0
2012-09-28 17:00:00	SPY	ETF	144.05	144.07	143.97	144.07	251925.0
2012-09-28 18:00:00	SPY	ETF	144.07	144.09	144.02	144.09	12335.0
2012-09-28 19:00:00	SPY	ETF	144.06	144.09	144.02	144.08	19589.0
2012-09-28 06:00:00	QQQ	ETF	69.09	69.09	68.95	68.95	5820.0
2012-09-28 07:00:00	QQQ	ETF	68.92	68.99	68.92	68.95	14200.0
2012-09-28 08:00:00	QQQ	ETF	68.98	69.02	68.81	68.92	479195.0
2012-09-28 09:00:00	QQQ	ETF	68.92	69.16	68.68	68.75	4711523.0
2012-09-28 10:00:00	QQQ	ETF	68.75	68.94	68.52	68.72	6273884.0
2012-09-28 11:00:00	QQQ	ETF	68.73	68.78	68.51	68.695	3470337.0
2012-09-28 12:00:00	QQQ	ETF	68.71	68.96	68.67	68.8405	2656792.0
2012-09-28 13:00:00	QQQ	ETF	68.85	69.05	68.71	68.93	2666329.0
2012-09-28 14:00:00	QQQ	ETF	68.93	68.99	68.64	68.77	1894379.0
2012-09-28 15:00:00	QQQ	ETF	68.78	68.8301	68.54	68.58	5340886.0
2012-09-28 16:00:00	QQQ	ETF	68.58	69.1623	68.5	68.5	2023881.0
2012-09-28 17:00:00	QQQ	ETF	68.51	68.55	68.5	68.55	14895.0
2012-09-28 18:00:00	QQQ	ETF	68.55	68.55	68.55	68.55	2520.0
2012-09-28 19:00:00	QQQ	ETF	68.52	68.55	68.5	68.5	1050.0
2012-09-28 07:00:00	IWM	ETF	83.8	83.81	83.74	83.78	15350.0
2012-09-28 08:00:00	IWM	ETF	83.76	83.76	83.44	83.64	285869.0
2012-09-28 09:00:00	IWM	ETF	83.65	83.81	83.2901	83.43	5896085.0
2012-09-28 10:00:00	IWM	ETF	83.42	83.6307	83.26	83.58	4986478.0
2012-09-28 11:00:00	IWM	ETF	83.58	83.68	83.43	83.6583	2468815.0
2012-09-28 12:00:00	IWM	ETF	83.66	83.93	83.58	83.6825	4785080.0
2012-09-28 13:00:00	IWM	ETF	83.68	84.0	83.51	83.92	3358240.0
2012-09-28 14:00:00	IWM	ETF	83.925	83.97	83.725	83.83	2474424.0
2012-09-28 15:00:00	IWM	ETF	83.83	83.915	83.39	83.4	8874592.0
2012-09-28 16:00:00	IWM	ETF	83.41	83.645	83.41	83.51	3087475.0
2012-09-28 17:00:00	IWM	ETF	83.51	83.51	83.48	83.48	2300.0
2012-09-28 18:00:00	IWM	ETF	83.48	83.51	83.48	83.51	675.0
2012-09-28 19:00:00	IWM	ETF	83.5	83.51	83.48	83.51	1624.0
2012-09-28 07:00:00	DIA	ETF	134.11	134.11	134.11	134.11	500.0
2012-09-28 08:00:00	DIA	ETF	134.09	134.09	133.73	133.78	16635.0
2012-09-28 09:00:00	DIA	ETF	133.96	134.0099	133.39	133.46	792687.0
2012-09-28 10:00:00	DIA	ETF	133.44	133.74	133.36	133.66	606205.0
2012-09-28 11:00:00	DIA	ETF	133.656	133.88	133.52	133.87	578286.0
2012-09-28 12:00:00	DIA	ETF	133.87	134.27	133.82	134.05	431275.0
2012-09-28 13:00:00	DIA	ETF	134.06	134.48	133.89	134.27	246756.0

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

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