PREVIEW / etf_1hour / 2013-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-08.parquet
  size:    191 KB
  rows:    6,009

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-01-08 04:00:00	SPY	ETF	145.63	145.63	145.63	145.63	500.0
2013-01-08 05:00:00	SPY	ETF	145.69	145.84	145.59	145.84	49600.0
2013-01-08 06:00:00	SPY	ETF	145.85	145.99	145.76	145.94	97805.0
2013-01-08 07:00:00	SPY	ETF	145.94	145.97	145.71	145.78	127650.0
2013-01-08 08:00:00	SPY	ETF	145.79	145.87	145.59	145.66	557745.0
2013-01-08 09:00:00	SPY	ETF	145.65	145.91	145.51	145.54	12717049.0
2013-01-08 10:00:00	SPY	ETF	145.53	145.59	145.09	145.17	20763710.0
2013-01-08 11:00:00	SPY	ETF	145.17	145.3	144.98	145.2875	14626230.0
2013-01-08 12:00:00	SPY	ETF	145.28	145.37	145.1	145.13	10287315.0
2013-01-08 13:00:00	SPY	ETF	145.135	145.42	145.13	145.395	11912638.0
2013-01-08 14:00:00	SPY	ETF	145.39	145.52	145.24	145.31	8372167.0
2013-01-08 15:00:00	SPY	ETF	145.31	145.63	145.29	145.54	18742870.0
2013-01-08 16:00:00	SPY	ETF	145.53	146.0369	145.2	145.5	19408308.0
2013-01-08 17:00:00	SPY	ETF	145.5	145.57	145.48	145.53	432052.0
2013-01-08 18:00:00	SPY	ETF	145.53	145.62	145.53	145.6	14858.0
2013-01-08 19:00:00	SPY	ETF	145.6	145.8	145.6	145.67	116383.0
2013-01-08 06:00:00	QQQ	ETF	66.58	66.69	66.58	66.69	1550.0
2013-01-08 07:00:00	QQQ	ETF	66.66	66.66	66.6	66.6	2600.0
2013-01-08 08:00:00	QQQ	ETF	66.58	66.7	66.54	66.6	475835.0
2013-01-08 09:00:00	QQQ	ETF	66.59	66.815	66.47	66.5	4764419.0
2013-01-08 10:00:00	QQQ	ETF	66.5	66.54	66.26	66.3	4329674.0
2013-01-08 11:00:00	QQQ	ETF	66.305	66.35	66.17	66.32	3093041.0
2013-01-08 12:00:00	QQQ	ETF	66.32	66.38	66.2	66.235	2018481.0
2013-01-08 13:00:00	QQQ	ETF	66.235	66.5	66.23	66.47	2091829.0
2013-01-08 14:00:00	QQQ	ETF	66.48	66.5499	66.35	66.4	1695434.0
2013-01-08 15:00:00	QQQ	ETF	66.39	66.61	66.38	66.54	4203559.0
2013-01-08 16:00:00	QQQ	ETF	66.55	66.6726	66.5103	66.54	2629808.0
2013-01-08 17:00:00	QQQ	ETF	66.56	66.6	66.56	66.6	9100.0
2013-01-08 18:00:00	QQQ	ETF	66.59	66.61	66.59	66.59	7326.0
2013-01-08 19:00:00	QQQ	ETF	66.63	66.67	66.59	66.63	8750.0
2013-01-08 07:00:00	IWM	ETF	87.01	87.01	86.87	86.87	9187.0
2013-01-08 08:00:00	IWM	ETF	86.89	86.92	86.81	86.83	114223.0
2013-01-08 09:00:00	IWM	ETF	86.82	87.01	86.7255	86.77	3214179.0
2013-01-08 10:00:00	IWM	ETF	86.77	86.83	86.5	86.56	3013609.0
2013-01-08 11:00:00	IWM	ETF	86.56	86.6	86.39	86.59	2110511.0
2013-01-08 12:00:00	IWM	ETF	86.6	86.69	86.4727	86.5	1738042.0
2013-01-08 13:00:00	IWM	ETF	86.51	86.74	86.5099	86.705	1361715.0
2013-01-08 14:00:00	IWM	ETF	86.715	86.79	86.62	86.695	1844308.0
2013-01-08 15:00:00	IWM	ETF	86.7	86.91	86.64	86.84	4649502.0
2013-01-08 16:00:00	IWM	ETF	86.84	86.96	86.8	86.89	1697102.0
2013-01-08 17:00:00	IWM	ETF	86.92	86.95	86.92	86.95	5400.0
2013-01-08 18:00:00	IWM	ETF	86.92	86.93	86.9	86.9	3745.0
2013-01-08 19:00:00	IWM	ETF	86.95	86.97	86.93	86.95	6100.0
2013-01-08 07:00:00	DIA	ETF	133.4	133.4	133.4	133.4	2300.0
2013-01-08 08:00:00	DIA	ETF	133.35	133.4	133.24	133.26	13400.0
2013-01-08 09:00:00	DIA	ETF	133.25	133.5	133.17	133.21	591915.0
2013-01-08 10:00:00	DIA	ETF	133.21	133.32	132.97	133.01	709026.0
2013-01-08 11:00:00	DIA	ETF	133.02	133.05	132.79	132.9901	377135.0
2013-01-08 12:00:00	DIA	ETF	133.01	133.04	132.74	132.79	584541.0
2013-01-08 13:00:00	DIA	ETF	132.8	133.0	132.79	132.98	294289.0

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

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