PREVIEW / etf_1hour / 2006-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-03.parquet
  size:    41 KB
  rows:    1,258

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-03 04:00:00	SPY	ETF	129.97	129.97	129.97	129.97	6000.0
2006-04-03 05:00:00	SPY	ETF	129.97	130.2	129.85	130.2	34500.0
2006-04-03 06:00:00	SPY	ETF	130.18	130.24	130.18	130.24	121000.0
2006-04-03 07:00:00	SPY	ETF	130.18	130.21	130.08	130.1	251300.0
2006-04-03 08:00:00	SPY	ETF	129.83	130.21	129.83	130.05	1883000.0
2006-04-03 09:00:00	SPY	ETF	130.04	130.17	129.83	130.15	6334300.0
2006-04-03 10:00:00	SPY	ETF	130.15	130.74	129.98	130.57	14435600.0
2006-04-03 11:00:00	SPY	ETF	130.57	130.87	130.5	130.75	7986200.0
2006-04-03 12:00:00	SPY	ETF	130.75	130.81	130.58	130.66	5499700.0
2006-04-03 13:00:00	SPY	ETF	130.7	130.71	130.5	130.6	4055400.0
2006-04-03 14:00:00	SPY	ETF	130.6	130.62	130.15	130.23	8043600.0
2006-04-03 15:00:00	SPY	ETF	130.21	130.35	129.49	129.69	10945300.0
2006-04-03 16:00:00	SPY	ETF	129.69	130.66	129.4043	129.71	1000600.0
2006-04-03 17:00:00	SPY	ETF	129.73	129.74	129.71	129.73	3500.0
2006-04-03 18:00:00	SPY	ETF	129.73	129.76	129.73	129.76	2400.0
2006-04-03 19:00:00	SPY	ETF	129.75	129.75	129.72	129.72	3200.0
2006-04-03 09:00:00	QQQ	ETF	42.15	42.17	42.03	42.14	9687800.0
2006-04-03 10:00:00	QQQ	ETF	42.14	42.32	42.08	42.26	18502200.0
2006-04-03 11:00:00	QQQ	ETF	42.27	42.37	42.21	42.32	8821000.0
2006-04-03 12:00:00	QQQ	ETF	42.31	42.36	42.21	42.26	8557500.0
2006-04-03 13:00:00	QQQ	ETF	42.26	42.31	42.17	42.26	6621500.0
2006-04-03 14:00:00	QQQ	ETF	42.27	42.27	42.06	42.09	9377300.0
2006-04-03 15:00:00	QQQ	ETF	42.09	42.15	41.9	41.97	12494200.0
2006-04-03 07:00:00	IWM	ETF	76.1	76.1	76.1	76.1	300.0
2006-04-03 08:00:00	IWM	ETF	76.0	76.24	75.97	76.14	451300.0
2006-04-03 09:00:00	IWM	ETF	76.14	76.17	75.73	75.87	2711200.0
2006-04-03 10:00:00	IWM	ETF	75.87	76.41	75.75	76.2899	6400500.0
2006-04-03 11:00:00	IWM	ETF	76.29	76.37	76.1	76.1	5240900.0
2006-04-03 12:00:00	IWM	ETF	76.1	76.21	75.91	75.98	5181200.0
2006-04-03 13:00:00	IWM	ETF	75.98	76.01	75.81	75.94	2439600.0
2006-04-03 14:00:00	IWM	ETF	75.93	75.95	75.39	75.49	4143100.0
2006-04-03 15:00:00	IWM	ETF	75.489	75.62	75.31	75.32	5058800.0
2006-04-03 16:00:00	IWM	ETF	75.32	75.82	75.28	75.29	752800.0
2006-04-03 17:00:00	IWM	ETF	75.28	75.28	75.27	75.27	6000.0
2006-04-03 07:00:00	DIA	ETF	111.71	111.73	111.6	111.6	15900.0
2006-04-03 08:00:00	DIA	ETF	111.61	111.77	111.31	111.59	132200.0
2006-04-03 09:00:00	DIA	ETF	111.55	111.72	111.31	111.7	723700.0
2006-04-03 10:00:00	DIA	ETF	111.7008	112.3	111.54	112.09	2117800.0
2006-04-03 11:00:00	DIA	ETF	112.1	112.39	112.03	112.27	773000.0
2006-04-03 12:00:00	DIA	ETF	112.26	112.31	112.11	112.22	1026200.0
2006-04-03 13:00:00	DIA	ETF	112.2	112.23	112.1	112.16	412700.0
2006-04-03 14:00:00	DIA	ETF	112.16	112.18	111.79	111.81	1102300.0
2006-04-03 15:00:00	DIA	ETF	111.83	111.91	111.26	111.36	1489000.0
2006-04-03 16:00:00	DIA	ETF	111.36	111.36	111.3	111.36	33700.0
2006-04-03 18:00:00	DIA	ETF	111.4	111.49	111.4	111.47	700.0
2006-04-03 06:00:00	GLD	ETF	57.98	57.98	57.98	57.98	1000.0
2006-04-03 08:00:00	GLD	ETF	58.41	58.53	58.28	58.45	116200.0
2006-04-03 09:00:00	GLD	ETF	58.41	58.67	58.4	58.49	798500.0
2006-04-03 10:00:00	GLD	ETF	58.49	58.93	58.42	58.75	648200.0
2006-04-03 11:00:00	GLD	ETF	58.75	58.81	58.71	58.75	450600.0

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

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