PREVIEW / etf_1hour / 2013-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-18.parquet
  size:    211 KB
  rows:    6,665

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-10-18 04:00:00	SPY	ETF	173.47	173.6	173.46	173.47	22406.0
2013-10-18 05:00:00	SPY	ETF	173.49	173.53	173.37	173.49	35104.0
2013-10-18 06:00:00	SPY	ETF	173.49	173.55	173.39	173.39	110877.0
2013-10-18 07:00:00	SPY	ETF	173.41	173.69	173.39	173.69	341669.0
2013-10-18 08:00:00	SPY	ETF	173.44	173.85	173.44	173.75	830111.0
2013-10-18 09:00:00	SPY	ETF	173.75	174.06	173.52	174.001	24370582.0
2013-10-18 10:00:00	SPY	ETF	174.0	174.12	173.51	173.75	22761558.0
2013-10-18 11:00:00	SPY	ETF	173.751	174.04	173.67	173.82	11762656.0
2013-10-18 12:00:00	SPY	ETF	173.81	174.1	173.74	173.99	11501148.0
2013-10-18 13:00:00	SPY	ETF	174.0	174.44	173.993	174.42	11785443.0
2013-10-18 14:00:00	SPY	ETF	174.425	174.51	174.23	174.3401	16743647.0
2013-10-18 15:00:00	SPY	ETF	174.34	174.4	174.14	174.37	25771805.0
2013-10-18 16:00:00	SPY	ETF	174.37	174.411	173.2764	174.26	9592344.0
2013-10-18 17:00:00	SPY	ETF	174.38	174.38	174.17	174.24	212865.0
2013-10-18 18:00:00	SPY	ETF	174.21	174.22	174.1	174.22	14107.0
2013-10-18 19:00:00	SPY	ETF	174.21	174.33	174.21	174.3	31588.0
2013-10-18 04:00:00	QQQ	ETF	81.34	81.4	81.31	81.37	27492.0
2013-10-18 05:00:00	QQQ	ETF	81.38	81.41	81.33	81.39	14600.0
2013-10-18 06:00:00	QQQ	ETF	81.38	81.41	81.33	81.34	21500.0
2013-10-18 07:00:00	QQQ	ETF	81.35	81.45	81.35	81.45	41630.0
2013-10-18 08:00:00	QQQ	ETF	81.44	81.53	81.38	81.44	437050.0
2013-10-18 09:00:00	QQQ	ETF	81.45	81.74	81.35	81.72	5613819.0
2013-10-18 10:00:00	QQQ	ETF	81.71	81.86	81.6	81.72	6631346.0
2013-10-18 11:00:00	QQQ	ETF	81.7201	81.81	81.64	81.68	2600350.0
2013-10-18 12:00:00	QQQ	ETF	81.67	81.8899	81.65	81.85	2029818.0
2013-10-18 13:00:00	QQQ	ETF	81.86	82.11	81.851	82.085	2622804.0
2013-10-18 14:00:00	QQQ	ETF	82.089	82.18	81.97	82.13	3201750.0
2013-10-18 15:00:00	QQQ	ETF	82.1201	82.16	81.97	82.15	6240226.0
2013-10-18 16:00:00	QQQ	ETF	82.14	82.1599	80.8565	82.12	5345689.0
2013-10-18 17:00:00	QQQ	ETF	82.12	82.13	82.06	82.06	71858.0
2013-10-18 18:00:00	QQQ	ETF	82.02	82.05	81.97	82.05	10202.0
2013-10-18 19:00:00	QQQ	ETF	82.05	82.08	82.04	82.08	10829.0
2013-10-18 07:00:00	IWM	ETF	109.88	110.0	109.88	110.0	52939.0
2013-10-18 08:00:00	IWM	ETF	109.98	110.09	109.91	109.96	209278.0
2013-10-18 09:00:00	IWM	ETF	109.99	110.36	109.83	110.33	6781534.0
2013-10-18 10:00:00	IWM	ETF	110.33	110.42	109.85	110.015	5879082.0
2013-10-18 11:00:00	IWM	ETF	110.01	110.32	109.93	110.07	3001400.0
2013-10-18 12:00:00	IWM	ETF	110.07	110.29	110.01	110.22	2132343.0
2013-10-18 13:00:00	IWM	ETF	110.23	110.54	110.23	110.502	2538764.0
2013-10-18 14:00:00	IWM	ETF	110.505	110.56	110.43	110.47	4360009.0
2013-10-18 15:00:00	IWM	ETF	110.4799	110.77	110.285	110.66	8492913.0
2013-10-18 16:00:00	IWM	ETF	110.65	110.71	110.2695	110.7	1289119.0
2013-10-18 17:00:00	IWM	ETF	110.7	110.74	110.61	110.63	20499.0
2013-10-18 18:00:00	IWM	ETF	110.61	110.7	110.61	110.7	1300.0
2013-10-18 19:00:00	IWM	ETF	110.65	110.69	110.65	110.69	200.0
2013-10-18 07:00:00	DIA	ETF	153.49	153.51	153.49	153.51	2200.0
2013-10-18 08:00:00	DIA	ETF	153.5	153.69	153.5	153.6	14329.0
2013-10-18 09:00:00	DIA	ETF	153.6	153.71	152.8946	153.45	1282342.0
2013-10-18 10:00:00	DIA	ETF	153.44	153.54	152.94	153.19	1073076.0
2013-10-18 11:00:00	DIA	ETF	153.21	153.45	153.12	153.16	832653.0

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

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