PREVIEW / etf_1hour / 2007-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-21.parquet
  size:    83 KB
  rows:    2,817

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-09-21 04:00:00	SPY	ETF	152.29	152.38	152.29	152.38	5000.0
2007-09-21 05:00:00	SPY	ETF	152.39	152.46	152.36	152.44	8100.0
2007-09-21 06:00:00	SPY	ETF	152.34	152.46	152.29	152.32	52700.0
2007-09-21 07:00:00	SPY	ETF	152.38	152.66	152.31	152.53	1030500.0
2007-09-21 08:00:00	SPY	ETF	152.54	152.92	151.72	152.81	4492800.0
2007-09-21 09:00:00	SPY	ETF	152.83	152.91	152.29	152.32	20047009.0
2007-09-21 10:00:00	SPY	ETF	152.32	152.68	152.28	152.47	19259700.0
2007-09-21 11:00:00	SPY	ETF	152.471	153.1177	152.44	152.72	14012500.0
2007-09-21 12:00:00	SPY	ETF	152.72	152.89	152.62	152.73	7336000.0
2007-09-21 13:00:00	SPY	ETF	152.73	152.77	152.48	152.5	28395700.0
2007-09-21 14:00:00	SPY	ETF	152.5	152.61	152.25	152.39	14601700.0
2007-09-21 15:00:00	SPY	ETF	152.39	152.68	152.27	152.27	18063800.0
2007-09-21 16:00:00	SPY	ETF	152.26	152.64	151.6501	152.05	10958600.0
2007-09-21 17:00:00	SPY	ETF	152.05	152.09	152.0	152.09	108300.0
2007-09-21 19:00:00	SPY	ETF	152.04	152.09	152.04	152.09	4100.0
2007-09-21 04:00:00	QQQ	ETF	50.28	50.28	50.28	50.28	10000.0
2007-09-21 06:00:00	QQQ	ETF	50.27	50.27	50.27	50.27	4000.0
2007-09-21 07:00:00	QQQ	ETF	50.25	50.32	50.24	50.29	378518.0
2007-09-21 08:00:00	QQQ	ETF	50.28	50.42	50.24	50.39	2308481.0
2007-09-21 09:00:00	QQQ	ETF	50.39	50.42	50.19	50.23	15087879.0
2007-09-21 10:00:00	QQQ	ETF	50.23	50.38	50.23	50.36	11670442.0
2007-09-21 11:00:00	QQQ	ETF	50.36	50.51	50.36	50.47	7272054.0
2007-09-21 12:00:00	QQQ	ETF	50.478	50.51	50.4	50.45	4961750.0
2007-09-21 13:00:00	QQQ	ETF	50.45	50.47	50.34	50.35	4258908.0
2007-09-21 14:00:00	QQQ	ETF	50.35	50.45	50.0143	50.39	7543354.0
2007-09-21 15:00:00	QQQ	ETF	50.39	50.52	50.35	50.37	13508027.0
2007-09-21 16:00:00	QQQ	ETF	50.37	50.43	50.27	50.33	3242138.0
2007-09-21 17:00:00	QQQ	ETF	50.35	50.35	50.32	50.35	57362.0
2007-09-21 18:00:00	QQQ	ETF	50.35	50.37	50.35	50.36	6125.0
2007-09-21 19:00:00	QQQ	ETF	50.36	50.37	50.36	50.37	1671.0
2007-09-21 07:00:00	IWM	ETF	81.22	81.23	81.2	81.23	40600.0
2007-09-21 08:00:00	IWM	ETF	81.25	81.47	81.23	81.42	231400.0
2007-09-21 09:00:00	IWM	ETF	81.44	81.45	80.96	81.04	8669631.0
2007-09-21 10:00:00	IWM	ETF	81.04	81.29	80.99	81.22	7211200.0
2007-09-21 11:00:00	IWM	ETF	81.22	81.55	81.21	81.48	7858500.0
2007-09-21 12:00:00	IWM	ETF	81.48	81.56	81.28	81.32	6239900.0
2007-09-21 13:00:00	IWM	ETF	81.31	81.37	81.06	81.09	4656600.0
2007-09-21 14:00:00	IWM	ETF	81.08	81.18	80.93	81.09	4605900.0
2007-09-21 15:00:00	IWM	ETF	81.09	81.27	80.97	81.05	10982000.0
2007-09-21 16:00:00	IWM	ETF	81.05	81.08	80.85	80.96	1441500.0
2007-09-21 17:00:00	IWM	ETF	80.98	81.0	80.95	80.95	24600.0
2007-09-21 18:00:00	IWM	ETF	80.95	80.95	80.95	80.95	600.0
2007-09-21 07:00:00	DIA	ETF	138.12	138.17	138.1	138.13	1600.0
2007-09-21 08:00:00	DIA	ETF	138.07	138.4	138.07	138.37	31100.0
2007-09-21 09:00:00	DIA	ETF	138.37	139.02	138.16	138.23	2159500.0
2007-09-21 10:00:00	DIA	ETF	138.23	138.42	138.13	138.24	1193200.0
2007-09-21 11:00:00	DIA	ETF	138.23	138.48	138.23	138.45	934500.0
2007-09-21 12:00:00	DIA	ETF	138.44	138.63	138.39	138.51	588200.0
2007-09-21 13:00:00	DIA	ETF	138.5	138.52	138.34	138.36	377700.0
2007-09-21 14:00:00	DIA	ETF	138.36	138.39	138.04	138.13	665100.0

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

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