PREVIEW / etf_1hour / 2013-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-23.parquet
  size:    216 KB
  rows:    6,900

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-23 04:00:00	SPY	ETF	182.42	182.44	182.4	182.44	16680.0
2013-12-23 05:00:00	SPY	ETF	182.44	182.49	182.4	182.43	47588.0
2013-12-23 06:00:00	SPY	ETF	182.46	182.49	182.32	182.37	42374.0
2013-12-23 07:00:00	SPY	ETF	182.36	182.48	182.35	182.48	226821.0
2013-12-23 08:00:00	SPY	ETF	182.47	182.6	181.56	182.53	1433752.0
2013-12-23 09:00:00	SPY	ETF	182.56	182.56	182.18	182.1875	10415827.0
2013-12-23 10:00:00	SPY	ETF	182.181	182.44	182.065	182.39	10652459.0
2013-12-23 11:00:00	SPY	ETF	182.39	182.56	182.37	182.495	9579835.0
2013-12-23 12:00:00	SPY	ETF	182.49	182.64	182.44	182.47	6581971.0
2013-12-23 13:00:00	SPY	ETF	182.47	182.53	182.15	182.2901	6918901.0
2013-12-23 14:00:00	SPY	ETF	182.295	182.44	182.225	182.332	6839444.0
2013-12-23 15:00:00	SPY	ETF	182.34	182.52	182.3	182.46	16274834.0
2013-12-23 16:00:00	SPY	ETF	182.47	182.58	181.4662	182.55	7031481.0
2013-12-23 17:00:00	SPY	ETF	182.54	182.56	182.45	182.5	114441.0
2013-12-23 18:00:00	SPY	ETF	182.5	182.54	182.47	182.49	41771.0
2013-12-23 19:00:00	SPY	ETF	182.48	182.48	182.29	182.31	151255.0
2013-12-23 04:00:00	QQQ	ETF	87.01	87.18	86.47	87.17	35674.0
2013-12-23 05:00:00	QQQ	ETF	87.16	87.19	87.16	87.19	18700.0
2013-12-23 06:00:00	QQQ	ETF	87.19	87.2	87.1	87.1	9800.0
2013-12-23 07:00:00	QQQ	ETF	87.1	87.2	87.1	87.19	25180.0
2013-12-23 08:00:00	QQQ	ETF	87.2	87.28	87.18	87.27	134024.0
2013-12-23 09:00:00	QQQ	ETF	87.26	87.26	87.035	87.04	3528266.0
2013-12-23 10:00:00	QQQ	ETF	87.04	87.19	86.95	87.18	2983285.0
2013-12-23 11:00:00	QQQ	ETF	87.18	87.29	87.16	87.25	2757305.0
2013-12-23 12:00:00	QQQ	ETF	87.25	87.35	87.22	87.25	1990574.0
2013-12-23 13:00:00	QQQ	ETF	87.25	87.3	87.1	87.169	1939217.0
2013-12-23 14:00:00	QQQ	ETF	87.1699	87.2799	87.125	87.205	2922216.0
2013-12-23 15:00:00	QQQ	ETF	87.21	87.4	87.205	87.39	5293759.0
2013-12-23 16:00:00	QQQ	ETF	87.4	87.41	86.4319	87.381	1693874.0
2013-12-23 17:00:00	QQQ	ETF	87.4	87.41	87.4	87.41	1900.0
2013-12-23 18:00:00	QQQ	ETF	87.38	87.38	87.35	87.37	1125.0
2013-12-23 19:00:00	QQQ	ETF	87.34	87.35	87.32	87.34	10470.0
2013-12-23 07:00:00	IWM	ETF	113.91	114.12	113.89	114.12	21612.0
2013-12-23 08:00:00	IWM	ETF	114.09	114.22	114.08	114.22	179541.0
2013-12-23 09:00:00	IWM	ETF	114.22	114.43	113.95	114.15	3671244.0
2013-12-23 10:00:00	IWM	ETF	114.15	114.6	114.07	114.3799	5107652.0
2013-12-23 11:00:00	IWM	ETF	114.37	114.635	114.345	114.54	3261095.0
2013-12-23 12:00:00	IWM	ETF	114.55	114.74	114.5	114.62	2845270.0
2013-12-23 13:00:00	IWM	ETF	114.62	114.8	114.545	114.62	2741017.0
2013-12-23 14:00:00	IWM	ETF	114.62	114.71	114.5	114.55	2788386.0
2013-12-23 15:00:00	IWM	ETF	114.55	114.82	114.545	114.73	5880441.0
2013-12-23 16:00:00	IWM	ETF	114.74	114.8	113.6596	114.72	3670403.0
2013-12-23 17:00:00	IWM	ETF	114.75	114.75	114.69	114.69	840.0
2013-12-23 18:00:00	IWM	ETF	114.74	114.74	114.6	114.6	1314.0
2013-12-23 19:00:00	IWM	ETF	114.68	114.71	114.6	114.6	1893.0
2013-12-23 07:00:00	DIA	ETF	162.5	162.55	162.5	162.55	900.0
2013-12-23 08:00:00	DIA	ETF	162.551	162.65	162.55	162.65	955.0
2013-12-23 09:00:00	DIA	ETF	162.63	162.75	162.43	162.45	866576.0
2013-12-23 10:00:00	DIA	ETF	162.46	162.63	162.33	162.595	570331.0
2013-12-23 11:00:00	DIA	ETF	162.58	162.71	162.57	162.69	407616.0

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

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