PREVIEW / futures_1hour / 2008-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-01.parquet
  size:    36 KB
  rows:    994

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-08-01 00:00:00	ES	Futures	1175.79	1176.72	1175.56	1176.25	869.0
2008-08-01 01:00:00	ES	Futures	1176.25	1177.18	1175.56	1176.72	611.0
2008-08-01 02:00:00	ES	Futures	1176.49	1178.35	1175.09	1177.42	5714.0
2008-08-01 03:00:00	ES	Futures	1177.65	1179.28	1176.72	1179.04	12323.0
2008-08-01 04:00:00	ES	Futures	1179.04	1179.97	1178.58	1179.04	6999.0
2008-08-01 05:00:00	ES	Futures	1179.04	1181.13	1178.58	1180.67	9377.0
2008-08-01 06:00:00	ES	Futures	1180.67	1182.3	1180.67	1180.9	14338.0
2008-08-01 07:00:00	ES	Futures	1181.13	1181.13	1174.63	1176.49	31540.0
2008-08-01 08:00:00	ES	Futures	1176.72	1185.32	1176.25	1182.3	120355.0
2008-08-01 09:00:00	ES	Futures	1182.06	1182.99	1169.28	1172.07	300115.0
2008-08-01 10:00:00	ES	Futures	1172.07	1174.16	1164.87	1172.07	410855.0
2008-08-01 11:00:00	ES	Futures	1172.07	1174.63	1168.58	1173.0	187965.0
2008-08-01 12:00:00	ES	Futures	1173.0	1173.47	1165.56	1166.49	155821.0
2008-08-01 13:00:00	ES	Futures	1166.49	1174.39	1166.03	1171.84	135806.0
2008-08-01 14:00:00	ES	Futures	1171.84	1173.0	1167.42	1172.3	147295.0
2008-08-01 15:00:00	ES	Futures	1172.3	1175.79	1168.58	1171.14	233723.0
2008-08-01 16:00:00	ES	Futures	1171.14	1172.3	1169.51	1170.91	68303.0
2008-08-01 00:00:00	NQ	Futures	2078.44	2079.29	2077.32	2078.72	52.0
2008-08-01 01:00:00	NQ	Futures	2079.01	2080.69	2078.72	2080.69	141.0
2008-08-01 02:00:00	NQ	Futures	2080.13	2083.22	2077.04	2081.82	474.0
2008-08-01 03:00:00	NQ	Futures	2081.82	2083.22	2079.29	2082.94	1203.0
2008-08-01 04:00:00	NQ	Futures	2082.66	2084.07	2082.1	2082.38	502.0
2008-08-01 05:00:00	NQ	Futures	2082.94	2086.6	2080.97	2086.04	530.0
2008-08-01 06:00:00	NQ	Futures	2086.04	2092.23	2086.04	2090.54	1200.0
2008-08-01 07:00:00	NQ	Futures	2090.54	2091.66	2079.57	2080.97	4776.0
2008-08-01 08:00:00	NQ	Futures	2080.69	2096.45	2077.04	2093.07	12897.0
2008-08-01 09:00:00	NQ	Futures	2093.07	2093.35	2032.87	2045.53	109196.0
2008-08-01 10:00:00	NQ	Futures	2045.81	2057.06	2033.72	2054.25	104290.0
2008-08-01 11:00:00	NQ	Futures	2054.25	2061.85	2044.13	2061.0	45238.0
2008-08-01 12:00:00	NQ	Futures	2061.0	2061.57	2044.41	2046.94	36095.0
2008-08-01 13:00:00	NQ	Futures	2046.94	2064.94	2045.81	2059.03	34556.0
2008-08-01 14:00:00	NQ	Futures	2059.03	2064.1	2050.88	2061.57	39573.0
2008-08-01 15:00:00	NQ	Futures	2061.85	2068.04	2055.1	2056.5	49400.0
2008-08-01 16:00:00	NQ	Futures	2056.78	2062.69	2053.41	2061.85	11892.0
2008-08-01 00:00:00	YM	Futures	10312.1	10315.7	10309.4	10311.2	69.0
2008-08-01 01:00:00	YM	Futures	10309.4	10317.5	10309.4	10317.5	64.0
2008-08-01 02:00:00	YM	Futures	10315.7	10329.4	10302.1	10324.8	310.0
2008-08-01 03:00:00	YM	Futures	10326.6	10340.3	10313.9	10339.4	1178.0
2008-08-01 04:00:00	YM	Futures	10339.4	10346.6	10334.8	10341.2	577.0
2008-08-01 05:00:00	YM	Futures	10340.3	10353.0	10334.8	10352.1	975.0
2008-08-01 06:00:00	YM	Futures	10352.1	10369.3	10351.2	10367.5	1019.0
2008-08-01 07:00:00	YM	Futures	10365.7	10365.7	10303.0	10323.9	2090.0
2008-08-01 08:00:00	YM	Futures	10323.0	10395.7	10307.5	10374.8	9836.0
2008-08-01 09:00:00	YM	Futures	10375.7	10381.2	10268.5	10293.9	27309.0
2008-08-01 10:00:00	YM	Futures	10293.0	10313.9	10218.5	10276.6	47241.0
2008-08-01 11:00:00	YM	Futures	10277.5	10297.5	10245.7	10283.0	24278.0
2008-08-01 12:00:00	YM	Futures	10282.1	10285.7	10232.1	10235.7	21380.0
2008-08-01 13:00:00	YM	Futures	10234.8	10305.7	10234.8	10283.9	20211.0
2008-08-01 14:00:00	YM	Futures	10283.9	10291.2	10247.6	10283.0	22341.0
2008-08-01 15:00:00	YM	Futures	10283.9	10318.4	10251.2	10280.3	24837.0

> showing 50 of 994 rows — these rows as CSV

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