PREVIEW / etf_1hour / 2011-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-06.parquet
  size:    177 KB
  rows:    5,504

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
2011-07-06 04:00:00	SPY	ETF	133.73	133.75	133.62	133.67	1548.0
2011-07-06 05:00:00	SPY	ETF	133.7	133.78	133.59	133.59	6560.0
2011-07-06 06:00:00	SPY	ETF	133.85	133.85	133.45	133.65	67077.0
2011-07-06 07:00:00	SPY	ETF	133.56	133.59	133.3	133.48	483955.0
2011-07-06 08:00:00	SPY	ETF	133.49	133.58	133.33	133.48	3246442.0
2011-07-06 09:00:00	SPY	ETF	133.47	133.71	133.39	133.47	18054600.0
2011-07-06 10:00:00	SPY	ETF	133.47	133.63	133.11	133.57	28322222.0
2011-07-06 11:00:00	SPY	ETF	133.57	133.99	133.42	133.9	15476339.0
2011-07-06 12:00:00	SPY	ETF	133.9	134.14	133.81	134.11	11104616.0
2011-07-06 13:00:00	SPY	ETF	134.1199	134.12	133.77	133.95	12796214.0
2011-07-06 14:00:00	SPY	ETF	133.95	133.99	133.65	133.78	15276095.0
2011-07-06 15:00:00	SPY	ETF	133.78	133.98	133.64	133.96	24622861.0
2011-07-06 16:00:00	SPY	ETF	133.96	134.33	133.6884	134.25	10798725.0
2011-07-06 17:00:00	SPY	ETF	134.25	134.28	134.2	134.28	103495.0
2011-07-06 18:00:00	SPY	ETF	134.28	134.29	133.94	134.19	162254.0
2011-07-06 19:00:00	SPY	ETF	134.19	134.34	134.17	134.33	44021.0
2011-07-06 04:00:00	QQQ	ETF	58.11	58.11	58.11	58.11	100.0
2011-07-06 05:00:00	QQQ	ETF	58.09	58.12	58.06	58.12	11800.0
2011-07-06 06:00:00	QQQ	ETF	58.16	58.23	58.15	58.19	20800.0
2011-07-06 07:00:00	QQQ	ETF	58.12	58.13	58.05	58.08	165900.0
2011-07-06 08:00:00	QQQ	ETF	58.09	58.14	58.05	58.11	411248.0
2011-07-06 09:00:00	QQQ	ETF	58.12	58.25	58.06	58.1838	7038360.0
2011-07-06 10:00:00	QQQ	ETF	58.18	58.22	57.94	58.18	7516808.0
2011-07-06 11:00:00	QQQ	ETF	58.18	58.39	58.095	58.35	4620352.0
2011-07-06 12:00:00	QQQ	ETF	58.35	58.49	58.3	58.48	3634399.0
2011-07-06 13:00:00	QQQ	ETF	58.48	58.49	58.29	58.375	4542710.0
2011-07-06 14:00:00	QQQ	ETF	58.375	58.38	58.15	58.24	6495583.0
2011-07-06 15:00:00	QQQ	ETF	58.24	58.39	58.17	58.38	6294429.0
2011-07-06 16:00:00	QQQ	ETF	58.39	58.48	58.35	58.47	943029.0
2011-07-06 17:00:00	QQQ	ETF	58.46	58.49	58.44	58.45	8055.0
2011-07-06 18:00:00	QQQ	ETF	58.47	58.47	58.36	58.36	20351.0
2011-07-06 19:00:00	QQQ	ETF	58.46	58.49	58.45	58.49	15702.0
2011-07-06 04:00:00	IWM	ETF	84.05	84.11	83.95	84.11	9800.0
2011-07-06 05:00:00	IWM	ETF	83.91	83.91	83.9	83.9	3000.0
2011-07-06 06:00:00	IWM	ETF	83.99	83.99	83.95	83.95	6000.0
2011-07-06 07:00:00	IWM	ETF	83.9	83.97	83.8	83.87	141900.0
2011-07-06 08:00:00	IWM	ETF	83.9	83.98	83.83	83.91	817101.0
2011-07-06 09:00:00	IWM	ETF	83.92	84.13	83.79	83.85	8909374.0
2011-07-06 10:00:00	IWM	ETF	83.85	84.08	83.61	83.99	8248679.0
2011-07-06 11:00:00	IWM	ETF	83.99	84.37	83.845	84.3187	5050197.0
2011-07-06 12:00:00	IWM	ETF	84.3184	84.51	84.23	84.5	4618309.0
2011-07-06 13:00:00	IWM	ETF	84.5	84.5	84.3	84.46	4850634.0
2011-07-06 14:00:00	IWM	ETF	84.45	84.48	84.14	84.2	5978010.0
2011-07-06 15:00:00	IWM	ETF	84.2	84.39	84.1	84.39	5739692.0
2011-07-06 16:00:00	IWM	ETF	84.39	84.62	84.342	84.6	793441.0
2011-07-06 17:00:00	IWM	ETF	84.6	84.73	84.59	84.71	205246.0
2011-07-06 18:00:00	IWM	ETF	84.66	84.66	84.65	84.65	5800.0
2011-07-06 19:00:00	IWM	ETF	84.66	84.67	84.61	84.67	1800.0
2011-07-06 04:00:00	DIA	ETF	125.29	125.29	125.29	125.29	500.0
2011-07-06 05:00:00	DIA	ETF	125.57	125.57	125.57	125.57	500.0

> showing 50 of 5,504 rows — these rows as CSV

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