PREVIEW / etf_1hour / 2007-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-20.parquet
  size:    85 KB
  rows:    2,847

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-07-20 04:00:00	SPY	ETF	155.06	155.06	154.87	154.87	5500.0
2007-07-20 05:00:00	SPY	ETF	154.79	154.94	154.79	154.94	7400.0
2007-07-20 06:00:00	SPY	ETF	154.92	155.14	154.92	155.13	17400.0
2007-07-20 07:00:00	SPY	ETF	155.01	155.02	154.59	154.67	618500.0
2007-07-20 08:00:00	SPY	ETF	154.6	154.92	154.57	154.91	1981600.0
2007-07-20 09:00:00	SPY	ETF	154.9	155.07	154.09	154.32	21975357.0
2007-07-20 10:00:00	SPY	ETF	154.31	154.42	153.78	154.03	39906071.0
2007-07-20 11:00:00	SPY	ETF	154.02	154.22	153.0	153.35	31249543.0
2007-07-20 12:00:00	SPY	ETF	153.35	155.019	152.83	152.92	37044376.0
2007-07-20 13:00:00	SPY	ETF	152.92	155.2484	152.9	153.65	27414206.0
2007-07-20 14:00:00	SPY	ETF	153.66	154.15	153.49	153.89	27537722.0
2007-07-20 15:00:00	SPY	ETF	153.89	154.1	152.29	153.33	34687669.0
2007-07-20 16:00:00	SPY	ETF	153.33	153.8	153.28	153.57	7966600.0
2007-07-20 17:00:00	SPY	ETF	153.57	153.6	153.49	153.49	506600.0
2007-07-20 18:00:00	SPY	ETF	153.49	153.49	153.38	153.38	21900.0
2007-07-20 19:00:00	SPY	ETF	153.48	153.48	153.46	153.47	2600.0
2007-07-20 04:00:00	QQQ	ETF	50.22	50.22	50.22	50.22	200.0
2007-07-20 06:00:00	QQQ	ETF	50.25	50.31	50.25	50.28	33000.0
2007-07-20 07:00:00	QQQ	ETF	50.27	50.31	50.19	50.22	428648.0
2007-07-20 08:00:00	QQQ	ETF	50.2	50.34	50.19	50.31	1572918.0
2007-07-20 09:00:00	QQQ	ETF	50.3	50.36	50.01	50.07	16993154.0
2007-07-20 10:00:00	QQQ	ETF	50.07	50.17	49.98	50.09	26565648.0
2007-07-20 11:00:00	QQQ	ETF	50.08	50.17	49.87	49.91	22076175.0
2007-07-20 12:00:00	QQQ	ETF	49.91	49.98	49.74	49.79	29495406.0
2007-07-20 13:00:00	QQQ	ETF	49.8	50.11	49.77	50.0611	18953405.0
2007-07-20 14:00:00	QQQ	ETF	50.06	50.22	50.03	50.13	17643468.0
2007-07-20 15:00:00	QQQ	ETF	50.13	50.21	49.9	50.08	21740242.0
2007-07-20 16:00:00	QQQ	ETF	50.07	50.12	50.012	50.1	3204669.0
2007-07-20 17:00:00	QQQ	ETF	50.12	50.13	50.11	50.11	8863.0
2007-07-20 18:00:00	QQQ	ETF	50.11	50.12	50.03	50.1	47414.0
2007-07-20 19:00:00	QQQ	ETF	50.05	50.05	50.04	50.05	5422.0
2007-07-20 07:00:00	IWM	ETF	84.57	84.57	84.39	84.4	45400.0
2007-07-20 08:00:00	IWM	ETF	84.43	84.53	84.37	84.5	737600.0
2007-07-20 09:00:00	IWM	ETF	84.48	84.73	83.07	83.64	16394732.0
2007-07-20 10:00:00	IWM	ETF	83.64	84.5	83.37	83.59	22259700.0
2007-07-20 11:00:00	IWM	ETF	83.58	83.74	82.78	82.85	32396799.0
2007-07-20 12:00:00	IWM	ETF	82.84	83.35	82.59	82.86	16945317.0
2007-07-20 13:00:00	IWM	ETF	82.86	83.49	82.78	83.28	15479166.0
2007-07-20 14:00:00	IWM	ETF	83.27	83.81	83.15	83.54	12556222.0
2007-07-20 15:00:00	IWM	ETF	83.54	83.7	83.09	83.12	17715952.0
2007-07-20 16:00:00	IWM	ETF	83.13	83.3	83.08	83.25	11192500.0
2007-07-20 18:00:00	IWM	ETF	83.22	83.22	83.22	83.22	2000.0
2007-07-20 07:00:00	DIA	ETF	139.69	139.69	139.23	139.25	21900.0
2007-07-20 08:00:00	DIA	ETF	139.22	139.33	139.13	139.26	57000.0
2007-07-20 09:00:00	DIA	ETF	139.28	139.56	138.82	138.94	2568300.0
2007-07-20 10:00:00	DIA	ETF	138.94	138.96	138.45	138.61	2828300.0
2007-07-20 11:00:00	DIA	ETF	138.6	138.72	138.19	138.29	2594900.0
2007-07-20 12:00:00	DIA	ETF	138.29	138.39	137.88	137.92	2221000.0
2007-07-20 13:00:00	DIA	ETF	137.93	138.58	137.9	138.43	2395900.0
2007-07-20 14:00:00	DIA	ETF	138.44	138.82	138.3	138.75	2536400.0

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

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