PREVIEW / futures_1hour / 2011-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-20.parquet
  size:    51 KB
  rows:    1,507

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-20 00:00:00	ES	Futures	1266.83	1266.83	1264.85	1265.59	6277.0
2011-01-20 01:00:00	ES	Futures	1265.34	1265.84	1263.61	1263.86	8522.0
2011-01-20 02:00:00	ES	Futures	1263.86	1264.85	1262.37	1263.36	14362.0
2011-01-20 03:00:00	ES	Futures	1263.12	1264.85	1262.13	1263.12	35950.0
2011-01-20 04:00:00	ES	Futures	1263.12	1266.83	1263.12	1265.59	30672.0
2011-01-20 05:00:00	ES	Futures	1265.84	1266.33	1263.36	1263.61	17093.0
2011-01-20 06:00:00	ES	Futures	1263.86	1264.35	1262.37	1263.36	26685.0
2011-01-20 07:00:00	ES	Futures	1263.36	1264.6	1260.39	1260.89	51795.0
2011-01-20 08:00:00	ES	Futures	1261.14	1265.84	1260.89	1265.09	93245.0
2011-01-20 09:00:00	ES	Futures	1265.09	1265.34	1257.67	1263.12	344896.0
2011-01-20 10:00:00	ES	Futures	1263.12	1264.85	1255.2	1255.94	496632.0
2011-01-20 11:00:00	ES	Futures	1255.94	1258.17	1254.46	1257.92	333812.0
2011-01-20 12:00:00	ES	Futures	1257.92	1262.37	1257.92	1261.63	187323.0
2011-01-20 13:00:00	ES	Futures	1261.88	1263.12	1259.4	1262.87	139992.0
2011-01-20 14:00:00	ES	Futures	1262.87	1267.07	1262.37	1265.59	253412.0
2011-01-20 15:00:00	ES	Futures	1265.34	1265.59	1260.89	1264.1	321351.0
2011-01-20 16:00:00	ES	Futures	1264.1	1264.85	1262.37	1264.6	124471.0
2011-01-20 17:00:00	ES	Futures	1264.6	1264.85	1264.1	1264.35	3503.0
2011-01-20 18:00:00	ES	Futures	1264.1	1264.6	1262.37	1262.87	5171.0
2011-01-20 19:00:00	ES	Futures	1262.87	1263.12	1260.89	1261.38	8220.0
2011-01-20 20:00:00	ES	Futures	1261.38	1262.13	1260.15	1261.38	10700.0
2011-01-20 21:00:00	ES	Futures	1261.38	1262.87	1260.64	1262.62	4779.0
2011-01-20 22:00:00	ES	Futures	1262.62	1264.35	1262.37	1262.62	7180.0
2011-01-20 23:00:00	ES	Futures	1262.37	1263.36	1261.14	1262.37	5885.0
2011-01-20 00:00:00	NQ	Futures	2637.54	2637.54	2631.8	2633.81	720.0
2011-01-20 01:00:00	NQ	Futures	2633.81	2634.67	2628.07	2630.65	1267.0
2011-01-20 02:00:00	NQ	Futures	2630.37	2632.66	2629.5	2631.23	1188.0
2011-01-20 03:00:00	NQ	Futures	2631.23	2633.52	2628.93	2630.65	2612.0
2011-01-20 04:00:00	NQ	Futures	2630.65	2640.12	2630.37	2636.97	3335.0
2011-01-20 05:00:00	NQ	Futures	2637.25	2638.69	2633.52	2634.1	1711.0
2011-01-20 06:00:00	NQ	Futures	2634.1	2634.38	2630.65	2631.51	1996.0
2011-01-20 07:00:00	NQ	Futures	2631.51	2633.52	2626.92	2627.78	4692.0
2011-01-20 08:00:00	NQ	Futures	2627.78	2635.82	2626.63	2635.53	10912.0
2011-01-20 09:00:00	NQ	Futures	2635.53	2635.82	2619.46	2624.91	54305.0
2011-01-20 10:00:00	NQ	Futures	2624.91	2628.93	2607.98	2609.99	73330.0
2011-01-20 11:00:00	NQ	Futures	2609.7	2613.14	2602.81	2610.27	41428.0
2011-01-20 12:00:00	NQ	Futures	2610.27	2618.31	2609.12	2617.74	24462.0
2011-01-20 13:00:00	NQ	Futures	2618.02	2618.02	2610.85	2616.87	21307.0
2011-01-20 14:00:00	NQ	Futures	2617.16	2632.66	2615.15	2630.37	40112.0
2011-01-20 15:00:00	NQ	Futures	2630.37	2630.37	2617.45	2623.19	43240.0
2011-01-20 16:00:00	NQ	Futures	2623.48	2627.5	2615.15	2624.91	20813.0
2011-01-20 17:00:00	NQ	Futures	2624.62	2625.2	2623.76	2624.34	492.0
2011-01-20 18:00:00	NQ	Futures	2623.76	2624.62	2620.89	2621.18	420.0
2011-01-20 19:00:00	NQ	Futures	2621.47	2621.75	2616.59	2617.45	746.0
2011-01-20 20:00:00	NQ	Futures	2617.45	2618.31	2613.72	2616.59	734.0
2011-01-20 21:00:00	NQ	Futures	2616.59	2620.03	2615.73	2619.46	285.0
2011-01-20 22:00:00	NQ	Futures	2619.75	2623.76	2619.46	2620.61	551.0
2011-01-20 23:00:00	NQ	Futures	2620.61	2622.33	2618.02	2620.03	184.0
2011-01-20 00:00:00	YM	Futures	11292.3	11292.3	11279.8	11286.5	162.0
2011-01-20 01:00:00	YM	Futures	11284.6	11287.5	11270.2	11272.1	312.0

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

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