PREVIEW / futures_1hour / 2013-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-15.parquet
  size:    41 KB
  rows:    1,239

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-03-15 00:00:00	ES	Futures	1604.24	1604.75	1603.98	1604.49	3719.0
2013-03-15 01:00:00	ES	Futures	1604.24	1605.27	1603.98	1604.75	4351.0
2013-03-15 02:00:00	ES	Futures	1605.01	1606.04	1604.49	1605.52	5970.0
2013-03-15 03:00:00	ES	Futures	1605.27	1606.04	1603.98	1605.01	8629.0
2013-03-15 04:00:00	ES	Futures	1604.75	1604.75	1601.92	1602.43	24140.0
2013-03-15 05:00:00	ES	Futures	1602.69	1603.2	1601.4	1601.66	19570.0
2013-03-15 06:00:00	ES	Futures	1601.66	1602.69	1601.14	1601.92	21003.0
2013-03-15 07:00:00	ES	Futures	1601.92	1603.46	1601.66	1603.2	28675.0
2013-03-15 08:00:00	ES	Futures	1602.95	1604.49	1602.69	1603.72	40788.0
2013-03-15 09:00:00	ES	Futures	1603.98	1604.24	1597.28	1597.28	356659.0
2013-03-15 10:00:00	ES	Futures	1597.28	1601.14	1595.99	1599.86	301705.0
2013-03-15 11:00:00	ES	Futures	1600.11	1602.69	1599.86	1602.17	162551.0
2013-03-15 12:00:00	ES	Futures	1602.17	1603.72	1601.4	1602.17	123205.0
2013-03-15 13:00:00	ES	Futures	1602.17	1602.43	1601.14	1601.4	78181.0
2013-03-15 14:00:00	ES	Futures	1601.4	1601.66	1597.8	1599.08	141016.0
2013-03-15 15:00:00	ES	Futures	1598.83	1601.66	1598.31	1601.66	206019.0
2013-03-15 16:00:00	ES	Futures	1601.4	1601.66	1600.11	1600.63	108696.0
2013-03-15 17:00:00	ES	Futures	1600.63	1600.63	1599.6	1599.6	3295.0
2013-03-15 00:00:00	NQ	Futures	3270.47	3271.06	3270.18	3270.76	152.0
2013-03-15 01:00:00	NQ	Futures	3271.06	3271.93	3270.76	3270.76	273.0
2013-03-15 02:00:00	NQ	Futures	3270.76	3272.51	3270.76	3271.35	191.0
2013-03-15 03:00:00	NQ	Futures	3271.64	3272.81	3269.89	3270.76	545.0
2013-03-15 04:00:00	NQ	Futures	3270.47	3270.76	3266.39	3267.26	1421.0
2013-03-15 05:00:00	NQ	Futures	3267.26	3268.14	3264.64	3265.22	1151.0
2013-03-15 06:00:00	NQ	Futures	3265.22	3267.56	3264.35	3266.68	1289.0
2013-03-15 07:00:00	NQ	Futures	3266.39	3270.47	3266.39	3269.89	1958.0
2013-03-15 08:00:00	NQ	Futures	3269.6	3272.81	3269.31	3271.35	3860.0
2013-03-15 09:00:00	NQ	Futures	3271.06	3272.22	3255.6	3255.89	35150.0
2013-03-15 10:00:00	NQ	Futures	3255.89	3260.26	3251.81	3257.35	25543.0
2013-03-15 11:00:00	NQ	Futures	3257.35	3266.1	3256.47	3262.31	18213.0
2013-03-15 12:00:00	NQ	Futures	3262.31	3266.97	3260.56	3263.76	12006.0
2013-03-15 13:00:00	NQ	Futures	3263.76	3264.35	3260.85	3260.85	6167.0
2013-03-15 14:00:00	NQ	Futures	3260.85	3262.31	3248.89	3252.68	15945.0
2013-03-15 15:00:00	NQ	Futures	3252.68	3257.93	3250.93	3257.06	18869.0
2013-03-15 16:00:00	NQ	Futures	3257.35	3258.81	3256.18	3256.76	6242.0
2013-03-15 17:00:00	NQ	Futures	3256.76	3257.35	3256.47	3257.06	151.0
2013-03-15 00:00:00	YM	Futures	14618.3	14623.3	14617.3	14622.3	475.0
2013-03-15 01:00:00	YM	Futures	14621.3	14632.4	14620.3	14626.4	951.0
2013-03-15 02:00:00	YM	Futures	14626.4	14638.5	14626.4	14630.4	775.0
2013-03-15 03:00:00	YM	Futures	14631.4	14634.4	14623.3	14628.4	892.0
2013-03-15 04:00:00	YM	Futures	14627.4	14627.4	14610.2	14612.2	1841.0
2013-03-15 05:00:00	YM	Futures	14612.2	14617.3	14607.1	14608.2	1560.0
2013-03-15 06:00:00	YM	Futures	14608.2	14613.2	14604.1	14606.1	1609.0
2013-03-15 07:00:00	YM	Futures	14605.1	14611.2	14601.1	14608.2	1493.0
2013-03-15 08:00:00	YM	Futures	14609.2	14619.3	14605.1	14612.2	2821.0
2013-03-15 09:00:00	YM	Futures	14613.2	14616.2	14562.7	14564.7	20467.0
2013-03-15 10:00:00	YM	Futures	14564.7	14590.0	14554.6	14580.9	19140.0
2013-03-15 11:00:00	YM	Futures	14581.9	14605.1	14579.8	14592.0	10245.0
2013-03-15 12:00:00	YM	Futures	14591.0	14602.1	14584.9	14585.9	5746.0
2013-03-15 13:00:00	YM	Futures	14585.9	14587.9	14581.9	14584.9	3779.0

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

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