PREVIEW / etf_1hour / 2007-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-23.parquet
  size:    65 KB
  rows:    2,076

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
2007-02-23 06:00:00	SPY	ETF	145.77	145.77	145.76	145.76	20000.0
2007-02-23 07:00:00	SPY	ETF	145.73	145.83	145.73	145.83	119000.0
2007-02-23 08:00:00	SPY	ETF	145.78	145.87	145.73	145.85	358800.0
2007-02-23 09:00:00	SPY	ETF	145.81	145.81	145.42	145.43	10464500.0
2007-02-23 10:00:00	SPY	ETF	145.43	145.58	145.03	145.12	21773900.0
2007-02-23 11:00:00	SPY	ETF	145.11	145.45	145.03	145.38	9181300.0
2007-02-23 12:00:00	SPY	ETF	145.38	145.74	145.03	145.21	6947300.0
2007-02-23 13:00:00	SPY	ETF	145.21	145.35	145.1	145.22	6170400.0
2007-02-23 14:00:00	SPY	ETF	145.22	145.55	144.75	145.39	7861200.0
2007-02-23 15:00:00	SPY	ETF	145.4	145.51	145.29	145.36	6948300.0
2007-02-23 16:00:00	SPY	ETF	145.34	145.38	145.24	145.31	728900.0
2007-02-23 17:00:00	SPY	ETF	145.31	145.38	145.3	145.38	21400.0
2007-02-23 18:00:00	SPY	ETF	145.4	145.43	145.4	145.4	900.0
2007-02-23 19:00:00	SPY	ETF	145.41	145.41	145.33	145.35	17500.0
2007-02-23 07:00:00	QQQ	ETF	45.39	45.46	45.39	45.46	154142.0
2007-02-23 08:00:00	QQQ	ETF	45.45	45.47	45.42	45.47	452193.0
2007-02-23 09:00:00	QQQ	ETF	45.46	45.47	45.25	45.26	13081342.0
2007-02-23 10:00:00	QQQ	ETF	45.26	45.39	45.06	45.15	27565800.0
2007-02-23 11:00:00	QQQ	ETF	45.15	45.37	45.12	45.31	19851500.0
2007-02-23 12:00:00	QQQ	ETF	45.3	45.32	45.16	45.26	9620500.0
2007-02-23 13:00:00	QQQ	ETF	45.26	45.32	45.19	45.25	8542000.0
2007-02-23 14:00:00	QQQ	ETF	45.25	45.37	45.22	45.32	10136600.0
2007-02-23 15:00:00	QQQ	ETF	45.33	45.37	45.26	45.26	9859200.0
2007-02-23 16:00:00	QQQ	ETF	45.25	45.31	45.24	45.31	1931180.0
2007-02-23 17:00:00	QQQ	ETF	45.3	45.3	45.26	45.29	43673.0
2007-02-23 18:00:00	QQQ	ETF	45.29	45.3	45.27	45.29	13050.0
2007-02-23 19:00:00	QQQ	ETF	45.29	45.29	45.26	45.27	26900.0
2007-02-23 08:00:00	IWM	ETF	82.33	82.33	82.23	82.29	34700.0
2007-02-23 09:00:00	IWM	ETF	82.28	82.31	81.92	81.93	7984200.0
2007-02-23 10:00:00	IWM	ETF	81.93	82.09	81.66	81.83	9089100.0
2007-02-23 11:00:00	IWM	ETF	81.83	82.17	81.7	82.06	6288100.0
2007-02-23 12:00:00	IWM	ETF	82.06	82.08	81.85	82.01	3485500.0
2007-02-23 13:00:00	IWM	ETF	82.01	82.1	81.92	81.99	2613700.0
2007-02-23 14:00:00	IWM	ETF	81.98	82.19	81.94	82.09	8814800.0
2007-02-23 15:00:00	IWM	ETF	82.09	82.25	82.03	82.04	5689700.0
2007-02-23 16:00:00	IWM	ETF	82.03	82.08	81.91	81.95	265100.0
2007-02-23 08:00:00	DIA	ETF	126.77	126.86	126.77	126.86	1700.0
2007-02-23 09:00:00	DIA	ETF	126.77	126.77	126.44	126.46	586100.0
2007-02-23 10:00:00	DIA	ETF	126.44	126.63	126.31	126.35	1349700.0
2007-02-23 11:00:00	DIA	ETF	126.36	126.58	126.31	126.53	651000.0
2007-02-23 12:00:00	DIA	ETF	126.53	126.67	126.27	126.4	1456800.0
2007-02-23 13:00:00	DIA	ETF	126.4	126.5	126.31	126.4	437300.0
2007-02-23 14:00:00	DIA	ETF	126.39	126.61	126.34	126.53	570200.0
2007-02-23 15:00:00	DIA	ETF	126.54	126.61	126.44	126.5	669700.0
2007-02-23 16:00:00	DIA	ETF	126.48	126.5	126.4	126.4	87900.0
2007-02-23 18:00:00	DIA	ETF	126.45	126.5	126.45	126.5	400.0
2007-02-23 07:00:00	GLD	ETF	67.24	67.25	67.24	67.25	1800.0
2007-02-23 08:00:00	GLD	ETF	67.3	67.6	67.3	67.55	170700.0
2007-02-23 09:00:00	GLD	ETF	67.57	68.0	67.56	67.77	1650000.0
2007-02-23 10:00:00	GLD	ETF	67.76	68.29	67.56	67.9701	2868100.0

> showing 50 of 2,076 rows — these rows as CSV

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