PREVIEW / etf_1hour / 2011-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-14.parquet
  size:    174 KB
  rows:    5,410

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-02-14 04:00:00	SPY	ETF	133.12	133.19	133.11	133.11	15050.0
2011-02-14 05:00:00	SPY	ETF	133.08	133.1	132.99	132.99	3900.0
2011-02-14 06:00:00	SPY	ETF	133.03	133.05	132.92	132.97	16050.0
2011-02-14 07:00:00	SPY	ETF	133.0	133.1	132.98	133.02	463573.0
2011-02-14 08:00:00	SPY	ETF	133.02	133.05	132.92	133.04	712937.0
2011-02-14 09:00:00	SPY	ETF	133.02	133.18	132.96	133.07	13077976.0
2011-02-14 10:00:00	SPY	ETF	133.07	133.3	132.88	133.015	20263801.0
2011-02-14 11:00:00	SPY	ETF	133.02	133.21	132.93	133.21	8673524.0
2011-02-14 12:00:00	SPY	ETF	133.21	133.38	133.18	133.31	8100303.0
2011-02-14 13:00:00	SPY	ETF	133.31	133.36	133.22	133.29	6037167.0
2011-02-14 14:00:00	SPY	ETF	133.29	133.43	133.23	133.4	6920794.0
2011-02-14 15:00:00	SPY	ETF	133.41	133.54	133.29	133.43	18473641.0
2011-02-14 16:00:00	SPY	ETF	133.42	133.46	133.01	133.02	15351277.0
2011-02-14 17:00:00	SPY	ETF	133.02	133.4424	132.9	132.97	1410980.0
2011-02-14 18:00:00	SPY	ETF	132.97	133.43	132.93	133.04	73726.0
2011-02-14 19:00:00	SPY	ETF	133.02	133.11	132.99	133.05	105553.0
2011-02-14 06:00:00	QQQ	ETF	58.37	58.4	58.37	58.39	2574.0
2011-02-14 07:00:00	QQQ	ETF	58.42	58.45	58.37	58.38	645589.0
2011-02-14 08:00:00	QQQ	ETF	58.4	58.44	58.38	58.41	604276.0
2011-02-14 09:00:00	QQQ	ETF	58.41	58.55	58.38	58.51	5976850.0
2011-02-14 10:00:00	QQQ	ETF	58.51	58.65	58.44	58.5	7939016.0
2011-02-14 11:00:00	QQQ	ETF	58.5	58.61	58.47	58.575	4639121.0
2011-02-14 12:00:00	QQQ	ETF	58.58	58.66	58.55	58.595	3968766.0
2011-02-14 13:00:00	QQQ	ETF	58.59	58.62	58.55	58.55	1637932.0
2011-02-14 14:00:00	QQQ	ETF	58.55	58.59	58.52	58.56	2070324.0
2011-02-14 15:00:00	QQQ	ETF	58.56	58.61	58.52	58.58	5155987.0
2011-02-14 16:00:00	QQQ	ETF	58.58	58.6304	58.4149	58.45	7763366.0
2011-02-14 17:00:00	QQQ	ETF	58.44	58.58	58.43	58.45	33361.0
2011-02-14 18:00:00	QQQ	ETF	58.44	58.46	58.43	58.45	7300.0
2011-02-14 19:00:00	QQQ	ETF	58.44	58.5	58.44	58.5	7511.0
2011-02-14 04:00:00	IWM	ETF	82.08	82.08	82.08	82.08	435.0
2011-02-14 05:00:00	IWM	ETF	82.1	82.2	82.1	82.2	3600.0
2011-02-14 07:00:00	IWM	ETF	82.12	82.18	82.06	82.06	6400.0
2011-02-14 08:00:00	IWM	ETF	82.08	82.11	82.03	82.1	105587.0
2011-02-14 09:00:00	IWM	ETF	82.09	82.48	82.05	82.3599	5747914.0
2011-02-14 10:00:00	IWM	ETF	82.357	82.54	82.19	82.288	6655564.0
2011-02-14 11:00:00	IWM	ETF	82.29	82.4701	82.24	82.4701	1839031.0
2011-02-14 12:00:00	IWM	ETF	82.47	82.61	82.41	82.45	3307090.0
2011-02-14 13:00:00	IWM	ETF	82.46	82.52	82.36	82.38	1764437.0
2011-02-14 14:00:00	IWM	ETF	82.37	82.44	82.32	82.43	2308068.0
2011-02-14 15:00:00	IWM	ETF	82.43	82.51	82.34	82.49	6453300.0
2011-02-14 16:00:00	IWM	ETF	82.49	82.53	82.26	82.26	975497.0
2011-02-14 17:00:00	IWM	ETF	82.25	82.28	82.21	82.25	27564.0
2011-02-14 18:00:00	IWM	ETF	82.25	82.32	82.23	82.32	1500.0
2011-02-14 19:00:00	IWM	ETF	82.33	82.37	82.23	82.35	1800.0
2011-02-14 08:00:00	DIA	ETF	122.61	122.62	122.53	122.59	5200.0
2011-02-14 09:00:00	DIA	ETF	122.6	122.62	122.32	122.41	633986.0
2011-02-14 10:00:00	DIA	ETF	122.41	122.57	122.3	122.37	834682.0
2011-02-14 11:00:00	DIA	ETF	122.37	122.53	122.3	122.5	323284.0
2011-02-14 12:00:00	DIA	ETF	122.491	122.66	122.49	122.6	534013.0

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

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