PREVIEW / etf_1hour / 2006-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-04.parquet
  size:    40 KB
  rows:    1,243

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-04-04 07:00:00	SPY	ETF	129.77	129.85	129.77	129.83	16200.0
2006-04-04 08:00:00	SPY	ETF	129.87	129.9	129.68	129.71	248400.0
2006-04-04 09:00:00	SPY	ETF	129.72	129.83	129.36	129.69	8159200.0
2006-04-04 10:00:00	SPY	ETF	129.69	130.05	129.66	129.73	8965600.0
2006-04-04 11:00:00	SPY	ETF	129.72	130.17	129.58	130.07	7498400.0
2006-04-04 12:00:00	SPY	ETF	130.08	130.46	130.07	130.38	6717700.0
2006-04-04 13:00:00	SPY	ETF	130.38	130.46	130.14	130.42	6414800.0
2006-04-04 14:00:00	SPY	ETF	130.41	130.71	130.24	130.47	8855400.0
2006-04-04 15:00:00	SPY	ETF	130.47	130.73	130.39	130.53	6253100.0
2006-04-04 16:00:00	SPY	ETF	130.52	130.61	130.52	130.54	650500.0
2006-04-04 17:00:00	SPY	ETF	130.58	130.58	130.49	130.52	268100.0
2006-04-04 18:00:00	SPY	ETF	130.53	130.57	130.53	130.57	1100.0
2006-04-04 19:00:00	SPY	ETF	130.61	130.61	130.57	130.57	1200.0
2006-04-04 09:00:00	QQQ	ETF	42.03	42.11	41.93	42.08	15044100.0
2006-04-04 10:00:00	QQQ	ETF	42.08	42.22	42.06	42.06	16549700.0
2006-04-04 11:00:00	QQQ	ETF	42.07	42.2	42.0	42.13	11336100.0
2006-04-04 12:00:00	QQQ	ETF	42.14	42.31	42.13	42.24	10949500.0
2006-04-04 13:00:00	QQQ	ETF	42.23	42.26	42.11	42.2	8781900.0
2006-04-04 14:00:00	QQQ	ETF	42.2	42.3	42.13	42.21	10693800.0
2006-04-04 15:00:00	QQQ	ETF	42.21	42.25	42.15	42.2	10427800.0
2006-04-04 08:00:00	IWM	ETF	75.38	75.39	75.27	75.28	9000.0
2006-04-04 09:00:00	IWM	ETF	75.28	75.83	75.07	75.39	5374200.0
2006-04-04 10:00:00	IWM	ETF	75.39	75.55	75.25	75.29	3957800.0
2006-04-04 11:00:00	IWM	ETF	75.28	75.71	75.15	75.62	3316800.0
2006-04-04 12:00:00	IWM	ETF	75.62	75.99	75.62	75.87	3361000.0
2006-04-04 13:00:00	IWM	ETF	75.87	75.94	75.57	75.74	3156000.0
2006-04-04 14:00:00	IWM	ETF	75.75	75.89	75.41	75.54	4447800.0
2006-04-04 15:00:00	IWM	ETF	75.54	75.82	75.53	75.66	5705900.0
2006-04-04 16:00:00	IWM	ETF	75.65	75.79	75.64	75.71	142300.0
2006-04-04 17:00:00	IWM	ETF	75.72	75.75	75.72	75.75	1400.0
2006-04-04 18:00:00	IWM	ETF	75.75	75.75	75.75	75.75	500.0
2006-04-04 07:00:00	DIA	ETF	111.35	111.35	111.35	111.35	100.0
2006-04-04 08:00:00	DIA	ETF	111.44	111.48	111.32	111.34	104900.0
2006-04-04 09:00:00	DIA	ETF	111.39	111.45	111.13	111.37	1016100.0
2006-04-04 10:00:00	DIA	ETF	111.37	111.7	111.37	111.52	1008500.0
2006-04-04 11:00:00	DIA	ETF	111.51	111.89	111.39	111.81	552200.0
2006-04-04 12:00:00	DIA	ETF	111.84	112.2	111.83	112.09	925000.0
2006-04-04 13:00:00	DIA	ETF	112.09	112.13	111.8	112.07	744900.0
2006-04-04 14:00:00	DIA	ETF	112.07	112.19	111.83	111.97	881800.0
2006-04-04 15:00:00	DIA	ETF	111.97	112.16	111.86	111.92	891100.0
2006-04-04 16:00:00	DIA	ETF	111.98	112.03	111.91	112.0	42900.0
2006-04-04 17:00:00	DIA	ETF	112.0	112.0	112.0	112.0	100.0
2006-04-04 08:00:00	GLD	ETF	58.61	58.61	58.36	58.36	7900.0
2006-04-04 09:00:00	GLD	ETF	58.33	58.76	58.33	58.65	1872000.0
2006-04-04 10:00:00	GLD	ETF	58.65	58.71	58.344	58.38	970700.0
2006-04-04 11:00:00	GLD	ETF	58.38	58.48	58.18	58.39	1078200.0
2006-04-04 12:00:00	GLD	ETF	58.39	58.56	58.37	58.48	327800.0
2006-04-04 13:00:00	GLD	ETF	58.46	58.52	58.26	58.35	251600.0
2006-04-04 14:00:00	GLD	ETF	58.34	58.39	58.26	58.36	203500.0
2006-04-04 15:00:00	GLD	ETF	58.379	58.542	58.35	58.4	321500.0

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

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