PREVIEW / etf_1hour / 2006-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-22.parquet
  size:    51 KB
  rows:    1,616

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-22 07:00:00	SPY	ETF	131.54	131.66	131.54	131.62	42800.0
2006-09-22 08:00:00	SPY	ETF	131.59	131.7	131.49	131.67	1175900.0
2006-09-22 09:00:00	SPY	ETF	131.69	131.71	131.41	131.44	7479500.0
2006-09-22 10:00:00	SPY	ETF	131.45	131.45	131.0	131.04	15267900.0
2006-09-22 11:00:00	SPY	ETF	131.05	131.36	131.0	131.3	9334300.0
2006-09-22 12:00:00	SPY	ETF	131.3	131.3	131.0	131.26	7199800.0
2006-09-22 13:00:00	SPY	ETF	131.26	131.37	131.14	131.26	9630900.0
2006-09-22 14:00:00	SPY	ETF	131.25	131.33	131.01	131.15	5461700.0
2006-09-22 15:00:00	SPY	ETF	131.15	131.54	131.13	131.4	8885100.0
2006-09-22 16:00:00	SPY	ETF	131.39	131.5	131.36	131.45	629600.0
2006-09-22 17:00:00	SPY	ETF	131.5	131.6	131.5	131.5	15500.0
2006-09-22 18:00:00	SPY	ETF	131.52	131.52	131.52	131.52	2000.0
2006-09-22 09:00:00	QQQ	ETF	40.16	40.16	39.93	39.96	15835400.0
2006-09-22 10:00:00	QQQ	ETF	39.97	39.98	38.84	39.83	21116800.0
2006-09-22 11:00:00	QQQ	ETF	39.83	39.95	39.79	39.89	11029800.0
2006-09-22 12:00:00	QQQ	ETF	39.9	39.9	39.7	39.83	9335500.0
2006-09-22 13:00:00	QQQ	ETF	39.82	39.92	39.79	39.84	9320100.0
2006-09-22 14:00:00	QQQ	ETF	39.83	39.9	39.74	39.8	7725400.0
2006-09-22 15:00:00	QQQ	ETF	39.8	39.97	39.78	39.87	17753200.0
2006-09-22 08:00:00	IWM	ETF	72.06	72.5	72.0	72.18	80800.0
2006-09-22 09:00:00	IWM	ETF	72.2	72.21	71.7	71.71	5447600.0
2006-09-22 10:00:00	IWM	ETF	71.72	71.73	71.3	71.31	11338900.0
2006-09-22 11:00:00	IWM	ETF	71.31	71.6	71.24	71.53	10057400.0
2006-09-22 12:00:00	IWM	ETF	71.53	71.54	71.06	71.22	5039700.0
2006-09-22 13:00:00	IWM	ETF	71.22	71.6	71.19	71.31	5198100.0
2006-09-22 14:00:00	IWM	ETF	71.31	71.38	71.1	71.24	4261800.0
2006-09-22 15:00:00	IWM	ETF	71.24	71.7	71.21	71.59	10372400.0
2006-09-22 16:00:00	IWM	ETF	71.58	72.4155	71.33	71.33	4457900.0
2006-09-22 17:00:00	IWM	ETF	71.5	71.54	71.35	71.35	11200.0
2006-09-22 08:00:00	DIA	ETF	115.16	115.2	115.13	115.2	7800.0
2006-09-22 09:00:00	DIA	ETF	115.19	115.28	115.08	115.14	601700.0
2006-09-22 10:00:00	DIA	ETF	115.14	115.14	114.77	114.8	1039900.0
2006-09-22 11:00:00	DIA	ETF	114.79	115.07	114.77	114.98	677300.0
2006-09-22 12:00:00	DIA	ETF	114.99	114.99	114.69	114.87	1279200.0
2006-09-22 13:00:00	DIA	ETF	114.88	114.99	114.81	114.92	296100.0
2006-09-22 14:00:00	DIA	ETF	114.91	114.95	114.67	114.74	350200.0
2006-09-22 15:00:00	DIA	ETF	114.74	115.11	114.72	115.01	1465400.0
2006-09-22 16:00:00	DIA	ETF	115.0	115.11	114.94	115.0	72200.0
2006-09-22 17:00:00	DIA	ETF	114.98	115.03	114.98	115.03	1000.0
2006-09-22 18:00:00	DIA	ETF	115.03	115.03	115.03	115.03	200.0
2006-09-22 06:00:00	GLD	ETF	58.6	58.6	58.6	58.6	1000.0
2006-09-22 07:00:00	GLD	ETF	58.6	58.65	58.53	58.65	9600.0
2006-09-22 08:00:00	GLD	ETF	58.58	58.64	58.47	58.59	44100.0
2006-09-22 09:00:00	GLD	ETF	58.65	58.76	58.42	58.46	743800.0
2006-09-22 10:00:00	GLD	ETF	58.45	58.5	57.99	58.1	768500.0
2006-09-22 11:00:00	GLD	ETF	58.1191	58.39	58.0301	58.33	360200.0
2006-09-22 12:00:00	GLD	ETF	58.33	58.49	58.26	58.42	288500.0
2006-09-22 13:00:00	GLD	ETF	58.42	58.6	58.33	58.52	359500.0
2006-09-22 14:00:00	GLD	ETF	58.48	58.54	58.35	58.41	370200.0
2006-09-22 15:00:00	GLD	ETF	58.4199	58.55	58.4	58.46	365200.0

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

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