PREVIEW / etf_1hour / 2006-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-31.parquet
  size:    40 KB
  rows:    1,247

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-03-31 04:00:00	SPY	ETF	128.89	128.99	128.89	128.99	200.0
2006-03-31 06:00:00	SPY	ETF	129.59	129.62	129.59	129.62	1500.0
2006-03-31 07:00:00	SPY	ETF	129.59	129.69	129.58	129.6	56600.0
2006-03-31 08:00:00	SPY	ETF	129.62	129.88	129.59	129.74	2024500.0
2006-03-31 09:00:00	SPY	ETF	129.74	130.24	129.65	130.12	8264300.0
2006-03-31 10:00:00	SPY	ETF	130.13	130.18	129.81	129.9	7680100.0
2006-03-31 11:00:00	SPY	ETF	129.89	129.97	129.62	129.84	6302600.0
2006-03-31 12:00:00	SPY	ETF	129.83	129.9737	129.71	129.76	5308500.0
2006-03-31 13:00:00	SPY	ETF	129.76	129.82	129.37	129.48	6091000.0
2006-03-31 14:00:00	SPY	ETF	129.48	129.81	129.46	129.71	8607000.0
2006-03-31 15:00:00	SPY	ETF	129.7	129.74	129.4	129.49	12358700.0
2006-03-31 16:00:00	SPY	ETF	129.49	129.88	129.405	129.85	3315600.0
2006-03-31 17:00:00	SPY	ETF	129.83	129.86	129.5764	129.81	53700.0
2006-03-31 18:00:00	SPY	ETF	129.84	129.84	129.83	129.83	400.0
2006-03-31 09:00:00	QQQ	ETF	42.13	42.19	42.03	42.14	9636800.0
2006-03-31 10:00:00	QQQ	ETF	42.14	42.18	41.96	42.0	12970200.0
2006-03-31 11:00:00	QQQ	ETF	42.0	42.04	41.9	42.03	7462400.0
2006-03-31 12:00:00	QQQ	ETF	42.02	42.11	41.99	42.01	5852600.0
2006-03-31 13:00:00	QQQ	ETF	42.01	42.04	41.84	41.89	7503300.0
2006-03-31 14:00:00	QQQ	ETF	41.89	42.05	41.87	41.98	7635900.0
2006-03-31 15:00:00	QQQ	ETF	41.98	42.01	41.88	41.93	11577600.0
2006-03-31 07:00:00	IWM	ETF	75.57	75.57	75.57	75.57	2000.0
2006-03-31 08:00:00	IWM	ETF	75.65	75.8	75.65	75.75	8900.0
2006-03-31 09:00:00	IWM	ETF	75.75	75.95	75.61	75.77	2906900.0
2006-03-31 10:00:00	IWM	ETF	75.77	75.9	75.57	75.66	2929000.0
2006-03-31 11:00:00	IWM	ETF	75.66	75.73	75.41	75.52	2737400.0
2006-03-31 12:00:00	IWM	ETF	75.52	75.86	75.47	75.75	3076200.0
2006-03-31 13:00:00	IWM	ETF	75.75	75.82	75.33	75.45	2688200.0
2006-03-31 14:00:00	IWM	ETF	75.44	75.92	75.41	75.86	4361000.0
2006-03-31 15:00:00	IWM	ETF	75.85	75.98	75.75	75.96	4103400.0
2006-03-31 16:00:00	IWM	ETF	75.95	76.0	75.83	76.0	592200.0
2006-03-31 17:00:00	IWM	ETF	75.9	75.9	75.85	75.85	2200.0
2006-03-31 19:00:00	IWM	ETF	75.97	75.97	75.97	75.97	100.0
2006-03-31 08:00:00	DIA	ETF	111.3	111.6	111.23	111.5	20500.0
2006-03-31 09:00:00	DIA	ETF	111.46	111.82	111.46	111.78	947500.0
2006-03-31 10:00:00	DIA	ETF	111.79	111.8	111.49	111.56	892100.0
2006-03-31 11:00:00	DIA	ETF	111.56	111.61	111.35	111.48	667800.0
2006-03-31 12:00:00	DIA	ETF	111.48	111.59	111.4	111.44	661300.0
2006-03-31 13:00:00	DIA	ETF	111.442	111.46	111.04	111.17	539000.0
2006-03-31 14:00:00	DIA	ETF	111.16	111.48	111.09	111.27	638200.0
2006-03-31 15:00:00	DIA	ETF	111.27	111.29	110.97	111.04	1261900.0
2006-03-31 16:00:00	DIA	ETF	111.06	111.29	111.04	111.28	320800.0
2006-03-31 17:00:00	DIA	ETF	111.3	111.3	111.3	111.3	500.0
2006-03-31 18:00:00	DIA	ETF	111.35	111.35	111.31	111.31	200.0
2006-03-31 19:00:00	DIA	ETF	111.32	111.33	111.32	111.33	1800.0
2006-03-31 07:00:00	GLD	ETF	58.29	58.41	58.28	58.28	7100.0
2006-03-31 08:00:00	GLD	ETF	58.28	58.31	57.84	57.97	81600.0
2006-03-31 09:00:00	GLD	ETF	57.93	58.15	57.81	57.9	698700.0
2006-03-31 10:00:00	GLD	ETF	57.91	58.31	57.87	57.88	1554800.0
2006-03-31 11:00:00	GLD	ETF	57.89	58.11	57.56	58.01	784800.0

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

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