PREVIEW / futures_1hour / 2008-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-23.parquet
  size:    40 KB
  rows:    1,176

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-06-23 00:00:00	ES	Futures	1230.17	1232.5	1229.94	1232.03	3865.0
2008-06-23 01:00:00	ES	Futures	1232.27	1232.73	1231.1	1231.57	2019.0
2008-06-23 02:00:00	ES	Futures	1231.34	1231.57	1230.41	1230.87	4876.0
2008-06-23 03:00:00	ES	Futures	1230.64	1233.66	1230.64	1231.34	15539.0
2008-06-23 04:00:00	ES	Futures	1231.34	1232.27	1229.24	1229.48	9080.0
2008-06-23 05:00:00	ES	Futures	1229.71	1230.64	1226.92	1230.17	11523.0
2008-06-23 06:00:00	ES	Futures	1230.17	1232.73	1229.94	1230.87	10250.0
2008-06-23 07:00:00	ES	Futures	1230.87	1231.1	1227.39	1227.85	14212.0
2008-06-23 08:00:00	ES	Futures	1228.08	1233.89	1228.08	1233.43	44304.0
2008-06-23 09:00:00	ES	Futures	1233.66	1234.36	1226.69	1227.85	226414.0
2008-06-23 10:00:00	ES	Futures	1228.08	1230.87	1224.83	1227.62	266209.0
2008-06-23 11:00:00	ES	Futures	1227.39	1228.32	1223.67	1227.15	195095.0
2008-06-23 12:00:00	ES	Futures	1227.15	1228.08	1224.13	1227.62	115146.0
2008-06-23 13:00:00	ES	Futures	1227.62	1230.87	1225.99	1229.48	136412.0
2008-06-23 14:00:00	ES	Futures	1229.48	1230.64	1225.99	1227.15	124071.0
2008-06-23 15:00:00	ES	Futures	1227.15	1227.62	1224.6	1227.15	180913.0
2008-06-23 16:00:00	ES	Futures	1227.15	1227.39	1222.04	1224.36	85281.0
2008-06-23 17:00:00	ES	Futures	1224.36	1225.29	1223.9	1224.83	2567.0
2008-06-23 18:00:00	ES	Futures	1224.83	1224.83	1223.9	1223.9	818.0
2008-06-23 19:00:00	ES	Futures	1224.13	1224.83	1223.9	1224.13	572.0
2008-06-23 20:00:00	ES	Futures	1224.36	1224.36	1223.67	1223.67	1346.0
2008-06-23 21:00:00	ES	Futures	1223.67	1225.99	1223.67	1225.76	1528.0
2008-06-23 22:00:00	ES	Futures	1225.76	1225.99	1225.29	1225.29	512.0
2008-06-23 23:00:00	ES	Futures	1225.53	1225.99	1224.83	1225.29	498.0
2008-06-23 00:00:00	NQ	Futures	2190.11	2193.49	2189.55	2192.36	286.0
2008-06-23 01:00:00	NQ	Futures	2192.65	2194.62	2191.52	2192.08	234.0
2008-06-23 02:00:00	NQ	Futures	2192.08	2192.08	2188.71	2190.96	230.0
2008-06-23 03:00:00	NQ	Futures	2190.96	2196.3	2190.96	2192.08	1205.0
2008-06-23 04:00:00	NQ	Futures	2191.8	2193.49	2188.43	2188.99	872.0
2008-06-23 05:00:00	NQ	Futures	2189.27	2190.11	2182.8	2188.99	1139.0
2008-06-23 06:00:00	NQ	Futures	2189.27	2194.62	2188.43	2192.36	804.0
2008-06-23 07:00:00	NQ	Futures	2191.8	2192.65	2182.52	2184.21	3385.0
2008-06-23 08:00:00	NQ	Futures	2184.21	2194.05	2184.21	2192.36	6363.0
2008-06-23 09:00:00	NQ	Futures	2192.93	2194.62	2174.64	2177.18	47567.0
2008-06-23 10:00:00	NQ	Futures	2177.46	2184.49	2163.39	2169.02	65554.0
2008-06-23 11:00:00	NQ	Futures	2168.74	2172.67	2159.17	2172.39	49884.0
2008-06-23 12:00:00	NQ	Futures	2172.67	2173.8	2163.11	2172.11	28831.0
2008-06-23 13:00:00	NQ	Futures	2172.11	2185.61	2167.89	2179.14	38658.0
2008-06-23 14:00:00	NQ	Futures	2178.86	2185.05	2172.67	2176.05	37095.0
2008-06-23 15:00:00	NQ	Futures	2176.05	2176.61	2160.58	2162.27	48758.0
2008-06-23 16:00:00	NQ	Futures	2161.99	2162.55	2147.92	2155.8	17753.0
2008-06-23 17:00:00	NQ	Futures	2155.8	2158.05	2155.52	2157.2	278.0
2008-06-23 18:00:00	NQ	Futures	2158.05	2158.05	2155.8	2155.8	73.0
2008-06-23 19:00:00	NQ	Futures	2155.8	2157.49	2155.23	2157.49	27.0
2008-06-23 20:00:00	NQ	Futures	2156.92	2157.49	2156.36	2156.92	30.0
2008-06-23 21:00:00	NQ	Futures	2157.2	2158.33	2157.2	2158.05	183.0
2008-06-23 22:00:00	NQ	Futures	2158.05	2158.61	2156.64	2158.05	93.0
2008-06-23 23:00:00	NQ	Futures	2158.05	2158.61	2156.08	2156.08	82.0
2008-06-23 00:00:00	YM	Futures	10798.3	10812.9	10797.4	10809.2	244.0
2008-06-23 01:00:00	YM	Futures	10809.2	10811.1	10802.0	10804.7	205.0

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

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