PREVIEW / etf_1hour / 2007-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-31.parquet
  size:    83 KB
  rows:    2,786

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-08-31 04:00:00	SPY	ETF	147.34	147.34	147.3	147.31	3200.0
2007-08-31 06:00:00	SPY	ETF	147.69	147.91	147.63	147.89	62600.0
2007-08-31 07:00:00	SPY	ETF	147.81	147.98	147.65	147.77	2218300.0
2007-08-31 08:00:00	SPY	ETF	147.77	147.96	146.65	147.93	5466300.0
2007-08-31 09:00:00	SPY	ETF	147.93	147.97	147.45	147.69	20122306.0
2007-08-31 10:00:00	SPY	ETF	147.69	148.07	146.94	147.3	36728600.0
2007-08-31 11:00:00	SPY	ETF	147.3	147.84	146.83	147.723	24706600.0
2007-08-31 12:00:00	SPY	ETF	147.73	148.43	147.57	148.14	25601900.0
2007-08-31 13:00:00	SPY	ETF	148.13	148.2	147.67	147.9	14535300.0
2007-08-31 14:00:00	SPY	ETF	147.89	148.12	147.72	147.79	12269700.0
2007-08-31 15:00:00	SPY	ETF	147.79	148.5	147.45	147.47	28910200.0
2007-08-31 16:00:00	SPY	ETF	147.44	148.2714	147.2	147.72	10060700.0
2007-08-31 17:00:00	SPY	ETF	147.63	147.69	147.56	147.56	100300.0
2007-08-31 18:00:00	SPY	ETF	147.59	147.67	147.45	147.58	21500.0
2007-08-31 19:00:00	SPY	ETF	147.57	147.59	147.51	147.51	1500.0
2007-08-31 04:00:00	QQQ	ETF	48.81	48.81	48.81	48.81	200.0
2007-08-31 05:00:00	QQQ	ETF	48.85	48.85	48.85	48.85	100.0
2007-08-31 06:00:00	QQQ	ETF	48.82	49.0	48.82	48.97	122870.0
2007-08-31 07:00:00	QQQ	ETF	48.98	49.01	48.87	48.9	811634.0
2007-08-31 08:00:00	QQQ	ETF	48.9	48.96	48.8	48.96	2095009.0
2007-08-31 09:00:00	QQQ	ETF	48.95	48.97	48.693	48.81	10684020.0
2007-08-31 10:00:00	QQQ	ETF	48.81	48.9	48.64	48.7	18109260.0
2007-08-31 11:00:00	QQQ	ETF	48.7015	48.86	48.61	48.81	11714000.0
2007-08-31 12:00:00	QQQ	ETF	48.81	48.96	48.76	48.9	8502244.0
2007-08-31 13:00:00	QQQ	ETF	48.8989	48.92	48.78	48.85	5611047.0
2007-08-31 14:00:00	QQQ	ETF	48.851	48.93	48.83	48.863	4829647.0
2007-08-31 15:00:00	QQQ	ETF	48.88	49.06	48.85	48.87	15577481.0
2007-08-31 16:00:00	QQQ	ETF	48.86	49.042	48.8	48.85	3581968.0
2007-08-31 17:00:00	QQQ	ETF	48.86	48.88	48.85	48.85	140900.0
2007-08-31 18:00:00	QQQ	ETF	48.85	48.87	48.83	48.87	15580.0
2007-08-31 19:00:00	QQQ	ETF	48.87	48.87	48.83	48.83	35506.0
2007-08-31 04:00:00	IWM	ETF	78.74	78.74	78.74	78.74	500.0
2007-08-31 06:00:00	IWM	ETF	78.95	79.34	78.95	79.34	2000.0
2007-08-31 07:00:00	IWM	ETF	79.34	79.4	79.19	79.29	251900.0
2007-08-31 08:00:00	IWM	ETF	79.21	79.34	78.9	79.34	1236100.0
2007-08-31 09:00:00	IWM	ETF	79.34	79.36	78.68	78.87	6285500.0
2007-08-31 10:00:00	IWM	ETF	78.87	79.14	78.34	78.55	9869700.0
2007-08-31 11:00:00	IWM	ETF	78.55	78.83	78.31	78.75	5094300.0
2007-08-31 12:00:00	IWM	ETF	78.75	79.05	78.63	78.89	4081100.0
2007-08-31 13:00:00	IWM	ETF	78.9	78.98	78.74	78.85	2262000.0
2007-08-31 14:00:00	IWM	ETF	78.84	79.06	78.8	78.87	2808800.0
2007-08-31 15:00:00	IWM	ETF	78.86	79.33	78.81	78.84	8367000.0
2007-08-31 16:00:00	IWM	ETF	78.84	79.0	78.74	78.84	1537400.0
2007-08-31 17:00:00	IWM	ETF	78.79	78.79	78.79	78.79	2000.0
2007-08-31 18:00:00	IWM	ETF	78.72	78.72	78.7	78.7	3400.0
2007-08-31 19:00:00	IWM	ETF	78.7	78.71	78.7	78.71	3600.0
2007-08-31 07:00:00	DIA	ETF	133.62	133.74	133.52	133.7	5300.0
2007-08-31 08:00:00	DIA	ETF	133.58	133.67	133.47	133.63	84100.0
2007-08-31 09:00:00	DIA	ETF	133.69	133.71	133.38	133.52	1508500.0
2007-08-31 10:00:00	DIA	ETF	133.52	133.77	132.9	133.29	2382000.0

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

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