PREVIEW / etf_1hour / 2013-04-01

all etf 1-hour files

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

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-01 04:00:00	SPY	ETF	156.64	156.64	156.39	156.42	3520.0
2013-04-01 05:00:00	SPY	ETF	156.42	156.46	156.38	156.41	4780.0
2013-04-01 06:00:00	SPY	ETF	156.42	156.61	156.42	156.59	11380.0
2013-04-01 07:00:00	SPY	ETF	156.57	156.81	156.57	156.69	215131.0
2013-04-01 08:00:00	SPY	ETF	156.69	156.77	156.38	156.67	931226.0
2013-04-01 09:00:00	SPY	ETF	156.66	156.91	156.54	156.61	8764987.0
2013-04-01 10:00:00	SPY	ETF	156.6	156.72	155.86	155.86	25248108.0
2013-04-01 11:00:00	SPY	ETF	155.86	156.1	155.75	155.995	10739360.0
2013-04-01 12:00:00	SPY	ETF	155.97	156.08	155.805	156.07	5279865.0
2013-04-01 13:00:00	SPY	ETF	156.06	156.26	156.03	156.09	6573258.0
2013-04-01 14:00:00	SPY	ETF	156.09	156.22	155.89	155.95	6532651.0
2013-04-01 15:00:00	SPY	ETF	155.94	156.07	155.67	156.06	20684375.0
2013-04-01 16:00:00	SPY	ETF	156.06	156.0963	155.91	156.0	8757612.0
2013-04-01 17:00:00	SPY	ETF	156.01	156.08	156.01	156.03	62813.0
2013-04-01 18:00:00	SPY	ETF	156.04	156.09	155.99	155.99	33600.0
2013-04-01 19:00:00	SPY	ETF	156.01	156.1	156.0	156.09	13950.0
2013-04-01 04:00:00	QQQ	ETF	68.92	68.92	68.87	68.87	1200.0
2013-04-01 05:00:00	QQQ	ETF	68.9	68.9	68.9	68.9	300.0
2013-04-01 07:00:00	QQQ	ETF	69.0	69.08	69.0	69.05	5900.0
2013-04-01 08:00:00	QQQ	ETF	69.01	69.08	69.01	69.06	47080.0
2013-04-01 09:00:00	QQQ	ETF	69.06	69.09	68.98	68.98	2601153.0
2013-04-01 10:00:00	QQQ	ETF	68.99	69.02	68.59	68.59	7525669.0
2013-04-01 11:00:00	QQQ	ETF	68.58	68.74	68.51	68.68	3304085.0
2013-04-01 12:00:00	QQQ	ETF	68.67	68.67	68.505	68.615	1391312.0
2013-04-01 13:00:00	QQQ	ETF	68.62	68.72	68.59	68.6	1722762.0
2013-04-01 14:00:00	QQQ	ETF	68.61	68.678	68.48	68.4801	1840104.0
2013-04-01 15:00:00	QQQ	ETF	68.49	68.52	68.31	68.5	7622889.0
2013-04-01 16:00:00	QQQ	ETF	68.5	69.01	68.37	68.45	1732196.0
2013-04-01 17:00:00	QQQ	ETF	68.45	68.49	68.45	68.48	2850.0
2013-04-01 18:00:00	QQQ	ETF	68.44	68.46	68.44	68.44	2677.0
2013-04-01 19:00:00	QQQ	ETF	68.44	68.48	68.43	68.48	5300.0
2013-04-01 04:00:00	IWM	ETF	94.18	94.18	94.16	94.16	12000.0
2013-04-01 07:00:00	IWM	ETF	94.23	94.38	94.23	94.29	86800.0
2013-04-01 08:00:00	IWM	ETF	94.31	94.38	94.31	94.33	33090.0
2013-04-01 09:00:00	IWM	ETF	94.34	94.47	94.15	94.15	3668043.0
2013-04-01 10:00:00	IWM	ETF	94.15	94.17	92.94	92.96	11769222.0
2013-04-01 11:00:00	IWM	ETF	92.97	93.028	92.79	92.92	5270332.0
2013-04-01 12:00:00	IWM	ETF	92.915	93.005	92.705	93.0	3150638.0
2013-04-01 13:00:00	IWM	ETF	92.991	93.25	92.93	93.07	2856676.0
2013-04-01 14:00:00	IWM	ETF	93.07	93.31	93.055	93.06	3677892.0
2013-04-01 15:00:00	IWM	ETF	93.05	93.2	92.74	93.19	9437867.0
2013-04-01 16:00:00	IWM	ETF	93.2	94.4583	93.06	93.07	4610790.0
2013-04-01 17:00:00	IWM	ETF	93.15	93.15	93.15	93.15	1600.0
2013-04-01 18:00:00	IWM	ETF	93.17	93.18	93.17	93.18	10000.0
2013-04-01 07:00:00	DIA	ETF	145.54	145.54	145.54	145.54	200.0
2013-04-01 08:00:00	DIA	ETF	145.55	145.55	145.38	145.39	12144.0
2013-04-01 09:00:00	DIA	ETF	145.4	145.7335	145.23	145.54	581014.0
2013-04-01 10:00:00	DIA	ETF	145.5401	145.66	145.1	145.1	2886959.0
2013-04-01 11:00:00	DIA	ETF	145.1	145.29	144.97	145.21	710846.0
2013-04-01 12:00:00	DIA	ETF	145.19	145.33	145.1	145.3299	387235.0

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

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