PREVIEW / etf_1hour / 2003-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-11.parquet
  size:    19 KB
  rows:    496

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-12-11 08:00:00	SPY	ETF	106.82	106.86	106.64	106.64	18700.0
2003-12-11 09:00:00	SPY	ETF	106.66	107.23	106.66	107.14	5949800.0
2003-12-11 10:00:00	SPY	ETF	107.15	107.57	106.99	107.48	7326600.0
2003-12-11 11:00:00	SPY	ETF	107.48	107.56	107.35	107.5	2520200.0
2003-12-11 12:00:00	SPY	ETF	107.49	107.59	107.38	107.4	1360100.0
2003-12-11 13:00:00	SPY	ETF	107.42	107.53	107.21	107.36	2976200.0
2003-12-11 14:00:00	SPY	ETF	107.33	107.9	107.25	107.8	8568900.0
2003-12-11 15:00:00	SPY	ETF	107.79	108.1	107.68	107.84	4733900.0
2003-12-11 16:00:00	SPY	ETF	107.83	107.97	107.79	107.9	3069000.0
2003-12-11 17:00:00	SPY	ETF	107.92	107.99	107.91	107.96	171900.0
2003-12-11 18:00:00	SPY	ETF	107.96	108.04	107.96	108.0	12300.0
2003-12-11 19:00:00	SPY	ETF	108.0	108.0	107.99	107.99	1300.0
2003-12-11 08:00:00	QQQ	ETF	34.67	34.67	34.52	34.53	239600.0
2003-12-11 09:00:00	QQQ	ETF	34.52	34.83	34.493	34.76	16009500.0
2003-12-11 10:00:00	QQQ	ETF	34.77	35.03	34.62	34.97	21105800.0
2003-12-11 11:00:00	QQQ	ETF	34.969	35.015	34.841	34.98	10854200.0
2003-12-11 12:00:00	QQQ	ETF	34.98	35.04	34.91	34.941	6685200.0
2003-12-11 13:00:00	QQQ	ETF	34.941	35.04	34.83	34.92	8947400.0
2003-12-11 14:00:00	QQQ	ETF	34.92	35.26	34.88	35.189	16394300.0
2003-12-11 15:00:00	QQQ	ETF	35.18	35.39	35.18	35.24	19744700.0
2003-12-11 16:00:00	QQQ	ETF	35.26	35.32	35.21	35.31	2408200.0
2003-12-11 17:00:00	QQQ	ETF	35.3	35.34	35.3	35.33	56300.0
2003-12-11 18:00:00	QQQ	ETF	35.32	35.34	35.32	35.34	26600.0
2003-12-11 19:00:00	QQQ	ETF	35.35	35.35	35.33	35.34	18300.0
2003-12-11 09:00:00	IWM	ETF	52.775	53.53	52.775	53.5	1482000.0
2003-12-11 10:00:00	IWM	ETF	53.5	53.985	53.345	53.935	2233200.0
2003-12-11 11:00:00	IWM	ETF	53.91	53.935	53.73	53.91	1561200.0
2003-12-11 12:00:00	IWM	ETF	53.915	53.97	53.8	53.83	400800.0
2003-12-11 13:00:00	IWM	ETF	53.82	53.96	53.74	53.82	221400.0
2003-12-11 14:00:00	IWM	ETF	53.825	54.135	53.789	54.01	1062000.0
2003-12-11 15:00:00	IWM	ETF	54.015	54.25	54.005	54.1305	1336800.0
2003-12-11 16:00:00	IWM	ETF	54.158	54.3095	54.142	54.225	422400.0
2003-12-11 08:00:00	DIA	ETF	99.65	99.65	99.6	99.6	4300.0
2003-12-11 09:00:00	DIA	ETF	99.58	99.89	99.52	99.82	893400.0
2003-12-11 10:00:00	DIA	ETF	99.79	100.1	99.67	100.03	1336500.0
2003-12-11 11:00:00	DIA	ETF	100.03	100.09	99.9	100.0	484200.0
2003-12-11 12:00:00	DIA	ETF	99.99	100.08	99.927	99.96	250600.0
2003-12-11 13:00:00	DIA	ETF	99.96	100.04	99.79	99.85	461900.0
2003-12-11 14:00:00	DIA	ETF	99.88	100.31	99.8	100.22	1681600.0
2003-12-11 15:00:00	DIA	ETF	100.238	100.43	100.11	100.25	1103000.0
2003-12-11 16:00:00	DIA	ETF	100.23	100.41	100.23	100.33	227900.0
2003-12-11 17:00:00	DIA	ETF	100.39	100.41	100.39	100.41	2100.0
2003-12-11 18:00:00	DIA	ETF	100.41	100.41	100.41	100.41	100.0
2003-12-11 19:00:00	DIA	ETF	100.41	100.41	100.41	100.41	100.0
2003-12-11 09:00:00	TLT	ETF	84.51	84.51	84.37	84.39	47500.0
2003-12-11 10:00:00	TLT	ETF	84.38	84.57	84.38	84.57	36900.0
2003-12-11 11:00:00	TLT	ETF	84.57	84.7	84.55	84.7	52600.0
2003-12-11 12:00:00	TLT	ETF	84.69	84.75	84.61	84.75	38000.0
2003-12-11 13:00:00	TLT	ETF	84.75	84.75	84.42	84.64	65900.0
2003-12-11 14:00:00	TLT	ETF	84.59	85.38	84.59	85.33	144200.0

> showing 50 of 496 rows — these rows as CSV

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