PREVIEW / etf_1hour / 2005-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-28.parquet
  size:    31 KB
  rows:    939

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
2005-07-28 06:00:00	SPY	ETF	123.8	123.8	123.8	123.8	5700.0
2005-07-28 07:00:00	SPY	ETF	123.9	123.93	123.89	123.89	75500.0
2005-07-28 08:00:00	SPY	ETF	123.92	124.11	123.92	123.93	1139100.0
2005-07-28 09:00:00	SPY	ETF	124.07	124.21	123.93	124.04	6251300.0
2005-07-28 10:00:00	SPY	ETF	124.02	124.08	123.64	123.98	7985300.0
2005-07-28 11:00:00	SPY	ETF	123.99	124.35	123.9	124.29	7821900.0
2005-07-28 12:00:00	SPY	ETF	124.27	124.34	124.18	124.24	2547200.0
2005-07-28 13:00:00	SPY	ETF	124.23	124.53	124.19	124.38	4508900.0
2005-07-28 14:00:00	SPY	ETF	124.39	124.64	124.33	124.52	5564600.0
2005-07-28 15:00:00	SPY	ETF	124.52	124.55	124.34	124.5	9659900.0
2005-07-28 16:00:00	SPY	ETF	124.5	124.6	124.47	124.58	1058700.0
2005-07-28 17:00:00	SPY	ETF	124.58	124.62	124.45	124.62	326900.0
2005-07-28 18:00:00	SPY	ETF	124.62	124.62	124.58	124.58	17200.0
2005-07-28 19:00:00	SPY	ETF	124.6	124.6	124.6	124.6	100.0
2005-07-28 09:00:00	QQQ	ETF	39.74	39.8	39.67	39.77	8604000.0
2005-07-28 10:00:00	QQQ	ETF	39.77	39.81	39.64	39.76	13101100.0
2005-07-28 11:00:00	QQQ	ETF	39.76	39.88	39.72	39.85	8943300.0
2005-07-28 12:00:00	QQQ	ETF	39.84	39.87	39.79	39.82	4953600.0
2005-07-28 13:00:00	QQQ	ETF	39.81	39.92	39.8	39.85	6197600.0
2005-07-28 14:00:00	QQQ	ETF	39.85	39.91	39.83	39.9	6324200.0
2005-07-28 15:00:00	QQQ	ETF	39.9	39.91	39.81	39.9	12152300.0
2005-07-28 07:00:00	IWM	ETF	67.28	67.28	67.28	67.28	1000.0
2005-07-28 08:00:00	IWM	ETF	67.46	67.46	67.4	67.42	26500.0
2005-07-28 09:00:00	IWM	ETF	67.43	67.56	67.27	67.35	2572500.0
2005-07-28 10:00:00	IWM	ETF	67.35	67.43	67.02	67.23	2574200.0
2005-07-28 11:00:00	IWM	ETF	67.23	67.5	67.15	67.44	1850700.0
2005-07-28 12:00:00	IWM	ETF	67.46	67.57	67.43	67.49	1153700.0
2005-07-28 13:00:00	IWM	ETF	67.49	67.73	67.45	67.55	1969600.0
2005-07-28 14:00:00	IWM	ETF	67.56	67.9	67.55	67.83	3898700.0
2005-07-28 15:00:00	IWM	ETF	67.84	68.0	67.78	67.95	6083800.0
2005-07-28 16:00:00	IWM	ETF	67.96	67.99	67.9	67.92	943000.0
2005-07-28 17:00:00	IWM	ETF	67.99	67.99	67.99	67.99	200.0
2005-07-28 08:00:00	DIA	ETF	106.5	106.66	106.5	106.66	6300.0
2005-07-28 09:00:00	DIA	ETF	106.65	106.77	106.57	106.65	1108200.0
2005-07-28 10:00:00	DIA	ETF	106.65	106.67	106.33	106.6	440800.0
2005-07-28 11:00:00	DIA	ETF	106.58	106.85	106.54	106.82	608500.0
2005-07-28 12:00:00	DIA	ETF	106.82	106.84	106.73	106.79	398400.0
2005-07-28 13:00:00	DIA	ETF	106.78	106.99	106.73	106.84	669000.0
2005-07-28 14:00:00	DIA	ETF	106.84	107.13	106.8	107.05	1205300.0
2005-07-28 15:00:00	DIA	ETF	107.05	107.11	106.89	107.05	2021900.0
2005-07-28 16:00:00	DIA	ETF	107.03	107.8	107.03	107.07	73200.0
2005-07-28 17:00:00	DIA	ETF	107.07	107.07	107.07	107.07	200.0
2005-07-28 08:00:00	GLD	ETF	42.45	42.45	42.45	42.45	50000.0
2005-07-28 09:00:00	GLD	ETF	42.45	42.63	42.43	42.56	426700.0
2005-07-28 10:00:00	GLD	ETF	42.56	42.68	42.54	42.66	211700.0
2005-07-28 11:00:00	GLD	ETF	42.66	42.68	42.61	42.64	1819700.0
2005-07-28 12:00:00	GLD	ETF	42.64	42.79	42.63	42.75	543200.0
2005-07-28 13:00:00	GLD	ETF	42.75	42.75	42.62	42.72	239900.0
2005-07-28 14:00:00	GLD	ETF	42.72	42.75	42.68	42.74	167800.0
2005-07-28 15:00:00	GLD	ETF	42.74	42.77	42.7	42.75	198700.0

> showing 50 of 939 rows — these rows as CSV

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