PREVIEW / etf_1hour / 2014-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-10.parquet
  size:    236 KB
  rows:    7,485

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-10 04:00:00	SPY	ETF	192.74	193.1	192.65	192.65	24036.0
2014-10-10 05:00:00	SPY	ETF	192.63	192.74	192.16	192.16	96252.0
2014-10-10 06:00:00	SPY	ETF	192.16	192.22	191.71	192.18	255017.0
2014-10-10 07:00:00	SPY	ETF	192.16	192.47	191.98	192.36	474023.0
2014-10-10 08:00:00	SPY	ETF	192.34	193.19	192.02	193.03	3588030.0
2014-10-10 09:00:00	SPY	ETF	193.02	193.65	192.11	193.08	28349844.0
2014-10-10 10:00:00	SPY	ETF	193.09	193.18	191.18	192.0495	50968438.0
2014-10-10 11:00:00	SPY	ETF	192.04	192.49	191.5099	192.08	23500840.0
2014-10-10 12:00:00	SPY	ETF	192.08	193.509	192.07	192.86	26205485.0
2014-10-10 13:00:00	SPY	ETF	192.85	192.99	192.13	192.65	13791966.0
2014-10-10 14:00:00	SPY	ETF	192.6499	192.89	191.87	191.94	11881580.0
2014-10-10 15:00:00	SPY	ETF	191.94	192.02	190.51	190.52	40897871.0
2014-10-10 16:00:00	SPY	ETF	190.5	191.0193	189.92	189.98	17560031.0
2014-10-10 17:00:00	SPY	ETF	189.98	190.54	189.95	190.13	1569001.0
2014-10-10 18:00:00	SPY	ETF	190.13	190.38	190.12	190.18	209040.0
2014-10-10 19:00:00	SPY	ETF	190.2	190.39	190.16	190.27	66229.0
2014-10-10 04:00:00	QQQ	ETF	96.41	96.41	96.41	96.41	100.0
2014-10-10 05:00:00	QQQ	ETF	96.31	96.31	96.11	96.24	16830.0
2014-10-10 06:00:00	QQQ	ETF	96.17	96.18	95.9	96.18	35850.0
2014-10-10 07:00:00	QQQ	ETF	96.17	96.29	96.07	96.25	282436.0
2014-10-10 08:00:00	QQQ	ETF	96.26	96.57	96.0	96.52	659890.0
2014-10-10 09:00:00	QQQ	ETF	96.51	96.83	95.943	96.37	10374097.0
2014-10-10 10:00:00	QQQ	ETF	96.37	96.4	95.11	95.695	16941598.0
2014-10-10 11:00:00	QQQ	ETF	95.69	95.96	95.44	95.65	9226734.0
2014-10-10 12:00:00	QQQ	ETF	95.65	96.32	95.65	95.95	9678277.0
2014-10-10 13:00:00	QQQ	ETF	95.94	96.02	95.5	95.71	4781336.0
2014-10-10 14:00:00	QQQ	ETF	95.72	95.8898	95.28	95.34	5138446.0
2014-10-10 15:00:00	QQQ	ETF	95.35	95.38	94.42	94.44	15257631.0
2014-10-10 16:00:00	QQQ	ETF	94.43	96.8196	94.15	94.18	2865775.0
2014-10-10 17:00:00	QQQ	ETF	94.18	94.44	94.17	94.24	274452.0
2014-10-10 18:00:00	QQQ	ETF	94.24	94.24	94.17	94.2	28702.0
2014-10-10 19:00:00	QQQ	ETF	94.18	94.26	94.16	94.25	15974.0
2014-10-10 04:00:00	IWM	ETF	106.03	106.03	106.03	106.03	500.0
2014-10-10 06:00:00	IWM	ETF	105.3	105.53	105.3	105.53	2100.0
2014-10-10 07:00:00	IWM	ETF	105.4	105.78	105.4	105.67	70394.0
2014-10-10 08:00:00	IWM	ETF	105.7	106.04	105.44	106.04	867875.0
2014-10-10 09:00:00	IWM	ETF	106.04	106.81	105.07	106.32	9445103.0
2014-10-10 10:00:00	IWM	ETF	106.33	106.465	104.87	105.26	13780261.0
2014-10-10 11:00:00	IWM	ETF	105.27	105.93	104.93	105.75	6925655.0
2014-10-10 12:00:00	IWM	ETF	105.74	106.89	105.74	106.2515	8660327.0
2014-10-10 13:00:00	IWM	ETF	106.25	106.37	105.64	106.04	4156609.0
2014-10-10 14:00:00	IWM	ETF	106.033	106.18	105.42	105.45	3276266.0
2014-10-10 15:00:00	IWM	ETF	105.45	106.0759	104.59	104.73	12698553.0
2014-10-10 16:00:00	IWM	ETF	104.73	106.5458	104.36	104.39	3447595.0
2014-10-10 17:00:00	IWM	ETF	104.39	104.7	104.37	104.55	33952.0
2014-10-10 18:00:00	IWM	ETF	104.46	104.63	104.44	104.63	1950.0
2014-10-10 19:00:00	IWM	ETF	104.63	104.7	104.61	104.69	6826.0
2014-10-10 05:00:00	DIA	ETF	165.85	165.85	165.71	165.71	7900.0
2014-10-10 06:00:00	DIA	ETF	165.7	165.87	165.41	165.87	43700.0
2014-10-10 07:00:00	DIA	ETF	165.87	166.05	165.87	166.05	19700.0

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

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