PREVIEW / etf_1hour / 2003-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-06.parquet
  size:    15 KB
  rows:    369

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-03-06 08:00:00	SPY	ETF	83.25	83.25	82.92	82.97	29000.0
2003-03-06 09:00:00	SPY	ETF	82.99	83.09	82.49	82.58	8372800.0
2003-03-06 10:00:00	SPY	ETF	82.59	83.52	82.47	83.0	7740100.0
2003-03-06 11:00:00	SPY	ETF	83.0	83.28	82.7	82.82	3815000.0
2003-03-06 12:00:00	SPY	ETF	82.83	82.85	82.47	82.55	4014600.0
2003-03-06 13:00:00	SPY	ETF	82.54	82.91	82.52	82.72	3035500.0
2003-03-06 14:00:00	SPY	ETF	82.7	83.0	82.48	82.7	3663700.0
2003-03-06 15:00:00	SPY	ETF	82.74	83.09	82.61	82.7	4446700.0
2003-03-06 16:00:00	SPY	ETF	82.74	82.8	82.3	82.54	1299200.0
2003-03-06 17:00:00	SPY	ETF	82.54	82.64	82.5	82.59	227900.0
2003-03-06 18:00:00	SPY	ETF	82.59	82.59	82.5	82.57	44500.0
2003-03-06 19:00:00	SPY	ETF	82.66	82.74	82.6	82.74	45300.0
2003-03-06 08:00:00	QQQ	ETF	24.54	24.6	24.45	24.46	56700.0
2003-03-06 09:00:00	QQQ	ETF	24.48	24.49	24.27	24.38	6984300.0
2003-03-06 10:00:00	QQQ	ETF	24.36	24.68	24.34	24.51	11669200.0
2003-03-06 11:00:00	QQQ	ETF	24.52	24.63	24.44	24.49	5811700.0
2003-03-06 12:00:00	QQQ	ETF	24.49	24.51	24.35	24.42	4422200.0
2003-03-06 13:00:00	QQQ	ETF	24.42	24.54	24.4	24.47	4067900.0
2003-03-06 14:00:00	QQQ	ETF	24.46	24.54	24.36	24.47	5427000.0
2003-03-06 15:00:00	QQQ	ETF	24.46	24.6	24.42	24.46	11342500.0
2003-03-06 16:00:00	QQQ	ETF	24.46	24.62	24.24	24.35	5474300.0
2003-03-06 17:00:00	QQQ	ETF	24.35	24.4	24.3	24.31	711100.0
2003-03-06 18:00:00	QQQ	ETF	24.33	24.4	24.32	24.36	63400.0
2003-03-06 19:00:00	QQQ	ETF	24.33	24.48	24.33	24.48	115000.0
2003-03-06 09:00:00	IWM	ETF	35.25	35.35	35.19	35.19	338000.0
2003-03-06 10:00:00	IWM	ETF	35.22	35.43	35.2	35.245	427600.0
2003-03-06 11:00:00	IWM	ETF	35.25	35.295	35.19	35.205	208400.0
2003-03-06 12:00:00	IWM	ETF	35.2	35.215	35.145	35.145	150600.0
2003-03-06 13:00:00	IWM	ETF	35.16	35.295	35.15	35.265	75600.0
2003-03-06 14:00:00	IWM	ETF	35.245	35.275	35.16	35.205	137400.0
2003-03-06 15:00:00	IWM	ETF	35.19	35.27	35.18	35.215	109800.0
2003-03-06 16:00:00	IWM	ETF	35.185	35.275	35.18	35.255	87000.0
2003-03-06 08:00:00	DIA	ETF	77.55	77.55	77.35	77.35	7600.0
2003-03-06 09:00:00	DIA	ETF	77.38	77.45	76.94	77.04	1084300.0
2003-03-06 10:00:00	DIA	ETF	77.03	77.9	77.0	77.37	1529900.0
2003-03-06 11:00:00	DIA	ETF	77.4	77.55	77.0	77.07	1021200.0
2003-03-06 12:00:00	DIA	ETF	77.03	77.09	76.75	76.85	1022800.0
2003-03-06 13:00:00	DIA	ETF	76.87	77.14	76.8	76.95	727700.0
2003-03-06 14:00:00	DIA	ETF	76.93	77.15	76.73	76.91	858600.0
2003-03-06 15:00:00	DIA	ETF	76.91	77.18	76.77	76.92	1046300.0
2003-03-06 16:00:00	DIA	ETF	76.91	77.0	76.62	76.75	118800.0
2003-03-06 17:00:00	DIA	ETF	76.75	76.8	76.6	76.79	15200.0
2003-03-06 18:00:00	DIA	ETF	76.7	76.72	76.62	76.72	4600.0
2003-03-06 19:00:00	DIA	ETF	76.8	76.8	76.68	76.75	300.0
2003-03-06 09:00:00	TLT	ETF	90.55	90.55	90.15	90.4	10100.0
2003-03-06 10:00:00	TLT	ETF	90.44	90.44	90.06	90.23	30700.0
2003-03-06 11:00:00	TLT	ETF	90.28	90.43	90.25	90.43	9200.0
2003-03-06 12:00:00	TLT	ETF	90.49	90.68	90.49	90.68	16900.0
2003-03-06 13:00:00	TLT	ETF	90.56	90.57	90.4	90.4	400.0
2003-03-06 14:00:00	TLT	ETF	90.39	90.46	90.26	90.26	4800.0

> showing 50 of 369 rows — these rows as CSV

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