PREVIEW / futures_1hour / 2012-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-12.parquet
  size:    40 KB
  rows:    1,182

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-10-12 00:00:00	ES	Futures	1461.76	1462.27	1461.25	1461.25	2515.0
2012-10-12 01:00:00	ES	Futures	1461.25	1463.3	1461.25	1463.04	6456.0
2012-10-12 02:00:00	ES	Futures	1462.79	1464.83	1462.02	1462.02	17769.0
2012-10-12 03:00:00	ES	Futures	1462.02	1464.57	1459.98	1464.57	44646.0
2012-10-12 04:00:00	ES	Futures	1464.57	1464.83	1462.02	1463.04	18460.0
2012-10-12 05:00:00	ES	Futures	1463.04	1463.81	1460.49	1461.76	19175.0
2012-10-12 06:00:00	ES	Futures	1462.02	1464.83	1462.02	1464.32	21364.0
2012-10-12 07:00:00	ES	Futures	1464.32	1465.85	1462.79	1465.6	40444.0
2012-10-12 08:00:00	ES	Futures	1465.6	1465.85	1462.02	1462.53	38473.0
2012-10-12 09:00:00	ES	Futures	1462.79	1463.81	1457.93	1463.3	215618.0
2012-10-12 10:00:00	ES	Futures	1463.3	1465.34	1458.95	1459.98	245955.0
2012-10-12 11:00:00	ES	Futures	1460.23	1460.49	1451.03	1453.59	333653.0
2012-10-12 12:00:00	ES	Futures	1453.59	1455.38	1452.57	1453.84	107147.0
2012-10-12 13:00:00	ES	Futures	1453.84	1454.61	1451.54	1454.35	95332.0
2012-10-12 14:00:00	ES	Futures	1454.35	1457.16	1453.33	1455.89	90172.0
2012-10-12 15:00:00	ES	Futures	1455.89	1456.4	1453.08	1454.1	184224.0
2012-10-12 16:00:00	ES	Futures	1454.1	1454.35	1451.54	1452.82	101821.0
2012-10-12 00:00:00	NQ	Futures	3156.24	3157.4	3154.5	3155.08	434.0
2012-10-12 01:00:00	NQ	Futures	3154.79	3159.44	3154.5	3158.86	765.0
2012-10-12 02:00:00	NQ	Futures	3158.27	3161.76	3156.24	3156.53	1275.0
2012-10-12 03:00:00	NQ	Futures	3156.24	3160.89	3149.27	3160.89	4992.0
2012-10-12 04:00:00	NQ	Futures	3160.6	3161.47	3153.63	3156.53	1868.0
2012-10-12 05:00:00	NQ	Futures	3156.82	3157.4	3150.14	3153.04	1888.0
2012-10-12 06:00:00	NQ	Futures	3153.04	3160.02	3153.04	3159.15	1823.0
2012-10-12 07:00:00	NQ	Futures	3158.86	3162.05	3155.66	3161.76	3005.0
2012-10-12 08:00:00	NQ	Futures	3161.47	3162.05	3156.82	3159.15	5267.0
2012-10-12 09:00:00	NQ	Futures	3158.86	3168.15	3149.85	3167.28	34543.0
2012-10-12 10:00:00	NQ	Futures	3167.57	3171.06	3160.31	3166.12	37037.0
2012-10-12 11:00:00	NQ	Futures	3166.41	3166.99	3146.65	3155.95	37258.0
2012-10-12 12:00:00	NQ	Futures	3155.95	3159.44	3152.46	3155.08	14625.0
2012-10-12 13:00:00	NQ	Futures	3155.08	3157.11	3149.27	3157.11	14173.0
2012-10-12 14:00:00	NQ	Futures	3156.82	3164.09	3153.92	3160.89	13789.0
2012-10-12 15:00:00	NQ	Futures	3161.18	3161.18	3153.33	3153.63	21690.0
2012-10-12 16:00:00	NQ	Futures	3153.33	3153.92	3149.85	3152.17	9180.0
2012-10-12 00:00:00	YM	Futures	13285.8	13288.8	13281.8	13283.8	264.0
2012-10-12 01:00:00	YM	Futures	13282.8	13297.8	13282.8	13296.8	484.0
2012-10-12 02:00:00	YM	Futures	13293.8	13309.8	13287.8	13293.8	1201.0
2012-10-12 03:00:00	YM	Futures	13291.8	13309.8	13274.8	13308.8	2125.0
2012-10-12 04:00:00	YM	Futures	13308.8	13309.8	13286.8	13294.8	1054.0
2012-10-12 05:00:00	YM	Futures	13294.8	13296.8	13271.8	13282.8	1213.0
2012-10-12 06:00:00	YM	Futures	13284.8	13304.8	13282.8	13301.8	1360.0
2012-10-12 07:00:00	YM	Futures	13301.8	13315.9	13290.8	13313.9	2310.0
2012-10-12 08:00:00	YM	Futures	13313.9	13314.9	13289.8	13298.8	2839.0
2012-10-12 09:00:00	YM	Futures	13297.8	13329.9	13276.8	13325.9	14667.0
2012-10-12 10:00:00	YM	Futures	13325.9	13340.9	13292.8	13302.8	16725.0
2012-10-12 11:00:00	YM	Futures	13303.8	13306.8	13236.8	13256.8	21097.0
2012-10-12 12:00:00	YM	Futures	13256.8	13267.8	13243.8	13253.8	7441.0
2012-10-12 13:00:00	YM	Futures	13253.8	13259.8	13233.8	13258.8	6989.0
2012-10-12 14:00:00	YM	Futures	13258.8	13277.8	13249.8	13268.8	7282.0
2012-10-12 15:00:00	YM	Futures	13268.8	13275.8	13250.8	13269.8	10998.0

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

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