PREVIEW / etf_1hour / 2001-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-16.parquet
  size:    13 KB
  rows:    268

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-11-16 09:00:00	SPY	ETF	115.08	115.1	114.22	114.5	2444600.0
2001-11-16 10:00:00	SPY	ETF	114.47	114.87	114.27	114.57	2781400.0
2001-11-16 11:00:00	SPY	ETF	114.51	114.66	114.0	114.22	1301100.0
2001-11-16 12:00:00	SPY	ETF	114.17	114.33	113.92	114.11	1466000.0
2001-11-16 13:00:00	SPY	ETF	114.12	114.24	113.44	113.5	2863800.0
2001-11-16 14:00:00	SPY	ETF	113.5	113.79	113.4	113.69	1732800.0
2001-11-16 15:00:00	SPY	ETF	113.66	114.39	113.6	114.31	4181300.0
2001-11-16 16:00:00	SPY	ETF	114.3	114.87	114.07	114.87	1187800.0
2001-11-16 17:00:00	SPY	ETF	114.87	114.87	114.4	114.4	11800.0
2001-11-16 18:00:00	SPY	ETF	114.66	114.7	114.66	114.7	500.0
2001-11-16 09:00:00	QQQ	ETF	39.48	39.57	39.16	39.38	9552300.0
2001-11-16 10:00:00	QQQ	ETF	39.37	39.68	39.16	39.49	11938100.0
2001-11-16 11:00:00	QQQ	ETF	39.51	39.65	39.27	39.4	8274400.0
2001-11-16 12:00:00	QQQ	ETF	39.4	39.49	39.13	39.33	5861400.0
2001-11-16 13:00:00	QQQ	ETF	39.33	39.4	38.92	38.95	7568900.0
2001-11-16 14:00:00	QQQ	ETF	38.95	39.16	38.92	39.13	6506500.0
2001-11-16 15:00:00	QQQ	ETF	39.12	39.49	39.1	39.45	11223900.0
2001-11-16 16:00:00	QQQ	ETF	39.42	39.52	39.33	39.45	2003400.0
2001-11-16 17:00:00	QQQ	ETF	39.45	42.08	39.43	39.5	86500.0
2001-11-16 18:00:00	QQQ	ETF	39.5	39.52	39.46	39.52	6900.0
2001-11-16 09:00:00	IWM	ETF	44.83	44.9	44.66	44.825	223400.0
2001-11-16 10:00:00	IWM	ETF	44.735	44.99	44.735	44.95	46000.0
2001-11-16 11:00:00	IWM	ETF	44.99	45.075	44.85	44.945	16600.0
2001-11-16 12:00:00	IWM	ETF	44.94	44.99	44.91	44.945	6400.0
2001-11-16 13:00:00	IWM	ETF	44.935	44.935	44.765	44.77	12800.0
2001-11-16 14:00:00	IWM	ETF	44.755	44.86	44.64	44.84	38800.0
2001-11-16 15:00:00	IWM	ETF	44.84	45.025	44.76	45.015	77200.0
2001-11-16 16:00:00	IWM	ETF	44.995	44.995	44.995	44.995	2000.0
2001-11-16 09:00:00	DIA	ETF	99.16	99.34	98.63	98.85	280700.0
2001-11-16 10:00:00	DIA	ETF	98.77	99.2	98.65	98.99	1450200.0
2001-11-16 11:00:00	DIA	ETF	98.86	99.1	98.55	98.72	405300.0
2001-11-16 12:00:00	DIA	ETF	98.71	98.8	98.5	98.69	200800.0
2001-11-16 13:00:00	DIA	ETF	98.74	98.79	98.11	98.2	328100.0
2001-11-16 14:00:00	DIA	ETF	98.16	98.4	98.01	98.2	757900.0
2001-11-16 15:00:00	DIA	ETF	98.2	98.79	98.19	98.7	425900.0
2001-11-16 16:00:00	DIA	ETF	98.75	98.87	98.5	98.8	94500.0
2001-11-16 18:00:00	DIA	ETF	99.0	99.0	99.0	99.0	200.0

> showing 37 of 268 rows — these rows as CSV

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