PREVIEW / etf_1hour / 2015-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-29.parquet
  size:    242 KB
  rows:    7,660

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
2015-07-29 04:00:00	SPY	ETF	209.58	209.65	209.3	209.63	29588.0
2015-07-29 05:00:00	SPY	ETF	209.7	209.95	209.55	209.87	138733.0
2015-07-29 06:00:00	SPY	ETF	209.84	209.88	209.6	209.79	22779.0
2015-07-29 07:00:00	SPY	ETF	209.79	210.02	209.72	209.85	281805.0
2015-07-29 08:00:00	SPY	ETF	209.85	209.95	209.12	209.3	704053.0
2015-07-29 09:00:00	SPY	ETF	209.31	209.78	209.31	209.64	8657227.0
2015-07-29 10:00:00	SPY	ETF	209.63	210.25	209.43	210.09	14157462.0
2015-07-29 11:00:00	SPY	ETF	210.09	210.5	209.92	210.445	10844958.0
2015-07-29 12:00:00	SPY	ETF	210.44	210.47	210.1	210.239	6658774.0
2015-07-29 13:00:00	SPY	ETF	210.23	210.33	210.13	210.17	6402847.0
2015-07-29 14:00:00	SPY	ETF	210.18	211.04	209.79	210.9	24783419.0
2015-07-29 15:00:00	SPY	ETF	210.905	210.95	210.51	210.74	23522056.0
2015-07-29 16:00:00	SPY	ETF	210.74	210.9	210.62	210.65	6948860.0
2015-07-29 17:00:00	SPY	ETF	210.66	210.74	210.59	210.59	647582.0
2015-07-29 18:00:00	SPY	ETF	210.58	210.58	210.42	210.43	232184.0
2015-07-29 19:00:00	SPY	ETF	210.5	210.54	210.44	210.53	83615.0
2015-07-29 04:00:00	QQQ	ETF	111.34	111.34	111.33	111.33	1650.0
2015-07-29 05:00:00	QQQ	ETF	111.44	111.49	111.44	111.49	65100.0
2015-07-29 06:00:00	QQQ	ETF	111.52	111.52	111.4	111.4	8300.0
2015-07-29 07:00:00	QQQ	ETF	111.5	111.6	111.41	111.47	29225.0
2015-07-29 08:00:00	QQQ	ETF	111.59	111.59	111.22	111.23	205618.0
2015-07-29 09:00:00	QQQ	ETF	111.22	111.53	111.06	111.15	3023680.0
2015-07-29 10:00:00	QQQ	ETF	111.14	111.465	110.94	111.35	3197205.0
2015-07-29 11:00:00	QQQ	ETF	111.34	111.5	111.22	111.45	1917128.0
2015-07-29 12:00:00	QQQ	ETF	111.45	111.48	111.22	111.3201	1559753.0
2015-07-29 13:00:00	QQQ	ETF	111.33	111.38	111.19	111.25	1677428.0
2015-07-29 14:00:00	QQQ	ETF	111.242	111.79	111.06	111.69	4656152.0
2015-07-29 15:00:00	QQQ	ETF	111.69	111.77	111.5	111.58	4906634.0
2015-07-29 16:00:00	QQQ	ETF	111.58	111.62	111.3	111.55	1271687.0
2015-07-29 17:00:00	QQQ	ETF	111.43	111.6	111.39	111.4	26048.0
2015-07-29 18:00:00	QQQ	ETF	111.37	111.39	111.32	111.33	46210.0
2015-07-29 19:00:00	QQQ	ETF	111.33	111.36	111.33	111.35	4835.0
2015-07-29 07:00:00	IWM	ETF	121.99	121.99	121.73	121.73	5194.0
2015-07-29 08:00:00	IWM	ETF	121.72	121.75	121.29	121.29	40757.0
2015-07-29 09:00:00	IWM	ETF	121.3	121.58	120.97	121.32	3263202.0
2015-07-29 10:00:00	IWM	ETF	121.32	121.89	121.16	121.6999	3883408.0
2015-07-29 11:00:00	IWM	ETF	121.69	122.015	121.55	121.94	2212188.0
2015-07-29 12:00:00	IWM	ETF	121.945	122.04	121.72	121.82	1424249.0
2015-07-29 13:00:00	IWM	ETF	121.82	121.905	121.71	121.81	925428.0
2015-07-29 14:00:00	IWM	ETF	121.835	122.23	121.55	122.169	4092624.0
2015-07-29 15:00:00	IWM	ETF	122.17	122.33	121.91	121.93	5000912.0
2015-07-29 16:00:00	IWM	ETF	121.93	121.94	120.9667	121.77	3036705.0
2015-07-29 17:00:00	IWM	ETF	121.92	121.94	121.82	121.82	62970.0
2015-07-29 18:00:00	IWM	ETF	121.67	121.72	121.66	121.72	2000.0
2015-07-29 07:00:00	DIA	ETF	176.5	176.5	176.5	176.5	600.0
2015-07-29 08:00:00	DIA	ETF	176.62	176.62	176.13	176.13	2039.0
2015-07-29 09:00:00	DIA	ETF	176.26	176.55	176.17	176.41	438608.0
2015-07-29 10:00:00	DIA	ETF	176.41	176.98	176.27	176.88	558107.0
2015-07-29 11:00:00	DIA	ETF	176.85	177.25	176.76	177.21	432146.0
2015-07-29 12:00:00	DIA	ETF	177.22	177.23	176.98	177.06	305465.0

> showing 50 of 7,660 rows — these rows as CSV

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