PREVIEW / futures_1hour / 2013-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-25.parquet
  size:    52 KB
  rows:    1,548

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-25 00:00:00	ES	Futures	1614.56	1616.63	1613.01	1616.11	10006.0
2013-06-25 01:00:00	ES	Futures	1615.85	1619.21	1611.2	1617.92	15255.0
2013-06-25 02:00:00	ES	Futures	1618.18	1627.48	1617.66	1625.42	25387.0
2013-06-25 03:00:00	ES	Futures	1625.42	1628.78	1621.8	1626.45	39316.0
2013-06-25 04:00:00	ES	Futures	1626.45	1630.33	1623.35	1629.55	34502.0
2013-06-25 05:00:00	ES	Futures	1629.55	1631.1	1626.71	1629.03	19234.0
2013-06-25 06:00:00	ES	Futures	1629.29	1630.07	1624.64	1625.93	26461.0
2013-06-25 07:00:00	ES	Futures	1626.19	1632.14	1625.42	1631.62	34685.0
2013-06-25 08:00:00	ES	Futures	1631.62	1632.39	1628.26	1629.29	45944.0
2013-06-25 09:00:00	ES	Futures	1629.03	1636.27	1626.45	1629.55	317804.0
2013-06-25 10:00:00	ES	Futures	1629.29	1634.72	1623.35	1633.43	409457.0
2013-06-25 11:00:00	ES	Futures	1633.43	1636.01	1629.29	1633.69	194997.0
2013-06-25 12:00:00	ES	Futures	1633.69	1636.79	1632.39	1633.95	114943.0
2013-06-25 13:00:00	ES	Futures	1633.95	1635.24	1629.81	1632.39	144236.0
2013-06-25 14:00:00	ES	Futures	1632.14	1637.82	1630.84	1634.46	132289.0
2013-06-25 15:00:00	ES	Futures	1634.46	1641.7	1634.2	1635.76	308451.0
2013-06-25 16:00:00	ES	Futures	1635.76	1636.53	1633.95	1634.72	84421.0
2013-06-25 17:00:00	ES	Futures	1634.72	1634.98	1634.2	1634.2	1884.0
2013-06-25 18:00:00	ES	Futures	1633.95	1634.98	1632.91	1634.2	4640.0
2013-06-25 19:00:00	ES	Futures	1633.95	1634.2	1630.07	1630.59	7103.0
2013-06-25 20:00:00	ES	Futures	1630.84	1633.17	1627.48	1632.14	14212.0
2013-06-25 21:00:00	ES	Futures	1632.14	1632.39	1628.52	1630.33	10963.0
2013-06-25 22:00:00	ES	Futures	1630.59	1631.1	1626.45	1628.0	12704.0
2013-06-25 23:00:00	ES	Futures	1628.0	1629.29	1627.48	1629.29	4463.0
2013-06-25 00:00:00	NQ	Futures	3315.42	3318.63	3312.79	3317.75	1483.0
2013-06-25 01:00:00	NQ	Futures	3317.75	3324.48	3308.99	3322.72	3137.0
2013-06-25 02:00:00	NQ	Futures	3322.72	3340.55	3321.55	3337.04	2742.0
2013-06-25 03:00:00	NQ	Futures	3337.04	3342.89	3329.44	3339.67	5424.0
2013-06-25 04:00:00	NQ	Futures	3339.67	3346.98	3332.95	3345.22	3894.0
2013-06-25 05:00:00	NQ	Futures	3345.22	3349.32	3340.84	3344.64	2410.0
2013-06-25 06:00:00	NQ	Futures	3345.22	3346.98	3337.33	3339.96	3109.0
2013-06-25 07:00:00	NQ	Futures	3339.96	3351.65	3338.79	3349.9	4149.0
2013-06-25 08:00:00	NQ	Futures	3349.9	3351.65	3342.59	3344.64	5297.0
2013-06-25 09:00:00	NQ	Futures	3344.35	3359.25	3336.46	3341.13	50385.0
2013-06-25 10:00:00	NQ	Futures	3341.13	3345.22	3324.77	3337.04	63942.0
2013-06-25 11:00:00	NQ	Futures	3336.75	3342.01	3330.32	3340.84	23747.0
2013-06-25 12:00:00	NQ	Futures	3340.84	3346.1	3337.92	3339.67	12147.0
2013-06-25 13:00:00	NQ	Futures	3339.38	3341.13	3330.9	3334.41	15857.0
2013-06-25 14:00:00	NQ	Futures	3334.41	3342.59	3332.66	3337.63	15142.0
2013-06-25 15:00:00	NQ	Futures	3337.63	3354.28	3337.63	3343.18	31872.0
2013-06-25 16:00:00	NQ	Futures	3343.18	3345.52	3341.13	3342.01	5122.0
2013-06-25 17:00:00	NQ	Futures	3342.01	3342.89	3341.42	3342.3	66.0
2013-06-25 18:00:00	NQ	Futures	3339.67	3342.59	3339.09	3340.84	239.0
2013-06-25 19:00:00	NQ	Futures	3340.55	3341.42	3334.12	3334.7	362.0
2013-06-25 20:00:00	NQ	Futures	3334.7	3339.96	3328.57	3338.5	1503.0
2013-06-25 21:00:00	NQ	Futures	3338.5	3338.5	3329.74	3334.12	1275.0
2013-06-25 22:00:00	NQ	Futures	3334.7	3335.29	3326.52	3328.86	1823.0
2013-06-25 23:00:00	NQ	Futures	3328.86	3332.37	3328.27	3332.37	687.0
2013-06-25 00:00:00	YM	Futures	14779.2	14793.4	14769.0	14790.4	1495.0
2013-06-25 01:00:00	YM	Futures	14790.4	14819.8	14754.8	14812.7	3036.0

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

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