PREVIEW / etf_1hour / 2013-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-03.parquet
  size:    208 KB
  rows:    6,521

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-09-03 04:00:00	SPY	ETF	165.36	165.43	164.84	164.92	102572.0
2013-09-03 05:00:00	SPY	ETF	164.9	165.24	164.84	164.92	74850.0
2013-09-03 06:00:00	SPY	ETF	164.9	165.28	164.9	165.2	107098.0
2013-09-03 07:00:00	SPY	ETF	165.19	165.28	164.9	165.07	388012.0
2013-09-03 08:00:00	SPY	ETF	165.26	165.43	164.9	165.2	1040555.0
2013-09-03 09:00:00	SPY	ETF	165.21	165.58	163.65	165.26	14581922.0
2013-09-03 10:00:00	SPY	ETF	165.26	165.45	164.97	165.07	18983988.0
2013-09-03 11:00:00	SPY	ETF	165.07	165.27	164.23	164.41	16579076.0
2013-09-03 12:00:00	SPY	ETF	164.42	164.56	163.94	163.9816	14252009.0
2013-09-03 13:00:00	SPY	ETF	163.985	164.16	163.77	163.815	11518469.0
2013-09-03 14:00:00	SPY	ETF	163.85	164.16	163.7	164.09	13817928.0
2013-09-03 15:00:00	SPY	ETF	164.08	164.55	164.03	164.38	25359544.0
2013-09-03 16:00:00	SPY	ETF	164.38	164.59	163.7033	164.44	16493690.0
2013-09-03 17:00:00	SPY	ETF	164.45	164.47	164.35	164.4	139654.0
2013-09-03 18:00:00	SPY	ETF	164.4	164.4	164.21	164.34	33216.0
2013-09-03 19:00:00	SPY	ETF	164.33	164.39	164.29	164.35	11202.0
2013-09-03 04:00:00	QQQ	ETF	76.33	76.34	75.98	76.0	84500.0
2013-09-03 05:00:00	QQQ	ETF	75.98	76.06	75.94	75.94	41000.0
2013-09-03 06:00:00	QQQ	ETF	75.96	76.14	75.96	76.07	28400.0
2013-09-03 07:00:00	QQQ	ETF	76.09	76.09	75.94	75.97	76685.0
2013-09-03 08:00:00	QQQ	ETF	75.98	76.09	75.96	76.08	125020.0
2013-09-03 09:00:00	QQQ	ETF	76.09	76.41	76.04	76.3	4343369.0
2013-09-03 10:00:00	QQQ	ETF	76.31	76.44	76.12	76.28	4691735.0
2013-09-03 11:00:00	QQQ	ETF	76.29	76.42	75.89	75.98	4028792.0
2013-09-03 12:00:00	QQQ	ETF	75.97	76.1	75.741	75.751	2038994.0
2013-09-03 13:00:00	QQQ	ETF	75.75	75.84	75.54	75.59	2895363.0
2013-09-03 14:00:00	QQQ	ETF	75.6	75.81	75.56	75.81	2354458.0
2013-09-03 15:00:00	QQQ	ETF	75.82	76.04	75.76	75.9	4498025.0
2013-09-03 16:00:00	QQQ	ETF	75.9	76.326	75.4803	75.82	1740610.0
2013-09-03 17:00:00	QQQ	ETF	75.46	75.85	75.46	75.84	45050.0
2013-09-03 18:00:00	QQQ	ETF	75.84	75.84	75.77	75.82	15537.0
2013-09-03 19:00:00	QQQ	ETF	75.82	75.85	75.82	75.84	14280.0
2013-09-03 04:00:00	IWM	ETF	101.8	101.94	101.8	101.9	2104.0
2013-09-03 07:00:00	IWM	ETF	101.73	101.88	101.62	101.7	61254.0
2013-09-03 08:00:00	IWM	ETF	101.7	101.84	101.67	101.82	148525.0
2013-09-03 09:00:00	IWM	ETF	101.83	102.37	100.38	101.88	6297149.0
2013-09-03 10:00:00	IWM	ETF	101.86	101.945	101.2	101.62	5965237.0
2013-09-03 11:00:00	IWM	ETF	101.62	101.78	100.96	101.07	4674376.0
2013-09-03 12:00:00	IWM	ETF	101.08	101.23	100.77	100.78	2829791.0
2013-09-03 13:00:00	IWM	ETF	100.78	100.94	100.37	100.44	2900869.0
2013-09-03 14:00:00	IWM	ETF	100.44	100.54	100.13	100.53	4475679.0
2013-09-03 15:00:00	IWM	ETF	100.55	101.16	100.52	101.05	7532477.0
2013-09-03 16:00:00	IWM	ETF	101.05	101.21	100.3215	101.11	2513053.0
2013-09-03 17:00:00	IWM	ETF	101.06	101.08	101.06	101.08	36400.0
2013-09-03 18:00:00	IWM	ETF	101.08	101.08	101.06	101.06	700.0
2013-09-03 19:00:00	IWM	ETF	101.02	101.07	101.02	101.07	200.0
2013-09-03 04:00:00	DIA	ETF	149.1	149.25	148.8	148.8	2432.0
2013-09-03 07:00:00	DIA	ETF	148.9	148.9	148.73	148.75	4400.0
2013-09-03 08:00:00	DIA	ETF	148.75	148.9	148.71	148.9	6221.0
2013-09-03 09:00:00	DIA	ETF	148.91	149.55	148.53	148.93	667477.0

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

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