PREVIEW / etf_1hour / 2007-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-01.parquet
  size:    88 KB
  rows:    2,907

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-01 05:00:00	SPY	ETF	152.75	152.75	152.67	152.68	47000.0
2007-10-01 06:00:00	SPY	ETF	152.71	152.97	152.71	152.97	90000.0
2007-10-01 07:00:00	SPY	ETF	152.91	152.91	152.38	152.5	1232700.0
2007-10-01 08:00:00	SPY	ETF	152.47	152.68	152.29	152.64	1140000.0
2007-10-01 09:00:00	SPY	ETF	152.64	153.35	152.5	153.16	19256980.0
2007-10-01 10:00:00	SPY	ETF	153.16	153.64	153.12	153.48	25051300.0
2007-10-01 11:00:00	SPY	ETF	153.47	154.07	153.35	154.0	21078500.0
2007-10-01 12:00:00	SPY	ETF	154.01	154.22	153.93	153.97	15106800.0
2007-10-01 13:00:00	SPY	ETF	153.97	154.54	153.97	154.38	18114500.0
2007-10-01 14:00:00	SPY	ETF	154.39	154.68	154.36	154.6	12563700.0
2007-10-01 15:00:00	SPY	ETF	154.6	154.75	152.5	154.52	19235100.0
2007-10-01 16:00:00	SPY	ETF	154.52	154.55	154.22	154.3	7298500.0
2007-10-01 17:00:00	SPY	ETF	154.24	154.31	152.48	154.19	4932100.0
2007-10-01 18:00:00	SPY	ETF	154.2	154.21	154.1	154.2	57300.0
2007-10-01 19:00:00	SPY	ETF	154.25	154.27	154.23	154.27	6100.0
2007-10-01 06:00:00	QQQ	ETF	51.49	51.49	51.49	51.49	2000.0
2007-10-01 07:00:00	QQQ	ETF	51.49	51.49	51.37	51.4	165500.0
2007-10-01 08:00:00	QQQ	ETF	51.4	51.47	51.38	51.43	779128.0
2007-10-01 09:00:00	QQQ	ETF	51.43	51.64	51.38	51.56	13279888.0
2007-10-01 10:00:00	QQQ	ETF	51.56	51.66	51.51	51.58	14204406.0
2007-10-01 11:00:00	QQQ	ETF	51.57	51.82	51.54	51.8185	12150390.0
2007-10-01 12:00:00	QQQ	ETF	51.82	51.94	51.78	51.86	6996699.0
2007-10-01 13:00:00	QQQ	ETF	51.86	52.03	51.86	51.98	10783760.0
2007-10-01 14:00:00	QQQ	ETF	51.98	52.16	51.98	52.1	15782177.0
2007-10-01 15:00:00	QQQ	ETF	52.11	52.14	51.88	52.02	23063751.0
2007-10-01 16:00:00	QQQ	ETF	52.01	52.0435	51.4076	51.94	5964952.0
2007-10-01 17:00:00	QQQ	ETF	51.93	52.0	51.92	51.95	61347.0
2007-10-01 18:00:00	QQQ	ETF	51.95	51.95	51.85	51.89	100619.0
2007-10-01 19:00:00	QQQ	ETF	51.9	51.93	51.89	51.92	16178.0
2007-10-01 07:00:00	IWM	ETF	80.21	80.21	80.09	80.12	52500.0
2007-10-01 08:00:00	IWM	ETF	80.1	80.18	79.99	80.15	1043400.0
2007-10-01 09:00:00	IWM	ETF	80.16	81.0	80.04	80.97	11111883.0
2007-10-01 10:00:00	IWM	ETF	80.98	81.42	80.87	81.28	21410600.0
2007-10-01 11:00:00	IWM	ETF	81.28	81.72	81.13	81.7	11579900.0
2007-10-01 12:00:00	IWM	ETF	81.69	81.85	81.61	81.7	7315200.0
2007-10-01 13:00:00	IWM	ETF	81.7	82.05	81.66	81.94	9135800.0
2007-10-01 14:00:00	IWM	ETF	81.95	82.21	81.91	82.12	12017400.0
2007-10-01 15:00:00	IWM	ETF	82.12	82.24	81.71	82.01	19280000.0
2007-10-01 16:00:00	IWM	ETF	82.01	82.2	80.04	82.02	4736500.0
2007-10-01 17:00:00	IWM	ETF	80.17	81.95	80.17	81.95	999200.0
2007-10-01 18:00:00	IWM	ETF	82.03	82.03	82.03	82.03	249000.0
2007-10-01 19:00:00	IWM	ETF	81.98	82.02	81.98	82.02	4100.0
2007-10-01 07:00:00	DIA	ETF	139.11	139.11	138.79	138.79	2900.0
2007-10-01 08:00:00	DIA	ETF	138.76	139.06	138.76	139.0	15900.0
2007-10-01 09:00:00	DIA	ETF	139.01	139.65	138.91	139.61	1224900.0
2007-10-01 10:00:00	DIA	ETF	139.61	139.94	139.58	139.8	1899700.0
2007-10-01 11:00:00	DIA	ETF	139.81	140.23	139.7	140.19	1332700.0
2007-10-01 12:00:00	DIA	ETF	140.2	140.6	140.17	140.25	1535900.0
2007-10-01 13:00:00	DIA	ETF	140.24	140.79	140.24	140.76	1174400.0
2007-10-01 14:00:00	DIA	ETF	140.74	140.98	140.69	140.91	974540.0

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

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