PREVIEW / etf_1hour / 2007-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-23.parquet
  size:    89 KB
  rows:    3,001

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-10-23 04:00:00	SPY	ETF	151.1	151.1	151.1	151.1	100.0
2007-10-23 05:00:00	SPY	ETF	151.03	151.03	151.03	151.03	2000.0
2007-10-23 06:00:00	SPY	ETF	151.15	151.43	151.15	151.4	138700.0
2007-10-23 07:00:00	SPY	ETF	151.37	151.39	150.93	150.98	716600.0
2007-10-23 08:00:00	SPY	ETF	150.97	151.41	150.96	151.37	2691100.0
2007-10-23 09:00:00	SPY	ETF	151.39	151.52	151.15	151.27	17670122.0
2007-10-23 10:00:00	SPY	ETF	151.29	151.61	150.9	150.9	23203400.0
2007-10-23 11:00:00	SPY	ETF	150.9	150.94	150.25	150.78	39425700.0
2007-10-23 12:00:00	SPY	ETF	150.79	150.97	150.55	150.66	11363500.0
2007-10-23 13:00:00	SPY	ETF	150.66	151.13	150.53	150.9	16137200.0
2007-10-23 14:00:00	SPY	ETF	150.91	151.5	150.8	151.08	24831620.0
2007-10-23 15:00:00	SPY	ETF	151.08	151.95	150.86	151.95	30564120.0
2007-10-23 16:00:00	SPY	ETF	151.94	151.95	150.802	151.25	10088800.0
2007-10-23 17:00:00	SPY	ETF	151.25	151.31	149.98	151.31	796700.0
2007-10-23 18:00:00	SPY	ETF	151.25	151.32	151.2	151.27	73200.0
2007-10-23 19:00:00	SPY	ETF	151.28	151.35	151.26	151.3	58200.0
2007-10-23 05:00:00	QQQ	ETF	53.37	53.37	53.37	53.37	2000.0
2007-10-23 06:00:00	QQQ	ETF	53.47	53.51	53.44	53.51	33600.0
2007-10-23 07:00:00	QQQ	ETF	53.49	53.52	53.42	53.45	737753.0
2007-10-23 08:00:00	QQQ	ETF	53.44	53.61	53.44	53.61	3517532.0
2007-10-23 09:00:00	QQQ	ETF	53.6	53.71	53.44	53.53	27958239.0
2007-10-23 10:00:00	QQQ	ETF	53.53	53.75	53.5	53.55	19793671.0
2007-10-23 11:00:00	QQQ	ETF	53.55	53.64	53.34	53.559	20559622.0
2007-10-23 12:00:00	QQQ	ETF	53.56	53.64	53.46	53.5581	6131600.0
2007-10-23 13:00:00	QQQ	ETF	53.55	53.71	53.45	53.63	10604521.0
2007-10-23 14:00:00	QQQ	ETF	53.64	54.07	53.63	53.97	24628502.0
2007-10-23 15:00:00	QQQ	ETF	53.96	54.21	53.92	54.2	28009932.0
2007-10-23 16:00:00	QQQ	ETF	54.2	54.2	53.033	53.75	16862433.0
2007-10-23 17:00:00	QQQ	ETF	53.75	53.755	53.57	53.6	3224111.0
2007-10-23 18:00:00	QQQ	ETF	53.6	53.66	53.6	53.66	263041.0
2007-10-23 19:00:00	QQQ	ETF	53.66	53.68	53.62	53.63	41895.0
2007-10-23 05:00:00	IWM	ETF	81.17	81.17	81.17	81.17	2500.0
2007-10-23 06:00:00	IWM	ETF	81.31	81.41	81.31	81.41	2100.0
2007-10-23 07:00:00	IWM	ETF	81.34	81.4	81.24	81.24	119600.0
2007-10-23 08:00:00	IWM	ETF	81.24	81.37	81.18	81.37	205200.0
2007-10-23 09:00:00	IWM	ETF	81.37	81.5	80.76	81.09	14842422.0
2007-10-23 10:00:00	IWM	ETF	81.09	81.29	80.76	80.84	11892300.0
2007-10-23 11:00:00	IWM	ETF	80.83	80.9	80.19	80.53	13072400.0
2007-10-23 12:00:00	IWM	ETF	80.53	80.74	80.44	80.49	3948800.0
2007-10-23 13:00:00	IWM	ETF	80.5	80.77	80.39	80.57	7226700.0
2007-10-23 14:00:00	IWM	ETF	80.58	81.26	80.54	80.91	12458000.0
2007-10-23 15:00:00	IWM	ETF	80.91	81.54	80.74	81.52	17997500.0
2007-10-23 16:00:00	IWM	ETF	81.52	81.53	80.86	80.94	3259100.0
2007-10-23 17:00:00	IWM	ETF	80.94	80.97	80.81	80.81	100000.0
2007-10-23 18:00:00	IWM	ETF	80.85	80.93	80.85	80.93	500.0
2007-10-23 19:00:00	IWM	ETF	80.87	80.87	80.85	80.85	2300.0
2007-10-23 07:00:00	DIA	ETF	136.0	136.1	135.94	136.03	9700.0
2007-10-23 08:00:00	DIA	ETF	135.95	136.13	135.85	136.13	51900.0
2007-10-23 09:00:00	DIA	ETF	136.15	136.31	136.02	136.22	2203900.0
2007-10-23 10:00:00	DIA	ETF	136.23	136.45	135.86	135.88	1510500.0

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

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