PREVIEW / etf_1hour / 2006-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-19.parquet
  size:    51 KB
  rows:    1,558

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
2006-07-19 06:00:00	SPY	ETF	123.97	124.02	123.97	124.02	2600.0
2006-07-19 07:00:00	SPY	ETF	124.06	124.06	123.9	123.93	311500.0
2006-07-19 08:00:00	SPY	ETF	123.92	124.53	123.79	124.21	13267500.0
2006-07-19 09:00:00	SPY	ETF	124.22	124.75	124.04	124.7	16650900.0
2006-07-19 10:00:00	SPY	ETF	124.7	125.82	124.61	125.64	44281500.0
2006-07-19 11:00:00	SPY	ETF	125.64	125.74	125.44	125.51	11569800.0
2006-07-19 12:00:00	SPY	ETF	125.51	125.7	125.32	125.66	7350200.0
2006-07-19 13:00:00	SPY	ETF	125.64	126.08	125.61	125.8	12235400.0
2006-07-19 14:00:00	SPY	ETF	125.82	126.26	125.75	126.13	8705300.0
2006-07-19 15:00:00	SPY	ETF	126.14	126.24	125.89	125.98	13098400.0
2006-07-19 16:00:00	SPY	ETF	125.97	126.2097	125.55	125.84	1434300.0
2006-07-19 17:00:00	SPY	ETF	125.84	125.88	125.79	125.87	246300.0
2006-07-19 18:00:00	SPY	ETF	125.86	125.94	125.0943	125.88	650900.0
2006-07-19 19:00:00	SPY	ETF	125.84	125.84	125.84	125.84	100.0
2006-07-19 09:00:00	QQQ	ETF	36.1	36.34	36.09	36.3	18511600.0
2006-07-19 10:00:00	QQQ	ETF	36.3	39.5	36.15	36.43	59509500.0
2006-07-19 11:00:00	QQQ	ETF	36.43	36.6	36.4	36.5	16572300.0
2006-07-19 12:00:00	QQQ	ETF	36.49	36.62	36.37	36.61	20101000.0
2006-07-19 13:00:00	QQQ	ETF	36.6	36.78	36.58	36.67	20479600.0
2006-07-19 14:00:00	QQQ	ETF	36.66	36.83	36.61	36.76	12580100.0
2006-07-19 15:00:00	QQQ	ETF	36.77	36.79	36.57	36.59	20476900.0
2006-07-19 07:00:00	IWM	ETF	67.8	67.87	67.8	67.86	2000.0
2006-07-19 08:00:00	IWM	ETF	67.85	68.36	67.55	68.02	2819700.0
2006-07-19 09:00:00	IWM	ETF	68.01	68.71	67.57	68.64	13350200.0
2006-07-19 10:00:00	IWM	ETF	68.66	69.63	68.5	69.38	34459000.0
2006-07-19 11:00:00	IWM	ETF	69.37	69.51	69.15	69.38	7111900.0
2006-07-19 12:00:00	IWM	ETF	69.37	69.42	69.14	69.41	5950800.0
2006-07-19 13:00:00	IWM	ETF	69.42	69.74	69.33	69.6	8272000.0
2006-07-19 14:00:00	IWM	ETF	69.6	70.0	69.55	69.99	8234700.0
2006-07-19 15:00:00	IWM	ETF	69.99	70.0	69.72	69.83	12894900.0
2006-07-19 16:00:00	IWM	ETF	69.81	69.86	69.01	69.68	749200.0
2006-07-19 17:00:00	IWM	ETF	69.71	69.83	69.62	69.83	31100.0
2006-07-19 18:00:00	IWM	ETF	69.7	69.73	69.7	69.72	900.0
2006-07-19 19:00:00	IWM	ETF	69.72	69.72	69.72	69.72	200.0
2006-07-19 08:00:00	DIA	ETF	108.29	108.5	107.9	108.35	69400.0
2006-07-19 09:00:00	DIA	ETF	108.33	108.78	108.1	108.69	1028600.0
2006-07-19 10:00:00	DIA	ETF	108.72	109.73	108.71	109.63	4200200.0
2006-07-19 11:00:00	DIA	ETF	109.61	109.79	109.5	109.58	1187900.0
2006-07-19 12:00:00	DIA	ETF	109.55	109.71	109.4	109.71	734400.0
2006-07-19 13:00:00	DIA	ETF	109.7	110.06	109.69	109.94	1710300.0
2006-07-19 14:00:00	DIA	ETF	109.94	110.44	109.92	110.37	1264200.0
2006-07-19 15:00:00	DIA	ETF	110.38	110.4	110.08	110.13	1192300.0
2006-07-19 16:00:00	DIA	ETF	110.12	110.18	109.98	110.12	52400.0
2006-07-19 17:00:00	DIA	ETF	110.19	110.19	110.19	110.19	1300.0
2006-07-19 18:00:00	DIA	ETF	110.13	110.34	110.13	110.25	600.0
2006-07-19 07:00:00	GLD	ETF	62.12	62.12	62.05	62.1	4300.0
2006-07-19 08:00:00	GLD	ETF	62.22	62.55	61.92	62.38	335100.0
2006-07-19 09:00:00	GLD	ETF	62.32	62.85	62.32	62.66	1313000.0
2006-07-19 10:00:00	GLD	ETF	62.7	64.24	62.69	63.79	2118300.0
2006-07-19 11:00:00	GLD	ETF	63.8	63.8	63.25	63.35	1344700.0

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

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