PREVIEW / etf_1hour / 2005-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-31.parquet
  size:    29 KB
  rows:    867

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-03-31 08:00:00	SPY	ETF	118.33	118.47	118.16	118.2	672800.0
2005-03-31 09:00:00	SPY	ETF	118.18	118.44	118.02	118.37	12663500.0
2005-03-31 10:00:00	SPY	ETF	118.37	118.43	117.94	118.1	8785300.0
2005-03-31 11:00:00	SPY	ETF	118.09	118.35	118.05	118.2	5669600.0
2005-03-31 12:00:00	SPY	ETF	118.2	118.22	117.87	118.11	5776000.0
2005-03-31 13:00:00	SPY	ETF	118.11	118.2	117.99	118.15	3654500.0
2005-03-31 14:00:00	SPY	ETF	118.14	118.46	118.0	118.31	7672000.0
2005-03-31 15:00:00	SPY	ETF	118.3	118.42	117.93	117.95	12624600.0
2005-03-31 16:00:00	SPY	ETF	117.99	118.19	117.87	117.96	1697000.0
2005-03-31 17:00:00	SPY	ETF	117.96	117.99	117.92	117.92	217400.0
2005-03-31 18:00:00	SPY	ETF	117.95	118.0	117.95	117.99	32600.0
2005-03-31 19:00:00	SPY	ETF	118.07	118.07	118.07	118.07	300.0
2005-03-31 09:00:00	QQQ	ETF	36.72	36.75	36.59	36.74	12858300.0
2005-03-31 10:00:00	QQQ	ETF	36.74	36.74	36.49	36.53	19033200.0
2005-03-31 11:00:00	QQQ	ETF	36.54	36.66	36.5	36.56	11570600.0
2005-03-31 12:00:00	QQQ	ETF	36.57	36.58	36.44	36.53	10193200.0
2005-03-31 13:00:00	QQQ	ETF	36.53	36.62	36.46	36.58	6046100.0
2005-03-31 14:00:00	QQQ	ETF	36.58	36.72	36.53	36.65	8475400.0
2005-03-31 15:00:00	QQQ	ETF	36.65	36.66	36.5	36.56	7540200.0
2005-03-31 08:00:00	IWM	ETF	61.075	61.075	61.075	61.075	200.0
2005-03-31 09:00:00	IWM	ETF	61.1	61.185	60.875	61.07	2144400.0
2005-03-31 10:00:00	IWM	ETF	61.065	61.065	60.82	60.995	2857400.0
2005-03-31 11:00:00	IWM	ETF	61.0	61.15	60.975	61.02	1532000.0
2005-03-31 12:00:00	IWM	ETF	61.03	61.045	60.875	60.975	1917600.0
2005-03-31 13:00:00	IWM	ETF	60.975	61.06	60.905	60.935	1967800.0
2005-03-31 14:00:00	IWM	ETF	60.93	61.035	60.795	60.95	1807200.0
2005-03-31 15:00:00	IWM	ETF	60.945	60.95	60.75	60.91	4022000.0
2005-03-31 16:00:00	IWM	ETF	60.92	61.135	60.695	61.0	2005400.0
2005-03-31 17:00:00	IWM	ETF	60.99	61.005	60.965	61.005	10200.0
2005-03-31 08:00:00	DIA	ETF	105.5	105.51	105.2	105.2	12800.0
2005-03-31 09:00:00	DIA	ETF	105.15	105.32	105.08	105.29	1063700.0
2005-03-31 10:00:00	DIA	ETF	105.28	105.28	104.93	105.02	878100.0
2005-03-31 11:00:00	DIA	ETF	105.01	105.19	104.98	105.11	475400.0
2005-03-31 12:00:00	DIA	ETF	105.11	105.11	104.8	105.0	917300.0
2005-03-31 13:00:00	DIA	ETF	105.0	105.1	104.92	105.03	617200.0
2005-03-31 14:00:00	DIA	ETF	105.03	105.32	104.9	105.16	1578800.0
2005-03-31 15:00:00	DIA	ETF	105.13	105.24	104.86	104.94	1096200.0
2005-03-31 16:00:00	DIA	ETF	104.91	105.0217	104.88	105.0	683000.0
2005-03-31 17:00:00	DIA	ETF	104.94	104.94	104.94	104.94	1300.0
2005-03-31 19:00:00	DIA	ETF	105.0	105.0	105.0	105.0	500.0
2005-03-31 08:00:00	GLD	ETF	42.87	42.87	42.82	42.82	45000.0
2005-03-31 09:00:00	GLD	ETF	42.87	42.87	42.77	42.77	190700.0
2005-03-31 10:00:00	GLD	ETF	42.79	42.8	42.7	42.76	137800.0
2005-03-31 11:00:00	GLD	ETF	42.73	42.83	42.72	42.77	257900.0
2005-03-31 12:00:00	GLD	ETF	42.77	42.82	42.77	42.81	273000.0
2005-03-31 13:00:00	GLD	ETF	42.81	42.83	42.79	42.83	80000.0
2005-03-31 14:00:00	GLD	ETF	42.81	42.84	42.8	42.83	113700.0
2005-03-31 15:00:00	GLD	ETF	42.82	42.87	42.81	42.82	209100.0
2005-03-31 16:00:00	GLD	ETF	42.82	42.85	42.82	42.85	40000.0
2005-03-31 08:00:00	TLT	ETF	88.72	89.12	88.72	89.0	93200.0

> showing 50 of 867 rows — these rows as CSV

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