PREVIEW / futures_1hour / 2011-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-12.parquet
  size:    49 KB
  rows:    1,456

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-01-12 00:00:00	ES	Futures	1257.67	1258.17	1256.93	1256.93	2358.0
2011-01-12 01:00:00	ES	Futures	1256.93	1258.66	1256.19	1257.92	3943.0
2011-01-12 02:00:00	ES	Futures	1257.92	1260.15	1257.67	1259.4	8513.0
2011-01-12 03:00:00	ES	Futures	1259.4	1263.86	1259.4	1263.36	52166.0
2011-01-12 04:00:00	ES	Futures	1263.12	1266.33	1263.12	1266.08	31368.0
2011-01-12 05:00:00	ES	Futures	1266.33	1266.33	1263.36	1264.6	23343.0
2011-01-12 06:00:00	ES	Futures	1264.6	1265.34	1263.61	1264.35	15442.0
2011-01-12 07:00:00	ES	Futures	1264.6	1265.34	1263.61	1265.09	16591.0
2011-01-12 08:00:00	ES	Futures	1265.09	1267.07	1264.6	1265.09	42776.0
2011-01-12 09:00:00	ES	Futures	1265.34	1265.84	1262.87	1263.86	182200.0
2011-01-12 10:00:00	ES	Futures	1264.1	1267.57	1263.36	1267.32	232036.0
2011-01-12 11:00:00	ES	Futures	1267.32	1269.8	1266.83	1268.81	226875.0
2011-01-12 12:00:00	ES	Futures	1268.81	1270.29	1268.06	1268.31	158454.0
2011-01-12 13:00:00	ES	Futures	1268.31	1269.3	1267.57	1269.05	77700.0
2011-01-12 14:00:00	ES	Futures	1269.05	1269.05	1267.82	1268.56	104645.0
2011-01-12 15:00:00	ES	Futures	1268.56	1269.05	1265.84	1269.05	282341.0
2011-01-12 16:00:00	ES	Futures	1269.05	1271.03	1268.81	1269.55	125568.0
2011-01-12 17:00:00	ES	Futures	1269.55	1269.8	1269.3	1269.55	1317.0
2011-01-12 18:00:00	ES	Futures	1269.55	1269.8	1269.05	1269.3	3140.0
2011-01-12 19:00:00	ES	Futures	1269.55	1270.04	1269.05	1269.8	2793.0
2011-01-12 20:00:00	ES	Futures	1269.8	1270.04	1268.81	1269.05	2403.0
2011-01-12 21:00:00	ES	Futures	1269.05	1269.55	1268.06	1268.56	3507.0
2011-01-12 22:00:00	ES	Futures	1268.56	1269.3	1268.31	1268.56	1739.0
2011-01-12 23:00:00	ES	Futures	1268.56	1269.05	1268.06	1268.81	1932.0
2011-01-12 00:00:00	NQ	Futures	2627.21	2627.78	2626.35	2626.35	61.0
2011-01-12 01:00:00	NQ	Futures	2626.35	2627.78	2624.91	2626.06	176.0
2011-01-12 02:00:00	NQ	Futures	2626.35	2631.23	2626.35	2629.79	563.0
2011-01-12 03:00:00	NQ	Futures	2629.79	2636.68	2629.79	2634.67	6117.0
2011-01-12 04:00:00	NQ	Futures	2634.96	2641.85	2634.96	2641.85	2805.0
2011-01-12 05:00:00	NQ	Futures	2641.85	2641.85	2636.97	2638.12	2120.0
2011-01-12 06:00:00	NQ	Futures	2638.4	2639.84	2636.97	2638.12	1410.0
2011-01-12 07:00:00	NQ	Futures	2638.4	2639.55	2636.11	2638.69	1839.0
2011-01-12 08:00:00	NQ	Futures	2638.4	2642.42	2636.97	2637.25	4464.0
2011-01-12 09:00:00	NQ	Futures	2637.54	2638.98	2626.63	2631.51	32697.0
2011-01-12 10:00:00	NQ	Futures	2631.23	2636.11	2628.93	2635.82	25627.0
2011-01-12 11:00:00	NQ	Futures	2635.82	2641.85	2634.96	2639.26	24283.0
2011-01-12 12:00:00	NQ	Futures	2639.26	2641.56	2637.54	2637.83	15855.0
2011-01-12 13:00:00	NQ	Futures	2637.83	2643.28	2637.54	2642.71	11144.0
2011-01-12 14:00:00	NQ	Futures	2642.99	2643.28	2639.26	2640.41	12522.0
2011-01-12 15:00:00	NQ	Futures	2640.7	2643.86	2637.54	2643.57	23026.0
2011-01-12 16:00:00	NQ	Futures	2643.86	2648.45	2642.99	2644.72	12067.0
2011-01-12 17:00:00	NQ	Futures	2644.43	2645.29	2644.43	2644.72	47.0
2011-01-12 18:00:00	NQ	Futures	2644.43	2645.87	2644.43	2645.0	133.0
2011-01-12 19:00:00	NQ	Futures	2645.0	2646.73	2645.0	2646.15	203.0
2011-01-12 20:00:00	NQ	Futures	2645.87	2646.15	2644.14	2644.14	120.0
2011-01-12 21:00:00	NQ	Futures	2644.72	2645.0	2643.28	2643.57	248.0
2011-01-12 22:00:00	NQ	Futures	2643.86	2645.58	2643.28	2644.72	79.0
2011-01-12 23:00:00	NQ	Futures	2644.72	2645.58	2644.72	2645.29	60.0
2011-01-12 00:00:00	YM	Futures	11131.3	11134.2	11128.5	11128.5	137.0
2011-01-12 01:00:00	YM	Futures	11127.5	11139.0	11123.7	11136.1	348.0

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

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