PREVIEW / etf_1hour / 2013-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-20.parquet
  size:    206 KB
  rows:    6,495

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-20 04:00:00	SPY	ETF	164.8	165.0	164.7	164.92	12255.0
2013-08-20 05:00:00	SPY	ETF	164.91	164.92	164.72	164.86	20904.0
2013-08-20 06:00:00	SPY	ETF	164.85	165.12	164.79	164.98	254100.0
2013-08-20 07:00:00	SPY	ETF	165.0	165.43	165.0	165.33	500214.0
2013-08-20 08:00:00	SPY	ETF	165.36	165.5	164.76	165.27	1124624.0
2013-08-20 09:00:00	SPY	ETF	165.27	165.29	164.76	165.08	14386533.0
2013-08-20 10:00:00	SPY	ETF	165.08	165.74	165.04	165.59	16884651.0
2013-08-20 11:00:00	SPY	ETF	165.59	166.07	165.59	165.99	10454231.0
2013-08-20 12:00:00	SPY	ETF	165.99	166.11	165.82	166.03	8527599.0
2013-08-20 13:00:00	SPY	ETF	166.03	166.2	165.9	165.97	7010608.0
2013-08-20 14:00:00	SPY	ETF	165.96	166.07	165.81	165.89	6830327.0
2013-08-20 15:00:00	SPY	ETF	165.9	166.11	165.54	165.58	14745273.0
2013-08-20 16:00:00	SPY	ETF	165.59	165.9902	164.8981	165.6	6755707.0
2013-08-20 17:00:00	SPY	ETF	165.59	165.67	165.59	165.64	91170.0
2013-08-20 18:00:00	SPY	ETF	165.65	165.68	165.58	165.6	41313.0
2013-08-20 19:00:00	SPY	ETF	165.64	165.67	165.6	165.63	17510.0
2013-08-20 04:00:00	QQQ	ETF	75.31	75.36	75.24	75.34	22000.0
2013-08-20 05:00:00	QQQ	ETF	75.32	75.32	75.26	75.3	6300.0
2013-08-20 06:00:00	QQQ	ETF	75.32	75.44	75.32	75.4	77800.0
2013-08-20 07:00:00	QQQ	ETF	75.42	75.58	75.4	75.56	155511.0
2013-08-20 08:00:00	QQQ	ETF	75.54	75.65	75.35	75.35	307102.0
2013-08-20 09:00:00	QQQ	ETF	75.58	75.67	75.43	75.59	2795712.0
2013-08-20 10:00:00	QQQ	ETF	75.58	75.84	75.49	75.73	3342326.0
2013-08-20 11:00:00	QQQ	ETF	75.72	75.99	75.72	75.95	2369913.0
2013-08-20 12:00:00	QQQ	ETF	75.945	76.03	75.82	75.9299	1541491.0
2013-08-20 13:00:00	QQQ	ETF	75.93	76.01	75.83	75.85	1224046.0
2013-08-20 14:00:00	QQQ	ETF	75.85	75.89	75.7625	75.8	1646081.0
2013-08-20 15:00:00	QQQ	ETF	75.8	75.9	75.67	75.68	3772067.0
2013-08-20 16:00:00	QQQ	ETF	75.68	75.7603	75.65	75.7	1032021.0
2013-08-20 17:00:00	QQQ	ETF	75.35	75.69	75.35	75.69	11169.0
2013-08-20 19:00:00	QQQ	ETF	75.7	75.72	75.7	75.71	4300.0
2013-08-20 04:00:00	IWM	ETF	100.55	100.55	100.55	100.55	100.0
2013-08-20 07:00:00	IWM	ETF	101.23	101.23	100.8	100.81	56295.0
2013-08-20 08:00:00	IWM	ETF	100.81	100.99	100.6	100.85	464204.0
2013-08-20 09:00:00	IWM	ETF	100.81	101.13	100.71	101.04	5346648.0
2013-08-20 10:00:00	IWM	ETF	101.04	101.74	100.995	101.649	7647322.0
2013-08-20 11:00:00	IWM	ETF	101.65	102.165	101.59	102.08	4469939.0
2013-08-20 12:00:00	IWM	ETF	102.09	102.33	102.08	102.24	3290224.0
2013-08-20 13:00:00	IWM	ETF	102.24	102.32	102.1	102.15	1372735.0
2013-08-20 14:00:00	IWM	ETF	102.16	102.245	102.04	102.165	2006019.0
2013-08-20 15:00:00	IWM	ETF	102.17	102.24	102.01	102.12	4855023.0
2013-08-20 16:00:00	IWM	ETF	102.12	102.25	102.04	102.25	930237.0
2013-08-20 17:00:00	IWM	ETF	102.1	102.1	102.1	102.1	100.0
2013-08-20 18:00:00	IWM	ETF	102.1	102.1	102.07	102.07	1100.0
2013-08-20 19:00:00	IWM	ETF	102.11	102.11	102.1	102.11	1400.0
2013-08-20 07:00:00	DIA	ETF	150.18	150.18	150.18	150.18	100.0
2013-08-20 08:00:00	DIA	ETF	150.19	150.25	150.02	150.02	3050.0
2013-08-20 09:00:00	DIA	ETF	150.1	150.11	149.56	149.79	735045.0
2013-08-20 10:00:00	DIA	ETF	149.77	150.21	149.76	150.12	662031.0
2013-08-20 11:00:00	DIA	ETF	150.13	150.38	150.08	150.33	564369.0

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

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