PREVIEW / etf_1hour / 2012-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-09.parquet
  size:    187 KB
  rows:    5,767

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-10-09 04:00:00	SPY	ETF	145.35	145.42	145.33	145.38	8775.0
2012-10-09 05:00:00	SPY	ETF	145.35	145.48	145.26	145.42	20800.0
2012-10-09 06:00:00	SPY	ETF	145.48	145.49	145.4	145.43	20000.0
2012-10-09 07:00:00	SPY	ETF	145.48	145.68	145.45	145.65	733184.0
2012-10-09 08:00:00	SPY	ETF	145.64	145.92	145.52	145.76	1418126.0
2012-10-09 09:00:00	SPY	ETF	145.76	145.79	145.25	145.31	15246750.0
2012-10-09 10:00:00	SPY	ETF	145.31	145.58	144.53	144.66	28087807.0
2012-10-09 11:00:00	SPY	ETF	144.67	144.67	144.25	144.43	25575624.0
2012-10-09 12:00:00	SPY	ETF	144.43	144.71	144.33	144.37	14973142.0
2012-10-09 13:00:00	SPY	ETF	144.37	144.73	144.32	144.53	10943117.0
2012-10-09 14:00:00	SPY	ETF	144.53	145.6217	144.4	144.71	12737889.0
2012-10-09 15:00:00	SPY	ETF	144.701	144.78	144.15	144.21	27017155.0
2012-10-09 16:00:00	SPY	ETF	144.2	145.6217	144.1	144.3	10687393.0
2012-10-09 17:00:00	SPY	ETF	144.27	144.3	144.15	144.15	318628.0
2012-10-09 18:00:00	SPY	ETF	144.17	144.25	144.0	144.01	251744.0
2012-10-09 19:00:00	SPY	ETF	144.04	144.09	143.81	143.88	134023.0
2012-10-09 04:00:00	QQQ	ETF	68.08	68.08	68.08	68.08	100.0
2012-10-09 05:00:00	QQQ	ETF	68.05	68.05	68.02	68.02	200.0
2012-10-09 06:00:00	QQQ	ETF	68.11	68.13	68.08	68.13	4100.0
2012-10-09 07:00:00	QQQ	ETF	68.13	68.23	68.13	68.2	57950.0
2012-10-09 08:00:00	QQQ	ETF	68.22	68.31	68.15	68.25	871785.0
2012-10-09 09:00:00	QQQ	ETF	68.25	68.27	67.7	67.73	7251368.0
2012-10-09 10:00:00	QQQ	ETF	67.73	67.9	67.16	67.275	9629244.0
2012-10-09 11:00:00	QQQ	ETF	67.275	67.32	67.1	67.2499	7224537.0
2012-10-09 12:00:00	QQQ	ETF	67.25	67.46	67.195	67.26	6002591.0
2012-10-09 13:00:00	QQQ	ETF	67.27	67.5	67.26	67.39	4090320.0
2012-10-09 14:00:00	QQQ	ETF	67.39	67.525	67.33	67.4784	3544595.0
2012-10-09 15:00:00	QQQ	ETF	67.48	67.5099	67.17	67.26	8398056.0
2012-10-09 16:00:00	QQQ	ETF	67.26	68.3395	67.2	67.25	5453262.0
2012-10-09 17:00:00	QQQ	ETF	67.26	67.27	67.14	67.14	45076.0
2012-10-09 18:00:00	QQQ	ETF	67.2	67.26	67.18	67.18	39972.0
2012-10-09 19:00:00	QQQ	ETF	67.18	67.2	67.03	67.06	73845.0
2012-10-09 04:00:00	IWM	ETF	83.58	83.58	83.58	83.58	221.0
2012-10-09 06:00:00	IWM	ETF	83.62	83.63	83.62	83.63	10000.0
2012-10-09 07:00:00	IWM	ETF	83.7	83.76	83.7	83.74	22510.0
2012-10-09 08:00:00	IWM	ETF	83.73	83.9	83.57	83.78	103795.0
2012-10-09 09:00:00	IWM	ETF	83.8	83.8	83.34	83.39	4096471.0
2012-10-09 10:00:00	IWM	ETF	83.39	83.67	82.62	82.64	13969145.0
2012-10-09 11:00:00	IWM	ETF	82.63	82.7475	82.44	82.66	6727629.0
2012-10-09 12:00:00	IWM	ETF	82.66	82.88	82.63	82.66	2804992.0
2012-10-09 13:00:00	IWM	ETF	82.66	82.84	82.62	82.718	4390762.0
2012-10-09 14:00:00	IWM	ETF	82.71	82.825	82.61	82.8	2701482.0
2012-10-09 15:00:00	IWM	ETF	82.8	82.87	82.48	82.56	6369259.0
2012-10-09 16:00:00	IWM	ETF	82.56	82.69	82.55	82.63	1023485.0
2012-10-09 17:00:00	IWM	ETF	82.67	82.67	82.55	82.59	22647.0
2012-10-09 18:00:00	IWM	ETF	82.55	82.55	82.48	82.54	8000.0
2012-10-09 19:00:00	IWM	ETF	82.53	82.56	82.44	82.44	13323.0
2012-10-09 08:00:00	DIA	ETF	135.57	135.75	135.57	135.75	2700.0
2012-10-09 09:00:00	DIA	ETF	135.61	135.64	135.35	135.46	447374.0
2012-10-09 10:00:00	DIA	ETF	135.47	135.74	134.86	134.99	986936.0

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

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