PREVIEW / etf_1hour / 2001-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-25.parquet
  size:    11 KB
  rows:    228

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-07-25 09:00:00	SPY	ETF	117.92	118.14	117.46	117.63	1119500.0
2001-07-25 10:00:00	SPY	ETF	117.62	118.7	117.51	118.52	3183000.0
2001-07-25 11:00:00	SPY	ETF	118.52	118.57	117.86	117.89	800900.0
2001-07-25 12:00:00	SPY	ETF	117.89	118.08	117.57	117.92	1143400.0
2001-07-25 13:00:00	SPY	ETF	117.92	118.25	117.71	118.06	853100.0
2001-07-25 14:00:00	SPY	ETF	118.08	118.86	117.96	118.73	1496400.0
2001-07-25 15:00:00	SPY	ETF	118.7	119.48	118.56	119.3	2489800.0
2001-07-25 16:00:00	SPY	ETF	119.26	119.4	118.18	119.21	503400.0
2001-07-25 17:00:00	SPY	ETF	119.17	119.2	119.12	119.2	2500.0
2001-07-25 18:00:00	SPY	ETF	119.2	119.4	119.06	119.06	2200.0
2001-07-25 09:00:00	QQQ	ETF	40.14	40.37	39.75	39.88	7089800.0
2001-07-25 10:00:00	QQQ	ETF	39.9	40.72	39.75	40.51	13198900.0
2001-07-25 11:00:00	QQQ	ETF	40.51	40.55	40.0	40.03	6808500.0
2001-07-25 12:00:00	QQQ	ETF	40.0	40.11	39.6	39.78	6765800.0
2001-07-25 13:00:00	QQQ	ETF	39.78	39.9	39.4	39.67	7796900.0
2001-07-25 14:00:00	QQQ	ETF	39.68	40.42	39.6	40.37	10477400.0
2001-07-25 15:00:00	QQQ	ETF	40.34	40.67	40.0	40.57	12245800.0
2001-07-25 16:00:00	QQQ	ETF	40.54	40.71	40.41	40.63	926700.0
2001-07-25 17:00:00	QQQ	ETF	40.6	40.8	40.55	40.66	201700.0
2001-07-25 18:00:00	QQQ	ETF	40.65	40.7	40.59	40.7	21000.0
2001-07-25 09:00:00	IWM	ETF	47.45	47.45	47.055	47.195	18000.0
2001-07-25 10:00:00	IWM	ETF	47.225	47.5	47.225	47.44	119200.0
2001-07-25 11:00:00	IWM	ETF	47.44	47.44	47.135	47.205	22400.0
2001-07-25 12:00:00	IWM	ETF	47.2	47.245	46.955	47.07	80400.0
2001-07-25 13:00:00	IWM	ETF	47.05	47.125	46.955	47.125	68600.0
2001-07-25 14:00:00	IWM	ETF	47.1	47.295	46.96	47.295	43000.0
2001-07-25 15:00:00	IWM	ETF	47.295	47.65	47.275	47.625	232200.0
2001-07-25 16:00:00	IWM	ETF	47.625	47.625	47.615	47.625	18000.0
2001-07-25 09:00:00	DIA	ETF	102.7	103.0	102.57	102.76	324300.0
2001-07-25 10:00:00	DIA	ETF	102.76	103.55	102.73	103.45	532400.0
2001-07-25 11:00:00	DIA	ETF	103.48	103.48	102.94	102.94	127200.0
2001-07-25 12:00:00	DIA	ETF	102.93	103.07	102.63	102.9	137700.0
2001-07-25 13:00:00	DIA	ETF	102.95	103.25	102.76	103.07	206100.0
2001-07-25 14:00:00	DIA	ETF	102.95	103.48	102.9	103.38	221500.0
2001-07-25 15:00:00	DIA	ETF	103.32	104.24	103.27	104.1	461900.0
2001-07-25 16:00:00	DIA	ETF	104.05	104.14	103.9	103.9	118000.0

> showing 36 of 228 rows — these rows as CSV

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