PREVIEW / etf_1hour / 2008-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-13.parquet
  size:    105 KB
  rows:    3,495

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-13 04:00:00	SPY	ETF	129.96	130.05	129.57	129.57	20900.0
2008-03-13 05:00:00	SPY	ETF	129.4	129.47	129.4	129.4	3600.0
2008-03-13 06:00:00	SPY	ETF	129.71	129.71	129.33	129.6	463700.0
2008-03-13 07:00:00	SPY	ETF	129.66	129.74	129.47	129.59	2201300.0
2008-03-13 08:00:00	SPY	ETF	129.6	129.83	129.18	129.6	7635500.0
2008-03-13 09:00:00	SPY	ETF	129.58	129.87	128.9	129.15	34313237.0
2008-03-13 10:00:00	SPY	ETF	129.14	129.78	128.6	128.9685	44842638.0
2008-03-13 11:00:00	SPY	ETF	128.96	130.71	128.85	130.59	71434798.0
2008-03-13 12:00:00	SPY	ETF	130.6	131.17	130.06	130.4	29070327.0
2008-03-13 13:00:00	SPY	ETF	130.4	132.59	130.24	132.19	52920567.0
2008-03-13 14:00:00	SPY	ETF	132.18	132.61	131.65	132.15	43353569.0
2008-03-13 15:00:00	SPY	ETF	132.15	132.64	131.69	131.92	47105952.0
2008-03-13 16:00:00	SPY	ETF	131.88	131.96	129.35	131.57	8923000.0
2008-03-13 17:00:00	SPY	ETF	131.55	131.69	131.44	131.53	5317600.0
2008-03-13 18:00:00	SPY	ETF	131.53	131.8	131.53	131.65	345000.0
2008-03-13 19:00:00	SPY	ETF	131.68	131.88	131.61	131.75	51700.0
2008-03-13 04:00:00	QQQ	ETF	42.32	42.33	42.12	42.12	7648.0
2008-03-13 05:00:00	QQQ	ETF	42.03	42.17	42.03	42.17	800.0
2008-03-13 06:00:00	QQQ	ETF	42.07	42.2	42.03	42.2	3881.0
2008-03-13 07:00:00	QQQ	ETF	42.19	42.21	42.05	42.15	938285.0
2008-03-13 08:00:00	QQQ	ETF	42.13	42.23	42.02	42.17	2949159.0
2008-03-13 09:00:00	QQQ	ETF	42.15	42.29	42.05	42.11	24884114.0
2008-03-13 10:00:00	QQQ	ETF	42.11	42.36	41.81	41.97	33065295.0
2008-03-13 11:00:00	QQQ	ETF	41.97	42.54	41.9	42.48	42327860.0
2008-03-13 12:00:00	QQQ	ETF	42.482	42.69	42.29	42.47	20814387.0
2008-03-13 13:00:00	QQQ	ETF	42.47	43.29	42.42	43.18	27567116.0
2008-03-13 14:00:00	QQQ	ETF	43.17	43.31	42.97	43.16	23593775.0
2008-03-13 15:00:00	QQQ	ETF	43.16	43.33	42.99	43.06	28897781.0
2008-03-13 16:00:00	QQQ	ETF	43.06	43.07	42.95	43.01	3765153.0
2008-03-13 17:00:00	QQQ	ETF	43.01	43.01	42.95	42.98	142762.0
2008-03-13 18:00:00	QQQ	ETF	42.98	43.02	42.95	43.0	25374.0
2008-03-13 19:00:00	QQQ	ETF	42.98	43.05	42.98	43.05	10370.0
2008-03-13 06:00:00	IWM	ETF	65.76	65.76	65.76	65.76	200.0
2008-03-13 07:00:00	IWM	ETF	65.7	65.76	65.54	65.7	313700.0
2008-03-13 08:00:00	IWM	ETF	65.66	65.8	65.53	65.75	451200.0
2008-03-13 09:00:00	IWM	ETF	65.74	66.0	65.34	65.4	13152151.0
2008-03-13 10:00:00	IWM	ETF	65.4	65.98	65.2	65.5	17306465.0
2008-03-13 11:00:00	IWM	ETF	65.5	66.5	65.4	66.36	20125881.0
2008-03-13 12:00:00	IWM	ETF	66.37	67.03	66.36	67.0	16797268.0
2008-03-13 13:00:00	IWM	ETF	67.0	67.98	65.35	67.7	24922970.0
2008-03-13 14:00:00	IWM	ETF	67.7	67.91	67.32	67.71	12068909.0
2008-03-13 15:00:00	IWM	ETF	67.72	67.94	67.49	67.89	14118468.0
2008-03-13 16:00:00	IWM	ETF	67.89	67.89	66.81	67.53	5641300.0
2008-03-13 17:00:00	IWM	ETF	67.61	67.7	67.57	67.7	5400.0
2008-03-13 18:00:00	IWM	ETF	67.63	67.75	67.63	67.74	30000.0
2008-03-13 19:00:00	IWM	ETF	67.7	67.77	67.69	67.72	8600.0
2008-03-13 06:00:00	DIA	ETF	119.86	119.86	119.77	119.77	400.0
2008-03-13 07:00:00	DIA	ETF	119.98	119.98	119.76	119.78	148500.0
2008-03-13 08:00:00	DIA	ETF	119.79	119.93	119.49	119.76	399300.0
2008-03-13 09:00:00	DIA	ETF	119.81	120.15	119.26	119.42	2804475.0

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

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