PREVIEW / futures_1hour / 2010-08-06

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-06.parquet
  size:    39 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-08-06 00:00:00	ES	Futures	1104.45	1104.7	1103.47	1103.96	1494.0
2010-08-06 01:00:00	ES	Futures	1103.96	1104.45	1103.47	1104.21	1879.0
2010-08-06 02:00:00	ES	Futures	1103.96	1104.94	1103.47	1103.96	5757.0
2010-08-06 03:00:00	ES	Futures	1104.21	1105.68	1103.23	1104.21	20645.0
2010-08-06 04:00:00	ES	Futures	1104.21	1104.7	1103.23	1103.72	13532.0
2010-08-06 05:00:00	ES	Futures	1103.72	1103.96	1101.75	1103.47	14337.0
2010-08-06 06:00:00	ES	Futures	1103.47	1104.21	1101.75	1103.72	13576.0
2010-08-06 07:00:00	ES	Futures	1103.96	1105.68	1102.98	1105.19	29384.0
2010-08-06 08:00:00	ES	Futures	1105.19	1106.17	1090.71	1092.92	255662.0
2010-08-06 09:00:00	ES	Futures	1092.67	1099.79	1090.71	1099.05	330070.0
2010-08-06 10:00:00	ES	Futures	1099.05	1099.79	1084.82	1085.8	418682.0
2010-08-06 11:00:00	ES	Futures	1086.05	1088.75	1083.35	1086.79	261979.0
2010-08-06 12:00:00	ES	Futures	1086.79	1087.77	1085.31	1086.54	94178.0
2010-08-06 13:00:00	ES	Futures	1086.54	1088.01	1085.31	1086.79	120216.0
2010-08-06 14:00:00	ES	Futures	1086.79	1094.15	1085.56	1093.41	195617.0
2010-08-06 15:00:00	ES	Futures	1093.41	1098.56	1092.18	1097.83	301318.0
2010-08-06 16:00:00	ES	Futures	1097.83	1099.3	1097.34	1099.05	76610.0
2010-08-06 00:00:00	NQ	Futures	2183.63	2184.49	2181.63	2182.49	65.0
2010-08-06 01:00:00	NQ	Futures	2182.49	2183.63	2181.91	2183.63	26.0
2010-08-06 02:00:00	NQ	Futures	2183.35	2184.78	2182.49	2182.77	454.0
2010-08-06 03:00:00	NQ	Futures	2183.06	2186.79	2181.91	2183.63	1575.0
2010-08-06 04:00:00	NQ	Futures	2183.63	2184.21	2180.48	2182.2	1104.0
2010-08-06 05:00:00	NQ	Futures	2182.2	2182.2	2177.04	2181.34	1284.0
2010-08-06 06:00:00	NQ	Futures	2181.05	2182.49	2178.47	2181.63	901.0
2010-08-06 07:00:00	NQ	Futures	2181.91	2184.78	2180.48	2183.63	1474.0
2010-08-06 08:00:00	NQ	Futures	2183.63	2186.5	2155.84	2160.13	20950.0
2010-08-06 09:00:00	NQ	Futures	2159.85	2181.05	2156.41	2180.77	62600.0
2010-08-06 10:00:00	NQ	Futures	2180.48	2183.06	2147.53	2150.1	80919.0
2010-08-06 11:00:00	NQ	Futures	2150.1	2160.42	2144.95	2156.98	51220.0
2010-08-06 12:00:00	NQ	Futures	2156.98	2159.56	2151.82	2157.56	24748.0
2010-08-06 13:00:00	NQ	Futures	2157.56	2161.28	2154.69	2158.7	23638.0
2010-08-06 14:00:00	NQ	Futures	2158.42	2174.75	2155.26	2173.6	39279.0
2010-08-06 15:00:00	NQ	Futures	2173.6	2181.34	2169.59	2178.47	52949.0
2010-08-06 16:00:00	NQ	Futures	2178.47	2184.49	2177.62	2184.21	8793.0
2010-08-06 00:00:00	YM	Futures	10077.6	10080.4	10070.0	10073.8	144.0
2010-08-06 01:00:00	YM	Futures	10073.8	10077.6	10068.1	10073.8	169.0
2010-08-06 02:00:00	YM	Futures	10074.7	10081.4	10071.9	10077.6	358.0
2010-08-06 03:00:00	YM	Futures	10076.6	10088.9	10068.1	10077.6	1001.0
2010-08-06 04:00:00	YM	Futures	10077.6	10080.4	10070.0	10074.7	609.0
2010-08-06 05:00:00	YM	Futures	10074.7	10074.7	10054.9	10071.9	1166.0
2010-08-06 06:00:00	YM	Futures	10070.9	10077.6	10057.7	10072.8	571.0
2010-08-06 07:00:00	YM	Futures	10073.8	10086.1	10068.1	10080.4	968.0
2010-08-06 08:00:00	YM	Futures	10080.4	10114.5	9969.7	9990.5	12485.0
2010-08-06 09:00:00	YM	Futures	9990.5	10046.3	9965.9	10045.4	23792.0
2010-08-06 10:00:00	YM	Futures	10045.4	10052.0	9923.3	9936.5	31062.0
2010-08-06 11:00:00	YM	Futures	9936.5	9958.3	9913.8	9943.2	16951.0
2010-08-06 12:00:00	YM	Futures	9942.2	9946.0	9923.3	9931.8	7188.0
2010-08-06 13:00:00	YM	Futures	9931.8	9949.8	9925.2	9941.3	6971.0
2010-08-06 14:00:00	YM	Futures	9941.3	10003.7	9930.8	10000.9	11833.0
2010-08-06 15:00:00	YM	Futures	10001.8	10049.2	9988.6	10045.4	19663.0

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

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