PREVIEW / etf_1hour / 2007-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-31.parquet
  size:    90 KB
  rows:    3,024

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-31 04:00:00	SPY	ETF	153.28	153.28	153.28	153.28	100.0
2007-10-31 05:00:00	SPY	ETF	153.46	153.46	153.46	153.46	7000.0
2007-10-31 06:00:00	SPY	ETF	153.61	153.61	153.51	153.53	30000.0
2007-10-31 07:00:00	SPY	ETF	153.53	153.76	153.53	153.6	1055500.0
2007-10-31 08:00:00	SPY	ETF	153.62	153.89	153.3	153.88	3097700.0
2007-10-31 09:00:00	SPY	ETF	153.86	153.99	153.5199	153.68	15228605.0
2007-10-31 10:00:00	SPY	ETF	153.67	154.11	153.63	153.93	16559475.0
2007-10-31 11:00:00	SPY	ETF	153.93	154.18	153.89	154.15	7305975.0
2007-10-31 12:00:00	SPY	ETF	154.16	154.32	154.11	154.16	15818601.0
2007-10-31 13:00:00	SPY	ETF	154.16	154.3	154.0	154.18	11794981.0
2007-10-31 14:00:00	SPY	ETF	154.19	155.27	152.84	154.94	92494862.0
2007-10-31 15:00:00	SPY	ETF	154.95	155.25	153.94	154.8	43550850.0
2007-10-31 16:00:00	SPY	ETF	154.83	154.87	153.15	154.87	5902900.0
2007-10-31 17:00:00	SPY	ETF	154.85	154.87	153.93	154.75	743600.0
2007-10-31 18:00:00	SPY	ETF	154.8	154.82	154.65	154.68	9700.0
2007-10-31 19:00:00	SPY	ETF	154.67	154.79	154.67	154.76	23500.0
2007-10-31 04:00:00	QQQ	ETF	54.31	54.31	54.29	54.29	200.0
2007-10-31 07:00:00	QQQ	ETF	54.41	54.42	54.38	54.39	29600.0
2007-10-31 08:00:00	QQQ	ETF	54.4	54.47	54.34	54.46	1068159.0
2007-10-31 09:00:00	QQQ	ETF	54.46	54.5	54.2995	54.45	10899421.0
2007-10-31 10:00:00	QQQ	ETF	54.45	54.53	54.38	54.478	9244656.0
2007-10-31 11:00:00	QQQ	ETF	54.48	54.58	54.44	54.58	6455024.0
2007-10-31 12:00:00	QQQ	ETF	54.5702	54.66	54.48	54.5	8319422.0
2007-10-31 13:00:00	QQQ	ETF	54.49	54.57	54.2669	54.508	13174327.0
2007-10-31 14:00:00	QQQ	ETF	54.5	55.07	54.04	54.96	60480992.0
2007-10-31 15:00:00	QQQ	ETF	54.95	55.02	54.67	55.02	32868778.0
2007-10-31 16:00:00	QQQ	ETF	55.01	55.07	54.16	55.05	9520048.0
2007-10-31 17:00:00	QQQ	ETF	55.06	55.06	55.0	55.05	327570.0
2007-10-31 18:00:00	QQQ	ETF	55.05	55.08	55.01	55.04	62185.0
2007-10-31 19:00:00	QQQ	ETF	55.05	55.05	55.03	55.05	11450.0
2007-10-31 06:00:00	IWM	ETF	81.53	81.54	81.53	81.54	20000.0
2007-10-31 07:00:00	IWM	ETF	81.61	81.63	81.54	81.6	161300.0
2007-10-31 08:00:00	IWM	ETF	81.56	81.68	81.5	81.59	1395000.0
2007-10-31 09:00:00	IWM	ETF	81.61	81.66	81.26	81.38	5537256.0
2007-10-31 10:00:00	IWM	ETF	81.39	81.64	81.33	81.56	5797035.0
2007-10-31 11:00:00	IWM	ETF	81.55	81.76	81.53	81.76	3473600.0
2007-10-31 12:00:00	IWM	ETF	81.76	82.16	81.76	81.99	10735256.0
2007-10-31 13:00:00	IWM	ETF	82.0	82.35	81.84	82.04	11056979.0
2007-10-31 14:00:00	IWM	ETF	82.05	82.8	80.77	81.83	44865930.0
2007-10-31 15:00:00	IWM	ETF	82.72	82.72	81.77	82.42	22389482.0
2007-10-31 16:00:00	IWM	ETF	82.42	82.52	81.35	82.38	3210400.0
2007-10-31 17:00:00	IWM	ETF	82.38	82.43	82.38	82.4	3200.0
2007-10-31 18:00:00	IWM	ETF	82.4	82.45	82.4	82.43	7100.0
2007-10-31 19:00:00	IWM	ETF	82.47	82.47	82.47	82.47	1600.0
2007-10-31 07:00:00	DIA	ETF	138.28	138.31	138.24	138.24	2200.0
2007-10-31 08:00:00	DIA	ETF	138.25	138.44	138.18	138.42	159200.0
2007-10-31 09:00:00	DIA	ETF	138.4	138.48	137.99	138.11	1997611.0
2007-10-31 10:00:00	DIA	ETF	138.14	138.36	138.1	138.21	2330000.0
2007-10-31 11:00:00	DIA	ETF	138.2	138.35	138.18	138.31	1798320.0
2007-10-31 12:00:00	DIA	ETF	138.32	138.53	138.3	138.43	970500.0

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

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