PREVIEW / etf_1hour / 2007-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-29.parquet
  size:    83 KB
  rows:    2,730

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-08-29 05:00:00	SPY	ETF	144.22	144.46	144.22	144.46	1600.0
2007-08-29 06:00:00	SPY	ETF	144.35	144.6	144.35	144.6	97900.0
2007-08-29 07:00:00	SPY	ETF	144.63	144.78	144.33	144.5	352800.0
2007-08-29 08:00:00	SPY	ETF	144.58	144.66	143.75	144.48	3902800.0
2007-08-29 09:00:00	SPY	ETF	144.47	144.79	144.18	144.28	23317897.0
2007-08-29 10:00:00	SPY	ETF	144.27	144.77	143.96	144.75	30265000.0
2007-08-29 11:00:00	SPY	ETF	144.75	145.63	144.69	145.25	25969600.0
2007-08-29 12:00:00	SPY	ETF	145.26	145.3	144.7	144.81	13565100.0
2007-08-29 13:00:00	SPY	ETF	144.82	145.06	144.47	144.78	15317200.0
2007-08-29 14:00:00	SPY	ETF	144.79	145.68	144.79	145.44	25811600.0
2007-08-29 15:00:00	SPY	ETF	145.43	146.74	145.43	146.71	50787200.0
2007-08-29 16:00:00	SPY	ETF	146.7	146.73	143.562	146.54	14198000.0
2007-08-29 17:00:00	SPY	ETF	146.56	146.78	146.54	146.59	132600.0
2007-08-29 18:00:00	SPY	ETF	146.65	146.76	146.65	146.76	124700.0
2007-08-29 19:00:00	SPY	ETF	146.69	146.69	146.53	146.55	37900.0
2007-08-29 04:00:00	QQQ	ETF	46.97	46.97	46.97	46.97	100.0
2007-08-29 05:00:00	QQQ	ETF	47.03	47.03	47.03	47.03	200.0
2007-08-29 07:00:00	QQQ	ETF	47.12	47.17	47.04	47.05	527845.0
2007-08-29 08:00:00	QQQ	ETF	47.05	47.06	46.94	47.0	1224542.0
2007-08-29 09:00:00	QQQ	ETF	47.0	47.21	46.99	47.12	12317788.0
2007-08-29 10:00:00	QQQ	ETF	47.12	47.39	47.06	47.35	13669755.0
2007-08-29 11:00:00	QQQ	ETF	47.35	47.52	47.33	47.46	10155786.0
2007-08-29 12:00:00	QQQ	ETF	47.47	47.48	47.32	47.3491	5499806.0
2007-08-29 13:00:00	QQQ	ETF	47.35	47.43	47.23	47.32	7347223.0
2007-08-29 14:00:00	QQQ	ETF	47.32	47.62	47.32	47.58	10750675.0
2007-08-29 15:00:00	QQQ	ETF	47.59	48.12	47.58	48.1	27919581.0
2007-08-29 16:00:00	QQQ	ETF	48.1	48.13	48.0	48.08	3223707.0
2007-08-29 17:00:00	QQQ	ETF	48.08	48.12	48.07	48.07	275525.0
2007-08-29 18:00:00	QQQ	ETF	48.08	48.13	48.08	48.13	25147.0
2007-08-29 19:00:00	QQQ	ETF	48.13	48.13	48.09	48.11	28884.0
2007-08-29 07:00:00	IWM	ETF	77.02	77.16	77.02	77.11	58400.0
2007-08-29 08:00:00	IWM	ETF	77.11	77.18	77.0	77.06	431100.0
2007-08-29 09:00:00	IWM	ETF	77.03	77.27	76.81	76.97	7228450.0
2007-08-29 10:00:00	IWM	ETF	76.98	77.31	76.77	77.3	9163000.0
2007-08-29 11:00:00	IWM	ETF	77.31	77.51	76.88	77.41	6084100.0
2007-08-29 12:00:00	IWM	ETF	77.41	77.43	77.06	77.12	3549300.0
2007-08-29 13:00:00	IWM	ETF	77.11	77.28	76.96	77.15	4711900.0
2007-08-29 14:00:00	IWM	ETF	77.16	77.66	77.16	77.56	5802300.0
2007-08-29 15:00:00	IWM	ETF	77.58	78.55	77.57	78.5	22866100.0
2007-08-29 16:00:00	IWM	ETF	78.5	78.56	78.44	78.5	849400.0
2007-08-29 17:00:00	IWM	ETF	78.55	78.55	78.51	78.53	4200.0
2007-08-29 18:00:00	IWM	ETF	78.57	78.59	78.57	78.57	11200.0
2007-08-29 19:00:00	IWM	ETF	78.6	78.6	78.59	78.6	5000.0
2007-08-29 07:00:00	DIA	ETF	131.09	131.28	131.05	131.1	16000.0
2007-08-29 08:00:00	DIA	ETF	131.18	131.24	131.04	131.18	37500.0
2007-08-29 09:00:00	DIA	ETF	131.14	131.38	131.03	131.13	1202200.0
2007-08-29 10:00:00	DIA	ETF	131.11	131.48	130.97	131.46	1506000.0
2007-08-29 11:00:00	DIA	ETF	131.46	131.9	131.44	131.79	1230600.0
2007-08-29 12:00:00	DIA	ETF	131.8	131.83	131.37	131.41	932700.0
2007-08-29 13:00:00	DIA	ETF	131.43	131.54	131.13	131.38	945200.0

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

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