PREVIEW / etf_1hour / 2009-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-12.parquet
  size:    134 KB
  rows:    4,150

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
2009-06-12 05:00:00	SPY	ETF	94.83	94.83	94.57	94.57	3914.0
2009-06-12 06:00:00	SPY	ETF	94.56	94.71	94.56	94.71	50219.0
2009-06-12 07:00:00	SPY	ETF	94.67	94.67	94.22	94.45	494409.0
2009-06-12 08:00:00	SPY	ETF	94.65	94.85	94.09	94.22	2884142.0
2009-06-12 09:00:00	SPY	ETF	94.22	94.52	94.1174	94.21	25019280.0
2009-06-12 10:00:00	SPY	ETF	94.21	94.8	94.0	94.62	37482623.0
2009-06-12 11:00:00	SPY	ETF	94.62	94.68	94.29	94.38	14736775.0
2009-06-12 12:00:00	SPY	ETF	94.38	94.9521	94.2926	94.55	17258200.0
2009-06-12 13:00:00	SPY	ETF	94.56	94.74	94.41	94.6701	18881199.0
2009-06-12 14:00:00	SPY	ETF	94.6701	95.13	94.51	94.93	26551504.0
2009-06-12 15:00:00	SPY	ETF	94.94	95.13	94.6	95.11	32326368.0
2009-06-12 16:00:00	SPY	ETF	95.12	95.13	94.5977	94.84	7913892.0
2009-06-12 17:00:00	SPY	ETF	94.83	94.98	94.81	94.98	78024.0
2009-06-12 18:00:00	SPY	ETF	94.96	94.98	94.9	94.95	14719.0
2009-06-12 19:00:00	SPY	ETF	94.94	94.98	94.88	94.91	7293.0
2009-06-12 04:00:00	QQQ	ETF	36.87	36.87	36.87	36.87	200.0
2009-06-12 05:00:00	QQQ	ETF	36.9	36.9	36.79	36.79	3441.0
2009-06-12 06:00:00	QQQ	ETF	36.82	36.83	36.77	36.82	135595.0
2009-06-12 07:00:00	QQQ	ETF	36.82	36.82	36.61	36.65	321132.0
2009-06-12 08:00:00	QQQ	ETF	36.66	36.79	36.58	36.65	1060604.0
2009-06-12 09:00:00	QQQ	ETF	36.65	36.719	36.33	36.39	14118060.0
2009-06-12 10:00:00	QQQ	ETF	36.39	36.56	36.2	36.42	27256008.0
2009-06-12 11:00:00	QQQ	ETF	36.42	36.45	36.25	36.299	8004992.0
2009-06-12 12:00:00	QQQ	ETF	36.29	36.41	36.27	36.41	5207851.0
2009-06-12 13:00:00	QQQ	ETF	36.41	36.44	36.3	36.41	10383766.0
2009-06-12 14:00:00	QQQ	ETF	36.4	36.66	36.35	36.5901	14306101.0
2009-06-12 15:00:00	QQQ	ETF	36.59	36.67	36.46	36.67	17082510.0
2009-06-12 16:00:00	QQQ	ETF	36.67	36.71	36.265	36.59	3782404.0
2009-06-12 17:00:00	QQQ	ETF	36.59	36.63	36.58	36.62	11205.0
2009-06-12 18:00:00	QQQ	ETF	36.61	36.62	36.59	36.61	3255.0
2009-06-12 19:00:00	QQQ	ETF	36.63	36.63	36.61	36.61	21780.0
2009-06-12 06:00:00	IWM	ETF	52.51	52.53	52.51	52.53	2000.0
2009-06-12 07:00:00	IWM	ETF	52.48	52.48	52.3	52.37	19700.0
2009-06-12 08:00:00	IWM	ETF	52.37	52.41	52.13	52.28	249852.0
2009-06-12 09:00:00	IWM	ETF	52.27	52.4	52.06	52.11	4969157.0
2009-06-12 10:00:00	IWM	ETF	52.1	52.33	51.89	52.18	8276641.0
2009-06-12 11:00:00	IWM	ETF	52.18	52.225	51.95	52.0578	2973454.0
2009-06-12 12:00:00	IWM	ETF	52.06	52.26	52.045	52.23	4617351.0
2009-06-12 13:00:00	IWM	ETF	52.24	52.4	52.1	52.37	3139912.0
2009-06-12 14:00:00	IWM	ETF	52.37	52.82	52.26	52.615	5633389.0
2009-06-12 15:00:00	IWM	ETF	52.6226	52.81	52.4	52.77	6573871.0
2009-06-12 16:00:00	IWM	ETF	52.79	52.81	52.6	52.72	3994783.0
2009-06-12 17:00:00	IWM	ETF	52.67	52.67	52.6	52.6	1100.0
2009-06-12 19:00:00	IWM	ETF	52.68	52.69	52.62	52.62	600.0
2009-06-12 06:00:00	DIA	ETF	87.74	87.77	87.74	87.77	2000.0
2009-06-12 07:00:00	DIA	ETF	87.66	87.66	87.49	87.59	7900.0
2009-06-12 08:00:00	DIA	ETF	87.67	87.67	87.3	87.39	31699.0
2009-06-12 09:00:00	DIA	ETF	87.44	87.76	87.43	87.57	1130443.0
2009-06-12 10:00:00	DIA	ETF	87.56	88.05	87.37	87.89	2049394.0
2009-06-12 11:00:00	DIA	ETF	87.9	87.96	87.64	87.73	772616.0

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

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