PREVIEW / futures_1hour / 2010-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-04.parquet
  size:    40 KB
  rows:    1,109

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-06-04 00:00:00	ES	Futures	1077.43	1077.92	1076.45	1077.92	2578.0
2010-06-04 01:00:00	ES	Futures	1077.92	1078.41	1076.21	1076.94	3210.0
2010-06-04 02:00:00	ES	Futures	1076.94	1078.41	1076.45	1078.16	5400.0
2010-06-04 03:00:00	ES	Futures	1078.16	1080.12	1077.92	1079.63	24312.0
2010-06-04 04:00:00	ES	Futures	1079.63	1082.08	1079.14	1081.1	23354.0
2010-06-04 05:00:00	ES	Futures	1080.85	1083.05	1080.61	1081.1	19132.0
2010-06-04 06:00:00	ES	Futures	1081.1	1081.1	1075.72	1076.45	41095.0
2010-06-04 07:00:00	ES	Futures	1076.45	1076.7	1067.17	1068.39	119309.0
2010-06-04 08:00:00	ES	Futures	1068.39	1072.05	1052.5	1057.14	329965.0
2010-06-04 09:00:00	ES	Futures	1057.14	1062.03	1053.72	1060.32	397037.0
2010-06-04 10:00:00	ES	Futures	1060.32	1063.74	1057.39	1059.1	384569.0
2010-06-04 11:00:00	ES	Futures	1058.85	1060.81	1053.23	1055.19	286295.0
2010-06-04 12:00:00	ES	Futures	1055.19	1055.19	1049.81	1054.7	238147.0
2010-06-04 13:00:00	ES	Futures	1054.7	1055.19	1047.37	1048.34	192794.0
2010-06-04 14:00:00	ES	Futures	1048.34	1050.3	1039.3	1040.28	358971.0
2010-06-04 15:00:00	ES	Futures	1040.28	1044.92	1035.63	1041.01	562046.0
2010-06-04 16:00:00	ES	Futures	1041.01	1043.7	1039.79	1042.23	144201.0
2010-06-04 00:00:00	NQ	Futures	2168.99	2170.7	2167.27	2170.7	304.0
2010-06-04 01:00:00	NQ	Futures	2170.99	2171.56	2167.27	2168.99	323.0
2010-06-04 02:00:00	NQ	Futures	2168.99	2170.99	2168.41	2170.13	506.0
2010-06-04 03:00:00	NQ	Futures	2170.42	2175.0	2169.56	2174.71	2732.0
2010-06-04 04:00:00	NQ	Futures	2174.71	2179.3	2174.14	2177.58	1902.0
2010-06-04 05:00:00	NQ	Futures	2177.29	2181.59	2177.0	2178.44	1228.0
2010-06-04 06:00:00	NQ	Futures	2178.44	2178.44	2167.84	2168.41	1653.0
2010-06-04 07:00:00	NQ	Futures	2168.41	2169.27	2147.22	2150.66	14033.0
2010-06-04 08:00:00	NQ	Futures	2150.94	2158.96	2121.73	2127.75	24973.0
2010-06-04 09:00:00	NQ	Futures	2128.03	2148.94	2119.73	2144.64	59709.0
2010-06-04 10:00:00	NQ	Futures	2144.64	2153.24	2139.49	2140.92	50956.0
2010-06-04 11:00:00	NQ	Futures	2140.92	2145.22	2129.47	2134.62	33603.0
2010-06-04 12:00:00	NQ	Futures	2134.91	2134.91	2122.02	2129.47	28145.0
2010-06-04 13:00:00	NQ	Futures	2129.75	2130.33	2110.57	2112.57	33235.0
2010-06-04 14:00:00	NQ	Futures	2112.86	2117.15	2097.39	2098.54	57084.0
2010-06-04 15:00:00	NQ	Futures	2098.54	2105.41	2089.66	2098.25	92824.0
2010-06-04 16:00:00	NQ	Futures	2098.25	2103.69	2097.11	2101.12	17966.0
2010-06-04 00:00:00	YM	Futures	9635.6	9644.1	9630.9	9640.3	167.0
2010-06-04 01:00:00	YM	Futures	9643.2	9645.0	9630.9	9635.6	445.0
2010-06-04 02:00:00	YM	Futures	9635.6	9646.0	9632.8	9643.2	315.0
2010-06-04 03:00:00	YM	Futures	9644.1	9657.3	9642.2	9655.4	1628.0
2010-06-04 04:00:00	YM	Futures	9654.5	9672.3	9653.5	9664.8	1024.0
2010-06-04 05:00:00	YM	Futures	9663.9	9679.9	9661.0	9665.7	852.0
2010-06-04 06:00:00	YM	Futures	9663.9	9664.8	9625.3	9630.0	1657.0
2010-06-04 07:00:00	YM	Futures	9629.0	9630.9	9561.3	9569.8	6629.0
2010-06-04 08:00:00	YM	Futures	9569.8	9597.1	9446.5	9483.2	14672.0
2010-06-04 09:00:00	YM	Futures	9483.2	9503.0	9447.4	9481.3	27301.0
2010-06-04 10:00:00	YM	Futures	9482.3	9500.1	9456.8	9465.3	26015.0
2010-06-04 11:00:00	YM	Futures	9464.4	9476.6	9417.3	9435.2	20580.0
2010-06-04 12:00:00	YM	Futures	9434.3	9437.1	9391.0	9434.3	15449.0
2010-06-04 13:00:00	YM	Futures	9434.3	9437.1	9385.3	9394.7	12429.0
2010-06-04 14:00:00	YM	Futures	9395.7	9411.7	9322.3	9330.8	22620.0
2010-06-04 15:00:00	YM	Futures	9329.8	9369.3	9296.9	9341.1	33204.0

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

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