PREVIEW / etf_1hour / 2014-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-03.parquet
  size:    214 KB
  rows:    6,744

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-03 04:00:00	SPY	ETF	182.88	183.03	182.78	183.03	30325.0
2014-01-03 05:00:00	SPY	ETF	183.13	183.13	183.07	183.07	4165.0
2014-01-03 06:00:00	SPY	ETF	183.02	183.13	183.02	183.02	11781.0
2014-01-03 07:00:00	SPY	ETF	183.03	183.33	183.03	183.28	139568.0
2014-01-03 08:00:00	SPY	ETF	183.24	183.48	183.08	183.28	873282.0
2014-01-03 09:00:00	SPY	ETF	183.3	183.53	183.1	183.455	7825496.0
2014-01-03 10:00:00	SPY	ETF	183.45	183.6	183.23	183.3518	9491414.0
2014-01-03 11:00:00	SPY	ETF	183.35	183.44	182.68	182.74	11196755.0
2014-01-03 12:00:00	SPY	ETF	182.735	183.0	182.63	182.87	9471373.0
2014-01-03 13:00:00	SPY	ETF	182.87	182.96	182.69	182.83	5378369.0
2014-01-03 14:00:00	SPY	ETF	182.83	183.32	182.8	183.2	9955585.0
2014-01-03 15:00:00	SPY	ETF	183.2	183.5	182.78	182.8	19161594.0
2014-01-03 16:00:00	SPY	ETF	182.8	183.1818	182.67	182.69	6964557.0
2014-01-03 17:00:00	SPY	ETF	182.67	183.1323	182.62	182.66	230875.0
2014-01-03 18:00:00	SPY	ETF	182.67	182.7	182.62	182.67	19492.0
2014-01-03 19:00:00	SPY	ETF	182.7	182.7	182.62	182.66	12399.0
2014-01-03 06:00:00	QQQ	ETF	87.28	87.28	87.27	87.28	2509.0
2014-01-03 07:00:00	QQQ	ETF	87.29	87.37	87.29	87.36	19900.0
2014-01-03 08:00:00	QQQ	ETF	87.38	87.43	87.15	87.33	85859.0
2014-01-03 09:00:00	QQQ	ETF	87.35	87.35	87.12	87.27	2866027.0
2014-01-03 10:00:00	QQQ	ETF	87.26	87.32	86.985	87.04	3151631.0
2014-01-03 11:00:00	QQQ	ETF	87.04	87.055	86.6228	86.65	5631428.0
2014-01-03 12:00:00	QQQ	ETF	86.65	87.2623	86.62	86.7101	2719299.0
2014-01-03 13:00:00	QQQ	ETF	86.71	86.76	86.66	86.73	1188752.0
2014-01-03 14:00:00	QQQ	ETF	86.74	86.955	86.7	86.89	2058944.0
2014-01-03 15:00:00	QQQ	ETF	86.89	86.96	86.63	86.64	5613870.0
2014-01-03 16:00:00	QQQ	ETF	86.64	87.2623	86.55	87.2623	3407573.0
2014-01-03 17:00:00	QQQ	ETF	87.2622	87.2623	86.54	86.6	3037855.0
2014-01-03 18:00:00	QQQ	ETF	86.62	86.63	86.62	86.62	1498.0
2014-01-03 19:00:00	QQQ	ETF	86.6	86.64	86.55	86.64	1604.0
2014-01-03 06:00:00	IWM	ETF	114.44	114.44	114.39	114.39	6350.0
2014-01-03 07:00:00	IWM	ETF	114.4	114.64	114.39	114.63	161100.0
2014-01-03 08:00:00	IWM	ETF	114.6	114.69	114.56	114.62	113242.0
2014-01-03 09:00:00	IWM	ETF	114.62	114.6801	114.34	114.64	3084599.0
2014-01-03 10:00:00	IWM	ETF	114.64	114.74	114.45	114.67	3839363.0
2014-01-03 11:00:00	IWM	ETF	114.68	114.75	114.11	114.16	2655154.0
2014-01-03 12:00:00	IWM	ETF	114.16	114.52	114.14	114.42	1793198.0
2014-01-03 13:00:00	IWM	ETF	114.42	114.52	114.3202	114.44	1100527.0
2014-01-03 14:00:00	IWM	ETF	114.44	114.72	114.37	114.69	2563667.0
2014-01-03 15:00:00	IWM	ETF	114.69	114.895	114.53	114.66	6180704.0
2014-01-03 16:00:00	IWM	ETF	114.67	114.74	114.4725	114.68	894597.0
2014-01-03 17:00:00	IWM	ETF	114.55	114.55	114.55	114.55	900.0
2014-01-03 18:00:00	IWM	ETF	114.64	114.64	114.64	114.64	660.0
2014-01-03 19:00:00	IWM	ETF	114.67	114.69	114.67	114.69	1840.0
2014-01-03 07:00:00	DIA	ETF	164.4	164.4	164.4	164.4	600.0
2014-01-03 08:00:00	DIA	ETF	164.4	164.56	164.4	164.49	7040.0
2014-01-03 09:00:00	DIA	ETF	164.501	164.7399	164.35	164.6701	721142.0
2014-01-03 10:00:00	DIA	ETF	164.68	164.8	164.56	164.6801	801656.0
2014-01-03 11:00:00	DIA	ETF	164.69	164.76	164.12	164.18	870715.0
2014-01-03 12:00:00	DIA	ETF	164.18	164.42	164.07	164.28	437281.0

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

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