PREVIEW / etf_1hour / 2007-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-03.parquet
  size:    86 KB
  rows:    2,852

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-03 06:00:00	SPY	ETF	147.59	147.59	146.65	147.56	18000.0
2007-08-03 07:00:00	SPY	ETF	147.51	147.69	147.44	147.56	332900.0
2007-08-03 08:00:00	SPY	ETF	147.64	147.9	146.92	147.43	12183900.0
2007-08-03 09:00:00	SPY	ETF	147.44	147.6	146.36	146.53	35162706.0
2007-08-03 10:00:00	SPY	ETF	146.53	146.91	145.64	146.08	60520109.0
2007-08-03 11:00:00	SPY	ETF	146.09	146.74	145.99	146.47	38938987.0
2007-08-03 12:00:00	SPY	ETF	146.47	147.3005	145.9	146.05	27388745.0
2007-08-03 13:00:00	SPY	ETF	146.04	147.3005	145.91	146.41	22483387.0
2007-08-03 14:00:00	SPY	ETF	146.4	146.78	145.07	145.29	59729878.0
2007-08-03 15:00:00	SPY	ETF	145.29	145.92	143.24	143.35	80923824.0
2007-08-03 16:00:00	SPY	ETF	143.34	147.2997	143.2	143.63	11462477.0
2007-08-03 17:00:00	SPY	ETF	143.65	147.2997	143.65	143.72	1391600.0
2007-08-03 18:00:00	SPY	ETF	143.73	144.36	143.63	143.64	132900.0
2007-08-03 19:00:00	SPY	ETF	143.63	143.7	143.55	143.7	18100.0
2007-08-03 07:00:00	QQQ	ETF	48.29	48.36	48.27	48.33	227373.0
2007-08-03 08:00:00	QQQ	ETF	48.33	48.43	48.22	48.32	5966251.0
2007-08-03 09:00:00	QQQ	ETF	48.32	48.34	48.0	48.05	12947124.0
2007-08-03 10:00:00	QQQ	ETF	48.06	48.09	47.85	47.96	26083635.0
2007-08-03 11:00:00	QQQ	ETF	47.95	48.14	47.91	48.09	15591376.0
2007-08-03 12:00:00	QQQ	ETF	48.09	48.29	47.95	47.98	20390181.0
2007-08-03 13:00:00	QQQ	ETF	47.99	48.12	47.94	48.08	8578218.0
2007-08-03 14:00:00	QQQ	ETF	48.09	48.2	47.7	47.79	21114981.0
2007-08-03 15:00:00	QQQ	ETF	47.79	47.84	47.15	47.17	36013027.0
2007-08-03 16:00:00	QQQ	ETF	47.17	47.43	47.154	47.34	4296819.0
2007-08-03 17:00:00	QQQ	ETF	47.32	47.42	47.31	47.36	306831.0
2007-08-03 18:00:00	QQQ	ETF	47.36	47.53	47.36	47.42	166258.0
2007-08-03 19:00:00	QQQ	ETF	47.42	47.5	47.38	47.5	13346.0
2007-08-03 07:00:00	IWM	ETF	78.07	78.2	78.07	78.18	80500.0
2007-08-03 08:00:00	IWM	ETF	78.17	78.56	77.98	78.08	1914900.0
2007-08-03 09:00:00	IWM	ETF	78.08	78.21	77.4	77.48	16106097.0
2007-08-03 10:00:00	IWM	ETF	77.48	77.56	76.93	77.21	19105121.0
2007-08-03 11:00:00	IWM	ETF	77.2	77.51	77.05	77.3	12791992.0
2007-08-03 12:00:00	IWM	ETF	77.3	77.45	76.88	76.99	7276971.0
2007-08-03 13:00:00	IWM	ETF	76.99	77.29	76.87	77.17	6627832.0
2007-08-03 14:00:00	IWM	ETF	77.18	77.36	75.98	76.11	27607244.0
2007-08-03 15:00:00	IWM	ETF	76.12	76.16	74.99	75.05	38135339.0
2007-08-03 16:00:00	IWM	ETF	75.05	75.5	74.96	75.45	10742300.0
2007-08-03 17:00:00	IWM	ETF	78.0651	78.0651	75.2	75.45	3005600.0
2007-08-03 18:00:00	IWM	ETF	75.3	75.3	75.15	75.17	4100.0
2007-08-03 19:00:00	IWM	ETF	75.17	75.45	75.17	75.35	5500.0
2007-08-03 07:00:00	DIA	ETF	134.52	134.52	134.51	134.51	200.0
2007-08-03 08:00:00	DIA	ETF	134.61	134.9	134.3	134.51	197200.0
2007-08-03 09:00:00	DIA	ETF	134.47	134.72	133.68	134.02	2132860.0
2007-08-03 10:00:00	DIA	ETF	134.02	134.06	133.31	133.75	7105102.0
2007-08-03 11:00:00	DIA	ETF	133.76	134.21	133.69	134.13	3966900.0
2007-08-03 12:00:00	DIA	ETF	134.13	134.42	133.71	133.79	1918300.0
2007-08-03 13:00:00	DIA	ETF	133.8	134.32	133.68	134.2	1808200.0
2007-08-03 14:00:00	DIA	ETF	134.22	134.5	133.26	133.46	4818500.0
2007-08-03 15:00:00	DIA	ETF	133.48	133.53	131.62	131.62	10871500.0
2007-08-03 16:00:00	DIA	ETF	131.62	134.0	131.54	132.19	427000.0

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

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