PREVIEW / etf_1hour / 2012-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-02.parquet
  size:    182 KB
  rows:    5,659

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-02 04:00:00	SPY	ETF	144.7	144.9	144.69	144.9	129500.0
2012-10-02 05:00:00	SPY	ETF	144.9	145.03	144.9	144.9	24100.0
2012-10-02 06:00:00	SPY	ETF	144.95	145.16	144.95	145.08	48100.0
2012-10-02 07:00:00	SPY	ETF	145.02	145.08	144.91	145.03	171915.0
2012-10-02 08:00:00	SPY	ETF	145.0	145.1	144.84	144.92	533055.0
2012-10-02 09:00:00	SPY	ETF	144.89	145.15	144.69	144.73	13330846.0
2012-10-02 10:00:00	SPY	ETF	144.73	144.935	144.32	144.41	17298121.0
2012-10-02 11:00:00	SPY	ETF	144.4	144.59	143.89	144.06	22487731.0
2012-10-02 12:00:00	SPY	ETF	144.06	144.37	143.98	144.2	10038655.0
2012-10-02 13:00:00	SPY	ETF	144.2	144.44	143.96	144.12	9306948.0
2012-10-02 14:00:00	SPY	ETF	144.12	144.22	143.83	143.8998	10512231.0
2012-10-02 15:00:00	SPY	ETF	143.9	144.55	143.83	144.48	20378578.0
2012-10-02 16:00:00	SPY	ETF	144.48	144.74	144.1884	144.58	8842886.0
2012-10-02 17:00:00	SPY	ETF	144.58	144.66	144.58	144.66	29591.0
2012-10-02 18:00:00	SPY	ETF	144.67	144.67	144.55	144.55	54671.0
2012-10-02 19:00:00	SPY	ETF	144.55	144.56	144.51	144.56	21245.0
2012-10-02 06:00:00	QQQ	ETF	68.8	68.87	68.8	68.87	6400.0
2012-10-02 07:00:00	QQQ	ETF	68.83	68.83	68.75	68.83	24481.0
2012-10-02 08:00:00	QQQ	ETF	68.81	68.88	68.76	68.79	62017.0
2012-10-02 09:00:00	QQQ	ETF	68.78	68.98	68.6399	68.78	4885108.0
2012-10-02 10:00:00	QQQ	ETF	68.78	68.96	68.51	68.69	5784852.0
2012-10-02 11:00:00	QQQ	ETF	68.68	68.7399	68.36	68.41	4820841.0
2012-10-02 12:00:00	QQQ	ETF	68.4	68.56	68.36	68.4	2294166.0
2012-10-02 13:00:00	QQQ	ETF	68.4083	68.51	68.29	68.35	3805108.0
2012-10-02 14:00:00	QQQ	ETF	68.34	68.4	68.13	68.17	2815555.0
2012-10-02 15:00:00	QQQ	ETF	68.18	68.66	68.14	68.66	4684421.0
2012-10-02 16:00:00	QQQ	ETF	68.67	68.77	68.3762	68.67	2703962.0
2012-10-02 17:00:00	QQQ	ETF	68.68	68.72	68.67	68.72	9370.0
2012-10-02 18:00:00	QQQ	ETF	68.72	68.72	68.67	68.67	8030.0
2012-10-02 19:00:00	QQQ	ETF	68.66	68.67	68.64	68.65	16000.0
2012-10-02 06:00:00	IWM	ETF	84.29	84.29	84.29	84.29	160.0
2012-10-02 07:00:00	IWM	ETF	84.26	84.28	84.17	84.18	56164.0
2012-10-02 08:00:00	IWM	ETF	84.2	84.26	84.1	84.13	62990.0
2012-10-02 09:00:00	IWM	ETF	84.11	84.24	83.79	83.81	4205552.0
2012-10-02 10:00:00	IWM	ETF	83.81	84.01	83.47	83.66	4067191.0
2012-10-02 11:00:00	IWM	ETF	83.65	83.84	83.37	83.64	4051926.0
2012-10-02 12:00:00	IWM	ETF	83.64	83.8	83.53	83.54	1800634.0
2012-10-02 13:00:00	IWM	ETF	83.55	83.79	83.49	83.6	1276866.0
2012-10-02 14:00:00	IWM	ETF	83.59	83.67	83.4	83.53	3201745.0
2012-10-02 15:00:00	IWM	ETF	83.53	83.82	83.49	83.8	4632517.0
2012-10-02 16:00:00	IWM	ETF	83.8	83.96	83.74	83.74	937946.0
2012-10-02 17:00:00	IWM	ETF	83.81	83.82	83.81	83.82	336.0
2012-10-02 18:00:00	IWM	ETF	83.82	83.82	83.82	83.82	460.0
2012-10-02 19:00:00	IWM	ETF	83.79	83.79	83.67	83.71	5600.0
2012-10-02 06:00:00	DIA	ETF	135.51	135.51	135.51	135.51	100.0
2012-10-02 07:00:00	DIA	ETF	135.25	135.25	135.25	135.25	500.0
2012-10-02 08:00:00	DIA	ETF	135.25	135.4	135.12	135.15	4096.0
2012-10-02 09:00:00	DIA	ETF	135.12	135.376	134.87	134.89	455974.0
2012-10-02 10:00:00	DIA	ETF	134.8783	134.9	134.39	134.45	683547.0
2012-10-02 11:00:00	DIA	ETF	134.44	134.6	133.94	134.1	902924.0

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

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