PREVIEW / etf_1hour / 2004-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-13.parquet
  size:    25 KB
  rows:    689

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
2004-02-13 08:00:00	SPY	ETF	115.86	115.94	115.85	115.85	4300.0
2004-02-13 09:00:00	SPY	ETF	115.8	116.14	115.62	116.14	9527800.0
2004-02-13 10:00:00	SPY	ETF	116.08	116.2	115.03	115.13	9778100.0
2004-02-13 11:00:00	SPY	ETF	115.12	115.39	115.07	115.1	4568400.0
2004-02-13 12:00:00	SPY	ETF	115.11	115.24	114.75	115.0	5977100.0
2004-02-13 13:00:00	SPY	ETF	115.0	115.12	114.94	115.02	2208000.0
2004-02-13 14:00:00	SPY	ETF	115.04	115.25	114.95	114.96	2959200.0
2004-02-13 15:00:00	SPY	ETF	114.97	115.16	114.89	115.12	3667100.0
2004-02-13 16:00:00	SPY	ETF	115.12	115.14	114.62	114.96	1156600.0
2004-02-13 17:00:00	SPY	ETF	114.91	115.0	114.9	115.0	16400.0
2004-02-13 18:00:00	SPY	ETF	114.98	115.0	114.98	115.0	1000.0
2004-02-13 08:00:00	QQQ	ETF	37.4	37.44	37.37	37.37	164800.0
2004-02-13 09:00:00	QQQ	ETF	37.37	37.558	37.34	37.55	13164600.0
2004-02-13 10:00:00	QQQ	ETF	37.55	37.58	36.92	36.993	26020400.0
2004-02-13 11:00:00	QQQ	ETF	36.993	37.11	36.97	36.98	11236700.0
2004-02-13 12:00:00	QQQ	ETF	36.97	37.0	36.76	36.873	11880600.0
2004-02-13 13:00:00	QQQ	ETF	36.875	36.93	36.86	36.904	4735200.0
2004-02-13 14:00:00	QQQ	ETF	36.904	37.0	36.88	36.892	7050900.0
2004-02-13 15:00:00	QQQ	ETF	36.893	37.02	36.87	36.96	8740000.0
2004-02-13 16:00:00	QQQ	ETF	36.96	36.99	36.91	36.947	2843500.0
2004-02-13 17:00:00	QQQ	ETF	36.94	36.95	36.92	36.94	75500.0
2004-02-13 18:00:00	QQQ	ETF	36.94	36.96	36.94	36.95	20900.0
2004-02-13 19:00:00	QQQ	ETF	36.97	36.99	36.97	36.98	7100.0
2004-02-13 08:00:00	IWM	ETF	59.18	59.185	59.18	59.185	1400.0
2004-02-13 09:00:00	IWM	ETF	59.095	59.25	58.965	59.25	1468600.0
2004-02-13 10:00:00	IWM	ETF	59.25	59.37	58.425	58.525	1655800.0
2004-02-13 11:00:00	IWM	ETF	58.5315	58.625	58.425	58.45	705600.0
2004-02-13 12:00:00	IWM	ETF	58.465	58.57	58.25	58.4	913200.0
2004-02-13 13:00:00	IWM	ETF	58.4	58.475	58.35	58.41	400800.0
2004-02-13 14:00:00	IWM	ETF	58.395	58.515	58.385	58.445	893800.0
2004-02-13 15:00:00	IWM	ETF	58.425	58.45	58.2	58.2	1098400.0
2004-02-13 16:00:00	IWM	ETF	58.275	58.325	58.2	58.325	243600.0
2004-02-13 08:00:00	DIA	ETF	107.48	107.5	107.43	107.43	3700.0
2004-02-13 09:00:00	DIA	ETF	107.38	107.6	107.21	107.6	679500.0
2004-02-13 10:00:00	DIA	ETF	107.6	107.67	106.68	106.77	819100.0
2004-02-13 11:00:00	DIA	ETF	106.78	106.94	106.72	106.75	622300.0
2004-02-13 12:00:00	DIA	ETF	106.72	106.75	106.38	106.64	875900.0
2004-02-13 13:00:00	DIA	ETF	106.61	106.73	106.53	106.58	167500.0
2004-02-13 14:00:00	DIA	ETF	106.56	106.81	106.5	106.51	181900.0
2004-02-13 15:00:00	DIA	ETF	106.55	106.73	106.46	106.66	559700.0
2004-02-13 16:00:00	DIA	ETF	106.66	106.7	106.6	106.667	54700.0
2004-02-13 17:00:00	DIA	ETF	106.64	106.69	106.64	106.69	1600.0
2004-02-13 18:00:00	DIA	ETF	106.61	106.61	106.61	106.61	400.0
2004-02-13 09:00:00	TLT	ETF	87.8	88.07	87.78	87.98	164300.0
2004-02-13 10:00:00	TLT	ETF	87.93	88.02	87.57	87.66	134200.0
2004-02-13 11:00:00	TLT	ETF	87.66	87.75	87.64	87.72	74700.0
2004-02-13 12:00:00	TLT	ETF	87.7	87.8	87.67	87.67	95700.0
2004-02-13 13:00:00	TLT	ETF	87.72	87.74	87.7	87.73	13900.0
2004-02-13 14:00:00	TLT	ETF	87.75	87.75	87.71	87.75	9500.0
2004-02-13 15:00:00	TLT	ETF	87.72	87.84	87.71	87.72	4800.0

> showing 50 of 689 rows — these rows as CSV

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