PREVIEW / etf_1hour / 2003-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-08.parquet
  size:    16 KB
  rows:    397

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-08 08:00:00	SPY	ETF	98.13	98.41	98.11	98.35	41500.0
2003-08-08 09:00:00	SPY	ETF	98.35	98.547	98.15	98.39	4674100.0
2003-08-08 10:00:00	SPY	ETF	98.41	98.48	98.0	98.16	5203400.0
2003-08-08 11:00:00	SPY	ETF	98.09	98.34	97.76	98.22	3685100.0
2003-08-08 12:00:00	SPY	ETF	98.23	98.3	97.97	98.09	2864300.0
2003-08-08 13:00:00	SPY	ETF	98.099	98.36	98.01	98.09	1715900.0
2003-08-08 14:00:00	SPY	ETF	98.09	98.28	97.89	98.04	2306200.0
2003-08-08 15:00:00	SPY	ETF	98.03	98.28	97.9	98.22	3309700.0
2003-08-08 16:00:00	SPY	ETF	98.27	98.37	98.17	98.28	1332900.0
2003-08-08 17:00:00	SPY	ETF	98.3	98.3	98.2	98.29	35700.0
2003-08-08 18:00:00	SPY	ETF	98.29	98.3	98.29	98.29	900.0
2003-08-08 08:00:00	QQQ	ETF	30.42	30.52	30.38	30.47	89600.0
2003-08-08 09:00:00	QQQ	ETF	30.47	30.55	30.35	30.47	7696500.0
2003-08-08 10:00:00	QQQ	ETF	30.46	30.52	30.17	30.2	8807900.0
2003-08-08 11:00:00	QQQ	ETF	30.2	30.21	29.95	30.128	14297100.0
2003-08-08 12:00:00	QQQ	ETF	30.13	30.16	29.97	30.021	8019300.0
2003-08-08 13:00:00	QQQ	ETF	30.03	30.23	30.01	30.099	5909500.0
2003-08-08 14:00:00	QQQ	ETF	30.09	30.11	29.96	29.996	5715400.0
2003-08-08 15:00:00	QQQ	ETF	29.995	30.1	29.93	30.04	9314900.0
2003-08-08 16:00:00	QQQ	ETF	30.07	30.081	29.98	30.069	2020700.0
2003-08-08 17:00:00	QQQ	ETF	30.04	30.08	30.02	30.07	21900.0
2003-08-08 18:00:00	QQQ	ETF	30.08	30.08	30.06	30.08	13600.0
2003-08-08 19:00:00	QQQ	ETF	30.08	30.09	30.07	30.07	5000.0
2003-08-08 09:00:00	IWM	ETF	45.43	45.475	45.2	45.375	284600.0
2003-08-08 10:00:00	IWM	ETF	45.395	45.425	45.185	45.23	1453200.0
2003-08-08 11:00:00	IWM	ETF	45.205	45.275	45.07	45.265	785800.0
2003-08-08 12:00:00	IWM	ETF	45.275	45.285	45.2	45.2	70400.0
2003-08-08 13:00:00	IWM	ETF	45.2	45.365	45.2	45.33	183000.0
2003-08-08 14:00:00	IWM	ETF	45.325	45.375	45.26	45.335	528600.0
2003-08-08 15:00:00	IWM	ETF	45.345	45.425	45.255	45.255	398800.0
2003-08-08 16:00:00	IWM	ETF	45.325	45.325	45.225	45.25	192600.0
2003-08-08 08:00:00	DIA	ETF	91.65	91.87	91.62	91.87	5400.0
2003-08-08 09:00:00	DIA	ETF	91.88	91.952	91.65	91.85	655400.0
2003-08-08 10:00:00	DIA	ETF	91.85	92.03	91.49	91.71	993600.0
2003-08-08 11:00:00	DIA	ETF	91.71	91.94	91.45	91.86	888100.0
2003-08-08 12:00:00	DIA	ETF	91.84	91.93	91.73	91.87	409300.0
2003-08-08 13:00:00	DIA	ETF	91.86	92.02	91.73	91.83	565900.0
2003-08-08 14:00:00	DIA	ETF	91.81	91.95	91.68	91.79	417600.0
2003-08-08 15:00:00	DIA	ETF	91.77	92.07	91.72	92.03	532500.0
2003-08-08 16:00:00	DIA	ETF	92.02	92.59	92.0	92.19	100800.0
2003-08-08 17:00:00	DIA	ETF	92.19	92.2	92.15	92.19	6700.0
2003-08-08 18:00:00	DIA	ETF	92.19	92.19	92.19	92.19	300.0
2003-08-08 09:00:00	TLT	ETF	84.34	84.5	84.25	84.36	284400.0
2003-08-08 10:00:00	TLT	ETF	84.4	84.69	84.27	84.59	341100.0
2003-08-08 11:00:00	TLT	ETF	84.59	84.79	84.43	84.6	238400.0
2003-08-08 12:00:00	TLT	ETF	84.56	84.78	84.41	84.72	322000.0
2003-08-08 13:00:00	TLT	ETF	84.63	84.63	84.19	84.32	599700.0
2003-08-08 14:00:00	TLT	ETF	84.35	84.35	83.75	83.75	68000.0
2003-08-08 15:00:00	TLT	ETF	83.67	83.86	83.65	83.73	171000.0
2003-08-08 16:00:00	TLT	ETF	83.7	83.72	83.66	83.66	29700.0

> showing 50 of 397 rows — these rows as CSV

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