PREVIEW / etf_1hour / 2003-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-08.parquet
  size:    17 KB
  rows:    439

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
2003-10-08 08:00:00	SPY	ETF	104.21	104.34	104.18	104.31	69200.0
2003-10-08 09:00:00	SPY	ETF	104.3	104.43	103.85	104.0	5910200.0
2003-10-08 10:00:00	SPY	ETF	104.0	104.29	103.68	103.71	4313900.0
2003-10-08 11:00:00	SPY	ETF	103.717	103.95	103.61	103.82	2855900.0
2003-10-08 12:00:00	SPY	ETF	103.81	104.03	103.68	103.953	2067400.0
2003-10-08 13:00:00	SPY	ETF	103.96	104.02	103.66	103.78	2037400.0
2003-10-08 14:00:00	SPY	ETF	103.77	103.8	103.41	103.73	4558900.0
2003-10-08 15:00:00	SPY	ETF	103.7	103.91	103.63	103.71	3170700.0
2003-10-08 16:00:00	SPY	ETF	103.72	104.13	103.69	103.91	1235800.0
2003-10-08 17:00:00	SPY	ETF	103.9036	103.97	103.86	103.97	289500.0
2003-10-08 18:00:00	SPY	ETF	103.93	103.95	103.82	103.95	13700.0
2003-10-08 19:00:00	SPY	ETF	103.91	103.91	103.91	103.91	500.0
2003-10-08 08:00:00	QQQ	ETF	34.63	34.7	34.59	34.7	71600.0
2003-10-08 09:00:00	QQQ	ETF	34.7	34.84	34.5	34.65	11614200.0
2003-10-08 10:00:00	QQQ	ETF	34.65	34.75	34.34	34.35	11832500.0
2003-10-08 11:00:00	QQQ	ETF	34.34	34.47	34.3	34.43	9189500.0
2003-10-08 12:00:00	QQQ	ETF	34.42	34.52	34.35	34.5	4025600.0
2003-10-08 13:00:00	QQQ	ETF	34.494	34.53	34.32	34.36	6065200.0
2003-10-08 14:00:00	QQQ	ETF	34.377	34.46	34.22	34.414	8891800.0
2003-10-08 15:00:00	QQQ	ETF	34.412	34.49	34.35	34.415	9410100.0
2003-10-08 16:00:00	QQQ	ETF	34.415	34.59	34.3	34.35	3173600.0
2003-10-08 17:00:00	QQQ	ETF	34.33	34.42	34.306	34.42	104300.0
2003-10-08 18:00:00	QQQ	ETF	34.41	34.41	34.35	34.41	18300.0
2003-10-08 19:00:00	QQQ	ETF	34.38	34.41	34.37	34.41	16000.0
2003-10-08 09:00:00	IWM	ETF	51.93	52.1	51.74	51.81	441400.0
2003-10-08 10:00:00	IWM	ETF	51.78	51.93	51.36	51.385	619600.0
2003-10-08 11:00:00	IWM	ETF	51.385	51.625	51.25	51.485	693000.0
2003-10-08 12:00:00	IWM	ETF	51.495	51.61	51.445	51.595	258800.0
2003-10-08 13:00:00	IWM	ETF	51.59	51.6	51.405	51.47	390800.0
2003-10-08 14:00:00	IWM	ETF	51.465	51.475	51.22	51.4	828000.0
2003-10-08 15:00:00	IWM	ETF	51.405	51.595	51.38	51.405	306400.0
2003-10-08 16:00:00	IWM	ETF	51.425	51.52	51.395	51.395	508400.0
2003-10-08 17:00:00	IWM	ETF	51.455	51.455	51.455	51.455	1000.0
2003-10-08 08:00:00	DIA	ETF	96.63	96.7	96.63	96.7	2500.0
2003-10-08 09:00:00	DIA	ETF	96.73	96.8	96.45	96.65	631500.0
2003-10-08 10:00:00	DIA	ETF	96.65	96.92	96.4	96.42	685400.0
2003-10-08 11:00:00	DIA	ETF	96.4	96.65	96.36	96.54	475000.0
2003-10-08 12:00:00	DIA	ETF	96.54	96.69	96.41	96.59	269500.0
2003-10-08 13:00:00	DIA	ETF	96.6	96.66	96.37	96.4	550100.0
2003-10-08 14:00:00	DIA	ETF	96.45	96.51	96.13	96.48	793000.0
2003-10-08 15:00:00	DIA	ETF	96.46	96.65	96.41	96.55	500800.0
2003-10-08 16:00:00	DIA	ETF	96.51	96.79	96.51	96.7	89100.0
2003-10-08 17:00:00	DIA	ETF	96.63	96.7	96.63	96.7	300.0
2003-10-08 09:00:00	TLT	ETF	84.45	84.61	84.42	84.5	152500.0
2003-10-08 10:00:00	TLT	ETF	84.42	84.81	84.35	84.8	71200.0
2003-10-08 11:00:00	TLT	ETF	84.75	84.85	84.69	84.77	129500.0
2003-10-08 12:00:00	TLT	ETF	84.8	84.89	84.7	84.74	43100.0
2003-10-08 13:00:00	TLT	ETF	84.81	84.95	84.75	84.88	32600.0
2003-10-08 14:00:00	TLT	ETF	84.93	84.98	84.66	84.69	23900.0
2003-10-08 15:00:00	TLT	ETF	84.64	84.75	84.53	84.67	198000.0

> showing 50 of 439 rows — these rows as CSV

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