PREVIEW / etf_1hour / 2012-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-15.parquet
  size:    187 KB
  rows:    5,743

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
2012-02-15 04:00:00	SPY	ETF	135.7	136.05	135.7	136.01	138899.0
2012-02-15 05:00:00	SPY	ETF	136.03	136.14	135.91	135.93	17170.0
2012-02-15 06:00:00	SPY	ETF	135.96	136.13	135.96	136.05	194730.0
2012-02-15 07:00:00	SPY	ETF	135.99	136.23	135.95	136.0	942737.0
2012-02-15 08:00:00	SPY	ETF	136.0	136.17	135.52	135.68	3661047.0
2012-02-15 09:00:00	SPY	ETF	135.68	135.89	135.27	135.52	21911369.0
2012-02-15 10:00:00	SPY	ETF	135.52	135.67	135.23	135.41	25797035.0
2012-02-15 11:00:00	SPY	ETF	135.405	135.83	135.35	135.78	19891718.0
2012-02-15 12:00:00	SPY	ETF	135.77	135.79	134.94	135.02	23457027.0
2012-02-15 13:00:00	SPY	ETF	135.01	135.14	134.7	135.12	22970124.0
2012-02-15 14:00:00	SPY	ETF	135.13	135.21	134.45	134.4701	30028870.0
2012-02-15 15:00:00	SPY	ETF	134.47	134.79	134.29	134.56	35986299.0
2012-02-15 16:00:00	SPY	ETF	134.55	135.8065	134.21	134.4	8864169.0
2012-02-15 17:00:00	SPY	ETF	134.4	134.5	134.38	134.4	128090.0
2012-02-15 18:00:00	SPY	ETF	134.39	134.4	134.3	134.37	121939.0
2012-02-15 19:00:00	SPY	ETF	134.37	134.38	134.13	134.29	575204.0
2012-02-15 04:00:00	QQQ	ETF	63.44	63.6	63.44	63.6	1500.0
2012-02-15 05:00:00	QQQ	ETF	63.62	63.67	63.62	63.67	700.0
2012-02-15 06:00:00	QQQ	ETF	63.59	63.63	63.59	63.62	3820.0
2012-02-15 07:00:00	QQQ	ETF	63.6	63.7	63.6	63.61	174177.0
2012-02-15 08:00:00	QQQ	ETF	63.62	63.65	63.48	63.49	3708064.0
2012-02-15 09:00:00	QQQ	ETF	63.5	63.61	63.4	63.58	8272947.0
2012-02-15 10:00:00	QQQ	ETF	63.58	63.78	63.44	63.631	8701498.0
2012-02-15 11:00:00	QQQ	ETF	63.64	63.86	63.62	63.85	6325833.0
2012-02-15 12:00:00	QQQ	ETF	63.85	63.855	63.14	63.21	16301794.0
2012-02-15 13:00:00	QQQ	ETF	63.2	63.3	62.97	63.28	10730309.0
2012-02-15 14:00:00	QQQ	ETF	63.29	63.34	62.84	62.86	9815345.0
2012-02-15 15:00:00	QQQ	ETF	62.86	62.91	62.67	62.75	12355533.0
2012-02-15 16:00:00	QQQ	ETF	62.75	62.89	62.63	62.64	1828227.0
2012-02-15 17:00:00	QQQ	ETF	62.65	62.7	62.62	62.69	21575.0
2012-02-15 18:00:00	QQQ	ETF	62.68	62.69	62.6	62.64	30554.0
2012-02-15 19:00:00	QQQ	ETF	62.62	62.63	62.58	62.6	26909.0
2012-02-15 04:00:00	IWM	ETF	82.47	82.66	82.47	82.66	200.0
2012-02-15 06:00:00	IWM	ETF	82.76	82.76	82.76	82.76	200.0
2012-02-15 07:00:00	IWM	ETF	82.71	82.88	82.67	82.74	24000.0
2012-02-15 08:00:00	IWM	ETF	82.73	82.79	82.33	82.4	613269.0
2012-02-15 09:00:00	IWM	ETF	82.42	82.58	81.73	81.98	5070680.0
2012-02-15 10:00:00	IWM	ETF	81.98	82.09	81.48	81.77	5936672.0
2012-02-15 11:00:00	IWM	ETF	81.76	82.37	81.74	82.29	4931692.0
2012-02-15 12:00:00	IWM	ETF	82.29	82.3	81.5	81.58	8234035.0
2012-02-15 13:00:00	IWM	ETF	81.58	81.82	81.27	81.63	6715205.0
2012-02-15 14:00:00	IWM	ETF	81.64	81.72	81.19	81.21	7842207.0
2012-02-15 15:00:00	IWM	ETF	81.21	81.39	81.0	81.22	11665541.0
2012-02-15 16:00:00	IWM	ETF	81.23	82.0868	81.18	81.2	4505829.0
2012-02-15 17:00:00	IWM	ETF	81.21	81.22	81.15	81.17	41346.0
2012-02-15 18:00:00	IWM	ETF	81.1	81.11	81.05	81.05	2599.0
2012-02-15 19:00:00	IWM	ETF	81.08	81.08	80.99	81.01	9600.0
2012-02-15 07:00:00	DIA	ETF	129.35	129.55	129.35	129.48	1170.0
2012-02-15 08:00:00	DIA	ETF	129.32	129.4	128.93	129.07	27570.0
2012-02-15 09:00:00	DIA	ETF	129.07	129.2	128.44	128.61	1029170.0

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

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