PREVIEW / etf_1hour / 2007-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-02.parquet
  size:    91 KB
  rows:    3,050

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-11-02 04:00:00	SPY	ETF	151.01	151.01	151.01	151.01	100.0
2007-11-02 05:00:00	SPY	ETF	151.06	151.11	151.06	151.11	3500.0
2007-11-02 06:00:00	SPY	ETF	150.82	150.94	150.79	150.81	24900.0
2007-11-02 07:00:00	SPY	ETF	150.8	150.98	150.33	150.87	1605300.0
2007-11-02 08:00:00	SPY	ETF	151.17	152.0	150.42	151.77	20235800.0
2007-11-02 09:00:00	SPY	ETF	151.76	151.95	149.6	150.06	64864190.0
2007-11-02 10:00:00	SPY	ETF	150.05	150.5	149.39	150.25	55311390.0
2007-11-02 11:00:00	SPY	ETF	150.26	150.5	149.21	149.96	40785294.0
2007-11-02 12:00:00	SPY	ETF	149.97	151.14	149.82	150.96	39897258.0
2007-11-02 13:00:00	SPY	ETF	150.96	152.0	150.3	150.56	29033194.0
2007-11-02 14:00:00	SPY	ETF	150.56	150.66	149.68	149.8	24680487.0
2007-11-02 15:00:00	SPY	ETF	149.8	151.13	149.71	151.12	43725116.0
2007-11-02 16:00:00	SPY	ETF	151.07	151.79	149.24	151.22	8221800.0
2007-11-02 17:00:00	SPY	ETF	151.19	151.33	151.12	151.12	135700.0
2007-11-02 18:00:00	SPY	ETF	151.22	151.33	151.22	151.33	5700.0
2007-11-02 19:00:00	SPY	ETF	151.3	151.38	151.28	151.35	4400.0
2007-11-02 04:00:00	QQQ	ETF	54.13	54.13	54.13	54.13	200.0
2007-11-02 05:00:00	QQQ	ETF	54.24	54.24	54.21	54.21	300.0
2007-11-02 07:00:00	QQQ	ETF	54.07	54.13	53.95	54.13	386613.0
2007-11-02 08:00:00	QQQ	ETF	54.0	54.64	54.0	54.54	4997255.0
2007-11-02 09:00:00	QQQ	ETF	54.54	54.63	53.71	53.89	41130916.0
2007-11-02 10:00:00	QQQ	ETF	53.89	54.19	53.6	54.13	40029067.0
2007-11-02 11:00:00	QQQ	ETF	54.1399	54.28	53.71	54.0	24214279.0
2007-11-02 12:00:00	QQQ	ETF	54.01	54.44	53.9299	54.43	27451522.0
2007-11-02 13:00:00	QQQ	ETF	54.43	54.5501	54.23	54.291	25273291.0
2007-11-02 14:00:00	QQQ	ETF	54.29	54.4	54.02	54.07	19331137.0
2007-11-02 15:00:00	QQQ	ETF	54.07	54.45	54.05	54.44	31700054.0
2007-11-02 16:00:00	QQQ	ETF	54.44	54.55	54.1	54.5	3459655.0
2007-11-02 17:00:00	QQQ	ETF	54.5	54.56	54.35	54.48	78311.0
2007-11-02 18:00:00	QQQ	ETF	54.48	54.54	54.48	54.53	2310.0
2007-11-02 19:00:00	QQQ	ETF	54.48	54.53	54.45	54.53	14884.0
2007-11-02 05:00:00	IWM	ETF	79.15	79.15	79.15	79.15	200.0
2007-11-02 07:00:00	IWM	ETF	79.0	79.43	79.0	79.43	40800.0
2007-11-02 08:00:00	IWM	ETF	79.4	80.25	79.32	80.24	4241700.0
2007-11-02 09:00:00	IWM	ETF	80.24	80.37	78.36	78.82	23054386.0
2007-11-02 10:00:00	IWM	ETF	78.81	79.34	78.35	79.22	23553663.0
2007-11-02 11:00:00	IWM	ETF	79.21	79.36	78.53	78.83	16069894.0
2007-11-02 12:00:00	IWM	ETF	78.84	79.77	78.74	79.63	13843461.0
2007-11-02 13:00:00	IWM	ETF	79.62	79.83	79.26	79.49	13971797.0
2007-11-02 14:00:00	IWM	ETF	79.49	79.5	78.7	78.74	10827247.0
2007-11-02 15:00:00	IWM	ETF	78.74	79.54	78.68	79.54	17324254.0
2007-11-02 16:00:00	IWM	ETF	79.53	79.71	79.2	79.47	7785541.0
2007-11-02 17:00:00	IWM	ETF	79.47	79.47	78.82	79.45	66700.0
2007-11-02 19:00:00	IWM	ETF	79.48	79.48	79.48	79.48	500.0
2007-11-02 07:00:00	DIA	ETF	135.35	135.71	135.28	135.7	8700.0
2007-11-02 08:00:00	DIA	ETF	135.74	136.8	135.64	136.29	400600.0
2007-11-02 09:00:00	DIA	ETF	136.35	136.47	134.64	135.02	5033224.0
2007-11-02 10:00:00	DIA	ETF	135.03	135.42	134.43	135.17	3660498.0
2007-11-02 11:00:00	DIA	ETF	135.17	135.49	134.38	134.97	2170500.0
2007-11-02 12:00:00	DIA	ETF	134.98	135.81	134.86	135.71	2407236.0

> showing 50 of 3,050 rows — these rows as CSV

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