PREVIEW / etf_1hour / 2010-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-11.parquet
  size:    154 KB
  rows:    4,723

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-06-11 04:00:00	SPY	ETF	108.7	108.99	108.7	108.99	2480.0
2010-06-11 05:00:00	SPY	ETF	109.03	109.15	109.0	109.15	2825.0
2010-06-11 06:00:00	SPY	ETF	109.13	109.18	108.96	108.96	8650.0
2010-06-11 07:00:00	SPY	ETF	108.96	109.06	108.82	108.93	592544.0
2010-06-11 08:00:00	SPY	ETF	108.93	109.1	108.0	108.03	5598734.0
2010-06-11 09:00:00	SPY	ETF	108.05	108.93	107.98	108.9	34737205.0
2010-06-11 10:00:00	SPY	ETF	108.89	109.4	108.71	108.82	36878177.0
2010-06-11 11:00:00	SPY	ETF	108.801	109.2	108.42	108.99	25440221.0
2010-06-11 12:00:00	SPY	ETF	108.99	109.02	108.6	108.87	12447920.0
2010-06-11 13:00:00	SPY	ETF	108.86	109.2	108.7	108.78	15428161.0
2010-06-11 14:00:00	SPY	ETF	108.79	109.01	108.51	108.84	18328179.0
2010-06-11 15:00:00	SPY	ETF	108.84	109.75	108.71	109.66	39896201.0
2010-06-11 16:00:00	SPY	ETF	109.65	109.6867	108.3097	109.54	23850109.0
2010-06-11 17:00:00	SPY	ETF	109.52	109.56	109.43	109.46	188122.0
2010-06-11 18:00:00	SPY	ETF	109.45	109.68	109.44	109.47	38099.0
2010-06-11 19:00:00	SPY	ETF	109.48	109.51	109.45	109.51	28852.0
2010-06-11 04:00:00	QQQ	ETF	44.86	44.86	44.86	44.86	398.0
2010-06-11 05:00:00	QQQ	ETF	44.96	45.03	44.96	45.03	1500.0
2010-06-11 06:00:00	QQQ	ETF	44.99	45.04	44.99	45.04	6300.0
2010-06-11 07:00:00	QQQ	ETF	44.96	44.99	44.88	44.95	101306.0
2010-06-11 08:00:00	QQQ	ETF	44.93	44.98	44.4	44.55	1365863.0
2010-06-11 09:00:00	QQQ	ETF	44.55	45.07	44.53	45.04	11405586.0
2010-06-11 10:00:00	QQQ	ETF	45.04	45.39	44.95	45.07	14402568.0
2010-06-11 11:00:00	QQQ	ETF	45.08	45.25	44.83	45.1599	10236662.0
2010-06-11 12:00:00	QQQ	ETF	45.16	45.18	44.99	45.12	4508849.0
2010-06-11 13:00:00	QQQ	ETF	45.12	45.31	45.0	45.07	7540386.0
2010-06-11 14:00:00	QQQ	ETF	45.07	45.2	44.92	45.11	4976875.0
2010-06-11 15:00:00	QQQ	ETF	45.12	45.54	45.07	45.48	15796021.0
2010-06-11 16:00:00	QQQ	ETF	45.48	45.5	45.0752	45.43	2498039.0
2010-06-11 17:00:00	QQQ	ETF	45.44	45.46	45.42	45.42	31305.0
2010-06-11 18:00:00	QQQ	ETF	45.45	45.46	45.38	45.44	54190.0
2010-06-11 19:00:00	QQQ	ETF	45.42	45.46	45.42	45.46	7000.0
2010-06-11 05:00:00	IWM	ETF	63.92	63.92	63.91	63.91	2500.0
2010-06-11 06:00:00	IWM	ETF	63.95	63.95	63.95	63.95	1200.0
2010-06-11 07:00:00	IWM	ETF	63.9	63.91	63.79	63.89	40060.0
2010-06-11 08:00:00	IWM	ETF	63.85	64.09	63.12	63.17	660837.0
2010-06-11 09:00:00	IWM	ETF	63.12	64.4	63.12	64.39	9864985.0
2010-06-11 10:00:00	IWM	ETF	64.38	64.77	64.2	64.22	11520100.0
2010-06-11 11:00:00	IWM	ETF	64.22	64.4	63.92	64.33	7677958.0
2010-06-11 12:00:00	IWM	ETF	64.33	64.37	64.09	64.33	3408893.0
2010-06-11 13:00:00	IWM	ETF	64.34	64.63	64.06	64.17	6085590.0
2010-06-11 14:00:00	IWM	ETF	64.17	64.37	63.95	64.21	5598908.0
2010-06-11 15:00:00	IWM	ETF	64.21	65.03	64.09	64.99	12302546.0
2010-06-11 16:00:00	IWM	ETF	64.99	65.019	64.1009	64.97	4966304.0
2010-06-11 17:00:00	IWM	ETF	65.0	65.0	64.86	64.86	51434.0
2010-06-11 18:00:00	IWM	ETF	64.94	64.95	64.87	64.95	2694.0
2010-06-11 19:00:00	IWM	ETF	64.96	64.98	64.96	64.96	1186.0
2010-06-11 07:00:00	DIA	ETF	101.73	101.73	101.7	101.7	1700.0
2010-06-11 08:00:00	DIA	ETF	101.69	101.76	100.95	100.95	58450.0
2010-06-11 09:00:00	DIA	ETF	100.98	101.64	100.95	101.62	1607737.0

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

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