PREVIEW / etf_1hour / 2005-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-04.parquet
  size:    30 KB
  rows:    839

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-01-04 08:00:00	SPY	ETF	120.53	120.55	120.45	120.5	109600.0
2005-01-04 09:00:00	SPY	ETF	120.5	120.51	120.21	120.21	4585300.0
2005-01-04 10:00:00	SPY	ETF	120.22	120.54	119.87	119.96	10179800.0
2005-01-04 11:00:00	SPY	ETF	119.97	120.1	119.79	119.93	7248000.0
2005-01-04 12:00:00	SPY	ETF	119.93	119.97	119.51	119.55	8174600.0
2005-01-04 13:00:00	SPY	ETF	119.55	119.79	119.51	119.58	4358200.0
2005-01-04 14:00:00	SPY	ETF	119.57	119.57	118.44	118.83	19682500.0
2005-01-04 15:00:00	SPY	ETF	118.84	118.97	118.63	118.74	9698800.0
2005-01-04 16:00:00	SPY	ETF	118.75	118.86	118.7	118.8	3367200.0
2005-01-04 17:00:00	SPY	ETF	118.79	118.8	118.75	118.75	589000.0
2005-01-04 18:00:00	SPY	ETF	118.77	118.86	118.76	118.86	39400.0
2005-01-04 19:00:00	SPY	ETF	118.85	118.85	118.85	118.85	1000.0
2005-01-04 09:00:00	QQQ	ETF	39.69	39.71	39.55	39.56	10457700.0
2005-01-04 10:00:00	QQQ	ETF	39.56	39.74	39.28	39.32	21622600.0
2005-01-04 11:00:00	QQQ	ETF	39.32	39.4	39.25	39.3	13363500.0
2005-01-04 12:00:00	QQQ	ETF	39.3	39.65	39.0	39.04	16945900.0
2005-01-04 13:00:00	QQQ	ETF	39.05	39.1	38.96	38.97	8821400.0
2005-01-04 14:00:00	QQQ	ETF	38.98	39.0	38.55	38.69	34595000.0
2005-01-04 15:00:00	QQQ	ETF	38.69	39.68	38.66	38.79	24624700.0
2005-01-04 09:00:00	IWM	ETF	64.0	64.085	63.86	63.86	1784200.0
2005-01-04 10:00:00	IWM	ETF	63.87	64.03	63.175	63.35	3575800.0
2005-01-04 11:00:00	IWM	ETF	63.355	63.45	63.13	63.32	3275000.0
2005-01-04 12:00:00	IWM	ETF	63.3	63.31	62.895	63.01	3263200.0
2005-01-04 13:00:00	IWM	ETF	63.045	63.15	62.995	63.01	621000.0
2005-01-04 14:00:00	IWM	ETF	62.99	62.99	62.445	62.64	7655200.0
2005-01-04 15:00:00	IWM	ETF	62.64	62.745	62.43	62.575	5356800.0
2005-01-04 16:00:00	IWM	ETF	62.565	62.61	62.51	62.565	302800.0
2005-01-04 17:00:00	IWM	ETF	62.495	62.545	62.495	62.545	36000.0
2005-01-04 08:00:00	DIA	ETF	107.51	107.58	107.51	107.55	11500.0
2005-01-04 09:00:00	DIA	ETF	107.54	107.6	107.26	107.27	1011000.0
2005-01-04 10:00:00	DIA	ETF	107.25	107.59	107.08	107.14	1765600.0
2005-01-04 11:00:00	DIA	ETF	107.13	107.41	107.04	107.24	1203700.0
2005-01-04 12:00:00	DIA	ETF	107.22	107.25	106.89	106.9	761200.0
2005-01-04 13:00:00	DIA	ETF	106.9	107.1	106.87	106.94	578000.0
2005-01-04 14:00:00	DIA	ETF	106.93	106.93	105.89	106.33	3013400.0
2005-01-04 15:00:00	DIA	ETF	106.34	106.45	106.17	106.2	2144600.0
2005-01-04 16:00:00	DIA	ETF	106.2	106.34	106.2	106.33	26600.0
2005-01-04 17:00:00	DIA	ETF	106.3	106.33	106.24	106.24	1900.0
2005-01-04 09:00:00	GLD	ETF	42.8	42.91	42.8	42.91	447700.0
2005-01-04 10:00:00	GLD	ETF	42.9	42.9	42.46	42.55	888800.0
2005-01-04 11:00:00	GLD	ETF	42.57	42.65	42.53	42.61	536900.0
2005-01-04 12:00:00	GLD	ETF	42.61	42.78	42.61	42.76	674200.0
2005-01-04 13:00:00	GLD	ETF	42.76	42.9	42.75	42.77	96700.0
2005-01-04 14:00:00	GLD	ETF	42.75	42.77	42.65	42.69	426400.0
2005-01-04 15:00:00	GLD	ETF	42.68	42.75	42.67	42.72	274800.0
2005-01-04 16:00:00	GLD	ETF	42.7189	42.7189	42.7189	42.7189	80000.0
2005-01-04 08:00:00	TLT	ETF	88.83	88.83	88.83	88.83	10000.0
2005-01-04 09:00:00	TLT	ETF	88.67	88.75	88.59	88.67	98700.0
2005-01-04 10:00:00	TLT	ETF	88.64	88.66	88.4	88.4	258200.0
2005-01-04 11:00:00	TLT	ETF	88.43	88.5	88.38	88.5	64800.0

> showing 50 of 839 rows — these rows as CSV

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