PREVIEW / etf_1hour / 2013-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-16.parquet
  size:    211 KB
  rows:    6,590

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
2013-08-16 04:00:00	SPY	ETF	166.24	166.45	166.21	166.33	1045.0
2013-08-16 05:00:00	SPY	ETF	166.4	166.42	166.27	166.34	3401.0
2013-08-16 06:00:00	SPY	ETF	166.48	166.62	166.45	166.45	38098.0
2013-08-16 07:00:00	SPY	ETF	166.53	166.67	166.47	166.47	408818.0
2013-08-16 08:00:00	SPY	ETF	166.48	166.64	166.26	166.28	500283.0
2013-08-16 09:00:00	SPY	ETF	166.29	166.38	165.87	166.31	19216815.0
2013-08-16 10:00:00	SPY	ETF	166.32	166.63	166.07	166.55	14975508.0
2013-08-16 11:00:00	SPY	ETF	166.55	166.63	166.19	166.46	11440436.0
2013-08-16 12:00:00	SPY	ETF	166.45	166.49	166.0	166.06	11563510.0
2013-08-16 13:00:00	SPY	ETF	166.06	166.11	165.56	165.7901	13565175.0
2013-08-16 14:00:00	SPY	ETF	165.7985	166.12	165.5	166.1	15310525.0
2013-08-16 15:00:00	SPY	ETF	166.09	166.29	165.82	165.88	21970196.0
2013-08-16 16:00:00	SPY	ETF	165.87	166.4028	165.53	165.56	17390137.0
2013-08-16 17:00:00	SPY	ETF	165.56	166.194	165.5	165.54	949403.0
2013-08-16 18:00:00	SPY	ETF	165.53	165.59	165.52	165.56	178501.0
2013-08-16 19:00:00	SPY	ETF	165.56	165.61	165.53	165.55	53528.0
2013-08-16 04:00:00	QQQ	ETF	75.53	75.53	75.53	75.53	1600.0
2013-08-16 06:00:00	QQQ	ETF	75.59	75.59	75.58	75.58	200.0
2013-08-16 07:00:00	QQQ	ETF	75.59	75.62	75.58	75.59	21072.0
2013-08-16 08:00:00	QQQ	ETF	75.6	75.6	75.45	75.55	219202.0
2013-08-16 09:00:00	QQQ	ETF	75.52	75.68	75.35	75.64	4108327.0
2013-08-16 10:00:00	QQQ	ETF	75.64	75.84	75.51	75.82	4081597.0
2013-08-16 11:00:00	QQQ	ETF	75.8122	75.87	75.65	75.76	1825445.0
2013-08-16 12:00:00	QQQ	ETF	75.75	75.8	75.57	75.63	2000314.0
2013-08-16 13:00:00	QQQ	ETF	75.64	75.66	75.43	75.531	2029984.0
2013-08-16 14:00:00	QQQ	ETF	75.54	75.6202	75.4	75.6195	1634129.0
2013-08-16 15:00:00	QQQ	ETF	75.61	75.69	75.44	75.45	3784779.0
2013-08-16 16:00:00	QQQ	ETF	75.46	75.7778	75.34	75.515	1781425.0
2013-08-16 17:00:00	QQQ	ETF	75.36	75.36	75.35	75.35	10300.0
2013-08-16 18:00:00	QQQ	ETF	75.35	75.35	75.35	75.35	2500.0
2013-08-16 19:00:00	QQQ	ETF	75.35	75.35	75.32	75.35	6312.0
2013-08-16 07:00:00	IWM	ETF	101.9	102.35	101.9	102.12	38332.0
2013-08-16 08:00:00	IWM	ETF	102.11	102.23	101.99	101.99	65018.0
2013-08-16 09:00:00	IWM	ETF	101.97	102.18	101.75	102.03	4306598.0
2013-08-16 10:00:00	IWM	ETF	102.032	102.33	101.82	102.29	4790388.0
2013-08-16 11:00:00	IWM	ETF	102.29	102.38	102.05	102.31	3313110.0
2013-08-16 12:00:00	IWM	ETF	102.3	102.345	102.02	102.09	2251704.0
2013-08-16 13:00:00	IWM	ETF	102.1	102.16	101.57	101.7895	7735410.0
2013-08-16 14:00:00	IWM	ETF	101.79	101.87	101.55	101.86	2605893.0
2013-08-16 15:00:00	IWM	ETF	101.85	102.02	101.68	101.7	5298523.0
2013-08-16 16:00:00	IWM	ETF	101.69	102.0705	101.47	101.47	2456763.0
2013-08-16 17:00:00	IWM	ETF	101.48	101.53	101.47	101.48	63300.0
2013-08-16 18:00:00	IWM	ETF	101.53	101.53	101.45	101.53	1760.0
2013-08-16 19:00:00	IWM	ETF	101.54	101.64	101.54	101.64	900.0
2013-08-16 04:00:00	DIA	ETF	150.85	150.85	150.75	150.75	200.0
2013-08-16 07:00:00	DIA	ETF	150.99	150.99	150.89	150.89	1350.0
2013-08-16 08:00:00	DIA	ETF	150.88	150.89	150.61	150.64	5361.0
2013-08-16 09:00:00	DIA	ETF	150.69	150.87	150.42	150.84	1022892.0
2013-08-16 10:00:00	DIA	ETF	150.8699	151.06	150.61	150.95	1422816.0
2013-08-16 11:00:00	DIA	ETF	150.94	151.04	150.66	150.88	1006163.0

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

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