PREVIEW / futures_1hour / 2009-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-30.parquet
  size:    39 KB
  rows:    1,066

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-10-30 00:00:00	ES	Futures	1028.23	1028.96	1027.75	1028.72	2439.0
2009-10-30 01:00:00	ES	Futures	1028.72	1029.44	1027.02	1027.26	3937.0
2009-10-30 02:00:00	ES	Futures	1027.02	1027.75	1026.54	1026.78	3271.0
2009-10-30 03:00:00	ES	Futures	1027.02	1027.26	1025.32	1025.81	10193.0
2009-10-30 04:00:00	ES	Futures	1025.57	1026.54	1022.9	1026.29	27554.0
2009-10-30 05:00:00	ES	Futures	1026.29	1027.99	1024.11	1025.08	29802.0
2009-10-30 06:00:00	ES	Futures	1024.84	1026.29	1024.36	1025.08	11943.0
2009-10-30 07:00:00	ES	Futures	1025.08	1025.81	1023.14	1024.84	23450.0
2009-10-30 08:00:00	ES	Futures	1024.84	1026.54	1023.63	1023.87	47308.0
2009-10-30 09:00:00	ES	Futures	1023.63	1028.72	1019.75	1021.69	380165.0
2009-10-30 10:00:00	ES	Futures	1021.69	1026.29	1018.78	1022.42	339039.0
2009-10-30 11:00:00	ES	Futures	1022.42	1022.66	1009.82	1012.49	432724.0
2009-10-30 12:00:00	ES	Futures	1012.49	1015.39	1000.86	1002.56	558723.0
2009-10-30 13:00:00	ES	Futures	1002.56	1006.92	998.92	1001.83	337192.0
2009-10-30 14:00:00	ES	Futures	1001.83	1008.13	1000.38	1003.04	332006.0
2009-10-30 15:00:00	ES	Futures	1003.04	1005.95	997.47	999.41	633965.0
2009-10-30 16:00:00	ES	Futures	999.65	1000.86	997.47	1000.13	163826.0
2009-10-30 00:00:00	NQ	Futures	1948.16	1949.02	1947.59	1948.73	110.0
2009-10-30 01:00:00	NQ	Futures	1949.02	1950.16	1945.59	1945.88	298.0
2009-10-30 02:00:00	NQ	Futures	1945.88	1946.74	1945.02	1945.59	182.0
2009-10-30 03:00:00	NQ	Futures	1945.88	1946.45	1943.03	1943.88	599.0
2009-10-30 04:00:00	NQ	Futures	1943.6	1947.02	1940.46	1947.02	3514.0
2009-10-30 05:00:00	NQ	Futures	1947.02	1949.59	1943.31	1944.45	2337.0
2009-10-30 06:00:00	NQ	Futures	1944.74	1947.59	1944.17	1946.16	1169.0
2009-10-30 07:00:00	NQ	Futures	1946.16	1947.02	1941.6	1945.02	1841.0
2009-10-30 08:00:00	NQ	Futures	1944.45	1948.73	1943.6	1944.45	4378.0
2009-10-30 09:00:00	NQ	Futures	1944.45	1952.72	1937.61	1943.31	57313.0
2009-10-30 10:00:00	NQ	Futures	1943.6	1951.58	1939.04	1946.16	46533.0
2009-10-30 11:00:00	NQ	Futures	1945.88	1946.45	1914.51	1920.78	60706.0
2009-10-30 12:00:00	NQ	Futures	1920.5	1925.06	1899.68	1903.39	79488.0
2009-10-30 13:00:00	NQ	Futures	1903.39	1910.8	1896.83	1904.24	46230.0
2009-10-30 14:00:00	NQ	Futures	1904.53	1913.65	1900.25	1906.81	41947.0
2009-10-30 15:00:00	NQ	Futures	1906.52	1910.8	1895.4	1897.11	87205.0
2009-10-30 16:00:00	NQ	Futures	1897.11	1898.54	1893.69	1896.54	16850.0
2009-10-30 00:00:00	YM	Futures	9207.9	9212.5	9203.2	9209.8	201.0
2009-10-30 01:00:00	YM	Futures	9209.8	9215.3	9198.6	9198.6	271.0
2009-10-30 02:00:00	YM	Futures	9198.6	9203.2	9194.9	9197.7	121.0
2009-10-30 03:00:00	YM	Futures	9197.7	9201.4	9190.2	9193.0	888.0
2009-10-30 04:00:00	YM	Futures	9192.1	9194.9	9162.3	9193.0	2666.0
2009-10-30 05:00:00	YM	Futures	9193.0	9204.2	9176.3	9181.9	1868.0
2009-10-30 06:00:00	YM	Futures	9181.9	9191.2	9178.1	9184.6	687.0
2009-10-30 07:00:00	YM	Futures	9183.7	9190.2	9168.8	9182.8	1455.0
2009-10-30 08:00:00	YM	Futures	9182.8	9195.8	9172.6	9172.6	2610.0
2009-10-30 09:00:00	YM	Futures	9172.6	9218.1	9127.9	9145.6	37048.0
2009-10-30 10:00:00	YM	Futures	9144.6	9181.9	9128.8	9157.7	35765.0
2009-10-30 11:00:00	YM	Futures	9158.6	9161.4	9057.2	9080.5	43436.0
2009-10-30 12:00:00	YM	Futures	9079.5	9098.1	8982.8	9001.4	53295.0
2009-10-30 13:00:00	YM	Futures	8999.5	9033.0	8962.3	8993.0	30069.0
2009-10-30 14:00:00	YM	Futures	8992.1	9037.7	8980.0	9005.1	25740.0
2009-10-30 15:00:00	YM	Futures	9004.2	9032.1	8959.5	8980.0	43239.0

> showing 50 of 1,066 rows — these rows as CSV

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