PREVIEW / futures_1hour / 2013-01-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	1490.02	1491.82	1489.77	1491.56	5144.0
2013-01-04 01:00:00	ES	Futures	1491.56	1491.56	1490.54	1491.05	2511.0
2013-01-04 02:00:00	ES	Futures	1490.79	1492.85	1490.54	1492.33	8305.0
2013-01-04 03:00:00	ES	Futures	1492.08	1494.9	1491.31	1493.87	18657.0
2013-01-04 04:00:00	ES	Futures	1493.87	1494.39	1491.82	1492.33	13910.0
2013-01-04 05:00:00	ES	Futures	1492.33	1492.59	1491.31	1492.33	12549.0
2013-01-04 06:00:00	ES	Futures	1492.08	1492.59	1491.31	1492.08	12808.0
2013-01-04 07:00:00	ES	Futures	1492.08	1493.1	1491.56	1491.82	16885.0
2013-01-04 08:00:00	ES	Futures	1491.82	1495.93	1489.51	1494.9	122486.0
2013-01-04 09:00:00	ES	Futures	1494.9	1496.7	1491.56	1496.18	175541.0
2013-01-04 10:00:00	ES	Futures	1496.44	1497.47	1492.33	1493.62	251644.0
2013-01-04 11:00:00	ES	Futures	1493.36	1497.98	1493.36	1495.93	192238.0
2013-01-04 12:00:00	ES	Futures	1495.93	1497.72	1495.93	1496.44	64902.0
2013-01-04 13:00:00	ES	Futures	1496.44	1498.24	1495.67	1497.21	78577.0
2013-01-04 14:00:00	ES	Futures	1497.21	1498.49	1496.7	1498.49	113159.0
2013-01-04 15:00:00	ES	Futures	1498.49	1501.57	1497.72	1499.26	276735.0
2013-01-04 16:00:00	ES	Futures	1499.26	1499.52	1495.93	1497.72	105251.0
2013-01-04 17:00:00	ES	Futures	1497.72	1498.24	1497.21	1498.24	1628.0
2013-01-04 00:00:00	NQ	Futures	3169.74	3173.53	3169.74	3173.53	258.0
2013-01-04 01:00:00	NQ	Futures	3172.94	3172.94	3170.62	3170.91	117.0
2013-01-04 02:00:00	NQ	Futures	3170.91	3174.11	3170.62	3172.94	784.0
2013-01-04 03:00:00	NQ	Futures	3172.65	3179.93	3171.78	3178.77	2127.0
2013-01-04 04:00:00	NQ	Futures	3178.47	3180.51	3174.69	3175.85	1582.0
2013-01-04 05:00:00	NQ	Futures	3175.85	3177.6	3174.98	3176.73	1110.0
2013-01-04 06:00:00	NQ	Futures	3176.73	3177.89	3174.69	3176.15	1400.0
2013-01-04 07:00:00	NQ	Futures	3176.15	3181.39	3175.85	3177.89	2907.0
2013-01-04 08:00:00	NQ	Futures	3177.6	3185.46	3175.85	3177.89	16208.0
2013-01-04 09:00:00	NQ	Futures	3178.18	3181.09	3166.83	3173.82	31900.0
2013-01-04 10:00:00	NQ	Futures	3174.11	3175.85	3156.64	3159.55	54471.0
2013-01-04 11:00:00	NQ	Futures	3159.55	3172.94	3159.26	3170.03	26506.0
2013-01-04 12:00:00	NQ	Futures	3170.03	3174.4	3166.54	3167.7	13959.0
2013-01-04 13:00:00	NQ	Futures	3167.41	3170.91	3165.38	3166.54	9437.0
2013-01-04 14:00:00	NQ	Futures	3166.83	3171.78	3165.67	3171.78	11427.0
2013-01-04 15:00:00	NQ	Futures	3171.78	3175.85	3164.21	3164.79	28767.0
2013-01-04 16:00:00	NQ	Futures	3164.5	3165.67	3158.39	3161.01	6112.0
2013-01-04 17:00:00	NQ	Futures	3161.59	3162.17	3160.72	3161.88	56.0
2013-01-04 00:00:00	YM	Futures	13378.1	13390.2	13378.1	13389.2	326.0
2013-01-04 01:00:00	YM	Futures	13389.2	13389.2	13384.2	13385.2	145.0
2013-01-04 02:00:00	YM	Futures	13385.2	13396.2	13382.1	13392.2	472.0
2013-01-04 03:00:00	YM	Futures	13393.2	13414.3	13388.2	13409.3	1276.0
2013-01-04 04:00:00	YM	Futures	13409.3	13410.3	13389.2	13393.2	956.0
2013-01-04 05:00:00	YM	Futures	13393.2	13399.2	13388.2	13396.2	1003.0
2013-01-04 06:00:00	YM	Futures	13395.2	13399.2	13388.2	13393.2	1282.0
2013-01-04 07:00:00	YM	Futures	13393.2	13404.3	13393.2	13395.2	981.0
2013-01-04 08:00:00	YM	Futures	13395.2	13420.4	13379.1	13411.3	7850.0
2013-01-04 09:00:00	YM	Futures	13412.3	13424.4	13386.2	13423.4	12763.0
2013-01-04 10:00:00	YM	Futures	13423.4	13434.5	13385.2	13396.2	18862.0
2013-01-04 11:00:00	YM	Futures	13397.2	13434.5	13397.2	13419.4	11927.0
2013-01-04 12:00:00	YM	Futures	13419.4	13429.4	13413.3	13416.3	5926.0
2013-01-04 13:00:00	YM	Futures	13416.3	13434.5	13412.3	13426.4	5316.0

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

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