PREVIEW / etf_1hour / 2007-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-11.parquet
  size:    90 KB
  rows:    3,023

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-11 04:00:00	SPY	ETF	156.84	156.94	156.84	156.94	5100.0
2007-10-11 05:00:00	SPY	ETF	156.96	157.0	156.89	156.89	12900.0
2007-10-11 06:00:00	SPY	ETF	156.82	156.97	156.82	156.95	126000.0
2007-10-11 07:00:00	SPY	ETF	156.97	157.3	156.9	157.13	1696300.0
2007-10-11 08:00:00	SPY	ETF	157.13	157.31	156.96	157.18	4189000.0
2007-10-11 09:00:00	SPY	ETF	157.18	157.19	156.76	156.96	13581630.0
2007-10-11 10:00:00	SPY	ETF	156.95	157.25	156.88	157.13	17699400.0
2007-10-11 11:00:00	SPY	ETF	157.13	157.16	156.85	157.06	8502100.0
2007-10-11 12:00:00	SPY	ETF	157.06	157.4385	156.99	157.34	8846600.0
2007-10-11 13:00:00	SPY	ETF	157.35	157.52	156.93	156.99	10542900.0
2007-10-11 14:00:00	SPY	ETF	156.99	156.99	155.43	155.91	84219715.0
2007-10-11 15:00:00	SPY	ETF	155.9	156.0	154.54	155.34	73026820.0
2007-10-11 16:00:00	SPY	ETF	155.36	157.09	154.67	155.36	7676900.0
2007-10-11 17:00:00	SPY	ETF	155.41	155.45	155.16	155.21	111000.0
2007-10-11 18:00:00	SPY	ETF	155.2	155.31	155.15	155.29	39000.0
2007-10-11 19:00:00	SPY	ETF	155.21	155.34	155.16	155.34	13300.0
2007-10-11 04:00:00	QQQ	ETF	53.72	53.72	53.72	53.72	600.0
2007-10-11 06:00:00	QQQ	ETF	53.76	53.76	53.76	53.76	10000.0
2007-10-11 07:00:00	QQQ	ETF	53.75	53.85	53.73	53.81	353796.0
2007-10-11 08:00:00	QQQ	ETF	53.82	53.85	53.78	53.83	707325.0
2007-10-11 09:00:00	QQQ	ETF	53.83	53.85	53.69	53.82	15838110.0
2007-10-11 10:00:00	QQQ	ETF	53.82	53.93	53.77	53.838	20593355.0
2007-10-11 11:00:00	QQQ	ETF	53.83	53.89	53.74	53.8505	8278292.0
2007-10-11 12:00:00	QQQ	ETF	53.85	53.94	53.79	53.89	8351987.0
2007-10-11 13:00:00	QQQ	ETF	53.892	53.93	53.55	53.57	17216478.0
2007-10-11 14:00:00	QQQ	ETF	53.57	53.57	52.65	52.94	87979167.0
2007-10-11 15:00:00	QQQ	ETF	52.95	52.97	52.28	52.67	64890894.0
2007-10-11 16:00:00	QQQ	ETF	52.67	53.94	52.53	52.71	15898965.0
2007-10-11 17:00:00	QQQ	ETF	52.72	52.73	52.5	52.63	223548.0
2007-10-11 18:00:00	QQQ	ETF	52.64	52.68	52.5201	52.63	98244.0
2007-10-11 19:00:00	QQQ	ETF	52.63	52.67	52.63	52.65	36112.0
2007-10-11 06:00:00	IWM	ETF	84.58	84.59	84.54	84.54	10200.0
2007-10-11 07:00:00	IWM	ETF	84.55	84.81	84.55	84.69	234700.0
2007-10-11 08:00:00	IWM	ETF	84.66	84.78	84.64	84.75	520400.0
2007-10-11 09:00:00	IWM	ETF	84.75	84.76	84.31	84.56	6423400.0
2007-10-11 10:00:00	IWM	ETF	84.57	84.81	84.5	84.62	8035800.0
2007-10-11 11:00:00	IWM	ETF	84.62	84.68	84.4	84.62	4181600.0
2007-10-11 12:00:00	IWM	ETF	84.62	84.88	84.49	84.8	5031900.0
2007-10-11 13:00:00	IWM	ETF	84.8	84.89	84.44	84.5	5390200.0
2007-10-11 14:00:00	IWM	ETF	84.49	84.75	83.03	83.44	32479800.0
2007-10-11 15:00:00	IWM	ETF	83.43	83.56	82.66	83.13	25797601.0
2007-10-11 16:00:00	IWM	ETF	83.12	83.25	83.0	83.07	5625200.0
2007-10-11 17:00:00	IWM	ETF	83.07	83.07	83.01	83.02	17500.0
2007-10-11 18:00:00	IWM	ETF	83.04	83.07	83.0	83.01	2000.0
2007-10-11 19:00:00	IWM	ETF	83.03	83.03	83.03	83.03	400.0
2007-10-11 07:00:00	DIA	ETF	141.4	141.52	141.4	141.45	4000.0
2007-10-11 08:00:00	DIA	ETF	141.45	141.52	141.32	141.5	66100.0
2007-10-11 09:00:00	DIA	ETF	141.48	141.61	141.3	141.51	1944620.0
2007-10-11 10:00:00	DIA	ETF	141.51	141.65	141.4	141.55	1475200.0
2007-10-11 11:00:00	DIA	ETF	141.54	141.6	141.29	141.49	1016700.0

> showing 50 of 3,023 rows — these rows as CSV

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