PREVIEW / futures_1hour / 2013-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-09.parquet
  size:    49 KB
  rows:    1,536

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-09 00:00:00	ES	Futures	1491.56	1492.33	1490.54	1491.56	3637.0
2013-01-09 01:00:00	ES	Futures	1491.56	1492.33	1491.05	1491.56	2919.0
2013-01-09 02:00:00	ES	Futures	1491.82	1493.1	1491.31	1492.33	4560.0
2013-01-09 03:00:00	ES	Futures	1492.08	1494.13	1491.82	1492.85	15303.0
2013-01-09 04:00:00	ES	Futures	1492.59	1493.1	1490.28	1490.54	14945.0
2013-01-09 05:00:00	ES	Futures	1490.28	1491.82	1490.28	1490.79	19350.0
2013-01-09 06:00:00	ES	Futures	1490.79	1491.31	1490.02	1490.79	19523.0
2013-01-09 07:00:00	ES	Futures	1490.79	1493.36	1490.28	1493.1	24007.0
2013-01-09 08:00:00	ES	Futures	1493.1	1493.62	1491.82	1493.36	29958.0
2013-01-09 09:00:00	ES	Futures	1493.36	1496.95	1492.59	1496.44	169561.0
2013-01-09 10:00:00	ES	Futures	1496.44	1497.98	1494.64	1495.67	178959.0
2013-01-09 11:00:00	ES	Futures	1495.93	1497.21	1494.64	1495.67	128122.0
2013-01-09 12:00:00	ES	Futures	1495.41	1496.44	1491.82	1493.62	133866.0
2013-01-09 13:00:00	ES	Futures	1493.62	1494.64	1492.33	1493.62	78101.0
2013-01-09 14:00:00	ES	Futures	1493.62	1494.9	1491.56	1492.08	77864.0
2013-01-09 15:00:00	ES	Futures	1491.82	1494.39	1490.79	1494.13	172638.0
2013-01-09 16:00:00	ES	Futures	1494.13	1494.9	1492.85	1494.39	66831.0
2013-01-09 17:00:00	ES	Futures	1494.64	1495.16	1494.13	1495.16	1810.0
2013-01-09 18:00:00	ES	Futures	1494.9	1494.9	1493.36	1493.62	3566.0
2013-01-09 19:00:00	ES	Futures	1493.62	1494.13	1493.36	1493.87	2649.0
2013-01-09 20:00:00	ES	Futures	1493.87	1494.13	1493.1	1493.1	2770.0
2013-01-09 21:00:00	ES	Futures	1493.36	1498.24	1493.36	1496.7	14191.0
2013-01-09 22:00:00	ES	Futures	1496.95	1498.49	1496.7	1498.24	5463.0
2013-01-09 23:00:00	ES	Futures	1498.24	1498.75	1496.44	1497.72	5776.0
2013-01-09 00:00:00	NQ	Futures	3161.3	3163.63	3159.55	3162.17	500.0
2013-01-09 01:00:00	NQ	Futures	3162.17	3163.92	3161.3	3162.76	251.0
2013-01-09 02:00:00	NQ	Futures	3163.34	3165.96	3162.47	3165.09	549.0
2013-01-09 03:00:00	NQ	Futures	3164.79	3167.7	3163.92	3164.21	1717.0
2013-01-09 04:00:00	NQ	Futures	3164.5	3165.09	3157.81	3158.1	2051.0
2013-01-09 05:00:00	NQ	Futures	3158.1	3161.3	3157.81	3158.68	1675.0
2013-01-09 06:00:00	NQ	Futures	3158.39	3160.14	3156.64	3158.68	2090.0
2013-01-09 07:00:00	NQ	Futures	3158.68	3164.5	3157.81	3164.5	2468.0
2013-01-09 08:00:00	NQ	Futures	3164.21	3165.38	3160.43	3164.79	4383.0
2013-01-09 09:00:00	NQ	Futures	3164.79	3171.49	3160.14	3168.87	26617.0
2013-01-09 10:00:00	NQ	Futures	3169.16	3178.77	3165.67	3175.27	29876.0
2013-01-09 11:00:00	NQ	Futures	3175.27	3177.6	3170.91	3172.07	16071.0
2013-01-09 12:00:00	NQ	Futures	3172.07	3174.69	3164.79	3168.58	15915.0
2013-01-09 13:00:00	NQ	Futures	3168.29	3173.82	3165.67	3172.07	11272.0
2013-01-09 14:00:00	NQ	Futures	3172.07	3175.27	3166.83	3168.29	11253.0
2013-01-09 15:00:00	NQ	Futures	3168.0	3170.62	3162.76	3169.74	24170.0
2013-01-09 16:00:00	NQ	Futures	3169.74	3171.2	3167.7	3170.32	4826.0
2013-01-09 17:00:00	NQ	Futures	3170.32	3171.2	3170.32	3170.91	139.0
2013-01-09 18:00:00	NQ	Futures	3169.74	3170.62	3168.0	3168.29	371.0
2013-01-09 19:00:00	NQ	Futures	3168.87	3170.03	3168.58	3169.45	228.0
2013-01-09 20:00:00	NQ	Futures	3169.16	3169.74	3167.7	3168.87	215.0
2013-01-09 21:00:00	NQ	Futures	3168.58	3178.18	3168.58	3175.56	1300.0
2013-01-09 22:00:00	NQ	Futures	3175.85	3178.18	3175.27	3177.89	429.0
2013-01-09 23:00:00	NQ	Futures	3177.89	3180.22	3175.27	3177.89	631.0
2013-01-09 00:00:00	YM	Futures	13360.0	13366.0	13354.0	13364.0	532.0
2013-01-09 01:00:00	YM	Futures	13363.0	13366.0	13358.0	13365.0	168.0

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

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