PREVIEW / etf_1hour / 2014-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-25.parquet
  size:    218 KB
  rows:    6,936

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-08-25 04:00:00	SPY	ETF	199.9	200.12	199.9	199.94	14408.0
2014-08-25 05:00:00	SPY	ETF	199.94	199.98	199.86	199.9	2806.0
2014-08-25 06:00:00	SPY	ETF	199.96	200.02	199.89	200.02	14186.0
2014-08-25 07:00:00	SPY	ETF	199.97	200.13	199.91	200.13	212313.0
2014-08-25 08:00:00	SPY	ETF	200.06	200.2	199.96	200.2	633461.0
2014-08-25 09:00:00	SPY	ETF	200.19	200.33	199.91	200.27	7687096.0
2014-08-25 10:00:00	SPY	ETF	200.26	200.51	200.09	200.45	12355371.0
2014-08-25 11:00:00	SPY	ETF	200.46	200.5949	200.36	200.44	6984960.0
2014-08-25 12:00:00	SPY	ETF	200.445	200.47	199.94	200.02	8609203.0
2014-08-25 13:00:00	SPY	ETF	200.02	200.24	199.86	200.14	5017327.0
2014-08-25 14:00:00	SPY	ETF	200.15	200.18	199.98	200.14	4597695.0
2014-08-25 15:00:00	SPY	ETF	200.14	200.21	200.05	200.17	14043722.0
2014-08-25 16:00:00	SPY	ETF	200.17	200.2	200.03	200.04	2854769.0
2014-08-25 17:00:00	SPY	ETF	200.05	200.08	200.03	200.03	109129.0
2014-08-25 18:00:00	SPY	ETF	200.03	200.09	200.0	200.04	29833.0
2014-08-25 19:00:00	SPY	ETF	200.08	200.11	200.08	200.1	28515.0
2014-08-25 04:00:00	QQQ	ETF	99.53	99.53	99.53	99.53	100.0
2014-08-25 06:00:00	QQQ	ETF	99.44	99.51	99.44	99.51	1300.0
2014-08-25 07:00:00	QQQ	ETF	99.47	99.57	99.44	99.54	87140.0
2014-08-25 08:00:00	QQQ	ETF	99.54	99.55	99.47	99.55	236337.0
2014-08-25 09:00:00	QQQ	ETF	99.54	99.61	99.48	99.59	2386541.0
2014-08-25 10:00:00	QQQ	ETF	99.58	99.68	99.48	99.62	3329950.0
2014-08-25 11:00:00	QQQ	ETF	99.625	99.64	99.54	99.5964	1908896.0
2014-08-25 12:00:00	QQQ	ETF	99.6	99.61	99.22	99.31	2859726.0
2014-08-25 13:00:00	QQQ	ETF	99.31	99.46	99.16	99.38	2228252.0
2014-08-25 14:00:00	QQQ	ETF	99.38	99.4	99.28	99.37	1696429.0
2014-08-25 15:00:00	QQQ	ETF	99.37	99.48	99.35	99.39	4095462.0
2014-08-25 16:00:00	QQQ	ETF	99.4	99.5206	99.0341	99.32	2543094.0
2014-08-25 17:00:00	QQQ	ETF	99.32	99.37	99.32	99.35	6600.0
2014-08-25 18:00:00	QQQ	ETF	99.35	99.37	99.31	99.33	9538.0
2014-08-25 19:00:00	QQQ	ETF	99.37	99.37	99.37	99.37	1000.0
2014-08-25 04:00:00	IWM	ETF	115.96	116.12	115.96	116.12	485.0
2014-08-25 06:00:00	IWM	ETF	116.0	116.05	116.0	116.05	200.0
2014-08-25 07:00:00	IWM	ETF	116.1	116.12	116.09	116.12	20300.0
2014-08-25 08:00:00	IWM	ETF	116.08	116.17	116.05	116.06	114723.0
2014-08-25 09:00:00	IWM	ETF	116.06	116.29	115.67	116.28	3790378.0
2014-08-25 10:00:00	IWM	ETF	116.269	116.41	116.0419	116.26	3323595.0
2014-08-25 11:00:00	IWM	ETF	116.27	116.35	116.01	116.12	3279559.0
2014-08-25 12:00:00	IWM	ETF	116.12	116.13	115.44	115.51	3092176.0
2014-08-25 13:00:00	IWM	ETF	115.5	115.85	115.32	115.73	2028029.0
2014-08-25 14:00:00	IWM	ETF	115.74	115.78	115.52	115.68	1688802.0
2014-08-25 15:00:00	IWM	ETF	115.68	115.86	115.65	115.74	3317819.0
2014-08-25 16:00:00	IWM	ETF	115.73	115.8548	115.62	115.7	796147.0
2014-08-25 17:00:00	IWM	ETF	115.62	115.63	115.62	115.63	307.0
2014-08-25 07:00:00	DIA	ETF	170.45	170.5	170.45	170.5	700.0
2014-08-25 08:00:00	DIA	ETF	170.29	170.6	170.29	170.6	5280.0
2014-08-25 09:00:00	DIA	ETF	170.6	170.85	170.44	170.79	571348.0
2014-08-25 10:00:00	DIA	ETF	170.83	171.0001	170.67	170.98	639218.0
2014-08-25 11:00:00	DIA	ETF	170.99	171.057	170.92	170.94	249276.0
2014-08-25 12:00:00	DIA	ETF	170.96	170.97	170.62	170.65	254620.0

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

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