PREVIEW / etf_1hour / 2011-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-10.parquet
  size:    180 KB
  rows:    5,530

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-05-10 04:00:00	SPY	ETF	134.95	135.1	134.8	135.1	5850.0
2011-05-10 05:00:00	SPY	ETF	135.18	135.3	135.17	135.17	5800.0
2011-05-10 06:00:00	SPY	ETF	135.26	135.42	135.26	135.35	89100.0
2011-05-10 07:00:00	SPY	ETF	135.33	135.44	135.26	135.4	307261.0
2011-05-10 08:00:00	SPY	ETF	135.4	135.53	135.27	135.32	1437108.0
2011-05-10 09:00:00	SPY	ETF	135.32	135.43	135.0	135.39	14430532.0
2011-05-10 10:00:00	SPY	ETF	135.4	135.66	135.32	135.56	17850670.0
2011-05-10 11:00:00	SPY	ETF	135.56	135.64	135.29	135.45	11413675.0
2011-05-10 12:00:00	SPY	ETF	135.45	135.58	135.36	135.45	6470799.0
2011-05-10 13:00:00	SPY	ETF	135.44	135.57	135.3	135.55	8079736.0
2011-05-10 14:00:00	SPY	ETF	135.56	135.94	135.42	135.94	13879413.0
2011-05-10 15:00:00	SPY	ETF	135.93	136.11	135.77	135.89	28044578.0
2011-05-10 16:00:00	SPY	ETF	135.89	136.02	135.76	135.89	8859725.0
2011-05-10 17:00:00	SPY	ETF	135.91	135.97	135.9	135.97	149326.0
2011-05-10 18:00:00	SPY	ETF	135.97	136.03	135.87	135.99	128892.0
2011-05-10 19:00:00	SPY	ETF	135.99	136.03	135.98	136.03	31641.0
2011-05-10 04:00:00	QQQ	ETF	58.68	58.68	58.6	58.6	9000.0
2011-05-10 05:00:00	QQQ	ETF	58.85	58.89	58.85	58.88	3200.0
2011-05-10 06:00:00	QQQ	ETF	58.94	58.94	58.94	58.94	300.0
2011-05-10 07:00:00	QQQ	ETF	58.98	59.01	58.94	58.99	67463.0
2011-05-10 08:00:00	QQQ	ETF	58.99	59.02	58.89	58.9	279569.0
2011-05-10 09:00:00	QQQ	ETF	58.91	59.08	58.775	59.07	5317951.0
2011-05-10 10:00:00	QQQ	ETF	59.08	59.1	58.9099	58.99	5540750.0
2011-05-10 11:00:00	QQQ	ETF	58.99	59.04	58.86	58.94	3150492.0
2011-05-10 12:00:00	QQQ	ETF	58.9449	58.98	58.89	58.9	4538482.0
2011-05-10 13:00:00	QQQ	ETF	58.91	59.01	58.84	58.9984	3800633.0
2011-05-10 14:00:00	QQQ	ETF	59.0	59.2	58.9405	59.19	4338023.0
2011-05-10 15:00:00	QQQ	ETF	59.19	59.28	59.13	59.2	6019597.0
2011-05-10 16:00:00	QQQ	ETF	59.19	59.23	59.12	59.19	1743532.0
2011-05-10 17:00:00	QQQ	ETF	59.19	59.25	59.18	59.18	50408.0
2011-05-10 18:00:00	QQQ	ETF	59.22	59.31	59.2	59.3	51308.0
2011-05-10 19:00:00	QQQ	ETF	59.3	59.33	59.3	59.33	12693.0
2011-05-10 04:00:00	IWM	ETF	84.4	84.44	84.26	84.44	1922.0
2011-05-10 05:00:00	IWM	ETF	84.54	84.54	84.54	84.54	100.0
2011-05-10 06:00:00	IWM	ETF	84.6	84.66	84.56	84.56	8900.0
2011-05-10 07:00:00	IWM	ETF	84.56	84.7	84.51	84.66	111140.0
2011-05-10 08:00:00	IWM	ETF	84.66	84.75	84.59	84.65	267782.0
2011-05-10 09:00:00	IWM	ETF	84.65	85.08	84.52	85.01	5859502.0
2011-05-10 10:00:00	IWM	ETF	85.01	85.17	84.78	85.1	7054114.0
2011-05-10 11:00:00	IWM	ETF	85.1	85.22	84.89	85.12	4914033.0
2011-05-10 12:00:00	IWM	ETF	85.11	85.21	85.08	85.12	2437238.0
2011-05-10 13:00:00	IWM	ETF	85.13	85.13	84.98	85.06	2831228.0
2011-05-10 14:00:00	IWM	ETF	85.06	85.34	85.0	85.34	3740383.0
2011-05-10 15:00:00	IWM	ETF	85.34	85.53	85.28	85.51	10570000.0
2011-05-10 16:00:00	IWM	ETF	85.51	85.57	85.38	85.51	2292339.0
2011-05-10 17:00:00	IWM	ETF	85.49	85.58	85.49	85.54	24790.0
2011-05-10 18:00:00	IWM	ETF	85.54	85.58	85.54	85.56	5335.0
2011-05-10 19:00:00	IWM	ETF	85.56	85.59	85.56	85.56	5626.0
2011-05-10 05:00:00	DIA	ETF	127.01	127.09	127.01	127.07	4580.0
2011-05-10 06:00:00	DIA	ETF	127.09	127.15	127.09	127.15	5300.0

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

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