PREVIEW / etf_1hour / 2010-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-12.parquet
  size:    154 KB
  rows:    4,759

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-12 04:00:00	SPY	ETF	107.33	107.37	107.15	107.21	10050.0
2010-07-12 05:00:00	SPY	ETF	107.18	107.28	107.14	107.26	20100.0
2010-07-12 06:00:00	SPY	ETF	107.29	107.35	107.2	107.3	49199.0
2010-07-12 07:00:00	SPY	ETF	107.3	107.48	107.26	107.42	113245.0
2010-07-12 08:00:00	SPY	ETF	107.42	107.62	107.13	107.57	613616.0
2010-07-12 09:00:00	SPY	ETF	107.57	108.24	107.47	108.12	22519129.0
2010-07-12 10:00:00	SPY	ETF	108.12	108.18	107.49	107.64	20921713.0
2010-07-12 11:00:00	SPY	ETF	107.63	107.63	107.15	107.48	16637612.0
2010-07-12 12:00:00	SPY	ETF	107.48	107.95	107.475	107.6	12368487.0
2010-07-12 13:00:00	SPY	ETF	107.59	108.07	107.52	108.0295	11959003.0
2010-07-12 14:00:00	SPY	ETF	108.025	108.06	107.67	107.87	11416717.0
2010-07-12 15:00:00	SPY	ETF	107.87	108.09	107.64	108.02	24268882.0
2010-07-12 16:00:00	SPY	ETF	108.02	108.39	107.275	108.39	6439816.0
2010-07-12 17:00:00	SPY	ETF	108.4	108.6	108.37	108.44	389471.0
2010-07-12 18:00:00	SPY	ETF	108.4	108.41	108.03	108.39	245010.0
2010-07-12 19:00:00	SPY	ETF	108.41	108.49	108.39	108.49	76795.0
2010-07-12 05:00:00	QQQ	ETF	44.4	44.4	44.4	44.4	200.0
2010-07-12 06:00:00	QQQ	ETF	44.43	44.43	44.39	44.39	500.0
2010-07-12 07:00:00	QQQ	ETF	44.44	44.49	44.42	44.49	29513.0
2010-07-12 08:00:00	QQQ	ETF	44.47	44.62	44.46	44.57	255536.0
2010-07-12 09:00:00	QQQ	ETF	44.57	45.03	44.53	44.97	11724055.0
2010-07-12 10:00:00	QQQ	ETF	44.97	45.0	44.59	44.66	10507352.0
2010-07-12 11:00:00	QQQ	ETF	44.66	44.66	44.46	44.48	7068703.0
2010-07-12 12:00:00	QQQ	ETF	44.48	44.72	44.47	44.55	4821821.0
2010-07-12 13:00:00	QQQ	ETF	44.55	44.81	44.525	44.78	5850601.0
2010-07-12 14:00:00	QQQ	ETF	44.78	44.81	44.64	44.72	5159484.0
2010-07-12 15:00:00	QQQ	ETF	44.72	44.83	44.61	44.75	10796708.0
2010-07-12 16:00:00	QQQ	ETF	44.75	44.92	44.54	44.92	2672193.0
2010-07-12 17:00:00	QQQ	ETF	44.93	44.98	44.9	44.91	64341.0
2010-07-12 18:00:00	QQQ	ETF	44.92	44.93	44.9	44.92	13920.0
2010-07-12 19:00:00	QQQ	ETF	44.92	44.95	44.91	44.95	21250.0
2010-07-12 04:00:00	IWM	ETF	62.38	62.38	62.38	62.38	600.0
2010-07-12 06:00:00	IWM	ETF	62.39	62.46	62.37	62.46	3300.0
2010-07-12 07:00:00	IWM	ETF	62.49	62.57	62.49	62.54	16300.0
2010-07-12 08:00:00	IWM	ETF	62.53	62.7	62.52	62.69	176914.0
2010-07-12 09:00:00	IWM	ETF	62.68	63.18	62.47	62.96	5671157.0
2010-07-12 10:00:00	IWM	ETF	62.96	63.02	62.05	62.11	9486608.0
2010-07-12 11:00:00	IWM	ETF	62.11	62.11	61.62	61.92	6883650.0
2010-07-12 12:00:00	IWM	ETF	61.92	62.37	61.92	62.0199	3581022.0
2010-07-12 13:00:00	IWM	ETF	62.01	62.485	61.875	62.45	3988599.0
2010-07-12 14:00:00	IWM	ETF	62.44	62.48	62.085	62.3	2799121.0
2010-07-12 15:00:00	IWM	ETF	62.3	62.41	62.04	62.22	6810337.0
2010-07-12 16:00:00	IWM	ETF	62.23	62.55	62.1453	62.49	892097.0
2010-07-12 17:00:00	IWM	ETF	62.59	62.64	62.55	62.61	70375.0
2010-07-12 18:00:00	IWM	ETF	62.59	62.64	62.53	62.58	3598.0
2010-07-12 19:00:00	IWM	ETF	62.57	62.64	62.57	62.6	2200.0
2010-07-12 07:00:00	DIA	ETF	101.7	101.7	101.7	101.7	200.0
2010-07-12 08:00:00	DIA	ETF	101.7	101.87	101.7	101.83	13050.0
2010-07-12 09:00:00	DIA	ETF	101.85	102.27	101.73	102.22	1388308.0
2010-07-12 10:00:00	DIA	ETF	102.23	102.27	101.79	101.9	1209137.0

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

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