PREVIEW / etf_1hour / 2007-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-03.parquet
  size:    91 KB
  rows:    3,078

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-12-03 04:00:00	SPY	ETF	148.18	148.2	148.08	148.08	4500.0
2007-12-03 05:00:00	SPY	ETF	148.2	148.28	148.2	148.28	300.0
2007-12-03 06:00:00	SPY	ETF	148.35	148.58	148.35	148.51	20000.0
2007-12-03 07:00:00	SPY	ETF	148.31	148.64	148.29	148.56	868000.0
2007-12-03 08:00:00	SPY	ETF	148.4	148.71	148.37	148.47	1699900.0
2007-12-03 09:00:00	SPY	ETF	148.48	148.66	147.58	147.83	22844525.0
2007-12-03 10:00:00	SPY	ETF	147.83	148.24	147.39	148.02	22105121.0
2007-12-03 11:00:00	SPY	ETF	148.01	148.29	147.66	148.04	11699239.0
2007-12-03 12:00:00	SPY	ETF	148.05	148.45	147.9	148.1301	9838822.0
2007-12-03 13:00:00	SPY	ETF	148.14	148.15	147.41	147.49	20917023.0
2007-12-03 14:00:00	SPY	ETF	147.5	147.82	147.39	147.76	14191897.0
2007-12-03 15:00:00	SPY	ETF	147.75	147.92	147.29	147.55	30102844.0
2007-12-03 16:00:00	SPY	ETF	147.52	148.3	147.4	147.55	2065000.0
2007-12-03 17:00:00	SPY	ETF	147.52	147.89	147.47	147.59	244900.0
2007-12-03 18:00:00	SPY	ETF	147.58	147.59	147.46	147.46	18600.0
2007-12-03 19:00:00	SPY	ETF	147.68	147.68	147.34	147.37	500800.0
2007-12-03 04:00:00	QQQ	ETF	51.32	51.32	51.32	51.32	100.0
2007-12-03 05:00:00	QQQ	ETF	51.37	51.37	51.37	51.37	8731.0
2007-12-03 06:00:00	QQQ	ETF	51.43	51.43	51.4	51.42	16500.0
2007-12-03 07:00:00	QQQ	ETF	51.38	51.63	51.38	51.5	565456.0
2007-12-03 08:00:00	QQQ	ETF	51.5	51.57	51.34	51.36	1424099.0
2007-12-03 09:00:00	QQQ	ETF	51.35	51.39	51.06	51.27	13053531.0
2007-12-03 10:00:00	QQQ	ETF	51.2799	51.49	51.08	51.4301	22555587.0
2007-12-03 11:00:00	QQQ	ETF	51.44	51.53	51.27	51.4501	8467588.0
2007-12-03 12:00:00	QQQ	ETF	51.46	51.53	51.37	51.38	6497858.0
2007-12-03 13:00:00	QQQ	ETF	51.38	51.38	51.07	51.12	14197884.0
2007-12-03 14:00:00	QQQ	ETF	51.1199	51.25	50.97	51.1001	17282606.0
2007-12-03 15:00:00	QQQ	ETF	51.1001	51.15	50.82	50.87	20284614.0
2007-12-03 16:00:00	QQQ	ETF	50.87	51.2037	50.85	50.94	3163097.0
2007-12-03 17:00:00	QQQ	ETF	50.93	51.04	50.88	50.98	659636.0
2007-12-03 18:00:00	QQQ	ETF	50.98	51.0	50.88	50.94	407060.0
2007-12-03 19:00:00	QQQ	ETF	50.92	50.96	50.9	50.91	43095.0
2007-12-03 06:00:00	IWM	ETF	76.9	77.0	76.9	76.92	12500.0
2007-12-03 07:00:00	IWM	ETF	76.8	76.95	76.8	76.85	83400.0
2007-12-03 08:00:00	IWM	ETF	76.9	77.0	76.68	76.75	226700.0
2007-12-03 09:00:00	IWM	ETF	76.7	76.72	75.93	76.08	9005798.0
2007-12-03 10:00:00	IWM	ETF	76.08	76.48	75.8	76.35	10268111.0
2007-12-03 11:00:00	IWM	ETF	76.35	76.58	76.18	76.45	5512710.0
2007-12-03 12:00:00	IWM	ETF	76.45	76.75	76.35	76.56	2302176.0
2007-12-03 13:00:00	IWM	ETF	76.57	76.58	75.99	76.04	8085706.0
2007-12-03 14:00:00	IWM	ETF	76.04	76.28	75.99	76.18	6630626.0
2007-12-03 15:00:00	IWM	ETF	76.18	76.26	75.73	75.77	12007132.0
2007-12-03 16:00:00	IWM	ETF	75.77	76.15	75.68	75.73	7341639.0
2007-12-03 17:00:00	IWM	ETF	75.75	75.9	75.61	75.9	161400.0
2007-12-03 18:00:00	IWM	ETF	75.63	75.75	75.63	75.75	326200.0
2007-12-03 07:00:00	DIA	ETF	133.8	134.0	133.8	133.92	5200.0
2007-12-03 08:00:00	DIA	ETF	133.99	134.05	133.9	133.9	3000.0
2007-12-03 09:00:00	DIA	ETF	133.88	133.88	133.28	133.42	1656952.0
2007-12-03 10:00:00	DIA	ETF	133.42	133.97	133.14	133.84	5316284.0
2007-12-03 11:00:00	DIA	ETF	133.85	133.96	133.54	133.84	836806.0

> showing 50 of 3,078 rows — these rows as CSV

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