PREVIEW / etf_1hour / 2012-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-19.parquet
  size:    181 KB
  rows:    5,639

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-04-19 04:00:00	SPY	ETF	139.17	139.38	138.78	138.95	28430.0
2012-04-19 05:00:00	SPY	ETF	138.85	139.23	138.85	139.23	18700.0
2012-04-19 06:00:00	SPY	ETF	139.19	139.19	138.93	139.02	138200.0
2012-04-19 07:00:00	SPY	ETF	139.0	139.19	138.37	138.64	2238297.0
2012-04-19 08:00:00	SPY	ETF	139.06	139.29	138.22	138.38	3737175.0
2012-04-19 09:00:00	SPY	ETF	138.38	138.918	138.26	138.79	17848382.0
2012-04-19 10:00:00	SPY	ETF	138.78	139.15	137.97	138.91	40920493.0
2012-04-19 11:00:00	SPY	ETF	138.91	139.1	138.39	138.67	19683897.0
2012-04-19 12:00:00	SPY	ETF	138.66	138.69	138.02	138.13	18458420.0
2012-04-19 13:00:00	SPY	ETF	138.14	138.5823	137.73	137.76	17526356.0
2012-04-19 14:00:00	SPY	ETF	137.75	137.9	137.07	137.425	27224505.0
2012-04-19 15:00:00	SPY	ETF	137.425	138.5823	137.27	137.745	41841821.0
2012-04-19 16:00:00	SPY	ETF	137.76	138.39	137.55	137.94	6013343.0
2012-04-19 17:00:00	SPY	ETF	137.92	137.96	137.78	137.8	486297.0
2012-04-19 18:00:00	SPY	ETF	137.81	137.86	137.8	137.85	92866.0
2012-04-19 19:00:00	SPY	ETF	137.85	138.03	137.85	138.0	69865.0
2012-04-19 04:00:00	QQQ	ETF	66.8	66.8	66.6	66.6	1351.0
2012-04-19 05:00:00	QQQ	ETF	66.58	66.67	66.58	66.67	400.0
2012-04-19 06:00:00	QQQ	ETF	66.75	66.75	66.63	66.68	14429.0
2012-04-19 07:00:00	QQQ	ETF	66.66	66.76	66.33	66.46	254567.0
2012-04-19 08:00:00	QQQ	ETF	66.4	66.97	66.2	66.21	2018285.0
2012-04-19 09:00:00	QQQ	ETF	66.2	66.89	66.2	66.79	9671996.0
2012-04-19 10:00:00	QQQ	ETF	66.78	67.17	66.41	66.9614	17248754.0
2012-04-19 11:00:00	QQQ	ETF	66.97	67.03	66.58	66.7	5996576.0
2012-04-19 12:00:00	QQQ	ETF	66.7	66.71	66.25	66.25	8066244.0
2012-04-19 13:00:00	QQQ	ETF	66.255	66.38	66.02	66.05	7266041.0
2012-04-19 14:00:00	QQQ	ETF	66.045	66.12	65.62	65.85	9682864.0
2012-04-19 15:00:00	QQQ	ETF	65.85	66.0	65.67	65.895	13032748.0
2012-04-19 16:00:00	QQQ	ETF	65.89	66.6093	65.85	66.05	3519422.0
2012-04-19 17:00:00	QQQ	ETF	66.04	66.1	65.93	66.01	49720.0
2012-04-19 18:00:00	QQQ	ETF	65.99	66.01	65.96	66.0	53368.0
2012-04-19 19:00:00	QQQ	ETF	66.0	66.06	66.0	66.06	5206.0
2012-04-19 04:00:00	IWM	ETF	80.29	80.79	80.29	80.79	600.0
2012-04-19 05:00:00	IWM	ETF	80.49	80.71	80.49	80.71	6100.0
2012-04-19 06:00:00	IWM	ETF	80.54	80.61	80.54	80.55	78000.0
2012-04-19 07:00:00	IWM	ETF	80.45	80.61	80.21	80.45	641400.0
2012-04-19 08:00:00	IWM	ETF	80.44	80.76	80.01	80.07	809501.0
2012-04-19 09:00:00	IWM	ETF	80.07	80.8	79.94	80.75	5970622.0
2012-04-19 10:00:00	IWM	ETF	80.75	80.99	79.58	80.74	17454412.0
2012-04-19 11:00:00	IWM	ETF	80.73	80.89	80.24	80.61	6352967.0
2012-04-19 12:00:00	IWM	ETF	80.6	80.63	79.96	80.07	6098766.0
2012-04-19 13:00:00	IWM	ETF	80.07	80.16	79.66	79.69	5685292.0
2012-04-19 14:00:00	IWM	ETF	79.68	79.835	79.25	79.52	9687490.0
2012-04-19 15:00:00	IWM	ETF	79.51	79.95	79.46	79.74	10343711.0
2012-04-19 16:00:00	IWM	ETF	79.75	80.1943	79.5635	79.82	2728169.0
2012-04-19 17:00:00	IWM	ETF	79.83	79.84	79.68	79.69	34332.0
2012-04-19 18:00:00	IWM	ETF	79.81	79.82	79.76	79.76	1300.0
2012-04-19 19:00:00	IWM	ETF	79.76	79.76	79.76	79.76	1000.0
2012-04-19 06:00:00	DIA	ETF	130.56	130.56	130.56	130.56	300.0
2012-04-19 07:00:00	DIA	ETF	130.68	130.68	130.21	130.22	4700.0

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

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