PREVIEW / futures_1hour / 2010-07-16

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-16.parquet
  size:    40 KB
  rows:    1,124

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
2010-07-16 00:00:00	ES	Futures	1069.61	1070.1	1067.16	1067.65	4977.0
2010-07-16 01:00:00	ES	Futures	1067.4	1067.89	1065.93	1066.91	5317.0
2010-07-16 02:00:00	ES	Futures	1066.91	1068.63	1066.66	1068.63	9157.0
2010-07-16 03:00:00	ES	Futures	1068.63	1071.57	1068.38	1070.1	28177.0
2010-07-16 04:00:00	ES	Futures	1069.85	1070.35	1067.16	1067.4	19303.0
2010-07-16 05:00:00	ES	Futures	1067.4	1072.8	1066.91	1072.06	19012.0
2010-07-16 06:00:00	ES	Futures	1071.82	1074.27	1071.57	1072.8	19543.0
2010-07-16 07:00:00	ES	Futures	1072.8	1074.52	1070.1	1070.84	32406.0
2010-07-16 08:00:00	ES	Futures	1070.84	1071.57	1067.4	1068.14	88305.0
2010-07-16 09:00:00	ES	Futures	1068.38	1068.87	1053.66	1055.38	420619.0
2010-07-16 10:00:00	ES	Futures	1055.38	1056.11	1050.72	1055.38	417582.0
2010-07-16 11:00:00	ES	Futures	1055.38	1056.11	1048.02	1048.51	247706.0
2010-07-16 12:00:00	ES	Futures	1048.51	1050.72	1046.05	1046.54	187999.0
2010-07-16 13:00:00	ES	Futures	1046.54	1049.24	1044.09	1045.32	199568.0
2010-07-16 14:00:00	ES	Futures	1045.07	1047.28	1043.35	1043.84	153519.0
2010-07-16 15:00:00	ES	Futures	1044.09	1045.32	1039.43	1041.88	456845.0
2010-07-16 16:00:00	ES	Futures	1041.88	1044.09	1041.39	1043.6	146161.0
2010-07-16 00:00:00	NQ	Futures	2120.02	2121.16	2112.56	2112.85	664.0
2010-07-16 01:00:00	NQ	Futures	2112.85	2113.42	2110.56	2111.71	784.0
2010-07-16 02:00:00	NQ	Futures	2111.99	2114.57	2110.85	2114.0	942.0
2010-07-16 03:00:00	NQ	Futures	2114.28	2120.59	2114.28	2117.72	2078.0
2010-07-16 04:00:00	NQ	Futures	2118.01	2118.01	2114.0	2114.28	1225.0
2010-07-16 05:00:00	NQ	Futures	2114.0	2122.59	2113.42	2122.02	1385.0
2010-07-16 06:00:00	NQ	Futures	2122.59	2126.89	2122.59	2124.89	1751.0
2010-07-16 07:00:00	NQ	Futures	2124.89	2127.18	2121.45	2122.59	2875.0
2010-07-16 08:00:00	NQ	Futures	2122.59	2124.6	2118.3	2118.87	8306.0
2010-07-16 09:00:00	NQ	Futures	2119.16	2120.3	2097.09	2099.96	66534.0
2010-07-16 10:00:00	NQ	Futures	2099.67	2100.53	2085.34	2093.65	68066.0
2010-07-16 11:00:00	NQ	Futures	2093.36	2095.08	2076.74	2077.6	47526.0
2010-07-16 12:00:00	NQ	Futures	2077.6	2082.19	2073.59	2075.88	34918.0
2010-07-16 13:00:00	NQ	Futures	2075.88	2085.63	2070.44	2073.88	48617.0
2010-07-16 14:00:00	NQ	Futures	2073.59	2078.18	2071.01	2073.02	30566.0
2010-07-16 15:00:00	NQ	Futures	2073.31	2076.17	2063.28	2065.85	63276.0
2010-07-16 16:00:00	NQ	Futures	2065.85	2068.72	2064.71	2065.57	13634.0
2010-07-16 00:00:00	YM	Futures	9722.6	9727.3	9707.5	9710.3	402.0
2010-07-16 01:00:00	YM	Futures	9709.3	9712.2	9698.0	9702.7	498.0
2010-07-16 02:00:00	YM	Futures	9703.7	9721.6	9703.7	9718.8	784.0
2010-07-16 03:00:00	YM	Futures	9718.8	9741.5	9718.8	9728.3	1438.0
2010-07-16 04:00:00	YM	Futures	9728.3	9730.2	9705.6	9708.4	952.0
2010-07-16 05:00:00	YM	Futures	9708.4	9750.0	9706.5	9741.5	1046.0
2010-07-16 06:00:00	YM	Futures	9742.5	9764.2	9742.5	9755.7	722.0
2010-07-16 07:00:00	YM	Futures	9753.8	9764.2	9730.2	9734.9	1377.0
2010-07-16 08:00:00	YM	Futures	9735.8	9745.3	9715.0	9719.8	5040.0
2010-07-16 09:00:00	YM	Futures	9719.8	9725.4	9599.5	9614.7	26585.0
2010-07-16 10:00:00	YM	Futures	9613.7	9619.4	9574.0	9613.7	29525.0
2010-07-16 11:00:00	YM	Futures	9613.7	9618.5	9560.7	9563.6	20252.0
2010-07-16 12:00:00	YM	Futures	9564.5	9582.5	9541.8	9548.4	15164.0
2010-07-16 13:00:00	YM	Futures	9548.4	9568.3	9525.7	9538.0	17610.0
2010-07-16 14:00:00	YM	Futures	9537.1	9551.3	9523.8	9528.5	12373.0
2010-07-16 15:00:00	YM	Futures	9529.5	9539.9	9490.7	9511.5	27896.0

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

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