PREVIEW / etf_1hour / 2005-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-13.parquet
  size:    30 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-05-13 05:00:00	SPY	ETF	116.22	116.22	116.22	116.22	7500.0
2005-05-13 07:00:00	SPY	ETF	116.23	116.42	116.23	116.3	72600.0
2005-05-13 08:00:00	SPY	ETF	116.34	116.38	116.19	116.24	193900.0
2005-05-13 09:00:00	SPY	ETF	116.24	116.32	115.68	115.86	9247500.0
2005-05-13 10:00:00	SPY	ETF	115.86	116.46	115.61	116.45	17261700.0
2005-05-13 11:00:00	SPY	ETF	116.45	116.62	116.24	116.49	10276700.0
2005-05-13 12:00:00	SPY	ETF	116.49	116.6	116.15	116.21	4580700.0
2005-05-13 13:00:00	SPY	ETF	116.21	116.29	115.58	115.73	8231600.0
2005-05-13 14:00:00	SPY	ETF	115.73	115.83	114.8	115.12	15429200.0
2005-05-13 15:00:00	SPY	ETF	115.13	115.9	114.98	115.59	16940700.0
2005-05-13 16:00:00	SPY	ETF	115.65	115.845	115.58	115.74	838600.0
2005-05-13 17:00:00	SPY	ETF	115.75	115.75	115.69	115.69	9000.0
2005-05-13 19:00:00	SPY	ETF	115.7	115.78	115.7	115.7	2200.0
2005-05-13 09:00:00	QQQ	ETF	35.99	36.07	35.89	35.96	14983100.0
2005-05-13 10:00:00	QQQ	ETF	35.96	36.3	35.89	36.3	25023100.0
2005-05-13 11:00:00	QQQ	ETF	36.29	36.45	34.28	36.41	19852300.0
2005-05-13 12:00:00	QQQ	ETF	36.41	36.47	36.3	36.31	10219500.0
2005-05-13 13:00:00	QQQ	ETF	36.31	36.37	36.18	36.23	9337700.0
2005-05-13 14:00:00	QQQ	ETF	36.23	36.28	35.93	36.03	25786600.0
2005-05-13 15:00:00	QQQ	ETF	36.04	36.25	36.0	36.23	20747200.0
2005-05-13 08:00:00	IWM	ETF	58.425	58.47	58.41	58.46	33600.0
2005-05-13 09:00:00	IWM	ETF	58.465	58.6	58.005	58.08	5922800.0
2005-05-13 10:00:00	IWM	ETF	58.11	58.55	57.965	58.545	6844600.0
2005-05-13 11:00:00	IWM	ETF	58.54	58.6	58.37	58.53	4031600.0
2005-05-13 12:00:00	IWM	ETF	58.53	58.605	58.295	58.305	1619800.0
2005-05-13 13:00:00	IWM	ETF	58.305	58.36	57.9	57.975	2847800.0
2005-05-13 14:00:00	IWM	ETF	57.965	58.01	57.445	57.595	5644400.0
2005-05-13 15:00:00	IWM	ETF	57.59	58.07	57.545	58.005	9177400.0
2005-05-13 16:00:00	IWM	ETF	58.01	58.065	57.99	58.065	328200.0
2005-05-13 08:00:00	DIA	ETF	102.22	102.25	102.16	102.16	11000.0
2005-05-13 09:00:00	DIA	ETF	102.18	102.26	101.71	101.9	1402800.0
2005-05-13 10:00:00	DIA	ETF	101.92	102.3	101.7	102.25	2743300.0
2005-05-13 11:00:00	DIA	ETF	102.3	102.47	102.14	102.4	1846000.0
2005-05-13 12:00:00	DIA	ETF	102.43	102.47	102.1	102.2	300100.0
2005-05-13 13:00:00	DIA	ETF	102.19	102.25	101.62	101.74	876900.0
2005-05-13 14:00:00	DIA	ETF	101.73	101.84	100.86	101.06	2189600.0
2005-05-13 15:00:00	DIA	ETF	101.07	101.67	100.97	101.48	1953700.0
2005-05-13 16:00:00	DIA	ETF	101.4915	101.7	101.4915	101.65	8100.0
2005-05-13 17:00:00	DIA	ETF	101.68	101.7	101.68	101.7	1700.0
2005-05-13 08:00:00	GLD	ETF	41.97	42.1	41.97	42.1	4600.0
2005-05-13 09:00:00	GLD	ETF	42.08	42.12	41.9	41.9	189200.0
2005-05-13 10:00:00	GLD	ETF	41.92	42.01	41.9	42.01	179200.0
2005-05-13 11:00:00	GLD	ETF	41.986	42.01	41.89	41.92	82900.0
2005-05-13 12:00:00	GLD	ETF	41.91	41.96	41.83	41.86	87500.0
2005-05-13 13:00:00	GLD	ETF	41.86	41.97	41.86	41.93	48000.0
2005-05-13 14:00:00	GLD	ETF	41.92	41.96	41.92	41.93	95100.0
2005-05-13 15:00:00	GLD	ETF	41.93	41.95	41.89	41.95	114000.0
2005-05-13 08:00:00	TLT	ETF	92.34	92.5	92.34	92.5	6400.0
2005-05-13 09:00:00	TLT	ETF	92.5	92.84	92.5	92.8	70600.0
2005-05-13 10:00:00	TLT	ETF	92.81	93.02	92.74	92.76	938100.0

> showing 50 of 864 rows — these rows as CSV

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