PREVIEW / etf_1hour / 2007-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-24.parquet
  size:    86 KB
  rows:    2,909

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-24 04:00:00	SPY	ETF	152.24	152.24	152.24	152.24	200.0
2007-09-24 06:00:00	SPY	ETF	152.41	152.45	152.41	152.45	55000.0
2007-09-24 07:00:00	SPY	ETF	152.45	152.49	152.25	152.41	299700.0
2007-09-24 08:00:00	SPY	ETF	152.41	152.51	151.85	152.37	1517200.0
2007-09-24 09:00:00	SPY	ETF	152.37	152.49	151.93	152.02	12267917.0
2007-09-24 10:00:00	SPY	ETF	152.01	152.79	151.97	152.64	23162000.0
2007-09-24 11:00:00	SPY	ETF	152.65	152.82	152.44	152.52	13567000.0
2007-09-24 12:00:00	SPY	ETF	152.51	152.65	152.28	152.39	12307500.0
2007-09-24 13:00:00	SPY	ETF	152.38	152.42	151.65	151.79	23987200.0
2007-09-24 14:00:00	SPY	ETF	151.79	151.98	151.42	151.68	20820100.0
2007-09-24 15:00:00	SPY	ETF	151.67	151.79	151.36	151.55	20369000.0
2007-09-24 16:00:00	SPY	ETF	151.57	152.4	151.5484	151.64	5998900.0
2007-09-24 17:00:00	SPY	ETF	151.6	151.64	151.23	151.3	1134500.0
2007-09-24 18:00:00	SPY	ETF	151.3	151.49	151.24	151.26	1308900.0
2007-09-24 19:00:00	SPY	ETF	151.28	151.32	151.23	151.32	105700.0
2007-09-24 07:00:00	QQQ	ETF	50.46	50.53	50.41	50.52	102170.0
2007-09-24 08:00:00	QQQ	ETF	50.5	50.53	50.4	50.5	326858.0
2007-09-24 09:00:00	QQQ	ETF	50.51	50.6	50.43	50.4699	10158056.0
2007-09-24 10:00:00	QQQ	ETF	50.46	50.96	50.44	50.9	20935920.0
2007-09-24 11:00:00	QQQ	ETF	50.9	50.94	50.8	50.85	8875038.0
2007-09-24 12:00:00	QQQ	ETF	50.8419	50.91	50.75	50.79	7932945.0
2007-09-24 13:00:00	QQQ	ETF	50.79	50.79	50.44	50.49	23854365.0
2007-09-24 14:00:00	QQQ	ETF	50.49	50.57	50.33	50.49	13364089.0
2007-09-24 15:00:00	QQQ	ETF	50.5	50.59	50.37	50.58	15287350.0
2007-09-24 16:00:00	QQQ	ETF	50.58	50.94	50.386	50.57	5937754.0
2007-09-24 17:00:00	QQQ	ETF	50.56	50.59	50.51	50.53	381785.0
2007-09-24 18:00:00	QQQ	ETF	50.52	50.52	50.42	50.43	62660.0
2007-09-24 19:00:00	QQQ	ETF	50.42	50.45	50.42	50.45	21530.0
2007-09-24 07:00:00	IWM	ETF	81.15	81.15	81.01	81.06	10300.0
2007-09-24 08:00:00	IWM	ETF	81.05	81.15	80.99	81.01	375500.0
2007-09-24 09:00:00	IWM	ETF	80.99	81.3	80.76	80.85	10654017.0
2007-09-24 10:00:00	IWM	ETF	80.85	81.37	80.61	81.18	16234200.0
2007-09-24 11:00:00	IWM	ETF	81.18	81.37	81.0	81.14	12095600.0
2007-09-24 12:00:00	IWM	ETF	81.15	81.27	80.9	80.96	4096900.0
2007-09-24 13:00:00	IWM	ETF	80.97	81.1	80.25	80.44	13291900.0
2007-09-24 14:00:00	IWM	ETF	80.44	81.5	80.16	80.3	8329000.0
2007-09-24 15:00:00	IWM	ETF	80.3	80.44	80.09	80.34	11393600.0
2007-09-24 16:00:00	IWM	ETF	80.34	80.79	80.3	80.34	11273400.0
2007-09-24 17:00:00	IWM	ETF	80.34	81.07	80.08	80.08	432100.0
2007-09-24 18:00:00	IWM	ETF	80.13	80.17	80.05	80.14	68200.0
2007-09-24 19:00:00	IWM	ETF	80.13	80.16	80.1	80.14	12500.0
2007-09-24 07:00:00	DIA	ETF	138.34	138.34	138.2	138.22	2200.0
2007-09-24 08:00:00	DIA	ETF	138.33	138.41	138.27	138.38	24600.0
2007-09-24 09:00:00	DIA	ETF	138.34	138.42	137.93	138.02	1527000.0
2007-09-24 10:00:00	DIA	ETF	138.02	138.75	137.98	138.52	1652000.0
2007-09-24 11:00:00	DIA	ETF	138.5	138.6	138.3	138.37	923800.0
2007-09-24 12:00:00	DIA	ETF	138.37	138.48	138.13	138.21	769800.0
2007-09-24 13:00:00	DIA	ETF	138.22	138.25	137.68	137.73	1881300.0
2007-09-24 14:00:00	DIA	ETF	137.76	137.9	137.5	137.65	1051600.0
2007-09-24 15:00:00	DIA	ETF	137.64	137.72	137.37	137.45	1465900.0

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

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