PREVIEW / futures_1hour / 2013-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-14.parquet
  size:    48 KB
  rows:    1,503

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-14 00:00:00	ES	Futures	1508.76	1509.01	1507.22	1507.47	3716.0
2013-01-14 01:00:00	ES	Futures	1507.47	1507.99	1506.45	1507.47	2953.0
2013-01-14 02:00:00	ES	Futures	1507.47	1509.27	1507.22	1507.47	8770.0
2013-01-14 03:00:00	ES	Futures	1507.73	1508.76	1506.45	1508.24	16703.0
2013-01-14 04:00:00	ES	Futures	1508.24	1509.53	1507.47	1508.76	13413.0
2013-01-14 05:00:00	ES	Futures	1509.01	1509.53	1506.7	1506.96	11827.0
2013-01-14 06:00:00	ES	Futures	1506.96	1507.73	1506.19	1506.96	31516.0
2013-01-14 07:00:00	ES	Futures	1506.7	1507.22	1503.62	1503.88	31619.0
2013-01-14 08:00:00	ES	Futures	1503.88	1505.42	1502.85	1504.65	33001.0
2013-01-14 09:00:00	ES	Futures	1504.91	1505.68	1500.29	1501.31	219725.0
2013-01-14 10:00:00	ES	Futures	1501.57	1502.6	1498.75	1502.08	200389.0
2013-01-14 11:00:00	ES	Futures	1502.34	1503.37	1500.8	1502.85	123435.0
2013-01-14 12:00:00	ES	Futures	1502.85	1503.37	1500.8	1501.57	83883.0
2013-01-14 13:00:00	ES	Futures	1501.57	1503.37	1500.54	1501.83	64035.0
2013-01-14 14:00:00	ES	Futures	1501.83	1505.16	1501.31	1503.88	95045.0
2013-01-14 15:00:00	ES	Futures	1504.14	1505.68	1501.57	1504.65	134011.0
2013-01-14 16:00:00	ES	Futures	1504.65	1505.42	1502.08	1503.37	66891.0
2013-01-14 17:00:00	ES	Futures	1503.37	1503.62	1503.37	1503.62	884.0
2013-01-14 18:00:00	ES	Futures	1503.62	1504.14	1502.85	1503.11	3060.0
2013-01-14 19:00:00	ES	Futures	1503.11	1504.14	1502.34	1502.6	4129.0
2013-01-14 20:00:00	ES	Futures	1502.85	1503.88	1501.57	1502.85	6758.0
2013-01-14 21:00:00	ES	Futures	1503.11	1503.37	1502.08	1502.34	3776.0
2013-01-14 22:00:00	ES	Futures	1502.34	1502.34	1499.52	1499.77	8747.0
2013-01-14 23:00:00	ES	Futures	1499.52	1500.54	1499.52	1500.54	3281.0
2013-01-14 00:00:00	NQ	Futures	3196.81	3197.39	3194.48	3194.77	355.0
2013-01-14 01:00:00	NQ	Futures	3194.77	3195.94	3193.03	3194.48	339.0
2013-01-14 02:00:00	NQ	Futures	3194.48	3199.43	3194.48	3195.65	772.0
2013-01-14 03:00:00	NQ	Futures	3195.36	3197.1	3192.45	3195.94	2405.0
2013-01-14 04:00:00	NQ	Futures	3195.94	3196.23	3188.08	3188.66	3374.0
2013-01-14 05:00:00	NQ	Futures	3188.95	3190.7	3181.68	3182.84	2157.0
2013-01-14 06:00:00	NQ	Futures	3182.55	3185.46	3179.64	3183.71	4901.0
2013-01-14 07:00:00	NQ	Futures	3183.42	3184.0	3174.69	3175.27	5004.0
2013-01-14 08:00:00	NQ	Futures	3174.98	3181.09	3173.82	3178.47	7856.0
2013-01-14 09:00:00	NQ	Futures	3178.47	3188.37	3171.2	3173.24	44488.0
2013-01-14 10:00:00	NQ	Futures	3173.24	3175.27	3165.96	3173.24	37736.0
2013-01-14 11:00:00	NQ	Futures	3173.24	3176.44	3169.45	3174.11	19060.0
2013-01-14 12:00:00	NQ	Futures	3173.82	3174.98	3168.58	3171.49	12154.0
2013-01-14 13:00:00	NQ	Futures	3171.2	3174.69	3168.29	3170.62	12352.0
2013-01-14 14:00:00	NQ	Futures	3170.32	3184.88	3168.58	3180.22	23807.0
2013-01-14 15:00:00	NQ	Futures	3180.22	3184.59	3170.91	3179.06	21010.0
2013-01-14 16:00:00	NQ	Futures	3178.77	3182.55	3176.44	3179.64	6072.0
2013-01-14 17:00:00	NQ	Futures	3179.93	3180.22	3179.64	3179.93	70.0
2013-01-14 18:00:00	NQ	Futures	3179.64	3181.09	3177.6	3179.64	295.0
2013-01-14 19:00:00	NQ	Futures	3179.64	3181.09	3177.6	3178.47	431.0
2013-01-14 20:00:00	NQ	Futures	3178.47	3180.51	3176.15	3178.47	577.0
2013-01-14 21:00:00	NQ	Futures	3178.77	3179.64	3177.02	3177.89	400.0
2013-01-14 22:00:00	NQ	Futures	3177.6	3177.6	3171.49	3171.78	693.0
2013-01-14 23:00:00	NQ	Futures	3172.07	3174.11	3171.49	3173.53	395.0
2013-01-14 00:00:00	YM	Futures	13528.0	13531.0	13518.0	13519.0	273.0
2013-01-14 01:00:00	YM	Futures	13519.0	13522.0	13512.9	13515.9	331.0

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

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