PREVIEW / etf_1hour / 2014-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-13.parquet
  size:    223 KB
  rows:    6,990

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-01-13 04:00:00	SPY	ETF	183.8	183.84	183.61	183.84	37155.0
2014-01-13 05:00:00	SPY	ETF	183.81	183.81	183.63	183.71	15695.0
2014-01-13 06:00:00	SPY	ETF	183.68	183.69	183.42	183.51	40209.0
2014-01-13 07:00:00	SPY	ETF	183.54	183.76	183.5	183.71	231369.0
2014-01-13 08:00:00	SPY	ETF	183.74	183.77	183.49	183.61	661113.0
2014-01-13 09:00:00	SPY	ETF	183.62	184.0	183.53	183.78	9425367.0
2014-01-13 10:00:00	SPY	ETF	183.78	184.18	183.78	184.01	10230883.0
2014-01-13 11:00:00	SPY	ETF	184.01	184.02	183.79	183.92	7488654.0
2014-01-13 12:00:00	SPY	ETF	183.915	183.94	182.96	182.96	13830219.0
2014-01-13 13:00:00	SPY	ETF	182.96	183.0299	182.54	182.79	17580730.0
2014-01-13 14:00:00	SPY	ETF	182.78	182.82	181.96	182.09	21215259.0
2014-01-13 15:00:00	SPY	ETF	182.09	182.09	181.34	181.72	43771255.0
2014-01-13 16:00:00	SPY	ETF	181.71	184.0539	181.63	181.84	19791017.0
2014-01-13 17:00:00	SPY	ETF	181.85	181.93	181.79	181.88	2282622.0
2014-01-13 18:00:00	SPY	ETF	181.88	181.97	181.88	181.94	269624.0
2014-01-13 19:00:00	SPY	ETF	181.96	181.99	181.91	181.93	81732.0
2014-01-13 04:00:00	QQQ	ETF	87.15	87.15	87.15	87.15	400.0
2014-01-13 05:00:00	QQQ	ETF	87.17	87.17	87.14	87.16	400.0
2014-01-13 06:00:00	QQQ	ETF	87.12	87.12	87.02	87.07	4200.0
2014-01-13 07:00:00	QQQ	ETF	87.09	87.21	87.08	87.21	3600.0
2014-01-13 08:00:00	QQQ	ETF	87.26	87.26	87.15	87.16	56200.0
2014-01-13 09:00:00	QQQ	ETF	87.17	87.35	87.08	87.24	3403174.0
2014-01-13 10:00:00	QQQ	ETF	87.24	87.48	87.24	87.45	3690315.0
2014-01-13 11:00:00	QQQ	ETF	87.45	87.47	87.35	87.435	2059936.0
2014-01-13 12:00:00	QQQ	ETF	87.43	87.44	86.91	86.92	4233868.0
2014-01-13 13:00:00	QQQ	ETF	86.92	86.92	86.61	86.72	4380106.0
2014-01-13 14:00:00	QQQ	ETF	86.715	86.75	86.15	86.22	6006509.0
2014-01-13 15:00:00	QQQ	ETF	86.22	86.22	85.675	86.02	13384528.0
2014-01-13 16:00:00	QQQ	ETF	86.02	87.326	85.98	86.08	8924844.0
2014-01-13 17:00:00	QQQ	ETF	86.09	86.14	86.08	86.1	8710.0
2014-01-13 18:00:00	QQQ	ETF	86.1	86.13	86.1	86.1	4120.0
2014-01-13 19:00:00	QQQ	ETF	86.13	86.13	86.1	86.11	4200.0
2014-01-13 07:00:00	IWM	ETF	115.36	115.36	115.19	115.22	10800.0
2014-01-13 08:00:00	IWM	ETF	115.22	115.24	115.11	115.11	34245.0
2014-01-13 09:00:00	IWM	ETF	115.11	115.49	114.9	115.07	3803631.0
2014-01-13 10:00:00	IWM	ETF	115.085	115.47	115.0805	115.39	3290256.0
2014-01-13 11:00:00	IWM	ETF	115.38	115.43	115.19	115.32	2458046.0
2014-01-13 12:00:00	IWM	ETF	115.32	115.36	114.74	114.745	3937672.0
2014-01-13 13:00:00	IWM	ETF	114.7401	114.75	114.35	114.48	4899814.0
2014-01-13 14:00:00	IWM	ETF	114.48	114.51	113.83	113.95	7584877.0
2014-01-13 15:00:00	IWM	ETF	113.95	114.0	113.2606	113.99	12786121.0
2014-01-13 16:00:00	IWM	ETF	113.99	114.14	113.94	114.06	1079958.0
2014-01-13 17:00:00	IWM	ETF	114.09	114.1	113.96	113.96	6850.0
2014-01-13 18:00:00	IWM	ETF	114.04	114.15	114.04	114.13	5455.0
2014-01-13 19:00:00	IWM	ETF	114.16	114.16	114.01	114.01	1416.0
2014-01-13 07:00:00	DIA	ETF	164.29	164.29	164.29	164.29	100.0
2014-01-13 08:00:00	DIA	ETF	164.0	164.02	164.0	164.02	1000.0
2014-01-13 09:00:00	DIA	ETF	163.94	164.03	163.78	163.93	695844.0
2014-01-13 10:00:00	DIA	ETF	163.94	164.28	163.94	164.02	761398.0
2014-01-13 11:00:00	DIA	ETF	164.02	164.03	163.8	163.94	652469.0

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

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