PREVIEW / etf_1hour / 2001-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-09-19.parquet
  size:    13 KB
  rows:    277

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
2001-09-19 09:00:00	SPY	ETF	104.1	104.45	103.8	104.19	2587900.0
2001-09-19 10:00:00	SPY	ETF	104.19	104.5	102.65	102.9	3341200.0
2001-09-19 11:00:00	SPY	ETF	102.87	102.93	101.23	101.3	6145300.0
2001-09-19 12:00:00	SPY	ETF	101.32	101.85	100.8	101.56	3196200.0
2001-09-19 13:00:00	SPY	ETF	101.62	101.76	100.45	101.08	5258200.0
2001-09-19 14:00:00	SPY	ETF	101.09	101.2	98.56	99.78	9607900.0
2001-09-19 15:00:00	SPY	ETF	99.75	102.57	99.7	102.02	9800200.0
2001-09-19 16:00:00	SPY	ETF	101.99	102.3	101.62	101.75	772600.0
2001-09-19 17:00:00	SPY	ETF	101.75	101.75	101.75	101.75	18500.0
2001-09-19 09:00:00	QQQ	ETF	30.64	30.94	30.53	30.71	8249800.0
2001-09-19 10:00:00	QQQ	ETF	30.73	30.98	29.84	29.92	17844900.0
2001-09-19 11:00:00	QQQ	ETF	29.91	29.94	29.15	29.15	19399700.0
2001-09-19 12:00:00	QQQ	ETF	29.15	29.46	29.0	29.42	10570700.0
2001-09-19 13:00:00	QQQ	ETF	29.4	29.58	28.91	29.17	8957900.0
2001-09-19 14:00:00	QQQ	ETF	29.19	29.25	28.26	28.75	17565600.0
2001-09-19 15:00:00	QQQ	ETF	28.77	30.36	28.74	30.11	27012500.0
2001-09-19 16:00:00	QQQ	ETF	30.1	30.15	28.55	30.0	2749600.0
2001-09-19 17:00:00	QQQ	ETF	30.0	30.08	29.95	30.02	382400.0
2001-09-19 18:00:00	QQQ	ETF	30.0	30.09	29.95	29.99	12100.0
2001-09-19 09:00:00	IWM	ETF	41.255	41.35	41.075	41.075	9000.0
2001-09-19 10:00:00	IWM	ETF	41.11	41.165	40.405	40.405	99200.0
2001-09-19 11:00:00	IWM	ETF	40.405	40.405	40.07	40.085	182000.0
2001-09-19 12:00:00	IWM	ETF	39.975	40.015	39.68	39.85	129000.0
2001-09-19 13:00:00	IWM	ETF	39.76	39.76	39.255	39.325	153800.0
2001-09-19 14:00:00	IWM	ETF	39.28	39.5	38.8	39.275	54200.0
2001-09-19 15:00:00	IWM	ETF	39.07	40.245	39.07	40.1	310400.0
2001-09-19 16:00:00	IWM	ETF	40.08	40.08	40.08	40.08	2000.0
2001-09-19 09:00:00	DIA	ETF	89.43	89.8	88.96	89.2	789900.0
2001-09-19 10:00:00	DIA	ETF	89.2	89.44	87.85	87.92	1454200.0
2001-09-19 11:00:00	DIA	ETF	88.0	88.0	86.56	86.6	1429200.0
2001-09-19 12:00:00	DIA	ETF	86.58	87.36	86.2	87.19	1073700.0
2001-09-19 13:00:00	DIA	ETF	87.25	87.45	86.11	86.75	1109700.0
2001-09-19 14:00:00	DIA	ETF	86.8	86.9	84.9	85.7	1353800.0
2001-09-19 15:00:00	DIA	ETF	85.89	88.5	85.51	87.75	2106600.0
2001-09-19 16:00:00	DIA	ETF	87.73	87.75	87.2	87.42	225900.0
2001-09-19 17:00:00	DIA	ETF	87.42	87.42	87.42	87.42	1000.0
2001-09-19 18:00:00	DIA	ETF	87.75	87.75	87.75	87.75	1000.0

> showing 37 of 277 rows — these rows as CSV

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