PREVIEW / futures_1hour / 2013-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-23.parquet
  size:    51 KB
  rows:    1,546

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
2013-04-23 00:00:00	ES	Futures	1599.34	1600.37	1598.05	1599.86	5100.0
2013-04-23 01:00:00	ES	Futures	1600.11	1600.37	1599.08	1599.6	3030.0
2013-04-23 02:00:00	ES	Futures	1599.6	1600.37	1597.28	1599.86	12339.0
2013-04-23 03:00:00	ES	Futures	1599.86	1603.72	1597.54	1598.57	51511.0
2013-04-23 04:00:00	ES	Futures	1598.57	1600.37	1595.73	1597.28	32702.0
2013-04-23 05:00:00	ES	Futures	1597.28	1602.69	1597.02	1600.89	23816.0
2013-04-23 06:00:00	ES	Futures	1600.89	1603.98	1600.37	1603.98	24902.0
2013-04-23 07:00:00	ES	Futures	1603.98	1607.84	1603.72	1607.84	41806.0
2013-04-23 08:00:00	ES	Futures	1607.84	1611.71	1607.58	1608.87	101702.0
2013-04-23 09:00:00	ES	Futures	1608.61	1618.14	1608.1	1615.31	347085.0
2013-04-23 10:00:00	ES	Futures	1615.57	1620.46	1614.8	1618.14	300002.0
2013-04-23 11:00:00	ES	Futures	1618.14	1622.27	1618.14	1621.75	162294.0
2013-04-23 12:00:00	ES	Futures	1621.75	1622.52	1619.95	1620.98	104667.0
2013-04-23 13:00:00	ES	Futures	1620.98	1621.75	1604.24	1620.46	448780.0
2013-04-23 14:00:00	ES	Futures	1620.21	1620.72	1615.31	1618.92	129078.0
2013-04-23 15:00:00	ES	Futures	1618.66	1622.27	1618.4	1621.49	175358.0
2013-04-23 16:00:00	ES	Futures	1621.49	1624.84	1619.43	1623.3	98855.0
2013-04-23 17:00:00	ES	Futures	1623.04	1623.81	1622.27	1623.3	3663.0
2013-04-23 18:00:00	ES	Futures	1621.24	1622.52	1620.46	1620.46	8949.0
2013-04-23 19:00:00	ES	Futures	1620.72	1621.75	1619.18	1619.69	4117.0
2013-04-23 20:00:00	ES	Futures	1619.43	1620.21	1619.18	1619.69	3674.0
2013-04-23 21:00:00	ES	Futures	1619.69	1620.21	1619.18	1619.18	4658.0
2013-04-23 22:00:00	ES	Futures	1619.43	1620.72	1619.18	1620.72	4036.0
2013-04-23 23:00:00	ES	Futures	1620.46	1623.55	1620.21	1623.04	6599.0
2013-04-23 00:00:00	NQ	Futures	3259.1	3261.14	3257.06	3260.26	540.0
2013-04-23 01:00:00	NQ	Futures	3259.68	3260.85	3258.22	3259.39	318.0
2013-04-23 02:00:00	NQ	Futures	3259.97	3261.72	3255.01	3259.1	1058.0
2013-04-23 03:00:00	NQ	Futures	3259.1	3270.76	3253.85	3255.6	6858.0
2013-04-23 04:00:00	NQ	Futures	3255.31	3259.97	3249.18	3252.97	3739.0
2013-04-23 05:00:00	NQ	Futures	3253.26	3266.68	3253.26	3264.06	2564.0
2013-04-23 06:00:00	NQ	Futures	3264.06	3269.31	3263.47	3269.31	2785.0
2013-04-23 07:00:00	NQ	Futures	3269.31	3280.68	3269.31	3280.39	5011.0
2013-04-23 08:00:00	NQ	Futures	3280.39	3287.97	3279.81	3281.56	10246.0
2013-04-23 09:00:00	NQ	Futures	3281.56	3300.81	3280.68	3297.89	41706.0
2013-04-23 10:00:00	NQ	Futures	3297.31	3305.47	3294.97	3301.1	37292.0
2013-04-23 11:00:00	NQ	Futures	3301.1	3310.43	3300.51	3309.56	20603.0
2013-04-23 12:00:00	NQ	Futures	3309.85	3312.18	3304.89	3306.64	13723.0
2013-04-23 13:00:00	NQ	Futures	3306.64	3308.68	3270.47	3302.85	59283.0
2013-04-23 14:00:00	NQ	Futures	3302.85	3303.72	3285.93	3297.31	18135.0
2013-04-23 15:00:00	NQ	Futures	3297.6	3304.01	3296.14	3300.22	21529.0
2013-04-23 16:00:00	NQ	Futures	3299.93	3316.56	3286.51	3313.93	18485.0
2013-04-23 17:00:00	NQ	Futures	3313.93	3317.43	3311.89	3314.22	1692.0
2013-04-23 18:00:00	NQ	Futures	3301.1	3301.39	3294.68	3294.97	3920.0
2013-04-23 19:00:00	NQ	Futures	3294.68	3296.43	3289.43	3290.01	1426.0
2013-04-23 20:00:00	NQ	Futures	3290.31	3292.35	3289.43	3291.18	1129.0
2013-04-23 21:00:00	NQ	Futures	3291.47	3295.26	3291.18	3292.64	1006.0
2013-04-23 22:00:00	NQ	Futures	3292.64	3294.68	3292.06	3292.93	591.0
2013-04-23 23:00:00	NQ	Futures	3293.22	3297.6	3291.76	3296.14	806.0
2013-04-23 00:00:00	YM	Futures	14623.3	14631.4	14615.2	14628.4	378.0
2013-04-23 01:00:00	YM	Futures	14627.4	14631.4	14624.3	14629.4	360.0

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

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