PREVIEW / futures_1hour / 2013-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-28.parquet
  size:    42 KB
  rows:    1,247

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-28 00:00:00	ES	Futures	1597.8	1598.31	1597.02	1597.02	4150.0
2013-03-28 01:00:00	ES	Futures	1597.28	1598.57	1596.77	1597.54	8417.0
2013-03-28 02:00:00	ES	Futures	1597.8	1599.34	1597.54	1599.34	3976.0
2013-03-28 03:00:00	ES	Futures	1599.08	1601.14	1598.83	1601.14	12964.0
2013-03-28 04:00:00	ES	Futures	1600.89	1603.72	1599.08	1599.34	36144.0
2013-03-28 05:00:00	ES	Futures	1599.08	1601.66	1598.31	1600.63	30157.0
2013-03-28 06:00:00	ES	Futures	1600.89	1605.78	1600.11	1605.52	31640.0
2013-03-28 07:00:00	ES	Futures	1605.52	1606.3	1604.49	1604.75	31924.0
2013-03-28 08:00:00	ES	Futures	1604.75	1606.3	1602.69	1602.69	46768.0
2013-03-28 09:00:00	ES	Futures	1602.69	1606.81	1601.66	1604.49	221879.0
2013-03-28 10:00:00	ES	Futures	1604.24	1609.9	1603.72	1608.87	242701.0
2013-03-28 11:00:00	ES	Futures	1608.87	1610.16	1607.58	1608.61	172598.0
2013-03-28 12:00:00	ES	Futures	1608.36	1608.87	1605.52	1607.84	172473.0
2013-03-28 13:00:00	ES	Futures	1607.58	1608.1	1606.3	1607.58	51556.0
2013-03-28 14:00:00	ES	Futures	1607.84	1609.64	1607.58	1609.39	69873.0
2013-03-28 15:00:00	ES	Futures	1609.64	1611.96	1607.58	1609.13	311002.0
2013-03-28 16:00:00	ES	Futures	1609.13	1611.19	1607.84	1610.93	135996.0
2013-03-28 17:00:00	ES	Futures	1610.93	1611.45	1610.67	1611.19	2736.0
2013-03-28 00:00:00	NQ	Futures	3258.81	3259.68	3257.64	3257.64	221.0
2013-03-28 01:00:00	NQ	Futures	3257.93	3259.97	3256.76	3258.81	327.0
2013-03-28 02:00:00	NQ	Futures	3258.81	3261.43	3258.22	3260.85	123.0
2013-03-28 03:00:00	NQ	Futures	3261.14	3265.51	3261.14	3265.51	1108.0
2013-03-28 04:00:00	NQ	Futures	3265.51	3270.47	3261.72	3261.72	2889.0
2013-03-28 05:00:00	NQ	Futures	3261.72	3267.56	3259.97	3266.1	2767.0
2013-03-28 06:00:00	NQ	Futures	3265.81	3274.85	3264.64	3274.56	2741.0
2013-03-28 07:00:00	NQ	Futures	3274.56	3277.18	3273.1	3273.97	2216.0
2013-03-28 08:00:00	NQ	Futures	3273.97	3277.18	3270.18	3270.47	4904.0
2013-03-28 09:00:00	NQ	Futures	3270.47	3274.26	3264.64	3270.18	24312.0
2013-03-28 10:00:00	NQ	Futures	3270.47	3278.06	3266.68	3275.43	25169.0
2013-03-28 11:00:00	NQ	Futures	3275.43	3277.47	3272.22	3273.39	16118.0
2013-03-28 12:00:00	NQ	Futures	3273.39	3274.85	3268.72	3273.1	15051.0
2013-03-28 13:00:00	NQ	Futures	3273.1	3275.14	3270.47	3273.68	5163.0
2013-03-28 14:00:00	NQ	Futures	3273.97	3277.47	3273.39	3277.18	6592.0
2013-03-28 15:00:00	NQ	Futures	3277.18	3283.89	3273.1	3280.39	26117.0
2013-03-28 16:00:00	NQ	Futures	3280.1	3283.31	3279.22	3281.85	6671.0
2013-03-28 17:00:00	NQ	Futures	3281.85	3283.31	3281.85	3282.14	125.0
2013-03-28 00:00:00	YM	Futures	14562.7	14565.7	14557.6	14557.6	350.0
2013-03-28 01:00:00	YM	Futures	14559.6	14571.8	14554.6	14565.7	926.0
2013-03-28 02:00:00	YM	Futures	14565.7	14580.9	14564.7	14578.8	706.0
2013-03-28 03:00:00	YM	Futures	14579.8	14598.0	14577.8	14598.0	1373.0
2013-03-28 04:00:00	YM	Futures	14597.0	14617.3	14578.8	14578.8	3545.0
2013-03-28 05:00:00	YM	Futures	14578.8	14600.1	14573.8	14593.0	3125.0
2013-03-28 06:00:00	YM	Futures	14593.0	14633.4	14587.9	14629.4	2135.0
2013-03-28 07:00:00	YM	Futures	14630.4	14635.5	14622.3	14623.3	2016.0
2013-03-28 08:00:00	YM	Futures	14623.3	14634.4	14603.1	14605.1	3814.0
2013-03-28 09:00:00	YM	Futures	14604.1	14645.6	14603.1	14629.4	19424.0
2013-03-28 10:00:00	YM	Futures	14630.4	14667.8	14625.3	14661.7	19484.0
2013-03-28 11:00:00	YM	Futures	14661.7	14669.8	14650.6	14655.7	13454.0
2013-03-28 12:00:00	YM	Futures	14656.7	14658.7	14632.4	14642.5	12110.0
2013-03-28 13:00:00	YM	Futures	14642.5	14647.6	14633.4	14641.5	4482.0

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

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