PREVIEW / etf_1hour / 2008-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-07.parquet
  size:    104 KB
  rows:    3,478

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-03-07 04:00:00	SPY	ETF	130.38	130.42	130.38	130.41	1800.0
2008-03-07 05:00:00	SPY	ETF	130.81	130.81	130.65	130.65	14000.0
2008-03-07 06:00:00	SPY	ETF	130.6	130.7	130.55	130.7	112100.0
2008-03-07 07:00:00	SPY	ETF	130.7	131.43	130.7	131.33	1011200.0
2008-03-07 08:00:00	SPY	ETF	130.95	132.09	129.13	129.94	29704999.0
2008-03-07 09:00:00	SPY	ETF	129.95	131.26	129.445	131.11	47634716.0
2008-03-07 10:00:00	SPY	ETF	131.1	131.74	130.53	130.97	48546094.0
2008-03-07 11:00:00	SPY	ETF	130.96	131.0	129.95	130.14	32257435.0
2008-03-07 12:00:00	SPY	ETF	130.14	130.24	129.69	130.13	21852148.0
2008-03-07 13:00:00	SPY	ETF	130.13	130.13	129.09	129.17	24330308.0
2008-03-07 14:00:00	SPY	ETF	129.18	129.74	128.58	129.69	43460651.0
2008-03-07 15:00:00	SPY	ETF	129.69	131.0	129.14	129.71	68124526.0
2008-03-07 16:00:00	SPY	ETF	129.722	131.5	129.53	129.63	5562500.0
2008-03-07 17:00:00	SPY	ETF	129.65	129.72	129.49	129.5	398500.0
2008-03-07 18:00:00	SPY	ETF	129.57	129.6	129.45	129.49	41800.0
2008-03-07 19:00:00	SPY	ETF	129.5	129.5	129.46	129.46	17900.0
2008-03-07 04:00:00	QQQ	ETF	42.01	42.01	42.0	42.0	1800.0
2008-03-07 05:00:00	QQQ	ETF	42.1	42.12	42.06	42.06	17691.0
2008-03-07 06:00:00	QQQ	ETF	42.06	42.08	42.06	42.08	831.0
2008-03-07 07:00:00	QQQ	ETF	42.12	42.32	42.12	42.28	449922.0
2008-03-07 08:00:00	QQQ	ETF	42.28	42.61	41.85	41.97	14163729.0
2008-03-07 09:00:00	QQQ	ETF	41.96	42.49	41.78	42.42	39857984.0
2008-03-07 10:00:00	QQQ	ETF	42.42	42.64	42.2	42.4199	40997637.0
2008-03-07 11:00:00	QQQ	ETF	42.41	42.41	41.99	42.0499	22084747.0
2008-03-07 12:00:00	QQQ	ETF	42.05	42.13	41.89	42.07	14873653.0
2008-03-07 13:00:00	QQQ	ETF	42.07	42.07	41.58	41.61	19198353.0
2008-03-07 14:00:00	QQQ	ETF	41.61	41.9	41.38	41.8975	26567992.0
2008-03-07 15:00:00	QQQ	ETF	41.9	42.3	41.73	42.07	64370260.0
2008-03-07 16:00:00	QQQ	ETF	42.06	42.1492	41.95	42.0	4975969.0
2008-03-07 17:00:00	QQQ	ETF	42.01	42.05	41.93	41.95	60154.0
2008-03-07 18:00:00	QQQ	ETF	41.98	41.99	41.96	41.96	8526.0
2008-03-07 19:00:00	QQQ	ETF	41.96	41.99	41.96	41.96	7710.0
2008-03-07 07:00:00	IWM	ETF	65.85	66.28	65.85	66.28	184900.0
2008-03-07 08:00:00	IWM	ETF	66.21	66.59	65.19	65.46	3974700.0
2008-03-07 09:00:00	IWM	ETF	65.46	66.82	65.25	66.75	15954725.0
2008-03-07 10:00:00	IWM	ETF	66.75	66.84	66.17	66.36	18096539.0
2008-03-07 11:00:00	IWM	ETF	66.34	66.46	65.88	65.99	9571688.0
2008-03-07 12:00:00	IWM	ETF	66.0	66.21	65.77	66.15	9699096.0
2008-03-07 13:00:00	IWM	ETF	66.14	66.15	65.5	65.57	7431641.0
2008-03-07 14:00:00	IWM	ETF	65.58	65.97	65.2	65.97	17443259.0
2008-03-07 15:00:00	IWM	ETF	65.97	66.54	65.66	65.82	22026611.0
2008-03-07 16:00:00	IWM	ETF	65.82	66.04	65.74	65.93	14735900.0
2008-03-07 17:00:00	IWM	ETF	65.95	65.95	65.95	65.95	1000.0
2008-03-07 18:00:00	IWM	ETF	65.82	65.82	65.69	65.69	20400.0
2008-03-07 07:00:00	DIA	ETF	120.61	120.91	120.61	120.9	2700.0
2008-03-07 08:00:00	DIA	ETF	120.85	121.32	119.1	119.6	1073900.0
2008-03-07 09:00:00	DIA	ETF	119.63	120.5	119.2	120.4	3232368.0
2008-03-07 10:00:00	DIA	ETF	120.4	121.04	120.02	120.41	2871663.0
2008-03-07 11:00:00	DIA	ETF	120.4	120.43	119.52	119.67	2107707.0
2008-03-07 12:00:00	DIA	ETF	119.64	119.72	119.31	119.64	1193305.0

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

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