PREVIEW / etf_1hour / 2005-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-05.parquet
  size:    29 KB
  rows:    841

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-01-05 08:00:00	SPY	ETF	118.71	118.82	118.57	118.57	431800.0
2005-01-05 09:00:00	SPY	ETF	118.57	119.14	118.56	118.91	7062100.0
2005-01-05 10:00:00	SPY	ETF	118.92	119.23	118.64	118.7	12302700.0
2005-01-05 11:00:00	SPY	ETF	118.71	119.16	118.62	118.83	10612400.0
2005-01-05 12:00:00	SPY	ETF	118.83	118.88	118.42	118.75	9101100.0
2005-01-05 13:00:00	SPY	ETF	118.75	119.25	118.74	119.0	8062700.0
2005-01-05 14:00:00	SPY	ETF	119.01	119.06	118.66	118.71	4064200.0
2005-01-05 15:00:00	SPY	ETF	118.7	119.01	118.29	118.32	8705300.0
2005-01-05 16:00:00	SPY	ETF	118.3	118.822	117.98	118.1	2130800.0
2005-01-05 17:00:00	SPY	ETF	118.1	118.12	118.07	118.1	188000.0
2005-01-05 18:00:00	SPY	ETF	118.11	118.14	118.11	118.13	27900.0
2005-01-05 19:00:00	SPY	ETF	118.19	118.22	118.17	118.17	6100.0
2005-01-05 09:00:00	QQQ	ETF	38.67	38.94	38.63	38.8	22608800.0
2005-01-05 10:00:00	QQQ	ETF	38.81	38.96	38.58	38.64	26160200.0
2005-01-05 11:00:00	QQQ	ETF	38.64	38.79	38.55	38.67	15361500.0
2005-01-05 12:00:00	QQQ	ETF	38.67	38.7	38.47	38.62	13105300.0
2005-01-05 13:00:00	QQQ	ETF	38.62	39.8	38.51	38.8	15044400.0
2005-01-05 14:00:00	QQQ	ETF	38.8	39.0	38.66	38.67	13073500.0
2005-01-05 15:00:00	QQQ	ETF	38.67	38.84	38.54	38.54	15622300.0
2005-01-05 08:00:00	IWM	ETF	62.345	62.345	62.295	62.295	25800.0
2005-01-05 09:00:00	IWM	ETF	62.29	62.47	62.225	62.33	3407200.0
2005-01-05 10:00:00	IWM	ETF	62.315	62.64	62.15	62.16	5719000.0
2005-01-05 11:00:00	IWM	ETF	62.16	62.28	61.84	61.85	3567200.0
2005-01-05 12:00:00	IWM	ETF	61.855	61.875	61.46	61.605	3965000.0
2005-01-05 13:00:00	IWM	ETF	61.605	62.425	61.595	62.115	6081800.0
2005-01-05 14:00:00	IWM	ETF	62.095	62.175	61.93	61.95	1923200.0
2005-01-05 15:00:00	IWM	ETF	61.99	62.075	61.325	61.465	4382600.0
2005-01-05 16:00:00	IWM	ETF	61.465	61.56	61.33	61.35	385200.0
2005-01-05 17:00:00	IWM	ETF	61.31	62.215	61.31	62.215	52400.0
2005-01-05 18:00:00	IWM	ETF	61.33	61.33	61.33	61.33	1600.0
2005-01-05 19:00:00	IWM	ETF	61.37	61.37	61.37	61.37	400.0
2005-01-05 08:00:00	DIA	ETF	106.25	106.28	106.16	106.16	9100.0
2005-01-05 09:00:00	DIA	ETF	106.16	106.67	106.16	106.54	1372400.0
2005-01-05 10:00:00	DIA	ETF	106.55	106.78	106.27	106.31	2279900.0
2005-01-05 11:00:00	DIA	ETF	106.32	106.62	106.3	106.44	859000.0
2005-01-05 12:00:00	DIA	ETF	106.45	106.49	106.09	106.35	1672600.0
2005-01-05 13:00:00	DIA	ETF	106.34	106.76	106.34	106.57	2087900.0
2005-01-05 14:00:00	DIA	ETF	106.57	106.63	106.3	106.3	942100.0
2005-01-05 15:00:00	DIA	ETF	106.31	106.57	105.89	105.94	1426000.0
2005-01-05 16:00:00	DIA	ETF	105.95	105.95	105.68	105.71	117000.0
2005-01-05 17:00:00	DIA	ETF	105.75	105.75	105.69	105.7	2900.0
2005-01-05 18:00:00	DIA	ETF	105.78	105.78	105.77	105.77	800.0
2005-01-05 19:00:00	DIA	ETF	105.78	105.78	105.73	105.77	2200.0
2005-01-05 09:00:00	GLD	ETF	42.75	42.78	42.63	42.69	443000.0
2005-01-05 10:00:00	GLD	ETF	42.68	42.82	42.6	42.79	490900.0
2005-01-05 11:00:00	GLD	ETF	42.79	42.88	42.75	42.82	179000.0
2005-01-05 12:00:00	GLD	ETF	42.79	42.84	42.64	42.6402	159100.0
2005-01-05 13:00:00	GLD	ETF	42.65	42.67	42.61	42.65	89200.0
2005-01-05 14:00:00	GLD	ETF	42.63	42.68	42.63	42.68	290300.0
2005-01-05 15:00:00	GLD	ETF	42.68	42.68	42.63	42.67	141800.0

> showing 50 of 841 rows — these rows as CSV

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