PREVIEW / etf_1hour / 2007-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-20.parquet
  size:    70 KB
  rows:    2,248

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-04-20 05:00:00	SPY	ETF	147.66	147.66	147.66	147.66	19000.0
2007-04-20 06:00:00	SPY	ETF	147.69	147.77	147.69	147.77	35100.0
2007-04-20 07:00:00	SPY	ETF	147.72	147.99	147.7	147.92	1343200.0
2007-04-20 08:00:00	SPY	ETF	147.77	148.05	147.47	148.05	5739100.0
2007-04-20 09:00:00	SPY	ETF	148.05	148.47	148.0	148.15	27209484.0
2007-04-20 10:00:00	SPY	ETF	148.16	148.5275	148.02	148.065	25433111.0
2007-04-20 11:00:00	SPY	ETF	148.05	148.1087	147.79	147.8699	15045096.0
2007-04-20 12:00:00	SPY	ETF	147.86	147.97	147.69	147.85	9606958.0
2007-04-20 13:00:00	SPY	ETF	147.845	148.08	147.79	147.95	6591514.0
2007-04-20 14:00:00	SPY	ETF	147.96	148.2	147.92	148.18	7940706.0
2007-04-20 15:00:00	SPY	ETF	148.19	148.48	148.04	148.47	17111366.0
2007-04-20 16:00:00	SPY	ETF	148.46	148.58	148.393	148.58	3013400.0
2007-04-20 17:00:00	SPY	ETF	148.56	148.62	148.5	148.58	54600.0
2007-04-20 18:00:00	SPY	ETF	148.58	148.58	148.55	148.57	10900.0
2007-04-20 19:00:00	SPY	ETF	148.59	148.59	148.57	148.57	900.0
2007-04-20 05:00:00	QQQ	ETF	45.24	45.34	45.24	45.34	57240.0
2007-04-20 06:00:00	QQQ	ETF	45.33	45.33	45.33	45.33	100.0
2007-04-20 07:00:00	QQQ	ETF	45.32	45.47	45.32	45.44	1253104.0
2007-04-20 08:00:00	QQQ	ETF	45.45	45.45	45.39	45.44	1699262.0
2007-04-20 09:00:00	QQQ	ETF	45.44	45.67	45.42	45.45	30126923.0
2007-04-20 10:00:00	QQQ	ETF	45.45	45.48	45.35	45.38	20051400.0
2007-04-20 11:00:00	QQQ	ETF	45.37	45.4	45.25	45.27	13294700.0
2007-04-20 12:00:00	QQQ	ETF	45.27	45.5	45.2	45.26	12671600.0
2007-04-20 13:00:00	QQQ	ETF	45.25	45.4	45.23	45.3	15133500.0
2007-04-20 14:00:00	QQQ	ETF	45.3	45.42	45.05	45.42	10754400.0
2007-04-20 15:00:00	QQQ	ETF	45.42	45.43	45.32	45.4	14127200.0
2007-04-20 16:00:00	QQQ	ETF	45.4	45.48	45.34	45.42	3736799.0
2007-04-20 17:00:00	QQQ	ETF	45.42	45.43	45.41	45.42	35700.0
2007-04-20 18:00:00	QQQ	ETF	45.41	45.43	45.41	45.42	10700.0
2007-04-20 19:00:00	QQQ	ETF	45.43	45.48	45.43	45.48	14686.0
2007-04-20 07:00:00	IWM	ETF	82.0	82.0	81.8	81.88	25500.0
2007-04-20 08:00:00	IWM	ETF	81.88	81.88	81.7	81.77	1258400.0
2007-04-20 09:00:00	IWM	ETF	81.77	82.38	81.77	82.175	12922661.0
2007-04-20 10:00:00	IWM	ETF	82.18	82.26	82.06	82.08	7116128.0
2007-04-20 11:00:00	IWM	ETF	82.07	82.25	81.97	82.02	4999547.0
2007-04-20 12:00:00	IWM	ETF	82.02	82.25	81.76	81.88	8265923.0
2007-04-20 13:00:00	IWM	ETF	81.88	82.05	81.83	81.96	2589014.0
2007-04-20 14:00:00	IWM	ETF	81.96	82.3	81.95	82.29	5257001.0
2007-04-20 15:00:00	IWM	ETF	82.3	82.3	82.1	82.26	7535337.0
2007-04-20 16:00:00	IWM	ETF	82.27	82.41	81.82	82.24	10356200.0
2007-04-20 17:00:00	IWM	ETF	82.26	82.31	82.26	82.31	8500.0
2007-04-20 07:00:00	DIA	ETF	128.68	128.95	128.65	128.95	54100.0
2007-04-20 08:00:00	DIA	ETF	128.9	128.93	128.66	128.89	88900.0
2007-04-20 09:00:00	DIA	ETF	128.9	129.35	128.9	129.11	1804985.0
2007-04-20 10:00:00	DIA	ETF	129.12	129.24	128.99	129.09	1875575.0
2007-04-20 11:00:00	DIA	ETF	129.08	129.15	128.9	128.98	1347802.0
2007-04-20 12:00:00	DIA	ETF	128.97	129.1	128.89	128.99	1403445.0
2007-04-20 13:00:00	DIA	ETF	129.0	129.16	128.94	129.0	877055.0
2007-04-20 14:00:00	DIA	ETF	129.0	129.28	128.99	129.27	707600.0
2007-04-20 15:00:00	DIA	ETF	129.278	129.53	129.19	129.49	1485994.0

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

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