PREVIEW / futures_1hour / 2012-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-24.parquet
  size:    46 KB
  rows:    1,425

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
2012-09-24 00:00:00	ES	Futures	1482.46	1482.71	1481.69	1481.69	2455.0
2012-09-24 01:00:00	ES	Futures	1481.43	1482.46	1480.92	1481.69	2933.0
2012-09-24 02:00:00	ES	Futures	1481.43	1481.94	1479.65	1480.16	9655.0
2012-09-24 03:00:00	ES	Futures	1480.41	1482.2	1479.65	1481.43	22248.0
2012-09-24 04:00:00	ES	Futures	1481.43	1481.69	1478.37	1479.39	23632.0
2012-09-24 05:00:00	ES	Futures	1479.13	1479.39	1476.32	1476.58	23265.0
2012-09-24 06:00:00	ES	Futures	1476.58	1478.11	1476.32	1477.6	12166.0
2012-09-24 07:00:00	ES	Futures	1477.35	1479.39	1477.09	1478.37	19097.0
2012-09-24 08:00:00	ES	Futures	1478.62	1478.62	1476.32	1477.09	40924.0
2012-09-24 09:00:00	ES	Futures	1477.35	1480.16	1476.32	1479.65	158105.0
2012-09-24 10:00:00	ES	Futures	1479.65	1483.48	1477.6	1482.71	237192.0
2012-09-24 11:00:00	ES	Futures	1482.97	1483.48	1479.9	1481.18	148493.0
2012-09-24 12:00:00	ES	Futures	1480.92	1481.43	1478.62	1480.41	80238.0
2012-09-24 13:00:00	ES	Futures	1480.16	1480.92	1478.62	1479.39	62522.0
2012-09-24 14:00:00	ES	Futures	1479.39	1486.29	1479.39	1484.76	114271.0
2012-09-24 15:00:00	ES	Futures	1484.76	1485.52	1481.18	1482.46	188829.0
2012-09-24 16:00:00	ES	Futures	1482.2	1483.99	1481.69	1483.73	73114.0
2012-09-24 17:00:00	ES	Futures	1483.73	1485.01	1483.73	1484.76	2943.0
2012-09-24 18:00:00	ES	Futures	1484.76	1485.01	1483.48	1483.99	4017.0
2012-09-24 19:00:00	ES	Futures	1484.24	1484.5	1483.73	1484.24	1255.0
2012-09-24 20:00:00	ES	Futures	1483.99	1487.31	1483.22	1486.8	11265.0
2012-09-24 21:00:00	ES	Futures	1486.8	1488.08	1486.54	1487.31	7389.0
2012-09-24 22:00:00	ES	Futures	1487.57	1488.08	1487.31	1487.82	3331.0
2012-09-24 23:00:00	ES	Futures	1487.82	1487.82	1486.8	1487.05	2660.0
2012-09-24 00:00:00	NQ	Futures	3316.06	3316.35	3314.31	3314.31	483.0
2012-09-24 01:00:00	NQ	Futures	3314.31	3316.35	3313.15	3314.31	344.0
2012-09-24 02:00:00	NQ	Futures	3314.31	3314.6	3311.41	3311.7	951.0
2012-09-24 03:00:00	NQ	Futures	3311.99	3314.9	3309.67	3311.99	1918.0
2012-09-24 04:00:00	NQ	Futures	3311.99	3311.99	3307.34	3309.08	1553.0
2012-09-24 05:00:00	NQ	Futures	3308.79	3310.25	3303.85	3304.14	1887.0
2012-09-24 06:00:00	NQ	Futures	3304.14	3305.6	3303.27	3304.43	912.0
2012-09-24 07:00:00	NQ	Futures	3304.43	3307.92	3304.14	3306.18	1163.0
2012-09-24 08:00:00	NQ	Futures	3306.18	3306.18	3291.94	3292.52	11719.0
2012-09-24 09:00:00	NQ	Futures	3292.52	3301.24	3284.97	3299.2	51765.0
2012-09-24 10:00:00	NQ	Futures	3299.2	3302.69	3288.16	3299.79	29389.0
2012-09-24 11:00:00	NQ	Futures	3299.79	3302.11	3289.91	3294.56	25431.0
2012-09-24 12:00:00	NQ	Futures	3294.26	3295.43	3288.74	3293.39	12962.0
2012-09-24 13:00:00	NQ	Futures	3293.68	3294.26	3286.13	3287.87	11535.0
2012-09-24 14:00:00	NQ	Futures	3287.58	3305.31	3287.29	3302.98	17425.0
2012-09-24 15:00:00	NQ	Futures	3302.98	3305.89	3296.88	3298.62	24851.0
2012-09-24 16:00:00	NQ	Futures	3298.33	3301.82	3296.88	3301.24	5050.0
2012-09-24 17:00:00	NQ	Futures	3301.24	3303.27	3300.95	3303.27	166.0
2012-09-24 18:00:00	NQ	Futures	3302.98	3303.27	3300.37	3301.82	224.0
2012-09-24 19:00:00	NQ	Futures	3301.53	3301.82	3300.66	3300.66	165.0
2012-09-24 20:00:00	NQ	Futures	3300.66	3307.63	3298.91	3306.18	1190.0
2012-09-24 21:00:00	NQ	Futures	3306.47	3309.08	3305.6	3307.92	747.0
2012-09-24 22:00:00	NQ	Futures	3308.21	3309.96	3307.63	3309.67	541.0
2012-09-24 23:00:00	NQ	Futures	3309.67	3309.67	3307.63	3307.63	229.0
2012-09-24 00:00:00	YM	Futures	13494.9	13498.9	13487.9	13488.9	394.0
2012-09-24 01:00:00	YM	Futures	13487.9	13495.9	13482.9	13488.9	237.0

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

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