PREVIEW / etf_1hour / 2005-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-21.parquet
  size:    32 KB
  rows:    954

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-21 07:00:00	SPY	ETF	123.5	124.33	123.42	123.69	896700.0
2005-07-21 08:00:00	SPY	ETF	123.98	123.98	123.12	123.61	7583300.0
2005-07-21 09:00:00	SPY	ETF	123.64	123.77	123.2	123.31	8574300.0
2005-07-21 10:00:00	SPY	ETF	123.29	123.41	122.47	122.64	18840400.0
2005-07-21 11:00:00	SPY	ETF	122.63	122.99	122.56	122.74	7588000.0
2005-07-21 12:00:00	SPY	ETF	122.74	123.55	122.66	123.37	14570000.0
2005-07-21 13:00:00	SPY	ETF	123.39	123.61	123.12	123.15	6481100.0
2005-07-21 14:00:00	SPY	ETF	123.14	123.18	122.57	122.72	21000200.0
2005-07-21 15:00:00	SPY	ETF	122.7	123.0	122.66	122.69	11310300.0
2005-07-21 16:00:00	SPY	ETF	122.7	122.93	122.49	122.52	1743500.0
2005-07-21 17:00:00	SPY	ETF	122.52	122.54	122.51	122.52	38000.0
2005-07-21 18:00:00	SPY	ETF	122.57	122.65	122.57	122.65	3100.0
2005-07-21 19:00:00	SPY	ETF	122.66	122.66	122.63	122.63	2100.0
2005-07-21 09:00:00	QQQ	ETF	39.56	39.57	38.49	39.51	11137900.0
2005-07-21 10:00:00	QQQ	ETF	39.51	39.53	39.21	39.27	21922000.0
2005-07-21 11:00:00	QQQ	ETF	39.27	39.44	39.25	39.37	14313700.0
2005-07-21 12:00:00	QQQ	ETF	39.38	39.67	39.31	39.62	17002700.0
2005-07-21 13:00:00	QQQ	ETF	39.62	39.69	39.52	39.58	11314700.0
2005-07-21 14:00:00	QQQ	ETF	39.58	39.61	39.35	39.37	11348200.0
2005-07-21 15:00:00	QQQ	ETF	39.38	39.53	39.36	39.46	15581500.0
2005-07-21 07:00:00	IWM	ETF	67.32	67.71	67.32	67.4	27200.0
2005-07-21 08:00:00	IWM	ETF	67.39	67.46	67.06	67.46	38500.0
2005-07-21 09:00:00	IWM	ETF	67.5	67.5	66.96	67.16	3014200.0
2005-07-21 10:00:00	IWM	ETF	67.16	67.18	66.26	66.33	7966500.0
2005-07-21 11:00:00	IWM	ETF	66.32	67.27	66.29	66.45	5199900.0
2005-07-21 12:00:00	IWM	ETF	66.45	67.28	66.43	67.24	6657800.0
2005-07-21 13:00:00	IWM	ETF	67.24	67.35	66.92	67.02	2138700.0
2005-07-21 14:00:00	IWM	ETF	67.02	67.04	66.52	66.64	9044200.0
2005-07-21 15:00:00	IWM	ETF	66.64	66.73	66.22	66.22	7328300.0
2005-07-21 16:00:00	IWM	ETF	66.22	66.39	66.16	66.16	239600.0
2005-07-21 17:00:00	IWM	ETF	66.22	66.23	66.15	66.15	2500.0
2005-07-21 07:00:00	DIA	ETF	107.41	108.0	106.8	106.8	16400.0
2005-07-21 08:00:00	DIA	ETF	106.91	107.05	106.59	106.88	146800.0
2005-07-21 09:00:00	DIA	ETF	106.95	106.98	106.52	106.67	823000.0
2005-07-21 10:00:00	DIA	ETF	106.67	106.72	106.02	106.15	2710900.0
2005-07-21 11:00:00	DIA	ETF	106.16	106.44	106.14	106.27	1519900.0
2005-07-21 12:00:00	DIA	ETF	106.27	106.9	106.22	106.79	1313800.0
2005-07-21 13:00:00	DIA	ETF	106.82	106.99	106.55	106.59	622200.0
2005-07-21 14:00:00	DIA	ETF	106.59	106.62	106.17	106.28	634400.0
2005-07-21 15:00:00	DIA	ETF	106.28	106.45	106.17	106.17	834600.0
2005-07-21 16:00:00	DIA	ETF	106.21	106.21	106.05	106.07	14500.0
2005-07-21 17:00:00	DIA	ETF	106.05	106.05	106.05	106.05	10000.0
2005-07-21 18:00:00	DIA	ETF	106.1	106.1	106.1	106.1	1000.0
2005-07-21 07:00:00	GLD	ETF	42.3	42.5	42.3	42.38	20000.0
2005-07-21 08:00:00	GLD	ETF	42.34	42.47	42.34	42.45	4500.0
2005-07-21 09:00:00	GLD	ETF	42.5	42.5	42.34	42.37	346400.0
2005-07-21 10:00:00	GLD	ETF	42.35	42.41	42.34	42.35	459800.0
2005-07-21 11:00:00	GLD	ETF	42.35	42.41	42.33	42.34	245800.0
2005-07-21 12:00:00	GLD	ETF	42.35	42.44	42.34	42.43	251700.0
2005-07-21 13:00:00	GLD	ETF	42.43	42.49	42.43	42.48	189800.0

> showing 50 of 954 rows — these rows as CSV

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