PREVIEW / etf_1hour / 2013-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-09.parquet
  size:    199 KB
  rows:    6,178

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-04-09 04:00:00	SPY	ETF	156.48	156.69	156.48	156.5	14899.0
2013-04-09 05:00:00	SPY	ETF	156.39	156.62	156.39	156.49	57000.0
2013-04-09 06:00:00	SPY	ETF	156.5	156.55	156.41	156.41	93900.0
2013-04-09 07:00:00	SPY	ETF	156.45	156.64	156.45	156.54	121386.0
2013-04-09 08:00:00	SPY	ETF	156.54	156.75	156.44	156.65	982373.0
2013-04-09 09:00:00	SPY	ETF	156.65	156.71	155.98	156.06	12237831.0
2013-04-09 10:00:00	SPY	ETF	156.06	156.53	156.02	156.24	15865498.0
2013-04-09 11:00:00	SPY	ETF	156.235	156.5	156.04	156.49	10713019.0
2013-04-09 12:00:00	SPY	ETF	156.49	156.76	156.37	156.63	7559802.0
2013-04-09 13:00:00	SPY	ETF	156.64	157.19	156.63	157.03	13440711.0
2013-04-09 14:00:00	SPY	ETF	157.02	157.32	156.97	157.23	11026089.0
2013-04-09 15:00:00	SPY	ETF	157.23	157.3	156.7	156.74	22610330.0
2013-04-09 16:00:00	SPY	ETF	156.73	157.1	156.71	156.76	5084379.0
2013-04-09 17:00:00	SPY	ETF	156.76	156.83	156.76	156.78	147060.0
2013-04-09 18:00:00	SPY	ETF	156.77	156.77	156.65	156.69	1105267.0
2013-04-09 19:00:00	SPY	ETF	156.69	156.74	156.63	156.65	54599.0
2013-04-09 04:00:00	QQQ	ETF	68.43	68.43	68.43	68.43	3600.0
2013-04-09 05:00:00	QQQ	ETF	68.45	68.45	68.45	68.45	11400.0
2013-04-09 06:00:00	QQQ	ETF	68.42	68.42	68.42	68.42	5400.0
2013-04-09 07:00:00	QQQ	ETF	68.44	68.5	68.44	68.44	6100.0
2013-04-09 08:00:00	QQQ	ETF	68.45	68.54	68.42	68.53	61445.0
2013-04-09 09:00:00	QQQ	ETF	68.53	68.56	68.13	68.17	4307541.0
2013-04-09 10:00:00	QQQ	ETF	68.17	68.45	68.15	68.32	3447094.0
2013-04-09 11:00:00	QQQ	ETF	68.32	68.38	68.09	68.37	2922135.0
2013-04-09 12:00:00	QQQ	ETF	68.3799	68.51	68.31	68.48	1481378.0
2013-04-09 13:00:00	QQQ	ETF	68.49	68.88	68.49	68.7899	4344333.0
2013-04-09 14:00:00	QQQ	ETF	68.79	68.96	68.75	68.86	2996032.0
2013-04-09 15:00:00	QQQ	ETF	68.87	68.91	68.65	68.675	4766752.0
2013-04-09 16:00:00	QQQ	ETF	68.68	68.8152	68.2384	68.7	2013845.0
2013-04-09 17:00:00	QQQ	ETF	68.72	68.78	68.72	68.77	128600.0
2013-04-09 18:00:00	QQQ	ETF	68.74	68.74	68.66	68.66	40000.0
2013-04-09 19:00:00	QQQ	ETF	68.67	68.69	68.66	68.66	11600.0
2013-04-09 04:00:00	IWM	ETF	92.89	92.89	92.89	92.89	100.0
2013-04-09 05:00:00	IWM	ETF	92.76	92.76	92.76	92.76	100.0
2013-04-09 06:00:00	IWM	ETF	92.78	92.78	92.78	92.78	2000.0
2013-04-09 07:00:00	IWM	ETF	92.79	92.89	92.79	92.81	86500.0
2013-04-09 08:00:00	IWM	ETF	92.83	92.87	92.76	92.82	114293.0
2013-04-09 09:00:00	IWM	ETF	92.83	92.83	92.12	92.14	4265735.0
2013-04-09 10:00:00	IWM	ETF	92.14	92.7	92.1	92.23	5111854.0
2013-04-09 11:00:00	IWM	ETF	92.24	92.46	92.04	92.45	3406254.0
2013-04-09 12:00:00	IWM	ETF	92.45	92.6	92.262	92.46	2469315.0
2013-04-09 13:00:00	IWM	ETF	92.45	92.78	92.45	92.6601	2538048.0
2013-04-09 14:00:00	IWM	ETF	92.67	92.83	92.56	92.7	2632804.0
2013-04-09 15:00:00	IWM	ETF	92.7	92.76	92.2	92.23	7723171.0
2013-04-09 16:00:00	IWM	ETF	92.22	92.42	92.16	92.23	1868729.0
2013-04-09 17:00:00	IWM	ETF	92.24	92.24	92.2	92.2	4000.0
2013-04-09 18:00:00	IWM	ETF	92.2	92.2	92.18	92.18	1240.0
2013-04-09 19:00:00	IWM	ETF	92.17	92.17	92.17	92.17	130.0
2013-04-09 06:00:00	DIA	ETF	145.98	145.98	145.98	145.98	3000.0
2013-04-09 07:00:00	DIA	ETF	146.02	146.14	146.02	146.14	3100.0

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

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