PREVIEW / etf_1hour / 2004-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-17.parquet
  size:    27 KB
  rows:    778

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
2004-12-17 08:00:00	SPY	ETF	120.18	120.24	119.97	120.03	381100.0
2004-12-17 09:00:00	SPY	ETF	120.01	120.03	119.28	119.72	8286800.0
2004-12-17 10:00:00	SPY	ETF	119.71	119.97	119.47	119.73	8227700.0
2004-12-17 11:00:00	SPY	ETF	119.73	119.77	119.24	119.32	8298800.0
2004-12-17 12:00:00	SPY	ETF	119.32	119.52	119.18	119.37	5825900.0
2004-12-17 13:00:00	SPY	ETF	119.34	119.52	119.16	119.35	4519000.0
2004-12-17 14:00:00	SPY	ETF	119.36	119.71	119.25	119.63	5200800.0
2004-12-17 15:00:00	SPY	ETF	119.65	119.68	119.39	119.42	8969500.0
2004-12-17 16:00:00	SPY	ETF	119.42	119.75	119.35	119.7	5003600.0
2004-12-17 17:00:00	SPY	ETF	119.7	119.75	119.5	119.54	149600.0
2004-12-17 18:00:00	SPY	ETF	119.53	119.57	119.38	119.38	69900.0
2004-12-17 19:00:00	SPY	ETF	119.43	119.43	119.4	119.4	600.0
2004-12-17 08:00:00	QQQ	ETF	39.72	39.77	39.645	39.66	1650031.0
2004-12-17 09:00:00	QQQ	ETF	39.66	39.81	39.541	39.72	15716758.0
2004-12-17 10:00:00	QQQ	ETF	39.72	39.743	39.57	39.711	13583227.0
2004-12-17 11:00:00	QQQ	ETF	39.71	39.72	39.48	39.521	13996100.0
2004-12-17 12:00:00	QQQ	ETF	39.52	39.592	39.47	39.53	8734274.0
2004-12-17 13:00:00	QQQ	ETF	39.54	39.561	39.45	39.492	8530340.0
2004-12-17 14:00:00	QQQ	ETF	39.49	39.62	39.45	39.582	8152019.0
2004-12-17 15:00:00	QQQ	ETF	39.582	39.6	39.46	39.473	13534662.0
2004-12-17 16:00:00	QQQ	ETF	39.48	39.57	39.431	39.513	4261741.0
2004-12-17 17:00:00	QQQ	ETF	39.54	39.6	39.42	39.42	716063.0
2004-12-17 18:00:00	QQQ	ETF	39.42	39.43	39.31	39.33	173280.0
2004-12-17 08:00:00	IWM	ETF	64.225	64.495	64.21	64.27	73400.0
2004-12-17 09:00:00	IWM	ETF	64.22	64.25	63.89	64.105	3753600.0
2004-12-17 10:00:00	IWM	ETF	64.1	64.15	63.92	64.09	3045400.0
2004-12-17 11:00:00	IWM	ETF	64.085	64.09	63.83	63.93	1849600.0
2004-12-17 12:00:00	IWM	ETF	63.935	63.935	63.82	63.85	1040400.0
2004-12-17 13:00:00	IWM	ETF	63.85	63.9	63.675	63.775	986200.0
2004-12-17 14:00:00	IWM	ETF	63.77	64.17	63.72	64.12	2389000.0
2004-12-17 15:00:00	IWM	ETF	64.12	64.185	63.9	63.905	3564200.0
2004-12-17 16:00:00	IWM	ETF	63.905	64.025	63.87	63.94	1497000.0
2004-12-17 17:00:00	IWM	ETF	63.94	64.0	63.935	63.935	3800.0
2004-12-17 08:00:00	DIA	ETF	106.87	106.95	106.82	106.82	88400.0
2004-12-17 09:00:00	DIA	ETF	106.82	106.86	106.19	106.78	1315100.0
2004-12-17 10:00:00	DIA	ETF	106.76	106.98	106.52	106.81	1694100.0
2004-12-17 11:00:00	DIA	ETF	106.79	106.81	106.3	106.38	1428100.0
2004-12-17 12:00:00	DIA	ETF	106.37	106.55	106.22	106.43	604300.0
2004-12-17 13:00:00	DIA	ETF	106.44	106.57	106.27	106.41	599000.0
2004-12-17 14:00:00	DIA	ETF	106.41	106.67	106.33	106.62	715100.0
2004-12-17 15:00:00	DIA	ETF	106.61	106.64	106.41	106.44	998800.0
2004-12-17 16:00:00	DIA	ETF	106.45	106.65	106.41	106.58	440900.0
2004-12-17 17:00:00	DIA	ETF	106.6	106.6	106.49	106.51	38000.0
2004-12-17 18:00:00	DIA	ETF	106.51	106.51	106.48	106.5	3500.0
2004-12-17 19:00:00	DIA	ETF	106.53	106.53	106.53	106.53	1600.0
2004-12-17 09:00:00	GLD	ETF	43.93	43.93	43.78	43.87	115300.0
2004-12-17 10:00:00	GLD	ETF	43.87	43.97	43.8	43.81	269500.0
2004-12-17 11:00:00	GLD	ETF	43.81	43.95	43.78	43.93	603700.0
2004-12-17 12:00:00	GLD	ETF	43.95	44.22	43.93	44.19	307200.0
2004-12-17 13:00:00	GLD	ETF	44.18	44.2	44.07	44.07	254500.0

> showing 50 of 778 rows — these rows as CSV

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