PREVIEW / futures_1hour / 2008-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-18.parquet
  size:    37 KB
  rows:    1,013

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-18 00:00:00	ES	Futures	1155.8	1156.27	1154.64	1155.34	2202.0
2008-07-18 01:00:00	ES	Futures	1155.34	1155.57	1154.41	1155.57	2055.0
2008-07-18 02:00:00	ES	Futures	1155.34	1157.66	1153.94	1155.57	8056.0
2008-07-18 03:00:00	ES	Futures	1155.57	1161.84	1153.71	1159.75	21223.0
2008-07-18 04:00:00	ES	Futures	1159.75	1160.68	1157.66	1158.13	9540.0
2008-07-18 05:00:00	ES	Futures	1158.13	1159.06	1156.27	1158.13	11020.0
2008-07-18 06:00:00	ES	Futures	1157.89	1169.05	1157.43	1167.65	48151.0
2008-07-18 07:00:00	ES	Futures	1167.42	1172.3	1166.96	1170.21	58766.0
2008-07-18 08:00:00	ES	Futures	1170.21	1173.47	1168.82	1172.77	74812.0
2008-07-18 09:00:00	ES	Futures	1173.0	1173.93	1164.4	1166.03	355922.0
2008-07-18 10:00:00	ES	Futures	1166.03	1172.54	1164.17	1170.21	339056.0
2008-07-18 11:00:00	ES	Futures	1170.21	1174.16	1168.12	1169.05	253331.0
2008-07-18 12:00:00	ES	Futures	1168.82	1170.44	1164.17	1164.87	153552.0
2008-07-18 13:00:00	ES	Futures	1164.87	1169.98	1163.47	1167.89	141821.0
2008-07-18 14:00:00	ES	Futures	1168.12	1171.14	1165.33	1166.96	105873.0
2008-07-18 15:00:00	ES	Futures	1166.96	1173.0	1166.03	1170.68	191495.0
2008-07-18 16:00:00	ES	Futures	1170.68	1172.07	1169.51	1171.84	84191.0
2008-07-18 00:00:00	NQ	Futures	2054.53	2055.38	2050.6	2053.69	689.0
2008-07-18 01:00:00	NQ	Futures	2053.13	2053.97	2050.88	2051.72	329.0
2008-07-18 02:00:00	NQ	Futures	2051.72	2054.81	2049.75	2051.44	600.0
2008-07-18 03:00:00	NQ	Futures	2051.16	2061.0	2048.34	2058.47	2284.0
2008-07-18 04:00:00	NQ	Futures	2058.19	2059.03	2054.25	2055.1	1101.0
2008-07-18 05:00:00	NQ	Futures	2054.81	2055.1	2051.72	2053.13	1601.0
2008-07-18 06:00:00	NQ	Futures	2053.41	2071.41	2052.28	2070.0	4409.0
2008-07-18 07:00:00	NQ	Futures	2069.72	2075.35	2068.6	2071.41	4682.0
2008-07-18 08:00:00	NQ	Futures	2071.41	2079.85	2066.91	2072.54	11237.0
2008-07-18 09:00:00	NQ	Futures	2072.25	2074.79	2051.72	2055.66	80697.0
2008-07-18 10:00:00	NQ	Futures	2055.66	2063.82	2048.91	2056.78	79025.0
2008-07-18 11:00:00	NQ	Futures	2056.78	2071.41	2055.1	2064.94	54234.0
2008-07-18 12:00:00	NQ	Futures	2065.22	2066.35	2049.75	2050.88	41490.0
2008-07-18 13:00:00	NQ	Futures	2050.88	2059.6	2050.31	2053.41	36531.0
2008-07-18 14:00:00	NQ	Futures	2053.41	2059.03	2050.6	2055.1	29310.0
2008-07-18 15:00:00	NQ	Futures	2054.81	2062.97	2053.13	2056.78	55728.0
2008-07-18 16:00:00	NQ	Futures	2056.78	2058.19	2046.94	2057.06	17810.0
2008-07-18 00:00:00	YM	Futures	10289.4	10292.1	10279.4	10279.4	368.0
2008-07-18 01:00:00	YM	Futures	10282.1	10284.8	10276.6	10283.0	123.0
2008-07-18 02:00:00	YM	Futures	10282.1	10300.3	10273.9	10286.6	545.0
2008-07-18 03:00:00	YM	Futures	10286.6	10331.2	10273.9	10318.4	1010.0
2008-07-18 04:00:00	YM	Futures	10317.5	10327.5	10302.1	10308.5	655.0
2008-07-18 05:00:00	YM	Futures	10307.5	10312.1	10289.4	10304.8	891.0
2008-07-18 06:00:00	YM	Futures	10304.8	10387.5	10301.2	10379.3	2696.0
2008-07-18 07:00:00	YM	Futures	10378.4	10414.8	10377.5	10396.6	4133.0
2008-07-18 08:00:00	YM	Futures	10396.6	10418.4	10386.6	10410.2	3705.0
2008-07-18 09:00:00	YM	Futures	10412.1	10420.2	10328.4	10345.7	26640.0
2008-07-18 10:00:00	YM	Futures	10344.8	10411.2	10331.2	10393.9	33945.0
2008-07-18 11:00:00	YM	Futures	10393.0	10451.1	10383.0	10402.1	28464.0
2008-07-18 12:00:00	YM	Futures	10402.1	10417.5	10362.1	10366.6	16551.0
2008-07-18 13:00:00	YM	Futures	10367.5	10413.0	10360.3	10397.5	14361.0
2008-07-18 14:00:00	YM	Futures	10398.4	10424.8	10380.3	10390.2	14242.0
2008-07-18 15:00:00	YM	Futures	10390.2	10442.1	10382.1	10424.8	15201.0

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

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