PREVIEW / etf_1hour / 2007-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-24.parquet
  size:    70 KB
  rows:    2,231

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-24 06:00:00	SPY	ETF	148.05	148.2	148.04	148.2	29900.0
2007-04-24 07:00:00	SPY	ETF	148.17	148.38	148.17	148.36	190200.0
2007-04-24 08:00:00	SPY	ETF	148.18	148.4	148.02	148.17	996500.0
2007-04-24 09:00:00	SPY	ETF	148.17	148.35	147.85	148.04	9153334.0
2007-04-24 10:00:00	SPY	ETF	148.03	148.04	147.32	147.51	32548764.0
2007-04-24 11:00:00	SPY	ETF	147.51	147.89	147.43	147.82	14626527.0
2007-04-24 12:00:00	SPY	ETF	147.82	148.24	147.76	147.98	13766867.0
2007-04-24 13:00:00	SPY	ETF	147.98	148.11	147.74	148.07	12285575.0
2007-04-24 14:00:00	SPY	ETF	148.07	148.4	148.01	148.13	13315988.0
2007-04-24 15:00:00	SPY	ETF	148.13	148.24	147.92	148.04	11742442.0
2007-04-24 16:00:00	SPY	ETF	148.06	148.21	147.83	148.15	4525700.0
2007-04-24 17:00:00	SPY	ETF	148.17	148.18	148.1	148.16	467400.0
2007-04-24 18:00:00	SPY	ETF	148.19	148.29	148.19	148.25	3000.0
2007-04-24 19:00:00	SPY	ETF	148.24	148.27	148.23	148.27	1100.0
2007-04-24 04:00:00	QQQ	ETF	45.5	45.5	45.5	45.5	50000.0
2007-04-24 06:00:00	QQQ	ETF	45.58	45.58	45.58	45.58	30200.0
2007-04-24 07:00:00	QQQ	ETF	45.57	45.67	45.57	45.67	305790.0
2007-04-24 08:00:00	QQQ	ETF	45.68	45.7	45.61	45.63	255115.0
2007-04-24 09:00:00	QQQ	ETF	45.63	45.68	45.52	45.58	13229715.0
2007-04-24 10:00:00	QQQ	ETF	45.58	45.58	45.33	45.43	26378100.0
2007-04-24 11:00:00	QQQ	ETF	45.43	45.59	45.41	45.54	11637300.0
2007-04-24 12:00:00	QQQ	ETF	45.55	45.81	45.53	45.73	17862400.0
2007-04-24 13:00:00	QQQ	ETF	45.73	45.78	45.59	45.75	10824600.0
2007-04-24 14:00:00	QQQ	ETF	45.76	45.83	45.49	45.73	12380600.0
2007-04-24 15:00:00	QQQ	ETF	45.74	45.78	45.64	45.7	12845600.0
2007-04-24 16:00:00	QQQ	ETF	45.69	45.73	45.66	45.68	2190042.0
2007-04-24 17:00:00	QQQ	ETF	45.7	45.71	45.7	45.71	65168.0
2007-04-24 18:00:00	QQQ	ETF	45.71	45.74	45.7	45.72	42850.0
2007-04-24 19:00:00	QQQ	ETF	45.74	45.75	45.72	45.72	4659.0
2007-04-24 08:00:00	IWM	ETF	82.4	82.4	82.23	82.24	52900.0
2007-04-24 09:00:00	IWM	ETF	82.24	82.35	81.85	82.02	5551285.0
2007-04-24 10:00:00	IWM	ETF	82.02	82.03	81.37	81.52	19761552.0
2007-04-24 11:00:00	IWM	ETF	81.52	81.78	81.5	81.72	5851014.0
2007-04-24 12:00:00	IWM	ETF	81.72	82.11	81.7	81.96	8652514.0
2007-04-24 13:00:00	IWM	ETF	81.95	82.09	81.74	82.08	4604939.0
2007-04-24 14:00:00	IWM	ETF	82.09	82.21	81.99	82.06	3704028.0
2007-04-24 15:00:00	IWM	ETF	82.06	82.14	81.85	82.04	7110664.0
2007-04-24 16:00:00	IWM	ETF	82.05	82.48	81.9039	82.29	388000.0
2007-04-24 17:00:00	IWM	ETF	82.2	82.2	82.15	82.15	100000.0
2007-04-24 19:00:00	IWM	ETF	82.2	82.2	82.2	82.2	200.0
2007-04-24 07:00:00	DIA	ETF	129.35	129.35	129.32	129.32	600.0
2007-04-24 08:00:00	DIA	ETF	129.35	129.35	129.18	129.18	65200.0
2007-04-24 09:00:00	DIA	ETF	129.2	129.4	129.16	129.33	888800.0
2007-04-24 10:00:00	DIA	ETF	129.33	129.33	128.9	129.03	3083200.0
2007-04-24 11:00:00	DIA	ETF	129.05	129.33	129.01	129.28	569900.0
2007-04-24 12:00:00	DIA	ETF	129.28	129.59	129.25	129.41	1146835.0
2007-04-24 13:00:00	DIA	ETF	129.41	129.5	129.23	129.5	656500.0
2007-04-24 14:00:00	DIA	ETF	129.5	129.77	129.46	129.58	1547199.0
2007-04-24 15:00:00	DIA	ETF	129.58	129.71	129.35	129.4	2143668.0
2007-04-24 16:00:00	DIA	ETF	129.43	129.5	129.43	129.45	42400.0

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

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