PREVIEW / etf_1hour / 2006-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-03.parquet
  size:    54 KB
  rows:    1,699

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-03 05:00:00	SPY	ETF	132.88	132.88	132.88	132.88	500.0
2006-10-03 07:00:00	SPY	ETF	132.91	133.06	132.91	132.98	16700.0
2006-10-03 08:00:00	SPY	ETF	132.74	133.0	132.74	132.97	570400.0
2006-10-03 09:00:00	SPY	ETF	132.86	133.0823	132.66	132.87	9867100.0
2006-10-03 10:00:00	SPY	ETF	132.87	133.04	132.65	132.89	12412000.0
2006-10-03 11:00:00	SPY	ETF	132.89	133.36	132.78	133.15	12110600.0
2006-10-03 12:00:00	SPY	ETF	133.15	133.77	133.15	133.76	9659300.0
2006-10-03 13:00:00	SPY	ETF	133.77	133.79	133.48	133.6	7222300.0
2006-10-03 14:00:00	SPY	ETF	133.6	133.87	133.41	133.61	9561200.0
2006-10-03 15:00:00	SPY	ETF	133.61	133.69	133.26	133.46	8908800.0
2006-10-03 16:00:00	SPY	ETF	133.44	133.47	133.32	133.4	1339400.0
2006-10-03 17:00:00	SPY	ETF	133.41	133.42	133.34	133.34	186600.0
2006-10-03 18:00:00	SPY	ETF	133.39	133.39	133.35	133.35	2500.0
2006-10-03 19:00:00	SPY	ETF	133.32	133.35	133.32	133.35	2200.0
2006-10-03 09:00:00	QQQ	ETF	40.05	40.07	39.88	39.98	12905200.0
2006-10-03 10:00:00	QQQ	ETF	39.99	40.11	39.89	39.98	15138900.0
2006-10-03 11:00:00	QQQ	ETF	39.99	40.2	39.93	40.14	15684500.0
2006-10-03 12:00:00	QQQ	ETF	40.14	40.45	40.13	40.45	18595600.0
2006-10-03 13:00:00	QQQ	ETF	40.45	40.48	40.28	40.38	14796900.0
2006-10-03 14:00:00	QQQ	ETF	40.37	40.46	40.31	40.38	12741000.0
2006-10-03 15:00:00	QQQ	ETF	40.38	40.45	40.25	40.33	17874900.0
2006-10-03 05:00:00	IWM	ETF	71.0	71.0	71.0	71.0	200.0
2006-10-03 07:00:00	IWM	ETF	71.1	71.25	71.1	71.25	2400.0
2006-10-03 08:00:00	IWM	ETF	71.12	71.21	71.11	71.16	72900.0
2006-10-03 09:00:00	IWM	ETF	71.16	71.28	70.68	70.86	7734800.0
2006-10-03 10:00:00	IWM	ETF	70.87	71.26	70.71	71.13	8639700.0
2006-10-03 11:00:00	IWM	ETF	71.12	71.58	71.06	71.29	6062900.0
2006-10-03 12:00:00	IWM	ETF	71.29	71.83	71.28	71.78	4833200.0
2006-10-03 13:00:00	IWM	ETF	71.79	71.82	71.48	71.6	3318000.0
2006-10-03 14:00:00	IWM	ETF	71.61	71.78	71.36	71.49	6604400.0
2006-10-03 15:00:00	IWM	ETF	71.49	71.59	71.23	71.31	6374600.0
2006-10-03 16:00:00	IWM	ETF	71.3	71.32	71.22	71.28	1246400.0
2006-10-03 17:00:00	IWM	ETF	71.34	71.38	71.3	71.37	67400.0
2006-10-03 18:00:00	IWM	ETF	71.34	71.34	71.34	71.34	200.0
2006-10-03 08:00:00	DIA	ETF	116.56	116.56	116.43	116.45	5600.0
2006-10-03 09:00:00	DIA	ETF	116.49	116.67	116.44	116.66	919900.0
2006-10-03 10:00:00	DIA	ETF	116.67	116.81	116.51	116.72	926000.0
2006-10-03 11:00:00	DIA	ETF	116.71	117.08	116.63	116.91	1002900.0
2006-10-03 12:00:00	DIA	ETF	116.93	117.48	116.92	117.44	1397700.0
2006-10-03 13:00:00	DIA	ETF	117.44	117.45	117.19	117.32	804600.0
2006-10-03 14:00:00	DIA	ETF	117.32	117.49	117.19	117.34	868000.0
2006-10-03 15:00:00	DIA	ETF	117.35	117.4	117.12	117.25	1070900.0
2006-10-03 16:00:00	DIA	ETF	117.25	117.25	117.14	117.1795	1735800.0
2006-10-03 07:00:00	GLD	ETF	58.8	58.8	58.8	58.8	900.0
2006-10-03 08:00:00	GLD	ETF	58.78	59.19	58.1	58.1	161400.0
2006-10-03 09:00:00	GLD	ETF	58.0	58.17	57.65	57.87	1069200.0
2006-10-03 10:00:00	GLD	ETF	57.86	58.14	57.75	57.78	811000.0
2006-10-03 11:00:00	GLD	ETF	57.81	57.92	56.91	57.82	547200.0
2006-10-03 12:00:00	GLD	ETF	57.85	57.9	57.5	57.63	579300.0
2006-10-03 13:00:00	GLD	ETF	57.6198	57.6198	57.1	57.1102	724000.0

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

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