PREVIEW / etf_1hour / 2005-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-01.parquet
  size:    30 KB
  rows:    940

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-08-01 06:00:00	SPY	ETF	123.78	123.8	123.78	123.78	65000.0
2005-08-01 07:00:00	SPY	ETF	123.84	123.87	123.76	123.76	6200.0
2005-08-01 08:00:00	SPY	ETF	123.78	123.86	123.78	123.83	238100.0
2005-08-01 09:00:00	SPY	ETF	123.84	123.95	123.73	123.88	4928300.0
2005-08-01 10:00:00	SPY	ETF	123.88	123.96	123.53	123.66	12058700.0
2005-08-01 11:00:00	SPY	ETF	123.66	123.87	123.45	123.67	3595500.0
2005-08-01 12:00:00	SPY	ETF	123.67	123.82	123.65	123.68	1812400.0
2005-08-01 13:00:00	SPY	ETF	123.681	123.73	123.48	123.62	3270700.0
2005-08-01 14:00:00	SPY	ETF	123.62	124.04	123.62	123.83	6330200.0
2005-08-01 15:00:00	SPY	ETF	123.83	123.94	123.55	123.55	5596200.0
2005-08-01 16:00:00	SPY	ETF	123.54	123.66	123.45	123.65	3367100.0
2005-08-01 17:00:00	SPY	ETF	123.64	123.72	123.64	123.66	332600.0
2005-08-01 18:00:00	SPY	ETF	123.68	123.7	123.67	123.7	10900.0
2005-08-01 19:00:00	SPY	ETF	123.69	123.69	123.69	123.69	400.0
2005-08-01 09:00:00	QQQ	ETF	39.64	39.74	39.63	39.71	8441300.0
2005-08-01 10:00:00	QQQ	ETF	39.71	39.74	39.52	39.58	16455400.0
2005-08-01 11:00:00	QQQ	ETF	39.57	39.65	39.52	39.63	5414300.0
2005-08-01 12:00:00	QQQ	ETF	39.63	39.71	39.61	39.62	4620400.0
2005-08-01 13:00:00	QQQ	ETF	39.62	39.65	39.55	39.62	3290600.0
2005-08-01 14:00:00	QQQ	ETF	39.62	39.83	39.62	39.71	10346800.0
2005-08-01 15:00:00	QQQ	ETF	39.72	39.79	39.64	39.65	7251800.0
2005-08-01 08:00:00	IWM	ETF	67.94	67.94	67.94	67.94	1000.0
2005-08-01 09:00:00	IWM	ETF	67.86	68.2	67.85	68.15	2319800.0
2005-08-01 10:00:00	IWM	ETF	68.15	68.23	67.8	67.88	4801700.0
2005-08-01 11:00:00	IWM	ETF	67.88	68.03	67.72	68.0	1875200.0
2005-08-01 12:00:00	IWM	ETF	68.0	68.06	67.85	67.89	767700.0
2005-08-01 13:00:00	IWM	ETF	67.89	67.95	67.76	67.91	1184100.0
2005-08-01 14:00:00	IWM	ETF	67.92	68.25	67.91	68.03	4233600.0
2005-08-01 15:00:00	IWM	ETF	68.03	68.22	67.8	67.81	2865600.0
2005-08-01 16:00:00	IWM	ETF	67.82	67.94	67.79	67.94	612900.0
2005-08-01 17:00:00	IWM	ETF	67.86	67.86	67.86	67.86	3700000.0
2005-08-01 18:00:00	IWM	ETF	67.88	67.88	67.88	67.88	2000.0
2005-08-01 07:00:00	DIA	ETF	106.68	106.68	106.68	106.68	100.0
2005-08-01 08:00:00	DIA	ETF	106.69	106.74	106.69	106.71	5800.0
2005-08-01 09:00:00	DIA	ETF	106.72	106.74	106.48	106.55	424500.0
2005-08-01 10:00:00	DIA	ETF	106.55	106.58	106.14	106.25	1936300.0
2005-08-01 11:00:00	DIA	ETF	106.26	106.27	106.1	106.23	735200.0
2005-08-01 12:00:00	DIA	ETF	106.27	106.34	106.2	106.27	248200.0
2005-08-01 13:00:00	DIA	ETF	106.28	106.3	106.1	106.22	211800.0
2005-08-01 14:00:00	DIA	ETF	106.21	106.53	106.21	106.34	381800.0
2005-08-01 15:00:00	DIA	ETF	106.35	106.46	106.18	106.18	593000.0
2005-08-01 16:00:00	DIA	ETF	106.15	106.25	106.12	106.25	74200.0
2005-08-01 17:00:00	DIA	ETF	106.25	106.25	106.11	106.11	4200.0
2005-08-01 18:00:00	DIA	ETF	106.15	106.3	106.15	106.3	200.0
2005-08-01 09:00:00	GLD	ETF	43.08	43.15	43.08	43.1	157700.0
2005-08-01 10:00:00	GLD	ETF	43.1	43.14	43.0	43.02	248500.0
2005-08-01 11:00:00	GLD	ETF	43.04	43.06	42.99	43.06	219100.0
2005-08-01 12:00:00	GLD	ETF	43.06	43.1	43.04	43.07	111900.0
2005-08-01 13:00:00	GLD	ETF	43.06	43.15	43.06	43.12	37900.0
2005-08-01 14:00:00	GLD	ETF	43.13	43.14	43.11	43.13	124300.0

> showing 50 of 940 rows — these rows as CSV

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