PREVIEW / futures_1hour / 2013-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-23.parquet
  size:    52 KB
  rows:    1,561

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-23 00:00:00	ES	Futures	1700.06	1701.86	1698.0	1699.8	20555.0
2013-05-23 01:00:00	ES	Futures	1699.8	1700.57	1694.9	1695.16	28357.0
2013-05-23 02:00:00	ES	Futures	1695.16	1695.94	1683.31	1691.04	87140.0
2013-05-23 03:00:00	ES	Futures	1690.78	1693.87	1685.63	1688.21	66148.0
2013-05-23 04:00:00	ES	Futures	1687.95	1688.72	1682.28	1684.6	60389.0
2013-05-23 05:00:00	ES	Futures	1684.6	1688.21	1684.34	1685.37	32015.0
2013-05-23 06:00:00	ES	Futures	1685.63	1692.59	1684.6	1692.07	55354.0
2013-05-23 07:00:00	ES	Futures	1692.33	1694.65	1687.69	1688.72	58230.0
2013-05-23 08:00:00	ES	Futures	1688.72	1692.84	1687.69	1689.5	96500.0
2013-05-23 09:00:00	ES	Futures	1689.75	1691.81	1684.6	1686.15	373179.0
2013-05-23 10:00:00	ES	Futures	1686.15	1695.42	1683.83	1689.75	456527.0
2013-05-23 11:00:00	ES	Futures	1690.01	1699.54	1689.5	1697.74	317193.0
2013-05-23 12:00:00	ES	Futures	1697.74	1702.63	1696.19	1697.74	225121.0
2013-05-23 13:00:00	ES	Futures	1697.74	1699.03	1692.84	1698.51	180955.0
2013-05-23 14:00:00	ES	Futures	1698.77	1704.18	1696.97	1701.6	214913.0
2013-05-23 15:00:00	ES	Futures	1701.6	1703.15	1696.71	1699.28	234997.0
2013-05-23 16:00:00	ES	Futures	1699.03	1701.6	1698.0	1701.09	79814.0
2013-05-23 17:00:00	ES	Futures	1701.09	1701.6	1700.83	1700.83	1438.0
2013-05-23 18:00:00	ES	Futures	1701.34	1702.63	1700.57	1701.86	6430.0
2013-05-23 19:00:00	ES	Futures	1701.86	1703.92	1701.34	1703.41	5835.0
2013-05-23 20:00:00	ES	Futures	1703.41	1705.47	1700.83	1703.15	16047.0
2013-05-23 21:00:00	ES	Futures	1703.15	1704.18	1701.6	1701.86	6495.0
2013-05-23 22:00:00	ES	Futures	1702.12	1703.92	1701.6	1702.37	4622.0
2013-05-23 23:00:00	ES	Futures	1702.12	1702.37	1699.03	1699.8	6960.0
2013-05-23 00:00:00	NQ	Futures	3491.56	3495.93	3487.47	3492.72	1650.0
2013-05-23 01:00:00	NQ	Futures	3492.43	3493.02	3483.68	3483.68	2659.0
2013-05-23 02:00:00	NQ	Futures	3483.97	3485.14	3458.89	3472.31	10182.0
2013-05-23 03:00:00	NQ	Futures	3472.02	3480.18	3462.39	3469.39	7605.0
2013-05-23 04:00:00	NQ	Futures	3469.39	3470.85	3454.81	3458.89	7827.0
2013-05-23 05:00:00	NQ	Futures	3459.18	3464.72	3457.43	3460.64	4693.0
2013-05-23 06:00:00	NQ	Futures	3460.35	3474.64	3458.89	3474.35	5687.0
2013-05-23 07:00:00	NQ	Futures	3474.35	3476.97	3466.18	3467.93	5770.0
2013-05-23 08:00:00	NQ	Futures	3468.22	3480.47	3465.02	3474.93	15632.0
2013-05-23 09:00:00	NQ	Futures	3474.93	3479.02	3461.22	3466.18	56731.0
2013-05-23 10:00:00	NQ	Futures	3466.18	3493.6	3461.52	3479.31	54389.0
2013-05-23 11:00:00	NQ	Futures	3479.6	3497.1	3479.31	3492.14	27649.0
2013-05-23 12:00:00	NQ	Futures	3492.14	3500.02	3487.47	3492.43	19704.0
2013-05-23 13:00:00	NQ	Futures	3492.43	3494.77	3480.47	3490.97	15884.0
2013-05-23 14:00:00	NQ	Futures	3490.97	3502.93	3488.35	3497.97	25645.0
2013-05-23 15:00:00	NQ	Futures	3497.97	3499.72	3487.77	3490.1	37986.0
2013-05-23 16:00:00	NQ	Futures	3490.1	3495.35	3489.22	3495.06	5952.0
2013-05-23 17:00:00	NQ	Futures	3495.35	3496.22	3495.06	3495.06	71.0
2013-05-23 18:00:00	NQ	Futures	3495.06	3497.1	3493.31	3496.22	241.0
2013-05-23 19:00:00	NQ	Futures	3495.35	3500.02	3495.06	3500.02	445.0
2013-05-23 20:00:00	NQ	Futures	3499.72	3503.52	3494.47	3499.14	1450.0
2013-05-23 21:00:00	NQ	Futures	3499.72	3501.77	3496.81	3497.1	977.0
2013-05-23 22:00:00	NQ	Futures	3497.1	3501.47	3496.52	3498.56	818.0
2013-05-23 23:00:00	NQ	Futures	3497.97	3498.56	3493.02	3494.18	885.0
2013-05-23 00:00:00	YM	Futures	15447.2	15458.4	15431.1	15444.2	1933.0
2013-05-23 01:00:00	YM	Futures	15444.2	15447.2	15407.8	15408.8	2695.0

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

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