PREVIEW / etf_1hour / 2004-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-26.parquet
  size:    24 KB
  rows:    675

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-05-26 08:00:00	SPY	ETF	111.76	111.78	111.61	111.67	71800.0
2004-05-26 09:00:00	SPY	ETF	111.69	111.95	111.62	111.84	4818600.0
2004-05-26 10:00:00	SPY	ETF	111.85	111.97	111.51	111.87	7137600.0
2004-05-26 11:00:00	SPY	ETF	111.88	112.03	111.64	111.95	3994800.0
2004-05-26 12:00:00	SPY	ETF	111.95	112.1	111.84	111.97	2659700.0
2004-05-26 13:00:00	SPY	ETF	111.97	112.22	111.85	111.98	3338500.0
2004-05-26 14:00:00	SPY	ETF	111.98	112.29	111.78	112.07	5479700.0
2004-05-26 15:00:00	SPY	ETF	112.09	112.21	111.771	112.09	4728800.0
2004-05-26 16:00:00	SPY	ETF	112.09	112.24	111.8	112.16	1260300.0
2004-05-26 17:00:00	SPY	ETF	112.19	112.25	112.19	112.2	23300.0
2004-05-26 18:00:00	SPY	ETF	112.22	112.22	112.16	112.2	3000.0
2004-05-26 08:00:00	QQQ	ETF	35.89	35.9	35.83	35.86	138000.0
2004-05-26 09:00:00	QQQ	ETF	35.87	36.03	35.84	35.98	14083600.0
2004-05-26 10:00:00	QQQ	ETF	35.984	36.05	35.81	36.03	18062200.0
2004-05-26 11:00:00	QQQ	ETF	36.03	36.11	35.91	36.07	9136100.0
2004-05-26 12:00:00	QQQ	ETF	36.05	36.15	36.0	36.07	8845500.0
2004-05-26 13:00:00	QQQ	ETF	36.072	36.14	35.99	36.061	6883400.0
2004-05-26 14:00:00	QQQ	ETF	36.05	36.19	35.96	36.11	12722400.0
2004-05-26 15:00:00	QQQ	ETF	36.113	36.15	35.95	36.146	17239800.0
2004-05-26 16:00:00	QQQ	ETF	36.13	36.24	36.11	36.18	2521400.0
2004-05-26 17:00:00	QQQ	ETF	36.179	36.23	36.179	36.21	134000.0
2004-05-26 18:00:00	QQQ	ETF	36.21	36.23	36.19	36.2	31900.0
2004-05-26 19:00:00	QQQ	ETF	36.21	36.23	36.2	36.23	7900.0
2004-05-26 08:00:00	IWM	ETF	56.19	56.19	56.19	56.19	200.0
2004-05-26 09:00:00	IWM	ETF	56.21	56.515	56.17	56.445	1233800.0
2004-05-26 10:00:00	IWM	ETF	56.45	56.45	56.03	56.37	2116600.0
2004-05-26 11:00:00	IWM	ETF	56.36	56.44	56.25	56.4	1224000.0
2004-05-26 12:00:00	IWM	ETF	56.385	56.46	56.31	56.41	552200.0
2004-05-26 13:00:00	IWM	ETF	56.43	56.54	56.36	56.405	869000.0
2004-05-26 14:00:00	IWM	ETF	56.425	56.63	56.3	56.485	2293400.0
2004-05-26 15:00:00	IWM	ETF	56.51	56.625	56.345	56.605	2807400.0
2004-05-26 16:00:00	IWM	ETF	56.6	56.65	56.52	56.6	681400.0
2004-05-26 08:00:00	DIA	ETF	101.2	101.22	101.0	101.05	8800.0
2004-05-26 09:00:00	DIA	ETF	101.05	101.31	100.99	101.22	1440200.0
2004-05-26 10:00:00	DIA	ETF	101.22	101.27	100.86	101.15	972600.0
2004-05-26 11:00:00	DIA	ETF	101.12	101.33	101.02	101.23	613100.0
2004-05-26 12:00:00	DIA	ETF	101.2	101.35	101.13	101.27	766000.0
2004-05-26 13:00:00	DIA	ETF	101.26	101.38	101.1	101.19	462000.0
2004-05-26 14:00:00	DIA	ETF	101.22	101.45	101.05	101.28	663600.0
2004-05-26 15:00:00	DIA	ETF	101.32	101.4	101.04	101.27	1137200.0
2004-05-26 16:00:00	DIA	ETF	101.28	101.39	101.23	101.39	193700.0
2004-05-26 17:00:00	DIA	ETF	101.33	101.33	101.33	101.33	200.0
2004-05-26 18:00:00	DIA	ETF	101.33	101.39	101.33	101.39	500.0
2004-05-26 08:00:00	TLT	ETF	82.52	82.52	82.45	82.45	400.0
2004-05-26 09:00:00	TLT	ETF	82.4	82.45	82.32	82.36	106000.0
2004-05-26 10:00:00	TLT	ETF	82.39	82.49	82.37	82.44	67100.0
2004-05-26 11:00:00	TLT	ETF	82.48	82.48	82.36	82.42	29400.0
2004-05-26 12:00:00	TLT	ETF	82.42	82.54	82.41	82.54	12400.0
2004-05-26 13:00:00	TLT	ETF	82.55	82.57	82.5	82.5	6500.0
2004-05-26 14:00:00	TLT	ETF	82.52	82.63	82.52	82.58	41200.0

> showing 50 of 675 rows — these rows as CSV

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