PREVIEW / futures_1hour / 2011-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-19.parquet
  size:    50 KB
  rows:    1,500

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-19 00:00:00	ES	Futures	1280.93	1281.92	1280.93	1281.92	2684.0
2011-01-19 01:00:00	ES	Futures	1281.67	1282.91	1281.67	1282.66	4511.0
2011-01-19 02:00:00	ES	Futures	1282.91	1282.91	1280.44	1280.93	10687.0
2011-01-19 03:00:00	ES	Futures	1281.18	1281.18	1279.45	1279.69	22761.0
2011-01-19 04:00:00	ES	Futures	1279.69	1280.44	1278.46	1279.69	14735.0
2011-01-19 05:00:00	ES	Futures	1279.45	1280.44	1278.21	1279.94	18644.0
2011-01-19 06:00:00	ES	Futures	1279.69	1279.94	1278.46	1279.45	10971.0
2011-01-19 07:00:00	ES	Futures	1279.2	1282.17	1279.2	1281.67	19461.0
2011-01-19 08:00:00	ES	Futures	1281.67	1281.92	1276.48	1277.22	74116.0
2011-01-19 09:00:00	ES	Futures	1277.22	1277.96	1272.76	1273.75	282018.0
2011-01-19 10:00:00	ES	Futures	1273.75	1274.99	1268.56	1270.29	359328.0
2011-01-19 11:00:00	ES	Futures	1270.29	1270.79	1268.06	1270.04	203961.0
2011-01-19 12:00:00	ES	Futures	1270.04	1270.54	1265.84	1267.07	273231.0
2011-01-19 13:00:00	ES	Futures	1266.83	1269.8	1265.84	1268.56	158899.0
2011-01-19 14:00:00	ES	Futures	1268.31	1268.56	1262.37	1264.1	255259.0
2011-01-19 15:00:00	ES	Futures	1264.1	1265.59	1261.88	1265.59	437988.0
2011-01-19 16:00:00	ES	Futures	1265.59	1266.83	1264.85	1265.09	130002.0
2011-01-19 17:00:00	ES	Futures	1265.09	1265.34	1264.6	1265.09	2688.0
2011-01-19 18:00:00	ES	Futures	1264.85	1265.34	1264.35	1264.85	5223.0
2011-01-19 19:00:00	ES	Futures	1264.85	1267.32	1264.1	1267.07	9501.0
2011-01-19 20:00:00	ES	Futures	1267.07	1268.31	1265.59	1267.07	10324.0
2011-01-19 21:00:00	ES	Futures	1267.32	1268.31	1266.08	1266.58	4851.0
2011-01-19 22:00:00	ES	Futures	1266.58	1266.83	1266.08	1266.33	2429.0
2011-01-19 23:00:00	ES	Futures	1266.33	1267.32	1266.08	1266.83	2664.0
2011-01-19 00:00:00	NQ	Futures	2680.31	2680.6	2679.45	2680.31	140.0
2011-01-19 01:00:00	NQ	Futures	2680.31	2685.19	2680.02	2684.33	491.0
2011-01-19 02:00:00	NQ	Futures	2684.33	2684.33	2678.87	2679.16	958.0
2011-01-19 03:00:00	NQ	Futures	2679.16	2679.73	2675.72	2676.29	2547.0
2011-01-19 04:00:00	NQ	Futures	2676.29	2677.73	2675.14	2675.43	1592.0
2011-01-19 05:00:00	NQ	Futures	2675.72	2676.29	2671.99	2675.43	2580.0
2011-01-19 06:00:00	NQ	Futures	2675.43	2676.0	2673.71	2675.14	1346.0
2011-01-19 07:00:00	NQ	Futures	2675.14	2680.6	2674.86	2680.02	2947.0
2011-01-19 08:00:00	NQ	Futures	2680.02	2680.02	2671.12	2675.43	9465.0
2011-01-19 09:00:00	NQ	Futures	2675.43	2679.45	2663.09	2664.24	54249.0
2011-01-19 10:00:00	NQ	Futures	2663.95	2669.69	2653.33	2657.92	46936.0
2011-01-19 11:00:00	NQ	Futures	2658.21	2659.93	2651.32	2655.05	25988.0
2011-01-19 12:00:00	NQ	Futures	2655.05	2656.2	2646.44	2649.88	18544.0
2011-01-19 13:00:00	NQ	Futures	2650.17	2654.48	2646.44	2649.88	13685.0
2011-01-19 14:00:00	NQ	Futures	2649.6	2650.74	2634.38	2638.69	28525.0
2011-01-19 15:00:00	NQ	Futures	2638.69	2642.42	2632.66	2642.42	46197.0
2011-01-19 16:00:00	NQ	Futures	2642.42	2644.14	2633.81	2634.1	17497.0
2011-01-19 17:00:00	NQ	Futures	2634.38	2634.38	2632.66	2633.24	1003.0
2011-01-19 18:00:00	NQ	Futures	2633.24	2634.38	2632.09	2633.24	781.0
2011-01-19 19:00:00	NQ	Futures	2632.95	2638.12	2631.51	2638.12	883.0
2011-01-19 20:00:00	NQ	Futures	2638.12	2639.55	2634.67	2636.97	713.0
2011-01-19 21:00:00	NQ	Futures	2636.97	2638.12	2634.96	2635.53	575.0
2011-01-19 22:00:00	NQ	Futures	2635.82	2637.25	2635.53	2636.11	239.0
2011-01-19 23:00:00	NQ	Futures	2636.39	2638.4	2635.82	2637.83	247.0
2011-01-19 00:00:00	YM	Futures	11318.1	11322.9	11317.2	11322.9	100.0
2011-01-19 01:00:00	YM	Futures	11323.9	11336.3	11322.9	11332.5	330.0

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

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