PREVIEW / etf_1hour / 2007-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-02.parquet
  size:    89 KB
  rows:    2,924

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-02 04:00:00	SPY	ETF	146.45	146.45	146.45	146.45	100.0
2007-08-02 05:00:00	SPY	ETF	146.05	146.36	146.05	146.36	12000.0
2007-08-02 06:00:00	SPY	ETF	146.29	146.66	146.21	146.33	43200.0
2007-08-02 07:00:00	SPY	ETF	146.36	146.97	146.36	146.84	1162400.0
2007-08-02 08:00:00	SPY	ETF	146.88	147.33	146.3	147.25	11701900.0
2007-08-02 09:00:00	SPY	ETF	147.23	147.42	146.72	147.26	36110373.0
2007-08-02 10:00:00	SPY	ETF	147.27	147.28	146.49	146.51	42622593.0
2007-08-02 11:00:00	SPY	ETF	146.52	147.26	146.1	147.24	31774827.0
2007-08-02 12:00:00	SPY	ETF	147.24	147.45	146.81	146.83	26167350.0
2007-08-02 13:00:00	SPY	ETF	146.83	147.02	145.26	146.73	35649537.0
2007-08-02 14:00:00	SPY	ETF	146.74	147.185	146.15	146.35	36184227.0
2007-08-02 15:00:00	SPY	ETF	146.36	147.76	146.2	147.28	61201446.0
2007-08-02 16:00:00	SPY	ETF	147.33	147.7	146.2785	146.9199	7651000.0
2007-08-02 17:00:00	SPY	ETF	147.62	147.65	146.26	147.53	285200.0
2007-08-02 18:00:00	SPY	ETF	147.48	147.65	146.6201	147.2415	58900.0
2007-08-02 19:00:00	SPY	ETF	147.64	147.64	147.53	147.59	72600.0
2007-08-02 04:00:00	QQQ	ETF	47.74	47.74	47.74	47.74	5000.0
2007-08-02 06:00:00	QQQ	ETF	47.96	47.97	47.85	47.85	15650.0
2007-08-02 07:00:00	QQQ	ETF	47.84	48.08	47.82	48.05	376091.0
2007-08-02 08:00:00	QQQ	ETF	48.06	48.18	48.03	48.15	2197347.0
2007-08-02 09:00:00	QQQ	ETF	48.15	48.2	47.86	48.08	40245708.0
2007-08-02 10:00:00	QQQ	ETF	48.07	48.09	47.83	47.92	27806103.0
2007-08-02 11:00:00	QQQ	ETF	47.92	48.3	47.79	48.25	23933652.0
2007-08-02 12:00:00	QQQ	ETF	48.26	48.3	48.06	48.07	12479190.0
2007-08-02 13:00:00	QQQ	ETF	48.07	48.19	47.17	48.12	17932593.0
2007-08-02 14:00:00	QQQ	ETF	48.12	48.22	47.97	48.1	13450178.0
2007-08-02 15:00:00	QQQ	ETF	48.1	48.43	48.0	48.28	28999463.0
2007-08-02 16:00:00	QQQ	ETF	48.29	48.41	48.27	48.37	3356535.0
2007-08-02 17:00:00	QQQ	ETF	48.35	48.39	48.32	48.33	83013.0
2007-08-02 18:00:00	QQQ	ETF	48.32	48.39	47.89	48.26	45373.0
2007-08-02 19:00:00	QQQ	ETF	48.39	48.4	48.34	48.38	389401.0
2007-08-02 07:00:00	IWM	ETF	77.67	77.83	77.64	77.76	226900.0
2007-08-02 08:00:00	IWM	ETF	77.76	78.08	77.75	78.08	949800.0
2007-08-02 09:00:00	IWM	ETF	78.03	78.5	77.64	78.06	16602546.0
2007-08-02 10:00:00	IWM	ETF	78.06	78.06	77.42	77.57	12336114.0
2007-08-02 11:00:00	IWM	ETF	77.58	78.06	77.33	78.06	13311648.0
2007-08-02 12:00:00	IWM	ETF	78.05	78.22	77.73	77.78	11197140.0
2007-08-02 13:00:00	IWM	ETF	77.77	77.85	77.45	77.74	7677917.0
2007-08-02 14:00:00	IWM	ETF	77.74	77.9	77.3	77.57	9716956.0
2007-08-02 15:00:00	IWM	ETF	77.58	78.13	77.46	78.02	21882063.0
2007-08-02 16:00:00	IWM	ETF	78.03	78.27	77.6099	78.15	3901200.0
2007-08-02 17:00:00	IWM	ETF	77.92	78.16	77.57	78.13	188000.0
2007-08-02 18:00:00	IWM	ETF	78.14	78.14	77.5404	77.8495	55700.0
2007-08-02 19:00:00	IWM	ETF	78.23	78.23	78.13	78.23	84300.0
2007-08-02 07:00:00	DIA	ETF	133.72	133.72	133.72	133.72	300.0
2007-08-02 08:00:00	DIA	ETF	133.72	133.94	133.65	133.88	108600.0
2007-08-02 09:00:00	DIA	ETF	133.82	134.07	133.51	133.93	2798800.0
2007-08-02 10:00:00	DIA	ETF	133.93	134.06	133.51	133.67	2771600.0
2007-08-02 11:00:00	DIA	ETF	133.68	134.25	132.98	134.24	2817600.0
2007-08-02 12:00:00	DIA	ETF	134.22	135.0	133.94	133.96	1940300.0

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

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