PREVIEW / etf_1hour / 2007-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-04.parquet
  size:    81 KB
  rows:    2,754

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-04 05:00:00	SPY	ETF	154.09	154.09	154.09	154.09	10000.0
2007-10-04 06:00:00	SPY	ETF	154.12	154.13	154.0	154.13	93500.0
2007-10-04 07:00:00	SPY	ETF	154.06	154.17	154.01	154.09	119500.0
2007-10-04 08:00:00	SPY	ETF	154.09	154.23	153.95	154.2	1178400.0
2007-10-04 09:00:00	SPY	ETF	154.18	154.22	153.65	153.75	10571510.0
2007-10-04 10:00:00	SPY	ETF	153.76	154.26	153.59	154.18	17419435.0
2007-10-04 11:00:00	SPY	ETF	154.18	154.22	153.91	153.95	7069800.0
2007-10-04 12:00:00	SPY	ETF	153.95	154.1	153.84	154.03	5769800.0
2007-10-04 13:00:00	SPY	ETF	154.04	154.1	153.76	153.91	9570100.0
2007-10-04 14:00:00	SPY	ETF	153.9	154.02	153.82	153.9	6096000.0
2007-10-04 15:00:00	SPY	ETF	153.9	154.19	153.85	154.16	16001200.0
2007-10-04 16:00:00	SPY	ETF	154.14	154.15	153.94	154.0	1576100.0
2007-10-04 17:00:00	SPY	ETF	153.99	154.04	153.9	153.99	37400.0
2007-10-04 18:00:00	SPY	ETF	153.93	153.93	153.86	153.9	49200.0
2007-10-04 19:00:00	SPY	ETF	153.91	153.97	153.87	153.97	98900.0
2007-10-04 05:00:00	QQQ	ETF	51.69	51.69	51.69	51.69	500.0
2007-10-04 07:00:00	QQQ	ETF	51.67	51.74	51.67	51.68	77604.0
2007-10-04 08:00:00	QQQ	ETF	51.7	51.78	51.66	51.76	910241.0
2007-10-04 09:00:00	QQQ	ETF	51.73	51.77	51.34	51.46	18342804.0
2007-10-04 10:00:00	QQQ	ETF	51.46	51.8	51.42	51.78	19855686.0
2007-10-04 11:00:00	QQQ	ETF	51.79	51.79	51.66	51.6799	7499820.0
2007-10-04 12:00:00	QQQ	ETF	51.67	51.73	51.6	51.7	4724996.0
2007-10-04 13:00:00	QQQ	ETF	51.7	51.71	51.55	51.61	6490718.0
2007-10-04 14:00:00	QQQ	ETF	51.62	51.66	51.58	51.63	4179113.0
2007-10-04 15:00:00	QQQ	ETF	51.64	51.83	51.63	51.76	13562813.0
2007-10-04 16:00:00	QQQ	ETF	51.76	51.78	51.54	51.66	10749576.0
2007-10-04 17:00:00	QQQ	ETF	51.68	51.72	51.63	51.72	11222.0
2007-10-04 18:00:00	QQQ	ETF	51.71	51.71	51.65	51.7	32621.0
2007-10-04 19:00:00	QQQ	ETF	51.68	51.7	51.67	51.7	10500.0
2007-10-04 07:00:00	IWM	ETF	82.6	82.71	82.6	82.71	2400.0
2007-10-04 08:00:00	IWM	ETF	82.59	82.66	82.57	82.6	26600.0
2007-10-04 09:00:00	IWM	ETF	82.63	82.66	82.0	82.1	6311236.0
2007-10-04 10:00:00	IWM	ETF	82.1	82.72	81.99	82.63	9062200.0
2007-10-04 11:00:00	IWM	ETF	82.63	82.65	82.44	82.48	2329400.0
2007-10-04 12:00:00	IWM	ETF	82.48	82.65	82.35	82.61	4244200.0
2007-10-04 13:00:00	IWM	ETF	82.6	82.62	82.4	82.45	3345000.0
2007-10-04 14:00:00	IWM	ETF	82.45	82.55	82.3	82.46	2591400.0
2007-10-04 15:00:00	IWM	ETF	82.45	82.58	82.38	82.58	6332100.0
2007-10-04 16:00:00	IWM	ETF	82.58	82.63	82.42	82.53	1479000.0
2007-10-04 17:00:00	IWM	ETF	82.53	82.57	82.45	82.51	59700.0
2007-10-04 07:00:00	DIA	ETF	139.84	139.95	139.84	139.95	2000.0
2007-10-04 08:00:00	DIA	ETF	139.85	140.02	139.85	140.02	6700.0
2007-10-04 09:00:00	DIA	ETF	140.01	140.04	139.49	139.57	1509000.0
2007-10-04 10:00:00	DIA	ETF	139.58	139.76	139.43	139.72	1509300.0
2007-10-04 11:00:00	DIA	ETF	139.73	139.74	139.54	139.56	501800.0
2007-10-04 12:00:00	DIA	ETF	139.54	139.75	139.49	139.68	524000.0
2007-10-04 13:00:00	DIA	ETF	139.68	139.69	139.45	139.52	445600.0
2007-10-04 14:00:00	DIA	ETF	139.52	139.61	139.49	139.52	236000.0
2007-10-04 15:00:00	DIA	ETF	139.52	139.64	139.43	139.64	2362100.0
2007-10-04 16:00:00	DIA	ETF	139.65	139.72	139.51	139.53	137900.0

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

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