PREVIEW / etf_1hour / 2013-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-03.parquet
  size:    212 KB
  rows:    6,706

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-12-03 04:00:00	SPY	ETF	180.66	180.66	180.23	180.24	4576.0
2013-12-03 05:00:00	SPY	ETF	180.24	180.24	180.05	180.05	12494.0
2013-12-03 06:00:00	SPY	ETF	180.07	180.07	179.89	179.93	120547.0
2013-12-03 07:00:00	SPY	ETF	179.94	180.05	179.89	180.05	398509.0
2013-12-03 08:00:00	SPY	ETF	180.05	180.1	179.89	179.9	510179.0
2013-12-03 09:00:00	SPY	ETF	179.9	180.29	179.76	180.27	15636990.0
2013-12-03 10:00:00	SPY	ETF	180.27	180.39	180.11	180.28	15981496.0
2013-12-03 11:00:00	SPY	ETF	180.29	180.318	179.47	179.691	16331644.0
2013-12-03 12:00:00	SPY	ETF	179.69	179.87	179.61	179.7616	7079289.0
2013-12-03 13:00:00	SPY	ETF	179.7607	179.79	179.31	179.405	11001801.0
2013-12-03 14:00:00	SPY	ETF	179.41	179.74	179.17	179.73	11020406.0
2013-12-03 15:00:00	SPY	ETF	179.73	179.97	179.4	179.88	17839916.0
2013-12-03 16:00:00	SPY	ETF	179.88	180.5056	179.63	179.7	12506308.0
2013-12-03 17:00:00	SPY	ETF	179.7	179.8437	179.66	179.73	162695.0
2013-12-03 18:00:00	SPY	ETF	179.73	179.8	179.7	179.73	180543.0
2013-12-03 19:00:00	SPY	ETF	179.76	179.84	179.73	179.82	137875.0
2013-12-03 04:00:00	QQQ	ETF	85.49	85.5	85.49	85.5	2000.0
2013-12-03 05:00:00	QQQ	ETF	85.48	85.48	85.41	85.41	41600.0
2013-12-03 06:00:00	QQQ	ETF	85.39	85.39	85.35	85.38	6300.0
2013-12-03 07:00:00	QQQ	ETF	85.4	85.42	85.35	85.4	29805.0
2013-12-03 08:00:00	QQQ	ETF	85.36	85.41	85.36	85.38	187670.0
2013-12-03 09:00:00	QQQ	ETF	85.38	85.565	85.32	85.5095	5384246.0
2013-12-03 10:00:00	QQQ	ETF	85.51	85.64	85.43	85.51	4690223.0
2013-12-03 11:00:00	QQQ	ETF	85.52	85.56	85.18	85.3	5423274.0
2013-12-03 12:00:00	QQQ	ETF	85.29	85.36	85.25	85.35	1844711.0
2013-12-03 13:00:00	QQQ	ETF	85.35	85.35	85.09	85.165	3241190.0
2013-12-03 14:00:00	QQQ	ETF	85.16	85.36	85.08	85.36	3106501.0
2013-12-03 15:00:00	QQQ	ETF	85.359	85.44	85.17	85.41	4925353.0
2013-12-03 16:00:00	QQQ	ETF	85.41	85.48	85.31	85.35	4712679.0
2013-12-03 17:00:00	QQQ	ETF	85.35	85.36	85.34	85.35	233300.0
2013-12-03 18:00:00	QQQ	ETF	85.38	85.39	85.35	85.35	2100.0
2013-12-03 19:00:00	QQQ	ETF	85.38	85.4	85.38	85.38	5150.0
2013-12-03 06:00:00	IWM	ETF	112.15	112.15	111.91	111.94	13450.0
2013-12-03 07:00:00	IWM	ETF	111.97	112.06	111.94	112.05	33300.0
2013-12-03 08:00:00	IWM	ETF	112.02	112.13	112.01	112.07	112286.0
2013-12-03 09:00:00	IWM	ETF	112.08	112.42	111.93	112.32	4988051.0
2013-12-03 10:00:00	IWM	ETF	112.33	112.6	112.22	112.3	5022130.0
2013-12-03 11:00:00	IWM	ETF	112.31	112.31	111.67	111.84	5149894.0
2013-12-03 12:00:00	IWM	ETF	111.85	111.96	111.67	111.77	2637259.0
2013-12-03 13:00:00	IWM	ETF	111.78	111.78	111.28	111.45	3845045.0
2013-12-03 14:00:00	IWM	ETF	111.45	111.71	111.27	111.64	3057084.0
2013-12-03 15:00:00	IWM	ETF	111.64	111.84	111.381	111.82	5466809.0
2013-12-03 16:00:00	IWM	ETF	111.82	111.83	111.61	111.67	1332890.0
2013-12-03 17:00:00	IWM	ETF	111.7	111.7	111.67	111.67	392.0
2013-12-03 19:00:00	IWM	ETF	111.7	111.91	111.7	111.91	350.0
2013-12-03 05:00:00	DIA	ETF	159.55	159.55	159.49	159.49	3700.0
2013-12-03 06:00:00	DIA	ETF	159.47	159.47	159.33	159.33	9850.0
2013-12-03 07:00:00	DIA	ETF	159.34	159.34	159.29	159.29	3600.0
2013-12-03 08:00:00	DIA	ETF	159.4	159.4	159.26	159.27	22288.0
2013-12-03 09:00:00	DIA	ETF	159.25	159.53	159.14	159.5	1643467.0

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

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