PREVIEW / futures_1hour / 2013-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-14.parquet
  size:    49 KB
  rows:    1,531

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-14 00:00:00	ES	Futures	1597.02	1597.28	1596.77	1597.02	2379.0
2013-03-14 01:00:00	ES	Futures	1596.77	1597.54	1596.25	1597.28	3189.0
2013-03-14 02:00:00	ES	Futures	1597.28	1598.05	1597.28	1598.05	2238.0
2013-03-14 03:00:00	ES	Futures	1598.05	1600.11	1597.28	1599.6	15822.0
2013-03-14 04:00:00	ES	Futures	1599.34	1600.89	1598.83	1600.11	27172.0
2013-03-14 05:00:00	ES	Futures	1600.37	1600.63	1599.08	1599.86	15668.0
2013-03-14 06:00:00	ES	Futures	1599.6	1599.86	1598.57	1599.08	16184.0
2013-03-14 07:00:00	ES	Futures	1599.08	1600.89	1599.08	1600.63	27173.0
2013-03-14 08:00:00	ES	Futures	1600.63	1601.92	1600.37	1601.14	54613.0
2013-03-14 09:00:00	ES	Futures	1601.14	1602.95	1599.34	1602.43	222095.0
2013-03-14 10:00:00	ES	Futures	1602.43	1602.95	1598.83	1601.14	208117.0
2013-03-14 11:00:00	ES	Futures	1600.89	1602.17	1599.6	1601.4	113658.0
2013-03-14 12:00:00	ES	Futures	1601.66	1603.98	1601.4	1602.17	126636.0
2013-03-14 13:00:00	ES	Futures	1602.17	1603.2	1600.37	1600.63	95558.0
2013-03-14 14:00:00	ES	Futures	1600.63	1602.43	1600.37	1602.43	61623.0
2013-03-14 15:00:00	ES	Futures	1602.43	1604.49	1601.92	1603.72	183745.0
2013-03-14 16:00:00	ES	Futures	1603.72	1604.24	1601.92	1602.95	90299.0
2013-03-14 17:00:00	ES	Futures	1602.95	1602.95	1601.66	1602.43	3214.0
2013-03-14 18:00:00	ES	Futures	1601.66	1602.95	1601.66	1602.95	5469.0
2013-03-14 19:00:00	ES	Futures	1602.95	1603.46	1602.69	1603.2	2896.0
2013-03-14 20:00:00	ES	Futures	1603.2	1603.98	1602.69	1603.72	2903.0
2013-03-14 21:00:00	ES	Futures	1603.72	1603.98	1602.17	1602.43	4571.0
2013-03-14 22:00:00	ES	Futures	1602.43	1603.72	1602.43	1603.72	2866.0
2013-03-14 23:00:00	ES	Futures	1603.46	1604.49	1603.2	1604.24	4043.0
2013-03-14 00:00:00	NQ	Futures	3260.26	3260.56	3259.39	3259.68	108.0
2013-03-14 01:00:00	NQ	Futures	3259.68	3260.85	3259.1	3260.56	148.0
2013-03-14 02:00:00	NQ	Futures	3260.26	3261.72	3260.26	3261.43	103.0
2013-03-14 03:00:00	NQ	Futures	3261.14	3266.39	3260.56	3265.81	1157.0
2013-03-14 04:00:00	NQ	Futures	3265.51	3269.01	3264.35	3266.68	2898.0
2013-03-14 05:00:00	NQ	Futures	3266.68	3268.14	3264.64	3265.51	1185.0
2013-03-14 06:00:00	NQ	Futures	3265.51	3265.81	3264.06	3264.93	890.0
2013-03-14 07:00:00	NQ	Futures	3264.93	3270.47	3264.64	3269.89	2574.0
2013-03-14 08:00:00	NQ	Futures	3269.6	3273.39	3269.31	3271.64	4796.0
2013-03-14 09:00:00	NQ	Futures	3271.64	3275.43	3267.85	3271.35	26125.0
2013-03-14 10:00:00	NQ	Futures	3271.06	3273.97	3261.43	3266.68	28500.0
2013-03-14 11:00:00	NQ	Futures	3266.39	3268.43	3263.18	3266.97	12307.0
2013-03-14 12:00:00	NQ	Futures	3266.97	3272.22	3266.68	3268.72	14927.0
2013-03-14 13:00:00	NQ	Futures	3269.01	3270.47	3262.89	3263.76	12363.0
2013-03-14 14:00:00	NQ	Futures	3263.76	3266.68	3263.18	3266.39	9637.0
2013-03-14 15:00:00	NQ	Futures	3266.39	3268.43	3264.64	3267.85	15244.0
2013-03-14 16:00:00	NQ	Futures	3267.56	3269.01	3265.81	3266.39	5459.0
2013-03-14 17:00:00	NQ	Futures	3266.39	3266.39	3264.93	3266.39	111.0
2013-03-14 18:00:00	NQ	Futures	3265.81	3266.39	3264.35	3266.39	281.0
2013-03-14 19:00:00	NQ	Futures	3266.39	3267.85	3265.81	3267.56	179.0
2013-03-14 20:00:00	NQ	Futures	3267.56	3268.14	3266.68	3267.85	183.0
2013-03-14 21:00:00	NQ	Futures	3267.85	3268.72	3266.39	3266.97	371.0
2013-03-14 22:00:00	NQ	Futures	3266.97	3269.31	3266.97	3269.01	445.0
2013-03-14 23:00:00	NQ	Futures	3269.31	3270.47	3268.72	3270.18	172.0
2013-03-14 00:00:00	YM	Futures	14552.6	14555.6	14550.5	14551.5	184.0
2013-03-14 01:00:00	YM	Futures	14552.6	14556.6	14549.5	14554.6	336.0

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

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