PREVIEW / etf_1hour / 2014-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-04.parquet
  size:    231 KB
  rows:    7,324

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
2014-11-04 04:00:00	SPY	ETF	201.85	201.95	201.76	201.95	12305.0
2014-11-04 05:00:00	SPY	ETF	201.8	201.8	201.1	201.28	44243.0
2014-11-04 06:00:00	SPY	ETF	201.28	201.48	201.21	201.43	58846.0
2014-11-04 07:00:00	SPY	ETF	201.47	201.48	201.18	201.18	326410.0
2014-11-04 08:00:00	SPY	ETF	201.19	201.54	201.0	201.2	710895.0
2014-11-04 09:00:00	SPY	ETF	201.17	201.53	201.07	201.35	11224086.0
2014-11-04 10:00:00	SPY	ETF	201.35	201.6	200.28	200.31	17649506.0
2014-11-04 11:00:00	SPY	ETF	200.31	200.56	200.06	200.37	13500560.0
2014-11-04 12:00:00	SPY	ETF	200.36	201.21	200.35	201.05	9803871.0
2014-11-04 13:00:00	SPY	ETF	201.05	201.38	200.68	201.27	8476712.0
2014-11-04 14:00:00	SPY	ETF	201.275	201.39	200.84	201.24	8463713.0
2014-11-04 15:00:00	SPY	ETF	201.2399	201.3	200.92	201.11	14262341.0
2014-11-04 16:00:00	SPY	ETF	201.1	201.7456	200.88	201.12	7278251.0
2014-11-04 17:00:00	SPY	ETF	201.12	201.7456	201.09	201.13	585834.0
2014-11-04 18:00:00	SPY	ETF	201.1	201.13	200.94	200.96	144316.0
2014-11-04 19:00:00	SPY	ETF	200.99	201.22	200.96	201.17	97018.0
2014-11-04 04:00:00	QQQ	ETF	101.6	101.67	101.6	101.67	1000.0
2014-11-04 05:00:00	QQQ	ETF	101.62	101.62	101.4	101.46	54250.0
2014-11-04 06:00:00	QQQ	ETF	101.45	101.5	101.4	101.5	15225.0
2014-11-04 07:00:00	QQQ	ETF	101.5	101.5	101.28	101.29	71800.0
2014-11-04 08:00:00	QQQ	ETF	101.3	101.7	101.21	101.33	136638.0
2014-11-04 09:00:00	QQQ	ETF	101.32	101.56	101.21	101.505	2969095.0
2014-11-04 10:00:00	QQQ	ETF	101.505	101.6244	100.85	100.87	4329963.0
2014-11-04 11:00:00	QQQ	ETF	100.86	101.01	100.67	100.7766	3445710.0
2014-11-04 12:00:00	QQQ	ETF	100.7741	101.275	100.7741	101.1899	1697322.0
2014-11-04 13:00:00	QQQ	ETF	101.1801	101.39	101.0666	101.34	1593911.0
2014-11-04 14:00:00	QQQ	ETF	101.34	101.4	101.21	101.4	1642158.0
2014-11-04 15:00:00	QQQ	ETF	101.395	101.46	101.29	101.37	3319911.0
2014-11-04 16:00:00	QQQ	ETF	101.36	101.7078	101.0489	101.3	1183700.0
2014-11-04 17:00:00	QQQ	ETF	101.27	101.33	101.27	101.27	12036.0
2014-11-04 18:00:00	QQQ	ETF	101.26	101.26	101.18	101.21	25912.0
2014-11-04 19:00:00	QQQ	ETF	101.22	101.33	101.21	101.31	23488.0
2014-11-04 04:00:00	IWM	ETF	116.31	116.31	116.16	116.16	2500.0
2014-11-04 05:00:00	IWM	ETF	116.18	116.18	115.81	115.81	2900.0
2014-11-04 07:00:00	IWM	ETF	115.85	115.9	115.71	115.71	17250.0
2014-11-04 08:00:00	IWM	ETF	115.73	115.84	115.6	115.81	123832.0
2014-11-04 09:00:00	IWM	ETF	115.81	116.45	115.77	116.32	4181114.0
2014-11-04 10:00:00	IWM	ETF	116.33	116.5	115.39	115.3901	6329554.0
2014-11-04 11:00:00	IWM	ETF	115.4	115.71	115.28	115.56	4880786.0
2014-11-04 12:00:00	IWM	ETF	115.55	115.82	115.54	115.62	2282820.0
2014-11-04 13:00:00	IWM	ETF	115.62	115.86	115.33	115.8	2565790.0
2014-11-04 14:00:00	IWM	ETF	115.81	115.94	115.6	115.93	2764860.0
2014-11-04 15:00:00	IWM	ETF	115.93	116.01	115.745	115.8	3871963.0
2014-11-04 16:00:00	IWM	ETF	115.81	115.89	115.68	115.83	741670.0
2014-11-04 17:00:00	IWM	ETF	115.83	115.85	115.7	115.76	36159.0
2014-11-04 18:00:00	IWM	ETF	115.74	115.89	115.74	115.87	2100.0
2014-11-04 19:00:00	IWM	ETF	115.87	115.9	115.82	115.82	2420.0
2014-11-04 08:00:00	DIA	ETF	173.0	173.0	172.89	172.9	11200.0
2014-11-04 09:00:00	DIA	ETF	172.9	173.39	172.9	173.36	680745.0
2014-11-04 10:00:00	DIA	ETF	173.34	173.59	172.62	172.66	1122022.0

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

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