PREVIEW / etf_1hour / 2013-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-30.parquet
  size:    202 KB
  rows:    6,325

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-05-30 04:00:00	SPY	ETF	165.1	165.23	164.8	164.8	14625.0
2013-05-30 05:00:00	SPY	ETF	164.85	165.15	164.8	165.05	115800.0
2013-05-30 06:00:00	SPY	ETF	164.995	165.59	164.88	165.52	224360.0
2013-05-30 07:00:00	SPY	ETF	165.5	166.0	165.5	165.705	602768.0
2013-05-30 08:00:00	SPY	ETF	165.57	166.12	164.6	165.53	1371846.0
2013-05-30 09:00:00	SPY	ETF	165.55	166.3099	165.22	166.2	15907659.0
2013-05-30 10:00:00	SPY	ETF	166.2	166.37	165.8	166.18	20854495.0
2013-05-30 11:00:00	SPY	ETF	166.185	166.26	165.77	166.255	13313754.0
2013-05-30 12:00:00	SPY	ETF	166.25	166.44	165.97	166.18	11036867.0
2013-05-30 13:00:00	SPY	ETF	166.189	166.44	166.03	166.361	7405741.0
2013-05-30 14:00:00	SPY	ETF	166.37	166.59	166.231	166.51	7659893.0
2013-05-30 15:00:00	SPY	ETF	166.5	166.52	165.8	165.82	21884928.0
2013-05-30 16:00:00	SPY	ETF	165.84	166.0815	165.35	165.88	4622532.0
2013-05-30 17:00:00	SPY	ETF	165.91	165.92	165.84	165.89	202380.0
2013-05-30 18:00:00	SPY	ETF	165.9	165.9	165.62	165.76	170770.0
2013-05-30 19:00:00	SPY	ETF	165.76	165.86	165.74	165.85	1078464.0
2013-05-30 04:00:00	QQQ	ETF	73.34	73.34	73.33	73.33	300.0
2013-05-30 05:00:00	QQQ	ETF	73.38	73.38	73.38	73.38	1000.0
2013-05-30 06:00:00	QQQ	ETF	73.37	73.64	73.34	73.64	2900.0
2013-05-30 07:00:00	QQQ	ETF	73.62	73.83	73.62	73.7	91495.0
2013-05-30 08:00:00	QQQ	ETF	73.7	73.79	73.57	73.61	144164.0
2013-05-30 09:00:00	QQQ	ETF	73.62	74.0099	73.48	73.98	3688587.0
2013-05-30 10:00:00	QQQ	ETF	73.98	74.06	73.82	74.06	4857191.0
2013-05-30 11:00:00	QQQ	ETF	74.06	74.11	73.93	74.1	5266264.0
2013-05-30 12:00:00	QQQ	ETF	74.1	74.18	73.99	74.09	2392341.0
2013-05-30 13:00:00	QQQ	ETF	74.1	74.24	74.03	74.2	2715728.0
2013-05-30 14:00:00	QQQ	ETF	74.2	74.275	74.15	74.26	2527308.0
2013-05-30 15:00:00	QQQ	ETF	74.255	74.26	73.93	73.93	6609570.0
2013-05-30 16:00:00	QQQ	ETF	73.93	74.1	73.86	73.91	1348512.0
2013-05-30 17:00:00	QQQ	ETF	73.9	73.94	73.83	73.87	79822.0
2013-05-30 18:00:00	QQQ	ETF	73.87	73.88	73.75	73.81	418354.0
2013-05-30 19:00:00	QQQ	ETF	73.82	73.87	73.81	73.86	14900.0
2013-05-30 04:00:00	IWM	ETF	98.4	98.4	98.18	98.18	20000.0
2013-05-30 06:00:00	IWM	ETF	98.18	98.59	98.18	98.59	32269.0
2013-05-30 07:00:00	IWM	ETF	98.59	98.86	98.58	98.77	114148.0
2013-05-30 08:00:00	IWM	ETF	98.69	98.85	98.51	98.6	163655.0
2013-05-30 09:00:00	IWM	ETF	98.61	99.1	98.31	98.92	4908639.0
2013-05-30 10:00:00	IWM	ETF	98.93	98.99	98.44	98.66	4947882.0
2013-05-30 11:00:00	IWM	ETF	98.66	98.77	98.37	98.75	3684057.0
2013-05-30 12:00:00	IWM	ETF	98.75	98.9	98.615	98.77	2826314.0
2013-05-30 13:00:00	IWM	ETF	98.78	98.95	98.66	98.89	1833013.0
2013-05-30 14:00:00	IWM	ETF	98.89	99.125	98.81	99.065	2547313.0
2013-05-30 15:00:00	IWM	ETF	99.05	99.1	98.7599	98.88	6221788.0
2013-05-30 16:00:00	IWM	ETF	98.88	98.9229	98.84	98.9229	1031630.0
2013-05-30 17:00:00	IWM	ETF	98.86	98.86	98.77	98.77	2886.0
2013-05-30 18:00:00	IWM	ETF	98.79	98.79	98.77	98.77	2375.0
2013-05-30 19:00:00	IWM	ETF	98.81	98.82	98.77	98.78	2650.0
2013-05-30 04:00:00	DIA	ETF	152.55	152.55	152.45	152.45	200.0
2013-05-30 06:00:00	DIA	ETF	152.85	152.85	152.85	152.85	100.0
2013-05-30 07:00:00	DIA	ETF	153.05	153.48	153.05	153.25	6400.0

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

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