PREVIEW / etf_1hour / 2008-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-26.parquet
  size:    113 KB
  rows:    3,601

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-06-26 04:00:00	SPY	ETF	131.4	131.4	131.25	131.25	300.0
2008-06-26 05:00:00	SPY	ETF	131.22	131.22	131.05	131.12	4700.0
2008-06-26 06:00:00	SPY	ETF	131.2	131.4	131.05	131.4	330650.0
2008-06-26 07:00:00	SPY	ETF	131.34	131.49	130.55	130.69	1990121.0
2008-06-26 08:00:00	SPY	ETF	130.7	131.35	130.37	130.53	7120214.0
2008-06-26 09:00:00	SPY	ETF	130.51	130.69	130.2	130.5	32139492.0
2008-06-26 10:00:00	SPY	ETF	130.5	131.42	129.5	129.55	58897209.0
2008-06-26 11:00:00	SPY	ETF	129.55	129.9	129.36	129.748	38017344.0
2008-06-26 12:00:00	SPY	ETF	129.77	129.79	129.0	129.21	32622761.0
2008-06-26 13:00:00	SPY	ETF	129.21	129.48	128.86	129.33	22452590.0
2008-06-26 14:00:00	SPY	ETF	129.33	129.57	128.5	128.58	39682017.0
2008-06-26 15:00:00	SPY	ETF	128.58	129.07	128.17	128.21	54936636.0
2008-06-26 16:00:00	SPY	ETF	128.21	128.38	128.08	128.21	5601671.0
2008-06-26 17:00:00	SPY	ETF	128.24	128.37	128.21	128.27	111616.0
2008-06-26 18:00:00	SPY	ETF	128.28	128.37	128.28	128.36	91549.0
2008-06-26 19:00:00	SPY	ETF	128.36	128.38	128.23	128.26	57740.0
2008-06-26 04:00:00	QQQ	ETF	47.14	47.14	47.12	47.12	2000.0
2008-06-26 05:00:00	QQQ	ETF	47.12	47.12	47.06	47.06	600.0
2008-06-26 06:00:00	QQQ	ETF	47.08	47.08	47.03	47.03	76600.0
2008-06-26 07:00:00	QQQ	ETF	47.04	47.06	46.71	46.78	477193.0
2008-06-26 08:00:00	QQQ	ETF	46.78	47.01	46.6	46.62	3622935.0
2008-06-26 09:00:00	QQQ	ETF	46.62	46.72	46.4	46.5	19597822.0
2008-06-26 10:00:00	QQQ	ETF	46.51	46.62	46.05	46.1	33113859.0
2008-06-26 11:00:00	QQQ	ETF	46.1	46.27	46.03	46.1801	14931553.0
2008-06-26 12:00:00	QQQ	ETF	46.182	46.19	45.99	46.1	15595753.0
2008-06-26 13:00:00	QQQ	ETF	46.1001	46.17	45.86	46.02	16305137.0
2008-06-26 14:00:00	QQQ	ETF	46.01	46.13	45.69	45.77	25521021.0
2008-06-26 15:00:00	QQQ	ETF	45.78	46.05	45.64	45.66	32562877.0
2008-06-26 16:00:00	QQQ	ETF	45.65	46.31	45.63	45.76	8824875.0
2008-06-26 17:00:00	QQQ	ETF	45.76	45.81	45.69	45.69	173707.0
2008-06-26 18:00:00	QQQ	ETF	45.69	45.76	45.68	45.75	90821.0
2008-06-26 19:00:00	QQQ	ETF	45.72	45.76	45.7	45.7	68682.0
2008-06-26 06:00:00	IWM	ETF	71.0	71.14	71.0	71.08	6900.0
2008-06-26 07:00:00	IWM	ETF	71.1	71.15	70.66	70.73	125998.0
2008-06-26 08:00:00	IWM	ETF	70.76	71.0	70.58	70.69	741993.0
2008-06-26 09:00:00	IWM	ETF	70.68	70.86	70.52	70.72	10721008.0
2008-06-26 10:00:00	IWM	ETF	70.73	70.95	70.06	70.1	22266784.0
2008-06-26 11:00:00	IWM	ETF	70.1	70.45	70.0	70.23	13291550.0
2008-06-26 12:00:00	IWM	ETF	70.23	70.25	69.73	69.97	11134810.0
2008-06-26 13:00:00	IWM	ETF	69.97	70.09	69.68	70.04	9747212.0
2008-06-26 14:00:00	IWM	ETF	70.03	70.23	69.61	69.73	16032676.0
2008-06-26 15:00:00	IWM	ETF	69.73	70.18	69.65	69.89	18918467.0
2008-06-26 16:00:00	IWM	ETF	69.89	71.65	69.64	69.7	7472246.0
2008-06-26 17:00:00	IWM	ETF	69.72	69.88	69.72	69.77	54694.0
2008-06-26 18:00:00	IWM	ETF	69.8	69.8	69.72	69.72	5850.0
2008-06-26 19:00:00	IWM	ETF	69.77	69.78	69.77	69.78	469.0
2008-06-26 07:00:00	DIA	ETF	117.52	117.52	116.98	116.99	3912.0
2008-06-26 08:00:00	DIA	ETF	117.01	117.15	116.83	116.96	177847.0
2008-06-26 09:00:00	DIA	ETF	116.93	117.06	116.52	116.67	2952745.0
2008-06-26 10:00:00	DIA	ETF	116.68	116.86	115.83	115.89	5060883.0

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

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