PREVIEW / etf_1hour / 2013-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-23.parquet
  size:    202 KB
  rows:    6,313

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-08-23 04:00:00	SPY	ETF	165.93	166.03	165.73	165.74	22870.0
2013-08-23 05:00:00	SPY	ETF	165.76	165.88	165.7	165.84	16500.0
2013-08-23 06:00:00	SPY	ETF	165.88	165.92	165.81	165.92	53302.0
2013-08-23 07:00:00	SPY	ETF	165.93	166.15	165.9	166.1	292341.0
2013-08-23 08:00:00	SPY	ETF	166.12	166.25	165.93	166.17	383659.0
2013-08-23 09:00:00	SPY	ETF	166.14	166.66	166.01	166.15	12192874.0
2013-08-23 10:00:00	SPY	ETF	166.15	166.53	165.77	166.42	18413611.0
2013-08-23 11:00:00	SPY	ETF	166.43	166.519	166.12	166.22	7407098.0
2013-08-23 12:00:00	SPY	ETF	166.22	166.43	166.2	166.42	6382302.0
2013-08-23 13:00:00	SPY	ETF	166.4101	166.49	166.29	166.415	5445514.0
2013-08-23 14:00:00	SPY	ETF	166.415	166.48	166.29	166.441	4131870.0
2013-08-23 15:00:00	SPY	ETF	166.45	166.83	166.37	166.59	18743141.0
2013-08-23 16:00:00	SPY	ETF	166.59	166.78	166.0185	166.73	12091716.0
2013-08-23 17:00:00	SPY	ETF	166.73	166.73	166.64	166.64	128601.0
2013-08-23 18:00:00	SPY	ETF	166.69	166.74	166.68	166.7	6391.0
2013-08-23 19:00:00	SPY	ETF	166.7	166.72	166.67	166.71	14366.0
2013-08-23 04:00:00	QQQ	ETF	76.24	76.24	76.07	76.07	24100.0
2013-08-23 05:00:00	QQQ	ETF	76.09	76.13	76.05	76.13	13500.0
2013-08-23 06:00:00	QQQ	ETF	76.15	76.16	76.11	76.16	56140.0
2013-08-23 07:00:00	QQQ	ETF	76.17	76.25	76.17	76.25	8400.0
2013-08-23 08:00:00	QQQ	ETF	76.17	76.28	76.16	76.25	42467.0
2013-08-23 09:00:00	QQQ	ETF	76.25	76.78	76.24	76.57	5250485.0
2013-08-23 10:00:00	QQQ	ETF	76.56	76.68	76.4	76.61	3905442.0
2013-08-23 11:00:00	QQQ	ETF	76.6003	76.64	76.4501	76.52	1977834.0
2013-08-23 12:00:00	QQQ	ETF	76.53	76.67	76.51	76.631	1058653.0
2013-08-23 13:00:00	QQQ	ETF	76.64	76.67	76.59	76.61	598379.0
2013-08-23 14:00:00	QQQ	ETF	76.6	76.6701	76.56	76.64	1274357.0
2013-08-23 15:00:00	QQQ	ETF	76.64	76.77	76.6	76.67	4249005.0
2013-08-23 16:00:00	QQQ	ETF	76.67	76.74	76.61	76.69	1741944.0
2013-08-23 17:00:00	QQQ	ETF	76.67	76.68	76.65	76.68	2090.0
2013-08-23 18:00:00	QQQ	ETF	76.68	76.68	76.68	76.68	100.0
2013-08-23 19:00:00	QQQ	ETF	76.68	76.73	76.66	76.73	2273.0
2013-08-23 07:00:00	IWM	ETF	102.92	102.92	102.92	102.92	24000.0
2013-08-23 08:00:00	IWM	ETF	102.93	102.99	102.87	102.91	171101.0
2013-08-23 09:00:00	IWM	ETF	102.98	103.32	102.57	102.75	3235274.0
2013-08-23 10:00:00	IWM	ETF	102.74	102.96	102.45	102.835	4484661.0
2013-08-23 11:00:00	IWM	ETF	102.83	102.95	102.64	102.755	1927717.0
2013-08-23 12:00:00	IWM	ETF	102.76	102.86	102.7	102.79	1199867.0
2013-08-23 13:00:00	IWM	ETF	102.79	102.88	102.7	102.81	1058630.0
2013-08-23 14:00:00	IWM	ETF	102.81	102.98	102.73	102.95	1499352.0
2013-08-23 15:00:00	IWM	ETF	102.95	103.25	102.91	103.14	4461043.0
2013-08-23 16:00:00	IWM	ETF	103.14	103.29	102.7578	103.28	938104.0
2013-08-23 17:00:00	IWM	ETF	103.27	103.27	103.27	103.27	4932.0
2013-08-23 18:00:00	IWM	ETF	103.22	103.22	103.21	103.21	2660.0
2013-08-23 07:00:00	DIA	ETF	149.35	149.36	149.35	149.36	2700.0
2013-08-23 08:00:00	DIA	ETF	149.37	149.44	149.3	149.37	12300.0
2013-08-23 09:00:00	DIA	ETF	149.44	149.66	149.34	149.41	868195.0
2013-08-23 10:00:00	DIA	ETF	149.41	149.68	149.06	149.62	1541264.0
2013-08-23 11:00:00	DIA	ETF	149.63	149.68	149.34	149.44	820614.0
2013-08-23 12:00:00	DIA	ETF	149.44	149.64	149.42	149.63	678386.0

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

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