PREVIEW / etf_1hour / 2001-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-13.parquet
  size:    13 KB
  rows:    289

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-12-13 09:00:00	SPY	ETF	113.45	113.45	112.73	113.13	4826900.0
2001-12-13 10:00:00	SPY	ETF	113.11	113.53	112.87	113.5	3069100.0
2001-12-13 11:00:00	SPY	ETF	113.48	113.7	113.24	113.4	2344500.0
2001-12-13 12:00:00	SPY	ETF	113.4	113.46	113.2	113.24	1009800.0
2001-12-13 13:00:00	SPY	ETF	113.24	113.66	113.0	113.12	1106800.0
2001-12-13 14:00:00	SPY	ETF	113.14	113.29	112.6	112.7	1895300.0
2001-12-13 15:00:00	SPY	ETF	112.74	112.82	112.28	112.36	2852800.0
2001-12-13 16:00:00	SPY	ETF	112.36	112.99	111.9	112.13	1758700.0
2001-12-13 17:00:00	SPY	ETF	112.13	112.13	111.93	112.1	164500.0
2001-12-13 18:00:00	SPY	ETF	112.05	112.25	112.05	112.25	6300.0
2001-12-13 09:00:00	QQQ	ETF	40.71	41.0	40.6	40.8	12473300.0
2001-12-13 10:00:00	QQQ	ETF	40.78	40.95	40.37	40.76	15524300.0
2001-12-13 11:00:00	QQQ	ETF	40.78	40.94	40.62	40.75	6887400.0
2001-12-13 12:00:00	QQQ	ETF	40.74	40.8	40.48	40.5	4432600.0
2001-12-13 13:00:00	QQQ	ETF	40.51	40.78	40.37	40.53	7371400.0
2001-12-13 14:00:00	QQQ	ETF	40.53	40.6	40.01	40.1	11243800.0
2001-12-13 15:00:00	QQQ	ETF	40.1	40.22	39.85	39.87	18076100.0
2001-12-13 16:00:00	QQQ	ETF	39.9	40.1	39.63	39.63	3399500.0
2001-12-13 17:00:00	QQQ	ETF	39.62	39.9	39.56	39.8	139300.0
2001-12-13 18:00:00	QQQ	ETF	39.8	39.9	39.75	39.88	56200.0
2001-12-13 09:00:00	IWM	ETF	46.975	47.02	46.705	47.02	28200.0
2001-12-13 10:00:00	IWM	ETF	47.025	47.1	46.84	47.07	81800.0
2001-12-13 11:00:00	IWM	ETF	47.125	47.22	47.0	47.125	19800.0
2001-12-13 12:00:00	IWM	ETF	47.18	47.205	47.125	47.125	11800.0
2001-12-13 13:00:00	IWM	ETF	47.125	47.27	47.11	47.175	11600.0
2001-12-13 14:00:00	IWM	ETF	47.1	47.145	46.86	47.0	409800.0
2001-12-13 15:00:00	IWM	ETF	46.85	47.0	46.625	46.625	118800.0
2001-12-13 16:00:00	IWM	ETF	46.55	46.66	46.55	46.555	114600.0
2001-12-13 09:00:00	DIA	ETF	98.3	98.44	98.01	98.27	1516800.0
2001-12-13 10:00:00	DIA	ETF	98.33	98.56	98.14	98.56	265000.0
2001-12-13 11:00:00	DIA	ETF	98.64	98.79	98.4	98.58	129200.0
2001-12-13 12:00:00	DIA	ETF	98.58	98.6	98.35	98.35	37500.0
2001-12-13 13:00:00	DIA	ETF	98.4	98.68	98.23	98.3	106800.0
2001-12-13 14:00:00	DIA	ETF	98.35	98.45	97.9	97.94	227000.0
2001-12-13 15:00:00	DIA	ETF	97.98	98.1	97.65	97.82	657100.0
2001-12-13 16:00:00	DIA	ETF	97.73	98.69	97.49	97.49	33600.0
2001-12-13 17:00:00	DIA	ETF	97.48	97.48	97.41	97.41	800.0
2001-12-13 18:00:00	DIA	ETF	97.49	97.49	97.49	97.49	100.0

> showing 38 of 289 rows — these rows as CSV

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