PREVIEW / etf_1hour / 2010-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-23.parquet
  size:    160 KB
  rows:    4,894

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-08-23 04:00:00	SPY	ETF	107.75	108.0	107.75	108.0	3000.0
2010-08-23 05:00:00	SPY	ETF	108.0	108.07	108.0	108.07	5300.0
2010-08-23 06:00:00	SPY	ETF	108.12	108.22	108.12	108.2	2800.0
2010-08-23 07:00:00	SPY	ETF	108.17	108.27	108.08	108.23	169186.0
2010-08-23 08:00:00	SPY	ETF	108.25	108.28	107.96	107.98	1116010.0
2010-08-23 09:00:00	SPY	ETF	107.98	108.57	107.88	108.37	23093683.0
2010-08-23 10:00:00	SPY	ETF	108.37	108.41	107.42	107.59	32077484.0
2010-08-23 11:00:00	SPY	ETF	107.59	107.64	107.3	107.44	17208584.0
2010-08-23 12:00:00	SPY	ETF	107.44	107.765	107.42	107.5799	9978127.0
2010-08-23 13:00:00	SPY	ETF	107.575	107.7	107.41	107.63	9331239.0
2010-08-23 14:00:00	SPY	ETF	107.62	107.95	107.57	107.69	13210376.0
2010-08-23 15:00:00	SPY	ETF	107.69	107.81	107.07	107.12	38102308.0
2010-08-23 16:00:00	SPY	ETF	107.12	108.4	107.0	107.07	9336443.0
2010-08-23 17:00:00	SPY	ETF	107.08	107.5455	107.04	107.05	4127265.0
2010-08-23 18:00:00	SPY	ETF	107.09	107.13	106.93	106.94	212059.0
2010-08-23 19:00:00	SPY	ETF	106.94	106.96	106.67	106.75	182433.0
2010-08-23 04:00:00	QQQ	ETF	45.0	45.05	45.0	45.05	200.0
2010-08-23 05:00:00	QQQ	ETF	45.17	45.17	45.13	45.13	3300.0
2010-08-23 06:00:00	QQQ	ETF	45.18	45.2	45.18	45.2	10300.0
2010-08-23 07:00:00	QQQ	ETF	45.22	45.26	45.17	45.24	44946.0
2010-08-23 08:00:00	QQQ	ETF	45.24	45.27	45.13	45.13	231604.0
2010-08-23 09:00:00	QQQ	ETF	45.13	45.34	45.09	45.23	8861319.0
2010-08-23 10:00:00	QQQ	ETF	45.22	45.23	44.61	44.68	14582626.0
2010-08-23 11:00:00	QQQ	ETF	44.68	44.6999	44.53	44.62	6849308.0
2010-08-23 12:00:00	QQQ	ETF	44.6202	44.75	44.61	44.6401	3976866.0
2010-08-23 13:00:00	QQQ	ETF	44.64	44.71	44.56	44.6881	3520605.0
2010-08-23 14:00:00	QQQ	ETF	44.68	44.8	44.64	44.66	7967101.0
2010-08-23 15:00:00	QQQ	ETF	44.66	44.74	44.46	44.47	9554012.0
2010-08-23 16:00:00	QQQ	ETF	44.47	45.22	44.42	44.51	6058748.0
2010-08-23 17:00:00	QQQ	ETF	44.914	44.914	44.47	44.5	6014724.0
2010-08-23 18:00:00	QQQ	ETF	44.53	44.53	44.45	44.46	45993.0
2010-08-23 19:00:00	QQQ	ETF	44.46	44.47	44.37	44.39	43285.0
2010-08-23 20:00:00	QQQ	ETF	44.39	44.39	44.39	44.39	287.0
2010-08-23 06:00:00	IWM	ETF	61.61	61.63	61.61	61.62	1300.0
2010-08-23 07:00:00	IWM	ETF	61.62	61.72	61.61	61.72	28370.0
2010-08-23 08:00:00	IWM	ETF	61.69	61.73	61.49	61.49	47597.0
2010-08-23 09:00:00	IWM	ETF	61.49	61.92	61.42	61.61	5886755.0
2010-08-23 10:00:00	IWM	ETF	61.61	61.63	60.75	60.89	7196834.0
2010-08-23 11:00:00	IWM	ETF	60.89	60.89	60.48	60.64	5585897.0
2010-08-23 12:00:00	IWM	ETF	60.64	61.12	60.64	60.9	3194907.0
2010-08-23 13:00:00	IWM	ETF	60.9	61.06	60.7399	60.88	2968083.0
2010-08-23 14:00:00	IWM	ETF	60.8701	61.28	60.78	60.81	5366273.0
2010-08-23 15:00:00	IWM	ETF	60.81	60.935	60.28	60.3	11286634.0
2010-08-23 16:00:00	IWM	ETF	60.31	61.8	60.2	60.28	8309028.0
2010-08-23 17:00:00	IWM	ETF	60.27	61.1289	60.25	60.28	505619.0
2010-08-23 18:00:00	IWM	ETF	60.26	60.29	60.22	60.22	8900.0
2010-08-23 19:00:00	IWM	ETF	60.23	60.23	60.09	60.1	19000.0
2010-08-23 04:00:00	DIA	ETF	102.35	102.47	102.35	102.47	7500.0
2010-08-23 05:00:00	DIA	ETF	102.49	102.51	102.49	102.51	3000.0
2010-08-23 06:00:00	DIA	ETF	102.53	102.61	102.5	102.61	3600.0

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

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