PREVIEW / futures_1hour / 2013-01-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	1493.36	1493.62	1492.33	1492.59	4265.0
2013-01-08 01:00:00	ES	Futures	1492.33	1492.85	1490.02	1490.28	8454.0
2013-01-08 02:00:00	ES	Futures	1490.28	1491.05	1489.0	1489.77	9379.0
2013-01-08 03:00:00	ES	Futures	1489.77	1492.08	1489.25	1490.54	22836.0
2013-01-08 04:00:00	ES	Futures	1490.54	1491.82	1490.28	1491.31	15311.0
2013-01-08 05:00:00	ES	Futures	1491.56	1493.62	1490.79	1493.36	14548.0
2013-01-08 06:00:00	ES	Futures	1493.36	1494.9	1492.59	1494.39	15041.0
2013-01-08 07:00:00	ES	Futures	1494.13	1494.64	1491.82	1492.85	22411.0
2013-01-08 08:00:00	ES	Futures	1492.59	1493.36	1490.54	1491.31	31742.0
2013-01-08 09:00:00	ES	Futures	1491.56	1494.13	1489.77	1489.77	182300.0
2013-01-08 10:00:00	ES	Futures	1490.02	1490.79	1485.41	1485.92	263997.0
2013-01-08 11:00:00	ES	Futures	1486.18	1487.72	1484.12	1487.2	180860.0
2013-01-08 12:00:00	ES	Futures	1487.2	1488.23	1485.41	1485.92	107072.0
2013-01-08 13:00:00	ES	Futures	1485.92	1488.74	1485.66	1488.48	79444.0
2013-01-08 14:00:00	ES	Futures	1488.48	1489.77	1486.69	1487.46	73111.0
2013-01-08 15:00:00	ES	Futures	1487.72	1491.05	1487.2	1490.02	229301.0
2013-01-08 16:00:00	ES	Futures	1490.02	1491.56	1489.25	1489.77	81081.0
2013-01-08 17:00:00	ES	Futures	1489.51	1490.02	1489.51	1489.77	804.0
2013-01-08 18:00:00	ES	Futures	1489.77	1491.05	1489.51	1491.05	3172.0
2013-01-08 19:00:00	ES	Futures	1490.79	1493.1	1490.28	1491.31	11019.0
2013-01-08 20:00:00	ES	Futures	1491.31	1493.36	1491.31	1493.1	5324.0
2013-01-08 21:00:00	ES	Futures	1493.1	1495.16	1492.33	1492.59	11270.0
2013-01-08 22:00:00	ES	Futures	1492.59	1493.1	1491.05	1492.59	6087.0
2013-01-08 23:00:00	ES	Futures	1492.59	1492.59	1490.54	1491.31	4837.0
2013-01-08 00:00:00	NQ	Futures	3160.14	3161.59	3159.85	3160.43	347.0
2013-01-08 01:00:00	NQ	Futures	3160.14	3160.72	3155.48	3156.06	551.0
2013-01-08 02:00:00	NQ	Futures	3156.06	3157.23	3153.73	3155.48	772.0
2013-01-08 03:00:00	NQ	Futures	3155.19	3158.1	3153.15	3156.06	2201.0
2013-01-08 04:00:00	NQ	Futures	3156.06	3158.97	3154.9	3158.68	3804.0
2013-01-08 05:00:00	NQ	Futures	3158.68	3163.34	3156.94	3162.47	2784.0
2013-01-08 06:00:00	NQ	Futures	3162.47	3166.83	3160.43	3165.67	2881.0
2013-01-08 07:00:00	NQ	Futures	3165.09	3165.09	3160.72	3161.88	2245.0
2013-01-08 08:00:00	NQ	Futures	3162.17	3167.41	3159.55	3162.17	6646.0
2013-01-08 09:00:00	NQ	Futures	3162.17	3172.36	3156.35	3158.1	33371.0
2013-01-08 10:00:00	NQ	Futures	3157.81	3159.85	3146.17	3148.49	41523.0
2013-01-08 11:00:00	NQ	Futures	3148.49	3149.95	3141.8	3148.79	26428.0
2013-01-08 12:00:00	NQ	Futures	3149.08	3151.99	3143.55	3145.0	13204.0
2013-01-08 13:00:00	NQ	Futures	3145.0	3157.23	3144.71	3156.06	13773.0
2013-01-08 14:00:00	NQ	Futures	3156.06	3159.55	3150.24	3152.57	14479.0
2013-01-08 15:00:00	NQ	Futures	3152.57	3162.76	3151.99	3158.97	29088.0
2013-01-08 16:00:00	NQ	Futures	3159.26	3162.17	3158.97	3158.97	4729.0
2013-01-08 17:00:00	NQ	Futures	3159.55	3161.01	3159.55	3161.01	189.0
2013-01-08 18:00:00	NQ	Futures	3161.01	3163.05	3160.43	3162.47	164.0
2013-01-08 19:00:00	NQ	Futures	3162.76	3166.83	3161.3	3164.21	949.0
2013-01-08 20:00:00	NQ	Futures	3163.92	3165.96	3163.92	3165.09	440.0
2013-01-08 21:00:00	NQ	Futures	3165.67	3168.58	3162.76	3163.34	1016.0
2013-01-08 22:00:00	NQ	Futures	3163.63	3164.5	3160.72	3163.05	367.0
2013-01-08 23:00:00	NQ	Futures	3163.05	3163.63	3158.97	3161.3	331.0
2013-01-08 00:00:00	YM	Futures	13381.1	13385.2	13379.1	13380.1	233.0
2013-01-08 01:00:00	YM	Futures	13380.1	13381.1	13362.0	13363.0	510.0

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

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