PREVIEW / etf_1hour / 2013-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-03.parquet
  size:    206 KB
  rows:    6,458

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-05-03 04:00:00	SPY	ETF	159.62	159.62	159.51	159.54	4960.0
2013-05-03 05:00:00	SPY	ETF	159.46	159.66	159.46	159.66	21729.0
2013-05-03 06:00:00	SPY	ETF	159.64	159.64	159.57	159.58	6200.0
2013-05-03 07:00:00	SPY	ETF	159.59	159.69	159.48	159.59	227600.0
2013-05-03 08:00:00	SPY	ETF	159.64	161.05	159.52	160.91	7265941.0
2013-05-03 09:00:00	SPY	ETF	160.92	161.66	160.92	161.44	23612424.0
2013-05-03 10:00:00	SPY	ETF	161.445	161.88	161.3	161.77	20654147.0
2013-05-03 11:00:00	SPY	ETF	161.77	161.88	161.57	161.601	13375104.0
2013-05-03 12:00:00	SPY	ETF	161.6	161.77	161.58	161.745	9792565.0
2013-05-03 13:00:00	SPY	ETF	161.74	161.8	161.51	161.5171	12381247.0
2013-05-03 14:00:00	SPY	ETF	161.53	161.62	161.33	161.415	10348590.0
2013-05-03 15:00:00	SPY	ETF	161.42	161.67	161.305	161.38	28693223.0
2013-05-03 16:00:00	SPY	ETF	161.37	161.5691	159.782	161.41	12415840.0
2013-05-03 17:00:00	SPY	ETF	161.41	161.45	161.35	161.42	2768105.0
2013-05-03 18:00:00	SPY	ETF	161.42	161.57	161.3	161.3	163396.0
2013-05-03 19:00:00	SPY	ETF	161.3	161.33	161.22	161.3	59586.0
2013-05-03 05:00:00	QQQ	ETF	71.21	71.23	71.21	71.23	200.0
2013-05-03 06:00:00	QQQ	ETF	71.23	71.23	71.23	71.23	200.0
2013-05-03 07:00:00	QQQ	ETF	71.26	71.26	71.22	71.22	8000.0
2013-05-03 08:00:00	QQQ	ETF	71.26	71.82	71.22	71.76	623762.0
2013-05-03 09:00:00	QQQ	ETF	71.77	72.26	71.77	72.19	5229215.0
2013-05-03 10:00:00	QQQ	ETF	72.19	72.32	72.1	72.23	5074928.0
2013-05-03 11:00:00	QQQ	ETF	72.24	72.2899	72.2	72.2201	3700070.0
2013-05-03 12:00:00	QQQ	ETF	72.222	72.27	72.2	72.27	2451299.0
2013-05-03 13:00:00	QQQ	ETF	72.27	72.34	72.16	72.18	4086123.0
2013-05-03 14:00:00	QQQ	ETF	72.18	72.23	72.1	72.14	2285124.0
2013-05-03 15:00:00	QQQ	ETF	72.139	72.21	72.07	72.13	5828722.0
2013-05-03 16:00:00	QQQ	ETF	72.125	72.2178	72.07	72.1	2426965.0
2013-05-03 17:00:00	QQQ	ETF	72.13	72.13	72.07	72.07	5305.0
2013-05-03 18:00:00	QQQ	ETF	72.13	72.17	72.12	72.15	301804.0
2013-05-03 19:00:00	QQQ	ETF	72.15	72.17	72.1	72.1	3139.0
2013-05-03 06:00:00	IWM	ETF	93.37	93.37	93.37	93.37	100.0
2013-05-03 07:00:00	IWM	ETF	93.19	93.23	93.17	93.2	19149.0
2013-05-03 08:00:00	IWM	ETF	93.2	94.37	93.19	94.25	1068229.0
2013-05-03 09:00:00	IWM	ETF	94.29	95.21	94.29	95.05	9105624.0
2013-05-03 10:00:00	IWM	ETF	95.06	95.47	94.93	95.265	10618631.0
2013-05-03 11:00:00	IWM	ETF	95.26	95.35	95.14	95.28	3886465.0
2013-05-03 12:00:00	IWM	ETF	95.28	95.35	95.24	95.26	1992189.0
2013-05-03 13:00:00	IWM	ETF	95.26	95.32	94.97	95.02	3851264.0
2013-05-03 14:00:00	IWM	ETF	95.02	95.11	94.8	94.93	3540067.0
2013-05-03 15:00:00	IWM	ETF	94.93	95.12	94.73	94.77	10526009.0
2013-05-03 16:00:00	IWM	ETF	94.76	94.9279	94.66	94.77	2403478.0
2013-05-03 17:00:00	IWM	ETF	94.72	94.73	94.67	94.73	620.0
2013-05-03 18:00:00	IWM	ETF	94.76	94.76	94.76	94.76	500.0
2013-05-03 19:00:00	IWM	ETF	94.75	94.76	94.72	94.72	834.0
2013-05-03 05:00:00	DIA	ETF	147.83	147.83	147.83	147.83	100.0
2013-05-03 06:00:00	DIA	ETF	147.85	147.85	147.85	147.85	100.0
2013-05-03 08:00:00	DIA	ETF	147.92	149.12	147.86	149.03	56672.0
2013-05-03 09:00:00	DIA	ETF	149.08	149.62	149.08	149.45	818325.0
2013-05-03 10:00:00	DIA	ETF	149.51	149.82	149.36	149.76	1206805.0

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

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