PREVIEW / futures_1hour / 2013-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-20.parquet
  size:    55 KB
  rows:    1,604

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-20 00:00:00	ES	Futures	1670.13	1672.46	1669.36	1670.65	4847.0
2013-06-20 01:00:00	ES	Futures	1670.65	1671.94	1668.84	1669.88	7451.0
2013-06-20 02:00:00	ES	Futures	1670.13	1672.2	1668.84	1671.69	13910.0
2013-06-20 03:00:00	ES	Futures	1671.69	1674.53	1669.1	1671.17	46522.0
2013-06-20 04:00:00	ES	Futures	1671.43	1672.46	1666.77	1666.77	49188.0
2013-06-20 05:00:00	ES	Futures	1666.77	1669.62	1660.05	1662.12	41544.0
2013-06-20 06:00:00	ES	Futures	1662.38	1666.0	1660.83	1664.97	49831.0
2013-06-20 07:00:00	ES	Futures	1665.22	1667.55	1661.35	1664.97	57288.0
2013-06-20 08:00:00	ES	Futures	1664.97	1667.55	1662.64	1663.16	69916.0
2013-06-20 09:00:00	ES	Futures	1662.64	1663.67	1656.18	1659.8	365126.0
2013-06-20 10:00:00	ES	Futures	1659.8	1662.64	1648.16	1652.82	573022.0
2013-06-20 11:00:00	ES	Futures	1652.82	1653.85	1646.35	1652.56	342963.0
2013-06-20 12:00:00	ES	Futures	1652.56	1656.95	1649.97	1650.23	202842.0
2013-06-20 13:00:00	ES	Futures	1650.23	1652.82	1646.35	1650.75	221257.0
2013-06-20 14:00:00	ES	Futures	1651.01	1651.52	1634.98	1635.24	395287.0
2013-06-20 15:00:00	ES	Futures	1635.24	1640.67	1630.59	1634.72	560672.0
2013-06-20 16:00:00	ES	Futures	1634.98	1638.86	1634.2	1637.31	159539.0
2013-06-20 17:00:00	ES	Futures	1637.56	1638.34	1637.05	1637.56	5452.0
2013-06-20 18:00:00	ES	Futures	1638.08	1639.89	1636.53	1637.31	9831.0
2013-06-20 19:00:00	ES	Futures	1637.31	1639.12	1636.53	1638.86	5629.0
2013-06-20 20:00:00	ES	Futures	1639.12	1640.15	1638.08	1638.34	8443.0
2013-06-20 21:00:00	ES	Futures	1638.6	1641.7	1638.08	1641.44	10094.0
2013-06-20 22:00:00	ES	Futures	1641.7	1643.77	1641.44	1643.77	14124.0
2013-06-20 23:00:00	ES	Futures	1643.51	1644.03	1641.7	1642.22	7048.0
2013-06-20 00:00:00	NQ	Futures	3439.91	3443.71	3438.74	3440.2	635.0
2013-06-20 01:00:00	NQ	Futures	3440.2	3442.25	3437.86	3439.32	924.0
2013-06-20 02:00:00	NQ	Futures	3439.62	3443.71	3436.69	3441.66	1599.0
2013-06-20 03:00:00	NQ	Futures	3441.66	3445.17	3435.82	3438.15	6364.0
2013-06-20 04:00:00	NQ	Futures	3438.45	3440.2	3427.63	3429.68	4500.0
2013-06-20 05:00:00	NQ	Futures	3429.97	3434.94	3417.11	3420.91	4495.0
2013-06-20 06:00:00	NQ	Futures	3421.21	3425.0	3416.24	3423.84	5588.0
2013-06-20 07:00:00	NQ	Futures	3423.54	3428.22	3419.45	3425.0	6137.0
2013-06-20 08:00:00	NQ	Futures	3425.0	3430.56	3423.84	3425.0	7801.0
2013-06-20 09:00:00	NQ	Futures	3424.71	3427.34	3411.27	3422.37	56536.0
2013-06-20 10:00:00	NQ	Futures	3422.37	3427.05	3402.79	3407.47	73128.0
2013-06-20 11:00:00	NQ	Futures	3407.47	3408.05	3393.44	3400.16	52722.0
2013-06-20 12:00:00	NQ	Futures	3400.46	3409.52	3391.69	3393.15	29419.0
2013-06-20 13:00:00	NQ	Futures	3392.86	3400.16	3387.31	3395.78	27371.0
2013-06-20 14:00:00	NQ	Futures	3395.78	3396.37	3369.19	3370.94	51389.0
2013-06-20 15:00:00	NQ	Futures	3370.65	3379.12	3361.59	3370.06	61886.0
2013-06-20 16:00:00	NQ	Futures	3370.36	3375.62	3363.05	3365.97	12501.0
2013-06-20 17:00:00	NQ	Futures	3365.68	3365.68	3363.63	3363.63	283.0
2013-06-20 18:00:00	NQ	Futures	3366.85	3369.48	3363.05	3363.34	497.0
2013-06-20 19:00:00	NQ	Futures	3363.63	3365.68	3362.17	3365.39	455.0
2013-06-20 20:00:00	NQ	Futures	3365.39	3368.6	3364.8	3365.97	770.0
2013-06-20 21:00:00	NQ	Futures	3365.97	3371.82	3365.68	3371.82	779.0
2013-06-20 22:00:00	NQ	Futures	3371.82	3376.2	3371.82	3375.32	922.0
2013-06-20 23:00:00	NQ	Futures	3375.62	3375.62	3370.65	3371.23	552.0
2013-06-20 00:00:00	YM	Futures	15224.0	15238.3	15218.0	15223.0	854.0
2013-06-20 01:00:00	YM	Futures	15223.0	15235.2	15215.9	15222.0	1633.0

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

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