PREVIEW / etf_1hour / 2004-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-28.parquet
  size:    27 KB
  rows:    793

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
2004-12-28 08:00:00	SPY	ETF	120.6	120.64	120.56	120.57	21400.0
2004-12-28 09:00:00	SPY	ETF	120.59	120.84	120.59	120.79	2873900.0
2004-12-28 10:00:00	SPY	ETF	120.79	121.3	120.79	121.12	6918200.0
2004-12-28 11:00:00	SPY	ETF	121.13	121.2	120.99	121.06	2361500.0
2004-12-28 12:00:00	SPY	ETF	121.07	121.1	120.99	121.06	1143900.0
2004-12-28 13:00:00	SPY	ETF	121.06	121.13	120.9	121.06	2465200.0
2004-12-28 14:00:00	SPY	ETF	121.06	121.2	120.98	121.04	1944100.0
2004-12-28 15:00:00	SPY	ETF	121.04	121.27	121.03	121.24	3352600.0
2004-12-28 16:00:00	SPY	ETF	121.24	121.33	120.97	121.24	1275900.0
2004-12-28 17:00:00	SPY	ETF	121.26	121.28	121.24	121.25	5800.0
2004-12-28 18:00:00	SPY	ETF	121.27	121.3	121.25	121.3	1100.0
2004-12-28 08:00:00	QQQ	ETF	39.64	39.67	39.64	39.648	113390.0
2004-12-28 09:00:00	QQQ	ETF	39.65	39.704	39.61	39.663	6800094.0
2004-12-28 10:00:00	QQQ	ETF	39.66	40.001	39.66	39.971	18513367.0
2004-12-28 11:00:00	QQQ	ETF	39.96	39.997	39.84	39.883	7056098.0
2004-12-28 12:00:00	QQQ	ETF	39.88	39.911	39.84	39.9	3203355.0
2004-12-28 13:00:00	QQQ	ETF	39.9	39.941	39.83	39.912	5329588.0
2004-12-28 14:00:00	QQQ	ETF	39.913	39.956	39.839	39.875	5723791.0
2004-12-28 15:00:00	QQQ	ETF	39.87	39.976	39.87	39.97	10620008.0
2004-12-28 16:00:00	QQQ	ETF	39.98	40.01	39.95	39.99	3489894.0
2004-12-28 17:00:00	QQQ	ETF	40.0	40.028	39.98	40.01	43065.0
2004-12-28 18:00:00	QQQ	ETF	40.01	40.02	40.0	40.02	33180.0
2004-12-28 09:00:00	IWM	ETF	64.235	64.57	64.23	64.485	1520600.0
2004-12-28 10:00:00	IWM	ETF	64.495	64.825	64.495	64.765	1497200.0
2004-12-28 11:00:00	IWM	ETF	64.77	64.795	64.605	64.71	701200.0
2004-12-28 12:00:00	IWM	ETF	64.71	64.765	64.65	64.765	671400.0
2004-12-28 13:00:00	IWM	ETF	64.77	64.95	64.68	64.895	1003200.0
2004-12-28 14:00:00	IWM	ETF	64.895	64.965	64.755	64.88	660200.0
2004-12-28 15:00:00	IWM	ETF	64.87	65.1	64.84	65.07	1751400.0
2004-12-28 16:00:00	IWM	ETF	65.08	65.145	64.995	65.085	232800.0
2004-12-28 09:00:00	DIA	ETF	107.87	108.06	107.8	107.96	431700.0
2004-12-28 10:00:00	DIA	ETF	107.99	108.44	107.99	108.33	850800.0
2004-12-28 11:00:00	DIA	ETF	108.36	108.43	108.22	108.25	509700.0
2004-12-28 12:00:00	DIA	ETF	108.28	108.29	108.19	108.25	199300.0
2004-12-28 13:00:00	DIA	ETF	108.28	108.34	108.16	108.23	178400.0
2004-12-28 14:00:00	DIA	ETF	108.24	108.33	108.2	108.23	519900.0
2004-12-28 15:00:00	DIA	ETF	108.24	108.47	108.23	108.41	447400.0
2004-12-28 16:00:00	DIA	ETF	108.42	108.46	108.39	108.46	94000.0
2004-12-28 18:00:00	DIA	ETF	108.5	108.5	108.5	108.5	200.0
2004-12-28 19:00:00	DIA	ETF	108.5	108.5	108.5	108.5	500.0
2004-12-28 09:00:00	GLD	ETF	44.42	44.47	44.39	44.43	90700.0
2004-12-28 10:00:00	GLD	ETF	44.41	44.41	44.3	44.36	303100.0
2004-12-28 11:00:00	GLD	ETF	44.36	44.41	44.29	44.37	76800.0
2004-12-28 12:00:00	GLD	ETF	44.38	44.43	44.38	44.4	50700.0
2004-12-28 13:00:00	GLD	ETF	44.4	44.43	44.36	44.4	58800.0
2004-12-28 14:00:00	GLD	ETF	44.38	44.42	44.356	44.38	95400.0
2004-12-28 15:00:00	GLD	ETF	44.4	44.4	44.36	44.39	96000.0
2004-12-28 16:00:00	GLD	ETF	44.39	44.39	44.37	44.37	1500.0
2004-12-28 09:00:00	TLT	ETF	87.8	87.86	87.76	87.76	56500.0
2004-12-28 10:00:00	TLT	ETF	87.75	87.75	87.4	87.62	133300.0

> showing 50 of 793 rows — these rows as CSV

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