PREVIEW / etf_1hour / 2007-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-04.parquet
  size:    84 KB
  rows:    2,777

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-09-04 06:00:00	SPY	ETF	147.64	147.64	147.29	147.29	62600.0
2007-09-04 07:00:00	SPY	ETF	147.31	147.49	147.25	147.39	178200.0
2007-09-04 08:00:00	SPY	ETF	147.42	147.74	147.25	147.41	946800.0
2007-09-04 09:00:00	SPY	ETF	147.44	148.24	147.36	148.18	11309967.0
2007-09-04 10:00:00	SPY	ETF	148.18	148.81	148.09	148.64	27440700.0
2007-09-04 11:00:00	SPY	ETF	148.65	148.91	148.53	148.68	10961000.0
2007-09-04 12:00:00	SPY	ETF	148.68	148.9	148.55	148.72	6866600.0
2007-09-04 13:00:00	SPY	ETF	148.72	149.13	148.63	149.02	12313100.0
2007-09-04 14:00:00	SPY	ETF	149.02	149.47	148.86	149.41	12846104.0
2007-09-04 15:00:00	SPY	ETF	149.4	149.98	149.18	149.23	26082700.0
2007-09-04 16:00:00	SPY	ETF	149.23	149.5856	148.49	148.91	5054400.0
2007-09-04 17:00:00	SPY	ETF	148.9	148.93	147.7239	148.87	2541500.0
2007-09-04 18:00:00	SPY	ETF	148.87	149.08	148.79	148.85	490100.0
2007-09-04 19:00:00	SPY	ETF	148.86	148.9	148.86	148.9	6700.0
2007-09-04 07:00:00	QQQ	ETF	48.84	48.91	48.83	48.91	78786.0
2007-09-04 08:00:00	QQQ	ETF	48.86	48.93	48.82	48.89	519998.0
2007-09-04 09:00:00	QQQ	ETF	48.89	49.32	48.87	49.3014	10797974.0
2007-09-04 10:00:00	QQQ	ETF	49.31	49.52	49.3	49.45	14608679.0
2007-09-04 11:00:00	QQQ	ETF	49.459	49.6	49.44	49.52	6559961.0
2007-09-04 12:00:00	QQQ	ETF	49.514	49.6	49.45	49.52	4889893.0
2007-09-04 13:00:00	QQQ	ETF	49.53	49.73	49.49	49.691	8288024.0
2007-09-04 14:00:00	QQQ	ETF	49.69	49.91	49.64	49.87	9090335.0
2007-09-04 15:00:00	QQQ	ETF	49.87	50.0	49.64	49.74	27751275.0
2007-09-04 16:00:00	QQQ	ETF	49.75	49.759	49.62	49.66	2898838.0
2007-09-04 17:00:00	QQQ	ETF	49.64	49.67	49.62	49.67	25265.0
2007-09-04 18:00:00	QQQ	ETF	49.64	49.67	49.64	49.66	45814.0
2007-09-04 19:00:00	QQQ	ETF	49.67	49.68	49.66	49.67	13880.0
2007-09-04 07:00:00	IWM	ETF	78.7	79.4	78.7	79.4	200.0
2007-09-04 08:00:00	IWM	ETF	78.69	78.75	78.62	78.68	28600.0
2007-09-04 09:00:00	IWM	ETF	78.71	79.16	78.58	79.14	3751600.0
2007-09-04 10:00:00	IWM	ETF	79.14	79.56	79.05	79.4	14034500.0
2007-09-04 11:00:00	IWM	ETF	79.41	79.74	79.35	79.57	3908900.0
2007-09-04 12:00:00	IWM	ETF	79.56	79.64	79.39	79.5	3219900.0
2007-09-04 13:00:00	IWM	ETF	79.5	79.72	79.45	79.65	4496200.0
2007-09-04 14:00:00	IWM	ETF	79.65	80.08	79.54	80.0	6288761.0
2007-09-04 15:00:00	IWM	ETF	80.01	80.32	79.66	79.79	11538800.0
2007-09-04 16:00:00	IWM	ETF	79.79	79.9	79.5	79.5	6167000.0
2007-09-04 17:00:00	IWM	ETF	79.5	79.55	79.48	79.51	40100.0
2007-09-04 18:00:00	IWM	ETF	79.55	79.61	79.55	79.61	16900.0
2007-09-04 19:00:00	IWM	ETF	79.61	79.64	79.6	79.64	3300.0
2007-09-04 07:00:00	DIA	ETF	133.24	133.24	133.2	133.2	3800.0
2007-09-04 08:00:00	DIA	ETF	133.18	133.25	133.08	133.19	11600.0
2007-09-04 09:00:00	DIA	ETF	133.18	133.55	133.11	133.48	1227800.0
2007-09-04 10:00:00	DIA	ETF	133.5	134.02	133.42	133.88	1903400.0
2007-09-04 11:00:00	DIA	ETF	133.9	134.07	133.82	133.85	764800.0
2007-09-04 12:00:00	DIA	ETF	133.86	133.96	133.7	133.84	523900.0
2007-09-04 13:00:00	DIA	ETF	133.86	134.19	133.79	134.07	929100.0
2007-09-04 14:00:00	DIA	ETF	134.1	134.42	134.0	134.42	806700.0
2007-09-04 15:00:00	DIA	ETF	134.42	134.89	134.38	134.46	1576800.0
2007-09-04 16:00:00	DIA	ETF	134.48	134.5	134.28	134.28	161500.0

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

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