PREVIEW / etf_1hour / 2007-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-22.parquet
  size:    78 KB
  rows:    2,664

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-22 07:00:00	SPY	ETF	152.83	152.85	152.78	152.82	146200.0
2007-05-22 08:00:00	SPY	ETF	152.75	152.89	152.75	152.79	1003900.0
2007-05-22 09:00:00	SPY	ETF	152.78	152.85	152.45	152.5885	10659890.0
2007-05-22 10:00:00	SPY	ETF	152.59	152.81	152.43	152.67	13572995.0
2007-05-22 11:00:00	SPY	ETF	152.67	152.73	152.4	152.49	7543300.0
2007-05-22 12:00:00	SPY	ETF	152.49	152.98	152.44	152.94	10904395.0
2007-05-22 13:00:00	SPY	ETF	152.94	153.15	152.8	152.97	8219117.0
2007-05-22 14:00:00	SPY	ETF	152.98	153.16	152.87	152.97	9850566.0
2007-05-22 15:00:00	SPY	ETF	152.97	153.04	152.55	152.6	14370024.0
2007-05-22 16:00:00	SPY	ETF	152.61	152.67	152.37	152.39	4134400.0
2007-05-22 17:00:00	SPY	ETF	152.39	152.44	152.37	152.38	15500.0
2007-05-22 18:00:00	SPY	ETF	152.43	152.65	152.43	152.65	101100.0
2007-05-22 19:00:00	SPY	ETF	152.46	152.46	152.42	152.43	29800.0
2007-05-22 07:00:00	QQQ	ETF	47.1	47.11	47.09	47.11	5100.0
2007-05-22 08:00:00	QQQ	ETF	47.09	47.12	47.06	47.06	434149.0
2007-05-22 09:00:00	QQQ	ETF	47.06	47.11	46.94	46.983	14236875.0
2007-05-22 10:00:00	QQQ	ETF	46.99	47.06	46.87	47.0	18742400.0
2007-05-22 11:00:00	QQQ	ETF	47.0	47.04	46.9	46.927	7705423.0
2007-05-22 12:00:00	QQQ	ETF	46.92	47.14	46.91	47.13	7365999.0
2007-05-22 13:00:00	QQQ	ETF	47.13	47.2	47.08	47.15	10188522.0
2007-05-22 14:00:00	QQQ	ETF	47.14	47.28	47.13	47.2474	16166001.0
2007-05-22 15:00:00	QQQ	ETF	47.24	47.26	47.096	47.14	17495162.0
2007-05-22 16:00:00	QQQ	ETF	47.13	47.18	47.0	47.07	4091820.0
2007-05-22 17:00:00	QQQ	ETF	47.07	47.07	47.04	47.05	10972.0
2007-05-22 18:00:00	QQQ	ETF	47.05	47.06	47.04	47.05	101985.0
2007-05-22 19:00:00	QQQ	ETF	47.05	47.05	47.03	47.03	2945.0
2007-05-22 07:00:00	IWM	ETF	82.94	82.94	82.94	82.94	100.0
2007-05-22 08:00:00	IWM	ETF	83.0	83.01	82.91	82.91	38900.0
2007-05-22 09:00:00	IWM	ETF	82.89	83.0	82.62	82.81	5197181.0
2007-05-22 10:00:00	IWM	ETF	82.82	83.14	82.73	82.98	8935461.0
2007-05-22 11:00:00	IWM	ETF	83.0	83.0	82.71	82.75	3935999.0
2007-05-22 12:00:00	IWM	ETF	82.74	83.19	82.72	83.16	5469200.0
2007-05-22 13:00:00	IWM	ETF	83.16	83.41	83.05	83.34	13769217.0
2007-05-22 14:00:00	IWM	ETF	83.35	83.62	83.31	83.48	11109071.0
2007-05-22 15:00:00	IWM	ETF	83.48	83.64	83.38	83.41	10222100.0
2007-05-22 16:00:00	IWM	ETF	83.42	83.45	83.27	83.33	7337600.0
2007-05-22 17:00:00	IWM	ETF	83.3	83.3	83.3	83.3	6000.0
2007-05-22 18:00:00	IWM	ETF	83.33	83.33	83.3	83.3	134500.0
2007-05-22 07:00:00	DIA	ETF	135.42	135.44	135.42	135.42	10000.0
2007-05-22 08:00:00	DIA	ETF	135.42	135.43	135.35	135.4	11800.0
2007-05-22 09:00:00	DIA	ETF	135.39	135.45	135.17	135.26	877950.0
2007-05-22 10:00:00	DIA	ETF	135.26	135.45	135.17	135.35	2046500.0
2007-05-22 11:00:00	DIA	ETF	135.35	135.41	135.17	135.23	1048500.0
2007-05-22 12:00:00	DIA	ETF	135.22	135.6	135.2	135.55	1094901.0
2007-05-22 13:00:00	DIA	ETF	135.55	135.73	135.45	135.66	1042300.0
2007-05-22 14:00:00	DIA	ETF	135.65	135.73	135.42	135.54	1192000.0
2007-05-22 15:00:00	DIA	ETF	135.55	135.59	135.19	135.24	1220100.0
2007-05-22 16:00:00	DIA	ETF	135.25	135.29	135.11	135.14	76700.0
2007-05-22 17:00:00	DIA	ETF	135.11	135.11	135.11	135.11	200.0
2007-05-22 18:00:00	DIA	ETF	135.15	135.15	135.08	135.08	5200.0

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

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