PREVIEW / futures_1hour / 2013-06-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	1629.29	1631.62	1628.52	1629.55	5066.0
2013-06-26 01:00:00	ES	Futures	1629.55	1631.88	1629.03	1630.59	5461.0
2013-06-26 02:00:00	ES	Futures	1630.33	1633.43	1630.07	1633.17	10012.0
2013-06-26 03:00:00	ES	Futures	1633.43	1637.56	1630.07	1637.31	36029.0
2013-06-26 04:00:00	ES	Futures	1637.31	1640.93	1636.79	1638.6	32402.0
2013-06-26 05:00:00	ES	Futures	1638.6	1642.48	1638.6	1642.48	17283.0
2013-06-26 06:00:00	ES	Futures	1642.48	1643.77	1640.93	1641.18	24922.0
2013-06-26 07:00:00	ES	Futures	1641.18	1645.84	1640.93	1645.32	33123.0
2013-06-26 08:00:00	ES	Futures	1645.58	1645.58	1641.7	1645.32	68546.0
2013-06-26 09:00:00	ES	Futures	1645.32	1652.04	1644.29	1649.97	251101.0
2013-06-26 10:00:00	ES	Futures	1649.97	1651.78	1644.8	1645.84	261185.0
2013-06-26 11:00:00	ES	Futures	1645.84	1647.39	1642.48	1644.03	196866.0
2013-06-26 12:00:00	ES	Futures	1644.03	1649.2	1643.77	1647.13	110197.0
2013-06-26 13:00:00	ES	Futures	1647.13	1652.56	1646.35	1651.01	135943.0
2013-06-26 14:00:00	ES	Futures	1651.01	1654.11	1649.71	1652.82	121248.0
2013-06-26 15:00:00	ES	Futures	1652.56	1655.66	1651.01	1651.52	251332.0
2013-06-26 16:00:00	ES	Futures	1651.78	1652.04	1649.2	1650.75	99499.0
2013-06-26 17:00:00	ES	Futures	1650.49	1651.52	1650.49	1651.26	2709.0
2013-06-26 18:00:00	ES	Futures	1651.01	1651.26	1649.46	1649.97	3467.0
2013-06-26 19:00:00	ES	Futures	1649.97	1650.49	1648.94	1648.94	2739.0
2013-06-26 20:00:00	ES	Futures	1649.2	1650.75	1648.94	1650.75	4787.0
2013-06-26 21:00:00	ES	Futures	1650.75	1654.63	1650.49	1654.63	12488.0
2013-06-26 22:00:00	ES	Futures	1654.37	1655.4	1654.11	1654.11	5611.0
2013-06-26 23:00:00	ES	Futures	1654.11	1654.63	1649.97	1649.97	7335.0
2013-06-26 00:00:00	NQ	Futures	3332.37	3337.33	3332.07	3334.12	1090.0
2013-06-26 01:00:00	NQ	Futures	3334.41	3338.5	3333.24	3334.7	679.0
2013-06-26 02:00:00	NQ	Futures	3334.7	3340.55	3334.7	3340.26	807.0
2013-06-26 03:00:00	NQ	Futures	3340.55	3348.44	3333.24	3348.15	5010.0
2013-06-26 04:00:00	NQ	Futures	3348.15	3357.21	3347.56	3351.95	3008.0
2013-06-26 05:00:00	NQ	Futures	3351.95	3360.42	3351.65	3360.42	1752.0
2013-06-26 06:00:00	NQ	Futures	3360.42	3362.76	3357.5	3357.79	2226.0
2013-06-26 07:00:00	NQ	Futures	3357.5	3367.14	3357.5	3365.97	2403.0
2013-06-26 08:00:00	NQ	Futures	3365.68	3366.26	3357.5	3366.26	6344.0
2013-06-26 09:00:00	NQ	Futures	3366.26	3379.12	3363.63	3372.99	31650.0
2013-06-26 10:00:00	NQ	Futures	3373.28	3377.95	3362.76	3369.77	30983.0
2013-06-26 11:00:00	NQ	Futures	3369.48	3372.4	3361.88	3363.93	26284.0
2013-06-26 12:00:00	NQ	Futures	3363.93	3373.28	3363.63	3367.43	13135.0
2013-06-26 13:00:00	NQ	Futures	3367.43	3376.79	3365.39	3372.11	14811.0
2013-06-26 14:00:00	NQ	Futures	3372.4	3376.79	3370.06	3374.16	12659.0
2013-06-26 15:00:00	NQ	Futures	3374.16	3381.46	3373.57	3373.86	28512.0
2013-06-26 16:00:00	NQ	Futures	3373.57	3375.62	3371.23	3373.28	9026.0
2013-06-26 17:00:00	NQ	Futures	3373.28	3374.16	3372.99	3373.86	77.0
2013-06-26 18:00:00	NQ	Futures	3373.28	3373.57	3369.48	3371.82	292.0
2013-06-26 19:00:00	NQ	Futures	3371.53	3372.99	3369.48	3369.48	226.0
2013-06-26 20:00:00	NQ	Futures	3369.77	3373.86	3369.77	3372.99	570.0
2013-06-26 21:00:00	NQ	Futures	3373.28	3380.88	3372.99	3380.58	841.0
2013-06-26 22:00:00	NQ	Futures	3380.88	3383.51	3379.71	3380.58	571.0
2013-06-26 23:00:00	NQ	Futures	3380.88	3381.46	3371.23	3371.23	687.0
2013-06-26 00:00:00	YM	Futures	14872.6	14892.9	14867.5	14873.6	721.0
2013-06-26 01:00:00	YM	Futures	14874.7	14895.0	14871.6	14880.7	868.0

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

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