PREVIEW / etf_1hour / 2007-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-07.parquet
  size:    68 KB
  rows:    2,325

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-05-07 06:00:00	SPY	ETF	150.92	150.92	150.87	150.87	11900.0
2007-05-07 07:00:00	SPY	ETF	150.87	151.02	150.87	150.95	139700.0
2007-05-07 08:00:00	SPY	ETF	150.9	151.02	150.86	150.89	1604700.0
2007-05-07 09:00:00	SPY	ETF	150.88	151.2	150.8	151.05	15120934.0
2007-05-07 10:00:00	SPY	ETF	151.06	151.11	150.84	150.99	13507138.0
2007-05-07 11:00:00	SPY	ETF	151.0	151.07	150.91	150.97	7010203.0
2007-05-07 12:00:00	SPY	ETF	150.98	151.09	150.91	150.98	4705550.0
2007-05-07 13:00:00	SPY	ETF	150.97	151.06	150.88	150.99	3927701.0
2007-05-07 14:00:00	SPY	ETF	151.0	151.05	150.97	151.02	4059796.0
2007-05-07 15:00:00	SPY	ETF	151.03	151.03	150.88	150.96	9528987.0
2007-05-07 16:00:00	SPY	ETF	150.95	151.0185	150.87	150.88	2647000.0
2007-05-07 17:00:00	SPY	ETF	150.94	150.94	150.85	150.91	521300.0
2007-05-07 18:00:00	SPY	ETF	150.91	150.91	150.86	150.9	224800.0
2007-05-07 19:00:00	SPY	ETF	150.9	150.93	150.9	150.93	1500.0
2007-05-07 07:00:00	QQQ	ETF	46.68	46.7	46.64	46.64	91112.0
2007-05-07 08:00:00	QQQ	ETF	46.65	46.7	46.64	46.66	195267.0
2007-05-07 09:00:00	QQQ	ETF	46.66	46.78	46.62	46.71	13062974.0
2007-05-07 10:00:00	QQQ	ETF	46.71	46.76	46.65	46.71	9697587.0
2007-05-07 11:00:00	QQQ	ETF	46.72	46.73	46.68	46.71	3538838.0
2007-05-07 12:00:00	QQQ	ETF	46.72	46.7399	46.66	46.68	3679695.0
2007-05-07 13:00:00	QQQ	ETF	46.68	46.71	46.62	46.69	3265121.0
2007-05-07 14:00:00	QQQ	ETF	46.68	46.71	46.66	46.68	1542532.0
2007-05-07 15:00:00	QQQ	ETF	46.69	46.69	46.57	46.61	9271526.0
2007-05-07 16:00:00	QQQ	ETF	46.62	46.76	46.61	46.64	1998970.0
2007-05-07 17:00:00	QQQ	ETF	46.64	46.65	46.59	46.59	429170.0
2007-05-07 18:00:00	QQQ	ETF	46.61	46.62	46.59	46.59	180100.0
2007-05-07 19:00:00	QQQ	ETF	46.59	46.62	46.58	46.61	12969.0
2007-05-07 07:00:00	IWM	ETF	82.71	82.8	82.71	82.8	3100.0
2007-05-07 08:00:00	IWM	ETF	82.8	82.84	82.68	82.71	159700.0
2007-05-07 09:00:00	IWM	ETF	82.72	87.7	82.66	82.81	6203090.0
2007-05-07 10:00:00	IWM	ETF	82.8	82.81	82.58	82.73	5708213.0
2007-05-07 11:00:00	IWM	ETF	82.73	82.83	82.6	82.75	3587038.0
2007-05-07 12:00:00	IWM	ETF	82.75	82.8	82.66	82.68	2455828.0
2007-05-07 13:00:00	IWM	ETF	82.69	82.69	82.53	82.62	4232904.0
2007-05-07 14:00:00	IWM	ETF	82.62	82.69	82.59	82.63	3955810.0
2007-05-07 15:00:00	IWM	ETF	82.62	82.65	82.47	82.6	9028584.0
2007-05-07 16:00:00	IWM	ETF	82.6	82.83	82.49	82.56	1538800.0
2007-05-07 18:00:00	IWM	ETF	82.47	82.47	82.45	82.45	2300.0
2007-05-07 19:00:00	IWM	ETF	82.43	82.43	82.42	82.42	5000.0
2007-05-07 07:00:00	DIA	ETF	132.74	132.82	132.74	132.82	6100.0
2007-05-07 08:00:00	DIA	ETF	132.76	132.87	132.75	132.79	375400.0
2007-05-07 09:00:00	DIA	ETF	132.84	133.05	132.79	132.92	1384620.0
2007-05-07 10:00:00	DIA	ETF	132.94	132.95	132.74	132.83	2865775.0
2007-05-07 11:00:00	DIA	ETF	132.84	133.01	132.82	132.97	651598.0
2007-05-07 12:00:00	DIA	ETF	132.97	133.09	132.94	132.97	532895.0
2007-05-07 13:00:00	DIA	ETF	132.96	133.11	132.91	133.06	454200.0
2007-05-07 14:00:00	DIA	ETF	133.05	133.13	133.01	133.12	508956.0
2007-05-07 15:00:00	DIA	ETF	133.13	133.13	132.97	133.03	1197650.0
2007-05-07 16:00:00	DIA	ETF	133.02	133.05	132.8022	133.0	222000.0
2007-05-07 17:00:00	DIA	ETF	133.0	133.0	132.98	132.98	167200.0

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

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