PREVIEW / etf_1hour / 2013-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-07.parquet
  size:    214 KB
  rows:    6,721

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-11-07 04:00:00	SPY	ETF	176.93	176.93	176.77	176.88	42827.0
2013-11-07 05:00:00	SPY	ETF	176.85	176.93	176.79	176.79	38072.0
2013-11-07 06:00:00	SPY	ETF	176.79	176.83	176.75	176.83	23757.0
2013-11-07 07:00:00	SPY	ETF	176.81	177.93	176.8	177.72	1251795.0
2013-11-07 08:00:00	SPY	ETF	177.7	177.95	176.98	177.64	2314370.0
2013-11-07 09:00:00	SPY	ETF	177.64	177.68	177.11	177.17	11748480.0
2013-11-07 10:00:00	SPY	ETF	177.16	177.25	176.15	176.2972	27659790.0
2013-11-07 11:00:00	SPY	ETF	176.29	176.46	175.72	176.39	17758659.0
2013-11-07 12:00:00	SPY	ETF	176.39	176.66	176.21	176.22	8847468.0
2013-11-07 13:00:00	SPY	ETF	176.23	176.3	175.6	175.69	11323809.0
2013-11-07 14:00:00	SPY	ETF	175.69	175.7	175.05	175.53	21575123.0
2013-11-07 15:00:00	SPY	ETF	175.535	175.59	174.76	174.94	34439246.0
2013-11-07 16:00:00	SPY	ETF	174.95	177.2009	174.8712	175.05	10007759.0
2013-11-07 17:00:00	SPY	ETF	175.05	175.08	174.9	174.98	7258185.0
2013-11-07 18:00:00	SPY	ETF	174.99	175.08	174.86	175.06	153904.0
2013-11-07 19:00:00	SPY	ETF	175.08	175.34	175.06	175.25	644488.0
2013-11-07 04:00:00	QQQ	ETF	82.83	82.83	82.76	82.77	12400.0
2013-11-07 05:00:00	QQQ	ETF	82.78	82.82	82.75	82.75	9400.0
2013-11-07 07:00:00	QQQ	ETF	82.75	83.11	82.75	83.06	189825.0
2013-11-07 08:00:00	QQQ	ETF	83.05	83.14	82.76	83.0	842137.0
2013-11-07 09:00:00	QQQ	ETF	83.01	83.13	82.67	82.71	4222020.0
2013-11-07 10:00:00	QQQ	ETF	82.7	82.77	81.97	82.14	13431770.0
2013-11-07 11:00:00	QQQ	ETF	82.15	82.24	81.83	82.1256	5677298.0
2013-11-07 12:00:00	QQQ	ETF	82.13	82.28	82.08	82.08	3161115.0
2013-11-07 13:00:00	QQQ	ETF	82.08	82.15	81.82	81.89	3076220.0
2013-11-07 14:00:00	QQQ	ETF	81.89	81.9	81.59	81.81	5874480.0
2013-11-07 15:00:00	QQQ	ETF	81.811	81.83	81.37	81.44	9450904.0
2013-11-07 16:00:00	QQQ	ETF	81.44	83.0131	81.42	81.6	2265477.0
2013-11-07 17:00:00	QQQ	ETF	81.56	81.56	81.48	81.5	6779.0
2013-11-07 18:00:00	QQQ	ETF	81.52	81.53	81.46	81.5	63864.0
2013-11-07 19:00:00	QQQ	ETF	81.58	81.64	81.58	81.6	61110.0
2013-11-07 07:00:00	IWM	ETF	109.09	109.87	109.09	109.77	200194.0
2013-11-07 08:00:00	IWM	ETF	109.75	109.87	109.46	109.71	717258.0
2013-11-07 09:00:00	IWM	ETF	109.69	109.81	109.05	109.11	5126661.0
2013-11-07 10:00:00	IWM	ETF	109.1	109.22	107.882	108.25	12812536.0
2013-11-07 11:00:00	IWM	ETF	108.25	108.33	107.73	108.18	7570064.0
2013-11-07 12:00:00	IWM	ETF	108.18	108.59	108.17	108.2	4434082.0
2013-11-07 13:00:00	IWM	ETF	108.19	108.25	107.73	107.87	3799400.0
2013-11-07 14:00:00	IWM	ETF	107.87	107.88	107.34	107.56	8051253.0
2013-11-07 15:00:00	IWM	ETF	107.561	107.73	107.14	107.26	10664005.0
2013-11-07 16:00:00	IWM	ETF	107.25	109.1454	107.16	107.32	2405272.0
2013-11-07 17:00:00	IWM	ETF	107.34	107.37	107.28	107.3	34082.0
2013-11-07 18:00:00	IWM	ETF	107.3	107.3	107.25	107.29	3164.0
2013-11-07 19:00:00	IWM	ETF	107.38	107.5	107.32	107.5	5113.0
2013-11-07 07:00:00	DIA	ETF	157.16	158.08	157.13	157.82	12562.0
2013-11-07 08:00:00	DIA	ETF	157.82	158.0	157.74	157.78	81610.0
2013-11-07 09:00:00	DIA	ETF	157.78	157.83	157.47	157.52	1060323.0
2013-11-07 10:00:00	DIA	ETF	157.52	157.6201	156.82	156.92	2484844.0
2013-11-07 11:00:00	DIA	ETF	156.95	157.05	156.43	156.98	1280679.0
2013-11-07 12:00:00	DIA	ETF	156.98	157.16	156.81	156.82	608445.0

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

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