PREVIEW / etf_1hour / 2010-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-22.parquet
  size:    160 KB
  rows:    4,881

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-07-22 04:00:00	SPY	ETF	107.21	108.01	107.18	107.95	12736.0
2010-07-22 05:00:00	SPY	ETF	108.0	108.26	107.9	108.21	29100.0
2010-07-22 06:00:00	SPY	ETF	108.17	108.36	108.0	108.23	136883.0
2010-07-22 07:00:00	SPY	ETF	108.26	108.31	108.1	108.15	3011554.0
2010-07-22 08:00:00	SPY	ETF	108.26	108.38	107.58	108.36	6076995.0
2010-07-22 09:00:00	SPY	ETF	108.38	109.12	108.28	109.07	37475291.0
2010-07-22 10:00:00	SPY	ETF	109.07	109.85	109.06	109.64	49372435.0
2010-07-22 11:00:00	SPY	ETF	109.64	109.82	109.25	109.38	31245381.0
2010-07-22 12:00:00	SPY	ETF	109.38	109.58	109.32	109.56	16392241.0
2010-07-22 13:00:00	SPY	ETF	109.56	109.75	109.45	109.53	11745445.0
2010-07-22 14:00:00	SPY	ETF	109.53	109.94	109.53	109.78	21345484.0
2010-07-22 15:00:00	SPY	ETF	109.77	109.93	109.06	109.46	59971417.0
2010-07-22 16:00:00	SPY	ETF	109.46	109.8	108.545	109.2	26577256.0
2010-07-22 17:00:00	SPY	ETF	109.18	109.39	109.17	109.36	2275552.0
2010-07-22 18:00:00	SPY	ETF	109.36	109.48	109.29	109.39	163385.0
2010-07-22 19:00:00	SPY	ETF	109.38	109.65	109.33	109.61	157676.0
2010-07-22 04:00:00	QQQ	ETF	44.7	45.01	44.7	45.01	786.0
2010-07-22 05:00:00	QQQ	ETF	45.23	45.23	45.23	45.23	100.0
2010-07-22 06:00:00	QQQ	ETF	45.14	45.2	45.09	45.16	12300.0
2010-07-22 07:00:00	QQQ	ETF	45.15	45.2	45.13	45.13	176796.0
2010-07-22 08:00:00	QQQ	ETF	44.95	45.2	44.95	45.2	708265.0
2010-07-22 09:00:00	QQQ	ETF	45.2	45.54	45.18	45.49	13662055.0
2010-07-22 10:00:00	QQQ	ETF	45.49	45.98	45.49	45.88	16795881.0
2010-07-22 11:00:00	QQQ	ETF	45.89	45.94	45.65	45.71	7594801.0
2010-07-22 12:00:00	QQQ	ETF	45.71	45.79	45.65	45.7599	5082266.0
2010-07-22 13:00:00	QQQ	ETF	45.76	45.86	45.7	45.7301	3816451.0
2010-07-22 14:00:00	QQQ	ETF	45.74	45.92	45.73	45.87	5510577.0
2010-07-22 15:00:00	QQQ	ETF	45.88	45.97	45.62	45.77	13062033.0
2010-07-22 16:00:00	QQQ	ETF	45.77	45.8937	44.6697	45.47	6117597.0
2010-07-22 17:00:00	QQQ	ETF	45.5	45.55	44.6697	45.53	2026337.0
2010-07-22 18:00:00	QQQ	ETF	45.53	45.58	45.53	45.57	50900.0
2010-07-22 19:00:00	QQQ	ETF	45.58	45.7	45.58	45.69	38550.0
2010-07-22 04:00:00	IWM	ETF	61.81	61.81	61.81	61.81	268.0
2010-07-22 05:00:00	IWM	ETF	62.16	62.16	62.16	62.16	600.0
2010-07-22 06:00:00	IWM	ETF	62.14	62.27	62.14	62.26	2900.0
2010-07-22 07:00:00	IWM	ETF	62.21	62.24	62.05	62.14	202989.0
2010-07-22 08:00:00	IWM	ETF	62.14	62.2	61.94	62.12	868129.0
2010-07-22 09:00:00	IWM	ETF	62.12	62.72	62.09	62.66	9504119.0
2010-07-22 10:00:00	IWM	ETF	62.67	63.41	62.66	63.1999	15882307.0
2010-07-22 11:00:00	IWM	ETF	63.19	63.31	62.88	62.96	4899431.0
2010-07-22 12:00:00	IWM	ETF	62.95	63.16	62.89	63.14	4643276.0
2010-07-22 13:00:00	IWM	ETF	63.15	63.25	63.01	63.08	2901105.0
2010-07-22 14:00:00	IWM	ETF	63.09	63.515	63.085	63.43	5904792.0
2010-07-22 15:00:00	IWM	ETF	63.44	63.66	62.95	63.44	15870761.0
2010-07-22 16:00:00	IWM	ETF	63.44	63.5625	61.2572	63.28	9823587.0
2010-07-22 17:00:00	IWM	ETF	63.27	63.37	61.2572	61.2572	3056760.0
2010-07-22 18:00:00	IWM	ETF	63.34	63.37	63.3	63.32	22500.0
2010-07-22 19:00:00	IWM	ETF	63.39	63.45	63.31	63.43	19334.0
2010-07-22 06:00:00	DIA	ETF	102.14	102.14	102.09	102.09	900.0
2010-07-22 07:00:00	DIA	ETF	102.19	102.23	102.11	102.14	15200.0

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

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