PREVIEW / etf_1hour / 2006-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-04.parquet
  size:    55 KB
  rows:    1,683

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
2006-10-04 06:00:00	SPY	ETF	133.35	133.35	133.35	133.35	5000.0
2006-10-04 07:00:00	SPY	ETF	133.6	133.67	133.55	133.58	29900.0
2006-10-04 08:00:00	SPY	ETF	133.58	133.66	133.2	133.31	2113600.0
2006-10-04 09:00:00	SPY	ETF	133.32	133.41	133.15	133.26	6031400.0
2006-10-04 10:00:00	SPY	ETF	133.26	133.82	133.08	133.66	11931800.0
2006-10-04 11:00:00	SPY	ETF	133.65	134.1	133.53	134.08	8303300.0
2006-10-04 12:00:00	SPY	ETF	134.08	134.09	133.9	134.03	5607900.0
2006-10-04 13:00:00	SPY	ETF	134.04	134.38	133.89	134.3	9160900.0
2006-10-04 14:00:00	SPY	ETF	134.3	134.78	134.25	134.74	15977000.0
2006-10-04 15:00:00	SPY	ETF	134.74	135.0	134.61	134.95	16832000.0
2006-10-04 16:00:00	SPY	ETF	134.93	134.99	134.82	134.92	2032800.0
2006-10-04 17:00:00	SPY	ETF	134.95	134.96	134.84	134.85	67000.0
2006-10-04 18:00:00	SPY	ETF	134.92	134.97	134.92	134.93	2800.0
2006-10-04 19:00:00	SPY	ETF	134.91	134.95	134.91	134.95	3800.0
2006-10-04 09:00:00	QQQ	ETF	40.22	40.31	40.17	40.23	9308500.0
2006-10-04 10:00:00	QQQ	ETF	40.23	40.68	40.14	40.65	32740600.0
2006-10-04 11:00:00	QQQ	ETF	40.65	40.9	40.58	40.85	20363600.0
2006-10-04 12:00:00	QQQ	ETF	40.85	40.85	40.72	40.8	11170900.0
2006-10-04 13:00:00	QQQ	ETF	40.81	40.95	40.71	40.87	18225100.0
2006-10-04 14:00:00	QQQ	ETF	40.88	41.24	40.87	41.23	20470300.0
2006-10-04 15:00:00	QQQ	ETF	41.22	41.31	41.01	41.31	21371400.0
2006-10-04 07:00:00	IWM	ETF	71.09	71.45	71.09	71.39	6000.0
2006-10-04 08:00:00	IWM	ETF	71.41	71.43	71.13	71.21	895700.0
2006-10-04 09:00:00	IWM	ETF	71.22	71.57	71.09	71.44	5887000.0
2006-10-04 10:00:00	IWM	ETF	71.45	71.95	71.25	71.84	8851200.0
2006-10-04 11:00:00	IWM	ETF	71.8475	72.18	71.67	72.17	6577500.0
2006-10-04 12:00:00	IWM	ETF	72.16	72.18	72.03	72.15	4365100.0
2006-10-04 13:00:00	IWM	ETF	72.15	72.4	71.97	72.34	4303700.0
2006-10-04 14:00:00	IWM	ETF	72.34	72.85	72.31	72.84	8276300.0
2006-10-04 15:00:00	IWM	ETF	72.84	72.93	72.56	72.9	9581300.0
2006-10-04 16:00:00	IWM	ETF	72.89	72.96	71.3657	72.89	1572800.0
2006-10-04 17:00:00	IWM	ETF	72.91	73.05	72.91	73.05	110400.0
2006-10-04 18:00:00	IWM	ETF	73.02	73.02	72.95	72.95	69300.0
2006-10-04 19:00:00	IWM	ETF	72.98	72.98	72.98	72.98	300.0
2006-10-04 08:00:00	DIA	ETF	117.33	117.33	117.03	117.05	29600.0
2006-10-04 09:00:00	DIA	ETF	117.08	117.36	117.0	117.24	795500.0
2006-10-04 10:00:00	DIA	ETF	117.24	117.65	117.0902	117.63	2323600.0
2006-10-04 11:00:00	DIA	ETF	117.63	117.82	117.48	117.7801	1098100.0
2006-10-04 12:00:00	DIA	ETF	117.78	117.79	117.63	117.74	1490600.0
2006-10-04 13:00:00	DIA	ETF	117.73	118.0	117.6	117.94	1081200.0
2006-10-04 14:00:00	DIA	ETF	117.95	118.3	117.91	118.29	1238200.0
2006-10-04 15:00:00	DIA	ETF	118.29	118.48	118.16	118.43	1335800.0
2006-10-04 16:00:00	DIA	ETF	118.41	118.43	118.34	118.39	64400.0
2006-10-04 17:00:00	DIA	ETF	118.45	118.45	118.39	118.39	300.0
2006-10-04 07:00:00	GLD	ETF	57.41	57.41	57.41	57.41	1000.0
2006-10-04 08:00:00	GLD	ETF	57.41	57.74	57.32	57.32	94400.0
2006-10-04 09:00:00	GLD	ETF	57.4	57.52	57.17	57.21	451600.0
2006-10-04 10:00:00	GLD	ETF	57.22	57.27	56.37	56.41	1501700.0
2006-10-04 11:00:00	GLD	ETF	56.4	56.43	55.75	56.08	2057000.0
2006-10-04 12:00:00	GLD	ETF	56.08	56.4	55.55	55.86	1745400.0

> showing 50 of 1,683 rows — these rows as CSV

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