PREVIEW / etf_1hour / 2005-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-10.parquet
  size:    32 KB
  rows:    980

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
2005-10-10 05:00:00	SPY	ETF	119.88	119.88	119.88	119.88	200.0
2005-10-10 06:00:00	SPY	ETF	119.9	119.9	119.84	119.84	10400.0
2005-10-10 07:00:00	SPY	ETF	119.9	120.0	119.9	119.96	10800.0
2005-10-10 08:00:00	SPY	ETF	119.94	120.01	119.76	119.87	913300.0
2005-10-10 09:00:00	SPY	ETF	119.7	119.88	119.17	119.24	6693400.0
2005-10-10 10:00:00	SPY	ETF	119.24	119.68	118.85	119.17	12402300.0
2005-10-10 11:00:00	SPY	ETF	119.16	119.43	118.96	119.12	5969600.0
2005-10-10 12:00:00	SPY	ETF	119.11	119.65	119.11	119.51	4801100.0
2005-10-10 13:00:00	SPY	ETF	119.51	119.6	119.16	119.18	3367400.0
2005-10-10 14:00:00	SPY	ETF	119.2	119.22	118.61	118.85	8973400.0
2005-10-10 15:00:00	SPY	ETF	118.84	119.68	118.69	118.77	7338500.0
2005-10-10 16:00:00	SPY	ETF	118.75	118.77	118.57	118.61	387600.0
2005-10-10 17:00:00	SPY	ETF	118.62	118.68	118.62	118.68	33400.0
2005-10-10 18:00:00	SPY	ETF	118.66	118.66	118.65	118.66	1000.0
2005-10-10 19:00:00	SPY	ETF	118.65	118.65	118.63	118.63	1800.0
2005-10-10 09:00:00	QQQ	ETF	38.29	38.37	38.19	38.22	9278300.0
2005-10-10 10:00:00	QQQ	ETF	38.23	38.3	38.06	38.26	12749100.0
2005-10-10 11:00:00	QQQ	ETF	38.25	38.36	38.18	38.28	7585700.0
2005-10-10 12:00:00	QQQ	ETF	38.28	38.46	38.27	38.41	6168400.0
2005-10-10 13:00:00	QQQ	ETF	38.4	38.4	38.24	38.28	4313500.0
2005-10-10 14:00:00	QQQ	ETF	38.28	38.29	38.08	38.18	11331100.0
2005-10-10 15:00:00	QQQ	ETF	38.18	38.26	38.11	38.12	7948800.0
2005-10-10 07:00:00	IWM	ETF	64.36	64.36	64.36	64.36	100.0
2005-10-10 08:00:00	IWM	ETF	64.33	64.37	64.33	64.36	22200.0
2005-10-10 09:00:00	IWM	ETF	64.28	64.28	63.67	63.72	2279600.0
2005-10-10 10:00:00	IWM	ETF	63.7	64.21	63.44	63.65	3596200.0
2005-10-10 11:00:00	IWM	ETF	63.65	64.21	63.57	63.69	1912900.0
2005-10-10 12:00:00	IWM	ETF	63.69	64.28	63.66	63.88	914700.0
2005-10-10 13:00:00	IWM	ETF	63.88	63.92	63.72	63.72	1145100.0
2005-10-10 14:00:00	IWM	ETF	63.73	63.75	63.38	63.49	2732300.0
2005-10-10 15:00:00	IWM	ETF	63.49	63.6	63.3	63.42	3263200.0
2005-10-10 16:00:00	IWM	ETF	63.45	63.63	63.32	63.43	172000.0
2005-10-10 18:00:00	IWM	ETF	63.37	63.37	63.21	63.25	1600.0
2005-10-10 19:00:00	IWM	ETF	63.25	63.25	63.25	63.25	400.0
2005-10-10 07:00:00	DIA	ETF	103.34	103.34	103.34	103.34	100.0
2005-10-10 08:00:00	DIA	ETF	103.34	107.0	103.28	103.28	53900.0
2005-10-10 09:00:00	DIA	ETF	103.23	103.23	102.85	102.92	339800.0
2005-10-10 10:00:00	DIA	ETF	102.91	102.97	102.6	102.82	865500.0
2005-10-10 11:00:00	DIA	ETF	102.79	103.0	102.69	102.88	367600.0
2005-10-10 12:00:00	DIA	ETF	102.89	103.24	102.88	103.13	330100.0
2005-10-10 13:00:00	DIA	ETF	103.12	103.14	102.88	102.91	217400.0
2005-10-10 14:00:00	DIA	ETF	102.92	102.94	102.42	102.54	1559300.0
2005-10-10 15:00:00	DIA	ETF	102.57	102.71	102.4	102.41	946700.0
2005-10-10 16:00:00	DIA	ETF	102.41	102.42	102.3	102.33	217300.0
2005-10-10 17:00:00	DIA	ETF	102.3	102.3	102.3	102.3	700.0
2005-10-10 18:00:00	DIA	ETF	102.36	102.36	102.36	102.36	100.0
2005-10-10 19:00:00	DIA	ETF	102.35	102.35	102.35	102.35	200.0
2005-10-10 08:00:00	GLD	ETF	47.5	47.55	47.34	47.34	8000.0
2005-10-10 09:00:00	GLD	ETF	47.34	47.38	47.24	47.25	308500.0
2005-10-10 10:00:00	GLD	ETF	47.23	47.25	47.09	47.1	261500.0

> showing 50 of 980 rows — these rows as CSV

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