PREVIEW / futures_1hour / 2010-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-17.parquet
  size:    43 KB
  rows:    1,342

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-03-17 00:00:00	ES	Futures	1130.47	1130.72	1129.49	1130.72	2687.0
2010-03-17 01:00:00	ES	Futures	1130.96	1131.69	1130.47	1131.45	3099.0
2010-03-17 02:00:00	ES	Futures	1131.45	1132.18	1130.96	1131.94	1845.0
2010-03-17 03:00:00	ES	Futures	1131.69	1132.18	1131.2	1131.69	6907.0
2010-03-17 04:00:00	ES	Futures	1131.45	1132.18	1130.72	1131.69	14733.0
2010-03-17 05:00:00	ES	Futures	1131.69	1132.43	1130.72	1132.18	9696.0
2010-03-17 06:00:00	ES	Futures	1132.43	1133.65	1131.94	1132.92	18495.0
2010-03-17 07:00:00	ES	Futures	1132.92	1133.16	1131.2	1131.2	13418.0
2010-03-17 08:00:00	ES	Futures	1131.45	1131.94	1130.23	1131.94	35980.0
2010-03-17 09:00:00	ES	Futures	1131.94	1135.36	1131.2	1134.87	225197.0
2010-03-17 10:00:00	ES	Futures	1135.12	1135.6	1132.67	1134.38	261043.0
2010-03-17 11:00:00	ES	Futures	1134.63	1136.83	1133.89	1135.6	225235.0
2010-03-17 12:00:00	ES	Futures	1135.6	1136.34	1134.87	1135.85	109290.0
2010-03-17 13:00:00	ES	Futures	1136.09	1139.52	1135.6	1138.05	259647.0
2010-03-17 14:00:00	ES	Futures	1138.29	1139.27	1134.38	1134.38	194924.0
2010-03-17 15:00:00	ES	Futures	1134.63	1135.85	1131.94	1135.85	304390.0
2010-03-17 16:00:00	ES	Futures	1135.85	1136.34	1134.63	1136.34	95425.0
2010-03-17 17:00:00	ES	Futures	1136.34	1136.58	1135.36	1135.6	1448.0
2010-03-17 18:00:00	ES	Futures	1135.85	1136.58	1135.36	1135.85	3369.0
2010-03-17 19:00:00	ES	Futures	1135.85	1138.05	1135.36	1137.32	8819.0
2010-03-17 20:00:00	ES	Futures	1137.32	1137.32	1135.6	1135.6	2831.0
2010-03-17 21:00:00	ES	Futures	1135.6	1136.34	1135.6	1135.85	1709.0
2010-03-17 22:00:00	ES	Futures	1135.85	1136.09	1135.36	1135.36	1398.0
2010-03-17 23:00:00	ES	Futures	1135.12	1136.34	1134.87	1135.85	2652.0
2010-03-17 00:00:00	NQ	Futures	2211.37	2211.94	2209.94	2211.66	241.0
2010-03-17 01:00:00	NQ	Futures	2211.94	2213.37	2211.37	2213.09	261.0
2010-03-17 02:00:00	NQ	Futures	2213.09	2213.66	2212.8	2213.37	551.0
2010-03-17 03:00:00	NQ	Futures	2213.37	2214.23	2213.09	2213.37	440.0
2010-03-17 04:00:00	NQ	Futures	2213.66	2214.23	2212.51	2213.09	1397.0
2010-03-17 05:00:00	NQ	Futures	2212.8	2214.23	2211.37	2213.66	842.0
2010-03-17 06:00:00	NQ	Futures	2213.66	2215.95	2213.37	2214.23	1191.0
2010-03-17 07:00:00	NQ	Futures	2214.52	2215.09	2212.23	2212.51	916.0
2010-03-17 08:00:00	NQ	Futures	2212.23	2213.37	2210.22	2212.23	3711.0
2010-03-17 09:00:00	NQ	Futures	2212.51	2219.96	2211.08	2217.96	30645.0
2010-03-17 10:00:00	NQ	Futures	2217.96	2219.39	2214.81	2218.53	37503.0
2010-03-17 11:00:00	NQ	Futures	2218.53	2221.96	2217.1	2219.39	31141.0
2010-03-17 12:00:00	NQ	Futures	2219.67	2221.39	2218.81	2220.25	18037.0
2010-03-17 13:00:00	NQ	Futures	2220.25	2226.55	2219.67	2223.4	30175.0
2010-03-17 14:00:00	NQ	Futures	2223.4	2223.97	2212.23	2212.51	34648.0
2010-03-17 15:00:00	NQ	Futures	2212.51	2216.52	2209.36	2215.09	46306.0
2010-03-17 16:00:00	NQ	Futures	2215.09	2215.95	2213.37	2215.38	8103.0
2010-03-17 17:00:00	NQ	Futures	2215.66	2216.52	2213.95	2215.09	255.0
2010-03-17 18:00:00	NQ	Futures	2215.38	2216.52	2215.38	2215.95	365.0
2010-03-17 19:00:00	NQ	Futures	2215.66	2218.24	2215.66	2217.1	546.0
2010-03-17 20:00:00	NQ	Futures	2217.1	2217.1	2214.81	2214.81	197.0
2010-03-17 21:00:00	NQ	Futures	2215.09	2216.81	2214.81	2215.95	237.0
2010-03-17 22:00:00	NQ	Futures	2216.24	2216.52	2214.81	2214.81	127.0
2010-03-17 23:00:00	NQ	Futures	2214.81	2216.52	2213.95	2215.38	146.0
2010-03-17 00:00:00	YM	Futures	10006.4	10010.1	9997.9	10009.2	132.0
2010-03-17 01:00:00	YM	Futures	10010.1	10015.8	10007.3	10015.8	184.0

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

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