PREVIEW / etf_1hour / 2006-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-08.parquet
  size:    49 KB
  rows:    1,565

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-08-08 05:00:00	SPY	ETF	128.2	128.2	128.2	128.2	1000.0
2006-08-08 06:00:00	SPY	ETF	128.18	128.19	128.13	128.17	136000.0
2006-08-08 07:00:00	SPY	ETF	128.17	128.21	128.11	128.11	477500.0
2006-08-08 08:00:00	SPY	ETF	128.14	128.28	127.92	128.02	2323000.0
2006-08-08 09:00:00	SPY	ETF	128.0	128.21	127.84	128.06	7437800.0
2006-08-08 10:00:00	SPY	ETF	128.06	128.17	127.97	128.03	4747000.0
2006-08-08 11:00:00	SPY	ETF	128.032	128.17	127.97	128.0	3685000.0
2006-08-08 12:00:00	SPY	ETF	128.0	128.09	127.9	127.99	4355100.0
2006-08-08 13:00:00	SPY	ETF	128.0	128.01	127.79	127.83	4377300.0
2006-08-08 14:00:00	SPY	ETF	127.84	128.46	127.1	127.53	40337800.0
2006-08-08 15:00:00	SPY	ETF	127.53	128.05	126.95	127.33	16911800.0
2006-08-08 16:00:00	SPY	ETF	127.33	128.265	127.28	127.61	4706400.0
2006-08-08 17:00:00	SPY	ETF	127.61	127.7	127.56	127.7	320800.0
2006-08-08 18:00:00	SPY	ETF	127.64	127.71	127.61	127.64	33000.0
2006-08-08 19:00:00	SPY	ETF	127.67	127.67	127.61	127.63	3200.0
2006-08-08 09:00:00	QQQ	ETF	36.82	36.85	36.66	36.75	8137100.0
2006-08-08 10:00:00	QQQ	ETF	36.75	36.85	36.74	36.79	10763000.0
2006-08-08 11:00:00	QQQ	ETF	36.8	36.9	36.74	36.77	6236500.0
2006-08-08 12:00:00	QQQ	ETF	36.77	36.83	36.75	36.77	2718600.0
2006-08-08 13:00:00	QQQ	ETF	36.77	36.8	36.68	36.69	3232000.0
2006-08-08 14:00:00	QQQ	ETF	36.69	36.88	36.26	36.51	63107300.0
2006-08-08 15:00:00	QQQ	ETF	36.51	36.58	36.3	36.49	25142200.0
2006-08-08 08:00:00	IWM	ETF	69.58	69.67	69.33	69.42	1201200.0
2006-08-08 09:00:00	IWM	ETF	69.41	69.61	69.04	69.32	4849300.0
2006-08-08 10:00:00	IWM	ETF	69.32	69.5	69.21	69.3	3589900.0
2006-08-08 11:00:00	IWM	ETF	69.29	69.45	69.18	69.22	3120200.0
2006-08-08 12:00:00	IWM	ETF	69.22	69.35	69.21	69.28	2123000.0
2006-08-08 13:00:00	IWM	ETF	69.28	69.33	69.01	69.08	7063300.0
2006-08-08 14:00:00	IWM	ETF	69.08	69.96	68.56	68.78	31705300.0
2006-08-08 15:00:00	IWM	ETF	68.78	68.95	68.18	68.34	18239500.0
2006-08-08 16:00:00	IWM	ETF	68.35	68.58	68.32	68.58	2401300.0
2006-08-08 17:00:00	IWM	ETF	68.51	68.72	68.48	68.72	227300.0
2006-08-08 18:00:00	IWM	ETF	68.67	68.72	68.67	68.7	11300.0
2006-08-08 19:00:00	IWM	ETF	68.7	68.7	68.7	68.7	300.0
2006-08-08 08:00:00	DIA	ETF	112.55	112.62	112.33	112.34	32100.0
2006-08-08 09:00:00	DIA	ETF	112.36	112.61	112.34	112.59	622700.0
2006-08-08 10:00:00	DIA	ETF	112.58	112.71	112.55	112.57	422900.0
2006-08-08 11:00:00	DIA	ETF	112.55	112.6	112.46	112.46	347600.0
2006-08-08 12:00:00	DIA	ETF	112.46	112.54	112.4	112.44	138800.0
2006-08-08 13:00:00	DIA	ETF	112.43	112.44	112.27	112.32	408700.0
2006-08-08 14:00:00	DIA	ETF	112.3	112.76	111.15	111.86	5037600.0
2006-08-08 15:00:00	DIA	ETF	111.86	112.0	111.39	111.72	1725900.0
2006-08-08 16:00:00	DIA	ETF	111.71	111.9	111.71	111.9	64800.0
2006-08-08 17:00:00	DIA	ETF	112.0	112.05	112.0	112.05	1600.0
2006-08-08 18:00:00	DIA	ETF	112.08	112.08	112.08	112.08	300.0
2006-08-08 19:00:00	DIA	ETF	112.0	112.15	112.0	112.15	200.0
2006-08-08 07:00:00	GLD	ETF	64.05	64.05	64.0	64.0	1000.0
2006-08-08 08:00:00	GLD	ETF	64.0	64.02	63.75	63.83	112500.0
2006-08-08 09:00:00	GLD	ETF	63.83	64.28	63.7	64.24	459200.0
2006-08-08 10:00:00	GLD	ETF	64.25	64.27	64.064	64.1	267600.0

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

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