PREVIEW / etf_1hour / 2007-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-24.parquet
  size:    87 KB
  rows:    2,903

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-07-24 06:00:00	SPY	ETF	153.97	153.98	153.77	153.82	50900.0
2007-07-24 07:00:00	SPY	ETF	153.89	153.89	153.58	153.71	420700.0
2007-07-24 08:00:00	SPY	ETF	153.7	153.71	153.15	153.19	6660100.0
2007-07-24 09:00:00	SPY	ETF	153.2	153.26	152.67	152.98	25625341.0
2007-07-24 10:00:00	SPY	ETF	152.98	154.28	152.57	153.44	37722978.0
2007-07-24 11:00:00	SPY	ETF	153.43	153.45	152.68	153.05	21334088.0
2007-07-24 12:00:00	SPY	ETF	153.05	153.5	152.69	153.18	19989940.0
2007-07-24 13:00:00	SPY	ETF	153.18	153.37	152.5	152.68	23535373.0
2007-07-24 14:00:00	SPY	ETF	152.68	152.7	152.0	152.02	36912270.0
2007-07-24 15:00:00	SPY	ETF	152.02	152.08	150.76	151.12	65392016.0
2007-07-24 16:00:00	SPY	ETF	151.12	151.55	150.9	151.47	9303600.0
2007-07-24 17:00:00	SPY	ETF	151.47	151.48	151.06	151.28	1572000.0
2007-07-24 18:00:00	SPY	ETF	151.3	151.38	151.29	151.33	54800.0
2007-07-24 19:00:00	SPY	ETF	151.33	151.35	151.26	151.31	47500.0
2007-07-24 04:00:00	QQQ	ETF	50.08	50.08	50.08	50.08	500.0
2007-07-24 06:00:00	QQQ	ETF	49.98	49.98	49.93	49.93	320000.0
2007-07-24 07:00:00	QQQ	ETF	49.9	49.93	49.86	49.9	538824.0
2007-07-24 08:00:00	QQQ	ETF	49.89	49.91	49.75	49.75	1266022.0
2007-07-24 09:00:00	QQQ	ETF	49.75	49.79	49.62	49.74	19728544.0
2007-07-24 10:00:00	QQQ	ETF	49.75	49.96	49.6	49.94	23839460.0
2007-07-24 11:00:00	QQQ	ETF	49.94	49.96	49.75	49.88	13601390.0
2007-07-24 12:00:00	QQQ	ETF	49.88	50.1	49.81	50.0	20147704.0
2007-07-24 13:00:00	QQQ	ETF	50.01	50.05	49.81	49.842	12602596.0
2007-07-24 14:00:00	QQQ	ETF	49.85	49.86	49.49	49.51	23851496.0
2007-07-24 15:00:00	QQQ	ETF	49.51	49.51	49.05	49.22	41150814.0
2007-07-24 16:00:00	QQQ	ETF	49.22	49.49	49.19	49.41	4969509.0
2007-07-24 17:00:00	QQQ	ETF	49.41	49.5	49.4	49.46	592207.0
2007-07-24 18:00:00	QQQ	ETF	49.45	49.51	49.44	49.48	127786.0
2007-07-24 19:00:00	QQQ	ETF	49.49	49.5	49.44	49.45	22395.0
2007-07-24 06:00:00	IWM	ETF	82.8	82.8	82.8	82.8	100.0
2007-07-24 07:00:00	IWM	ETF	82.68	82.73	82.66	82.73	27600.0
2007-07-24 08:00:00	IWM	ETF	82.66	82.66	82.08	82.11	711600.0
2007-07-24 09:00:00	IWM	ETF	82.14	82.99	81.72	82.05	19190822.0
2007-07-24 10:00:00	IWM	ETF	82.07	152.94	81.48	81.88	32194392.0
2007-07-24 11:00:00	IWM	ETF	81.88	81.93	81.54	81.77	15320631.0
2007-07-24 12:00:00	IWM	ETF	81.77	81.96	81.41	81.82	10554682.0
2007-07-24 13:00:00	IWM	ETF	81.83	81.99	81.57	81.62	12200633.0
2007-07-24 14:00:00	IWM	ETF	81.62	81.64	81.09	81.1	14846753.0
2007-07-24 15:00:00	IWM	ETF	81.1	81.12	80.49	80.82	30916958.0
2007-07-24 16:00:00	IWM	ETF	80.82	83.157	80.8	81.07	6229184.0
2007-07-24 17:00:00	IWM	ETF	81.1	81.11	80.76	80.9	2161400.0
2007-07-24 18:00:00	IWM	ETF	80.93	80.95	80.91	80.93	19600.0
2007-07-24 19:00:00	IWM	ETF	80.92	80.92	80.89	80.9	14600.0
2007-07-24 07:00:00	DIA	ETF	139.1	139.1	138.98	139.09	23000.0
2007-07-24 08:00:00	DIA	ETF	138.92	138.99	138.58	138.61	227100.0
2007-07-24 09:00:00	DIA	ETF	138.57	138.57	138.1	138.43	2129500.0
2007-07-24 10:00:00	DIA	ETF	138.42	138.81	138.16	138.73	2671000.0
2007-07-24 11:00:00	DIA	ETF	138.74	138.74	138.22	138.51	2387600.0
2007-07-24 12:00:00	DIA	ETF	138.5	138.82	138.22	138.56	1722300.0
2007-07-24 13:00:00	DIA	ETF	138.55	138.72	138.06	138.2	1653400.0

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

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