PREVIEW / etf_1hour / 2009-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-24.parquet
  size:    147 KB
  rows:    4,534

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
2009-09-24 04:00:00	SPY	ETF	105.87	106.05	105.82	106.05	7183.0
2009-09-24 05:00:00	SPY	ETF	106.11	106.5	106.11	106.5	4500.0
2009-09-24 06:00:00	SPY	ETF	106.4	106.41	106.11	106.11	17599.0
2009-09-24 07:00:00	SPY	ETF	106.12	106.41	106.12	106.36	224457.0
2009-09-24 08:00:00	SPY	ETF	106.37	106.84	106.26	106.72	5293420.0
2009-09-24 09:00:00	SPY	ETF	106.74	106.75	106.12	106.38	20524913.0
2009-09-24 10:00:00	SPY	ETF	106.34	106.4	104.77	105.16	55566149.0
2009-09-24 11:00:00	SPY	ETF	105.16	105.35	104.88	105.04	19782510.0
2009-09-24 12:00:00	SPY	ETF	105.03	105.18	104.8	104.84	12414727.0
2009-09-24 13:00:00	SPY	ETF	104.84	105.19	104.62	104.79	21806345.0
2009-09-24 14:00:00	SPY	ETF	104.79	105.2	104.55	105.1	25918186.0
2009-09-24 15:00:00	SPY	ETF	105.1	105.33	104.95	105.04	39452433.0
2009-09-24 16:00:00	SPY	ETF	105.03	106.53	104.7	104.89	17230341.0
2009-09-24 17:00:00	SPY	ETF	104.9	105.05	104.81	104.88	1664226.0
2009-09-24 18:00:00	SPY	ETF	104.89	104.95	104.85	104.86	91387.0
2009-09-24 19:00:00	SPY	ETF	104.87	104.87	104.75	104.77	39861.0
2009-09-24 04:00:00	QQQ	ETF	42.36	42.36	42.34	42.36	845.0
2009-09-24 05:00:00	QQQ	ETF	42.42	42.53	42.42	42.53	4100.0
2009-09-24 06:00:00	QQQ	ETF	42.56	42.56	42.55	42.55	15000.0
2009-09-24 07:00:00	QQQ	ETF	42.45	42.57	42.45	42.55	136758.0
2009-09-24 08:00:00	QQQ	ETF	42.48	42.77	42.48	42.73	2303580.0
2009-09-24 09:00:00	QQQ	ETF	42.73	42.75	42.44	42.49	13193910.0
2009-09-24 10:00:00	QQQ	ETF	42.5	42.555	41.77	41.9501	28381548.0
2009-09-24 11:00:00	QQQ	ETF	41.95	42.09	41.87	41.928	8879141.0
2009-09-24 12:00:00	QQQ	ETF	41.92	42.0	41.86	41.8894	5593686.0
2009-09-24 13:00:00	QQQ	ETF	41.881	42.01	41.8	41.87	7617133.0
2009-09-24 14:00:00	QQQ	ETF	41.87	42.05	41.82	42.03	10721118.0
2009-09-24 15:00:00	QQQ	ETF	42.03	42.16	41.9	42.08	21549238.0
2009-09-24 16:00:00	QQQ	ETF	42.08	42.12	41.76	41.81	10112659.0
2009-09-24 17:00:00	QQQ	ETF	41.81	41.83	41.73	41.76	270276.0
2009-09-24 18:00:00	QQQ	ETF	41.77	41.79	41.75	41.76	135683.0
2009-09-24 19:00:00	QQQ	ETF	41.76	41.76	41.69	41.72	65636.0
2009-09-24 07:00:00	IWM	ETF	61.4	61.59	61.4	61.58	15405.0
2009-09-24 08:00:00	IWM	ETF	61.58	61.86	61.5	61.78	752572.0
2009-09-24 09:00:00	IWM	ETF	61.78	61.8	61.25	61.4	5856864.0
2009-09-24 10:00:00	IWM	ETF	61.41	61.41	59.99	60.29	16408448.0
2009-09-24 11:00:00	IWM	ETF	60.29	60.52	60.07	60.17	6514796.0
2009-09-24 12:00:00	IWM	ETF	60.19	60.31	59.92	59.95	2801420.0
2009-09-24 13:00:00	IWM	ETF	59.95	60.23	59.86	59.97	4397870.0
2009-09-24 14:00:00	IWM	ETF	59.96	60.22	59.76	60.2	7383481.0
2009-09-24 15:00:00	IWM	ETF	60.21	60.42	60.1	60.2	11332820.0
2009-09-24 16:00:00	IWM	ETF	60.2	61.3098	60.02	60.05	4385395.0
2009-09-24 17:00:00	IWM	ETF	60.06	60.07	59.97	60.07	45449.0
2009-09-24 18:00:00	IWM	ETF	59.97	60.04	59.95	60.02	4300.0
2009-09-24 19:00:00	IWM	ETF	59.99	60.02	59.81	59.91	11900.0
2009-09-24 07:00:00	DIA	ETF	97.64	97.77	97.6	97.77	8900.0
2009-09-24 08:00:00	DIA	ETF	97.8	98.14	97.4	98.04	315864.0
2009-09-24 09:00:00	DIA	ETF	98.04	98.04	97.6994	97.86	1324921.0
2009-09-24 10:00:00	DIA	ETF	97.89	97.89	96.74	97.02	3564755.0
2009-09-24 11:00:00	DIA	ETF	97.02	97.19	96.78	96.91	1089649.0

> showing 50 of 4,534 rows — these rows as CSV

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