PREVIEW / futures_1hour / 2013-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-30.parquet
  size:    52 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-30 00:00:00	ES	Futures	1543.65	1543.91	1543.14	1543.65	2379.0
2013-01-30 01:00:00	ES	Futures	1543.65	1543.91	1542.37	1542.37	3193.0
2013-01-30 02:00:00	ES	Futures	1542.37	1545.45	1542.37	1544.93	13246.0
2013-01-30 03:00:00	ES	Futures	1544.93	1545.7	1543.91	1545.19	24931.0
2013-01-30 04:00:00	ES	Futures	1545.19	1545.7	1544.17	1545.19	14934.0
2013-01-30 05:00:00	ES	Futures	1545.19	1545.45	1543.91	1545.45	19618.0
2013-01-30 06:00:00	ES	Futures	1545.19	1545.7	1543.91	1545.19	15091.0
2013-01-30 07:00:00	ES	Futures	1545.19	1545.19	1542.88	1543.14	31401.0
2013-01-30 08:00:00	ES	Futures	1542.88	1544.68	1538.01	1541.09	135933.0
2013-01-30 09:00:00	ES	Futures	1541.09	1545.19	1540.57	1542.37	207330.0
2013-01-30 10:00:00	ES	Futures	1542.37	1542.63	1538.26	1540.06	280984.0
2013-01-30 11:00:00	ES	Futures	1540.32	1542.63	1540.06	1541.6	156165.0
2013-01-30 12:00:00	ES	Futures	1541.86	1543.14	1539.29	1542.88	149848.0
2013-01-30 13:00:00	ES	Futures	1542.88	1543.14	1541.09	1541.6	62186.0
2013-01-30 14:00:00	ES	Futures	1541.6	1542.88	1537.49	1539.55	191611.0
2013-01-30 15:00:00	ES	Futures	1539.8	1540.32	1534.67	1536.72	365445.0
2013-01-30 16:00:00	ES	Futures	1536.72	1536.98	1533.64	1533.9	99990.0
2013-01-30 17:00:00	ES	Futures	1533.64	1534.16	1532.88	1533.13	3337.0
2013-01-30 18:00:00	ES	Futures	1533.64	1535.18	1533.64	1533.9	7775.0
2013-01-30 19:00:00	ES	Futures	1534.16	1535.7	1533.9	1534.93	5200.0
2013-01-30 20:00:00	ES	Futures	1534.93	1535.7	1533.39	1533.64	5602.0
2013-01-30 21:00:00	ES	Futures	1533.9	1534.16	1532.88	1532.88	3194.0
2013-01-30 22:00:00	ES	Futures	1532.88	1534.41	1532.88	1533.64	3866.0
2013-01-30 23:00:00	ES	Futures	1533.64	1533.9	1533.13	1533.39	2422.0
2013-01-30 00:00:00	NQ	Futures	3194.77	3195.65	3193.9	3195.65	306.0
2013-01-30 01:00:00	NQ	Futures	3195.36	3195.36	3191.57	3191.57	981.0
2013-01-30 02:00:00	NQ	Futures	3191.57	3197.68	3190.99	3196.23	1115.0
2013-01-30 03:00:00	NQ	Futures	3196.23	3199.43	3193.9	3197.68	2112.0
2013-01-30 04:00:00	NQ	Futures	3197.98	3200.01	3195.36	3195.94	2271.0
2013-01-30 05:00:00	NQ	Futures	3195.94	3197.39	3195.07	3196.81	1685.0
2013-01-30 06:00:00	NQ	Futures	3197.1	3197.68	3194.77	3196.52	1512.0
2013-01-30 07:00:00	NQ	Futures	3196.52	3196.81	3193.61	3193.9	1875.0
2013-01-30 08:00:00	NQ	Futures	3193.61	3196.23	3184.3	3187.5	8081.0
2013-01-30 09:00:00	NQ	Futures	3187.5	3203.8	3187.21	3198.85	34206.0
2013-01-30 10:00:00	NQ	Futures	3198.56	3199.43	3180.8	3191.28	42429.0
2013-01-30 11:00:00	NQ	Futures	3191.28	3201.47	3191.28	3197.1	21711.0
2013-01-30 12:00:00	NQ	Futures	3197.1	3198.27	3188.08	3194.48	24831.0
2013-01-30 13:00:00	NQ	Futures	3194.19	3195.36	3188.95	3191.86	13188.0
2013-01-30 14:00:00	NQ	Futures	3191.57	3196.81	3183.71	3188.37	34995.0
2013-01-30 15:00:00	NQ	Futures	3188.37	3190.12	3174.11	3182.26	49010.0
2013-01-30 16:00:00	NQ	Futures	3182.55	3188.08	3180.8	3184.59	9109.0
2013-01-30 17:00:00	NQ	Futures	3184.3	3185.46	3183.42	3184.0	198.0
2013-01-30 18:00:00	NQ	Futures	3183.13	3185.75	3183.13	3183.71	476.0
2013-01-30 19:00:00	NQ	Futures	3184.0	3185.75	3184.0	3184.59	456.0
2013-01-30 20:00:00	NQ	Futures	3184.88	3185.46	3181.97	3183.42	452.0
2013-01-30 21:00:00	NQ	Futures	3182.84	3184.0	3180.51	3180.8	359.0
2013-01-30 22:00:00	NQ	Futures	3181.09	3182.84	3180.22	3180.8	485.0
2013-01-30 23:00:00	NQ	Futures	3180.8	3181.09	3179.93	3180.51	170.0
2013-01-30 00:00:00	YM	Futures	13983.7	13986.8	13979.7	13984.8	160.0
2013-01-30 01:00:00	YM	Futures	13983.7	13987.8	13978.7	13979.7	222.0

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

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