PREVIEW / etf_1hour / 2012-12-13

all etf 1-hour files

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

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-13 04:00:00	SPY	ETF	143.37	143.37	143.27	143.27	3100.0
2012-12-13 05:00:00	SPY	ETF	143.2	143.28	143.07	143.28	47500.0
2012-12-13 06:00:00	SPY	ETF	143.25	143.31	143.16	143.31	42800.0
2012-12-13 07:00:00	SPY	ETF	143.29	143.41	143.25	143.35	161295.0
2012-12-13 08:00:00	SPY	ETF	143.35	143.81	143.24	143.35	837691.0
2012-12-13 09:00:00	SPY	ETF	143.36	143.63	143.27	143.53	10121078.0
2012-12-13 10:00:00	SPY	ETF	143.53	143.83	143.45	143.46	15030812.0
2012-12-13 11:00:00	SPY	ETF	143.47	143.51	142.99	143.19	19258718.0
2012-12-13 12:00:00	SPY	ETF	143.197	143.22	142.57	142.699	15078667.0
2012-12-13 13:00:00	SPY	ETF	142.69	142.78	142.44	142.62	10682386.0
2012-12-13 14:00:00	SPY	ETF	142.62	142.65	142.275	142.53	14580688.0
2012-12-13 15:00:00	SPY	ETF	142.52	143.0	142.325	142.69	28144614.0
2012-12-13 16:00:00	SPY	ETF	142.69	143.6866	142.41	142.43	15419091.0
2012-12-13 17:00:00	SPY	ETF	142.44	142.45	142.28	142.33	3309222.0
2012-12-13 18:00:00	SPY	ETF	142.33	142.87	142.33	142.85	372420.0
2012-12-13 19:00:00	SPY	ETF	142.8	142.85	142.4	142.45	80015.0
2012-12-13 05:00:00	QQQ	ETF	65.63	65.63	65.63	65.63	100.0
2012-12-13 06:00:00	QQQ	ETF	65.68	65.68	65.68	65.68	4000.0
2012-12-13 07:00:00	QQQ	ETF	65.73	65.73	65.66	65.68	900.0
2012-12-13 08:00:00	QQQ	ETF	65.71	65.9	65.62	65.65	249781.0
2012-12-13 09:00:00	QQQ	ETF	65.65	65.9	65.63	65.74	3769846.0
2012-12-13 10:00:00	QQQ	ETF	65.74	66.16	65.68	65.94	5779493.0
2012-12-13 11:00:00	QQQ	ETF	65.94	65.97	65.49	65.6	5435108.0
2012-12-13 12:00:00	QQQ	ETF	65.6	65.62	65.15	65.2	8032129.0
2012-12-13 13:00:00	QQQ	ETF	65.1999	65.32	65.12	65.25	4349216.0
2012-12-13 14:00:00	QQQ	ETF	65.2501	65.27	65.03	65.19	3001537.0
2012-12-13 15:00:00	QQQ	ETF	65.18	65.43	65.07	65.32	6120224.0
2012-12-13 16:00:00	QQQ	ETF	65.32	65.8108	65.15	65.8108	5300176.0
2012-12-13 17:00:00	QQQ	ETF	65.24	65.24	65.21	65.21	8000.0
2012-12-13 18:00:00	QQQ	ETF	65.21	65.36	65.21	65.36	14200.0
2012-12-13 19:00:00	QQQ	ETF	65.38	65.38	65.19	65.19	24600.0
2012-12-13 07:00:00	IWM	ETF	82.85	82.88	82.81	82.88	23199.0
2012-12-13 08:00:00	IWM	ETF	82.86	83.09	82.85	82.91	183870.0
2012-12-13 09:00:00	IWM	ETF	82.92	83.11	82.81	82.96	2748718.0
2012-12-13 10:00:00	IWM	ETF	82.96	83.21	82.93	83.02	3666142.0
2012-12-13 11:00:00	IWM	ETF	83.03	83.0518	82.75	82.9	3187428.0
2012-12-13 12:00:00	IWM	ETF	82.9	82.9099	82.43	82.53	4009120.0
2012-12-13 13:00:00	IWM	ETF	82.53	82.61	82.39	82.52	2731142.0
2012-12-13 14:00:00	IWM	ETF	82.515	82.53	82.11	82.235	4391971.0
2012-12-13 15:00:00	IWM	ETF	82.23	82.71	82.17	82.44	8518217.0
2012-12-13 16:00:00	IWM	ETF	82.44	82.5673	82.29	82.31	1066661.0
2012-12-13 17:00:00	IWM	ETF	82.33	82.35	82.19	82.21	85945.0
2012-12-13 18:00:00	IWM	ETF	82.3	82.46	82.3	82.46	8177.0
2012-12-13 19:00:00	IWM	ETF	82.46	82.48	82.34	82.34	15108.0
2012-12-13 05:00:00	DIA	ETF	132.2	132.2	132.2	132.2	100.0
2012-12-13 07:00:00	DIA	ETF	132.4	132.4	132.4	132.4	300.0
2012-12-13 08:00:00	DIA	ETF	132.47	132.73	132.42	132.48	5043.0
2012-12-13 09:00:00	DIA	ETF	132.49	132.66	132.34	132.561	436621.0
2012-12-13 10:00:00	DIA	ETF	132.57	132.72	132.4	132.43	356469.0
2012-12-13 11:00:00	DIA	ETF	132.44	132.4799	132.13	132.28	487694.0

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

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