PREVIEW / etf_1hour / 2005-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-21.parquet
  size:    34 KB
  rows:    1,068

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-11-21 06:00:00	SPY	ETF	125.13	125.13	125.11	125.11	25000.0
2005-11-21 07:00:00	SPY	ETF	125.12	125.24	125.11	125.12	41400.0
2005-11-21 08:00:00	SPY	ETF	125.16	125.25	125.1	125.19	548700.0
2005-11-21 09:00:00	SPY	ETF	125.2	125.23	124.98	125.01	4754600.0
2005-11-21 10:00:00	SPY	ETF	125.01	125.5	125.0	125.45	8866300.0
2005-11-21 11:00:00	SPY	ETF	125.44	125.52	125.13	125.23	6564400.0
2005-11-21 12:00:00	SPY	ETF	125.23	125.35	125.13	125.29	4133300.0
2005-11-21 13:00:00	SPY	ETF	125.29	125.49	125.18	125.4	4433700.0
2005-11-21 14:00:00	SPY	ETF	125.39	125.5	125.32	125.44	6130800.0
2005-11-21 15:00:00	SPY	ETF	125.43	125.91	125.39	125.73	11407700.0
2005-11-21 16:00:00	SPY	ETF	125.76	125.81	125.74	125.75	1171900.0
2005-11-21 17:00:00	SPY	ETF	125.75	125.75	125.73	125.73	17900.0
2005-11-21 18:00:00	SPY	ETF	125.76	125.79	125.76	125.79	700.0
2005-11-21 19:00:00	SPY	ETF	125.79	125.8	125.75	125.76	3400.0
2005-11-21 09:00:00	QQQ	ETF	41.4	41.43	41.24	41.27	8264000.0
2005-11-21 10:00:00	QQQ	ETF	41.27	41.52	41.27	41.48	13525600.0
2005-11-21 11:00:00	QQQ	ETF	41.49	41.5	41.24	41.29	11390400.0
2005-11-21 12:00:00	QQQ	ETF	41.28	41.4	41.28	41.36	5293000.0
2005-11-21 13:00:00	QQQ	ETF	41.36	41.44	41.3	41.41	5045400.0
2005-11-21 14:00:00	QQQ	ETF	41.4	41.45	41.36	41.39	4717400.0
2005-11-21 15:00:00	QQQ	ETF	41.39	41.58	41.38	41.55	12510800.0
2005-11-21 07:00:00	IWM	ETF	66.94	66.94	66.93	66.93	10800.0
2005-11-21 08:00:00	IWM	ETF	66.93	66.97	66.86	66.92	365500.0
2005-11-21 09:00:00	IWM	ETF	66.94	67.07	66.52	66.56	3694400.0
2005-11-21 10:00:00	IWM	ETF	66.56	67.16	66.52	67.14	4881500.0
2005-11-21 11:00:00	IWM	ETF	67.14	67.15	66.84	66.94	1931000.0
2005-11-21 12:00:00	IWM	ETF	66.92	67.19	66.88	67.13	2404600.0
2005-11-21 13:00:00	IWM	ETF	67.13	67.4	67.05	67.33	2161500.0
2005-11-21 14:00:00	IWM	ETF	67.34	67.4	67.2	67.33	3478000.0
2005-11-21 15:00:00	IWM	ETF	67.32	67.69	67.28	67.59	7110400.0
2005-11-21 16:00:00	IWM	ETF	67.59	67.65	67.52	67.54	1789900.0
2005-11-21 17:00:00	IWM	ETF	67.53	67.55	67.53	67.55	5200.0
2005-11-21 07:00:00	DIA	ETF	107.6	107.6	107.6	107.6	700.0
2005-11-21 08:00:00	DIA	ETF	107.64	107.86	107.64	107.85	8300.0
2005-11-21 09:00:00	DIA	ETF	107.83	107.83	107.53	107.55	925500.0
2005-11-21 10:00:00	DIA	ETF	107.6	107.95	107.58	107.88	1076800.0
2005-11-21 11:00:00	DIA	ETF	107.8712	107.95	107.69	107.78	516800.0
2005-11-21 12:00:00	DIA	ETF	107.76	107.87	107.66	107.82	261800.0
2005-11-21 13:00:00	DIA	ETF	107.82	107.91	107.73	107.87	217800.0
2005-11-21 14:00:00	DIA	ETF	107.87	107.95	107.82	107.91	310600.0
2005-11-21 15:00:00	DIA	ETF	107.89	108.3	107.86	108.13	1612600.0
2005-11-21 16:00:00	DIA	ETF	108.12	108.22	108.1	108.1	46500.0
2005-11-21 17:00:00	DIA	ETF	108.25	108.39	108.15	108.15	4500.0
2005-11-21 18:00:00	DIA	ETF	108.15	108.15	108.15	108.15	200.0
2005-11-21 08:00:00	GLD	ETF	48.71	48.79	48.65	48.7	14600.0
2005-11-21 09:00:00	GLD	ETF	48.78	48.78	48.6	48.71	476700.0
2005-11-21 10:00:00	GLD	ETF	48.71	48.75	48.54	48.61	422000.0
2005-11-21 11:00:00	GLD	ETF	48.62	48.75	48.53	48.75	541500.0
2005-11-21 12:00:00	GLD	ETF	48.75	48.75	48.5	48.53	246100.0
2005-11-21 13:00:00	GLD	ETF	48.52	48.77	48.51	48.72	108300.0

> showing 50 of 1,068 rows — these rows as CSV

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