PREVIEW / etf_1hour / 2014-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-13.parquet
  size:    239 KB
  rows:    7,532

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-10-13 04:00:00	SPY	ETF	189.66	190.38	189.5	190.37	53429.0
2014-10-13 05:00:00	SPY	ETF	190.35	190.38	190.0	190.15	72169.0
2014-10-13 06:00:00	SPY	ETF	190.18	190.66	190.16	190.63	261271.0
2014-10-13 07:00:00	SPY	ETF	190.59	190.61	190.29	190.34	765999.0
2014-10-13 08:00:00	SPY	ETF	189.56	190.86	189.22	190.72	2521292.0
2014-10-13 09:00:00	SPY	ETF	190.72	191.15	189.55	190.07	31919513.0
2014-10-13 10:00:00	SPY	ETF	190.09	190.45	188.95	189.67	36608223.0
2014-10-13 11:00:00	SPY	ETF	189.67	190.33	189.38	189.91	23202113.0
2014-10-13 12:00:00	SPY	ETF	189.91	191.15	189.71	190.65	22144476.0
2014-10-13 13:00:00	SPY	ETF	190.65	190.88	189.96	190.23	16610276.0
2014-10-13 14:00:00	SPY	ETF	190.23	190.5	189.58	189.695	16963983.0
2014-10-13 15:00:00	SPY	ETF	189.69	189.78	187.3	187.38	55259703.0
2014-10-13 16:00:00	SPY	ETF	187.38	189.922	187.04	187.12	11393731.0
2014-10-13 17:00:00	SPY	ETF	187.1	187.4099	186.97	187.28	8535417.0
2014-10-13 18:00:00	SPY	ETF	187.26	187.51	187.23	187.41	418527.0
2014-10-13 19:00:00	SPY	ETF	187.4	187.7	187.35	187.7	430208.0
2014-10-13 04:00:00	QQQ	ETF	94.17	94.17	93.85	93.98	17759.0
2014-10-13 05:00:00	QQQ	ETF	94.2	94.2	94.08	94.14	20600.0
2014-10-13 06:00:00	QQQ	ETF	94.06	94.32	94.04	94.32	53600.0
2014-10-13 07:00:00	QQQ	ETF	94.27	94.3	94.15	94.18	95760.0
2014-10-13 08:00:00	QQQ	ETF	94.19	94.44	94.1	94.36	304705.0
2014-10-13 09:00:00	QQQ	ETF	94.35	94.73	93.72	94.05	12139131.0
2014-10-13 10:00:00	QQQ	ETF	94.05	94.22	93.11	93.78	13767671.0
2014-10-13 11:00:00	QQQ	ETF	93.78	94.49	93.62	94.27	13383380.0
2014-10-13 12:00:00	QQQ	ETF	94.26	94.99	94.09	94.69	6342667.0
2014-10-13 13:00:00	QQQ	ETF	94.69	94.835	94.21	94.36	5899319.0
2014-10-13 14:00:00	QQQ	ETF	94.35	94.67	93.99	94.045	6372925.0
2014-10-13 15:00:00	QQQ	ETF	94.04	94.11	92.88	92.97	15125750.0
2014-10-13 16:00:00	QQQ	ETF	92.96	94.4217	92.75	92.79	2701693.0
2014-10-13 17:00:00	QQQ	ETF	92.76	92.96	92.71	92.82	3059956.0
2014-10-13 18:00:00	QQQ	ETF	92.85	93.03	92.85	92.91	50070.0
2014-10-13 19:00:00	QQQ	ETF	92.91	93.09	92.89	93.08	52381.0
2014-10-13 04:00:00	IWM	ETF	104.42	104.49	104.31	104.49	2300.0
2014-10-13 05:00:00	IWM	ETF	104.36	104.65	104.34	104.65	1500.0
2014-10-13 06:00:00	IWM	ETF	104.74	104.74	104.74	104.74	2600.0
2014-10-13 07:00:00	IWM	ETF	104.82	104.84	104.59	104.67	82368.0
2014-10-13 08:00:00	IWM	ETF	104.6	104.95	104.57	104.86	637327.0
2014-10-13 09:00:00	IWM	ETF	104.8	105.37	104.22	104.75	7590884.0
2014-10-13 10:00:00	IWM	ETF	104.75	105.15	103.86	104.76	12340863.0
2014-10-13 11:00:00	IWM	ETF	104.76	105.53	104.63	105.23	8127778.0
2014-10-13 12:00:00	IWM	ETF	105.21	106.11	105.07	105.905	6539431.0
2014-10-13 13:00:00	IWM	ETF	105.905	106.11	105.34	105.45	4523925.0
2014-10-13 14:00:00	IWM	ETF	105.45	105.71	105.01	105.07	4022253.0
2014-10-13 15:00:00	IWM	ETF	105.07	105.21	104.18	104.3	13231341.0
2014-10-13 16:00:00	IWM	ETF	104.29	104.6243	104.02	104.19	4658180.0
2014-10-13 17:00:00	IWM	ETF	104.15	104.37	104.15	104.35	16985.0
2014-10-13 18:00:00	IWM	ETF	104.39	104.5	104.37	104.5	1340.0
2014-10-13 19:00:00	IWM	ETF	104.57	104.84	104.51	104.53	11449.0
2014-10-13 04:00:00	DIA	ETF	165.0	165.0	163.15	163.15	500.0
2014-10-13 06:00:00	DIA	ETF	165.06	165.31	164.99	165.31	13135.0

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

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