PREVIEW / etf_1hour / 2007-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-02.parquet
  size:    67 KB
  rows:    2,148

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-04-02 04:00:00	SPY	ETF	142.04	142.04	142.04	142.04	2200.0
2007-04-02 06:00:00	SPY	ETF	142.05	142.05	142.03	142.03	12500.0
2007-04-02 07:00:00	SPY	ETF	142.02	142.23	141.96	142.11	336200.0
2007-04-02 08:00:00	SPY	ETF	142.2	142.2	142.0	142.18	1123600.0
2007-04-02 09:00:00	SPY	ETF	142.18	142.34	142.0	142.13	7038500.0
2007-04-02 10:00:00	SPY	ETF	142.14	142.23	140.89	142.06	25521949.0
2007-04-02 11:00:00	SPY	ETF	142.05	142.44	141.95	142.01	8383602.0
2007-04-02 12:00:00	SPY	ETF	142.01	142.17	141.9	141.95	7246100.0
2007-04-02 13:00:00	SPY	ETF	141.95	142.15	141.87	141.95	5217175.0
2007-04-02 14:00:00	SPY	ETF	141.96	142.18	141.76	142.1	8174751.0
2007-04-02 15:00:00	SPY	ETF	142.1	142.46	142.1	142.3	12868503.0
2007-04-02 16:00:00	SPY	ETF	142.3	142.34	142.1655	142.27	1789300.0
2007-04-02 17:00:00	SPY	ETF	142.27	142.28	142.22	142.24	93100.0
2007-04-02 18:00:00	SPY	ETF	142.24	142.28	142.23	142.23	14700.0
2007-04-02 19:00:00	SPY	ETF	142.27	142.28	142.27	142.28	26200.0
2007-04-02 07:00:00	QQQ	ETF	43.64	43.73	43.64	43.68	299050.0
2007-04-02 08:00:00	QQQ	ETF	43.68	43.72	43.54	43.67	525279.0
2007-04-02 09:00:00	QQQ	ETF	43.67	43.76	43.53	43.66	7134262.0
2007-04-02 10:00:00	QQQ	ETF	43.66	43.66	43.32	43.51	34464000.0
2007-04-02 11:00:00	QQQ	ETF	43.51	43.55	43.4	43.45	11098600.0
2007-04-02 12:00:00	QQQ	ETF	43.45	43.48	43.36	43.4	5321900.0
2007-04-02 13:00:00	QQQ	ETF	43.39	43.44	43.35	43.39	7377700.0
2007-04-02 14:00:00	QQQ	ETF	43.38	43.46	43.3	43.44	9590300.0
2007-04-02 15:00:00	QQQ	ETF	43.44	43.6	43.44	43.58	11504200.0
2007-04-02 16:00:00	QQQ	ETF	43.59	43.6	43.54	43.6	2003774.0
2007-04-02 17:00:00	QQQ	ETF	43.59	43.62	43.59	43.6	62100.0
2007-04-02 18:00:00	QQQ	ETF	43.61	43.61	43.6	43.6	7500.0
2007-04-02 19:00:00	QQQ	ETF	43.62	43.62	43.6	43.6	11700.0
2007-04-02 08:00:00	IWM	ETF	79.51	79.77	79.46	79.66	133600.0
2007-04-02 09:00:00	IWM	ETF	79.66	79.71	79.48	79.6	3495600.0
2007-04-02 10:00:00	IWM	ETF	79.6099	79.61	79.21	79.45	6552000.0
2007-04-02 11:00:00	IWM	ETF	79.45	79.55	79.35	79.38	3651300.0
2007-04-02 12:00:00	IWM	ETF	79.39	79.51	79.24	79.29	2851300.0
2007-04-02 13:00:00	IWM	ETF	79.3	79.42	79.15	79.32	3026800.0
2007-04-02 14:00:00	IWM	ETF	79.31	79.45	79.21	79.38	5452900.0
2007-04-02 15:00:00	IWM	ETF	79.38	79.75	79.38	79.75	7161500.0
2007-04-02 16:00:00	IWM	ETF	79.75	79.78	79.62	79.73	3467400.0
2007-04-02 17:00:00	IWM	ETF	79.73	79.73	79.73	79.73	400.0
2007-04-02 18:00:00	IWM	ETF	79.77	79.77	79.67	79.67	6200.0
2007-04-02 07:00:00	DIA	ETF	123.6	123.6	123.6	123.6	5300.0
2007-04-02 08:00:00	DIA	ETF	123.6	123.6	123.55	123.6	15400.0
2007-04-02 09:00:00	DIA	ETF	123.6	123.8	123.54	123.66	815600.0
2007-04-02 10:00:00	DIA	ETF	123.61	123.61	123.11	123.51	1607562.0
2007-04-02 11:00:00	DIA	ETF	123.49	123.68	123.41	123.47	577100.0
2007-04-02 12:00:00	DIA	ETF	123.47	123.53	123.32	123.38	375400.0
2007-04-02 13:00:00	DIA	ETF	123.39	123.77	123.33	123.42	856350.0
2007-04-02 14:00:00	DIA	ETF	123.4	123.64	123.25	123.58	743800.0
2007-04-02 15:00:00	DIA	ETF	123.57	123.82	123.57	123.71	1063150.0
2007-04-02 16:00:00	DIA	ETF	123.71	123.72	123.58	123.72	68000.0
2007-04-02 08:00:00	GLD	ETF	65.67	65.73	65.32	65.366	35000.0

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

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