PREVIEW / futures_1hour / 2013-04-10

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-10.parquet
  size:    49 KB
  rows:    1,511

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-04-10 00:00:00	ES	Futures	1609.9	1609.9	1609.39	1609.64	3216.0
2013-04-10 01:00:00	ES	Futures	1609.64	1610.67	1609.39	1610.42	4040.0
2013-04-10 02:00:00	ES	Futures	1610.67	1611.96	1610.42	1611.45	8374.0
2013-04-10 03:00:00	ES	Futures	1611.45	1614.54	1611.19	1613.77	31279.0
2013-04-10 04:00:00	ES	Futures	1613.77	1614.54	1612.99	1614.02	20073.0
2013-04-10 05:00:00	ES	Futures	1614.02	1615.57	1613.77	1615.31	20494.0
2013-04-10 06:00:00	ES	Futures	1615.05	1616.6	1615.05	1615.57	19987.0
2013-04-10 07:00:00	ES	Futures	1615.83	1616.08	1614.8	1615.31	21985.0
2013-04-10 08:00:00	ES	Futures	1615.31	1616.34	1611.45	1613.77	83724.0
2013-04-10 09:00:00	ES	Futures	1613.77	1620.21	1612.74	1619.69	327039.0
2013-04-10 10:00:00	ES	Futures	1619.95	1627.42	1619.69	1627.16	433175.0
2013-04-10 11:00:00	ES	Futures	1627.16	1629.99	1625.87	1628.45	290418.0
2013-04-10 12:00:00	ES	Futures	1628.71	1632.05	1627.42	1631.54	170658.0
2013-04-10 13:00:00	ES	Futures	1631.28	1632.31	1629.99	1630.77	116208.0
2013-04-10 14:00:00	ES	Futures	1630.77	1632.31	1628.96	1630.51	117982.0
2013-04-10 15:00:00	ES	Futures	1630.51	1632.57	1628.19	1630.51	242475.0
2013-04-10 16:00:00	ES	Futures	1630.77	1632.31	1630.25	1632.05	90670.0
2013-04-10 17:00:00	ES	Futures	1631.8	1632.31	1631.54	1632.05	1698.0
2013-04-10 18:00:00	ES	Futures	1631.54	1631.8	1630.25	1630.51	5338.0
2013-04-10 19:00:00	ES	Futures	1630.51	1631.02	1629.74	1629.99	2674.0
2013-04-10 20:00:00	ES	Futures	1629.99	1630.77	1629.48	1629.74	4320.0
2013-04-10 21:00:00	ES	Futures	1629.74	1630.51	1628.96	1629.22	6719.0
2013-04-10 22:00:00	ES	Futures	1629.22	1629.48	1628.71	1628.96	3721.0
2013-04-10 23:00:00	ES	Futures	1628.96	1629.74	1628.71	1629.48	2218.0
2013-04-10 00:00:00	NQ	Futures	3263.47	3264.06	3262.6	3263.18	109.0
2013-04-10 01:00:00	NQ	Futures	3263.18	3264.93	3262.89	3264.93	193.0
2013-04-10 02:00:00	NQ	Futures	3264.93	3268.14	3264.93	3267.85	605.0
2013-04-10 03:00:00	NQ	Futures	3267.56	3274.85	3266.97	3273.1	2388.0
2013-04-10 04:00:00	NQ	Futures	3273.39	3274.85	3271.64	3273.1	1134.0
2013-04-10 05:00:00	NQ	Futures	3273.1	3275.72	3273.1	3275.43	965.0
2013-04-10 06:00:00	NQ	Futures	3275.43	3277.47	3275.14	3276.31	1480.0
2013-04-10 07:00:00	NQ	Futures	3276.01	3277.76	3274.26	3275.14	1856.0
2013-04-10 08:00:00	NQ	Futures	3275.14	3277.76	3270.18	3273.97	7333.0
2013-04-10 09:00:00	NQ	Futures	3273.97	3291.76	3272.22	3290.31	43947.0
2013-04-10 10:00:00	NQ	Futures	3290.6	3321.52	3290.6	3320.93	60789.0
2013-04-10 11:00:00	NQ	Futures	3321.22	3326.18	3317.14	3324.72	31414.0
2013-04-10 12:00:00	NQ	Futures	3324.72	3333.77	3321.52	3330.85	27544.0
2013-04-10 13:00:00	NQ	Futures	3330.85	3333.18	3327.93	3328.52	15430.0
2013-04-10 14:00:00	NQ	Futures	3328.52	3331.43	3321.81	3327.64	20288.0
2013-04-10 15:00:00	NQ	Futures	3327.64	3332.31	3322.97	3328.22	33644.0
2013-04-10 16:00:00	NQ	Futures	3327.93	3329.39	3326.77	3327.06	7962.0
2013-04-10 17:00:00	NQ	Futures	3327.64	3327.93	3327.06	3327.06	175.0
2013-04-10 18:00:00	NQ	Futures	3327.35	3327.35	3322.1	3322.68	1705.0
2013-04-10 19:00:00	NQ	Futures	3322.97	3323.85	3322.1	3322.68	359.0
2013-04-10 20:00:00	NQ	Futures	3322.68	3323.85	3322.1	3322.68	484.0
2013-04-10 21:00:00	NQ	Futures	3322.68	3323.56	3320.64	3321.22	794.0
2013-04-10 22:00:00	NQ	Futures	3321.22	3322.1	3320.35	3321.22	474.0
2013-04-10 23:00:00	NQ	Futures	3321.22	3322.97	3321.22	3322.39	266.0
2013-04-10 00:00:00	YM	Futures	14762.8	14764.9	14759.8	14759.8	206.0
2013-04-10 01:00:00	YM	Futures	14760.8	14767.9	14759.8	14767.9	295.0

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

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