PREVIEW / etf_1hour / 2013-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-12.parquet
  size:    196 KB
  rows:    6,160

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-03-12 04:00:00	SPY	ETF	155.75	155.86	155.71	155.85	21040.0
2013-03-12 05:00:00	SPY	ETF	155.89	155.96	155.75	155.84	50900.0
2013-03-12 06:00:00	SPY	ETF	155.8	155.84	155.7	155.81	18500.0
2013-03-12 07:00:00	SPY	ETF	155.8	155.82	155.65	155.72	214104.0
2013-03-12 08:00:00	SPY	ETF	155.81	155.88	155.69	155.86	1206895.0
2013-03-12 09:00:00	SPY	ETF	155.86	155.95	155.74	155.903	10412226.0
2013-03-12 10:00:00	SPY	ETF	155.91	156.1	155.82	155.85	13106026.0
2013-03-12 11:00:00	SPY	ETF	155.86	155.86	155.32	155.695	19221376.0
2013-03-12 12:00:00	SPY	ETF	155.7	155.74	155.42	155.66	8317909.0
2013-03-12 13:00:00	SPY	ETF	155.67	155.67	155.37	155.4	6872620.0
2013-03-12 14:00:00	SPY	ETF	155.41	155.505	155.21	155.4	11208390.0
2013-03-12 15:00:00	SPY	ETF	155.4	155.76	155.39	155.7	24384208.0
2013-03-12 16:00:00	SPY	ETF	155.69	155.76	155.3192	155.76	5474835.0
2013-03-12 17:00:00	SPY	ETF	155.75	156.0247	155.7	155.74	1553586.0
2013-03-12 18:00:00	SPY	ETF	155.72	155.72	155.65	155.7	32109.0
2013-03-12 19:00:00	SPY	ETF	155.66	155.75	155.66	155.73	59766.0
2013-03-12 04:00:00	QQQ	ETF	68.82	68.82	68.81	68.81	2500.0
2013-03-12 05:00:00	QQQ	ETF	68.8	68.8	68.8	68.8	1100.0
2013-03-12 06:00:00	QQQ	ETF	68.8	68.8	68.77	68.77	947.0
2013-03-12 07:00:00	QQQ	ETF	68.82	68.82	68.74	68.74	15900.0
2013-03-12 08:00:00	QQQ	ETF	68.74	68.8	68.74	68.77	100495.0
2013-03-12 09:00:00	QQQ	ETF	68.77	68.9299	68.67	68.8601	3347704.0
2013-03-12 10:00:00	QQQ	ETF	68.86	68.9099	68.64	68.73	2694475.0
2013-03-12 11:00:00	QQQ	ETF	68.73	68.74	68.39	68.61	4671715.0
2013-03-12 12:00:00	QQQ	ETF	68.62	68.695	68.51	68.66	1815233.0
2013-03-12 13:00:00	QQQ	ETF	68.66	68.71	68.51	68.55	1667859.0
2013-03-12 14:00:00	QQQ	ETF	68.55	68.585	68.448	68.52	1807004.0
2013-03-12 15:00:00	QQQ	ETF	68.53	68.76	68.525	68.72	4808914.0
2013-03-12 16:00:00	QQQ	ETF	68.73	68.9817	68.685	68.78	6429424.0
2013-03-12 17:00:00	QQQ	ETF	68.78	68.8	68.75	68.77	3798.0
2013-03-12 18:00:00	QQQ	ETF	68.74	68.75	68.73	68.73	3000.0
2013-03-12 19:00:00	QQQ	ETF	68.74	68.76	68.73	68.73	3875.0
2013-03-12 07:00:00	IWM	ETF	93.48	93.48	93.38	93.38	13600.0
2013-03-12 08:00:00	IWM	ETF	93.38	93.48	93.36	93.44	77255.0
2013-03-12 09:00:00	IWM	ETF	93.46	93.7	93.41	93.66	3068288.0
2013-03-12 10:00:00	IWM	ETF	93.66	93.75	93.52	93.61	3241594.0
2013-03-12 11:00:00	IWM	ETF	93.6	93.6	93.18	93.39	4428343.0
2013-03-12 12:00:00	IWM	ETF	93.39	93.5	93.27	93.45	1318039.0
2013-03-12 13:00:00	IWM	ETF	93.45	93.5	93.32	93.36	1224744.0
2013-03-12 14:00:00	IWM	ETF	93.37	93.4	93.24	93.31	1921648.0
2013-03-12 15:00:00	IWM	ETF	93.31	93.54	93.31	93.47	4483836.0
2013-03-12 16:00:00	IWM	ETF	93.49	93.64	93.43	93.63	926339.0
2013-03-12 17:00:00	IWM	ETF	93.63	93.65	93.61	93.62	11237.0
2013-03-12 06:00:00	DIA	ETF	144.18	144.18	144.18	144.18	200.0
2013-03-12 08:00:00	DIA	ETF	144.07	144.29	144.07	144.29	9435.0
2013-03-12 09:00:00	DIA	ETF	144.29	144.43	144.23	144.4	625441.0
2013-03-12 10:00:00	DIA	ETF	144.41	144.7	144.405	144.51	989300.0
2013-03-12 11:00:00	DIA	ETF	144.51	144.51	144.15	144.42	800571.0
2013-03-12 12:00:00	DIA	ETF	144.4099	144.45	144.16	144.37	420978.0
2013-03-12 13:00:00	DIA	ETF	144.37	144.38	144.16	144.2	316805.0

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

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