PREVIEW / etf_1hour / 2005-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-06.parquet
  size:    29 KB
  rows:    864

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
2005-04-06 08:00:00	SPY	ETF	118.53	118.55	118.39	118.39	86200.0
2005-04-06 09:00:00	SPY	ETF	118.41	118.58	118.35	118.43	5810300.0
2005-04-06 10:00:00	SPY	ETF	118.43	118.68	118.3	118.63	9091900.0
2005-04-06 11:00:00	SPY	ETF	118.62	118.91	118.36	118.74	8378900.0
2005-04-06 12:00:00	SPY	ETF	118.74	118.95	118.68	118.76	5623800.0
2005-04-06 13:00:00	SPY	ETF	118.78	118.86	118.36	118.52	6800500.0
2005-04-06 14:00:00	SPY	ETF	118.5	118.75	118.45	118.53	4015100.0
2005-04-06 15:00:00	SPY	ETF	118.53	118.6	118.18	118.4	8570300.0
2005-04-06 16:00:00	SPY	ETF	118.38	118.67	118.1364	118.56	3455900.0
2005-04-06 17:00:00	SPY	ETF	118.57	118.57	118.53	118.57	14800.0
2005-04-06 18:00:00	SPY	ETF	118.52	118.56	118.52	118.56	2400.0
2005-04-06 09:00:00	QQQ	ETF	36.68	37.0	36.65	36.7	8592500.0
2005-04-06 10:00:00	QQQ	ETF	36.7	36.81	36.64	36.76	14604800.0
2005-04-06 11:00:00	QQQ	ETF	36.76	36.9	36.73	36.82	14660000.0
2005-04-06 12:00:00	QQQ	ETF	36.81	36.9	36.69	36.72	8165600.0
2005-04-06 13:00:00	QQQ	ETF	36.72	36.77	36.51	36.58	9901500.0
2005-04-06 14:00:00	QQQ	ETF	36.58	36.65	36.56	36.57	8711400.0
2005-04-06 15:00:00	QQQ	ETF	36.57	36.6	36.42	36.5	14632500.0
2005-04-06 08:00:00	IWM	ETF	61.385	61.39	61.365	61.365	10000.0
2005-04-06 09:00:00	IWM	ETF	61.315	61.485	61.26	61.41	1729800.0
2005-04-06 10:00:00	IWM	ETF	61.405	61.655	61.395	61.595	3790600.0
2005-04-06 11:00:00	IWM	ETF	61.595	61.805	61.59	61.675	3908000.0
2005-04-06 12:00:00	IWM	ETF	61.67	61.685	61.515	61.555	2034600.0
2005-04-06 13:00:00	IWM	ETF	61.555	61.59	61.245	61.3	2881800.0
2005-04-06 14:00:00	IWM	ETF	61.295	61.515	61.285	61.385	2037600.0
2005-04-06 15:00:00	IWM	ETF	61.38	61.43	61.175	61.3	2802400.0
2005-04-06 16:00:00	IWM	ETF	61.3	61.355	61.28	61.325	250200.0
2005-04-06 17:00:00	IWM	ETF	61.3	61.3	61.3	61.3	800.0
2005-04-06 08:00:00	DIA	ETF	104.86	104.86	104.76	104.76	7000.0
2005-04-06 09:00:00	DIA	ETF	104.79	104.92	104.78	104.84	627900.0
2005-04-06 10:00:00	DIA	ETF	104.84	105.05	104.77	105.02	627600.0
2005-04-06 11:00:00	DIA	ETF	105.01	105.24	104.99	105.13	1160600.0
2005-04-06 12:00:00	DIA	ETF	105.1	105.23	105.05	105.1	308600.0
2005-04-06 13:00:00	DIA	ETF	105.11	105.2	104.86	104.99	323500.0
2005-04-06 14:00:00	DIA	ETF	104.99	105.13	104.91	104.95	300500.0
2005-04-06 15:00:00	DIA	ETF	104.94	105.0	104.72	104.86	1102000.0
2005-04-06 16:00:00	DIA	ETF	104.85	105.09	104.85	105.08	18700.0
2005-04-06 17:00:00	DIA	ETF	105.03	105.03	105.03	105.03	200.0
2005-04-06 19:00:00	DIA	ETF	105.02	105.02	105.02	105.02	500.0
2005-04-06 09:00:00	GLD	ETF	42.49	42.58	42.49	42.55	47600.0
2005-04-06 10:00:00	GLD	ETF	42.57	42.58	42.49	42.52	661100.0
2005-04-06 11:00:00	GLD	ETF	42.53	42.61	42.52	42.61	652200.0
2005-04-06 12:00:00	GLD	ETF	42.61	42.72	42.56	42.71	117600.0
2005-04-06 13:00:00	GLD	ETF	42.7	42.71	42.65	42.69	80500.0
2005-04-06 14:00:00	GLD	ETF	42.68	42.71	42.63	42.63	40300.0
2005-04-06 15:00:00	GLD	ETF	42.65	42.65	42.6	42.61	38000.0
2005-04-06 09:00:00	TLT	ETF	89.41	89.41	89.3	89.4	45600.0
2005-04-06 10:00:00	TLT	ETF	89.4	89.43	89.34	89.42	74700.0
2005-04-06 11:00:00	TLT	ETF	89.43	89.44	89.22	89.28	53900.0
2005-04-06 12:00:00	TLT	ETF	89.28	89.39	89.26	89.31	21700.0

> showing 50 of 864 rows — these rows as CSV

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