PREVIEW / etf_1hour / 2014-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-09.parquet
  size:    221 KB
  rows:    7,015

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-09-09 04:00:00	SPY	ETF	200.57	200.72	200.43	200.43	1942.0
2014-09-09 05:00:00	SPY	ETF	200.45	200.56	200.4	200.56	8355.0
2014-09-09 06:00:00	SPY	ETF	200.59	200.75	200.56	200.74	22134.0
2014-09-09 07:00:00	SPY	ETF	200.69	200.9	200.69	200.74	172508.0
2014-09-09 08:00:00	SPY	ETF	200.73	200.74	200.46	200.55	429094.0
2014-09-09 09:00:00	SPY	ETF	200.55	200.56	199.76	199.78	9620391.0
2014-09-09 10:00:00	SPY	ETF	199.78	200.02	199.57	199.86	11855114.0
2014-09-09 11:00:00	SPY	ETF	199.86	200.19	199.8	200.005	6266021.0
2014-09-09 12:00:00	SPY	ETF	200.0	200.16	199.84	199.9	6380834.0
2014-09-09 13:00:00	SPY	ETF	199.9	200.55	199.66	200.45	9352698.0
2014-09-09 14:00:00	SPY	ETF	200.445	200.47	199.6	199.74	10990986.0
2014-09-09 15:00:00	SPY	ETF	199.74	199.74	198.91	199.33	26043015.0
2014-09-09 16:00:00	SPY	ETF	199.33	199.58	199.32	199.52	5490696.0
2014-09-09 17:00:00	SPY	ETF	199.52	199.57	199.51	199.55	63568.0
2014-09-09 18:00:00	SPY	ETF	199.55	199.57	199.48	199.5	27292.0
2014-09-09 19:00:00	SPY	ETF	199.51	199.51	199.3	199.34	57869.0
2014-09-09 04:00:00	QQQ	ETF	99.99	99.99	99.96	99.96	200.0
2014-09-09 06:00:00	QQQ	ETF	100.05	100.13	100.05	100.13	1100.0
2014-09-09 07:00:00	QQQ	ETF	100.14	100.23	100.14	100.19	38500.0
2014-09-09 08:00:00	QQQ	ETF	100.18	100.18	100.05	100.08	91945.0
2014-09-09 09:00:00	QQQ	ETF	100.1	100.1	99.7	99.76	3444481.0
2014-09-09 10:00:00	QQQ	ETF	99.751	99.95	99.69	99.73	3682099.0
2014-09-09 11:00:00	QQQ	ETF	99.73	99.94	99.68	99.86	1903297.0
2014-09-09 12:00:00	QQQ	ETF	99.85	99.99	99.79	99.89	1281297.0
2014-09-09 13:00:00	QQQ	ETF	99.89	100.46	99.54	100.38	6356242.0
2014-09-09 14:00:00	QQQ	ETF	100.39	100.44	99.52	99.65	6342691.0
2014-09-09 15:00:00	QQQ	ETF	99.66	99.6635	99.0645	99.26	9899926.0
2014-09-09 16:00:00	QQQ	ETF	99.26	100.0928	99.25	99.36	2135235.0
2014-09-09 17:00:00	QQQ	ETF	99.35	99.39	99.3	99.3	35356.0
2014-09-09 18:00:00	QQQ	ETF	99.35	99.38	99.32	99.32	44216.0
2014-09-09 19:00:00	QQQ	ETF	99.34	99.34	99.25	99.28	41708.0
2014-09-09 07:00:00	IWM	ETF	116.94	116.94	116.8	116.8	12000.0
2014-09-09 08:00:00	IWM	ETF	116.65	116.68	116.56	116.61	49512.0
2014-09-09 09:00:00	IWM	ETF	116.59	116.59	115.53	115.62	4818341.0
2014-09-09 10:00:00	IWM	ETF	115.63	115.94	115.42	115.62	5478128.0
2014-09-09 11:00:00	IWM	ETF	115.615	116.03	115.55	115.78	2446575.0
2014-09-09 12:00:00	IWM	ETF	115.78	115.87	115.53	115.5463	2185492.0
2014-09-09 13:00:00	IWM	ETF	115.54	116.01	115.44	115.91	2815173.0
2014-09-09 14:00:00	IWM	ETF	115.92	115.97	115.23	115.415	4022296.0
2014-09-09 15:00:00	IWM	ETF	115.405	115.42	115.0	115.18	6635618.0
2014-09-09 16:00:00	IWM	ETF	115.17	115.33	115.1623	115.19	2273957.0
2014-09-09 17:00:00	IWM	ETF	115.2	115.25	115.18	115.25	12070.0
2014-09-09 18:00:00	IWM	ETF	115.28	115.28	115.18	115.18	200.0
2014-09-09 19:00:00	IWM	ETF	115.1	115.1	115.1	115.1	100.0
2014-09-09 09:00:00	DIA	ETF	170.86	170.86	170.15	170.18	646382.0
2014-09-09 10:00:00	DIA	ETF	170.17	170.38	170.05	170.34	649333.0
2014-09-09 11:00:00	DIA	ETF	170.35	170.58	170.32	170.46	295224.0
2014-09-09 12:00:00	DIA	ETF	170.45	170.55	170.291	170.32	146497.0
2014-09-09 13:00:00	DIA	ETF	170.34	170.84	170.26	170.75	524222.0
2014-09-09 14:00:00	DIA	ETF	170.76	170.77	170.26	170.36	402640.0

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

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