PREVIEW / etf_1hour / 2007-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-18.parquet
  size:    87 KB
  rows:    2,889

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-18 06:00:00	SPY	ETF	148.34	148.34	148.31	148.31	2100.0
2007-09-18 07:00:00	SPY	ETF	148.3	148.41	148.07	148.18	465600.0
2007-09-18 08:00:00	SPY	ETF	148.2	149.05	148.1	148.86	9296100.0
2007-09-18 09:00:00	SPY	ETF	148.88	148.96	148.37	148.62	15616297.0
2007-09-18 10:00:00	SPY	ETF	148.62	149.21	148.58	149.18	22599300.0
2007-09-18 11:00:00	SPY	ETF	149.17	149.57	148.1341	149.23	23259900.0
2007-09-18 12:00:00	SPY	ETF	149.23	149.3	149.07	149.17	9167300.0
2007-09-18 13:00:00	SPY	ETF	149.17	149.21	148.95	149.18	14287500.0
2007-09-18 14:00:00	SPY	ETF	149.19	151.75	148.67	151.37	94563300.0
2007-09-18 15:00:00	SPY	ETF	151.36	152.5	151.07	152.4	55806700.0
2007-09-18 16:00:00	SPY	ETF	152.4	152.53	149.13	152.39	13131300.0
2007-09-18 17:00:00	SPY	ETF	152.37	152.43	152.3	152.35	1655800.0
2007-09-18 18:00:00	SPY	ETF	152.34	152.6	152.32	152.55	111500.0
2007-09-18 19:00:00	SPY	ETF	152.58	152.61	152.46	152.48	371200.0
2007-09-18 06:00:00	QQQ	ETF	48.8	48.81	48.8	48.81	600.0
2007-09-18 07:00:00	QQQ	ETF	48.84	48.88	48.83	48.84	5687.0
2007-09-18 08:00:00	QQQ	ETF	48.85	49.2	48.84	49.11	2904129.0
2007-09-18 09:00:00	QQQ	ETF	49.12	49.14	48.83	48.9	9678335.0
2007-09-18 10:00:00	QQQ	ETF	48.909	49.03	48.88	49.03	9830955.0
2007-09-18 11:00:00	QQQ	ETF	49.01	49.2	48.97	49.1	12035908.0
2007-09-18 12:00:00	QQQ	ETF	49.1019	49.13	49.03	49.08	3815810.0
2007-09-18 13:00:00	QQQ	ETF	49.08	49.09	48.95	49.04	6393887.0
2007-09-18 14:00:00	QQQ	ETF	49.04	52.77	48.91	49.88	51679499.0
2007-09-18 15:00:00	QQQ	ETF	49.86	50.08	49.73	50.07	26354772.0
2007-09-18 16:00:00	QQQ	ETF	50.07	50.08	49.0769	49.56	2775719.0
2007-09-18 17:00:00	QQQ	ETF	50.03	50.04	49.5	50.01	2049859.0
2007-09-18 18:00:00	QQQ	ETF	50.02	50.08	50.02	50.06	59404.0
2007-09-18 19:00:00	QQQ	ETF	50.06	50.09	50.04	50.07	33293.0
2007-09-18 07:00:00	IWM	ETF	77.33	77.37	77.27	77.29	93200.0
2007-09-18 08:00:00	IWM	ETF	77.354	77.89	77.25	77.79	1220800.0
2007-09-18 09:00:00	IWM	ETF	77.79	77.84	77.24	77.49	9124418.0
2007-09-18 10:00:00	IWM	ETF	77.48	78.0	77.43	77.96	9054500.0
2007-09-18 11:00:00	IWM	ETF	77.97	78.32	77.35	77.99	14466900.0
2007-09-18 12:00:00	IWM	ETF	77.99	78.03	77.79	77.95	3100800.0
2007-09-18 13:00:00	IWM	ETF	77.95	78.07	77.77	78.06	4673300.0
2007-09-18 14:00:00	IWM	ETF	78.06	79.91	77.62	79.7	38262700.0
2007-09-18 15:00:00	IWM	ETF	79.68	80.48	79.49	80.44	31239900.0
2007-09-18 16:00:00	IWM	ETF	80.44	80.63	80.0	80.56	5207500.0
2007-09-18 17:00:00	IWM	ETF	80.55	80.6	80.46	80.51	108200.0
2007-09-18 18:00:00	IWM	ETF	80.6	80.66	80.6	80.61	24000.0
2007-09-18 19:00:00	IWM	ETF	80.57	80.65	80.57	80.64	18800.0
2007-09-18 07:00:00	DIA	ETF	134.29	134.37	134.29	134.37	1800.0
2007-09-18 08:00:00	DIA	ETF	134.27	134.85	134.27	134.68	339500.0
2007-09-18 09:00:00	DIA	ETF	134.67	134.75	134.41	134.57	763400.0
2007-09-18 10:00:00	DIA	ETF	134.57	135.07	134.51	135.03	1191300.0
2007-09-18 11:00:00	DIA	ETF	135.03	135.27	134.9	135.0	1331300.0
2007-09-18 12:00:00	DIA	ETF	135.0	135.05	134.89	134.99	441700.0
2007-09-18 13:00:00	DIA	ETF	134.97	135.02	134.79	134.95	660600.0
2007-09-18 14:00:00	DIA	ETF	134.94	136.82	134.66	136.69	6320100.0
2007-09-18 15:00:00	DIA	ETF	136.67	137.46	136.45	137.35	4811100.0

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

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