PREVIEW / etf_1hour / 2003-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-06.parquet
  size:    17 KB
  rows:    405

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-08-06 08:00:00	SPY	ETF	96.75	96.78	96.67	96.74	25400.0
2003-08-06 09:00:00	SPY	ETF	96.76	97.07	96.5	97.04	5658500.0
2003-08-06 10:00:00	SPY	ETF	97.04	97.13	96.423	96.85	8345300.0
2003-08-06 11:00:00	SPY	ETF	96.84	97.16	96.62	97.14	3052300.0
2003-08-06 12:00:00	SPY	ETF	97.15	97.49	97.11	97.28	4884500.0
2003-08-06 13:00:00	SPY	ETF	97.3	97.76	97.27	97.6	5065100.0
2003-08-06 14:00:00	SPY	ETF	97.61	98.06	97.439	97.72	6040100.0
2003-08-06 15:00:00	SPY	ETF	97.71	97.73	97.07	97.13	7398800.0
2003-08-06 16:00:00	SPY	ETF	97.1	97.21	96.98	97.05	1739800.0
2003-08-06 17:00:00	SPY	ETF	97.17	97.17	96.87	96.9	651000.0
2003-08-06 18:00:00	SPY	ETF	97.0	97.04	96.97	96.98	2800.0
2003-08-06 19:00:00	SPY	ETF	96.98	97.0	96.95	97.0	1500.0
2003-08-06 08:00:00	QQQ	ETF	30.33	30.38	30.31	30.36	136000.0
2003-08-06 09:00:00	QQQ	ETF	30.36	30.46	30.24	30.4	11560300.0
2003-08-06 10:00:00	QQQ	ETF	30.43	30.48	30.1	30.28	19232700.0
2003-08-06 11:00:00	QQQ	ETF	30.27	30.38	30.19	30.35	9022100.0
2003-08-06 12:00:00	QQQ	ETF	30.35	30.57	30.349	30.45	14819900.0
2003-08-06 13:00:00	QQQ	ETF	30.48	30.75	30.47	30.62	9393600.0
2003-08-06 14:00:00	QQQ	ETF	30.62	30.77	30.53	30.56	8522200.0
2003-08-06 15:00:00	QQQ	ETF	30.57	30.58	30.21	30.22	12295100.0
2003-08-06 16:00:00	QQQ	ETF	30.21	30.395	30.162	30.205	3603300.0
2003-08-06 17:00:00	QQQ	ETF	30.215	30.215	30.16	30.2	142800.0
2003-08-06 18:00:00	QQQ	ETF	30.19	30.21	30.17	30.17	37300.0
2003-08-06 19:00:00	QQQ	ETF	30.18	30.2	30.16	30.16	10000.0
2003-08-06 09:00:00	IWM	ETF	45.485	45.575	45.35	45.465	1092800.0
2003-08-06 10:00:00	IWM	ETF	45.48	45.49	45.13	45.17	510200.0
2003-08-06 11:00:00	IWM	ETF	45.155	45.23	45.075	45.17	452800.0
2003-08-06 12:00:00	IWM	ETF	45.175	45.395	45.175	45.325	569400.0
2003-08-06 13:00:00	IWM	ETF	45.32	45.555	45.32	45.505	485400.0
2003-08-06 14:00:00	IWM	ETF	45.515	45.73	45.51	45.67	538400.0
2003-08-06 15:00:00	IWM	ETF	45.645	45.645	45.265	45.265	418000.0
2003-08-06 16:00:00	IWM	ETF	45.235	45.25	45.14	45.225	98200.0
2003-08-06 08:00:00	DIA	ETF	90.37	90.43	90.37	90.43	4600.0
2003-08-06 09:00:00	DIA	ETF	90.44	90.63	90.15	90.608	945900.0
2003-08-06 10:00:00	DIA	ETF	90.61	90.721	90.1	90.53	1576700.0
2003-08-06 11:00:00	DIA	ETF	90.48	90.9	90.37	90.88	985200.0
2003-08-06 12:00:00	DIA	ETF	90.896	91.12	90.71	90.86	1403300.0
2003-08-06 13:00:00	DIA	ETF	90.85	91.29	90.85	91.12	879700.0
2003-08-06 14:00:00	DIA	ETF	91.13	91.5	90.98	91.24	763100.0
2003-08-06 15:00:00	DIA	ETF	91.23	91.23	90.68	90.742	1383400.0
2003-08-06 16:00:00	DIA	ETF	90.75	90.77	90.66	90.73	103800.0
2003-08-06 17:00:00	DIA	ETF	90.69	90.69	90.61	90.61	4000.0
2003-08-06 18:00:00	DIA	ETF	90.74	90.74	90.74	90.74	100.0
2003-08-06 19:00:00	DIA	ETF	90.65	90.65	90.65	90.65	100.0
2003-08-06 09:00:00	TLT	ETF	82.5	82.68	82.37	82.63	181200.0
2003-08-06 10:00:00	TLT	ETF	82.63	82.95	82.55	82.95	481100.0
2003-08-06 11:00:00	TLT	ETF	82.97	83.12	82.81	83.1	375900.0
2003-08-06 12:00:00	TLT	ETF	83.08	83.207	82.93	82.95	289800.0
2003-08-06 13:00:00	TLT	ETF	82.97	83.5	82.89	83.4	508300.0
2003-08-06 14:00:00	TLT	ETF	83.36	83.55	83.31	83.54	179700.0

> showing 50 of 405 rows — these rows as CSV

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