PREVIEW / etf_1hour / 2006-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-20.parquet
  size:    52 KB
  rows:    1,662

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-09-20 06:00:00	SPY	ETF	132.27	132.34	132.27	132.34	5000.0
2006-09-20 07:00:00	SPY	ETF	132.25	132.35	132.23	132.3	106400.0
2006-09-20 08:00:00	SPY	ETF	132.3	132.38	132.23	132.28	712200.0
2006-09-20 09:00:00	SPY	ETF	132.29	132.56	132.23	132.48	9635300.0
2006-09-20 10:00:00	SPY	ETF	132.48	132.68	132.34	132.55	11629700.0
2006-09-20 11:00:00	SPY	ETF	132.54	132.62	132.46	132.48	5922400.0
2006-09-20 12:00:00	SPY	ETF	132.48	132.58	132.42	132.46	3798200.0
2006-09-20 13:00:00	SPY	ETF	132.46	132.65	132.41	132.62	3060000.0
2006-09-20 14:00:00	SPY	ETF	132.62	132.77	132.06	132.35	23605800.0
2006-09-20 15:00:00	SPY	ETF	132.35	132.58	132.3	132.41	13004400.0
2006-09-20 16:00:00	SPY	ETF	132.42	132.56	132.4	132.49	1179000.0
2006-09-20 17:00:00	SPY	ETF	132.49	132.49	132.45	132.49	12900.0
2006-09-20 18:00:00	SPY	ETF	132.46	132.5	132.46	132.5	8700.0
2006-09-20 19:00:00	SPY	ETF	132.45	132.45	132.44	132.44	600.0
2006-09-20 09:00:00	QQQ	ETF	40.2	40.38	40.19	40.33	17016700.0
2006-09-20 10:00:00	QQQ	ETF	40.33	40.51	40.25	40.46	17841000.0
2006-09-20 11:00:00	QQQ	ETF	40.46	40.54	40.44	40.45	10604200.0
2006-09-20 12:00:00	QQQ	ETF	40.45	40.49	40.39	40.39	5309800.0
2006-09-20 13:00:00	QQQ	ETF	40.4	40.48	40.36	40.46	5188500.0
2006-09-20 14:00:00	QQQ	ETF	40.46	40.53	40.21	40.34	34890200.0
2006-09-20 15:00:00	QQQ	ETF	40.34	40.48	40.31	40.45	13002700.0
2006-09-20 07:00:00	IWM	ETF	72.2	72.4	72.2	72.4	600.0
2006-09-20 08:00:00	IWM	ETF	72.56	72.81	72.56	72.76	520400.0
2006-09-20 09:00:00	IWM	ETF	72.75	73.06	72.7	73.02	8176800.0
2006-09-20 10:00:00	IWM	ETF	73.02	73.5	72.91	73.29	12420500.0
2006-09-20 11:00:00	IWM	ETF	73.29	73.4	73.19	73.24	3369800.0
2006-09-20 12:00:00	IWM	ETF	73.24	73.31	73.17	73.17	2227000.0
2006-09-20 13:00:00	IWM	ETF	73.17	73.32	73.12	73.32	2984500.0
2006-09-20 14:00:00	IWM	ETF	73.32	73.45	72.73	72.98	15032400.0
2006-09-20 15:00:00	IWM	ETF	72.98	73.34	72.91	73.11	9058500.0
2006-09-20 16:00:00	IWM	ETF	73.1	73.32	73.1	73.3	412500.0
2006-09-20 17:00:00	IWM	ETF	73.3	73.3	73.27	73.27	1700.0
2006-09-20 18:00:00	IWM	ETF	73.27	73.27	73.27	73.27	3000.0
2006-09-20 08:00:00	DIA	ETF	115.69	115.78	115.67	115.69	16000.0
2006-09-20 09:00:00	DIA	ETF	115.7	115.92	115.63	115.89	1044300.0
2006-09-20 10:00:00	DIA	ETF	115.9	116.06	115.76	116.0	2038500.0
2006-09-20 11:00:00	DIA	ETF	116.01	116.09	115.95	115.98	622100.0
2006-09-20 12:00:00	DIA	ETF	115.98	115.98	115.86	115.87	319300.0
2006-09-20 13:00:00	DIA	ETF	115.87	116.06	115.84	116.05	411300.0
2006-09-20 14:00:00	DIA	ETF	116.06	116.21	115.7	115.93	3128300.0
2006-09-20 15:00:00	DIA	ETF	115.93	116.16	115.9	116.05	1220000.0
2006-09-20 16:00:00	DIA	ETF	116.05	116.1	116.04	116.08	20000.0
2006-09-20 17:00:00	DIA	ETF	116.07	116.1	116.07	116.1	1800.0
2006-09-20 07:00:00	GLD	ETF	56.8	56.8	56.8	56.8	500.0
2006-09-20 08:00:00	GLD	ETF	57.19	57.65	57.07	57.5	157800.0
2006-09-20 09:00:00	GLD	ETF	57.5	57.9	57.5	57.62	851200.0
2006-09-20 10:00:00	GLD	ETF	57.61	57.85	57.54	57.72	1586200.0
2006-09-20 11:00:00	GLD	ETF	57.72	58.24	57.66	57.87	901700.0
2006-09-20 12:00:00	GLD	ETF	57.87	58.07	57.58	57.69	509800.0
2006-09-20 13:00:00	GLD	ETF	57.68	57.81	57.54	57.64	386300.0

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

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