PREVIEW / futures_1hour / 2009-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-04.parquet
  size:    42 KB
  rows:    1,212

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
2009-05-04 00:00:00	ES	Futures	842.07	843.27	841.59	841.59	2875.0
2009-05-04 01:00:00	ES	Futures	841.83	843.51	841.59	842.31	3413.0
2009-05-04 02:00:00	ES	Futures	842.55	845.19	842.07	844.71	8669.0
2009-05-04 03:00:00	ES	Futures	844.71	846.15	842.55	845.91	12886.0
2009-05-04 04:00:00	ES	Futures	846.15	846.39	843.75	845.19	8813.0
2009-05-04 05:00:00	ES	Futures	845.19	847.11	844.95	846.39	8700.0
2009-05-04 06:00:00	ES	Futures	846.39	846.39	843.75	844.23	7893.0
2009-05-04 07:00:00	ES	Futures	844.23	844.47	841.83	843.99	9810.0
2009-05-04 08:00:00	ES	Futures	843.75	845.19	841.59	843.99	23732.0
2009-05-04 09:00:00	ES	Futures	843.99	850.46	842.55	850.22	249947.0
2009-05-04 10:00:00	ES	Futures	850.22	857.41	850.22	854.53	341301.0
2009-05-04 11:00:00	ES	Futures	854.77	858.85	854.05	855.25	248722.0
2009-05-04 12:00:00	ES	Futures	855.25	857.89	852.14	854.77	234725.0
2009-05-04 13:00:00	ES	Futures	854.77	859.57	854.29	858.61	148917.0
2009-05-04 14:00:00	ES	Futures	858.61	861.0	856.21	858.85	238758.0
2009-05-04 15:00:00	ES	Futures	859.09	867.23	858.37	867.23	464758.0
2009-05-04 16:00:00	ES	Futures	867.23	867.23	865.08	865.56	134858.0
2009-05-04 17:00:00	ES	Futures	865.56	865.8	865.08	865.56	1767.0
2009-05-04 18:00:00	ES	Futures	865.32	866.28	864.84	866.04	2977.0
2009-05-04 19:00:00	ES	Futures	866.04	866.28	864.84	864.84	1487.0
2009-05-04 20:00:00	ES	Futures	865.08	865.08	862.68	863.16	7309.0
2009-05-04 21:00:00	ES	Futures	863.16	863.4	861.96	862.44	6125.0
2009-05-04 22:00:00	ES	Futures	862.44	863.64	861.96	862.68	3389.0
2009-05-04 23:00:00	ES	Futures	862.44	863.4	861.72	862.44	3853.0
2009-05-04 00:00:00	NQ	Futures	1595.16	1598.29	1595.16	1595.16	200.0
2009-05-04 01:00:00	NQ	Futures	1595.16	1598.57	1595.16	1596.3	137.0
2009-05-04 02:00:00	NQ	Futures	1595.73	1599.99	1595.73	1599.14	668.0
2009-05-04 03:00:00	NQ	Futures	1599.14	1602.26	1596.58	1601.98	1027.0
2009-05-04 04:00:00	NQ	Futures	1601.7	1603.12	1598.57	1600.84	831.0
2009-05-04 05:00:00	NQ	Futures	1601.13	1605.11	1600.84	1602.26	951.0
2009-05-04 06:00:00	NQ	Futures	1601.98	1601.98	1598.0	1598.57	703.0
2009-05-04 07:00:00	NQ	Futures	1598.85	1603.69	1596.58	1600.56	1780.0
2009-05-04 08:00:00	NQ	Futures	1600.56	1601.7	1596.01	1600.28	3533.0
2009-05-04 09:00:00	NQ	Futures	1600.28	1603.12	1593.46	1599.99	34741.0
2009-05-04 10:00:00	NQ	Futures	1599.99	1616.19	1599.71	1607.95	49453.0
2009-05-04 11:00:00	NQ	Futures	1608.23	1615.34	1606.81	1609.08	31422.0
2009-05-04 12:00:00	NQ	Futures	1609.37	1613.91	1605.11	1609.37	30064.0
2009-05-04 13:00:00	NQ	Futures	1609.37	1617.32	1608.23	1614.48	23411.0
2009-05-04 14:00:00	NQ	Futures	1614.48	1616.76	1609.37	1611.36	30063.0
2009-05-04 15:00:00	NQ	Futures	1611.36	1619.88	1609.94	1619.31	47363.0
2009-05-04 16:00:00	NQ	Futures	1618.74	1620.73	1615.9	1619.6	14570.0
2009-05-04 17:00:00	NQ	Futures	1619.6	1619.88	1618.46	1619.03	60.0
2009-05-04 18:00:00	NQ	Futures	1619.6	1621.59	1619.03	1621.02	338.0
2009-05-04 19:00:00	NQ	Futures	1621.02	1621.02	1619.31	1620.73	247.0
2009-05-04 20:00:00	NQ	Futures	1620.17	1620.17	1616.19	1616.76	601.0
2009-05-04 21:00:00	NQ	Futures	1616.47	1617.04	1615.34	1616.76	424.0
2009-05-04 22:00:00	NQ	Futures	1616.76	1617.89	1615.05	1617.04	304.0
2009-05-04 23:00:00	NQ	Futures	1616.47	1617.32	1615.34	1616.76	278.0
2009-05-04 00:00:00	YM	Futures	7540.9	7551.9	7534.5	7534.5	245.0
2009-05-04 01:00:00	YM	Futures	7535.4	7551.9	7534.5	7542.7	264.0

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

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