PREVIEW / etf_1hour / 2013-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-16.parquet
  size:    194 KB
  rows:    6,095

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-01-16 04:00:00	SPY	ETF	146.84	146.84	146.41	146.45	18699.0
2013-01-16 05:00:00	SPY	ETF	146.42	146.58	146.38	146.55	35968.0
2013-01-16 06:00:00	SPY	ETF	146.58	146.8	146.58	146.63	90934.0
2013-01-16 07:00:00	SPY	ETF	146.72	146.72	146.39	146.4	805170.0
2013-01-16 08:00:00	SPY	ETF	146.42	146.76	146.4	146.55	1116106.0
2013-01-16 09:00:00	SPY	ETF	146.555	146.87	146.555	146.82	18136261.0
2013-01-16 10:00:00	SPY	ETF	146.81	147.03	146.8	146.82	11091226.0
2013-01-16 11:00:00	SPY	ETF	146.82	147.185	146.82	147.05	9130784.0
2013-01-16 12:00:00	SPY	ETF	147.0502	147.12	146.89	146.985	6973583.0
2013-01-16 13:00:00	SPY	ETF	146.99	147.25	146.92	147.17	11351936.0
2013-01-16 14:00:00	SPY	ETF	147.17	147.28	147.06	147.25	6920167.0
2013-01-16 15:00:00	SPY	ETF	147.2501	147.26	147.01	147.04	21796131.0
2013-01-16 16:00:00	SPY	ETF	147.03	147.1442	146.83	146.86	15657278.0
2013-01-16 17:00:00	SPY	ETF	146.87	146.89	146.82	146.87	90755.0
2013-01-16 18:00:00	SPY	ETF	146.88	146.89	146.71	146.75	40391.0
2013-01-16 19:00:00	SPY	ETF	146.77	146.95	146.77	146.95	61169.0
2013-01-16 05:00:00	QQQ	ETF	66.49	66.51	66.49	66.51	8700.0
2013-01-16 06:00:00	QQQ	ETF	66.63	66.63	66.59	66.59	2500.0
2013-01-16 07:00:00	QQQ	ETF	66.61	66.61	66.46	66.53	790770.0
2013-01-16 08:00:00	QQQ	ETF	66.54	66.65	66.48	66.59	1034559.0
2013-01-16 09:00:00	QQQ	ETF	66.59	66.83	66.59	66.8	3959776.0
2013-01-16 10:00:00	QQQ	ETF	66.79	67.0	66.74	66.815	6016119.0
2013-01-16 11:00:00	QQQ	ETF	66.81	66.98	66.8	66.91	1880006.0
2013-01-16 12:00:00	QQQ	ETF	66.9	66.9407	66.8	66.8201	2174016.0
2013-01-16 13:00:00	QQQ	ETF	66.83	67.01	66.82	66.99	2824612.0
2013-01-16 14:00:00	QQQ	ETF	66.99	67.13	66.93	67.11	2615968.0
2013-01-16 15:00:00	QQQ	ETF	67.1	67.11	66.89	66.9	5269432.0
2013-01-16 16:00:00	QQQ	ETF	66.89	67.094	66.6439	66.85	5871863.0
2013-01-16 17:00:00	QQQ	ETF	66.86	66.86	66.84	66.84	6627.0
2013-01-16 18:00:00	QQQ	ETF	66.85	66.87	66.82	66.82	5300.0
2013-01-16 19:00:00	QQQ	ETF	66.86	66.88	66.83	66.87	1740.0
2013-01-16 04:00:00	IWM	ETF	87.37	87.37	87.3	87.3	3044.0
2013-01-16 06:00:00	IWM	ETF	87.45	87.45	87.45	87.45	1200.0
2013-01-16 07:00:00	IWM	ETF	87.35	87.4	87.29	87.29	25690.0
2013-01-16 08:00:00	IWM	ETF	87.3	87.47	87.28	87.44	185586.0
2013-01-16 09:00:00	IWM	ETF	87.45	87.67	87.3	87.54	4939995.0
2013-01-16 10:00:00	IWM	ETF	87.55	87.6	87.39	87.4	2920754.0
2013-01-16 11:00:00	IWM	ETF	87.4	87.67	87.3801	87.51	2079748.0
2013-01-16 12:00:00	IWM	ETF	87.52	87.58	87.42	87.48	1410629.0
2013-01-16 13:00:00	IWM	ETF	87.49	87.69	87.42	87.605	1862810.0
2013-01-16 14:00:00	IWM	ETF	87.6	87.735	87.57	87.68	1797192.0
2013-01-16 15:00:00	IWM	ETF	87.69	87.75	87.51	87.51	3586890.0
2013-01-16 16:00:00	IWM	ETF	87.5	87.5759	87.385	87.44	725157.0
2013-01-16 17:00:00	IWM	ETF	87.44	87.45	87.41	87.41	31425.0
2013-01-16 18:00:00	IWM	ETF	87.41	87.41	87.41	87.41	965.0
2013-01-16 19:00:00	IWM	ETF	87.43	87.43	87.43	87.43	1700.0
2013-01-16 07:00:00	DIA	ETF	134.57	134.57	134.36	134.36	5744.0
2013-01-16 08:00:00	DIA	ETF	134.42	134.64	134.42	134.47	30518.0
2013-01-16 09:00:00	DIA	ETF	134.53	134.72	134.53	134.71	465460.0
2013-01-16 10:00:00	DIA	ETF	134.72	134.93	134.72	134.75	741120.0

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

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