PREVIEW / etf_1hour / 2007-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-16.parquet
  size:    90 KB
  rows:    3,041

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-16 05:00:00	SPY	ETF	145.5	145.72	145.35	145.72	7000.0
2007-11-16 06:00:00	SPY	ETF	145.7	145.93	145.7	145.76	154100.0
2007-11-16 07:00:00	SPY	ETF	145.69	146.35	145.65	146.22	1239100.0
2007-11-16 08:00:00	SPY	ETF	146.21	146.49	145.68	146.44	5517600.0
2007-11-16 09:00:00	SPY	ETF	146.43	146.43	145.29	145.31	31565790.0
2007-11-16 10:00:00	SPY	ETF	145.31	145.68	144.57	145.02	59721291.0
2007-11-16 11:00:00	SPY	ETF	145.02	146.02	144.97	145.74	32849182.0
2007-11-16 12:00:00	SPY	ETF	145.74	146.47	145.57	145.66	29963417.0
2007-11-16 13:00:00	SPY	ETF	145.66	146.29	145.62	145.79	16764356.0
2007-11-16 14:00:00	SPY	ETF	145.8	145.82	144.62	145.24	56709465.0
2007-11-16 15:00:00	SPY	ETF	145.24	146.17	144.92	146.04	49156467.0
2007-11-16 16:00:00	SPY	ETF	146.02	146.05	144.88	145.78	11820000.0
2007-11-16 17:00:00	SPY	ETF	145.8	145.88	145.44	145.84	3955700.0
2007-11-16 18:00:00	SPY	ETF	145.83	146.03	145.83	145.99	38500.0
2007-11-16 19:00:00	SPY	ETF	145.95	146.02	145.94	146.02	4100.0
2007-11-16 05:00:00	QQQ	ETF	49.75	49.75	49.75	49.75	700.0
2007-11-16 07:00:00	QQQ	ETF	49.8	50.13	49.8	50.06	1423285.0
2007-11-16 08:00:00	QQQ	ETF	50.06	50.36	49.92	50.35	6722479.0
2007-11-16 09:00:00	QQQ	ETF	50.35	50.35	49.5	49.54	56377543.0
2007-11-16 10:00:00	QQQ	ETF	49.53	49.74	49.34	49.6215	44088214.0
2007-11-16 11:00:00	QQQ	ETF	49.61	50.27	49.61	50.13	41920075.0
2007-11-16 12:00:00	QQQ	ETF	50.1301	50.36	49.94	50.0	22635141.0
2007-11-16 13:00:00	QQQ	ETF	50.0	50.25	49.94	50.09	12029162.0
2007-11-16 14:00:00	QQQ	ETF	50.08	50.15	49.76	50.05	25919162.0
2007-11-16 15:00:00	QQQ	ETF	50.05	50.49	49.95	50.34	37699702.0
2007-11-16 16:00:00	QQQ	ETF	50.34	50.5035	49.7774	50.4	14404621.0
2007-11-16 17:00:00	QQQ	ETF	50.41	50.52	50.28	50.44	384370.0
2007-11-16 18:00:00	QQQ	ETF	50.45	50.48	50.42	50.42	8700.0
2007-11-16 19:00:00	QQQ	ETF	50.4	50.47	50.37	50.47	10495.0
2007-11-16 06:00:00	IWM	ETF	77.06	77.06	77.01	77.01	7000.0
2007-11-16 07:00:00	IWM	ETF	76.97	77.36	76.97	77.24	110700.0
2007-11-16 08:00:00	IWM	ETF	77.08	77.56	77.01	77.51	1238700.0
2007-11-16 09:00:00	IWM	ETF	77.45	77.47	76.14	76.15	12864644.0
2007-11-16 10:00:00	IWM	ETF	76.15	76.25	75.54	76.17	26301081.0
2007-11-16 11:00:00	IWM	ETF	76.17	76.78	76.04	76.59	15118247.0
2007-11-16 12:00:00	IWM	ETF	76.57	77.16	76.39	76.48	11438941.0
2007-11-16 13:00:00	IWM	ETF	76.47	76.86	76.35	76.44	8652191.0
2007-11-16 14:00:00	IWM	ETF	76.43	76.51	75.7	76.09	25758153.0
2007-11-16 15:00:00	IWM	ETF	76.1	76.77	75.89	76.49	18164996.0
2007-11-16 16:00:00	IWM	ETF	76.5	76.89	76.0	76.3	4110900.0
2007-11-16 17:00:00	IWM	ETF	76.39	76.41	76.39	76.41	5000.0
2007-11-16 18:00:00	IWM	ETF	76.48	76.48	76.48	76.48	100.0
2007-11-16 19:00:00	IWM	ETF	76.48	76.5	76.48	76.5	1500.0
2007-11-16 07:00:00	DIA	ETF	131.65	131.66	131.64	131.64	900.0
2007-11-16 08:00:00	DIA	ETF	131.68	131.83	131.61	131.83	55700.0
2007-11-16 09:00:00	DIA	ETF	131.7	131.82	131.21	131.22	2852494.0
2007-11-16 10:00:00	DIA	ETF	131.21	131.25	130.55	130.88	4385220.0
2007-11-16 11:00:00	DIA	ETF	130.87	131.52	130.87	131.32	2362465.0
2007-11-16 12:00:00	DIA	ETF	131.33	132.02	131.29	131.44	4820715.0
2007-11-16 13:00:00	DIA	ETF	131.46	131.84	131.27	131.37	1081400.0

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

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