PREVIEW / etf_1hour / 2007-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-27.parquet
  size:    84 KB
  rows:    2,873

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
2007-09-27 04:00:00	SPY	ETF	152.97	152.99	152.85	152.85	2700.0
2007-09-27 06:00:00	SPY	ETF	152.85	152.85	152.79	152.82	6500.0
2007-09-27 07:00:00	SPY	ETF	152.84	152.84	152.5	152.65	362700.0
2007-09-27 08:00:00	SPY	ETF	152.63	152.88	152.51	152.86	2446400.0
2007-09-27 09:00:00	SPY	ETF	152.86	152.98	152.59	152.64	11489774.0
2007-09-27 10:00:00	SPY	ETF	152.64	152.92	152.42	152.84	26246900.0
2007-09-27 11:00:00	SPY	ETF	152.85	152.89	152.35	152.5	10323300.0
2007-09-27 12:00:00	SPY	ETF	152.501	152.7	152.4	152.59	5472900.0
2007-09-27 13:00:00	SPY	ETF	152.6	152.79	152.46	152.64	8337700.0
2007-09-27 14:00:00	SPY	ETF	152.63	152.96	152.53	152.73	12051200.0
2007-09-27 15:00:00	SPY	ETF	152.74	153.08	152.73	152.95	17774900.0
2007-09-27 16:00:00	SPY	ETF	152.96	153.31	152.35	152.96	6462700.0
2007-09-27 17:00:00	SPY	ETF	152.92	153.09	152.9	152.97	154800.0
2007-09-27 18:00:00	SPY	ETF	152.97	152.99	152.92	152.92	13200.0
2007-09-27 19:00:00	SPY	ETF	152.95	152.97	152.92	152.97	4500.0
2007-09-27 07:00:00	QQQ	ETF	51.39	51.58	51.36	51.56	255408.0
2007-09-27 08:00:00	QQQ	ETF	51.52	51.62	51.5	51.62	1298661.0
2007-09-27 09:00:00	QQQ	ETF	51.62	51.65	51.44	51.46	12654984.0
2007-09-27 10:00:00	QQQ	ETF	51.45	51.62	51.36	51.6	15935572.0
2007-09-27 11:00:00	QQQ	ETF	51.5987	51.6	51.41	51.4425	7474867.0
2007-09-27 12:00:00	QQQ	ETF	51.4475	51.54	51.43	51.5	5711489.0
2007-09-27 13:00:00	QQQ	ETF	51.5	51.57	51.41	51.47	6291165.0
2007-09-27 14:00:00	QQQ	ETF	51.47	51.6	51.47	51.5	8872292.0
2007-09-27 15:00:00	QQQ	ETF	51.5	51.58	51.47	51.52	12092545.0
2007-09-27 16:00:00	QQQ	ETF	51.53	51.65	51.385	51.57	2471615.0
2007-09-27 17:00:00	QQQ	ETF	51.55	51.59	51.52	51.52	346446.0
2007-09-27 18:00:00	QQQ	ETF	51.54	51.55	51.51	51.55	179926.0
2007-09-27 19:00:00	QQQ	ETF	51.52	51.54	51.51	51.54	5200.0
2007-09-27 06:00:00	IWM	ETF	80.76	80.77	80.76	80.77	20000.0
2007-09-27 07:00:00	IWM	ETF	80.5	80.65	80.5	80.65	18200.0
2007-09-27 08:00:00	IWM	ETF	80.58	80.85	80.57	80.83	599100.0
2007-09-27 09:00:00	IWM	ETF	80.83	80.96	80.61	80.65	5812000.0
2007-09-27 10:00:00	IWM	ETF	80.65	80.9	80.58	80.8	11049700.0
2007-09-27 11:00:00	IWM	ETF	80.8	80.87	80.54	80.67	5138100.0
2007-09-27 12:00:00	IWM	ETF	80.66	80.86	80.65	80.75	3020400.0
2007-09-27 13:00:00	IWM	ETF	80.76	80.86	80.63	80.7	3795700.0
2007-09-27 14:00:00	IWM	ETF	80.7	81.02	80.68	80.91	7871100.0
2007-09-27 15:00:00	IWM	ETF	80.91	81.08	80.83	80.93	9968600.0
2007-09-27 16:00:00	IWM	ETF	80.93	81.01	80.82	80.94	15968100.0
2007-09-27 17:00:00	IWM	ETF	80.95	80.95	80.95	80.95	700.0
2007-09-27 18:00:00	IWM	ETF	80.86	80.86	80.86	80.86	100.0
2007-09-27 08:00:00	DIA	ETF	138.94	139.1	138.93	139.06	38000.0
2007-09-27 09:00:00	DIA	ETF	139.12	139.13	138.78	138.82	1476600.0
2007-09-27 10:00:00	DIA	ETF	138.81	138.99	138.62	138.92	1865700.0
2007-09-27 11:00:00	DIA	ETF	138.93	138.95	138.55	138.65	798800.0
2007-09-27 12:00:00	DIA	ETF	138.65	138.82	138.56	138.74	382300.0
2007-09-27 13:00:00	DIA	ETF	138.72	138.84	138.55	138.69	1973800.0
2007-09-27 14:00:00	DIA	ETF	138.66	138.93	138.63	138.78	564400.0
2007-09-27 15:00:00	DIA	ETF	138.78	139.03	138.78	139.0	1770500.0
2007-09-27 16:00:00	DIA	ETF	139.01	139.13	138.99	139.0	78000.0

> showing 50 of 2,873 rows — these rows as CSV

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