PREVIEW / futures_1hour / 2011-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-13.parquet
  size:    46 KB
  rows:    1,399

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
2011-06-13 00:00:00	ES	Futures	1262.77	1262.77	1261.78	1261.78	479.0
2011-06-13 01:00:00	ES	Futures	1262.03	1263.27	1261.78	1263.27	1887.0
2011-06-13 02:00:00	ES	Futures	1263.02	1265.01	1262.52	1264.51	3295.0
2011-06-13 03:00:00	ES	Futures	1264.51	1265.75	1262.77	1265.01	6421.0
2011-06-13 04:00:00	ES	Futures	1264.76	1265.75	1261.53	1261.78	9025.0
2011-06-13 05:00:00	ES	Futures	1261.53	1262.77	1260.78	1262.52	4695.0
2011-06-13 06:00:00	ES	Futures	1262.52	1264.76	1261.78	1264.51	5015.0
2011-06-13 07:00:00	ES	Futures	1264.26	1266.25	1263.77	1264.26	9750.0
2011-06-13 08:00:00	ES	Futures	1264.26	1267.49	1264.26	1267.0	13929.0
2011-06-13 09:00:00	ES	Futures	1267.0	1268.98	1264.51	1267.74	40463.0
2011-06-13 10:00:00	ES	Futures	1267.74	1268.73	1264.26	1265.51	42061.0
2011-06-13 11:00:00	ES	Futures	1265.26	1266.5	1262.28	1262.77	41443.0
2011-06-13 12:00:00	ES	Futures	1263.02	1264.26	1260.29	1260.78	25030.0
2011-06-13 13:00:00	ES	Futures	1260.78	1267.0	1257.06	1266.75	45055.0
2011-06-13 14:00:00	ES	Futures	1266.75	1269.23	1264.51	1265.51	37600.0
2011-06-13 15:00:00	ES	Futures	1265.51	1267.74	1262.03	1263.52	39195.0
2011-06-13 16:00:00	ES	Futures	1263.77	1265.75	1262.52	1265.01	13821.0
2011-06-13 17:00:00	ES	Futures	1264.76	1265.01	1264.51	1265.01	141.0
2011-06-13 18:00:00	ES	Futures	1264.76	1265.51	1264.76	1265.26	787.0
2011-06-13 19:00:00	ES	Futures	1265.51	1265.51	1264.76	1265.01	325.0
2011-06-13 20:00:00	ES	Futures	1265.51	1265.75	1264.26	1264.26	1129.0
2011-06-13 21:00:00	ES	Futures	1264.01	1265.26	1262.52	1265.26	2019.0
2011-06-13 22:00:00	ES	Futures	1265.26	1270.97	1265.26	1269.98	7339.0
2011-06-13 23:00:00	ES	Futures	1270.23	1272.21	1269.23	1270.97	1730.0
2011-06-13 00:00:00	NQ	Futures	2555.09	2555.09	2553.65	2553.94	14.0
2011-06-13 01:00:00	NQ	Futures	2553.65	2554.8	2552.22	2554.8	51.0
2011-06-13 02:00:00	NQ	Futures	2554.52	2557.68	2553.65	2556.24	232.0
2011-06-13 03:00:00	NQ	Futures	2556.24	2559.4	2553.65	2558.25	491.0
2011-06-13 04:00:00	NQ	Futures	2558.25	2558.54	2551.07	2551.36	391.0
2011-06-13 05:00:00	NQ	Futures	2551.64	2554.8	2551.36	2554.23	150.0
2011-06-13 06:00:00	NQ	Futures	2553.65	2557.1	2553.08	2556.81	343.0
2011-06-13 07:00:00	NQ	Futures	2555.95	2559.11	2555.67	2555.67	320.0
2011-06-13 08:00:00	NQ	Futures	2555.95	2562.27	2555.67	2561.7	421.0
2011-06-13 09:00:00	NQ	Futures	2561.7	2565.43	2553.08	2563.14	6074.0
2011-06-13 10:00:00	NQ	Futures	2563.71	2567.44	2555.67	2557.1	4349.0
2011-06-13 11:00:00	NQ	Futures	2557.1	2560.55	2551.36	2553.37	3414.0
2011-06-13 12:00:00	NQ	Futures	2553.37	2555.67	2549.92	2551.36	3504.0
2011-06-13 13:00:00	NQ	Futures	2551.36	2563.42	2545.03	2562.85	4569.0
2011-06-13 14:00:00	NQ	Futures	2562.56	2565.72	2557.96	2559.69	4279.0
2011-06-13 15:00:00	NQ	Futures	2559.97	2563.14	2551.07	2553.08	5800.0
2011-06-13 16:00:00	NQ	Futures	2553.37	2559.11	2551.07	2555.38	1441.0
2011-06-13 17:00:00	NQ	Futures	2555.67	2556.81	2555.67	2556.81	4.0
2011-06-13 18:00:00	NQ	Futures	2557.39	2557.39	2555.09	2555.95	13.0
2011-06-13 19:00:00	NQ	Futures	2555.95	2556.53	2554.52	2554.52	79.0
2011-06-13 20:00:00	NQ	Futures	2555.95	2556.81	2553.94	2553.94	70.0
2011-06-13 21:00:00	NQ	Futures	2553.37	2555.38	2551.64	2555.38	21.0
2011-06-13 22:00:00	NQ	Futures	2556.53	2568.59	2556.53	2565.72	276.0
2011-06-13 23:00:00	NQ	Futures	2564.86	2571.47	2564.86	2569.46	160.0
2011-06-13 00:00:00	YM	Futures	11509.4	11509.4	11498.8	11499.7	97.0
2011-06-13 01:00:00	YM	Futures	11502.6	11514.3	11500.7	11514.3	225.0

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

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