PREVIEW / etf_1hour / 2005-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-29.parquet
  size:    31 KB
  rows:    933

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
2005-07-29 07:00:00	SPY	ETF	124.7	124.7	124.64	124.65	4200.0
2005-07-29 08:00:00	SPY	ETF	124.7	124.7	124.52	124.54	344600.0
2005-07-29 09:00:00	SPY	ETF	124.54	124.66	124.33	124.51	4582400.0
2005-07-29 10:00:00	SPY	ETF	124.53	124.63	124.06	124.11	10460700.0
2005-07-29 11:00:00	SPY	ETF	124.11	124.19	123.86	123.93	11215300.0
2005-07-29 12:00:00	SPY	ETF	123.93	124.03	123.78	123.93	7844700.0
2005-07-29 13:00:00	SPY	ETF	123.92	124.07	123.77	124.0	4487100.0
2005-07-29 14:00:00	SPY	ETF	123.99	124.21	123.93	124.01	4176300.0
2005-07-29 15:00:00	SPY	ETF	124.01	124.07	123.5	123.56	12636300.0
2005-07-29 16:00:00	SPY	ETF	123.61	124.53	123.53	123.75	3786000.0
2005-07-29 17:00:00	SPY	ETF	123.82	123.84	123.58	123.78	28600.0
2005-07-29 18:00:00	SPY	ETF	123.72	123.72	123.72	123.72	500.0
2005-07-29 19:00:00	SPY	ETF	123.72	123.8	123.72	123.8	1900.0
2005-07-29 09:00:00	QQQ	ETF	39.87	39.89	39.8	39.88	8399100.0
2005-07-29 10:00:00	QQQ	ETF	39.89	39.92	39.69	39.71	12510800.0
2005-07-29 11:00:00	QQQ	ETF	39.71	39.74	39.6	39.63	11683300.0
2005-07-29 12:00:00	QQQ	ETF	39.63	39.73	39.54	39.6	9797500.0
2005-07-29 13:00:00	QQQ	ETF	39.6	39.69	39.59	39.68	6528400.0
2005-07-29 14:00:00	QQQ	ETF	39.68	39.76	39.66	39.71	8240900.0
2005-07-29 15:00:00	QQQ	ETF	39.7	39.72	39.52	39.57	13347500.0
2005-07-29 08:00:00	IWM	ETF	68.05	68.11	68.04	68.06	13300.0
2005-07-29 09:00:00	IWM	ETF	68.02	68.18	67.9	68.18	2045400.0
2005-07-29 10:00:00	IWM	ETF	68.18	68.26	67.77	67.83	3695600.0
2005-07-29 11:00:00	IWM	ETF	67.83	67.94	67.64	67.67	3481900.0
2005-07-29 12:00:00	IWM	ETF	67.69	67.74	67.48	67.53	3800100.0
2005-07-29 13:00:00	IWM	ETF	67.53	67.65	67.44	67.64	2909300.0
2005-07-29 14:00:00	IWM	ETF	67.64	67.92	67.6	67.74	1672800.0
2005-07-29 15:00:00	IWM	ETF	67.74	67.8	67.52	67.64	5130300.0
2005-07-29 16:00:00	IWM	ETF	67.63	68.09	67.62	67.87	1159800.0
2005-07-29 17:00:00	IWM	ETF	67.82	67.83	67.62	67.62	5900.0
2005-07-29 07:00:00	DIA	ETF	107.16	107.16	107.16	107.16	2600.0
2005-07-29 08:00:00	DIA	ETF	107.19	107.22	107.07	107.11	4800.0
2005-07-29 09:00:00	DIA	ETF	107.06	107.07	106.88	107.06	1009800.0
2005-07-29 10:00:00	DIA	ETF	107.07	107.16	106.77	106.81	522500.0
2005-07-29 11:00:00	DIA	ETF	106.81	106.85	106.58	106.64	679300.0
2005-07-29 12:00:00	DIA	ETF	106.66	106.72	106.56	106.69	654500.0
2005-07-29 13:00:00	DIA	ETF	106.69	106.85	106.58	106.8	347700.0
2005-07-29 14:00:00	DIA	ETF	106.79	106.95	106.76	106.82	677100.0
2005-07-29 15:00:00	DIA	ETF	106.82	106.87	106.39	106.44	1445700.0
2005-07-29 16:00:00	DIA	ETF	106.42	106.7	106.42	106.62	36000.0
2005-07-29 17:00:00	DIA	ETF	106.5	106.61	106.5	106.61	1500.0
2005-07-29 19:00:00	DIA	ETF	106.56	106.56	106.56	106.56	300.0
2005-07-29 08:00:00	GLD	ETF	42.86	42.86	42.86	42.86	5000.0
2005-07-29 09:00:00	GLD	ETF	42.83	42.84	42.79	42.82	112600.0
2005-07-29 10:00:00	GLD	ETF	42.84	42.95	42.79	42.89	116600.0
2005-07-29 11:00:00	GLD	ETF	42.9	42.95	42.83	42.93	463000.0
2005-07-29 12:00:00	GLD	ETF	42.91	42.96	42.91	42.94	151600.0
2005-07-29 13:00:00	GLD	ETF	42.92	42.93	42.86	42.9	102900.0
2005-07-29 14:00:00	GLD	ETF	42.9	42.9	42.83	42.86	30800.0
2005-07-29 15:00:00	GLD	ETF	42.86	42.88	42.81	42.81	179000.0

> showing 50 of 933 rows — these rows as CSV

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