PREVIEW / futures_1hour / 2011-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-14.parquet
  size:    49 KB
  rows:    1,435

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-09-14 00:00:00	ES	Futures	1155.99	1158.0	1154.74	1156.75	6897.0
2011-09-14 01:00:00	ES	Futures	1156.5	1157.25	1151.48	1154.99	13350.0
2011-09-14 02:00:00	ES	Futures	1154.74	1157.5	1152.48	1155.24	18020.0
2011-09-14 03:00:00	ES	Futures	1155.24	1167.78	1155.24	1165.27	72682.0
2011-09-14 04:00:00	ES	Futures	1165.02	1168.53	1161.76	1165.77	44451.0
2011-09-14 05:00:00	ES	Futures	1165.77	1168.03	1161.76	1166.53	30238.0
2011-09-14 06:00:00	ES	Futures	1166.78	1176.81	1166.28	1174.8	54806.0
2011-09-14 07:00:00	ES	Futures	1174.8	1180.82	1174.8	1180.82	58971.0
2011-09-14 08:00:00	ES	Futures	1180.82	1180.82	1173.05	1175.3	104771.0
2011-09-14 09:00:00	ES	Futures	1175.05	1178.06	1170.04	1171.54	299793.0
2011-09-14 10:00:00	ES	Futures	1171.54	1172.54	1158.75	1167.78	583793.0
2011-09-14 11:00:00	ES	Futures	1168.03	1176.31	1165.52	1176.31	276405.0
2011-09-14 12:00:00	ES	Futures	1176.31	1179.57	1172.8	1177.06	195817.0
2011-09-14 13:00:00	ES	Futures	1177.06	1185.58	1176.81	1181.07	251717.0
2011-09-14 14:00:00	ES	Futures	1181.32	1190.35	1181.32	1190.1	242743.0
2011-09-14 15:00:00	ES	Futures	1190.1	1199.88	1185.08	1185.58	584530.0
2011-09-14 16:00:00	ES	Futures	1185.58	1188.59	1184.58	1184.83	118174.0
2011-09-14 17:00:00	ES	Futures	1184.83	1185.08	1181.57	1182.07	6542.0
2011-09-14 18:00:00	ES	Futures	1182.07	1185.08	1181.57	1184.33	5748.0
2011-09-14 19:00:00	ES	Futures	1184.33	1186.59	1184.08	1186.34	4631.0
2011-09-14 20:00:00	ES	Futures	1186.59	1187.09	1185.08	1186.09	6060.0
2011-09-14 21:00:00	ES	Futures	1185.83	1186.84	1184.33	1186.59	10578.0
2011-09-14 22:00:00	ES	Futures	1186.84	1188.84	1184.58	1185.33	7319.0
2011-09-14 23:00:00	ES	Futures	1185.58	1186.59	1182.32	1184.83	5193.0
2011-09-14 00:00:00	NQ	Futures	2531.47	2533.2	2527.43	2531.76	545.0
2011-09-14 01:00:00	NQ	Futures	2531.47	2532.05	2521.09	2526.86	894.0
2011-09-14 02:00:00	NQ	Futures	2528.01	2532.05	2522.82	2529.16	1380.0
2011-09-14 03:00:00	NQ	Futures	2529.16	2554.25	2528.01	2549.92	5738.0
2011-09-14 04:00:00	NQ	Futures	2549.35	2556.27	2542.72	2549.35	4129.0
2011-09-14 05:00:00	NQ	Futures	2549.92	2555.4	2541.85	2553.1	2875.0
2011-09-14 06:00:00	NQ	Futures	2552.52	2573.28	2552.23	2569.82	5078.0
2011-09-14 07:00:00	NQ	Futures	2570.11	2581.06	2569.82	2581.06	4522.0
2011-09-14 08:00:00	NQ	Futures	2580.77	2581.06	2564.63	2568.95	9901.0
2011-09-14 09:00:00	NQ	Futures	2569.24	2577.6	2562.61	2570.39	38897.0
2011-09-14 10:00:00	NQ	Futures	2570.68	2572.41	2542.72	2562.61	67253.0
2011-09-14 11:00:00	NQ	Futures	2562.03	2579.62	2558.57	2579.33	31932.0
2011-09-14 12:00:00	NQ	Futures	2579.33	2585.68	2573.28	2579.91	28442.0
2011-09-14 13:00:00	NQ	Futures	2580.2	2592.88	2578.47	2585.39	29109.0
2011-09-14 14:00:00	NQ	Futures	2585.68	2603.26	2584.81	2602.98	31373.0
2011-09-14 15:00:00	NQ	Futures	2602.98	2621.14	2589.71	2590.87	65335.0
2011-09-14 16:00:00	NQ	Futures	2590.87	2596.34	2587.12	2589.14	13180.0
2011-09-14 17:00:00	NQ	Futures	2589.42	2589.42	2584.52	2585.39	335.0
2011-09-14 18:00:00	NQ	Futures	2586.25	2589.71	2583.66	2588.85	429.0
2011-09-14 19:00:00	NQ	Futures	2588.85	2593.17	2588.56	2593.17	393.0
2011-09-14 20:00:00	NQ	Futures	2592.6	2593.75	2589.14	2592.31	577.0
2011-09-14 21:00:00	NQ	Futures	2591.73	2593.17	2587.41	2591.73	1236.0
2011-09-14 22:00:00	NQ	Futures	2592.02	2595.77	2587.98	2589.42	663.0
2011-09-14 23:00:00	NQ	Futures	2589.42	2591.15	2584.52	2587.12	465.0
2011-09-14 00:00:00	YM	Futures	10739.6	10756.3	10730.7	10744.5	325.0
2011-09-14 01:00:00	YM	Futures	10744.5	10747.5	10700.2	10722.8	1284.0

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

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