PREVIEW / etf_1hour / 2012-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-23.parquet
  size:    192 KB
  rows:    5,935

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-07-23 04:00:00	SPY	ETF	135.48	136.25	135.26	135.3	58616.0
2012-07-23 05:00:00	SPY	ETF	135.31	135.31	134.9	134.92	28441.0
2012-07-23 06:00:00	SPY	ETF	134.94	135.15	134.75	135.05	67458.0
2012-07-23 07:00:00	SPY	ETF	135.06	135.14	134.85	134.95	359892.0
2012-07-23 08:00:00	SPY	ETF	134.95	135.78	134.37	134.58	3727527.0
2012-07-23 09:00:00	SPY	ETF	134.58	134.67	133.84	134.09	23760548.0
2012-07-23 10:00:00	SPY	ETF	134.09	134.54	133.87	134.419	20908908.0
2012-07-23 11:00:00	SPY	ETF	134.41	134.71	134.31	134.59	15556089.0
2012-07-23 12:00:00	SPY	ETF	134.5938	134.89	134.34	134.8	9935281.0
2012-07-23 13:00:00	SPY	ETF	134.81	134.97	134.69	134.92	10726804.0
2012-07-23 14:00:00	SPY	ETF	134.92	136.3852	134.825	134.88	12414951.0
2012-07-23 15:00:00	SPY	ETF	134.87	135.46	134.72	135.13	28039772.0
2012-07-23 16:00:00	SPY	ETF	135.14	135.1772	134.24	134.68	14203660.0
2012-07-23 17:00:00	SPY	ETF	134.67	134.76	134.48	134.5	296944.0
2012-07-23 18:00:00	SPY	ETF	134.5	134.64	134.32	134.64	288935.0
2012-07-23 19:00:00	SPY	ETF	134.61	134.71	134.57	134.69	94437.0
2012-07-23 04:00:00	QQQ	ETF	63.8	63.8	63.62	63.63	1380.0
2012-07-23 05:00:00	QQQ	ETF	63.6	63.6	63.45	63.45	2616.0
2012-07-23 06:00:00	QQQ	ETF	63.39	63.49	63.39	63.49	2450.0
2012-07-23 07:00:00	QQQ	ETF	63.5	63.51	63.36	63.42	60272.0
2012-07-23 08:00:00	QQQ	ETF	63.43	63.44	63.13	63.17	441405.0
2012-07-23 09:00:00	QQQ	ETF	63.16	63.22	62.51	62.72	8072852.0
2012-07-23 10:00:00	QQQ	ETF	62.71	63.03	62.63	62.91	6605448.0
2012-07-23 11:00:00	QQQ	ETF	62.905	63.1	62.85	63.045	3697360.0
2012-07-23 12:00:00	QQQ	ETF	63.05	63.28	62.95	63.22	3741885.0
2012-07-23 13:00:00	QQQ	ETF	63.22	63.43	63.1789	63.38	1954495.0
2012-07-23 14:00:00	QQQ	ETF	63.38	63.53	63.33	63.39	2650385.0
2012-07-23 15:00:00	QQQ	ETF	63.38	63.68	63.29	63.48	7968517.0
2012-07-23 16:00:00	QQQ	ETF	63.48	64.2016	62.5865	63.27	1727356.0
2012-07-23 17:00:00	QQQ	ETF	63.3	63.32	63.24	63.32	13555.0
2012-07-23 18:00:00	QQQ	ETF	63.23	63.31	63.18	63.3	48481.0
2012-07-23 19:00:00	QQQ	ETF	63.3	63.34	63.28	63.33	7883.0
2012-07-23 04:00:00	IWM	ETF	78.22	78.22	78.08	78.09	1300.0
2012-07-23 05:00:00	IWM	ETF	78.0	78.0	77.74	77.74	20600.0
2012-07-23 06:00:00	IWM	ETF	77.74	77.9	77.74	77.9	10260.0
2012-07-23 07:00:00	IWM	ETF	77.87	77.9	77.75	77.82	49700.0
2012-07-23 08:00:00	IWM	ETF	77.8	77.83	77.36	77.46	590364.0
2012-07-23 09:00:00	IWM	ETF	77.44	77.57	77.18	77.28	6091139.0
2012-07-23 10:00:00	IWM	ETF	77.27	77.61	77.2	77.51	7743393.0
2012-07-23 11:00:00	IWM	ETF	77.51	77.77	77.4	77.56	4688394.0
2012-07-23 12:00:00	IWM	ETF	77.5528	77.72	77.4	77.7	4022500.0
2012-07-23 13:00:00	IWM	ETF	77.7	77.8101	77.57	77.79	2557755.0
2012-07-23 14:00:00	IWM	ETF	77.79	77.85	77.64	77.7	2530210.0
2012-07-23 15:00:00	IWM	ETF	77.69	78.03	77.56	77.68	8958385.0
2012-07-23 16:00:00	IWM	ETF	77.67	78.9365	77.39	77.41	8115564.0
2012-07-23 17:00:00	IWM	ETF	77.4	77.49	77.27	77.37	45155.0
2012-07-23 18:00:00	IWM	ETF	77.27	77.38	77.2	77.38	4688.0
2012-07-23 19:00:00	IWM	ETF	77.39	77.42	77.32	77.42	2870.0
2012-07-23 04:00:00	DIA	ETF	126.96	126.96	126.96	126.96	100.0
2012-07-23 07:00:00	DIA	ETF	126.65	126.65	126.31	126.31	250.0

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

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