PREVIEW / futures_1hour / 2013-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-21.parquet
  size:    45 KB
  rows:    1,269

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-06-21 00:00:00	ES	Futures	1642.22	1643.77	1640.41	1643.25	6304.0
2013-06-21 01:00:00	ES	Futures	1643.51	1646.09	1643.25	1645.32	11184.0
2013-06-21 02:00:00	ES	Futures	1645.32	1648.42	1645.06	1645.84	20136.0
2013-06-21 03:00:00	ES	Futures	1645.58	1649.46	1645.58	1647.39	33340.0
2013-06-21 04:00:00	ES	Futures	1647.13	1647.65	1644.54	1646.35	29407.0
2013-06-21 05:00:00	ES	Futures	1646.35	1651.52	1645.84	1649.97	32686.0
2013-06-21 06:00:00	ES	Futures	1650.23	1651.01	1649.2	1650.49	39809.0
2013-06-21 07:00:00	ES	Futures	1650.23	1650.49	1646.61	1647.65	49508.0
2013-06-21 08:00:00	ES	Futures	1647.65	1648.42	1640.41	1642.22	109668.0
2013-06-21 09:00:00	ES	Futures	1642.22	1648.68	1640.41	1640.67	415375.0
2013-06-21 10:00:00	ES	Futures	1640.67	1645.32	1631.88	1637.56	474611.0
2013-06-21 11:00:00	ES	Futures	1637.31	1638.86	1623.86	1626.45	464871.0
2013-06-21 12:00:00	ES	Futures	1626.45	1638.86	1624.9	1638.86	339766.0
2013-06-21 13:00:00	ES	Futures	1638.86	1642.48	1632.65	1633.95	225340.0
2013-06-21 14:00:00	ES	Futures	1633.95	1640.93	1631.88	1640.93	176039.0
2013-06-21 15:00:00	ES	Futures	1640.93	1646.09	1638.08	1640.67	307067.0
2013-06-21 16:00:00	ES	Futures	1640.67	1641.18	1635.76	1637.05	124903.0
2013-06-21 17:00:00	ES	Futures	1637.05	1638.08	1637.05	1637.56	4185.0
2013-06-21 00:00:00	NQ	Futures	3371.53	3374.45	3368.6	3374.16	515.0
2013-06-21 01:00:00	NQ	Futures	3374.16	3379.42	3374.16	3377.95	1022.0
2013-06-21 02:00:00	NQ	Futures	3377.37	3382.34	3376.49	3376.79	1556.0
2013-06-21 03:00:00	NQ	Futures	3376.79	3382.63	3376.79	3379.12	3753.0
2013-06-21 04:00:00	NQ	Futures	3378.83	3382.05	3375.03	3381.17	3448.0
2013-06-21 05:00:00	NQ	Futures	3381.17	3389.06	3380.29	3387.01	3686.0
2013-06-21 06:00:00	NQ	Futures	3387.31	3388.47	3385.55	3387.6	2464.0
2013-06-21 07:00:00	NQ	Futures	3387.31	3387.6	3382.92	3384.68	3194.0
2013-06-21 08:00:00	NQ	Futures	3384.38	3384.97	3370.36	3370.36	8336.0
2013-06-21 09:00:00	NQ	Futures	3370.65	3380.0	3359.84	3360.13	60190.0
2013-06-21 10:00:00	NQ	Futures	3360.13	3368.02	3344.64	3354.28	70867.0
2013-06-21 11:00:00	NQ	Futures	3354.28	3355.74	3326.81	3332.66	68130.0
2013-06-21 12:00:00	NQ	Futures	3332.66	3356.33	3331.49	3355.74	49615.0
2013-06-21 13:00:00	NQ	Futures	3355.74	3362.47	3339.67	3342.3	35568.0
2013-06-21 14:00:00	NQ	Futures	3342.01	3352.53	3337.33	3351.95	30616.0
2013-06-21 15:00:00	NQ	Futures	3351.95	3362.76	3350.19	3356.33	44099.0
2013-06-21 16:00:00	NQ	Futures	3356.33	3356.91	3346.39	3349.02	6951.0
2013-06-21 17:00:00	NQ	Futures	3348.44	3350.78	3348.44	3349.32	150.0
2013-06-21 00:00:00	YM	Futures	14970.1	14981.3	14959.0	14977.2	737.0
2013-06-21 01:00:00	YM	Futures	14978.3	15006.7	14978.3	14996.5	1421.0
2013-06-21 02:00:00	YM	Futures	14994.5	15018.9	14993.5	14998.6	2132.0
2013-06-21 03:00:00	YM	Futures	14998.6	15020.9	14996.5	15003.6	3322.0
2013-06-21 04:00:00	YM	Futures	15003.6	15008.7	14985.4	14998.6	2134.0
2013-06-21 05:00:00	YM	Futures	14998.6	15033.1	14994.5	15022.9	2984.0
2013-06-21 06:00:00	YM	Futures	15024.0	15031.1	15014.8	15027.0	2643.0
2013-06-21 07:00:00	YM	Futures	15026.0	15028.0	15001.6	15007.7	2170.0
2013-06-21 08:00:00	YM	Futures	15007.7	15011.8	14954.9	14966.1	6567.0
2013-06-21 09:00:00	YM	Futures	14965.0	15011.8	14948.8	14952.9	37351.0
2013-06-21 10:00:00	YM	Futures	14952.9	14991.5	14896.0	14951.8	43510.0
2013-06-21 11:00:00	YM	Futures	14952.9	14964.0	14846.2	14864.5	40252.0
2013-06-21 12:00:00	YM	Futures	14863.5	14952.9	14838.1	14951.8	31299.0
2013-06-21 13:00:00	YM	Futures	14951.8	14980.3	14888.9	14900.0	25304.0

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

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