PREVIEW / etf_1hour / 2007-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-04.parquet
  size:    76 KB
  rows:    2,609

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-06-04 05:00:00	SPY	ETF	153.78	153.78	153.75	153.76	4000.0
2007-06-04 06:00:00	SPY	ETF	153.68	153.79	153.67	153.67	12500.0
2007-06-04 07:00:00	SPY	ETF	153.63	153.74	153.63	153.74	343900.0
2007-06-04 08:00:00	SPY	ETF	153.64	153.75	153.47	153.54	2147300.0
2007-06-04 09:00:00	SPY	ETF	153.56	153.94	153.47	153.78	11197881.0
2007-06-04 10:00:00	SPY	ETF	153.79	153.99	153.62	153.79	13291614.0
2007-06-04 11:00:00	SPY	ETF	153.79	154.02	153.64	153.93	8801066.0
2007-06-04 12:00:00	SPY	ETF	153.93	154.13	153.86	154.05	6942300.0
2007-06-04 13:00:00	SPY	ETF	154.04	154.05	153.84	153.94	5085973.0
2007-06-04 14:00:00	SPY	ETF	153.94	154.09	153.8	153.97	8804712.0
2007-06-04 15:00:00	SPY	ETF	153.97	154.39	153.96	154.24	14899616.0
2007-06-04 16:00:00	SPY	ETF	154.23	154.3254	154.06	154.09	4347200.0
2007-06-04 17:00:00	SPY	ETF	154.05	154.08	154.02	154.04	133600.0
2007-06-04 18:00:00	SPY	ETF	154.03	154.05	153.99	154.05	22100.0
2007-06-04 19:00:00	SPY	ETF	154.01	154.08	154.01	154.08	18400.0
2007-06-04 07:00:00	QQQ	ETF	47.35	47.38	47.32	47.36	131915.0
2007-06-04 08:00:00	QQQ	ETF	47.33	47.35	47.21	47.27	1047453.0
2007-06-04 09:00:00	QQQ	ETF	47.27	47.47	47.24	47.395	11559377.0
2007-06-04 10:00:00	QQQ	ETF	47.4	47.56	47.32	47.417	16290922.0
2007-06-04 11:00:00	QQQ	ETF	47.41	47.5	47.389	47.4615	4817457.0
2007-06-04 12:00:00	QQQ	ETF	47.47	47.55	47.42	47.49	6305387.0
2007-06-04 13:00:00	QQQ	ETF	47.49	47.51	47.39	47.44	4745596.0
2007-06-04 14:00:00	QQQ	ETF	47.44	47.5	47.41	47.48	6640135.0
2007-06-04 15:00:00	QQQ	ETF	47.48	47.64	47.48	47.58	9846682.0
2007-06-04 16:00:00	QQQ	ETF	47.57	47.62	47.54	47.55	2517938.0
2007-06-04 17:00:00	QQQ	ETF	47.55	47.55	47.53	47.54	724886.0
2007-06-04 18:00:00	QQQ	ETF	47.53	47.54	47.53	47.54	4760.0
2007-06-04 19:00:00	QQQ	ETF	47.53	47.53	47.51	47.52	9600.0
2007-06-04 07:00:00	IWM	ETF	83.7	84.6	83.7	84.6	11500.0
2007-06-04 08:00:00	IWM	ETF	84.57	84.57	84.43	84.47	53000.0
2007-06-04 09:00:00	IWM	ETF	84.47	84.9	84.44	84.73	5225400.0
2007-06-04 10:00:00	IWM	ETF	84.73	84.97	84.34	84.51	10583484.0
2007-06-04 11:00:00	IWM	ETF	84.51	84.82	84.5	84.75	7547200.0
2007-06-04 12:00:00	IWM	ETF	84.75	84.83	84.63	84.74	3471300.0
2007-06-04 13:00:00	IWM	ETF	84.74	84.81	84.62	84.65	4642700.0
2007-06-04 14:00:00	IWM	ETF	84.64	84.86	84.6	84.77	4564822.0
2007-06-04 15:00:00	IWM	ETF	84.77	84.97	84.77	84.88	5658300.0
2007-06-04 16:00:00	IWM	ETF	84.88	84.9	84.73	84.77	1731800.0
2007-06-04 17:00:00	IWM	ETF	84.76	84.81	84.76	84.81	104700.0
2007-06-04 07:00:00	DIA	ETF	136.38	136.43	136.38	136.38	7500.0
2007-06-04 08:00:00	DIA	ETF	136.41	136.43	136.24	136.31	27500.0
2007-06-04 09:00:00	DIA	ETF	136.31	136.44	136.13	136.33	1115300.0
2007-06-04 10:00:00	DIA	ETF	136.34	136.45	136.17	136.3	1310300.0
2007-06-04 11:00:00	DIA	ETF	136.3	136.47	136.26	136.35	605900.0
2007-06-04 12:00:00	DIA	ETF	136.35	136.57	136.33	136.53	752100.0
2007-06-04 13:00:00	DIA	ETF	136.52	136.52	136.34	136.43	465400.0
2007-06-04 14:00:00	DIA	ETF	136.42	136.55	136.28	136.41	852801.0
2007-06-04 15:00:00	DIA	ETF	136.41	136.81	136.41	136.63	2197200.0
2007-06-04 16:00:00	DIA	ETF	136.62	136.63	136.5	136.52	62300.0
2007-06-04 17:00:00	DIA	ETF	136.52	136.52	136.5	136.51	20000.0

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

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