PREVIEW / etf_1hour / 2005-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-21.parquet
  size:    31 KB
  rows:    885

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-04-21 04:00:00	SPY	ETF	114.62	114.62	114.5	114.52	23700.0
2005-04-21 05:00:00	SPY	ETF	114.49	114.5	114.41	114.47	12100.0
2005-04-21 06:00:00	SPY	ETF	114.56	114.66	114.54	114.66	5000.0
2005-04-21 07:00:00	SPY	ETF	114.64	114.67	114.5	114.6	253700.0
2005-04-21 08:00:00	SPY	ETF	114.6	114.83	114.55	114.76	752800.0
2005-04-21 09:00:00	SPY	ETF	114.76	115.03	114.62	114.99	10718900.0
2005-04-21 10:00:00	SPY	ETF	114.98	115.02	114.46	114.64	15713700.0
2005-04-21 11:00:00	SPY	ETF	114.64	115.53	114.38	114.77	11191700.0
2005-04-21 12:00:00	SPY	ETF	114.76	115.3	114.76	115.07	12979500.0
2005-04-21 13:00:00	SPY	ETF	115.07	115.52	114.96	115.46	7103800.0
2005-04-21 14:00:00	SPY	ETF	115.45	115.9	115.39	115.73	12061800.0
2005-04-21 15:00:00	SPY	ETF	115.72	116.04	115.65	115.99	8851800.0
2005-04-21 16:00:00	SPY	ETF	116.02	116.21	115.93	115.93	4156300.0
2005-04-21 17:00:00	SPY	ETF	115.92	116.0	115.9	115.95	180500.0
2005-04-21 18:00:00	SPY	ETF	115.95	115.96	115.9	115.94	5300.0
2005-04-21 19:00:00	SPY	ETF	115.93	115.93	115.82	115.84	7600.0
2005-04-21 09:00:00	QQQ	ETF	35.09	35.26	35.06	35.22	16799800.0
2005-04-21 10:00:00	QQQ	ETF	35.22	35.23	35.01	35.14	19181700.0
2005-04-21 11:00:00	QQQ	ETF	35.14	35.22	34.96	35.21	12587300.0
2005-04-21 12:00:00	QQQ	ETF	35.22	35.39	34.37	35.29	18523000.0
2005-04-21 13:00:00	QQQ	ETF	35.29	35.43	35.26	35.42	9077000.0
2005-04-21 14:00:00	QQQ	ETF	35.43	35.59	35.4	35.51	16071600.0
2005-04-21 15:00:00	QQQ	ETF	35.51	35.71	35.5	35.64	20357800.0
2005-04-21 07:00:00	IWM	ETF	58.69	58.74	58.68	58.74	5000.0
2005-04-21 08:00:00	IWM	ETF	58.74	58.955	58.7	58.81	40600.0
2005-04-21 09:00:00	IWM	ETF	58.82	59.06	58.025	59.06	3951600.0
2005-04-21 10:00:00	IWM	ETF	59.06	59.07	58.475	58.67	6014200.0
2005-04-21 11:00:00	IWM	ETF	58.67	58.98	58.455	58.9	5547200.0
2005-04-21 12:00:00	IWM	ETF	58.9	59.305	58.885	59.11	5489200.0
2005-04-21 13:00:00	IWM	ETF	59.115	59.415	59.06	59.39	2257400.0
2005-04-21 14:00:00	IWM	ETF	59.395	59.58	59.365	59.465	3050000.0
2005-04-21 15:00:00	IWM	ETF	59.47	59.645	59.35	59.55	3776400.0
2005-04-21 16:00:00	IWM	ETF	59.54	59.695	59.54	59.575	1425400.0
2005-04-21 17:00:00	IWM	ETF	59.575	59.575	59.55	59.55	23000.0
2005-04-21 18:00:00	IWM	ETF	59.575	59.64	59.575	59.64	3000.0
2005-04-21 07:00:00	DIA	ETF	100.75	100.85	100.75	100.77	26000.0
2005-04-21 08:00:00	DIA	ETF	100.71	100.97	100.71	100.92	31500.0
2005-04-21 09:00:00	DIA	ETF	100.93	101.22	100.85	101.16	1046200.0
2005-04-21 10:00:00	DIA	ETF	101.16	101.18	100.75	100.89	1007200.0
2005-04-21 11:00:00	DIA	ETF	100.88	101.09	100.68	100.99	649300.0
2005-04-21 12:00:00	DIA	ETF	101.02	101.5	101.0	101.3	1392100.0
2005-04-21 13:00:00	DIA	ETF	101.31	101.63	101.24	101.59	742800.0
2005-04-21 14:00:00	DIA	ETF	101.62	102.01	101.56	101.89	891400.0
2005-04-21 15:00:00	DIA	ETF	101.86	102.19	101.82	102.12	1270800.0
2005-04-21 16:00:00	DIA	ETF	102.12	102.33	102.08	102.08	144800.0
2005-04-21 17:00:00	DIA	ETF	102.1	102.25	102.08	102.11	21700.0
2005-04-21 18:00:00	DIA	ETF	102.15	102.15	102.15	102.15	2900.0
2005-04-21 19:00:00	DIA	ETF	102.1	102.1	102.1	102.1	100.0
2005-04-21 08:00:00	GLD	ETF	43.34	43.34	43.34	43.34	1000.0
2005-04-21 09:00:00	GLD	ETF	43.42	43.43	43.31	43.35	160900.0

> showing 50 of 885 rows — these rows as CSV

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