PREVIEW / etf_1hour / 2007-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-28.parquet
  size:    84 KB
  rows:    2,789

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-28 04:00:00	SPY	ETF	146.43	146.43	146.41	146.41	2000.0
2007-08-28 06:00:00	SPY	ETF	146.61	146.61	146.41	146.42	30500.0
2007-08-28 07:00:00	SPY	ETF	146.4	146.45	146.21	146.38	620000.0
2007-08-28 08:00:00	SPY	ETF	146.39	146.4	146.21	146.26	1406800.0
2007-08-28 09:00:00	SPY	ETF	146.22	146.39	145.65	145.79	26537728.0
2007-08-28 10:00:00	SPY	ETF	145.79	145.98	145.29	145.45	32263000.0
2007-08-28 11:00:00	SPY	ETF	145.45	145.6	144.82	145.02	25971000.0
2007-08-28 12:00:00	SPY	ETF	145.03	145.36	144.99	145.25	14670600.0
2007-08-28 13:00:00	SPY	ETF	145.25	145.35	145.02	145.33	8766400.0
2007-08-28 14:00:00	SPY	ETF	145.33	145.4	144.44	144.59	39237100.0
2007-08-28 15:00:00	SPY	ETF	144.59	144.69	143.46	143.66	50050500.0
2007-08-28 16:00:00	SPY	ETF	143.73	145.1	143.65	143.71	8310400.0
2007-08-28 17:00:00	SPY	ETF	143.71	143.73	143.6	143.67	278900.0
2007-08-28 18:00:00	SPY	ETF	143.69	143.87	143.55	143.73	120100.0
2007-08-28 19:00:00	SPY	ETF	143.77	143.78	143.56	143.56	97500.0
2007-08-28 07:00:00	QQQ	ETF	47.65	47.68	47.58	47.66	599186.0
2007-08-28 08:00:00	QQQ	ETF	47.66	47.68	47.61	47.62	892428.0
2007-08-28 09:00:00	QQQ	ETF	47.62	47.7	47.49	47.5285	8490636.0
2007-08-28 10:00:00	QQQ	ETF	47.524	47.61	47.31	47.39	16548516.0
2007-08-28 11:00:00	QQQ	ETF	47.39	47.39	47.16	47.25	12590482.0
2007-08-28 12:00:00	QQQ	ETF	47.2599	47.31	47.23	47.2889	6738630.0
2007-08-28 13:00:00	QQQ	ETF	47.29	47.34	47.19	47.32	6221886.0
2007-08-28 14:00:00	QQQ	ETF	47.31	47.35	47.07	47.11	11910838.0
2007-08-28 15:00:00	QQQ	ETF	47.11	47.15	46.71	46.74	21134602.0
2007-08-28 16:00:00	QQQ	ETF	46.73	47.3501	46.72	46.8	6297453.0
2007-08-28 17:00:00	QQQ	ETF	46.82	46.85	46.79	46.82	103563.0
2007-08-28 18:00:00	QQQ	ETF	46.82	46.85	46.74	46.8	268165.0
2007-08-28 19:00:00	QQQ	ETF	46.81	46.85	46.75	46.76	27957.0
2007-08-28 06:00:00	IWM	ETF	78.35	78.35	78.35	78.35	800.0
2007-08-28 07:00:00	IWM	ETF	78.25	78.29	78.2	78.23	25000.0
2007-08-28 08:00:00	IWM	ETF	78.24	78.33	78.2	78.21	703000.0
2007-08-28 09:00:00	IWM	ETF	78.21	78.24	77.63	77.66	11292281.0
2007-08-28 10:00:00	IWM	ETF	77.67	77.91	77.45	77.53	12170800.0
2007-08-28 11:00:00	IWM	ETF	77.52	77.58	77.12	77.31	7261900.0
2007-08-28 12:00:00	IWM	ETF	77.31	77.55	77.25	77.49	4494200.0
2007-08-28 13:00:00	IWM	ETF	77.5	77.6	77.27	77.45	3685900.0
2007-08-28 14:00:00	IWM	ETF	77.45	77.48	77.01	77.13	8816000.0
2007-08-28 15:00:00	IWM	ETF	77.12	77.18	76.41	76.44	16158900.0
2007-08-28 16:00:00	IWM	ETF	76.44	76.82	76.4	76.65	10241000.0
2007-08-28 17:00:00	IWM	ETF	76.65	76.65	76.55	76.56	47500.0
2007-08-28 18:00:00	IWM	ETF	76.56	76.64	76.55	76.55	5000.0
2007-08-28 19:00:00	IWM	ETF	76.56	76.64	76.55	76.55	2900.0
2007-08-28 07:00:00	DIA	ETF	132.72	132.74	132.6	132.74	5500.0
2007-08-28 08:00:00	DIA	ETF	132.7	132.7	132.58	132.58	33700.0
2007-08-28 09:00:00	DIA	ETF	132.58	132.7	132.26	132.35	1088417.0
2007-08-28 10:00:00	DIA	ETF	132.36	132.61	132.09	132.19	1602300.0
2007-08-28 11:00:00	DIA	ETF	132.19	132.21	131.54	131.71	2531600.0
2007-08-28 12:00:00	DIA	ETF	131.72	131.86	131.64	131.73	552900.0
2007-08-28 13:00:00	DIA	ETF	131.73	131.81	131.56	131.8	493000.0
2007-08-28 14:00:00	DIA	ETF	131.8	131.84	131.26	131.34	2245600.0

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

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