PREVIEW / etf_1hour / 2007-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-15.parquet
  size:    92 KB
  rows:    3,048

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-11-15 05:00:00	SPY	ETF	146.82	146.82	146.82	146.82	12500.0
2007-11-15 06:00:00	SPY	ETF	146.78	146.95	146.75	146.95	103000.0
2007-11-15 07:00:00	SPY	ETF	146.95	147.19	146.66	146.7	1028900.0
2007-11-15 08:00:00	SPY	ETF	146.71	147.33	146.35	146.67	9992800.0
2007-11-15 09:00:00	SPY	ETF	146.66	147.04	146.0	146.81	27139342.0
2007-11-15 10:00:00	SPY	ETF	146.81	147.49	146.53	147.07	31343397.0
2007-11-15 11:00:00	SPY	ETF	147.07	147.37	146.5	146.69	20181220.0
2007-11-15 12:00:00	SPY	ETF	146.7	147.0	146.04	146.32	31125943.0
2007-11-15 13:00:00	SPY	ETF	146.32	146.93	146.17	146.25	17849496.0
2007-11-15 14:00:00	SPY	ETF	146.26	146.33	145.13	145.2	39667942.0
2007-11-15 15:00:00	SPY	ETF	145.21	145.8	144.52	145.35	73944301.0
2007-11-15 16:00:00	SPY	ETF	145.42	147.6	145.2073	145.47	5894100.0
2007-11-15 17:00:00	SPY	ETF	145.47	145.69	145.41	145.41	735600.0
2007-11-15 18:00:00	SPY	ETF	145.49	146.14	145.47	145.64	48200.0
2007-11-15 19:00:00	SPY	ETF	145.6	145.62	145.47	145.52	54000.0
2007-11-15 04:00:00	QQQ	ETF	50.0	50.0	50.0	50.0	200.0
2007-11-15 06:00:00	QQQ	ETF	49.93	50.0	49.92	50.0	3800.0
2007-11-15 07:00:00	QQQ	ETF	49.96	50.17	49.91	49.92	1616150.0
2007-11-15 08:00:00	QQQ	ETF	49.94	50.31	49.91	50.04	6276116.0
2007-11-15 09:00:00	QQQ	ETF	50.05	50.39	49.9	50.18	27108418.0
2007-11-15 10:00:00	QQQ	ETF	50.178	50.54	50.08	50.32	36021650.0
2007-11-15 11:00:00	QQQ	ETF	50.32	50.48	50.15	50.24	18141005.0
2007-11-15 12:00:00	QQQ	ETF	50.25	50.35	49.87	50.0101	37078116.0
2007-11-15 13:00:00	QQQ	ETF	50.02	50.26	49.93	50.01	17766310.0
2007-11-15 14:00:00	QQQ	ETF	50.01	50.1199	49.5	49.5	31699667.0
2007-11-15 15:00:00	QQQ	ETF	49.51	49.93	49.37	49.8115	69424408.0
2007-11-15 16:00:00	QQQ	ETF	49.81	49.88	49.5267	49.84	5480552.0
2007-11-15 17:00:00	QQQ	ETF	49.84	49.92	49.82	49.9	246175.0
2007-11-15 18:00:00	QQQ	ETF	49.89	49.93	49.82	49.87	156413.0
2007-11-15 19:00:00	QQQ	ETF	49.83	49.85	49.8	49.83	513921.0
2007-11-15 06:00:00	IWM	ETF	77.43	77.55	77.43	77.55	600.0
2007-11-15 07:00:00	IWM	ETF	77.62	77.79	77.54	77.57	496900.0
2007-11-15 08:00:00	IWM	ETF	77.64	77.93	77.48	77.58	3195300.0
2007-11-15 09:00:00	IWM	ETF	77.57	77.89	77.38	77.47	10802150.0
2007-11-15 10:00:00	IWM	ETF	77.47	77.82	77.18	77.51	18352457.0
2007-11-15 11:00:00	IWM	ETF	77.51	77.72	77.14	77.33	7056353.0
2007-11-15 12:00:00	IWM	ETF	77.33	77.46	76.7	76.99	24762989.0
2007-11-15 13:00:00	IWM	ETF	76.99	77.55	76.94	77.02	5715734.0
2007-11-15 14:00:00	IWM	ETF	77.04	77.15	76.38	76.41	11907656.0
2007-11-15 15:00:00	IWM	ETF	76.41	77.08	76.24	76.87	27226054.0
2007-11-15 16:00:00	IWM	ETF	76.87	77.97	76.72	76.92	5881200.0
2007-11-15 17:00:00	IWM	ETF	76.85	76.95	76.79	76.79	27700.0
2007-11-15 18:00:00	IWM	ETF	76.8	76.88	76.8	76.88	5000.0
2007-11-15 07:00:00	DIA	ETF	132.3	132.47	132.12	132.12	4900.0
2007-11-15 08:00:00	DIA	ETF	132.13	132.6	131.85	132.07	293600.0
2007-11-15 09:00:00	DIA	ETF	131.99	132.41	131.92	132.32	1562024.0
2007-11-15 10:00:00	DIA	ETF	132.27	132.89	132.05	132.56	2203786.0
2007-11-15 11:00:00	DIA	ETF	132.56	132.81	132.22	132.39	1472407.0
2007-11-15 12:00:00	DIA	ETF	132.39	132.67	131.97	132.17	2340063.0
2007-11-15 13:00:00	DIA	ETF	132.17	132.55	132.07	132.13	1605955.0

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

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