PREVIEW / futures_30min / 2010-07-23

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-07-23.parquet
  size:    61 KB
  rows:    2,043

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-23 00:00:00	ES	Futures	1068.38	1070.59	1068.38	1070.1	2448.0
2010-07-23 00:30:00	ES	Futures	1070.35	1070.59	1069.61	1069.61	1297.0
2010-07-23 01:00:00	ES	Futures	1069.85	1071.82	1069.85	1070.35	2716.0
2010-07-23 01:30:00	ES	Futures	1070.35	1070.84	1066.42	1068.14	6081.0
2010-07-23 02:00:00	ES	Futures	1068.14	1069.61	1067.65	1069.36	3542.0
2010-07-23 02:30:00	ES	Futures	1069.36	1069.61	1068.63	1069.61	2975.0
2010-07-23 03:00:00	ES	Futures	1069.61	1069.61	1066.66	1069.12	15946.0
2010-07-23 03:30:00	ES	Futures	1069.36	1071.33	1068.38	1069.85	15970.0
2010-07-23 04:00:00	ES	Futures	1070.1	1074.03	1069.85	1073.54	19408.0
2010-07-23 04:30:00	ES	Futures	1073.54	1074.52	1072.8	1073.29	14139.0
2010-07-23 05:00:00	ES	Futures	1073.29	1073.29	1070.59	1070.59	9237.0
2010-07-23 05:30:00	ES	Futures	1070.59	1071.82	1070.59	1071.57	6213.0
2010-07-23 06:00:00	ES	Futures	1071.57	1071.82	1070.59	1071.08	4933.0
2010-07-23 06:30:00	ES	Futures	1071.08	1073.54	1070.84	1072.31	7824.0
2010-07-23 07:00:00	ES	Futures	1072.06	1073.78	1071.33	1071.82	12920.0
2010-07-23 07:30:00	ES	Futures	1072.06	1072.55	1071.57	1072.06	11622.0
2010-07-23 08:00:00	ES	Futures	1072.06	1073.29	1070.84	1073.04	19484.0
2010-07-23 08:30:00	ES	Futures	1073.04	1073.29	1070.35	1071.08	17769.0
2010-07-23 09:00:00	ES	Futures	1070.84	1071.82	1066.17	1067.4	87396.0
2010-07-23 09:30:00	ES	Futures	1067.16	1071.33	1064.46	1064.95	261139.0
2010-07-23 10:00:00	ES	Futures	1064.95	1070.84	1063.97	1070.35	156975.0
2010-07-23 10:30:00	ES	Futures	1070.35	1073.04	1069.85	1070.1	143707.0
2010-07-23 11:00:00	ES	Futures	1069.85	1072.06	1069.12	1070.84	89641.0
2010-07-23 11:30:00	ES	Futures	1070.84	1073.29	1068.38	1071.33	100733.0
2010-07-23 12:00:00	ES	Futures	1071.57	1074.52	1066.91	1070.59	197974.0
2010-07-23 12:30:00	ES	Futures	1070.59	1071.33	1066.42	1070.59	104191.0
2010-07-23 13:00:00	ES	Futures	1070.59	1077.22	1068.14	1077.22	127651.0
2010-07-23 13:30:00	ES	Futures	1076.97	1078.93	1075.74	1077.71	102996.0
2010-07-23 14:00:00	ES	Futures	1077.71	1080.16	1075.74	1076.97	94811.0
2010-07-23 14:30:00	ES	Futures	1077.22	1080.41	1076.23	1078.93	65977.0
2010-07-23 15:00:00	ES	Futures	1078.93	1079.42	1075.74	1077.22	73912.0
2010-07-23 15:30:00	ES	Futures	1077.46	1079.18	1073.29	1078.69	187545.0
2010-07-23 16:00:00	ES	Futures	1078.44	1081.14	1077.71	1080.65	84723.0
2010-07-23 00:00:00	NQ	Futures	2123.74	2127.75	2123.74	2127.47	138.0
2010-07-23 00:30:00	NQ	Futures	2127.47	2127.75	2125.75	2125.75	121.0
2010-07-23 01:00:00	NQ	Futures	2126.03	2129.76	2126.03	2127.47	104.0
2010-07-23 01:30:00	NQ	Futures	2127.18	2128.33	2120.3	2122.88	329.0
2010-07-23 02:00:00	NQ	Futures	2123.45	2126.61	2122.31	2126.32	378.0
2010-07-23 02:30:00	NQ	Futures	2126.61	2127.75	2125.17	2127.47	498.0
2010-07-23 03:00:00	NQ	Futures	2127.47	2127.75	2122.31	2127.75	1187.0
2010-07-23 03:30:00	NQ	Futures	2127.75	2131.48	2125.46	2128.33	727.0
2010-07-23 04:00:00	NQ	Futures	2128.33	2136.06	2128.33	2134.06	1539.0
2010-07-23 04:30:00	NQ	Futures	2134.34	2137.21	2133.77	2135.49	777.0
2010-07-23 05:00:00	NQ	Futures	2135.2	2135.2	2130.33	2130.62	480.0
2010-07-23 05:30:00	NQ	Futures	2130.62	2132.91	2130.62	2132.62	190.0
2010-07-23 06:00:00	NQ	Futures	2131.76	2132.62	2130.62	2132.05	174.0
2010-07-23 06:30:00	NQ	Futures	2132.34	2135.78	2131.76	2133.77	565.0
2010-07-23 07:00:00	NQ	Futures	2133.77	2136.64	2132.34	2133.2	602.0
2010-07-23 07:30:00	NQ	Futures	2133.48	2133.77	2130.9	2131.48	1274.0
2010-07-23 08:00:00	NQ	Futures	2131.48	2132.62	2128.04	2132.34	2116.0

> showing 50 of 2,043 rows — these rows as CSV

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