PREVIEW / futures_1hour / 2013-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-29.parquet
  size:    50 KB
  rows:    1,572

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-29 00:00:00	ES	Futures	1536.98	1538.26	1536.72	1537.49	4868.0
2013-01-29 01:00:00	ES	Futures	1537.49	1538.26	1537.24	1537.24	2855.0
2013-01-29 02:00:00	ES	Futures	1537.24	1537.49	1535.95	1535.95	6390.0
2013-01-29 03:00:00	ES	Futures	1536.21	1536.98	1535.44	1535.7	19133.0
2013-01-29 04:00:00	ES	Futures	1535.7	1535.95	1533.9	1534.93	14972.0
2013-01-29 05:00:00	ES	Futures	1534.67	1535.44	1531.59	1531.85	25144.0
2013-01-29 06:00:00	ES	Futures	1531.85	1532.36	1530.31	1531.08	25162.0
2013-01-29 07:00:00	ES	Futures	1531.08	1532.11	1530.57	1531.34	23635.0
2013-01-29 08:00:00	ES	Futures	1531.34	1533.64	1531.08	1532.62	39630.0
2013-01-29 09:00:00	ES	Futures	1532.62	1537.49	1532.11	1536.47	184027.0
2013-01-29 10:00:00	ES	Futures	1536.21	1537.49	1532.36	1536.47	232041.0
2013-01-29 11:00:00	ES	Futures	1536.47	1540.57	1535.7	1539.8	228298.0
2013-01-29 12:00:00	ES	Futures	1539.8	1541.6	1538.78	1540.57	103999.0
2013-01-29 13:00:00	ES	Futures	1540.83	1542.63	1540.57	1541.86	114568.0
2013-01-29 14:00:00	ES	Futures	1542.11	1543.14	1541.09	1541.86	77927.0
2013-01-29 15:00:00	ES	Futures	1541.6	1544.42	1540.83	1542.63	256113.0
2013-01-29 16:00:00	ES	Futures	1542.37	1545.19	1542.11	1544.68	100985.0
2013-01-29 17:00:00	ES	Futures	1544.68	1545.45	1544.42	1545.19	4150.0
2013-01-29 18:00:00	ES	Futures	1544.68	1544.93	1543.4	1543.65	4162.0
2013-01-29 19:00:00	ES	Futures	1543.91	1544.68	1543.65	1544.42	3204.0
2013-01-29 20:00:00	ES	Futures	1544.42	1544.68	1543.91	1544.68	3205.0
2013-01-29 21:00:00	ES	Futures	1544.68	1544.93	1543.65	1543.91	3296.0
2013-01-29 22:00:00	ES	Futures	1544.17	1544.68	1542.88	1543.4	3976.0
2013-01-29 23:00:00	ES	Futures	1543.4	1543.91	1543.14	1543.65	1741.0
2013-01-29 00:00:00	NQ	Futures	3187.79	3189.53	3186.62	3188.66	420.0
2013-01-29 01:00:00	NQ	Futures	3188.66	3190.41	3187.21	3188.37	342.0
2013-01-29 02:00:00	NQ	Futures	3188.66	3188.95	3185.17	3185.46	830.0
2013-01-29 03:00:00	NQ	Futures	3185.46	3186.92	3183.42	3184.59	1923.0
2013-01-29 04:00:00	NQ	Futures	3184.59	3185.17	3180.51	3182.55	1969.0
2013-01-29 05:00:00	NQ	Futures	3182.55	3184.3	3175.85	3176.73	2849.0
2013-01-29 06:00:00	NQ	Futures	3176.73	3177.89	3174.98	3177.02	2409.0
2013-01-29 07:00:00	NQ	Futures	3176.73	3178.47	3174.98	3177.02	2340.0
2013-01-29 08:00:00	NQ	Futures	3177.31	3183.13	3176.73	3180.51	4468.0
2013-01-29 09:00:00	NQ	Futures	3180.51	3184.0	3173.24	3179.35	30821.0
2013-01-29 10:00:00	NQ	Futures	3179.06	3180.22	3162.47	3177.02	46463.0
2013-01-29 11:00:00	NQ	Futures	3177.31	3190.7	3174.11	3189.24	34779.0
2013-01-29 12:00:00	NQ	Futures	3188.95	3189.53	3181.39	3187.21	17065.0
2013-01-29 13:00:00	NQ	Futures	3187.5	3189.83	3183.42	3188.08	15599.0
2013-01-29 14:00:00	NQ	Futures	3188.37	3190.12	3183.71	3185.75	12390.0
2013-01-29 15:00:00	NQ	Futures	3185.75	3195.36	3184.59	3188.66	27589.0
2013-01-29 16:00:00	NQ	Futures	3188.37	3198.27	3182.55	3196.23	16150.0
2013-01-29 17:00:00	NQ	Futures	3196.23	3198.27	3195.07	3197.1	711.0
2013-01-29 18:00:00	NQ	Futures	3196.52	3196.81	3193.9	3195.65	718.0
2013-01-29 19:00:00	NQ	Futures	3195.36	3196.52	3194.77	3196.23	623.0
2013-01-29 20:00:00	NQ	Futures	3196.23	3196.52	3194.77	3195.94	169.0
2013-01-29 21:00:00	NQ	Futures	3196.23	3196.81	3195.65	3195.94	361.0
2013-01-29 22:00:00	NQ	Futures	3195.65	3197.39	3194.19	3194.77	377.0
2013-01-29 23:00:00	NQ	Futures	3195.07	3195.65	3194.77	3195.36	195.0
2013-01-29 00:00:00	YM	Futures	13921.4	13929.4	13920.4	13928.4	303.0
2013-01-29 01:00:00	YM	Futures	13928.4	13931.4	13923.4	13924.4	216.0

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

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