PREVIEW / etf_1hour / 2010-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-20.parquet
  size:    163 KB
  rows:    4,932

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-20 04:00:00	SPY	ETF	106.6	106.69	106.52	106.66	7200.0
2010-07-20 05:00:00	SPY	ETF	106.7	106.7	106.05	106.05	3500.0
2010-07-20 06:00:00	SPY	ETF	106.08	106.08	105.83	106.08	47226.0
2010-07-20 07:00:00	SPY	ETF	106.08	106.2	105.86	106.1	887683.0
2010-07-20 08:00:00	SPY	ETF	106.1	106.16	105.62	106.02	6718403.0
2010-07-20 09:00:00	SPY	ETF	106.01	106.48	105.82	106.35	30549196.0
2010-07-20 10:00:00	SPY	ETF	106.36	106.7	106.03	106.52	34889620.0
2010-07-20 11:00:00	SPY	ETF	106.52	107.05	106.45	106.6699	27554626.0
2010-07-20 12:00:00	SPY	ETF	106.66	106.92	106.51	106.89	11119267.0
2010-07-20 13:00:00	SPY	ETF	106.88	108.0	106.82	107.97	30138664.0
2010-07-20 14:00:00	SPY	ETF	107.96	108.0	107.55	107.75	30916442.0
2010-07-20 15:00:00	SPY	ETF	107.76	108.56	107.65	108.47	59219952.0
2010-07-20 16:00:00	SPY	ETF	108.47	109.05	106.185	108.7	21266441.0
2010-07-20 17:00:00	SPY	ETF	108.7	108.74	107.2712	108.65	4634663.0
2010-07-20 18:00:00	SPY	ETF	108.64	108.66	108.48	108.53	329616.0
2010-07-20 19:00:00	SPY	ETF	108.53	108.7	108.53	108.63	28135.0
2010-07-20 04:00:00	QQQ	ETF	44.3	44.33	44.3	44.33	3400.0
2010-07-20 05:00:00	QQQ	ETF	44.25	44.26	44.11	44.11	1360.0
2010-07-20 06:00:00	QQQ	ETF	44.1	44.1	43.95	44.06	2600.0
2010-07-20 07:00:00	QQQ	ETF	44.07	44.11	44.0	44.1	80530.0
2010-07-20 08:00:00	QQQ	ETF	44.1	44.4	43.88	44.08	1790006.0
2010-07-20 09:00:00	QQQ	ETF	44.07	44.13	43.86	44.08	11280271.0
2010-07-20 10:00:00	QQQ	ETF	44.08	44.31	43.9	44.23	15320016.0
2010-07-20 11:00:00	QQQ	ETF	44.23	44.49	44.2123	44.34	6207408.0
2010-07-20 12:00:00	QQQ	ETF	44.3429	44.48	44.29	44.47	5775834.0
2010-07-20 13:00:00	QQQ	ETF	44.48	44.93	44.44	44.91	11728934.0
2010-07-20 14:00:00	QQQ	ETF	44.92	44.97	44.745	44.85	8305289.0
2010-07-20 15:00:00	QQQ	ETF	44.86	45.26	44.82	45.25	17516026.0
2010-07-20 16:00:00	QQQ	ETF	45.24	45.7	44.2	45.56	6385366.0
2010-07-20 17:00:00	QQQ	ETF	45.55	45.6	45.47	45.47	339390.0
2010-07-20 18:00:00	QQQ	ETF	45.5	45.53	45.47	45.5	29132.0
2010-07-20 19:00:00	QQQ	ETF	45.52	45.55	45.5	45.54	18233.0
2010-07-20 04:00:00	IWM	ETF	60.94	61.03	60.94	61.03	600.0
2010-07-20 05:00:00	IWM	ETF	60.53	60.53	60.53	60.53	1400.0
2010-07-20 06:00:00	IWM	ETF	60.55	60.55	60.35	60.52	1300.0
2010-07-20 07:00:00	IWM	ETF	60.51	60.62	60.38	60.53	86695.0
2010-07-20 08:00:00	IWM	ETF	60.49	61.1	60.24	60.49	582042.0
2010-07-20 09:00:00	IWM	ETF	60.47	60.83	60.21	60.65	8431683.0
2010-07-20 10:00:00	IWM	ETF	60.64	61.0	60.39	60.885	9767672.0
2010-07-20 11:00:00	IWM	ETF	60.89	61.21	60.84	60.94	9523178.0
2010-07-20 12:00:00	IWM	ETF	60.94	61.1	60.76	60.985	5259287.0
2010-07-20 13:00:00	IWM	ETF	61.01	61.77	60.91	61.7	6802719.0
2010-07-20 14:00:00	IWM	ETF	61.7	61.73	61.39	61.56	5356634.0
2010-07-20 15:00:00	IWM	ETF	61.57	62.47	61.5	62.36	17927770.0
2010-07-20 16:00:00	IWM	ETF	62.37	62.76	61.2983	62.51	2894874.0
2010-07-20 17:00:00	IWM	ETF	62.51	62.54	62.42	62.47	14500.0
2010-07-20 18:00:00	IWM	ETF	62.53	62.55	62.53	62.55	400.0
2010-07-20 19:00:00	IWM	ETF	62.52	62.54	62.48	62.54	3392.0
2010-07-20 07:00:00	DIA	ETF	100.5	100.55	100.27	100.33	14380.0
2010-07-20 08:00:00	DIA	ETF	100.41	100.5	100.05	100.42	105965.0

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

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