PREVIEW / etf_1hour / 2014-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-10.parquet
  size:    221 KB
  rows:    6,952

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-10 04:00:00	SPY	ETF	199.33	199.34	199.21	199.25	8052.0
2014-09-10 05:00:00	SPY	ETF	199.33	199.71	199.33	199.71	71849.0
2014-09-10 06:00:00	SPY	ETF	199.7	199.83	199.59	199.72	98244.0
2014-09-10 07:00:00	SPY	ETF	199.7	199.79	199.36	199.52	158931.0
2014-09-10 08:00:00	SPY	ETF	199.54	199.62	199.26	199.4	332533.0
2014-09-10 09:00:00	SPY	ETF	199.37	199.59	198.91	199.025	9976259.0
2014-09-10 10:00:00	SPY	ETF	199.03	199.29	198.77	198.97	12832417.0
2014-09-10 11:00:00	SPY	ETF	198.98	199.55	198.84	199.4599	8098420.0
2014-09-10 12:00:00	SPY	ETF	199.45	199.8	199.34	199.5999	6072881.0
2014-09-10 13:00:00	SPY	ETF	199.6	200.17	199.59	199.875	7613346.0
2014-09-10 14:00:00	SPY	ETF	199.88	200.04	199.72	199.8	5510614.0
2014-09-10 15:00:00	SPY	ETF	199.8	200.2	199.79	200.08	12428125.0
2014-09-10 16:00:00	SPY	ETF	200.1	200.14	200.06	200.14	2753867.0
2014-09-10 17:00:00	SPY	ETF	200.14	200.14	200.03	200.05	184729.0
2014-09-10 18:00:00	SPY	ETF	200.04	200.09	199.9	200.0	77517.0
2014-09-10 19:00:00	SPY	ETF	199.98	200.05	199.96	200.05	13536.0
2014-09-10 04:00:00	QQQ	ETF	99.15	99.15	99.15	99.15	5000.0
2014-09-10 05:00:00	QQQ	ETF	99.21	99.21	99.21	99.21	500.0
2014-09-10 06:00:00	QQQ	ETF	99.52	99.55	99.47	99.55	42629.0
2014-09-10 07:00:00	QQQ	ETF	99.52	99.53	99.32	99.37	80450.0
2014-09-10 08:00:00	QQQ	ETF	99.38	99.4	99.24	99.34	197126.0
2014-09-10 09:00:00	QQQ	ETF	99.32	99.57	99.17	99.25	5448561.0
2014-09-10 10:00:00	QQQ	ETF	99.25	99.47	99.1	99.3701	4795773.0
2014-09-10 11:00:00	QQQ	ETF	99.37	99.62	99.25	99.59	3186143.0
2014-09-10 12:00:00	QQQ	ETF	99.58	99.87	99.51	99.7807	2671301.0
2014-09-10 13:00:00	QQQ	ETF	99.79	100.067	99.79	99.9	3763822.0
2014-09-10 14:00:00	QQQ	ETF	99.9	99.9861	99.8	99.87	1995862.0
2014-09-10 15:00:00	QQQ	ETF	99.875	100.11	99.86	100.06	5493791.0
2014-09-10 16:00:00	QQQ	ETF	100.06	100.09	99.5787	100.06	2120672.0
2014-09-10 17:00:00	QQQ	ETF	100.04	100.09	100.04	100.07	75059.0
2014-09-10 18:00:00	QQQ	ETF	100.05	100.05	99.97	99.98	24859.0
2014-09-10 19:00:00	QQQ	ETF	99.99	100.03	99.98	100.02	10685.0
2014-09-10 04:00:00	IWM	ETF	114.93	114.93	114.93	114.93	100.0
2014-09-10 07:00:00	IWM	ETF	115.25	115.25	115.02	115.15	24100.0
2014-09-10 08:00:00	IWM	ETF	115.15	115.15	114.99	115.08	47056.0
2014-09-10 09:00:00	IWM	ETF	115.16	115.48	114.82	115.01	3218443.0
2014-09-10 10:00:00	IWM	ETF	115.01	115.24	114.71	114.88	3917724.0
2014-09-10 11:00:00	IWM	ETF	114.88	115.25	114.74	115.18	2902678.0
2014-09-10 12:00:00	IWM	ETF	115.18	115.53	115.05	115.435	1856883.0
2014-09-10 13:00:00	IWM	ETF	115.43	115.93	115.42	115.645	2974520.0
2014-09-10 14:00:00	IWM	ETF	115.66	115.73	115.49	115.545	1103255.0
2014-09-10 15:00:00	IWM	ETF	115.55	115.9	115.54	115.88	4727020.0
2014-09-10 16:00:00	IWM	ETF	115.88	115.89	115.5125	115.85	1198620.0
2014-09-10 17:00:00	IWM	ETF	115.85	116.3	115.85	115.85	1571.0
2014-09-10 19:00:00	IWM	ETF	115.96	115.96	115.96	115.96	288.0
2014-09-10 06:00:00	DIA	ETF	170.43	170.43	170.43	170.43	100.0
2014-09-10 07:00:00	DIA	ETF	170.4	170.4	170.33	170.33	350.0
2014-09-10 08:00:00	DIA	ETF	170.2	170.27	170.2	170.2	2450.0
2014-09-10 09:00:00	DIA	ETF	170.2	170.29	169.8	169.92	638833.0
2014-09-10 10:00:00	DIA	ETF	169.94	170.14	169.71	169.79	847574.0

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

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