PREVIEW / futures_1hour / 2013-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-07.parquet
  size:    48 KB
  rows:    1,501

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-01-07 00:00:00	ES	Futures	1494.64	1494.64	1493.1	1493.62	4508.0
2013-01-07 01:00:00	ES	Futures	1493.62	1495.16	1493.62	1495.16	4059.0
2013-01-07 02:00:00	ES	Futures	1495.16	1496.44	1494.64	1494.9	6075.0
2013-01-07 03:00:00	ES	Futures	1494.9	1496.18	1493.87	1494.39	15905.0
2013-01-07 04:00:00	ES	Futures	1494.64	1495.16	1493.87	1494.64	16005.0
2013-01-07 05:00:00	ES	Futures	1494.9	1495.16	1494.13	1494.9	12796.0
2013-01-07 06:00:00	ES	Futures	1494.64	1495.16	1493.62	1494.13	11490.0
2013-01-07 07:00:00	ES	Futures	1494.13	1495.41	1493.87	1494.64	18379.0
2013-01-07 08:00:00	ES	Futures	1494.64	1495.41	1493.36	1493.62	25485.0
2013-01-07 09:00:00	ES	Futures	1493.36	1493.87	1490.79	1492.33	181667.0
2013-01-07 10:00:00	ES	Futures	1492.59	1494.64	1492.08	1492.85	150587.0
2013-01-07 11:00:00	ES	Futures	1493.1	1493.87	1490.02	1490.28	164969.0
2013-01-07 12:00:00	ES	Futures	1490.28	1491.05	1489.0	1490.02	123522.0
2013-01-07 13:00:00	ES	Futures	1490.28	1491.82	1489.51	1490.79	70916.0
2013-01-07 14:00:00	ES	Futures	1490.54	1493.62	1490.54	1493.62	118041.0
2013-01-07 15:00:00	ES	Futures	1493.62	1496.18	1492.85	1494.64	162273.0
2013-01-07 16:00:00	ES	Futures	1494.64	1495.93	1493.62	1494.9	70257.0
2013-01-07 17:00:00	ES	Futures	1494.9	1495.41	1494.64	1495.16	925.0
2013-01-07 18:00:00	ES	Futures	1495.16	1495.16	1493.87	1494.13	3318.0
2013-01-07 19:00:00	ES	Futures	1493.87	1495.16	1493.36	1495.16	5306.0
2013-01-07 20:00:00	ES	Futures	1494.9	1495.41	1493.87	1493.87	4640.0
2013-01-07 21:00:00	ES	Futures	1494.13	1495.16	1493.87	1494.64	3988.0
2013-01-07 22:00:00	ES	Futures	1494.64	1494.9	1493.1	1493.62	3699.0
2013-01-07 23:00:00	ES	Futures	1493.62	1493.62	1492.59	1493.36	4022.0
2013-01-07 00:00:00	NQ	Futures	3155.77	3155.77	3152.86	3154.9	405.0
2013-01-07 01:00:00	NQ	Futures	3154.61	3158.39	3154.32	3158.39	287.0
2013-01-07 02:00:00	NQ	Futures	3158.1	3161.3	3157.81	3158.1	454.0
2013-01-07 03:00:00	NQ	Futures	3157.81	3161.59	3155.19	3158.39	1853.0
2013-01-07 04:00:00	NQ	Futures	3158.68	3160.14	3156.35	3158.97	1558.0
2013-01-07 05:00:00	NQ	Futures	3158.97	3159.26	3156.35	3157.81	1668.0
2013-01-07 06:00:00	NQ	Futures	3157.23	3157.81	3154.61	3156.64	1017.0
2013-01-07 07:00:00	NQ	Futures	3156.64	3160.72	3153.73	3155.19	3055.0
2013-01-07 08:00:00	NQ	Futures	3155.19	3157.52	3151.99	3153.73	3253.0
2013-01-07 09:00:00	NQ	Futures	3153.73	3156.35	3146.46	3150.82	32648.0
2013-01-07 10:00:00	NQ	Futures	3150.82	3165.96	3149.37	3160.14	27866.0
2013-01-07 11:00:00	NQ	Futures	3160.14	3168.0	3154.32	3155.19	26741.0
2013-01-07 12:00:00	NQ	Futures	3155.19	3158.1	3151.7	3154.61	15474.0
2013-01-07 13:00:00	NQ	Futures	3154.9	3159.85	3150.82	3154.02	11517.0
2013-01-07 14:00:00	NQ	Futures	3154.02	3162.76	3154.02	3161.01	13544.0
2013-01-07 15:00:00	NQ	Futures	3161.01	3170.03	3158.68	3165.67	25938.0
2013-01-07 16:00:00	NQ	Futures	3165.38	3168.29	3162.47	3164.5	4715.0
2013-01-07 17:00:00	NQ	Futures	3164.5	3165.09	3164.21	3164.5	113.0
2013-01-07 18:00:00	NQ	Futures	3165.38	3165.38	3163.92	3163.92	183.0
2013-01-07 19:00:00	NQ	Futures	3163.63	3164.5	3162.76	3164.5	351.0
2013-01-07 20:00:00	NQ	Futures	3164.5	3165.38	3161.59	3161.59	384.0
2013-01-07 21:00:00	NQ	Futures	3161.88	3165.09	3161.59	3164.5	349.0
2013-01-07 22:00:00	NQ	Futures	3164.5	3164.79	3160.72	3161.88	227.0
2013-01-07 23:00:00	NQ	Futures	3161.59	3162.17	3159.55	3160.14	277.0
2013-01-07 00:00:00	YM	Futures	13408.3	13409.3	13400.3	13405.3	736.0
2013-01-07 01:00:00	YM	Futures	13405.3	13416.3	13404.3	13415.3	349.0

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

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