PREVIEW / etf_1hour / 2002-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-01.parquet
  size:    16 KB
  rows:    373

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
2002-10-01 08:00:00	SPY	ETF	82.38	82.6	82.38	82.45	5000.0
2002-10-01 09:00:00	SPY	ETF	82.45	82.72	81.99	82.14	4380100.0
2002-10-01 10:00:00	SPY	ETF	82.13	82.7	81.47	82.11	12936900.0
2002-10-01 11:00:00	SPY	ETF	82.08	82.27	81.74	81.97	4043300.0
2002-10-01 12:00:00	SPY	ETF	81.96	83.05	81.8	82.9	4836900.0
2002-10-01 13:00:00	SPY	ETF	82.9	83.72	82.79	83.35	11073400.0
2002-10-01 14:00:00	SPY	ETF	83.32	84.28	83.13	83.8	8675700.0
2002-10-01 15:00:00	SPY	ETF	83.8	85.1	83.78	85.0	11936900.0
2002-10-01 16:00:00	SPY	ETF	85.06	85.87	84.43	85.62	6504100.0
2002-10-01 17:00:00	SPY	ETF	85.65	85.67	83.51	85.63	95100.0
2002-10-01 18:00:00	SPY	ETF	85.6	85.72	85.6	85.72	3400.0
2002-10-01 19:00:00	SPY	ETF	85.72	85.73	85.72	85.73	300.0
2002-10-01 08:00:00	QQQ	ETF	21.0	21.0	20.89	20.9	9400.0
2002-10-01 09:00:00	QQQ	ETF	20.88	21.07	20.69	20.77	8354200.0
2002-10-01 10:00:00	QQQ	ETF	20.76	20.87	20.47	20.66	20885400.0
2002-10-01 11:00:00	QQQ	ETF	20.67	20.77	20.52	20.68	7450200.0
2002-10-01 12:00:00	QQQ	ETF	20.68	21.0	20.62	20.92	8119000.0
2002-10-01 13:00:00	QQQ	ETF	20.91	21.15	20.85	20.98	16284800.0
2002-10-01 14:00:00	QQQ	ETF	20.99	21.35	20.91	21.19	12508400.0
2002-10-01 15:00:00	QQQ	ETF	21.2	21.64	21.15	21.62	18989800.0
2002-10-01 16:00:00	QQQ	ETF	21.61	22.03	21.03	21.99	7782700.0
2002-10-01 17:00:00	QQQ	ETF	21.98	22.03	21.93	21.97	214800.0
2002-10-01 18:00:00	QQQ	ETF	21.96	21.98	21.94	21.98	40700.0
2002-10-01 19:00:00	QQQ	ETF	22.0	22.04	22.0	22.04	500.0
2002-10-01 09:00:00	IWM	ETF	36.25	36.275	35.625	35.72	343600.0
2002-10-01 10:00:00	IWM	ETF	35.725	35.975	35.475	35.775	415000.0
2002-10-01 11:00:00	IWM	ETF	35.755	35.79	35.67	35.75	211200.0
2002-10-01 12:00:00	IWM	ETF	35.785	36.0	35.715	36.0	317800.0
2002-10-01 13:00:00	IWM	ETF	35.995	36.26	35.965	36.175	220000.0
2002-10-01 14:00:00	IWM	ETF	36.15	36.425	36.1	36.34	421600.0
2002-10-01 15:00:00	IWM	ETF	36.285	36.65	36.255	36.65	638400.0
2002-10-01 16:00:00	IWM	ETF	36.64	36.925	36.64	36.675	692200.0
2002-10-01 17:00:00	IWM	ETF	36.675	36.675	36.675	36.675	163600.0
2002-10-01 08:00:00	DIA	ETF	76.62	76.8	76.6	76.6	5400.0
2002-10-01 09:00:00	DIA	ETF	76.6	77.0	76.32	76.5	1320600.0
2002-10-01 10:00:00	DIA	ETF	76.5	76.97	75.95	76.66	3696600.0
2002-10-01 11:00:00	DIA	ETF	76.61	76.78	76.23	76.45	801300.0
2002-10-01 12:00:00	DIA	ETF	76.4	77.3	76.32	77.15	927200.0
2002-10-01 13:00:00	DIA	ETF	77.24	78.04	77.12	77.75	2541700.0
2002-10-01 14:00:00	DIA	ETF	77.7	78.6	77.51	78.24	2391400.0
2002-10-01 15:00:00	DIA	ETF	78.23	79.54	78.15	79.48	2905500.0
2002-10-01 16:00:00	DIA	ETF	79.52	80.2	79.38	79.95	382700.0
2002-10-01 17:00:00	DIA	ETF	80.05	80.05	79.8	79.94	260000.0
2002-10-01 18:00:00	DIA	ETF	79.95	80.0	79.88	80.0	1300.0
2002-10-01 09:00:00	TLT	ETF	89.16	89.2	89.01	89.17	156000.0
2002-10-01 10:00:00	TLT	ETF	89.17	89.3	88.8	89.02	65700.0
2002-10-01 11:00:00	TLT	ETF	88.96	89.19	88.94	89.08	11000.0
2002-10-01 12:00:00	TLT	ETF	89.05	89.17	88.98	89.17	3800.0
2002-10-01 13:00:00	TLT	ETF	89.05	89.15	89.05	89.11	2200.0
2002-10-01 14:00:00	TLT	ETF	89.12	89.16	88.92	89.05	4600.0

> showing 50 of 373 rows — these rows as CSV

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