PREVIEW / etf_1hour / 2005-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-02.parquet
  size:    29 KB
  rows:    858

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-05-02 06:00:00	SPY	ETF	116.09	116.09	116.09	116.09	500.0
2005-05-02 07:00:00	SPY	ETF	116.2	116.24	116.12	116.21	89700.0
2005-05-02 08:00:00	SPY	ETF	116.16	116.17	116.02	116.15	79500.0
2005-05-02 09:00:00	SPY	ETF	116.13	116.34	116.0	116.32	5837700.0
2005-05-02 10:00:00	SPY	ETF	116.32	116.41	116.01	116.14	14237200.0
2005-05-02 11:00:00	SPY	ETF	116.14	116.3667	115.82	115.98	4820400.0
2005-05-02 12:00:00	SPY	ETF	115.972	116.1	115.88	115.99	3565200.0
2005-05-02 13:00:00	SPY	ETF	115.98	116.01	115.77	115.86	4687000.0
2005-05-02 14:00:00	SPY	ETF	115.86	116.04	115.52	115.91	10683200.0
2005-05-02 15:00:00	SPY	ETF	115.92	116.38	115.82	116.33	7498000.0
2005-05-02 16:00:00	SPY	ETF	116.38	116.41	115.97	116.35	735600.0
2005-05-02 17:00:00	SPY	ETF	116.31	116.35	116.31	116.31	3000.0
2005-05-02 18:00:00	SPY	ETF	116.32	116.32	116.32	116.32	500.0
2005-05-02 19:00:00	SPY	ETF	116.32	116.33	116.32	116.33	3100.0
2005-05-02 09:00:00	QQQ	ETF	35.1	35.22	35.07	35.2	8433800.0
2005-05-02 10:00:00	QQQ	ETF	35.2	35.25	35.01	35.12	16743500.0
2005-05-02 11:00:00	QQQ	ETF	35.12	35.26	34.9	35.08	6427200.0
2005-05-02 12:00:00	QQQ	ETF	35.07	35.17	35.05	35.12	4806500.0
2005-05-02 13:00:00	QQQ	ETF	35.12	35.12	35.01	35.03	4409100.0
2005-05-02 14:00:00	QQQ	ETF	35.02	35.02	34.89	34.97	10736400.0
2005-05-02 15:00:00	QQQ	ETF	34.97	35.11	34.93	35.1	10535500.0
2005-05-02 07:00:00	IWM	ETF	57.9	57.9	57.9	57.9	9800.0
2005-05-02 08:00:00	IWM	ETF	57.86	57.86	57.8	57.82	1600.0
2005-05-02 09:00:00	IWM	ETF	57.845	58.03	57.7	58.015	3565200.0
2005-05-02 10:00:00	IWM	ETF	58.015	58.225	57.865	58.0	5427200.0
2005-05-02 11:00:00	IWM	ETF	57.975	57.995	57.7	57.895	2494200.0
2005-05-02 12:00:00	IWM	ETF	57.905	57.915	57.765	57.875	899800.0
2005-05-02 13:00:00	IWM	ETF	57.865	57.9	57.65	57.845	2057200.0
2005-05-02 14:00:00	IWM	ETF	57.84	57.935	57.535	57.885	3524400.0
2005-05-02 15:00:00	IWM	ETF	57.885	58.24	57.755	58.205	4323800.0
2005-05-02 16:00:00	IWM	ETF	58.205	58.27	58.175	58.235	1804000.0
2005-05-02 17:00:00	IWM	ETF	58.125	58.125	58.115	58.115	400.0
2005-05-02 07:00:00	DIA	ETF	102.2	102.26	102.2	102.26	1200.0
2005-05-02 08:00:00	DIA	ETF	102.27	102.3	102.22	102.25	2500.0
2005-05-02 09:00:00	DIA	ETF	102.27	102.47	102.19	102.47	916200.0
2005-05-02 10:00:00	DIA	ETF	102.472	102.58	102.29	102.44	1174600.0
2005-05-02 11:00:00	DIA	ETF	102.44	102.49	102.19	102.31	500300.0
2005-05-02 12:00:00	DIA	ETF	102.29	102.42	102.23	102.33	363300.0
2005-05-02 13:00:00	DIA	ETF	102.32	102.36	102.09	102.17	433500.0
2005-05-02 14:00:00	DIA	ETF	102.15	102.3	101.86	102.21	787500.0
2005-05-02 15:00:00	DIA	ETF	102.18	102.58	102.11	102.55	696800.0
2005-05-02 16:00:00	DIA	ETF	102.56	102.62	102.53	102.58	225900.0
2005-05-02 08:00:00	GLD	ETF	43.2	43.2	43.2	43.2	500.0
2005-05-02 09:00:00	GLD	ETF	43.11	43.17	43.09	43.12	102700.0
2005-05-02 10:00:00	GLD	ETF	43.11	43.11	42.81	42.85	1227000.0
2005-05-02 11:00:00	GLD	ETF	42.87	42.94	42.82	42.93	155100.0
2005-05-02 12:00:00	GLD	ETF	42.92	42.92	42.84	42.88	66500.0
2005-05-02 13:00:00	GLD	ETF	42.87	42.91	42.85	42.86	40300.0
2005-05-02 14:00:00	GLD	ETF	42.88	42.95	42.876	42.88	26100.0
2005-05-02 15:00:00	GLD	ETF	42.88	42.92	42.87	42.88	88400.0

> showing 50 of 858 rows — these rows as CSV

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