PREVIEW / futures_1hour / 2008-10-07

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-10-07.parquet
  size:    47 KB
  rows:    1,323

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-10-07 00:00:00	ES	Futures	1010.26	1012.86	1007.18	1010.97	8045.0
2008-10-07 01:00:00	ES	Futures	1010.97	1012.86	1010.26	1011.44	3967.0
2008-10-07 02:00:00	ES	Futures	1011.44	1014.28	1008.36	1013.33	17113.0
2008-10-07 03:00:00	ES	Futures	1013.1	1018.3	1007.18	1007.65	62514.0
2008-10-07 04:00:00	ES	Futures	1007.65	1009.07	989.67	996.06	64662.0
2008-10-07 05:00:00	ES	Futures	995.82	998.66	992.75	996.53	19297.0
2008-10-07 06:00:00	ES	Futures	996.53	1009.55	996.53	1009.07	35629.0
2008-10-07 07:00:00	ES	Futures	1009.31	1010.02	1002.92	1009.07	30043.0
2008-10-07 08:00:00	ES	Futures	1009.07	1015.23	988.25	992.75	133613.0
2008-10-07 09:00:00	ES	Futures	992.75	1020.43	992.75	1005.29	631366.0
2008-10-07 10:00:00	ES	Futures	1005.52	1012.86	995.59	1004.81	538710.0
2008-10-07 11:00:00	ES	Futures	1004.58	1006.71	993.22	1000.55	347480.0
2008-10-07 12:00:00	ES	Futures	1000.32	1001.03	980.2	984.23	348889.0
2008-10-07 13:00:00	ES	Futures	984.23	993.46	963.87	964.82	532958.0
2008-10-07 14:00:00	ES	Futures	964.82	986.83	961.74	970.97	549011.0
2008-10-07 15:00:00	ES	Futures	970.97	972.63	946.13	947.31	716625.0
2008-10-07 16:00:00	ES	Futures	947.55	955.59	946.84	951.57	195893.0
2008-10-07 17:00:00	ES	Futures	951.57	952.99	948.97	952.51	8706.0
2008-10-07 18:00:00	ES	Futures	951.33	955.59	950.62	953.22	7681.0
2008-10-07 19:00:00	ES	Futures	953.22	953.22	944.71	946.36	10163.0
2008-10-07 20:00:00	ES	Futures	946.36	953.93	946.13	952.28	9038.0
2008-10-07 21:00:00	ES	Futures	952.28	954.41	949.2	953.22	5108.0
2008-10-07 22:00:00	ES	Futures	953.22	956.54	952.51	953.7	5535.0
2008-10-07 23:00:00	ES	Futures	953.7	955.59	950.86	952.28	4074.0
2008-10-07 00:00:00	NQ	Futures	1612.89	1614.31	1611.19	1612.33	538.0
2008-10-07 01:00:00	NQ	Futures	1612.04	1614.59	1611.19	1614.59	226.0
2008-10-07 02:00:00	NQ	Futures	1614.31	1616.85	1608.93	1616.29	989.0
2008-10-07 03:00:00	NQ	Futures	1616.0	1618.27	1609.78	1610.63	3315.0
2008-10-07 04:00:00	NQ	Futures	1610.91	1614.87	1588.27	1596.2	4376.0
2008-10-07 05:00:00	NQ	Futures	1595.06	1603.84	1591.1	1594.22	1788.0
2008-10-07 06:00:00	NQ	Futures	1594.22	1612.33	1593.37	1611.76	1812.0
2008-10-07 07:00:00	NQ	Futures	1611.76	1616.85	1608.36	1615.44	3450.0
2008-10-07 08:00:00	NQ	Futures	1615.72	1617.7	1575.26	1585.73	11951.0
2008-10-07 09:00:00	NQ	Futures	1586.01	1629.87	1585.16	1594.78	82028.0
2008-10-07 10:00:00	NQ	Futures	1594.78	1615.44	1579.22	1599.31	92106.0
2008-10-07 11:00:00	NQ	Futures	1599.59	1601.57	1582.9	1595.06	52328.0
2008-10-07 12:00:00	NQ	Futures	1595.06	1595.35	1559.41	1568.75	56383.0
2008-10-07 13:00:00	NQ	Futures	1568.47	1587.71	1532.81	1534.51	79911.0
2008-10-07 14:00:00	NQ	Futures	1534.79	1573.56	1529.42	1544.13	77572.0
2008-10-07 15:00:00	NQ	Futures	1543.85	1548.94	1509.33	1513.01	87923.0
2008-10-07 16:00:00	NQ	Futures	1513.01	1520.93	1507.91	1511.87	27713.0
2008-10-07 17:00:00	NQ	Futures	1512.16	1512.16	1506.21	1511.59	877.0
2008-10-07 18:00:00	NQ	Futures	1511.31	1517.25	1507.35	1512.44	535.0
2008-10-07 19:00:00	NQ	Futures	1512.44	1512.44	1500.84	1504.23	583.0
2008-10-07 20:00:00	NQ	Futures	1504.52	1516.4	1504.52	1515.55	494.0
2008-10-07 21:00:00	NQ	Futures	1515.83	1518.66	1512.44	1516.12	246.0
2008-10-07 22:00:00	NQ	Futures	1516.68	1522.06	1516.68	1519.23	233.0
2008-10-07 23:00:00	NQ	Futures	1519.23	1520.93	1513.29	1516.68	146.0
2008-10-07 00:00:00	YM	Futures	9178.9	9194.3	9158.9	9173.4	613.0
2008-10-07 01:00:00	YM	Futures	9177.0	9197.1	9173.4	9184.3	246.0

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

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