PREVIEW / etf_1hour / 2010-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-23.parquet
  size:    158 KB
  rows:    4,880

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
2010-04-23 04:00:00	SPY	ETF	120.69	121.1	120.69	121.1	5400.0
2010-04-23 05:00:00	SPY	ETF	121.17	121.17	120.9	121.08	12354.0
2010-04-23 06:00:00	SPY	ETF	120.92	121.02	120.85	120.98	31500.0
2010-04-23 07:00:00	SPY	ETF	120.97	121.15	120.96	121.11	292850.0
2010-04-23 08:00:00	SPY	ETF	121.1	121.17	120.21	120.9	1968219.0
2010-04-23 09:00:00	SPY	ETF	120.89	121.02	120.63	120.94	24089126.0
2010-04-23 10:00:00	SPY	ETF	120.95	121.51	120.85	120.98	41026745.0
2010-04-23 11:00:00	SPY	ETF	120.97	121.135	120.65	120.89	22080264.0
2010-04-23 12:00:00	SPY	ETF	120.89	121.27	120.885	121.26	12154951.0
2010-04-23 13:00:00	SPY	ETF	121.26	121.34	121.13	121.28	13432382.0
2010-04-23 14:00:00	SPY	ETF	121.29	121.64	121.21	121.6	15472784.0
2010-04-23 15:00:00	SPY	ETF	121.5925	121.86	121.0	121.8	32183572.0
2010-04-23 16:00:00	SPY	ETF	121.79	121.81	120.71	121.68	9457071.0
2010-04-23 17:00:00	SPY	ETF	121.68	121.79	121.67	121.7	169856.0
2010-04-23 18:00:00	SPY	ETF	121.69	121.73	121.67	121.69	42135.0
2010-04-23 19:00:00	SPY	ETF	121.71	121.72	121.65	121.71	31196.0
2010-04-23 05:00:00	QQQ	ETF	50.24	50.24	50.24	50.24	202.0
2010-04-23 06:00:00	QQQ	ETF	50.24	50.24	50.2	50.2	5250.0
2010-04-23 07:00:00	QQQ	ETF	50.22	50.28	50.21	50.28	209023.0
2010-04-23 08:00:00	QQQ	ETF	50.27	50.46	50.26	50.3	4071588.0
2010-04-23 09:00:00	QQQ	ETF	50.3	50.42	50.21	50.3901	11976806.0
2010-04-23 10:00:00	QQQ	ETF	50.39	50.55	50.2	50.25	14827881.0
2010-04-23 11:00:00	QQQ	ETF	50.25	50.28	50.09	50.22	12702982.0
2010-04-23 12:00:00	QQQ	ETF	50.22	50.36	50.19	50.35	5908185.0
2010-04-23 13:00:00	QQQ	ETF	50.35	50.35	50.21	50.31	3843338.0
2010-04-23 14:00:00	QQQ	ETF	50.31	50.52	50.27	50.52	7134738.0
2010-04-23 15:00:00	QQQ	ETF	50.52	50.57	50.41	50.51	9382821.0
2010-04-23 16:00:00	QQQ	ETF	50.52	50.55	50.3006	50.5	4647429.0
2010-04-23 17:00:00	QQQ	ETF	50.5	50.57	50.48	50.56	76860.0
2010-04-23 18:00:00	QQQ	ETF	50.55	50.56	50.47	50.47	33300.0
2010-04-23 19:00:00	QQQ	ETF	50.48	50.6	50.47	50.6	39703.0
2010-04-23 04:00:00	IWM	ETF	73.15	73.25	73.15	73.25	2966.0
2010-04-23 05:00:00	IWM	ETF	73.3	73.3	73.3	73.3	1000.0
2010-04-23 06:00:00	IWM	ETF	73.2	73.3	73.2	73.2	15476.0
2010-04-23 07:00:00	IWM	ETF	73.29	73.4	73.29	73.38	117600.0
2010-04-23 08:00:00	IWM	ETF	73.37	73.47	72.86	73.44	373999.0
2010-04-23 09:00:00	IWM	ETF	73.45	73.54	72.64	73.45	7497133.0
2010-04-23 10:00:00	IWM	ETF	73.45	73.86	73.37	73.43	13532246.0
2010-04-23 11:00:00	IWM	ETF	73.43	73.8	73.32	73.58	7304161.0
2010-04-23 12:00:00	IWM	ETF	73.59	73.87	73.581	73.85	4465452.0
2010-04-23 13:00:00	IWM	ETF	73.85	73.92	73.71	73.82	6656185.0
2010-04-23 14:00:00	IWM	ETF	73.82	74.03	73.73	73.99	5259262.0
2010-04-23 15:00:00	IWM	ETF	74.0	74.21	73.89	74.14	11518134.0
2010-04-23 16:00:00	IWM	ETF	74.15	74.2508	73.4295	74.06	7895020.0
2010-04-23 17:00:00	IWM	ETF	74.11	74.14	74.06	74.08	4789.0
2010-04-23 18:00:00	IWM	ETF	74.15	74.15	74.08	74.14	1700.0
2010-04-23 19:00:00	IWM	ETF	74.13	74.13	74.01	74.02	731.0
2010-04-23 05:00:00	DIA	ETF	111.47	111.47	111.47	111.47	500.0
2010-04-23 07:00:00	DIA	ETF	111.4	111.47	111.39	111.47	4600.0
2010-04-23 08:00:00	DIA	ETF	111.42	111.46	111.25	111.25	6820.0

> showing 50 of 4,880 rows — these rows as CSV

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