PREVIEW / etf_1hour / 2005-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-31.parquet
  size:    29 KB
  rows:    837

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-31 08:00:00	SPY	ETF	117.9	118.0	117.88	117.95	288900.0
2005-01-31 09:00:00	SPY	ETF	117.96	118.08	117.81	118.02	8833600.0
2005-01-31 10:00:00	SPY	ETF	118.04	118.09	117.72	117.87	7027500.0
2005-01-31 11:00:00	SPY	ETF	117.87	118.02	117.75	117.97	4959900.0
2005-01-31 12:00:00	SPY	ETF	117.96	118.25	117.85	118.18	7793000.0
2005-01-31 13:00:00	SPY	ETF	118.17	118.17	117.86	117.93	3200400.0
2005-01-31 14:00:00	SPY	ETF	117.93	118.15	117.86	118.05	4992400.0
2005-01-31 15:00:00	SPY	ETF	118.05	118.18	117.71	118.07	10179600.0
2005-01-31 16:00:00	SPY	ETF	118.05	118.24	118.04	118.13	3106600.0
2005-01-31 17:00:00	SPY	ETF	118.15	118.16	118.1	118.11	1004300.0
2005-01-31 18:00:00	SPY	ETF	118.13	118.13	118.12	118.12	7200.0
2005-01-31 19:00:00	SPY	ETF	118.12	118.12	118.12	118.12	400.0
2005-01-31 09:00:00	QQQ	ETF	37.36	37.43	37.28	37.43	14515100.0
2005-01-31 10:00:00	QQQ	ETF	37.44	37.5	37.33	37.4	15481200.0
2005-01-31 11:00:00	QQQ	ETF	37.4	37.47	37.33	37.44	7034300.0
2005-01-31 12:00:00	QQQ	ETF	37.45	37.53	37.39	37.52	8978400.0
2005-01-31 13:00:00	QQQ	ETF	37.52	37.52	37.39	37.43	6962800.0
2005-01-31 14:00:00	QQQ	ETF	37.43	37.51	37.39	37.4	10318200.0
2005-01-31 15:00:00	QQQ	ETF	37.4	37.45	37.26	37.41	17896500.0
2005-01-31 08:00:00	IWM	ETF	61.735	61.745	61.7	61.7	4200.0
2005-01-31 09:00:00	IWM	ETF	61.69	61.89	61.635	61.83	2718000.0
2005-01-31 10:00:00	IWM	ETF	61.835	61.955	61.65	61.7	2347600.0
2005-01-31 11:00:00	IWM	ETF	61.7	61.855	61.57	61.705	1344200.0
2005-01-31 12:00:00	IWM	ETF	61.71	61.91	61.65	61.9	1577800.0
2005-01-31 13:00:00	IWM	ETF	61.9	61.9	61.725	61.84	594000.0
2005-01-31 14:00:00	IWM	ETF	61.84	62.17	61.81	62.08	3590800.0
2005-01-31 15:00:00	IWM	ETF	62.08	62.25	61.85	62.1	6005800.0
2005-01-31 16:00:00	IWM	ETF	62.06	62.23	61.9	62.025	981800.0
2005-01-31 17:00:00	IWM	ETF	61.0804	62.175	61.0804	62.1	331800.0
2005-01-31 19:00:00	IWM	ETF	62.115	62.115	62.115	62.115	400.0
2005-01-31 08:00:00	DIA	ETF	104.84	104.93	104.84	104.91	5900.0
2005-01-31 09:00:00	DIA	ETF	104.91	105.05	104.79	104.93	1190100.0
2005-01-31 10:00:00	DIA	ETF	104.93	104.96	104.67	104.73	769300.0
2005-01-31 11:00:00	DIA	ETF	104.72	104.85	104.61	104.79	408900.0
2005-01-31 12:00:00	DIA	ETF	104.81	105.0	104.72	104.92	356000.0
2005-01-31 13:00:00	DIA	ETF	104.92	104.97	104.69	104.73	229200.0
2005-01-31 14:00:00	DIA	ETF	104.72	104.86	104.66	104.75	336800.0
2005-01-31 15:00:00	DIA	ETF	104.76	104.88	104.48	104.79	1637900.0
2005-01-31 16:00:00	DIA	ETF	104.78	104.89	104.78	104.85	4900.0
2005-01-31 09:00:00	GLD	ETF	42.21	42.3	42.18	42.2	447000.0
2005-01-31 10:00:00	GLD	ETF	42.21	42.23	41.96	42.1	573800.0
2005-01-31 11:00:00	GLD	ETF	42.11	42.17	42.09	42.11	215900.0
2005-01-31 12:00:00	GLD	ETF	42.1	42.16	42.06	42.16	121000.0
2005-01-31 13:00:00	GLD	ETF	42.15	42.25	42.09	42.25	82700.0
2005-01-31 14:00:00	GLD	ETF	42.23	42.3	42.22	42.26	153300.0
2005-01-31 15:00:00	GLD	ETF	42.25	42.28	42.21	42.22	95000.0
2005-01-31 17:00:00	GLD	ETF	42.22	42.22	42.22	42.22	3700.0
2005-01-31 08:00:00	TLT	ETF	91.23	91.35	91.21	91.35	4200.0
2005-01-31 09:00:00	TLT	ETF	91.33	91.42	91.3	91.3	36400.0
2005-01-31 10:00:00	TLT	ETF	91.35	91.57	91.29	91.48	129700.0

> showing 50 of 837 rows — these rows as CSV

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