PREVIEW / etf_1hour / 2014-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-02.parquet
  size:    225 KB
  rows:    7,097

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-02 04:00:00	SPY	ETF	184.84	184.84	183.88	184.15	22981.0
2014-01-02 05:00:00	SPY	ETF	184.0	184.25	183.92	184.01	86130.0
2014-01-02 06:00:00	SPY	ETF	184.11	184.31	183.75	184.12	366352.0
2014-01-02 07:00:00	SPY	ETF	184.11	184.15	183.82	183.85	363661.0
2014-01-02 08:00:00	SPY	ETF	183.855	184.17	183.82	183.93	684418.0
2014-01-02 09:00:00	SPY	ETF	183.89	184.67	183.29	183.559	19400807.0
2014-01-02 10:00:00	SPY	ETF	183.55	183.91	183.12	183.47	28671018.0
2014-01-02 11:00:00	SPY	ETF	183.48	183.61	182.86	183.02	15119685.0
2014-01-02 12:00:00	SPY	ETF	183.02	183.135	182.74	183.01	9997147.0
2014-01-02 13:00:00	SPY	ETF	183.01	183.09	182.73	182.969	8604180.0
2014-01-02 14:00:00	SPY	ETF	182.965	183.09	182.48	182.761	11192924.0
2014-01-02 15:00:00	SPY	ETF	182.76	183.2	182.74	182.95	17784738.0
2014-01-02 16:00:00	SPY	ETF	182.95	184.5679	182.92	182.98	5867074.0
2014-01-02 17:00:00	SPY	ETF	182.98	183.0	182.93	183.0	63431.0
2014-01-02 18:00:00	SPY	ETF	183.01	183.07	182.99	183.07	120093.0
2014-01-02 19:00:00	SPY	ETF	183.08	183.1	183.02	183.09	99600.0
2014-01-02 04:00:00	QQQ	ETF	88.0	88.0	87.63	87.83	5299.0
2014-01-02 05:00:00	QQQ	ETF	87.8	87.82	87.73	87.76	5700.0
2014-01-02 06:00:00	QQQ	ETF	87.63	87.65	87.5	87.65	21700.0
2014-01-02 07:00:00	QQQ	ETF	87.6	87.64	87.53	87.53	179054.0
2014-01-02 08:00:00	QQQ	ETF	87.54	87.67	87.52	87.55	192160.0
2014-01-02 09:00:00	QQQ	ETF	87.96	87.96	87.15	87.19	8374470.0
2014-01-02 10:00:00	QQQ	ETF	87.18	87.4	87.08	87.31	4410595.0
2014-01-02 11:00:00	QQQ	ETF	87.31	87.45	87.1399	87.19	3343804.0
2014-01-02 12:00:00	QQQ	ETF	87.185	87.295	87.13	87.2858	1681650.0
2014-01-02 13:00:00	QQQ	ETF	87.29	87.3	87.07	87.25	2202543.0
2014-01-02 14:00:00	QQQ	ETF	87.25	87.28	87.02	87.14	2363762.0
2014-01-02 15:00:00	QQQ	ETF	87.145	87.33	87.1401	87.28	4837686.0
2014-01-02 16:00:00	QQQ	ETF	87.28	87.3538	87.2595	87.29	987944.0
2014-01-02 17:00:00	QQQ	ETF	87.31	87.33	87.31	87.33	2350.0
2014-01-02 18:00:00	QQQ	ETF	87.3	87.33	87.29	87.3	10900.0
2014-01-02 19:00:00	QQQ	ETF	87.28	87.31	87.28	87.3	1300.0
2014-01-02 07:00:00	IWM	ETF	114.98	115.08	114.79	114.79	62010.0
2014-01-02 08:00:00	IWM	ETF	114.8	114.97	114.78	114.81	82261.0
2014-01-02 09:00:00	IWM	ETF	114.83	115.31	114.1225	114.41	6974377.0
2014-01-02 10:00:00	IWM	ETF	114.42	114.74	114.09	114.48	7225196.0
2014-01-02 11:00:00	IWM	ETF	114.48	114.495	113.66	113.71	7804728.0
2014-01-02 12:00:00	IWM	ETF	113.71	113.96	113.69	113.78	3636721.0
2014-01-02 13:00:00	IWM	ETF	113.78	113.91	113.64	113.9	1894374.0
2014-01-02 14:00:00	IWM	ETF	113.9	114.1	113.6425	113.92	3667109.0
2014-01-02 15:00:00	IWM	ETF	113.92	114.21	113.901	114.12	6931149.0
2014-01-02 16:00:00	IWM	ETF	114.12	114.32	114.11	114.31	1499315.0
2014-01-02 17:00:00	IWM	ETF	114.31	114.33	114.31	114.33	20345.0
2014-01-02 18:00:00	IWM	ETF	114.33	114.33	114.33	114.33	200.0
2014-01-02 19:00:00	IWM	ETF	114.35	114.35	114.35	114.35	100.0
2014-01-02 06:00:00	DIA	ETF	164.11	164.11	164.11	164.11	100.0
2014-01-02 07:00:00	DIA	ETF	164.57	164.9	164.57	164.88	1700.0
2014-01-02 08:00:00	DIA	ETF	164.75	165.0	164.74	164.74	35750.0
2014-01-02 09:00:00	DIA	ETF	164.761	165.01	164.36	164.64	2420429.0
2014-01-02 10:00:00	DIA	ETF	164.62	164.76	164.19	164.545	1325000.0

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

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