PREVIEW / etf_1hour / 2006-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-10.parquet
  size:    42 KB
  rows:    1,338

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-05-10 06:00:00	SPY	ETF	132.61	132.61	132.58	132.58	2200.0
2006-05-10 07:00:00	SPY	ETF	132.55	132.61	132.52	132.58	74600.0
2006-05-10 08:00:00	SPY	ETF	132.59	132.63	132.54	132.55	150400.0
2006-05-10 09:00:00	SPY	ETF	132.54	132.58	132.33	132.52	4251900.0
2006-05-10 10:00:00	SPY	ETF	132.53	132.6	132.41	132.46	4830700.0
2006-05-10 11:00:00	SPY	ETF	132.46	132.52	132.4	132.43	3458000.0
2006-05-10 12:00:00	SPY	ETF	132.41	132.56	132.41	132.49	1830600.0
2006-05-10 13:00:00	SPY	ETF	132.52	132.58	132.4	132.43	2406700.0
2006-05-10 14:00:00	SPY	ETF	132.43	132.72	131.89	132.59	26064200.0
2006-05-10 15:00:00	SPY	ETF	132.59	132.75	132.18	132.43	16160500.0
2006-05-10 16:00:00	SPY	ETF	132.43	132.55	132.34	132.48	419900.0
2006-05-10 17:00:00	SPY	ETF	132.5	132.53	132.47	132.51	180200.0
2006-05-10 18:00:00	SPY	ETF	132.52	132.52	132.47	132.47	25900.0
2006-05-10 19:00:00	SPY	ETF	132.48	132.48	132.46	132.46	6500.0
2006-05-10 09:00:00	QQQ	ETF	41.93	41.98	41.87	41.93	8305900.0
2006-05-10 10:00:00	QQQ	ETF	41.93	41.97	41.82	41.83	8228900.0
2006-05-10 11:00:00	QQQ	ETF	41.84	41.92	41.83	41.87	9005500.0
2006-05-10 12:00:00	QQQ	ETF	41.87	41.91	41.82	41.89	4000200.0
2006-05-10 13:00:00	QQQ	ETF	41.9	41.92	41.76	41.8	5215300.0
2006-05-10 14:00:00	QQQ	ETF	41.8	41.86	41.55	41.76	31686900.0
2006-05-10 15:00:00	QQQ	ETF	41.76	41.85	41.55	41.65	16660000.0
2006-05-10 08:00:00	IWM	ETF	77.5	77.5	77.41	77.45	31900.0
2006-05-10 09:00:00	IWM	ETF	77.45	77.46	77.2	77.29	1449400.0
2006-05-10 10:00:00	IWM	ETF	77.29	77.46	77.17	77.22	1954400.0
2006-05-10 11:00:00	IWM	ETF	77.22	77.32	77.2	77.23	3425200.0
2006-05-10 12:00:00	IWM	ETF	77.23	77.34	77.19	77.31	2233800.0
2006-05-10 13:00:00	IWM	ETF	77.3	77.4	77.16	77.2	1488100.0
2006-05-10 14:00:00	IWM	ETF	77.19	77.4	76.73	77.18	8417200.0
2006-05-10 15:00:00	IWM	ETF	77.2	77.28	76.84	77.11	5254300.0
2006-05-10 16:00:00	IWM	ETF	77.12	77.15	77.05	77.12	643900.0
2006-05-10 07:00:00	DIA	ETF	116.34	116.34	116.34	116.34	500.0
2006-05-10 08:00:00	DIA	ETF	116.4	116.45	116.34	116.34	197800.0
2006-05-10 09:00:00	DIA	ETF	116.3	116.43	116.19	116.41	499000.0
2006-05-10 10:00:00	DIA	ETF	116.41	116.64	116.38	116.49	674300.0
2006-05-10 11:00:00	DIA	ETF	116.48	116.54	116.41	116.44	432900.0
2006-05-10 12:00:00	DIA	ETF	116.43	116.54	116.39	116.49	207900.0
2006-05-10 13:00:00	DIA	ETF	116.49	116.52	116.39	116.42	330100.0
2006-05-10 14:00:00	DIA	ETF	116.43	116.8	116.04	116.66	3007100.0
2006-05-10 15:00:00	DIA	ETF	116.66	116.74	116.19	116.48	2363200.0
2006-05-10 16:00:00	DIA	ETF	116.43	116.58	116.43	116.48	161900.0
2006-05-10 17:00:00	DIA	ETF	116.48	116.48	116.48	116.48	900.0
2006-05-10 18:00:00	DIA	ETF	116.48	116.48	116.48	116.48	100.0
2006-05-10 19:00:00	DIA	ETF	116.5	116.5	116.5	116.5	900.0
2006-05-10 05:00:00	GLD	ETF	70.1	70.1	70.1	70.1	200.0
2006-05-10 07:00:00	GLD	ETF	69.85	69.85	69.7	69.7	24100.0
2006-05-10 08:00:00	GLD	ETF	69.7	69.8	69.33	69.38	482500.0
2006-05-10 09:00:00	GLD	ETF	69.34	69.53	69.02	69.45	1664600.0
2006-05-10 10:00:00	GLD	ETF	69.43	69.8	69.4	69.78	1902000.0
2006-05-10 11:00:00	GLD	ETF	69.77	69.9	69.48	69.58	824500.0
2006-05-10 12:00:00	GLD	ETF	69.58	69.84	69.58	69.72	1043400.0

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

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