PREVIEW / etf_1hour / 2007-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-29.parquet
  size:    87 KB
  rows:    2,970

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
2007-10-29 05:00:00	SPY	ETF	154.05	154.07	154.05	154.07	3000.0
2007-10-29 06:00:00	SPY	ETF	153.94	154.05	153.94	154.05	113000.0
2007-10-29 07:00:00	SPY	ETF	154.05	154.22	153.98	154.15	353400.0
2007-10-29 08:00:00	SPY	ETF	154.16	154.17	154.0	154.01	591900.0
2007-10-29 09:00:00	SPY	ETF	154.01	154.44	153.8	154.16	18694299.0
2007-10-29 10:00:00	SPY	ETF	154.16	154.19	153.55	153.76	23912565.0
2007-10-29 11:00:00	SPY	ETF	153.76	154.15	153.6	153.79	11216200.0
2007-10-29 12:00:00	SPY	ETF	153.79	154.12	153.75	153.872	7592400.0
2007-10-29 13:00:00	SPY	ETF	153.87	154.175	153.78	154.1601	7328900.0
2007-10-29 14:00:00	SPY	ETF	154.16	154.27	153.73	154.09	12140683.0
2007-10-29 15:00:00	SPY	ETF	154.08	154.32	153.95	154.0	20136234.0
2007-10-29 16:00:00	SPY	ETF	153.98	154.3	153.89	153.97	3226200.0
2007-10-29 17:00:00	SPY	ETF	153.95	154.09	153.92	154.02	29300.0
2007-10-29 18:00:00	SPY	ETF	154.05	154.1	153.9	153.9	17700.0
2007-10-29 19:00:00	SPY	ETF	153.92	153.94	153.88	153.92	6000.0
2007-10-29 05:00:00	QQQ	ETF	54.29	54.29	54.29	54.29	25000.0
2007-10-29 06:00:00	QQQ	ETF	54.26	54.29	54.26	54.29	16400.0
2007-10-29 07:00:00	QQQ	ETF	54.28	54.34	54.27	54.27	309601.0
2007-10-29 08:00:00	QQQ	ETF	54.28	54.28	54.21	54.22	373282.0
2007-10-29 09:00:00	QQQ	ETF	54.22	54.29	54.11	54.17	14749315.0
2007-10-29 10:00:00	QQQ	ETF	54.17	54.24	53.84	54.04	27918912.0
2007-10-29 11:00:00	QQQ	ETF	54.03	54.18	53.96	54.08	9837634.0
2007-10-29 12:00:00	QQQ	ETF	54.08	54.16	54.01	54.11	5684163.0
2007-10-29 13:00:00	QQQ	ETF	54.11	54.2695	54.04	54.2524	5259960.0
2007-10-29 14:00:00	QQQ	ETF	54.2501	54.33	54.0	54.1	16343958.0
2007-10-29 15:00:00	QQQ	ETF	54.1	54.18	54.05	54.14	14420254.0
2007-10-29 16:00:00	QQQ	ETF	54.15	54.2	53.9443	54.07	6950136.0
2007-10-29 17:00:00	QQQ	ETF	54.09	54.16	54.07	54.11	13286.0
2007-10-29 18:00:00	QQQ	ETF	54.11	54.16	54.08	54.08	32104.0
2007-10-29 19:00:00	QQQ	ETF	54.09	54.1	54.07	54.07	11564.0
2007-10-29 07:00:00	IWM	ETF	82.28	82.37	82.28	82.36	72000.0
2007-10-29 08:00:00	IWM	ETF	82.25	82.3	82.15	82.24	94600.0
2007-10-29 09:00:00	IWM	ETF	82.23	82.44	82.1	82.2	8121582.0
2007-10-29 10:00:00	IWM	ETF	82.2	82.22	81.47	81.57	11762700.0
2007-10-29 11:00:00	IWM	ETF	81.57	81.87	81.44	81.55	7666800.0
2007-10-29 12:00:00	IWM	ETF	81.55	81.78	81.39	81.65	5506100.0
2007-10-29 13:00:00	IWM	ETF	81.64	82.0	81.56	81.97	4051200.0
2007-10-29 14:00:00	IWM	ETF	81.96	82.08	81.48	81.72	7373100.0
2007-10-29 15:00:00	IWM	ETF	81.71	81.91	81.56	81.89	10476900.0
2007-10-29 16:00:00	IWM	ETF	81.88	82.0	81.79	81.87	1690900.0
2007-10-29 17:00:00	IWM	ETF	81.85	81.85	81.8	81.8	3200.0
2007-10-29 18:00:00	IWM	ETF	81.89	81.89	81.89	81.89	1900.0
2007-10-29 19:00:00	IWM	ETF	81.85	81.89	81.84	81.84	3500.0
2007-10-29 07:00:00	DIA	ETF	138.52	138.58	138.51	138.51	3400.0
2007-10-29 08:00:00	DIA	ETF	138.5	138.5	138.41	138.43	14600.0
2007-10-29 09:00:00	DIA	ETF	138.34	138.63	138.16	138.5	870333.0
2007-10-29 10:00:00	DIA	ETF	138.52	138.53	138.17	138.3	1442400.0
2007-10-29 11:00:00	DIA	ETF	138.29	138.51	138.19	138.35	986100.0
2007-10-29 12:00:00	DIA	ETF	138.35	138.56	138.27	138.37	833600.0
2007-10-29 13:00:00	DIA	ETF	138.37	138.58	138.31	138.56	661500.0

> showing 50 of 2,970 rows — these rows as CSV

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