PREVIEW / futures_1hour / 2011-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-28.parquet
  size:    47 KB
  rows:    1,445

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-12-28 00:00:00	ES	Futures	1266.74	1267.25	1266.24	1266.49	3173.0
2011-12-28 01:00:00	ES	Futures	1266.49	1267.25	1265.99	1267.0	1242.0
2011-12-28 02:00:00	ES	Futures	1267.25	1269.01	1264.22	1269.01	6960.0
2011-12-28 03:00:00	ES	Futures	1269.01	1269.77	1265.48	1268.76	18067.0
2011-12-28 04:00:00	ES	Futures	1269.01	1271.03	1268.26	1270.52	11392.0
2011-12-28 05:00:00	ES	Futures	1270.78	1273.8	1270.27	1273.55	9714.0
2011-12-28 06:00:00	ES	Futures	1273.55	1274.05	1272.54	1273.3	5729.0
2011-12-28 07:00:00	ES	Futures	1273.04	1274.56	1272.79	1272.79	7048.0
2011-12-28 08:00:00	ES	Futures	1273.04	1273.8	1272.29	1272.79	12482.0
2011-12-28 09:00:00	ES	Futures	1272.79	1273.3	1262.21	1262.96	171535.0
2011-12-28 10:00:00	ES	Futures	1262.96	1265.23	1257.92	1259.94	191245.0
2011-12-28 11:00:00	ES	Futures	1259.69	1260.44	1254.4	1256.16	137556.0
2011-12-28 12:00:00	ES	Futures	1256.16	1257.17	1254.14	1254.9	69519.0
2011-12-28 13:00:00	ES	Futures	1254.9	1258.93	1254.65	1258.43	66563.0
2011-12-28 14:00:00	ES	Futures	1258.68	1258.68	1254.9	1255.4	79881.0
2011-12-28 15:00:00	ES	Futures	1255.4	1257.17	1252.88	1255.15	145946.0
2011-12-28 16:00:00	ES	Futures	1255.15	1256.16	1253.39	1254.9	56226.0
2011-12-28 17:00:00	ES	Futures	1254.9	1255.66	1254.65	1255.15	1560.0
2011-12-28 18:00:00	ES	Futures	1255.4	1257.42	1255.15	1257.17	4439.0
2011-12-28 19:00:00	ES	Futures	1257.17	1257.92	1254.9	1256.66	6042.0
2011-12-28 20:00:00	ES	Futures	1256.66	1258.93	1256.41	1258.68	5661.0
2011-12-28 21:00:00	ES	Futures	1258.68	1258.93	1257.92	1258.43	2389.0
2011-12-28 22:00:00	ES	Futures	1258.43	1259.94	1258.43	1259.44	3041.0
2011-12-28 23:00:00	ES	Futures	1259.44	1259.69	1258.68	1259.18	2408.0
2011-12-28 00:00:00	NQ	Futures	2633.84	2633.84	2632.4	2632.97	198.0
2011-12-28 01:00:00	NQ	Futures	2633.26	2634.42	2632.69	2634.13	85.0
2011-12-28 02:00:00	NQ	Futures	2634.13	2637.31	2630.09	2637.02	482.0
2011-12-28 03:00:00	NQ	Futures	2637.02	2639.04	2629.8	2635.86	2213.0
2011-12-28 04:00:00	NQ	Futures	2635.86	2641.64	2634.71	2640.48	1151.0
2011-12-28 05:00:00	NQ	Futures	2640.48	2646.26	2639.62	2645.97	576.0
2011-12-28 06:00:00	NQ	Futures	2646.26	2647.13	2643.66	2645.1	519.0
2011-12-28 07:00:00	NQ	Futures	2645.1	2647.7	2645.1	2645.68	578.0
2011-12-28 08:00:00	NQ	Futures	2645.39	2647.99	2644.53	2646.84	1171.0
2011-12-28 09:00:00	NQ	Futures	2646.84	2647.41	2624.6	2626.62	21930.0
2011-12-28 10:00:00	NQ	Futures	2626.62	2633.26	2619.4	2622.58	22420.0
2011-12-28 11:00:00	NQ	Futures	2622.58	2625.47	2615.65	2619.11	15008.0
2011-12-28 12:00:00	NQ	Futures	2619.11	2622.29	2613.34	2615.94	9810.0
2011-12-28 13:00:00	NQ	Futures	2615.65	2623.16	2615.36	2621.42	9497.0
2011-12-28 14:00:00	NQ	Futures	2621.71	2622.29	2615.65	2617.67	11297.0
2011-12-28 15:00:00	NQ	Futures	2617.38	2619.4	2603.52	2614.49	25145.0
2011-12-28 16:00:00	NQ	Futures	2614.2	2616.51	2610.74	2615.36	5036.0
2011-12-28 17:00:00	NQ	Futures	2614.78	2617.67	2614.49	2616.8	60.0
2011-12-28 18:00:00	NQ	Futures	2613.63	2617.09	2613.63	2616.51	282.0
2011-12-28 19:00:00	NQ	Futures	2616.51	2617.09	2611.6	2614.78	396.0
2011-12-28 20:00:00	NQ	Futures	2614.78	2618.25	2614.49	2617.67	202.0
2011-12-28 21:00:00	NQ	Futures	2617.96	2619.11	2617.09	2618.82	162.0
2011-12-28 22:00:00	NQ	Futures	2618.53	2621.42	2618.53	2620.85	241.0
2011-12-28 23:00:00	NQ	Futures	2620.85	2620.85	2619.11	2619.98	93.0
2011-12-28 00:00:00	YM	Futures	12091.9	12094.8	12087.9	12087.9	204.0
2011-12-28 01:00:00	YM	Futures	12089.9	12094.8	12085.9	12093.8	96.0

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

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