PREVIEW / etf_1hour / 2013-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-04.parquet
  size:    214 KB
  rows:    6,712

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-12-04 04:00:00	SPY	ETF	179.99	180.08	179.92	179.97	7892.0
2013-12-04 05:00:00	SPY	ETF	179.97	179.97	179.75	179.79	9143.0
2013-12-04 06:00:00	SPY	ETF	179.81	179.86	179.69	179.72	17098.0
2013-12-04 07:00:00	SPY	ETF	179.69	179.76	179.34	179.4	262611.0
2013-12-04 08:00:00	SPY	ETF	179.41	179.95	179.08	179.33	1391913.0
2013-12-04 09:00:00	SPY	ETF	179.33	179.45	179.03	179.32	12834035.0
2013-12-04 10:00:00	SPY	ETF	179.32	180.48	179.3	180.418	21992425.0
2013-12-04 11:00:00	SPY	ETF	180.41	180.41	179.88	179.99	9184593.0
2013-12-04 12:00:00	SPY	ETF	179.98	179.99	179.29	179.52	13273889.0
2013-12-04 13:00:00	SPY	ETF	179.52	179.69	178.35	178.79	19335383.0
2013-12-04 14:00:00	SPY	ETF	178.78	179.45	178.73	179.385	12540173.0
2013-12-04 15:00:00	SPY	ETF	179.38	180.13	179.22	179.7	20254931.0
2013-12-04 16:00:00	SPY	ETF	179.68	179.9784	179.5659	179.83	9203725.0
2013-12-04 17:00:00	SPY	ETF	179.8	179.8	179.75	179.78	115919.0
2013-12-04 18:00:00	SPY	ETF	179.79	179.79	179.74	179.76	6640.0
2013-12-04 19:00:00	SPY	ETF	179.77	179.8	179.73	179.76	75781.0
2013-12-04 04:00:00	QQQ	ETF	85.47	85.54	85.47	85.54	140615.0
2013-12-04 05:00:00	QQQ	ETF	85.5	85.5	85.44	85.44	3500.0
2013-12-04 06:00:00	QQQ	ETF	85.44	85.47	85.4	85.41	5300.0
2013-12-04 07:00:00	QQQ	ETF	85.38	85.38	85.22	85.22	17800.0
2013-12-04 08:00:00	QQQ	ETF	85.24	85.27	85.13	85.16	123590.0
2013-12-04 09:00:00	QQQ	ETF	85.19	85.32	85.0	85.26	3962391.0
2013-12-04 10:00:00	QQQ	ETF	85.26	85.77	85.25	85.77	7546360.0
2013-12-04 11:00:00	QQQ	ETF	85.765	85.765	85.48	85.51	2149824.0
2013-12-04 12:00:00	QQQ	ETF	85.51	85.51	85.2	85.36	3920026.0
2013-12-04 13:00:00	QQQ	ETF	85.36	85.44	84.78	84.98	6562195.0
2013-12-04 14:00:00	QQQ	ETF	84.98	85.35	84.96	85.29	4458761.0
2013-12-04 15:00:00	QQQ	ETF	85.29	85.6975	85.2	85.5	6289031.0
2013-12-04 16:00:00	QQQ	ETF	85.5	85.55	85.296	85.51	1010021.0
2013-12-04 17:00:00	QQQ	ETF	85.52	85.52	85.49	85.51	90900.0
2013-12-04 18:00:00	QQQ	ETF	85.47	85.49	85.47	85.47	4050.0
2013-12-04 19:00:00	QQQ	ETF	85.48	85.48	85.44	85.48	14300.0
2013-12-04 07:00:00	IWM	ETF	111.67	111.7	111.44	111.44	45673.0
2013-12-04 08:00:00	IWM	ETF	111.47	111.55	111.26	111.48	69492.0
2013-12-04 09:00:00	IWM	ETF	111.47	111.6	111.26	111.45	3212289.0
2013-12-04 10:00:00	IWM	ETF	111.45	112.42	111.43	112.34	7334747.0
2013-12-04 11:00:00	IWM	ETF	112.34	112.34	111.95	111.99	3416838.0
2013-12-04 12:00:00	IWM	ETF	111.98	112.0	111.31	111.36	4546993.0
2013-12-04 13:00:00	IWM	ETF	111.36	111.54	110.37	110.84	6790573.0
2013-12-04 14:00:00	IWM	ETF	110.84	111.53	110.79	111.46	3767511.0
2013-12-04 15:00:00	IWM	ETF	111.45	111.91	111.34	111.5	5772499.0
2013-12-04 16:00:00	IWM	ETF	111.5	111.5776	111.1347	111.56	696501.0
2013-12-04 17:00:00	IWM	ETF	111.56	111.58	111.54	111.54	4700.0
2013-12-04 18:00:00	IWM	ETF	111.59	111.59	111.56	111.56	200.0
2013-12-04 06:00:00	DIA	ETF	158.99	158.99	158.99	158.99	1900.0
2013-12-04 08:00:00	DIA	ETF	158.69	158.76	158.54	158.67	22429.0
2013-12-04 09:00:00	DIA	ETF	158.67	158.705	158.37	158.53	800764.0
2013-12-04 10:00:00	DIA	ETF	158.52	159.52	158.52	159.52	1212847.0
2013-12-04 11:00:00	DIA	ETF	159.51	159.51	158.94	159.04	583293.0
2013-12-04 12:00:00	DIA	ETF	159.03	159.04	158.53	158.69	593436.0

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

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