PREVIEW / futures_1hour / 2008-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-25.parquet
  size:    36 KB
  rows:    1,000

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-07-25 00:00:00	ES	Futures	1163.24	1163.7	1162.77	1163.24	2123.0
2008-07-25 01:00:00	ES	Futures	1163.47	1163.94	1162.54	1163.94	1752.0
2008-07-25 02:00:00	ES	Futures	1163.94	1164.87	1162.54	1162.77	5876.0
2008-07-25 03:00:00	ES	Futures	1162.77	1165.33	1161.38	1164.4	20454.0
2008-07-25 04:00:00	ES	Futures	1164.4	1167.89	1164.17	1165.8	15087.0
2008-07-25 05:00:00	ES	Futures	1165.8	1165.8	1161.84	1164.17	13400.0
2008-07-25 06:00:00	ES	Futures	1164.17	1166.49	1163.01	1163.47	7255.0
2008-07-25 07:00:00	ES	Futures	1163.47	1168.82	1163.24	1167.65	20830.0
2008-07-25 08:00:00	ES	Futures	1167.65	1171.37	1166.26	1168.82	52319.0
2008-07-25 09:00:00	ES	Futures	1168.82	1171.37	1164.17	1170.68	242785.0
2008-07-25 10:00:00	ES	Futures	1170.91	1173.93	1166.49	1173.23	344246.0
2008-07-25 11:00:00	ES	Futures	1173.0	1173.47	1168.58	1169.75	146794.0
2008-07-25 12:00:00	ES	Futures	1169.51	1170.68	1167.19	1170.44	101039.0
2008-07-25 13:00:00	ES	Futures	1170.21	1171.61	1163.24	1166.26	206229.0
2008-07-25 14:00:00	ES	Futures	1166.26	1169.98	1166.03	1169.51	164044.0
2008-07-25 15:00:00	ES	Futures	1169.51	1169.98	1164.17	1167.89	173987.0
2008-07-25 16:00:00	ES	Futures	1167.89	1168.58	1164.87	1165.56	66469.0
2008-07-25 00:00:00	NQ	Futures	2044.97	2045.25	2042.44	2045.25	702.0
2008-07-25 01:00:00	NQ	Futures	2044.69	2046.66	2043.84	2045.81	1013.0
2008-07-25 02:00:00	NQ	Futures	2046.38	2048.63	2044.41	2044.41	292.0
2008-07-25 03:00:00	NQ	Futures	2044.41	2052.56	2044.13	2052.0	2490.0
2008-07-25 04:00:00	NQ	Futures	2052.0	2057.91	2051.44	2052.28	1970.0
2008-07-25 05:00:00	NQ	Futures	2052.0	2052.28	2043.84	2047.78	716.0
2008-07-25 06:00:00	NQ	Futures	2047.5	2050.03	2044.13	2044.41	978.0
2008-07-25 07:00:00	NQ	Futures	2044.41	2056.78	2044.41	2055.94	2490.0
2008-07-25 08:00:00	NQ	Futures	2055.66	2063.53	2052.85	2058.75	6998.0
2008-07-25 09:00:00	NQ	Futures	2059.03	2069.72	2052.0	2066.35	43415.0
2008-07-25 10:00:00	NQ	Futures	2065.78	2079.85	2064.1	2078.44	62262.0
2008-07-25 11:00:00	NQ	Futures	2078.72	2080.13	2069.16	2075.07	31812.0
2008-07-25 12:00:00	NQ	Futures	2074.5	2075.63	2066.63	2073.38	20673.0
2008-07-25 13:00:00	NQ	Futures	2072.82	2077.04	2066.07	2071.97	31843.0
2008-07-25 14:00:00	NQ	Futures	2071.69	2085.48	2070.57	2084.35	34093.0
2008-07-25 15:00:00	NQ	Futures	2084.35	2085.48	2073.94	2078.44	40564.0
2008-07-25 16:00:00	NQ	Futures	2078.44	2078.72	2070.29	2070.29	9740.0
2008-07-25 00:00:00	YM	Futures	10300.3	10301.2	10292.1	10300.3	191.0
2008-07-25 01:00:00	YM	Futures	10299.4	10303.0	10294.8	10303.0	97.0
2008-07-25 02:00:00	YM	Futures	10304.8	10312.1	10293.0	10293.9	270.0
2008-07-25 03:00:00	YM	Futures	10293.9	10312.1	10281.2	10304.8	743.0
2008-07-25 04:00:00	YM	Futures	10303.9	10332.1	10302.1	10312.1	1041.0
2008-07-25 05:00:00	YM	Futures	10310.3	10311.2	10286.6	10304.8	737.0
2008-07-25 06:00:00	YM	Futures	10304.8	10320.3	10298.5	10299.4	890.0
2008-07-25 07:00:00	YM	Futures	10298.5	10334.8	10298.5	10326.6	779.0
2008-07-25 08:00:00	YM	Futures	10326.6	10358.4	10314.8	10340.3	3245.0
2008-07-25 09:00:00	YM	Futures	10341.2	10358.4	10298.5	10357.5	20838.0
2008-07-25 10:00:00	YM	Futures	10356.6	10385.7	10321.2	10373.0	32547.0
2008-07-25 11:00:00	YM	Futures	10373.9	10378.4	10326.6	10331.2	17591.0
2008-07-25 12:00:00	YM	Futures	10329.4	10339.4	10304.8	10333.9	13806.0
2008-07-25 13:00:00	YM	Futures	10334.8	10347.5	10274.8	10301.2	26192.0
2008-07-25 14:00:00	YM	Futures	10301.2	10337.5	10298.5	10331.2	20567.0
2008-07-25 15:00:00	YM	Futures	10331.2	10335.7	10276.6	10311.2	19519.0

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

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