PREVIEW / etf_1hour / 2006-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-04.parquet
  size:    39 KB
  rows:    1,212

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-01-04 07:00:00	SPY	ETF	126.69	126.69	126.65	126.65	18200.0
2006-01-04 08:00:00	SPY	ETF	126.6	126.87	126.6	126.82	1410800.0
2006-01-04 09:00:00	SPY	ETF	126.82	127.02	126.7	126.89	6717900.0
2006-01-04 10:00:00	SPY	ETF	126.89	127.27	126.84	127.11	7446900.0
2006-01-04 11:00:00	SPY	ETF	127.11	127.47	126.93	127.41	8400000.0
2006-01-04 12:00:00	SPY	ETF	127.4	127.49	127.05	127.06	5370500.0
2006-01-04 13:00:00	SPY	ETF	127.06	127.12	126.83	127.02	4611700.0
2006-01-04 14:00:00	SPY	ETF	127.02	127.21	126.72	127.05	5880600.0
2006-01-04 15:00:00	SPY	ETF	127.03	127.4	126.99	127.27	8904000.0
2006-01-04 16:00:00	SPY	ETF	127.27	127.37	127.21	127.28	1232400.0
2006-01-04 17:00:00	SPY	ETF	127.27	127.31	127.16	127.16	327700.0
2006-01-04 18:00:00	SPY	ETF	127.17	127.24	127.16	127.2	312700.0
2006-01-04 19:00:00	SPY	ETF	127.2	127.23	127.2	127.23	1700.0
2006-01-04 09:00:00	QQQ	ETF	41.4	41.51	41.34	41.44	8261900.0
2006-01-04 10:00:00	QQQ	ETF	41.44	41.66	41.16	41.59	20024900.0
2006-01-04 11:00:00	QQQ	ETF	41.6	41.73	41.46	41.69	10355800.0
2006-01-04 12:00:00	QQQ	ETF	41.69	41.74	41.63	41.64	6670400.0
2006-01-04 13:00:00	QQQ	ETF	41.65	41.65	41.5	41.59	9892700.0
2006-01-04 14:00:00	QQQ	ETF	41.6	41.61	41.44	41.53	12475900.0
2006-01-04 15:00:00	QQQ	ETF	41.53	41.73	41.52	41.73	12285500.0
2006-01-04 08:00:00	IWM	ETF	67.94	68.14	67.94	68.12	1535800.0
2006-01-04 09:00:00	IWM	ETF	68.1	68.2	67.88	67.94	3884600.0
2006-01-04 10:00:00	IWM	ETF	67.94	68.36	67.94	68.35	3983500.0
2006-01-04 11:00:00	IWM	ETF	68.34	68.53	68.11	68.53	2823200.0
2006-01-04 12:00:00	IWM	ETF	68.53	68.65	68.45	68.47	3075500.0
2006-01-04 13:00:00	IWM	ETF	68.47	68.56	68.35	68.41	3662900.0
2006-01-04 14:00:00	IWM	ETF	68.41	68.55	68.14	68.34	4800000.0
2006-01-04 15:00:00	IWM	ETF	68.33	68.59	68.32	68.46	4698800.0
2006-01-04 16:00:00	IWM	ETF	68.47	68.49	68.3	68.43	385000.0
2006-01-04 17:00:00	IWM	ETF	68.37	68.39	68.37	68.39	6700.0
2006-01-04 18:00:00	IWM	ETF	68.31	68.31	68.31	68.31	500.0
2006-01-04 08:00:00	DIA	ETF	108.22	108.36	108.22	108.36	5000.0
2006-01-04 09:00:00	DIA	ETF	108.35	108.54	108.31	108.42	442600.0
2006-01-04 10:00:00	DIA	ETF	108.4499	108.71	108.42	108.52	713100.0
2006-01-04 11:00:00	DIA	ETF	108.54	108.83	108.4	108.79	1014700.0
2006-01-04 12:00:00	DIA	ETF	108.77	108.83	108.45	108.46	445400.0
2006-01-04 13:00:00	DIA	ETF	108.43	108.57	108.3	108.49	1512400.0
2006-01-04 14:00:00	DIA	ETF	108.5	108.68	108.27	108.55	599900.0
2006-01-04 15:00:00	DIA	ETF	108.54	108.86	108.52	108.75	578800.0
2006-01-04 16:00:00	DIA	ETF	108.75	108.82	108.7	108.76	398200.0
2006-01-04 07:00:00	GLD	ETF	53.2	53.2	53.18	53.18	4200.0
2006-01-04 08:00:00	GLD	ETF	53.19	53.23	52.59	52.59	83400.0
2006-01-04 09:00:00	GLD	ETF	52.62	53.16	52.43	53.02	956000.0
2006-01-04 10:00:00	GLD	ETF	53.01	53.01	52.62	52.75	1097300.0
2006-01-04 11:00:00	GLD	ETF	52.75	53.06	52.75	53.06	477400.0
2006-01-04 12:00:00	GLD	ETF	53.05	53.3	52.93	53.08	622100.0
2006-01-04 13:00:00	GLD	ETF	53.09	53.3	53.08	53.27	309500.0
2006-01-04 14:00:00	GLD	ETF	53.2601	53.31	53.2	53.23	640400.0
2006-01-04 15:00:00	GLD	ETF	53.23	53.34	52.99	53.32	589200.0
2006-01-04 16:00:00	GLD	ETF	53.32	53.32	53.27	53.27	503100.0

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

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