PREVIEW / etf_1hour / 2006-06-14

all etf 1-hour files

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

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-14 05:00:00	SPY	ETF	123.09	123.09	123.09	123.09	100.0
2006-06-14 06:00:00	SPY	ETF	123.14	123.22	123.12	123.19	316200.0
2006-06-14 07:00:00	SPY	ETF	123.17	123.38	123.17	123.34	1557400.0
2006-06-14 08:00:00	SPY	ETF	123.33	123.45	122.3	122.8	24275800.0
2006-06-14 09:00:00	SPY	ETF	122.78	123.54	122.5	123.46	25901400.0
2006-06-14 10:00:00	SPY	ETF	123.42	123.63	122.94	123.01	22459500.0
2006-06-14 11:00:00	SPY	ETF	123.03	123.31	122.8	123.05	15627100.0
2006-06-14 12:00:00	SPY	ETF	123.05	123.47	122.94	123.17	7238200.0
2006-06-14 13:00:00	SPY	ETF	123.17	123.18	122.39	122.84	16557200.0
2006-06-14 14:00:00	SPY	ETF	122.86	123.22	122.34	122.7	19533900.0
2006-06-14 15:00:00	SPY	ETF	122.7	123.5	122.57	123.49	21422500.0
2006-06-14 16:00:00	SPY	ETF	123.49	123.6	123.33	123.6	2559300.0
2006-06-14 17:00:00	SPY	ETF	123.62	123.75	123.59	123.7	723300.0
2006-06-14 18:00:00	SPY	ETF	123.7	123.76	123.69	123.73	85400.0
2006-06-14 19:00:00	SPY	ETF	123.73	123.81	123.65	123.66	15700.0
2006-06-14 09:00:00	QQQ	ETF	37.36	37.63	37.33	37.56	30113500.0
2006-06-14 10:00:00	QQQ	ETF	37.56	37.66	37.41	37.45	24497200.0
2006-06-14 11:00:00	QQQ	ETF	37.44	37.61	37.35	37.49	25260400.0
2006-06-14 12:00:00	QQQ	ETF	37.5	37.6	37.43	37.5	9402400.0
2006-06-14 13:00:00	QQQ	ETF	37.51	37.51	37.22	37.44	22066500.0
2006-06-14 14:00:00	QQQ	ETF	37.43	37.57	37.2	37.33	36298700.0
2006-06-14 15:00:00	QQQ	ETF	37.33	37.71	37.31	37.64	26281200.0
2006-06-14 07:00:00	IWM	ETF	66.71	66.91	66.7	66.91	2600.0
2006-06-14 08:00:00	IWM	ETF	66.95	67.42	66.48	66.89	6585800.0
2006-06-14 09:00:00	IWM	ETF	66.79	67.57	66.6	67.46	17610600.0
2006-06-14 10:00:00	IWM	ETF	67.47	67.68	67.0	67.12	19052100.0
2006-06-14 11:00:00	IWM	ETF	67.12	67.55	66.91	67.35	14378200.0
2006-06-14 12:00:00	IWM	ETF	67.36	67.52	67.22	67.33	3156400.0
2006-06-14 13:00:00	IWM	ETF	67.34	67.35	66.55	67.15	16002800.0
2006-06-14 14:00:00	IWM	ETF	67.15	67.35	66.592	66.86	10386100.0
2006-06-14 15:00:00	IWM	ETF	66.86	67.56	66.71	67.37	16060800.0
2006-06-14 16:00:00	IWM	ETF	67.36	67.49	67.3	67.49	1559400.0
2006-06-14 17:00:00	IWM	ETF	67.5	67.63	67.5	67.59	62100.0
2006-06-14 18:00:00	IWM	ETF	67.58	67.61	67.58	67.61	32200.0
2006-06-14 07:00:00	DIA	ETF	107.42	107.54	107.42	107.54	1000.0
2006-06-14 08:00:00	DIA	ETF	107.6	107.6	106.66	107.08	123600.0
2006-06-14 09:00:00	DIA	ETF	107.04	107.95	106.95	107.86	1655100.0
2006-06-14 10:00:00	DIA	ETF	107.8625	108.02	107.59	107.68	1792500.0
2006-06-14 11:00:00	DIA	ETF	107.69	107.87	107.48	107.72	1558700.0
2006-06-14 12:00:00	DIA	ETF	107.72	107.96	107.62	107.84	691500.0
2006-06-14 13:00:00	DIA	ETF	107.84	107.85	107.32	107.64	1224800.0
2006-06-14 14:00:00	DIA	ETF	107.64	107.92	107.31	107.6	1100700.0
2006-06-14 15:00:00	DIA	ETF	107.6	108.27	107.53	108.24	1859100.0
2006-06-14 16:00:00	DIA	ETF	108.24	108.41	108.17	108.41	27200.0
2006-06-14 17:00:00	DIA	ETF	108.45	108.67	108.45	108.67	1700.0
2006-06-14 18:00:00	DIA	ETF	108.62	108.65	108.61	108.65	900.0
2006-06-14 04:00:00	GLD	ETF	56.1	56.1	56.1	56.1	1000.0
2006-06-14 07:00:00	GLD	ETF	56.25	56.29	56.19	56.25	16000.0
2006-06-14 08:00:00	GLD	ETF	56.3	56.69	55.93	56.15	574800.0
2006-06-14 09:00:00	GLD	ETF	56.16	56.91	55.86	56.71	2897300.0

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

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