PREVIEW / etf_1hour / 2005-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-13.parquet
  size:    29 KB
  rows:    853

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-13 06:00:00	SPY	ETF	118.59	118.59	118.59	118.59	500.0
2005-04-13 07:00:00	SPY	ETF	118.7	118.72	118.7	118.72	16400.0
2005-04-13 08:00:00	SPY	ETF	118.7	118.72	118.56	118.59	157500.0
2005-04-13 09:00:00	SPY	ETF	118.58	118.8	118.42	118.48	5582100.0
2005-04-13 10:00:00	SPY	ETF	118.47	118.75	118.28	118.39	12871400.0
2005-04-13 11:00:00	SPY	ETF	118.38	118.65	118.15	118.34	6925600.0
2005-04-13 12:00:00	SPY	ETF	118.35	118.45	118.15	118.43	3945400.0
2005-04-13 13:00:00	SPY	ETF	118.43	118.47	117.6	117.68	11700000.0
2005-04-13 14:00:00	SPY	ETF	117.68	117.79	117.45	117.53	9873000.0
2005-04-13 15:00:00	SPY	ETF	117.53	117.54	117.13	117.41	11697400.0
2005-04-13 16:00:00	SPY	ETF	117.41	117.44	117.2	117.3	1706300.0
2005-04-13 17:00:00	SPY	ETF	117.31	117.35	117.3	117.3	20300.0
2005-04-13 18:00:00	SPY	ETF	117.3	117.4	117.29	117.4	30600.0
2005-04-13 19:00:00	SPY	ETF	117.33	117.33	117.33	117.33	2000.0
2005-04-13 09:00:00	QQQ	ETF	36.56	36.59	36.47	36.5	9084500.0
2005-04-13 10:00:00	QQQ	ETF	36.5	36.6	36.34	36.39	19482900.0
2005-04-13 11:00:00	QQQ	ETF	36.4	36.46	36.32	36.4	10165900.0
2005-04-13 12:00:00	QQQ	ETF	36.4	36.42	36.3	36.41	8635500.0
2005-04-13 13:00:00	QQQ	ETF	36.41	36.43	36.15	36.19	14759600.0
2005-04-13 14:00:00	QQQ	ETF	36.19	36.23	36.07	36.1	13016000.0
2005-04-13 15:00:00	QQQ	ETF	36.1	36.11	35.98	36.05	25320900.0
2005-04-13 08:00:00	IWM	ETF	60.95	60.99	60.87	60.875	33800.0
2005-04-13 09:00:00	IWM	ETF	60.835	60.9	60.665	60.8	3091000.0
2005-04-13 10:00:00	IWM	ETF	60.8	60.88	60.475	60.57	4544200.0
2005-04-13 11:00:00	IWM	ETF	60.55	60.66	60.34	60.495	2280400.0
2005-04-13 12:00:00	IWM	ETF	60.5	60.52	60.365	60.48	1689600.0
2005-04-13 13:00:00	IWM	ETF	60.48	60.52	60.015	60.09	4468200.0
2005-04-13 14:00:00	IWM	ETF	60.08	60.175	59.97	60.04	2962000.0
2005-04-13 15:00:00	IWM	ETF	60.045	60.045	59.725	59.945	5981400.0
2005-04-13 16:00:00	IWM	ETF	59.925	59.935	59.79	59.79	410600.0
2005-04-13 17:00:00	IWM	ETF	59.81	59.81	59.78	59.78	5200.0
2005-04-13 18:00:00	IWM	ETF	59.85	59.86	59.85	59.85	8800.0
2005-04-13 07:00:00	DIA	ETF	105.03	105.03	105.03	105.03	500.0
2005-04-13 08:00:00	DIA	ETF	105.07	105.07	104.96	104.96	12900.0
2005-04-13 09:00:00	DIA	ETF	104.99	105.12	104.88	104.96	514600.0
2005-04-13 10:00:00	DIA	ETF	104.96	105.22	104.841	104.91	802200.0
2005-04-13 11:00:00	DIA	ETF	104.91	105.03	104.7	104.93	1297700.0
2005-04-13 12:00:00	DIA	ETF	104.93	105.04	104.8	104.99	243300.0
2005-04-13 13:00:00	DIA	ETF	105.0	105.07	104.29	104.34	1514100.0
2005-04-13 14:00:00	DIA	ETF	104.35	104.45	104.11	104.13	683600.0
2005-04-13 15:00:00	DIA	ETF	104.14	104.16	103.75	104.0	3029000.0
2005-04-13 16:00:00	DIA	ETF	103.95	103.98	103.86	103.86	23700.0
2005-04-13 09:00:00	GLD	ETF	42.76	42.77	42.68	42.76	103800.0
2005-04-13 10:00:00	GLD	ETF	42.77	42.83	42.73	42.789	71600.0
2005-04-13 11:00:00	GLD	ETF	42.78	42.95	42.78	42.89	33200.0
2005-04-13 12:00:00	GLD	ETF	42.89	42.89	42.83	42.86	24700.0
2005-04-13 13:00:00	GLD	ETF	42.86	42.914	42.85	42.88	50100.0
2005-04-13 14:00:00	GLD	ETF	42.872	42.88	42.82	42.87	50800.0
2005-04-13 15:00:00	GLD	ETF	42.85	42.9	42.84	42.9	48800.0
2005-04-13 08:00:00	TLT	ETF	90.5	90.53	90.3	90.3	5100.0

> showing 50 of 853 rows — these rows as CSV

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