PREVIEW / futures_1hour / 2013-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-02.parquet
  size:    43 KB
  rows:    1,258

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-02 06:00:00	ES	Futures	1481.04	1486.43	1476.17	1480.02	127055.0
2013-01-02 07:00:00	ES	Futures	1480.02	1485.15	1479.25	1482.84	51049.0
2013-01-02 08:00:00	ES	Futures	1482.84	1486.43	1482.07	1484.64	72669.0
2013-01-02 09:00:00	ES	Futures	1484.64	1491.05	1482.58	1489.77	367948.0
2013-01-02 10:00:00	ES	Futures	1490.02	1491.05	1484.64	1485.66	325158.0
2013-01-02 11:00:00	ES	Futures	1485.66	1486.69	1482.07	1482.58	180479.0
2013-01-02 12:00:00	ES	Futures	1482.84	1485.41	1482.07	1483.1	114588.0
2013-01-02 13:00:00	ES	Futures	1482.84	1484.89	1482.84	1483.61	85446.0
2013-01-02 14:00:00	ES	Futures	1483.87	1486.18	1483.1	1485.66	116042.0
2013-01-02 15:00:00	ES	Futures	1485.66	1496.44	1485.41	1495.93	330638.0
2013-01-02 16:00:00	ES	Futures	1495.93	1496.44	1494.39	1495.67	163991.0
2013-01-02 17:00:00	ES	Futures	1495.67	1496.18	1494.39	1494.9	2478.0
2013-01-02 18:00:00	ES	Futures	1494.39	1494.64	1492.33	1492.59	7621.0
2013-01-02 19:00:00	ES	Futures	1492.59	1493.1	1492.08	1492.33	5259.0
2013-01-02 20:00:00	ES	Futures	1492.33	1492.59	1491.31	1492.33	6014.0
2013-01-02 21:00:00	ES	Futures	1492.33	1492.59	1491.56	1491.82	3263.0
2013-01-02 22:00:00	ES	Futures	1491.56	1492.08	1491.05	1492.08	3953.0
2013-01-02 23:00:00	ES	Futures	1491.82	1492.08	1490.79	1491.31	3897.0
2013-01-02 06:00:00	NQ	Futures	3127.54	3151.7	3127.54	3138.31	11062.0
2013-01-02 07:00:00	NQ	Futures	3138.6	3155.77	3138.6	3151.4	7424.0
2013-01-02 08:00:00	NQ	Futures	3151.7	3162.17	3149.37	3159.55	12308.0
2013-01-02 09:00:00	NQ	Futures	3159.55	3186.62	3157.52	3180.51	75393.0
2013-01-02 10:00:00	NQ	Futures	3181.09	3181.97	3164.79	3167.12	40999.0
2013-01-02 11:00:00	NQ	Futures	3167.12	3168.87	3158.39	3160.14	31244.0
2013-01-02 12:00:00	NQ	Futures	3159.85	3166.54	3157.23	3163.63	17485.0
2013-01-02 13:00:00	NQ	Futures	3163.63	3169.74	3161.59	3164.21	14664.0
2013-01-02 14:00:00	NQ	Futures	3163.92	3172.36	3162.47	3170.91	20238.0
2013-01-02 15:00:00	NQ	Futures	3170.91	3193.03	3170.91	3192.15	43151.0
2013-01-02 16:00:00	NQ	Futures	3191.86	3193.32	3188.37	3191.86	11826.0
2013-01-02 17:00:00	NQ	Futures	3192.15	3192.45	3189.53	3190.12	134.0
2013-01-02 18:00:00	NQ	Futures	3188.95	3190.41	3187.21	3187.5	780.0
2013-01-02 19:00:00	NQ	Futures	3187.21	3188.08	3185.46	3186.92	520.0
2013-01-02 20:00:00	NQ	Futures	3186.33	3186.92	3184.88	3186.92	518.0
2013-01-02 21:00:00	NQ	Futures	3187.21	3188.95	3184.88	3185.17	793.0
2013-01-02 22:00:00	NQ	Futures	3184.88	3185.46	3183.71	3184.59	309.0
2013-01-02 23:00:00	NQ	Futures	3184.88	3184.88	3183.13	3183.42	217.0
2013-01-02 06:00:00	YM	Futures	13256.4	13321.8	13245.3	13267.5	9902.0
2013-01-02 07:00:00	YM	Futures	13268.5	13307.7	13268.5	13290.6	2979.0
2013-01-02 08:00:00	YM	Futures	13292.6	13334.9	13291.6	13314.7	7107.0
2013-01-02 09:00:00	YM	Futures	13314.7	13386.2	13300.7	13380.1	35073.0
2013-01-02 10:00:00	YM	Futures	13383.1	13393.2	13348.9	13361.0	29204.0
2013-01-02 11:00:00	YM	Futures	13361.0	13369.1	13332.8	13337.9	12387.0
2013-01-02 12:00:00	YM	Futures	13337.9	13356.0	13330.8	13338.9	8156.0
2013-01-02 13:00:00	YM	Futures	13339.9	13348.9	13332.8	13338.9	5698.0
2013-01-02 14:00:00	YM	Futures	13338.9	13353.0	13326.8	13343.9	10282.0
2013-01-02 15:00:00	YM	Futures	13343.9	13422.4	13343.9	13418.4	24028.0
2013-01-02 16:00:00	YM	Futures	13418.4	13424.4	13404.3	13414.3	6542.0
2013-01-02 17:00:00	YM	Futures	13414.3	13416.3	13403.3	13407.3	142.0
2013-01-02 18:00:00	YM	Futures	13404.3	13405.3	13390.2	13391.2	697.0
2013-01-02 19:00:00	YM	Futures	13390.2	13393.2	13386.2	13390.2	531.0

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

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