PREVIEW / etf_1hour / 2007-05-30

all etf 1-hour files

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

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-30 04:00:00	SPY	ETF	151.78	151.78	151.78	151.78	100.0
2007-05-30 05:00:00	SPY	ETF	151.6	151.63	151.6	151.63	30000.0
2007-05-30 06:00:00	SPY	ETF	151.62	151.72	151.62	151.67	45200.0
2007-05-30 07:00:00	SPY	ETF	151.62	151.65	151.45	151.64	754700.0
2007-05-30 08:00:00	SPY	ETF	151.64	151.9	151.48	151.56	1377900.0
2007-05-30 09:00:00	SPY	ETF	151.55	151.84	151.34	151.8	18100772.0
2007-05-30 10:00:00	SPY	ETF	151.8	152.06	151.69	151.91	19781481.0
2007-05-30 11:00:00	SPY	ETF	151.91	152.24	151.81	152.1	14418988.0
2007-05-30 12:00:00	SPY	ETF	152.1	152.56	152.08	152.36	10032269.0
2007-05-30 13:00:00	SPY	ETF	152.36	152.47	152.16	152.339	7337732.0
2007-05-30 14:00:00	SPY	ETF	152.33	153.13	151.92	152.9996	31042548.0
2007-05-30 15:00:00	SPY	ETF	152.99	153.38	152.87	153.37	20776878.0
2007-05-30 16:00:00	SPY	ETF	153.38	153.53	153.31	153.45	2667400.0
2007-05-30 17:00:00	SPY	ETF	153.45	153.46	153.45	153.45	10300.0
2007-05-30 18:00:00	SPY	ETF	153.46	153.53	153.46	153.52	2275500.0
2007-05-30 19:00:00	SPY	ETF	153.51	153.53	153.49	153.53	1400.0
2007-05-30 05:00:00	QQQ	ETF	46.56	46.56	46.55	46.55	60000.0
2007-05-30 06:00:00	QQQ	ETF	46.55	46.55	46.55	46.55	15691.0
2007-05-30 07:00:00	QQQ	ETF	46.55	46.56	46.5	46.56	254208.0
2007-05-30 08:00:00	QQQ	ETF	46.54	46.59	46.51	46.53	655794.0
2007-05-30 09:00:00	QQQ	ETF	46.52	46.65	46.35	46.62	20087320.0
2007-05-30 10:00:00	QQQ	ETF	46.62	46.72	46.52	46.6	24484122.0
2007-05-30 11:00:00	QQQ	ETF	46.6	46.77	46.57	46.69	10723236.0
2007-05-30 12:00:00	QQQ	ETF	46.69	46.89	46.68	46.8105	11301037.0
2007-05-30 13:00:00	QQQ	ETF	46.82	46.85	46.72	46.77	7017316.0
2007-05-30 14:00:00	QQQ	ETF	46.77	47.0	46.61	46.99	24530964.0
2007-05-30 15:00:00	QQQ	ETF	46.99	47.2	46.94	47.19	21449391.0
2007-05-30 16:00:00	QQQ	ETF	47.19	47.26	47.18	47.21	2863740.0
2007-05-30 17:00:00	QQQ	ETF	47.21	47.23	47.2	47.21	61127.0
2007-05-30 18:00:00	QQQ	ETF	47.22	47.24	47.21	47.22	2408611.0
2007-05-30 19:00:00	QQQ	ETF	47.23	47.24	47.22	47.24	9920.0
2007-05-30 07:00:00	IWM	ETF	82.8	82.83	82.8	82.83	12000.0
2007-05-30 08:00:00	IWM	ETF	82.93	82.93	82.71	82.73	429000.0
2007-05-30 09:00:00	IWM	ETF	82.72	83.0	82.43	82.96	8169300.0
2007-05-30 10:00:00	IWM	ETF	82.96	83.16	82.7	82.83	13787026.0
2007-05-30 11:00:00	IWM	ETF	82.84	83.15	82.8	83.06	6171542.0
2007-05-30 12:00:00	IWM	ETF	83.06	83.44	83.04	83.31	4523996.0
2007-05-30 13:00:00	IWM	ETF	83.3	83.5	83.25	83.36	4494532.0
2007-05-30 14:00:00	IWM	ETF	83.36	83.66	83.11	83.62	9767329.0
2007-05-30 15:00:00	IWM	ETF	83.6	83.83	83.51	83.83	11889418.0
2007-05-30 16:00:00	IWM	ETF	83.83	83.89	83.75	83.8	2317600.0
2007-05-30 17:00:00	IWM	ETF	83.83	83.87	83.8	83.82	224700.0
2007-05-30 19:00:00	IWM	ETF	83.87	83.87	83.87	83.87	200.0
2007-05-30 07:00:00	DIA	ETF	134.66	134.69	134.6	134.69	8200.0
2007-05-30 08:00:00	DIA	ETF	134.73	134.8	134.67	134.71	81600.0
2007-05-30 09:00:00	DIA	ETF	134.71	134.81	134.42	134.78	1721967.0
2007-05-30 10:00:00	DIA	ETF	134.77	135.06	134.7	134.88	2988894.0
2007-05-30 11:00:00	DIA	ETF	134.89	135.2	134.78	135.07	1586846.0
2007-05-30 12:00:00	DIA	ETF	135.07	135.49	135.07	135.32	1210300.0
2007-05-30 13:00:00	DIA	ETF	135.31	135.38	134.99	135.1	959500.0

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

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