PREVIEW / etf_1hour / 2006-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-21.parquet
  size:    46 KB
  rows:    1,418

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-06-21 06:00:00	SPY	ETF	124.01	124.02	124.01	124.02	25000.0
2006-06-21 07:00:00	SPY	ETF	123.84	123.95	123.8	123.91	73200.0
2006-06-21 08:00:00	SPY	ETF	123.88	124.16	123.81	124.03	537300.0
2006-06-21 09:00:00	SPY	ETF	123.99	124.79	123.96	124.58	9901500.0
2006-06-21 10:00:00	SPY	ETF	124.58	125.01	124.58	124.63	12459900.0
2006-06-21 11:00:00	SPY	ETF	124.62	125.41	124.62	125.24	10041100.0
2006-06-21 12:00:00	SPY	ETF	125.22	125.64	125.22	125.46	11286000.0
2006-06-21 13:00:00	SPY	ETF	125.46	125.7	125.33	125.62	7618500.0
2006-06-21 14:00:00	SPY	ETF	125.63	125.7	125.42	125.55	5929900.0
2006-06-21 15:00:00	SPY	ETF	125.5599	125.64	124.96	125.13	13356000.0
2006-06-21 16:00:00	SPY	ETF	125.13	125.2	125.04	125.13	1002700.0
2006-06-21 17:00:00	SPY	ETF	125.14	125.15	125.12	125.14	82800.0
2006-06-21 18:00:00	SPY	ETF	125.14	125.21	125.14	125.21	29400.0
2006-06-21 19:00:00	SPY	ETF	125.13	125.18	125.13	125.18	5700.0
2006-06-21 09:00:00	QQQ	ETF	38.14	38.35	38.13	38.31	10875400.0
2006-06-21 10:00:00	QQQ	ETF	38.31	38.62	38.3	38.51	23580200.0
2006-06-21 11:00:00	QQQ	ETF	38.51	38.79	38.5	38.7	16008700.0
2006-06-21 12:00:00	QQQ	ETF	38.7	38.87	38.7	38.77	13825500.0
2006-06-21 13:00:00	QQQ	ETF	38.77	38.95	38.76	38.91	13917000.0
2006-06-21 14:00:00	QQQ	ETF	38.91	38.99	38.81	38.91	14295400.0
2006-06-21 15:00:00	QQQ	ETF	38.91	38.95	38.63	38.69	28824400.0
2006-06-21 07:00:00	IWM	ETF	67.25	67.25	67.25	67.25	100.0
2006-06-21 08:00:00	IWM	ETF	67.22	67.4	67.2	67.28	174800.0
2006-06-21 09:00:00	IWM	ETF	67.28	68.1	67.23	67.93	14705400.0
2006-06-21 10:00:00	IWM	ETF	67.93	68.23	67.84	67.96	11766100.0
2006-06-21 11:00:00	IWM	ETF	67.96	68.84	67.95	68.68	12553500.0
2006-06-21 12:00:00	IWM	ETF	68.68	68.97	68.66	68.87	11598700.0
2006-06-21 13:00:00	IWM	ETF	68.87	69.02	68.69	68.97	5527800.0
2006-06-21 14:00:00	IWM	ETF	68.97	69.06	68.83	68.91	5935500.0
2006-06-21 15:00:00	IWM	ETF	68.92	68.93	68.6	68.72	13868000.0
2006-06-21 16:00:00	IWM	ETF	68.71	68.78	68.63	68.75	788000.0
2006-06-21 17:00:00	IWM	ETF	68.69	68.69	68.69	68.69	1000.0
2006-06-21 18:00:00	IWM	ETF	68.72	68.75	68.72	68.75	10200.0
2006-06-21 19:00:00	IWM	ETF	68.72	68.72	68.71	68.71	500.0
2006-06-21 07:00:00	DIA	ETF	109.7	109.7	109.68	109.68	500.0
2006-06-21 08:00:00	DIA	ETF	109.72	109.85	109.72	109.81	2700.0
2006-06-21 09:00:00	DIA	ETF	109.75	110.44	109.69	110.29	1108900.0
2006-06-21 10:00:00	DIA	ETF	110.29	110.7	110.28	110.39	1926300.0
2006-06-21 11:00:00	DIA	ETF	110.4	111.03	110.4	110.98	2901000.0
2006-06-21 12:00:00	DIA	ETF	110.97	111.25	110.95	111.02	1183600.0
2006-06-21 13:00:00	DIA	ETF	111.02	111.19	110.94	111.14	497300.0
2006-06-21 14:00:00	DIA	ETF	111.13	111.19	110.962	111.04	485700.0
2006-06-21 15:00:00	DIA	ETF	111.04	111.04	110.65	110.73	882400.0
2006-06-21 16:00:00	DIA	ETF	110.69	110.76	110.66	110.69	96400.0
2006-06-21 17:00:00	DIA	ETF	110.67	110.85	110.67	110.85	1300.0
2006-06-21 18:00:00	DIA	ETF	110.72	110.72	110.72	110.72	40000.0
2006-06-21 07:00:00	GLD	ETF	57.1	57.22	57.1	57.18	3000.0
2006-06-21 08:00:00	GLD	ETF	57.1	57.15	56.75	56.87	87600.0
2006-06-21 09:00:00	GLD	ETF	56.85	57.39	56.62	57.21	736200.0
2006-06-21 10:00:00	GLD	ETF	57.2	57.37	57.05	57.2384	926100.0

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

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