PREVIEW / futures_1hour / 2013-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-25.parquet
  size:    43 KB
  rows:    1,248

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-01-25 00:00:00	ES	Futures	1526.97	1528.77	1526.72	1528.0	4932.0
2013-01-25 01:00:00	ES	Futures	1528.26	1529.28	1528.0	1529.03	3536.0
2013-01-25 02:00:00	ES	Futures	1529.03	1531.08	1528.77	1530.82	8760.0
2013-01-25 03:00:00	ES	Futures	1530.82	1534.93	1530.05	1533.9	44842.0
2013-01-25 04:00:00	ES	Futures	1534.16	1534.93	1533.13	1534.41	28769.0
2013-01-25 05:00:00	ES	Futures	1534.16	1535.7	1533.9	1534.41	22317.0
2013-01-25 06:00:00	ES	Futures	1534.41	1535.7	1533.64	1534.67	36432.0
2013-01-25 07:00:00	ES	Futures	1534.41	1536.98	1534.41	1535.44	40733.0
2013-01-25 08:00:00	ES	Futures	1535.7	1536.47	1534.41	1534.93	39420.0
2013-01-25 09:00:00	ES	Futures	1534.93	1536.98	1533.13	1536.21	185291.0
2013-01-25 10:00:00	ES	Futures	1536.21	1536.21	1530.05	1531.85	275682.0
2013-01-25 11:00:00	ES	Futures	1531.85	1533.9	1531.34	1531.85	144780.0
2013-01-25 12:00:00	ES	Futures	1531.85	1536.21	1531.85	1534.16	108367.0
2013-01-25 13:00:00	ES	Futures	1534.41	1537.49	1534.16	1536.72	90212.0
2013-01-25 14:00:00	ES	Futures	1536.72	1538.26	1535.95	1536.21	103777.0
2013-01-25 15:00:00	ES	Futures	1536.21	1538.01	1533.39	1537.75	265376.0
2013-01-25 16:00:00	ES	Futures	1537.75	1538.78	1534.41	1535.44	133143.0
2013-01-25 17:00:00	ES	Futures	1535.18	1535.44	1534.93	1534.93	1319.0
2013-01-25 00:00:00	NQ	Futures	3161.01	3163.92	3160.72	3163.63	430.0
2013-01-25 01:00:00	NQ	Futures	3163.34	3165.09	3163.05	3164.5	242.0
2013-01-25 02:00:00	NQ	Futures	3165.09	3169.16	3165.09	3169.16	1497.0
2013-01-25 03:00:00	NQ	Futures	3169.16	3177.02	3167.12	3175.27	4150.0
2013-01-25 04:00:00	NQ	Futures	3174.98	3176.73	3172.94	3175.27	2754.0
2013-01-25 05:00:00	NQ	Futures	3175.27	3180.22	3174.98	3176.73	1818.0
2013-01-25 06:00:00	NQ	Futures	3176.73	3179.93	3174.4	3176.73	3426.0
2013-01-25 07:00:00	NQ	Futures	3176.44	3180.8	3176.44	3178.18	2380.0
2013-01-25 08:00:00	NQ	Futures	3178.18	3179.64	3175.56	3176.15	3265.0
2013-01-25 09:00:00	NQ	Futures	3176.15	3189.53	3168.0	3187.5	35108.0
2013-01-25 10:00:00	NQ	Futures	3186.62	3187.5	3168.29	3171.2	41407.0
2013-01-25 11:00:00	NQ	Futures	3171.49	3179.06	3168.29	3168.87	27794.0
2013-01-25 12:00:00	NQ	Futures	3168.87	3179.93	3168.29	3172.65	23590.0
2013-01-25 13:00:00	NQ	Futures	3172.94	3187.5	3171.78	3184.59	21026.0
2013-01-25 14:00:00	NQ	Futures	3184.88	3189.53	3181.68	3183.71	17765.0
2013-01-25 15:00:00	NQ	Futures	3184.0	3186.92	3175.27	3180.51	35195.0
2013-01-25 16:00:00	NQ	Futures	3180.51	3182.26	3175.56	3178.47	8451.0
2013-01-25 17:00:00	NQ	Futures	3178.18	3179.06	3177.31	3177.31	92.0
2013-01-25 00:00:00	YM	Futures	13831.8	13845.9	13830.8	13839.9	655.0
2013-01-25 01:00:00	YM	Futures	13839.9	13855.0	13838.9	13852.0	588.0
2013-01-25 02:00:00	YM	Futures	13852.0	13862.0	13847.9	13861.0	749.0
2013-01-25 03:00:00	YM	Futures	13862.0	13897.2	13858.0	13895.2	3821.0
2013-01-25 04:00:00	YM	Futures	13895.2	13899.2	13887.2	13894.2	2460.0
2013-01-25 05:00:00	YM	Futures	13894.2	13902.3	13892.2	13897.2	1461.0
2013-01-25 06:00:00	YM	Futures	13897.2	13912.3	13893.2	13897.2	2571.0
2013-01-25 07:00:00	YM	Futures	13898.2	13910.3	13898.2	13900.2	2241.0
2013-01-25 08:00:00	YM	Futures	13901.3	13902.3	13894.2	13896.2	2434.0
2013-01-25 09:00:00	YM	Futures	13896.2	13908.3	13874.1	13898.2	16696.0
2013-01-25 10:00:00	YM	Futures	13898.2	13899.2	13858.0	13879.1	18377.0
2013-01-25 11:00:00	YM	Futures	13880.1	13892.2	13871.1	13879.1	10210.0
2013-01-25 12:00:00	YM	Futures	13879.1	13910.3	13879.1	13895.2	7332.0
2013-01-25 13:00:00	YM	Futures	13896.2	13911.3	13893.2	13903.3	6273.0

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

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