PREVIEW / futures_1hour / 2012-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-25.parquet
  size:    48 KB
  rows:    1,480

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-25 00:00:00	ES	Futures	1487.05	1487.57	1486.03	1486.29	3678.0
2012-09-25 01:00:00	ES	Futures	1486.29	1487.05	1484.5	1484.76	8330.0
2012-09-25 02:00:00	ES	Futures	1484.76	1485.01	1484.24	1484.5	7998.0
2012-09-25 03:00:00	ES	Futures	1484.5	1486.54	1483.22	1485.01	28972.0
2012-09-25 04:00:00	ES	Futures	1485.01	1486.54	1482.46	1483.22	23285.0
2012-09-25 05:00:00	ES	Futures	1482.97	1483.73	1482.2	1482.2	20097.0
2012-09-25 06:00:00	ES	Futures	1482.2	1483.73	1481.94	1483.22	12930.0
2012-09-25 07:00:00	ES	Futures	1483.22	1485.78	1482.97	1484.5	28372.0
2012-09-25 08:00:00	ES	Futures	1484.76	1487.57	1484.5	1486.8	42461.0
2012-09-25 09:00:00	ES	Futures	1487.05	1487.57	1483.99	1484.5	143486.0
2012-09-25 10:00:00	ES	Futures	1484.76	1488.33	1484.76	1487.31	243155.0
2012-09-25 11:00:00	ES	Futures	1487.31	1488.84	1485.52	1486.03	125289.0
2012-09-25 12:00:00	ES	Futures	1485.78	1486.29	1478.62	1480.67	245245.0
2012-09-25 13:00:00	ES	Futures	1480.67	1481.94	1478.37	1479.9	102218.0
2012-09-25 14:00:00	ES	Futures	1479.65	1480.41	1473.51	1473.51	172949.0
2012-09-25 15:00:00	ES	Futures	1473.51	1474.79	1466.36	1467.38	445757.0
2012-09-25 16:00:00	ES	Futures	1467.38	1469.94	1467.13	1469.17	126190.0
2012-09-25 17:00:00	ES	Futures	1469.43	1470.19	1468.92	1469.94	3481.0
2012-09-25 18:00:00	ES	Futures	1469.68	1469.94	1468.92	1469.43	3956.0
2012-09-25 19:00:00	ES	Futures	1469.43	1469.43	1468.15	1469.17	2720.0
2012-09-25 20:00:00	ES	Futures	1469.17	1470.7	1468.66	1470.45	5036.0
2012-09-25 21:00:00	ES	Futures	1470.7	1471.22	1469.68	1469.68	5420.0
2012-09-25 22:00:00	ES	Futures	1469.94	1469.94	1468.66	1469.94	4033.0
2012-09-25 23:00:00	ES	Futures	1469.94	1471.22	1469.43	1470.7	3440.0
2012-09-25 00:00:00	NQ	Futures	3307.92	3308.21	3307.05	3307.05	467.0
2012-09-25 01:00:00	NQ	Futures	3307.34	3308.79	3303.85	3304.14	636.0
2012-09-25 02:00:00	NQ	Futures	3304.14	3304.14	3302.11	3302.4	607.0
2012-09-25 03:00:00	NQ	Futures	3302.4	3307.05	3300.37	3304.43	1849.0
2012-09-25 04:00:00	NQ	Futures	3304.73	3307.63	3299.49	3301.24	1468.0
2012-09-25 05:00:00	NQ	Futures	3301.53	3303.27	3299.49	3299.49	1000.0
2012-09-25 06:00:00	NQ	Futures	3299.49	3302.69	3298.62	3301.82	834.0
2012-09-25 07:00:00	NQ	Futures	3301.82	3307.05	3301.53	3305.6	1839.0
2012-09-25 08:00:00	NQ	Futures	3305.6	3313.15	3305.6	3312.28	6137.0
2012-09-25 09:00:00	NQ	Futures	3312.28	3313.44	3298.91	3299.79	29732.0
2012-09-25 10:00:00	NQ	Futures	3300.37	3311.7	3300.37	3309.96	31247.0
2012-09-25 11:00:00	NQ	Futures	3310.25	3316.06	3308.79	3309.37	17266.0
2012-09-25 12:00:00	NQ	Futures	3309.67	3310.25	3291.07	3295.43	26869.0
2012-09-25 13:00:00	NQ	Futures	3295.14	3298.62	3290.49	3295.14	15209.0
2012-09-25 14:00:00	NQ	Futures	3295.14	3296.01	3271.02	3271.31	25255.0
2012-09-25 15:00:00	NQ	Futures	3271.02	3274.21	3252.42	3253.58	60689.0
2012-09-25 16:00:00	NQ	Futures	3253.87	3262.01	3253.29	3261.72	11549.0
2012-09-25 17:00:00	NQ	Futures	3262.01	3262.88	3261.14	3262.3	250.0
2012-09-25 18:00:00	NQ	Futures	3262.3	3262.3	3259.98	3261.14	463.0
2012-09-25 19:00:00	NQ	Futures	3261.43	3261.43	3258.81	3260.56	271.0
2012-09-25 20:00:00	NQ	Futures	3260.27	3262.01	3259.4	3261.14	621.0
2012-09-25 21:00:00	NQ	Futures	3261.14	3262.88	3259.4	3259.4	490.0
2012-09-25 22:00:00	NQ	Futures	3259.4	3259.98	3256.78	3259.69	466.0
2012-09-25 23:00:00	NQ	Futures	3259.4	3262.01	3258.52	3261.14	344.0
2012-09-25 00:00:00	YM	Futures	13525.0	13528.0	13520.0	13522.0	578.0
2012-09-25 01:00:00	YM	Futures	13522.0	13529.0	13511.0	13514.0	1521.0

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

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