PREVIEW / etf_1hour / 2006-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-19.parquet
  size:    53 KB
  rows:    1,654

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-19 06:00:00	SPY	ETF	131.75	131.75	131.75	131.75	1000.0
2006-09-19 07:00:00	SPY	ETF	131.7	131.83	131.7	131.82	291000.0
2006-09-19 08:00:00	SPY	ETF	131.73	132.2	131.53	132.2	3918900.0
2006-09-19 09:00:00	SPY	ETF	132.2	132.23	131.77	131.83	9672900.0
2006-09-19 10:00:00	SPY	ETF	131.83	131.97	131.65	131.75	9953000.0
2006-09-19 11:00:00	SPY	ETF	131.75	131.96	131.33	131.42	17938800.0
2006-09-19 12:00:00	SPY	ETF	131.42	131.8	131.11	131.27	12782600.0
2006-09-19 13:00:00	SPY	ETF	131.27	131.33	131.07	131.23	8335600.0
2006-09-19 14:00:00	SPY	ETF	131.23	131.46	131.17	131.3	8560300.0
2006-09-19 15:00:00	SPY	ETF	131.31	131.995	131.26	131.74	15434200.0
2006-09-19 16:00:00	SPY	ETF	131.75	131.98	131.716	131.94	1515000.0
2006-09-19 17:00:00	SPY	ETF	131.93	132.01	131.9	131.95	35200.0
2006-09-19 18:00:00	SPY	ETF	131.95	131.95	131.87	131.87	7700.0
2006-09-19 19:00:00	SPY	ETF	131.91	131.93	131.88	131.88	10600.0
2006-09-19 09:00:00	QQQ	ETF	40.25	40.25	40.03	40.09	11852400.0
2006-09-19 10:00:00	QQQ	ETF	40.09	40.18	39.95	40.07	18302000.0
2006-09-19 11:00:00	QQQ	ETF	40.07	40.19	39.65	39.71	34358500.0
2006-09-19 12:00:00	QQQ	ETF	39.71	39.8	39.52	39.63	30419000.0
2006-09-19 13:00:00	QQQ	ETF	39.63	39.67	39.54	39.6	11028200.0
2006-09-19 14:00:00	QQQ	ETF	39.6	39.72	39.57	39.64	17185600.0
2006-09-19 15:00:00	QQQ	ETF	39.65	39.87	39.63	39.85	17272900.0
2006-09-19 07:00:00	IWM	ETF	72.43	72.45	72.43	72.45	5000.0
2006-09-19 08:00:00	IWM	ETF	72.45	72.88	72.39	72.64	570700.0
2006-09-19 09:00:00	IWM	ETF	72.82	72.84	72.22	72.35	3890900.0
2006-09-19 10:00:00	IWM	ETF	72.35	72.53	72.13	72.3	6089600.0
2006-09-19 11:00:00	IWM	ETF	72.3	72.55	71.42	71.5	13719100.0
2006-09-19 12:00:00	IWM	ETF	71.49	71.66	71.15	71.32	10613800.0
2006-09-19 13:00:00	IWM	ETF	71.32	71.43	71.18	71.32	6035900.0
2006-09-19 14:00:00	IWM	ETF	71.32	71.78	71.32	71.67	6528000.0
2006-09-19 15:00:00	IWM	ETF	71.67	72.32	71.63	72.21	13983100.0
2006-09-19 16:00:00	IWM	ETF	72.22	72.48	72.19	72.25	1744000.0
2006-09-19 17:00:00	IWM	ETF	72.41	72.41	72.41	72.41	600.0
2006-09-19 18:00:00	IWM	ETF	72.38	72.38	72.38	72.38	100.0
2006-09-19 08:00:00	DIA	ETF	115.27	115.61	115.27	115.58	497600.0
2006-09-19 09:00:00	DIA	ETF	115.61	115.65	115.17	115.23	1255100.0
2006-09-19 10:00:00	DIA	ETF	115.22	115.33	115.06	115.17	728000.0
2006-09-19 11:00:00	DIA	ETF	115.16	115.31	114.85	114.91	1534000.0
2006-09-19 12:00:00	DIA	ETF	114.91	114.97	114.68	114.85	995900.0
2006-09-19 13:00:00	DIA	ETF	114.85	114.92	114.7401	114.83	1369400.0
2006-09-19 14:00:00	DIA	ETF	114.84	115.05	114.84	114.92	664100.0
2006-09-19 15:00:00	DIA	ETF	114.92	115.37	114.89	115.35	1380600.0
2006-09-19 16:00:00	DIA	ETF	115.36	115.47	115.28	115.46	150100.0
2006-09-19 17:00:00	DIA	ETF	115.35	115.4	115.35	115.35	1100.0
2006-09-19 07:00:00	GLD	ETF	57.72	57.72	57.72	57.72	300.0
2006-09-19 08:00:00	GLD	ETF	57.78	58.05	57.68	57.96	90100.0
2006-09-19 09:00:00	GLD	ETF	57.89	58.11	57.83	57.93	509000.0
2006-09-19 10:00:00	GLD	ETF	57.91	57.98	57.51	57.63	950900.0
2006-09-19 11:00:00	GLD	ETF	57.62	57.74	57.25	57.66	992600.0
2006-09-19 12:00:00	GLD	ETF	57.64	57.66	57.28	57.39	781200.0
2006-09-19 13:00:00	GLD	ETF	57.4	57.5	57.05	57.12	588100.0

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

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