PREVIEW / etf_1hour / 2013-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-12.parquet
  size:    206 KB
  rows:    6,458

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
2013-11-12 04:00:00	SPY	ETF	177.12	177.12	176.81	176.91	47289.0
2013-11-12 05:00:00	SPY	ETF	176.89	176.97	176.89	176.94	12500.0
2013-11-12 06:00:00	SPY	ETF	176.94	177.02	176.85	176.93	125400.0
2013-11-12 07:00:00	SPY	ETF	176.94	177.09	176.92	176.94	94975.0
2013-11-12 08:00:00	SPY	ETF	176.99	177.29	176.75	176.83	748722.0
2013-11-12 09:00:00	SPY	ETF	176.83	177.22	176.74	177.14	8174465.0
2013-11-12 10:00:00	SPY	ETF	177.14	177.36	176.86	177.0	12659310.0
2013-11-12 11:00:00	SPY	ETF	177.01	177.21	176.68	176.83	11156699.0
2013-11-12 12:00:00	SPY	ETF	176.83	176.9	176.52	176.73	9941813.0
2013-11-12 13:00:00	SPY	ETF	176.72	176.85	176.37	176.52	7877332.0
2013-11-12 14:00:00	SPY	ETF	176.52	176.99	176.47	176.95	8297206.0
2013-11-12 15:00:00	SPY	ETF	176.95	177.09	176.74	176.98	16543589.0
2013-11-12 16:00:00	SPY	ETF	176.98	177.07	176.6164	177.05	6947463.0
2013-11-12 17:00:00	SPY	ETF	177.06	177.06	176.97	177.02	63830.0
2013-11-12 18:00:00	SPY	ETF	177.0	177.04	176.96	177.0	58610.0
2013-11-12 19:00:00	SPY	ETF	177.02	177.11	176.99	177.1	124012.0
2013-11-12 04:00:00	QQQ	ETF	82.19	82.19	82.13	82.13	20000.0
2013-11-12 05:00:00	QQQ	ETF	82.15	82.18	82.15	82.17	10900.0
2013-11-12 06:00:00	QQQ	ETF	82.18	82.24	82.18	82.22	13500.0
2013-11-12 07:00:00	QQQ	ETF	82.19	82.27	82.18	82.22	11800.0
2013-11-12 08:00:00	QQQ	ETF	82.21	82.24	82.1	82.13	87509.0
2013-11-12 09:00:00	QQQ	ETF	82.12	82.52	82.1199	82.45	2704308.0
2013-11-12 10:00:00	QQQ	ETF	82.46	82.66	82.27	82.4899	3576235.0
2013-11-12 11:00:00	QQQ	ETF	82.49	82.56	82.25	82.3605	2932187.0
2013-11-12 12:00:00	QQQ	ETF	82.37	82.42	82.19	82.365	1691266.0
2013-11-12 13:00:00	QQQ	ETF	82.365	82.45	82.19	82.31	1308454.0
2013-11-12 14:00:00	QQQ	ETF	82.3	82.53	82.27	82.52	2018405.0
2013-11-12 15:00:00	QQQ	ETF	82.52	82.5899	82.45	82.53	3758587.0
2013-11-12 16:00:00	QQQ	ETF	82.54	82.61	82.3229	82.59	1661693.0
2013-11-12 17:00:00	QQQ	ETF	82.61	82.63	82.61	82.63	3000.0
2013-11-12 18:00:00	QQQ	ETF	82.6	82.6	82.53	82.55	6091.0
2013-11-12 19:00:00	QQQ	ETF	82.55	82.58	82.55	82.58	3600.0
2013-11-12 07:00:00	IWM	ETF	109.08	109.08	109.05	109.05	600.0
2013-11-12 08:00:00	IWM	ETF	109.07	109.08	108.94	108.96	30430.0
2013-11-12 09:00:00	IWM	ETF	108.94	109.35	108.92	109.22	4041378.0
2013-11-12 10:00:00	IWM	ETF	109.215	109.32	108.93	109.0998	3006781.0
2013-11-12 11:00:00	IWM	ETF	109.11	109.385	108.99	109.09	2611383.0
2013-11-12 12:00:00	IWM	ETF	109.08	109.11	108.67	108.9	2782256.0
2013-11-12 13:00:00	IWM	ETF	108.895	109.095	108.75	108.91	2247500.0
2013-11-12 14:00:00	IWM	ETF	108.91	109.3	108.87	109.27	2478380.0
2013-11-12 15:00:00	IWM	ETF	109.27	109.5	109.26	109.5	4399130.0
2013-11-12 16:00:00	IWM	ETF	109.51	109.51	108.9244	109.47	714034.0
2013-11-12 17:00:00	IWM	ETF	109.42	109.42	109.42	109.42	1500.0
2013-11-12 18:00:00	IWM	ETF	109.39	109.39	109.39	109.39	1100.0
2013-11-12 19:00:00	IWM	ETF	109.41	109.47	109.41	109.41	1462.0
2013-11-12 08:00:00	DIA	ETF	157.35	157.35	157.3	157.34	2360.0
2013-11-12 09:00:00	DIA	ETF	157.31	157.71	157.28	157.58	559371.0
2013-11-12 10:00:00	DIA	ETF	157.6	157.72	157.32	157.36	654840.0
2013-11-12 11:00:00	DIA	ETF	157.37	157.51	156.97	157.14	789989.0
2013-11-12 12:00:00	DIA	ETF	157.15	157.2	156.93	157.14	351895.0

> showing 50 of 6,458 rows — these rows as CSV

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