PREVIEW / futures_1hour / 2013-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-02.parquet
  size:    50 KB
  rows:    1,554

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-05-02 00:00:00	ES	Futures	1629.48	1629.48	1628.71	1628.96	2372.0
2013-05-02 01:00:00	ES	Futures	1628.96	1629.48	1628.45	1628.71	4017.0
2013-05-02 02:00:00	ES	Futures	1628.71	1630.51	1628.19	1628.45	11291.0
2013-05-02 03:00:00	ES	Futures	1628.71	1631.02	1628.45	1630.51	21086.0
2013-05-02 04:00:00	ES	Futures	1630.25	1630.77	1628.19	1628.96	12476.0
2013-05-02 05:00:00	ES	Futures	1628.71	1629.22	1627.16	1627.68	15501.0
2013-05-02 06:00:00	ES	Futures	1627.68	1629.99	1627.42	1629.74	13821.0
2013-05-02 07:00:00	ES	Futures	1629.99	1633.6	1628.71	1632.05	52622.0
2013-05-02 08:00:00	ES	Futures	1631.8	1636.95	1629.99	1631.28	139998.0
2013-05-02 09:00:00	ES	Futures	1631.28	1633.6	1627.68	1630.77	295340.0
2013-05-02 10:00:00	ES	Futures	1631.02	1636.43	1630.77	1635.15	238952.0
2013-05-02 11:00:00	ES	Futures	1635.4	1641.58	1634.89	1640.81	271512.0
2013-05-02 12:00:00	ES	Futures	1640.81	1641.84	1638.49	1640.04	91971.0
2013-05-02 13:00:00	ES	Futures	1640.3	1642.62	1639.78	1642.1	97018.0
2013-05-02 14:00:00	ES	Futures	1641.84	1642.62	1640.3	1641.33	106357.0
2013-05-02 15:00:00	ES	Futures	1641.58	1642.1	1639.78	1640.81	172732.0
2013-05-02 16:00:00	ES	Futures	1640.81	1641.33	1640.3	1640.81	70187.0
2013-05-02 17:00:00	ES	Futures	1640.81	1641.07	1640.55	1640.81	1413.0
2013-05-02 18:00:00	ES	Futures	1640.55	1640.81	1639.78	1640.04	2842.0
2013-05-02 19:00:00	ES	Futures	1640.3	1641.07	1640.04	1640.3	1539.0
2013-05-02 20:00:00	ES	Futures	1640.04	1641.07	1640.04	1640.3	2329.0
2013-05-02 21:00:00	ES	Futures	1640.04	1640.55	1639.52	1640.55	2322.0
2013-05-02 22:00:00	ES	Futures	1640.3	1640.55	1639.01	1639.78	2904.0
2013-05-02 23:00:00	ES	Futures	1639.78	1640.04	1639.52	1639.52	925.0
2013-05-02 00:00:00	NQ	Futures	3349.81	3350.1	3348.35	3348.93	259.0
2013-05-02 01:00:00	NQ	Futures	3349.22	3349.81	3347.18	3348.93	494.0
2013-05-02 02:00:00	NQ	Futures	3348.64	3351.85	3348.06	3348.35	981.0
2013-05-02 03:00:00	NQ	Futures	3348.35	3352.43	3347.47	3351.56	2047.0
2013-05-02 04:00:00	NQ	Futures	3351.56	3352.43	3348.35	3349.22	1817.0
2013-05-02 05:00:00	NQ	Futures	3349.22	3349.52	3346.02	3346.89	1726.0
2013-05-02 06:00:00	NQ	Futures	3347.18	3351.56	3346.31	3351.27	1649.0
2013-05-02 07:00:00	NQ	Futures	3351.27	3358.56	3348.35	3355.64	5661.0
2013-05-02 08:00:00	NQ	Futures	3355.93	3367.6	3352.72	3357.39	13869.0
2013-05-02 09:00:00	NQ	Futures	3357.1	3367.6	3348.64	3362.64	41106.0
2013-05-02 10:00:00	NQ	Futures	3362.93	3376.93	3361.77	3375.77	33496.0
2013-05-02 11:00:00	NQ	Futures	3375.77	3389.18	3373.72	3386.85	30108.0
2013-05-02 12:00:00	NQ	Futures	3386.85	3389.77	3382.18	3388.02	11092.0
2013-05-02 13:00:00	NQ	Futures	3388.31	3395.6	3388.02	3393.85	12097.0
2013-05-02 14:00:00	NQ	Futures	3393.56	3394.43	3389.47	3392.1	14073.0
2013-05-02 15:00:00	NQ	Futures	3392.1	3393.27	3387.72	3388.31	20757.0
2013-05-02 16:00:00	NQ	Futures	3388.02	3389.18	3385.1	3386.85	5592.0
2013-05-02 17:00:00	NQ	Futures	3386.85	3387.14	3386.27	3386.56	80.0
2013-05-02 18:00:00	NQ	Futures	3385.68	3386.27	3384.22	3385.1	227.0
2013-05-02 19:00:00	NQ	Futures	3385.1	3387.43	3385.1	3386.85	212.0
2013-05-02 20:00:00	NQ	Futures	3386.85	3388.6	3386.56	3386.85	272.0
2013-05-02 21:00:00	NQ	Futures	3386.56	3387.14	3385.68	3386.56	177.0
2013-05-02 22:00:00	NQ	Futures	3386.56	3388.6	3385.97	3388.31	348.0
2013-05-02 23:00:00	NQ	Futures	3388.31	3388.31	3387.43	3387.43	83.0
2013-05-02 00:00:00	YM	Futures	14826.5	14827.5	14820.5	14824.5	175.0
2013-05-02 01:00:00	YM	Futures	14824.5	14827.5	14818.4	14825.5	331.0

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

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