PREVIEW / etf_1hour / 2006-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-06.parquet
  size:    48 KB
  rows:    1,509

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-06 04:00:00	SPY	ETF	127.35	127.4	127.35	127.4	400.0
2006-07-06 05:00:00	SPY	ETF	127.39	127.39	127.38	127.38	200.0
2006-07-06 06:00:00	SPY	ETF	127.32	127.34	127.32	127.34	1100.0
2006-07-06 07:00:00	SPY	ETF	127.29	127.3	127.22	127.3	23200.0
2006-07-06 08:00:00	SPY	ETF	127.29	127.44	127.19	127.28	1032500.0
2006-07-06 09:00:00	SPY	ETF	127.28	127.51	127.17	127.37	3559700.0
2006-07-06 10:00:00	SPY	ETF	127.37	127.83	127.33	127.64	10267700.0
2006-07-06 11:00:00	SPY	ETF	127.63	127.85	127.47	127.51	9574100.0
2006-07-06 12:00:00	SPY	ETF	127.5	127.6	127.24	127.37	4772300.0
2006-07-06 13:00:00	SPY	ETF	127.38	127.66	127.35	127.41	5136100.0
2006-07-06 14:00:00	SPY	ETF	127.41	127.47	127.08	127.15	5483500.0
2006-07-06 15:00:00	SPY	ETF	127.15	127.47	127.0875	127.37	7725600.0
2006-07-06 16:00:00	SPY	ETF	127.36	127.7	127.29	127.45	761200.0
2006-07-06 17:00:00	SPY	ETF	127.45	127.49	127.37	127.44	262600.0
2006-07-06 18:00:00	SPY	ETF	127.45	127.45	127.33	127.36	1189400.0
2006-07-06 19:00:00	SPY	ETF	127.34	127.34	127.33	127.33	1000.0
2006-07-06 09:00:00	QQQ	ETF	38.26	38.64	38.2	38.23	6873400.0
2006-07-06 10:00:00	QQQ	ETF	38.23	38.48	38.21	38.32	15276400.0
2006-07-06 11:00:00	QQQ	ETF	38.33	38.42	38.22	38.24	7767400.0
2006-07-06 12:00:00	QQQ	ETF	38.24	38.27	38.11	38.16	7395600.0
2006-07-06 13:00:00	QQQ	ETF	38.17	38.29	38.15	38.18	5486200.0
2006-07-06 14:00:00	QQQ	ETF	38.18	38.19	38.01	38.05	9070500.0
2006-07-06 15:00:00	QQQ	ETF	38.05	38.2	38.03	38.1	12408400.0
2006-07-06 08:00:00	IWM	ETF	71.67	71.9	71.67	71.73	53600.0
2006-07-06 09:00:00	IWM	ETF	71.69	72.15	71.66	71.82	5651300.0
2006-07-06 10:00:00	IWM	ETF	71.81	72.2	71.77	71.88	5724900.0
2006-07-06 11:00:00	IWM	ETF	71.88	72.04	71.8	71.84	2955400.0
2006-07-06 12:00:00	IWM	ETF	71.84	71.88	71.54	71.66	4044600.0
2006-07-06 13:00:00	IWM	ETF	71.67	71.82	71.62	71.65	1579400.0
2006-07-06 14:00:00	IWM	ETF	71.66	71.66	71.2	71.26	6979400.0
2006-07-06 15:00:00	IWM	ETF	71.25	71.64	71.16	71.62	5841400.0
2006-07-06 16:00:00	IWM	ETF	71.63	71.67	71.46	71.55	242300.0
2006-07-06 18:00:00	IWM	ETF	71.6	71.6	71.6	71.6	1800.0
2006-07-06 19:00:00	IWM	ETF	71.61	71.61	71.61	71.61	1000.0
2006-07-06 07:00:00	DIA	ETF	111.7	111.7	111.7	111.7	100.0
2006-07-06 08:00:00	DIA	ETF	111.7	111.83	111.68	111.74	10200.0
2006-07-06 09:00:00	DIA	ETF	111.72	111.99	111.63	111.95	2112500.0
2006-07-06 10:00:00	DIA	ETF	111.96	112.27	111.87	112.2599	2404700.0
2006-07-06 11:00:00	DIA	ETF	112.25	112.56	112.24	112.3	2104400.0
2006-07-06 12:00:00	DIA	ETF	112.29	112.37	112.09	112.23	472300.0
2006-07-06 13:00:00	DIA	ETF	112.25	112.43	112.23	112.26	242300.0
2006-07-06 14:00:00	DIA	ETF	112.24	112.26	112.02	112.11	472700.0
2006-07-06 15:00:00	DIA	ETF	112.08	112.29	112.03	112.22	1035200.0
2006-07-06 16:00:00	DIA	ETF	112.2	112.26	112.16	112.22	30200.0
2006-07-06 17:00:00	DIA	ETF	112.3	112.35	112.3	112.35	900.0
2006-07-06 18:00:00	DIA	ETF	112.25	112.25	112.22	112.22	1000.0
2006-07-06 07:00:00	GLD	ETF	62.12	62.12	62.06	62.06	15400.0
2006-07-06 08:00:00	GLD	ETF	62.16	62.53	62.07	62.43	245500.0
2006-07-06 09:00:00	GLD	ETF	62.43	62.49	62.05	62.26	1091800.0
2006-07-06 10:00:00	GLD	ETF	62.27	62.67	62.24	62.54	1097300.0

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

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