PREVIEW / etf_1hour / 2003-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-01.parquet
  size:    17 KB
  rows:    411

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
2003-07-01 08:00:00	SPY	ETF	97.56	97.6	97.03	97.19	129300.0
2003-07-01 09:00:00	SPY	ETF	97.2	97.39	97.14	97.2	3642300.0
2003-07-01 10:00:00	SPY	ETF	97.2	97.26	96.43	96.65	13608100.0
2003-07-01 11:00:00	SPY	ETF	96.675	97.14	96.66	96.99	3101400.0
2003-07-01 12:00:00	SPY	ETF	96.99	97.04	96.64	96.97	2534700.0
2003-07-01 13:00:00	SPY	ETF	96.99	97.67	96.97	97.4	5764300.0
2003-07-01 14:00:00	SPY	ETF	97.4	98.36	97.25	98.24	8019300.0
2003-07-01 15:00:00	SPY	ETF	98.24	98.66	98.16	98.56	6137900.0
2003-07-01 16:00:00	SPY	ETF	98.562	98.75	97.481	98.6	3256600.0
2003-07-01 17:00:00	SPY	ETF	98.54	98.65	98.54	98.58	6200.0
2003-07-01 18:00:00	SPY	ETF	98.57	98.64	98.55	98.62	81800.0
2003-07-01 19:00:00	SPY	ETF	98.65	98.65	98.62	98.64	1100.0
2003-07-01 08:00:00	QQQ	ETF	29.83	29.83	29.68	29.7	275600.0
2003-07-01 09:00:00	QQQ	ETF	29.71	29.75	29.61	29.67	8401500.0
2003-07-01 10:00:00	QQQ	ETF	29.67	29.7	29.26	29.39	18748900.0
2003-07-01 11:00:00	QQQ	ETF	29.4	29.58	29.38	29.57	7662500.0
2003-07-01 12:00:00	QQQ	ETF	29.56	29.59	29.42	29.55	3959800.0
2003-07-01 13:00:00	QQQ	ETF	29.55	29.77	29.54	29.64	10383600.0
2003-07-01 14:00:00	QQQ	ETF	29.66	30.242	29.57	30.15	19250700.0
2003-07-01 15:00:00	QQQ	ETF	30.154	30.33	30.07	30.299	15756400.0
2003-07-01 16:00:00	QQQ	ETF	30.29	30.38	29.704	30.37	5296600.0
2003-07-01 17:00:00	QQQ	ETF	30.36	30.37	30.33	30.34	54200.0
2003-07-01 18:00:00	QQQ	ETF	30.34	30.39	30.33	30.37	32600.0
2003-07-01 19:00:00	QQQ	ETF	30.36	30.41	30.36	30.4	46200.0
2003-07-01 09:00:00	IWM	ETF	44.405	44.49	44.2	44.285	662600.0
2003-07-01 10:00:00	IWM	ETF	44.25	44.25	43.875	43.935	769200.0
2003-07-01 11:00:00	IWM	ETF	43.925	44.13	43.915	44.12	479400.0
2003-07-01 12:00:00	IWM	ETF	44.12	44.16	44.025	44.16	559400.0
2003-07-01 13:00:00	IWM	ETF	44.17	44.325	44.16	44.265	400600.0
2003-07-01 14:00:00	IWM	ETF	44.28	44.81	44.255	44.8	1365600.0
2003-07-01 15:00:00	IWM	ETF	44.785	44.835	44.72	44.765	850000.0
2003-07-01 16:00:00	IWM	ETF	44.76	44.8	44.705	44.8	155000.0
2003-07-01 08:00:00	DIA	ETF	89.83	89.83	89.4	89.45	7500.0
2003-07-01 09:00:00	DIA	ETF	89.62	89.74	89.42	89.55	676200.0
2003-07-01 10:00:00	DIA	ETF	89.55	89.55	88.85	89.0	1949700.0
2003-07-01 11:00:00	DIA	ETF	89.0	89.4	89.0	89.27	768700.0
2003-07-01 12:00:00	DIA	ETF	89.27	89.32	89.04	89.3	375200.0
2003-07-01 13:00:00	DIA	ETF	89.3	89.8	89.3	89.59	755100.0
2003-07-01 14:00:00	DIA	ETF	89.58	90.49	89.44	90.38	1451400.0
2003-07-01 15:00:00	DIA	ETF	90.38	90.67	90.33	90.62	772400.0
2003-07-01 16:00:00	DIA	ETF	90.61	90.63	90.52	90.56	80600.0
2003-07-01 17:00:00	DIA	ETF	90.5	90.5	90.5	90.5	200.0
2003-07-01 18:00:00	DIA	ETF	90.55	90.6	90.55	90.58	1300.0
2003-07-01 19:00:00	DIA	ETF	90.6	90.61	90.6	90.61	800.0
2003-07-01 09:00:00	TLT	ETF	92.15	92.15	92.01	92.11	45900.0
2003-07-01 10:00:00	TLT	ETF	92.15	92.49	92.0	92.0	115500.0
2003-07-01 11:00:00	TLT	ETF	92.0	92.0	91.76	91.91	26800.0
2003-07-01 12:00:00	TLT	ETF	91.91	91.92	91.6	91.6	23400.0
2003-07-01 13:00:00	TLT	ETF	91.57	91.74	91.51	91.68	28000.0
2003-07-01 14:00:00	TLT	ETF	91.7	91.78	91.51	91.6	30000.0

> showing 50 of 411 rows — these rows as CSV

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