PREVIEW / etf_1hour / 2008-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-16.parquet
  size:    103 KB
  rows:    3,461

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
2008-01-16 04:00:00	SPY	ETF	137.1	137.36	137.1	137.35	6000.0
2008-01-16 05:00:00	SPY	ETF	137.35	137.35	136.9	137.0	30600.0
2008-01-16 06:00:00	SPY	ETF	137.08	137.1	136.6	136.92	170200.0
2008-01-16 07:00:00	SPY	ETF	136.95	137.49	136.82	137.1	2480600.0
2008-01-16 08:00:00	SPY	ETF	137.0	137.68	136.6664	137.26	13821900.0
2008-01-16 09:00:00	SPY	ETF	137.28	138.5	137.17	137.45	37685358.0
2008-01-16 10:00:00	SPY	ETF	137.45	137.75	136.28	136.65	49787724.0
2008-01-16 11:00:00	SPY	ETF	136.65	138.08	136.59	137.9	51890728.0
2008-01-16 12:00:00	SPY	ETF	137.9	138.33	137.55	137.79	31419501.0
2008-01-16 13:00:00	SPY	ETF	137.79	137.95	137.26	137.51	29164941.0
2008-01-16 14:00:00	SPY	ETF	137.51	139.12	137.13	138.18	69197224.0
2008-01-16 15:00:00	SPY	ETF	138.19	138.91	137.1	137.15	67604096.0
2008-01-16 16:00:00	SPY	ETF	137.16	138.24	136.98	137.28	21295650.0
2008-01-16 17:00:00	SPY	ETF	137.27	137.36	137.2	137.21	107600.0
2008-01-16 18:00:00	SPY	ETF	137.26	137.31	137.11	137.3	65000.0
2008-01-16 19:00:00	SPY	ETF	137.31	137.51	137.3	137.4	29500.0
2008-01-16 04:00:00	QQQ	ETF	46.03	46.03	46.01	46.01	1300.0
2008-01-16 05:00:00	QQQ	ETF	46.01	46.01	45.94	45.94	400.0
2008-01-16 06:00:00	QQQ	ETF	45.97	45.97	45.83	45.95	28900.0
2008-01-16 07:00:00	QQQ	ETF	45.96	46.17	45.93	46.04	2141637.0
2008-01-16 08:00:00	QQQ	ETF	46.07	46.26	46.0	46.1	6681788.0
2008-01-16 09:00:00	QQQ	ETF	46.14	46.65	46.1	46.15	30056178.0
2008-01-16 10:00:00	QQQ	ETF	46.15	46.2	45.46	45.63	40342525.0
2008-01-16 11:00:00	QQQ	ETF	45.64	46.3	45.62	46.25	42933223.0
2008-01-16 12:00:00	QQQ	ETF	46.26	46.47	46.09	46.3	27454025.0
2008-01-16 13:00:00	QQQ	ETF	46.3	46.35	46.0	46.15	21923957.0
2008-01-16 14:00:00	QQQ	ETF	46.16	46.91	46.03	46.45	45319398.0
2008-01-16 15:00:00	QQQ	ETF	46.45	46.78	46.01	46.02	43782861.0
2008-01-16 16:00:00	QQQ	ETF	46.02	46.5695	45.89	46.05	5900656.0
2008-01-16 17:00:00	QQQ	ETF	46.09	46.12	46.03	46.05	129557.0
2008-01-16 18:00:00	QQQ	ETF	46.03	46.06	46.01	46.06	24855.0
2008-01-16 19:00:00	QQQ	ETF	46.07	46.15	46.07	46.13	53578.0
2008-01-16 06:00:00	IWM	ETF	68.81	68.83	68.81	68.81	3200.0
2008-01-16 07:00:00	IWM	ETF	69.0	69.12	68.93	69.1	182100.0
2008-01-16 08:00:00	IWM	ETF	69.03	69.26	68.57	69.2	581000.0
2008-01-16 09:00:00	IWM	ETF	69.25	70.14	69.1	69.37	19266689.0
2008-01-16 10:00:00	IWM	ETF	69.38	69.5	68.72	68.89	17368878.0
2008-01-16 11:00:00	IWM	ETF	68.89	70.06	68.88	69.93	24960062.0
2008-01-16 12:00:00	IWM	ETF	69.93	70.29	69.5	70.07	14615297.0
2008-01-16 13:00:00	IWM	ETF	70.07	70.2	69.65	69.78	8744435.0
2008-01-16 14:00:00	IWM	ETF	69.77	70.71	69.61	70.22	27913862.0
2008-01-16 15:00:00	IWM	ETF	70.22	70.59	69.59	69.59	20626066.0
2008-01-16 16:00:00	IWM	ETF	69.59	70.19	68.59	69.71	2198020.0
2008-01-16 17:00:00	IWM	ETF	69.69	69.83	69.68	69.78	8600.0
2008-01-16 18:00:00	IWM	ETF	69.67	69.67	69.67	69.67	1000.0
2008-01-16 19:00:00	IWM	ETF	69.77	69.88	69.77	69.88	3800.0
2008-01-16 07:00:00	DIA	ETF	124.32	124.57	124.09	124.57	8900.0
2008-01-16 08:00:00	DIA	ETF	124.3	124.76	124.26	124.62	101500.0
2008-01-16 09:00:00	DIA	ETF	124.56	125.46	124.36	124.69	2771229.0
2008-01-16 10:00:00	DIA	ETF	124.68	124.96	123.94	124.22	4121263.0

> showing 50 of 3,461 rows — these rows as CSV

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