PREVIEW / etf_1hour / 2007-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-18.parquet
  size:    68 KB
  rows:    2,197

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-18 06:00:00	SPY	ETF	146.9	147.02	146.9	147.02	5200.0
2007-04-18 07:00:00	SPY	ETF	146.98	147.01	146.74	146.81	45600.0
2007-04-18 08:00:00	SPY	ETF	146.81	146.97	146.52	146.68	2752800.0
2007-04-18 09:00:00	SPY	ETF	146.67	146.89	146.57	146.86	12149455.0
2007-04-18 10:00:00	SPY	ETF	146.87	147.15	146.58	147.02	19861657.0
2007-04-18 11:00:00	SPY	ETF	147.02	147.31	147.0	147.12	9913361.0
2007-04-18 12:00:00	SPY	ETF	147.12	147.235	146.97	147.02	6450947.0
2007-04-18 13:00:00	SPY	ETF	147.01	147.29	147.0	147.21	8561192.0
2007-04-18 14:00:00	SPY	ETF	147.2	147.39	147.19	147.33	7444723.0
2007-04-18 15:00:00	SPY	ETF	147.33	147.7	147.14	147.15	15918528.0
2007-04-18 16:00:00	SPY	ETF	147.14	147.36	147.08	147.16	3491100.0
2007-04-18 17:00:00	SPY	ETF	147.16	147.26	147.14	147.26	137100.0
2007-04-18 18:00:00	SPY	ETF	147.22	147.22	147.14	147.19	8000.0
2007-04-18 19:00:00	SPY	ETF	147.17	147.17	147.1	147.1	700.0
2007-04-18 06:00:00	QQQ	ETF	45.06	45.1	45.06	45.1	5800.0
2007-04-18 07:00:00	QQQ	ETF	45.07	45.11	44.97	44.99	707839.0
2007-04-18 08:00:00	QQQ	ETF	44.99	45.0	44.89	44.93	1602706.0
2007-04-18 09:00:00	QQQ	ETF	44.93	45.02	44.89	44.96	11858018.0
2007-04-18 10:00:00	QQQ	ETF	44.96	45.06	44.83	45.03	20274200.0
2007-04-18 11:00:00	QQQ	ETF	45.02	45.12	45.02	45.07	6840000.0
2007-04-18 12:00:00	QQQ	ETF	45.07	45.08	44.96	44.99	5154900.0
2007-04-18 13:00:00	QQQ	ETF	45.0	45.08	44.99	45.05	6092300.0
2007-04-18 14:00:00	QQQ	ETF	45.06	45.13	45.05	45.1	5908200.0
2007-04-18 15:00:00	QQQ	ETF	45.11	45.23	45.01	45.01	15317800.0
2007-04-18 16:00:00	QQQ	ETF	45.01	45.16	45.0	45.07	4760173.0
2007-04-18 17:00:00	QQQ	ETF	45.07	45.15	45.06	45.15	3031523.0
2007-04-18 18:00:00	QQQ	ETF	45.14	45.14	45.06	45.06	271169.0
2007-04-18 19:00:00	QQQ	ETF	45.07	45.08	45.03	45.03	21955.0
2007-04-18 07:00:00	IWM	ETF	82.03	82.04	82.0	82.03	9100.0
2007-04-18 08:00:00	IWM	ETF	82.08	82.24	81.75	81.91	2133200.0
2007-04-18 09:00:00	IWM	ETF	81.91	82.13	81.84	82.04	4334352.0
2007-04-18 10:00:00	IWM	ETF	82.05	82.22	81.66	82.04	10016515.0
2007-04-18 11:00:00	IWM	ETF	82.04	82.18	81.94	81.96	4087824.0
2007-04-18 12:00:00	IWM	ETF	81.96	82.01	81.8	81.88	3625079.0
2007-04-18 13:00:00	IWM	ETF	81.87	81.97	81.82	81.94	2922298.0
2007-04-18 14:00:00	IWM	ETF	81.9395	82.11	81.9378	82.04	3144674.0
2007-04-18 15:00:00	IWM	ETF	82.05	82.18	81.74	81.75	12110369.0
2007-04-18 16:00:00	IWM	ETF	81.75	81.98	81.68	81.68	4434400.0
2007-04-18 17:00:00	IWM	ETF	81.72	81.78	81.7	81.78	63700.0
2007-04-18 18:00:00	IWM	ETF	81.82	81.82	81.73	81.76	50300.0
2007-04-18 19:00:00	IWM	ETF	81.74	81.87	81.74	81.87	127700.0
2007-04-18 07:00:00	DIA	ETF	127.52	127.52	127.52	127.52	500.0
2007-04-18 08:00:00	DIA	ETF	127.5	127.56	127.38	127.5	36600.0
2007-04-18 09:00:00	DIA	ETF	127.5	127.68	127.42	127.52	1020176.0
2007-04-18 10:00:00	DIA	ETF	127.53	127.78	127.29	127.62	2875200.0
2007-04-18 11:00:00	DIA	ETF	127.62	127.9	127.61	127.78	1627250.0
2007-04-18 12:00:00	DIA	ETF	127.78	127.9	127.66	127.7	669200.0
2007-04-18 13:00:00	DIA	ETF	127.71	128.02	127.71	127.945	735400.0
2007-04-18 14:00:00	DIA	ETF	127.94	128.07	127.93	128.05	611100.0
2007-04-18 15:00:00	DIA	ETF	128.05	128.34	127.94	127.94	1437038.0

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

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