PREVIEW / etf_1hour / 2006-06-19

all etf 1-hour files

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

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-19 04:00:00	SPY	ETF	125.11	125.11	125.05	125.05	800.0
2006-06-19 05:00:00	SPY	ETF	125.11	125.3	125.11	125.3	10800.0
2006-06-19 06:00:00	SPY	ETF	125.2	125.2	125.17	125.17	47100.0
2006-06-19 07:00:00	SPY	ETF	125.17	125.37	125.17	125.32	154400.0
2006-06-19 08:00:00	SPY	ETF	125.31	125.41	125.17	125.39	638200.0
2006-06-19 09:00:00	SPY	ETF	125.37	125.48	124.93	125.06	9421900.0
2006-06-19 10:00:00	SPY	ETF	125.08	125.45	124.39	124.73	14671800.0
2006-06-19 11:00:00	SPY	ETF	124.72	124.89	124.47	124.65	6883200.0
2006-06-19 12:00:00	SPY	ETF	124.65	124.79	124.5	124.5	4020400.0
2006-06-19 13:00:00	SPY	ETF	124.5	124.59	123.67	123.84	26321100.0
2006-06-19 14:00:00	SPY	ETF	123.87	125.0298	123.55	123.57	13935200.0
2006-06-19 15:00:00	SPY	ETF	123.58	124.34	123.56	123.83	15033700.0
2006-06-19 16:00:00	SPY	ETF	123.81	123.89	123.6	123.77	1141400.0
2006-06-19 17:00:00	SPY	ETF	123.77	124.0	123.77	123.83	532700.0
2006-06-19 18:00:00	SPY	ETF	123.83	123.88	123.81	123.85	11100.0
2006-06-19 19:00:00	SPY	ETF	123.8	123.87	123.79	123.87	5800.0
2006-06-19 09:00:00	QQQ	ETF	38.5	38.54	38.34	38.41	9687300.0
2006-06-19 10:00:00	QQQ	ETF	38.41	38.49	38.15	38.35	19520000.0
2006-06-19 11:00:00	QQQ	ETF	38.34	38.47	38.28	38.38	16047100.0
2006-06-19 12:00:00	QQQ	ETF	38.39	38.46	38.35	38.35	5868700.0
2006-06-19 13:00:00	QQQ	ETF	38.35	38.37	38.03	38.13	27159300.0
2006-06-19 14:00:00	QQQ	ETF	38.14	38.19	37.93	37.93	17069400.0
2006-06-19 15:00:00	QQQ	ETF	37.93	38.23	37.91	38.04	25528800.0
2006-06-19 07:00:00	IWM	ETF	69.1	69.1	69.1	69.1	100.0
2006-06-19 08:00:00	IWM	ETF	69.1	69.13	68.85	69.1	2084600.0
2006-06-19 09:00:00	IWM	ETF	69.1	69.18	68.34	68.53	8958300.0
2006-06-19 10:00:00	IWM	ETF	68.52	69.08	67.86	68.2	15645700.0
2006-06-19 11:00:00	IWM	ETF	68.21	68.5076	68.05	68.22	7071100.0
2006-06-19 12:00:00	IWM	ETF	68.22	68.4	67.98	68.2	3688200.0
2006-06-19 13:00:00	IWM	ETF	68.2	68.2	67.5	67.75	9799200.0
2006-06-19 14:00:00	IWM	ETF	67.74	67.99	67.48	67.48	10677700.0
2006-06-19 15:00:00	IWM	ETF	67.48	68.09	67.44	67.65	9751200.0
2006-06-19 16:00:00	IWM	ETF	67.66	67.69	67.5	67.51	472600.0
2006-06-19 17:00:00	IWM	ETF	67.55	67.6	67.51	67.55	10200.0
2006-06-19 18:00:00	IWM	ETF	67.55	67.6	67.55	67.6	7200.0
2006-06-19 05:00:00	DIA	ETF	110.1	110.1	110.1	110.1	100.0
2006-06-19 08:00:00	DIA	ETF	110.37	110.41	110.22	110.28	28200.0
2006-06-19 09:00:00	DIA	ETF	110.3	110.44	110.19	110.28	609400.0
2006-06-19 10:00:00	DIA	ETF	110.26	110.36	109.72	109.97	954600.0
2006-06-19 11:00:00	DIA	ETF	109.96	110.205	109.72	109.85	917000.0
2006-06-19 12:00:00	DIA	ETF	109.847	109.99	109.81	109.82	480000.0
2006-06-19 13:00:00	DIA	ETF	109.79	109.81	109.1218	109.25	1207000.0
2006-06-19 14:00:00	DIA	ETF	109.22	109.43	108.98	108.98	1025800.0
2006-06-19 15:00:00	DIA	ETF	108.98	109.67	108.96	109.33	1614900.0
2006-06-19 16:00:00	DIA	ETF	109.32	109.33	109.08	109.28	46400.0
2006-06-19 17:00:00	DIA	ETF	109.33	109.35	108.85	108.85	400.0
2006-06-19 07:00:00	GLD	ETF	56.76	56.76	56.54	56.56	8900.0
2006-06-19 08:00:00	GLD	ETF	56.56	56.89	56.13	56.68	98400.0
2006-06-19 09:00:00	GLD	ETF	56.71	56.98	56.66	56.75	1079300.0
2006-06-19 10:00:00	GLD	ETF	56.75	57.0	56.62	57.0	791200.0

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

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