PREVIEW / futures_1hour / 2013-01-10

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-10.parquet
  size:    51 KB
  rows:    1,556

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-10 00:00:00	ES	Futures	1497.47	1498.24	1497.21	1497.47	2283.0
2013-01-10 01:00:00	ES	Futures	1497.47	1497.98	1496.95	1497.98	2862.0
2013-01-10 02:00:00	ES	Futures	1497.98	1498.49	1496.95	1497.21	5142.0
2013-01-10 03:00:00	ES	Futures	1497.21	1497.47	1495.41	1496.7	14347.0
2013-01-10 04:00:00	ES	Futures	1496.7	1499.26	1496.7	1499.01	20249.0
2013-01-10 05:00:00	ES	Futures	1499.26	1499.52	1497.98	1498.24	16943.0
2013-01-10 06:00:00	ES	Futures	1497.98	1498.49	1497.72	1497.98	13906.0
2013-01-10 07:00:00	ES	Futures	1497.98	1499.77	1497.21	1499.52	24330.0
2013-01-10 08:00:00	ES	Futures	1499.77	1503.62	1499.26	1501.83	89392.0
2013-01-10 09:00:00	ES	Futures	1502.08	1503.37	1499.01	1501.31	181884.0
2013-01-10 10:00:00	ES	Futures	1501.06	1502.08	1495.93	1496.18	314397.0
2013-01-10 11:00:00	ES	Futures	1496.18	1497.98	1494.13	1497.47	183992.0
2013-01-10 12:00:00	ES	Futures	1497.47	1500.8	1496.7	1500.54	119545.0
2013-01-10 13:00:00	ES	Futures	1500.54	1501.06	1498.75	1500.03	85518.0
2013-01-10 14:00:00	ES	Futures	1500.29	1503.62	1498.75	1503.11	135877.0
2013-01-10 15:00:00	ES	Futures	1503.11	1505.93	1502.85	1505.68	203163.0
2013-01-10 16:00:00	ES	Futures	1505.68	1507.47	1504.91	1507.22	80698.0
2013-01-10 17:00:00	ES	Futures	1507.22	1509.01	1506.96	1508.76	6936.0
2013-01-10 18:00:00	ES	Futures	1508.5	1510.3	1507.47	1508.5	14144.0
2013-01-10 19:00:00	ES	Futures	1508.5	1508.5	1506.96	1507.47	5877.0
2013-01-10 20:00:00	ES	Futures	1507.47	1507.47	1506.19	1506.19	5862.0
2013-01-10 21:00:00	ES	Futures	1506.45	1506.96	1505.68	1506.7	4906.0
2013-01-10 22:00:00	ES	Futures	1506.96	1506.96	1505.93	1506.19	3276.0
2013-01-10 23:00:00	ES	Futures	1505.93	1506.7	1505.68	1506.19	3475.0
2013-01-10 00:00:00	NQ	Futures	3177.89	3178.47	3177.02	3177.31	216.0
2013-01-10 01:00:00	NQ	Futures	3177.31	3178.18	3175.56	3177.31	349.0
2013-01-10 02:00:00	NQ	Futures	3177.6	3179.35	3175.56	3175.56	595.0
2013-01-10 03:00:00	NQ	Futures	3175.85	3177.31	3171.78	3173.82	1676.0
2013-01-10 04:00:00	NQ	Futures	3173.82	3180.22	3173.53	3179.06	1589.0
2013-01-10 05:00:00	NQ	Futures	3179.35	3179.93	3175.85	3176.73	1260.0
2013-01-10 06:00:00	NQ	Futures	3176.73	3178.47	3176.15	3177.02	1137.0
2013-01-10 07:00:00	NQ	Futures	3177.31	3182.84	3174.69	3181.97	3939.0
2013-01-10 08:00:00	NQ	Futures	3181.97	3194.19	3181.68	3191.86	12630.0
2013-01-10 09:00:00	NQ	Futures	3192.15	3194.19	3184.59	3189.24	35463.0
2013-01-10 10:00:00	NQ	Futures	3189.53	3190.7	3168.58	3170.03	54284.0
2013-01-10 11:00:00	NQ	Futures	3170.03	3171.78	3159.55	3168.87	36239.0
2013-01-10 12:00:00	NQ	Futures	3168.29	3172.65	3165.67	3171.2	17218.0
2013-01-10 13:00:00	NQ	Futures	3171.2	3174.69	3168.58	3172.65	12843.0
2013-01-10 14:00:00	NQ	Futures	3172.94	3185.46	3168.0	3181.68	23711.0
2013-01-10 15:00:00	NQ	Futures	3181.68	3189.83	3181.39	3188.08	32481.0
2013-01-10 16:00:00	NQ	Futures	3187.79	3190.41	3186.62	3190.12	5620.0
2013-01-10 17:00:00	NQ	Futures	3190.12	3193.61	3189.83	3193.03	364.0
2013-01-10 18:00:00	NQ	Futures	3193.03	3195.36	3190.99	3192.74	766.0
2013-01-10 19:00:00	NQ	Futures	3192.45	3192.74	3189.53	3190.12	522.0
2013-01-10 20:00:00	NQ	Futures	3190.12	3190.41	3187.5	3187.79	574.0
2013-01-10 21:00:00	NQ	Futures	3187.5	3188.66	3186.33	3188.66	592.0
2013-01-10 22:00:00	NQ	Futures	3188.08	3188.66	3186.62	3186.92	219.0
2013-01-10 23:00:00	NQ	Futures	3186.92	3188.66	3186.33	3187.79	360.0
2013-01-10 00:00:00	YM	Futures	13432.4	13434.5	13427.4	13428.4	269.0
2013-01-10 01:00:00	YM	Futures	13428.4	13432.4	13426.4	13431.4	340.0

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

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