PREVIEW / etf_1hour / 2003-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-01.parquet
  size:    16 KB
  rows:    395

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-05-01 08:00:00	SPY	ETF	91.8	91.95	91.67	91.73	47300.0
2003-05-01 09:00:00	SPY	ETF	91.74	92.02	91.48	91.57	3685900.0
2003-05-01 10:00:00	SPY	ETF	91.48	91.52	90.5	90.85	11334400.0
2003-05-01 11:00:00	SPY	ETF	90.85	91.21	90.72	91.16	3280100.0
2003-05-01 12:00:00	SPY	ETF	91.16	91.35	90.97	91.21	4032900.0
2003-05-01 13:00:00	SPY	ETF	91.23	91.78	91.15	91.65	4655200.0
2003-05-01 14:00:00	SPY	ETF	91.67	92.38	91.62	92.09	9379100.0
2003-05-01 15:00:00	SPY	ETF	92.09	92.16	91.72	91.92	7342200.0
2003-05-01 16:00:00	SPY	ETF	92.02	92.53	91.8	91.81	2383000.0
2003-05-01 17:00:00	SPY	ETF	91.84	91.96	91.81	91.85	15400.0
2003-05-01 18:00:00	SPY	ETF	91.94	91.96	91.84	91.9	158000.0
2003-05-01 19:00:00	SPY	ETF	91.87	92.26	91.87	92.1	11800.0
2003-05-01 08:00:00	QQQ	ETF	27.39	27.44	27.35	27.37	68300.0
2003-05-01 09:00:00	QQQ	ETF	27.37	27.56	27.36	27.44	7851200.0
2003-05-01 10:00:00	QQQ	ETF	27.45	27.46	27.19	27.31	15019700.0
2003-05-01 11:00:00	QQQ	ETF	27.31	27.4	27.2	27.34	6183400.0
2003-05-01 12:00:00	QQQ	ETF	27.35	27.43	27.29	27.37	4763700.0
2003-05-01 13:00:00	QQQ	ETF	27.37	27.62	27.33	27.54	6395400.0
2003-05-01 14:00:00	QQQ	ETF	27.55	27.87	27.51	27.71	12609100.0
2003-05-01 15:00:00	QQQ	ETF	27.7	27.79	27.57	27.68	7298400.0
2003-05-01 16:00:00	QQQ	ETF	27.68	27.7	27.62	27.65	1018900.0
2003-05-01 17:00:00	QQQ	ETF	27.65	27.68	27.63	27.66	147800.0
2003-05-01 18:00:00	QQQ	ETF	27.67	27.72	27.66	27.7	13200.0
2003-05-01 19:00:00	QQQ	ETF	27.71	27.75	27.7	27.72	9000.0
2003-05-01 09:00:00	IWM	ETF	39.75	39.75	39.54	39.555	253000.0
2003-05-01 10:00:00	IWM	ETF	39.535	39.535	39.245	39.39	452000.0
2003-05-01 11:00:00	IWM	ETF	39.405	39.505	39.405	39.5	116200.0
2003-05-01 12:00:00	IWM	ETF	39.535	39.595	39.475	39.535	270200.0
2003-05-01 13:00:00	IWM	ETF	39.535	39.735	39.535	39.695	380200.0
2003-05-01 14:00:00	IWM	ETF	39.725	39.925	39.695	39.885	585200.0
2003-05-01 15:00:00	IWM	ETF	39.815	39.815	39.645	39.65	368600.0
2003-05-01 16:00:00	IWM	ETF	39.715	39.76	39.715	39.755	1600.0
2003-05-01 08:00:00	DIA	ETF	84.81	84.81	84.56	84.65	15000.0
2003-05-01 09:00:00	DIA	ETF	84.66	84.8	84.37	84.44	1004600.0
2003-05-01 10:00:00	DIA	ETF	84.43	84.44	83.5	83.75	3404900.0
2003-05-01 11:00:00	DIA	ETF	83.8	84.09	83.65	84.01	1213800.0
2003-05-01 12:00:00	DIA	ETF	84.01	84.1	83.86	84.0	530500.0
2003-05-01 13:00:00	DIA	ETF	83.98	84.51	83.91	84.34	1116800.0
2003-05-01 14:00:00	DIA	ETF	84.33	84.93	84.3	84.7	1705600.0
2003-05-01 15:00:00	DIA	ETF	84.67	84.76	84.39	84.64	1308200.0
2003-05-01 16:00:00	DIA	ETF	84.65	84.74	84.61	84.67	132200.0
2003-05-01 17:00:00	DIA	ETF	84.63	84.69	84.61	84.69	3300.0
2003-05-01 18:00:00	DIA	ETF	84.63	84.7	84.63	84.7	2200.0
2003-05-01 19:00:00	DIA	ETF	84.7	84.8	84.7	84.8	2000.0
2003-05-01 09:00:00	TLT	ETF	89.2	89.37	89.2	89.37	10000.0
2003-05-01 10:00:00	TLT	ETF	89.41	89.6	89.4	89.42	38200.0
2003-05-01 11:00:00	TLT	ETF	89.4	89.44	89.21	89.21	8200.0
2003-05-01 12:00:00	TLT	ETF	89.23	89.24	89.04	89.05	3400.0
2003-05-01 13:00:00	TLT	ETF	89.1	89.1	88.87	88.92	29700.0
2003-05-01 14:00:00	TLT	ETF	89.02	89.02	88.8	88.8	128900.0

> showing 50 of 395 rows — these rows as CSV

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