PREVIEW / etf_1hour / 2006-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-25.parquet
  size:    44 KB
  rows:    1,357

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-05-25 04:00:00	SPY	ETF	125.96	125.96	125.96	125.96	100.0
2006-05-25 05:00:00	SPY	ETF	126.19	126.19	126.19	126.19	100.0
2006-05-25 07:00:00	SPY	ETF	126.44	126.76	126.4	126.7	318700.0
2006-05-25 08:00:00	SPY	ETF	126.71	127.04	126.4	126.9	4742700.0
2006-05-25 09:00:00	SPY	ETF	126.92	127.07	125.95	126.92	12124400.0
2006-05-25 10:00:00	SPY	ETF	126.91	126.98	126.43	126.7	12071900.0
2006-05-25 11:00:00	SPY	ETF	126.7	127.31	126.61	127.31	9348100.0
2006-05-25 12:00:00	SPY	ETF	127.29	127.33	126.88	127.05	8059500.0
2006-05-25 13:00:00	SPY	ETF	127.05	127.17	126.92	127.04	5016500.0
2006-05-25 14:00:00	SPY	ETF	127.02	127.43	127.0	127.27	11845500.0
2006-05-25 15:00:00	SPY	ETF	127.28	127.66	127.11	127.63	9811200.0
2006-05-25 16:00:00	SPY	ETF	127.63	127.76	127.55	127.72	1413600.0
2006-05-25 17:00:00	SPY	ETF	127.71	127.71	127.62	127.64	17800.0
2006-05-25 18:00:00	SPY	ETF	127.63	127.66	127.6	127.66	10000.0
2006-05-25 19:00:00	SPY	ETF	127.62	127.62	127.62	127.62	300.0
2006-05-25 09:00:00	QQQ	ETF	39.08	39.19	39.03	39.11	16450800.0
2006-05-25 10:00:00	QQQ	ETF	39.12	39.14	38.82	38.94	25426200.0
2006-05-25 11:00:00	QQQ	ETF	38.94	39.19	38.89	39.18	15738900.0
2006-05-25 12:00:00	QQQ	ETF	39.19	39.22	39.0	39.11	16142500.0
2006-05-25 13:00:00	QQQ	ETF	39.11	39.14	39.05	39.11	5693900.0
2006-05-25 14:00:00	QQQ	ETF	39.1	39.24	38.18	39.18	12440000.0
2006-05-25 15:00:00	QQQ	ETF	39.18	39.37	39.13	39.37	18469200.0
2006-05-25 08:00:00	IWM	ETF	70.95	71.51	70.93	71.47	1365700.0
2006-05-25 09:00:00	IWM	ETF	71.5	71.74	71.25	71.61	12611600.0
2006-05-25 10:00:00	IWM	ETF	71.62	71.7	71.04	71.22	12722500.0
2006-05-25 11:00:00	IWM	ETF	71.2	71.85	71.07	71.84	7440300.0
2006-05-25 12:00:00	IWM	ETF	71.83	71.83	71.37	71.58	6711200.0
2006-05-25 13:00:00	IWM	ETF	71.59	71.73	71.47	71.62	3090200.0
2006-05-25 14:00:00	IWM	ETF	71.62	71.9	71.58	71.77	6496000.0
2006-05-25 15:00:00	IWM	ETF	71.77	72.18	71.57	72.17	11117500.0
2006-05-25 16:00:00	IWM	ETF	72.19	72.28	72.14	72.25	779700.0
2006-05-25 17:00:00	IWM	ETF	72.27	72.27	72.21	72.22	2500.0
2006-05-25 18:00:00	IWM	ETF	72.21	72.23	72.2	72.23	2100.0
2006-05-25 19:00:00	IWM	ETF	72.28	72.28	72.28	72.28	1200.0
2006-05-25 07:00:00	DIA	ETF	111.45	111.45	111.45	111.45	200.0
2006-05-25 08:00:00	DIA	ETF	111.4	111.61	111.28	111.52	30800.0
2006-05-25 09:00:00	DIA	ETF	111.52	111.65	111.39	111.5	1939200.0
2006-05-25 10:00:00	DIA	ETF	111.48	111.55	111.29	111.46	1607700.0
2006-05-25 11:00:00	DIA	ETF	111.45	111.96	111.39	111.92	1372300.0
2006-05-25 12:00:00	DIA	ETF	111.93	111.94	111.61	111.71	676300.0
2006-05-25 13:00:00	DIA	ETF	111.7	111.72	111.54	111.6	442800.0
2006-05-25 14:00:00	DIA	ETF	111.61	111.92	111.58	111.81	988100.0
2006-05-25 15:00:00	DIA	ETF	111.78	112.07	111.63	112.05	1424900.0
2006-05-25 16:00:00	DIA	ETF	112.06	112.15	111.92	112.15	39300.0
2006-05-25 17:00:00	DIA	ETF	112.14	112.14	112.14	112.14	100.0
2006-05-25 18:00:00	DIA	ETF	112.15	112.15	112.15	112.15	200.0
2006-05-25 07:00:00	GLD	ETF	63.81	63.81	63.81	63.81	200.0
2006-05-25 08:00:00	GLD	ETF	63.99	64.4	63.57	63.94	449500.0
2006-05-25 09:00:00	GLD	ETF	64.06	64.27	63.93	64.19	1045400.0
2006-05-25 10:00:00	GLD	ETF	64.2	64.24	63.76	64.14	1157400.0

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

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