PREVIEW / etf_1hour / 2003-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-04.parquet
  size:    18 KB
  rows:    438

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-06-04 08:00:00	SPY	ETF	97.79	97.8	97.7	97.7	15300.0
2003-06-04 09:00:00	SPY	ETF	97.68	97.9	97.56	97.87	4218000.0
2003-06-04 10:00:00	SPY	ETF	97.82	98.94	97.82	98.82	11804300.0
2003-06-04 11:00:00	SPY	ETF	98.83	98.91	98.46	98.49	3699200.0
2003-06-04 12:00:00	SPY	ETF	98.5	98.87	98.43	98.59	3507700.0
2003-06-04 13:00:00	SPY	ETF	98.6	98.9	98.52	98.77	2199900.0
2003-06-04 14:00:00	SPY	ETF	98.78	98.97	98.57	98.76	3835700.0
2003-06-04 15:00:00	SPY	ETF	98.75	99.35	98.71	99.13	9143300.0
2003-06-04 16:00:00	SPY	ETF	99.14	99.26	99.05	99.09	4845500.0
2003-06-04 17:00:00	SPY	ETF	99.1	99.15	99.05	99.08	211300.0
2003-06-04 18:00:00	SPY	ETF	99.09	99.12	99.05	99.12	47100.0
2003-06-04 19:00:00	SPY	ETF	99.07	99.09	99.03	99.09	4100.0
2003-06-04 08:00:00	QQQ	ETF	29.89	29.89	29.8	29.8	150300.0
2003-06-04 09:00:00	QQQ	ETF	29.8	29.94	29.72	29.89	6176500.0
2003-06-04 10:00:00	QQQ	ETF	29.91	30.36	29.89	30.27	22662100.0
2003-06-04 11:00:00	QQQ	ETF	30.28	30.34	30.06	30.09	10953900.0
2003-06-04 12:00:00	QQQ	ETF	30.09	30.21	30.04	30.09	6267100.0
2003-06-04 13:00:00	QQQ	ETF	30.09	30.27	30.08	30.19	3959000.0
2003-06-04 14:00:00	QQQ	ETF	30.19	30.27	30.1	30.2	6220900.0
2003-06-04 15:00:00	QQQ	ETF	30.21	30.58	30.18	30.42	20710600.0
2003-06-04 16:00:00	QQQ	ETF	30.41	30.45	30.32	30.36	3755200.0
2003-06-04 17:00:00	QQQ	ETF	30.36	30.39	30.34	30.34	189700.0
2003-06-04 18:00:00	QQQ	ETF	30.35	30.37	30.33	30.36	59900.0
2003-06-04 19:00:00	QQQ	ETF	30.37	30.38	30.35	30.35	21700.0
2003-06-04 09:00:00	IWM	ETF	44.375	44.56	44.355	44.56	343000.0
2003-06-04 10:00:00	IWM	ETF	44.56	44.96	44.56	44.91	655600.0
2003-06-04 11:00:00	IWM	ETF	44.89	44.94	44.835	44.845	358000.0
2003-06-04 12:00:00	IWM	ETF	44.83	44.9	44.8	44.875	261800.0
2003-06-04 13:00:00	IWM	ETF	44.86	44.915	44.835	44.91	185600.0
2003-06-04 14:00:00	IWM	ETF	44.92	44.945	44.865	44.905	219800.0
2003-06-04 15:00:00	IWM	ETF	44.915	45.125	44.9	45.075	439000.0
2003-06-04 16:00:00	IWM	ETF	45.09	45.09	44.99	44.99	31800.0
2003-06-04 17:00:00	IWM	ETF	45.015	45.015	45.015	45.015	71000.0
2003-06-04 08:00:00	DIA	ETF	89.58	89.6	89.57	89.6	4700.0
2003-06-04 09:00:00	DIA	ETF	89.51	89.69	89.34	89.69	700700.0
2003-06-04 10:00:00	DIA	ETF	89.67	90.58	89.65	90.47	2840900.0
2003-06-04 11:00:00	DIA	ETF	90.44	90.55	90.16	90.23	794000.0
2003-06-04 12:00:00	DIA	ETF	90.21	90.5	90.16	90.3	487400.0
2003-06-04 13:00:00	DIA	ETF	90.28	90.49	90.17	90.38	525700.0
2003-06-04 14:00:00	DIA	ETF	90.4	90.5	90.2	90.33	866500.0
2003-06-04 15:00:00	DIA	ETF	90.34	90.91	90.27	90.65	1790300.0
2003-06-04 16:00:00	DIA	ETF	90.66	90.89	90.62	90.62	176200.0
2003-06-04 17:00:00	DIA	ETF	90.6	90.7	90.6	90.7	3700.0
2003-06-04 18:00:00	DIA	ETF	90.64	90.65	90.58	90.65	15500.0
2003-06-04 19:00:00	DIA	ETF	90.65	90.75	90.63	90.74	14400.0
2003-06-04 09:00:00	TLT	ETF	94.46	94.46	94.18	94.2	105400.0
2003-06-04 10:00:00	TLT	ETF	94.14	94.33	94.05	94.1	147100.0
2003-06-04 11:00:00	TLT	ETF	94.17	94.31	94.11	94.25	20700.0
2003-06-04 12:00:00	TLT	ETF	94.23	94.3	94.2	94.3	4900.0
2003-06-04 13:00:00	TLT	ETF	94.35	94.35	94.23	94.35	4500.0

> showing 50 of 438 rows — these rows as CSV

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