PREVIEW / futures_30min / 2010-06-21

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-06-21.parquet
  size:    71 KB
  rows:    2,477

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-21 00:00:00	ES	Futures	1102.98	1104.94	1102.98	1103.23	1512.0
2010-06-21 00:30:00	ES	Futures	1103.23	1104.7	1101.75	1103.23	3997.0
2010-06-21 01:00:00	ES	Futures	1103.47	1105.68	1103.23	1105.68	4026.0
2010-06-21 01:30:00	ES	Futures	1105.68	1107.15	1105.43	1106.42	5718.0
2010-06-21 02:00:00	ES	Futures	1106.42	1108.62	1106.17	1107.4	9901.0
2010-06-21 02:30:00	ES	Futures	1107.4	1108.38	1106.91	1107.64	6420.0
2010-06-21 03:00:00	ES	Futures	1107.64	1108.13	1106.66	1107.64	19940.0
2010-06-21 03:30:00	ES	Futures	1107.4	1107.64	1105.43	1105.68	16235.0
2010-06-21 04:00:00	ES	Futures	1105.68	1106.42	1103.96	1106.42	17507.0
2010-06-21 04:30:00	ES	Futures	1106.17	1107.15	1105.19	1105.93	10093.0
2010-06-21 05:00:00	ES	Futures	1105.93	1106.42	1104.45	1105.93	7572.0
2010-06-21 05:30:00	ES	Futures	1105.93	1105.93	1104.45	1105.68	5739.0
2010-06-21 06:00:00	ES	Futures	1105.93	1107.4	1105.68	1107.15	7790.0
2010-06-21 06:30:00	ES	Futures	1106.91	1107.4	1105.43	1105.68	8409.0
2010-06-21 07:00:00	ES	Futures	1105.93	1106.91	1105.68	1105.93	10291.0
2010-06-21 07:30:00	ES	Futures	1105.93	1106.42	1104.7	1104.94	10871.0
2010-06-21 08:00:00	ES	Futures	1104.94	1105.43	1102.24	1102.49	26053.0
2010-06-21 08:30:00	ES	Futures	1102.49	1103.72	1102.24	1103.23	26178.0
2010-06-21 09:00:00	ES	Futures	1103.23	1106.17	1102.98	1105.68	34050.0
2010-06-21 09:30:00	ES	Futures	1105.68	1106.66	1100.77	1104.94	225668.0
2010-06-21 10:00:00	ES	Futures	1104.94	1106.17	1101.75	1101.75	135196.0
2010-06-21 10:30:00	ES	Futures	1102.0	1103.23	1099.55	1100.04	144335.0
2010-06-21 11:00:00	ES	Futures	1100.04	1102.49	1099.3	1101.51	92200.0
2010-06-21 11:30:00	ES	Futures	1101.51	1102.49	1099.55	1100.28	84884.0
2010-06-21 12:00:00	ES	Futures	1100.53	1101.02	1097.09	1097.09	84603.0
2010-06-21 12:30:00	ES	Futures	1097.34	1098.07	1095.86	1097.58	88979.0
2010-06-21 13:00:00	ES	Futures	1097.34	1099.05	1096.6	1098.07	81408.0
2010-06-21 13:30:00	ES	Futures	1098.07	1098.56	1093.9	1095.37	105319.0
2010-06-21 14:00:00	ES	Futures	1095.37	1099.05	1094.39	1096.85	94654.0
2010-06-21 14:30:00	ES	Futures	1096.6	1097.58	1092.67	1093.41	87364.0
2010-06-21 15:00:00	ES	Futures	1093.17	1093.9	1084.58	1086.3	257373.0
2010-06-21 15:30:00	ES	Futures	1086.05	1088.75	1082.86	1088.5	251138.0
2010-06-21 16:00:00	ES	Futures	1088.5	1091.2	1088.5	1089.98	98276.0
2010-06-21 16:30:00	ES	Futures	1089.98	1090.71	1089.73	1090.22	4699.0
2010-06-21 17:00:00	ES	Futures	1090.22	1090.71	1089.98	1090.22	1206.0
2010-06-21 18:00:00	ES	Futures	1090.47	1091.2	1090.22	1090.47	1836.0
2010-06-21 18:30:00	ES	Futures	1090.47	1090.96	1090.22	1090.47	1832.0
2010-06-21 19:00:00	ES	Futures	1090.71	1091.45	1090.47	1091.2	1115.0
2010-06-21 19:30:00	ES	Futures	1091.2	1091.45	1090.71	1090.96	1222.0
2010-06-21 20:00:00	ES	Futures	1090.71	1091.2	1089.98	1090.22	2896.0
2010-06-21 20:30:00	ES	Futures	1090.47	1091.2	1090.22	1091.2	2483.0
2010-06-21 21:00:00	ES	Futures	1091.2	1094.88	1089.98	1094.15	12633.0
2010-06-21 21:30:00	ES	Futures	1093.9	1096.36	1091.45	1093.41	17040.0
2010-06-21 22:00:00	ES	Futures	1093.41	1093.66	1090.47	1091.2	4689.0
2010-06-21 22:30:00	ES	Futures	1090.96	1093.17	1090.96	1091.45	2784.0
2010-06-21 23:00:00	ES	Futures	1091.45	1092.67	1091.45	1091.94	1315.0
2010-06-21 23:30:00	ES	Futures	1091.94	1092.18	1090.47	1090.71	2257.0
2010-06-21 00:00:00	NQ	Futures	2214.58	2218.02	2214.58	2215.73	231.0
2010-06-21 00:30:00	NQ	Futures	2216.02	2217.73	2214.01	2215.16	370.0
2010-06-21 01:00:00	NQ	Futures	2215.16	2218.02	2214.58	2218.02	174.0

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

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