PREVIEW / futures_1hour / 2017-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-23.parquet
  size:    52 KB
  rows:    1,605

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
2017-02-23 00:00:00	ES	Futures	2574.39	2575.21	2574.12	2575.21	1652.0
2017-02-23 01:00:00	ES	Futures	2575.21	2575.21	2574.39	2575.21	1281.0
2017-02-23 02:00:00	ES	Futures	2574.94	2575.21	2574.12	2574.67	3679.0
2017-02-23 03:00:00	ES	Futures	2574.94	2576.58	2574.12	2574.67	17483.0
2017-02-23 04:00:00	ES	Futures	2574.67	2579.03	2574.67	2578.76	14168.0
2017-02-23 05:00:00	ES	Futures	2578.48	2578.76	2576.85	2576.85	9590.0
2017-02-23 06:00:00	ES	Futures	2577.12	2577.67	2576.03	2577.67	7420.0
2017-02-23 07:00:00	ES	Futures	2577.39	2579.85	2576.3	2578.76	34928.0
2017-02-23 08:00:00	ES	Futures	2578.76	2580.39	2578.21	2580.12	36876.0
2017-02-23 09:00:00	ES	Futures	2580.12	2583.12	2577.94	2579.85	184423.0
2017-02-23 10:00:00	ES	Futures	2579.85	2580.12	2569.48	2571.12	299598.0
2017-02-23 11:00:00	ES	Futures	2571.39	2574.67	2567.3	2572.48	241513.0
2017-02-23 12:00:00	ES	Futures	2572.76	2578.76	2572.21	2576.3	154535.0
2017-02-23 13:00:00	ES	Futures	2576.3	2577.39	2574.39	2576.85	120597.0
2017-02-23 14:00:00	ES	Futures	2577.12	2579.85	2576.3	2579.3	99921.0
2017-02-23 15:00:00	ES	Futures	2579.03	2580.39	2574.94	2577.12	226491.0
2017-02-23 16:00:00	ES	Futures	2577.39	2579.3	2576.03	2577.94	75112.0
2017-02-23 18:00:00	ES	Futures	2576.58	2576.85	2574.94	2575.21	6043.0
2017-02-23 19:00:00	ES	Futures	2574.94	2576.85	2574.39	2576.03	5042.0
2017-02-23 20:00:00	ES	Futures	2576.3	2576.3	2574.67	2574.94	3623.0
2017-02-23 21:00:00	ES	Futures	2574.94	2575.48	2574.67	2574.94	3306.0
2017-02-23 22:00:00	ES	Futures	2575.21	2575.48	2574.39	2575.48	3004.0
2017-02-23 23:00:00	ES	Futures	2575.21	2575.76	2574.67	2575.48	1453.0
2017-02-23 00:00:00	NQ	Futures	6381.96	6385.54	6381.96	6384.94	639.0
2017-02-23 01:00:00	NQ	Futures	6384.94	6385.54	6383.75	6385.24	324.0
2017-02-23 02:00:00	NQ	Futures	6385.54	6386.13	6383.75	6384.64	764.0
2017-02-23 03:00:00	NQ	Futures	6384.94	6387.92	6383.15	6383.45	2690.0
2017-02-23 04:00:00	NQ	Futures	6383.45	6390.91	6383.45	6390.31	2218.0
2017-02-23 05:00:00	NQ	Futures	6390.01	6390.31	6385.24	6387.03	2147.0
2017-02-23 06:00:00	NQ	Futures	6387.03	6389.12	6384.94	6388.52	1215.0
2017-02-23 07:00:00	NQ	Futures	6388.52	6392.4	6386.13	6390.31	3676.0
2017-02-23 08:00:00	NQ	Futures	6390.01	6392.7	6388.82	6391.5	3334.0
2017-02-23 09:00:00	NQ	Futures	6391.5	6397.47	6371.51	6379.87	35277.0
2017-02-23 10:00:00	NQ	Futures	6379.87	6380.17	6347.65	6351.83	52563.0
2017-02-23 11:00:00	NQ	Futures	6351.83	6357.49	6337.21	6353.02	43618.0
2017-02-23 12:00:00	NQ	Futures	6353.02	6363.46	6350.93	6359.28	21874.0
2017-02-23 13:00:00	NQ	Futures	6358.99	6362.86	6354.51	6360.48	14552.0
2017-02-23 14:00:00	NQ	Futures	6360.48	6367.64	6357.79	6365.55	14438.0
2017-02-23 15:00:00	NQ	Futures	6365.55	6369.13	6355.11	6363.16	29628.0
2017-02-23 16:00:00	NQ	Futures	6363.16	6365.25	6358.69	6361.97	4760.0
2017-02-23 18:00:00	NQ	Futures	6359.28	6360.48	6353.62	6353.62	1041.0
2017-02-23 19:00:00	NQ	Futures	6353.91	6358.69	6351.83	6355.7	1431.0
2017-02-23 20:00:00	NQ	Futures	6356.0	6357.2	6351.23	6352.42	1170.0
2017-02-23 21:00:00	NQ	Futures	6352.42	6353.62	6350.93	6351.53	954.0
2017-02-23 22:00:00	NQ	Futures	6351.53	6352.12	6350.33	6351.83	734.0
2017-02-23 23:00:00	NQ	Futures	6351.83	6352.12	6349.74	6350.93	504.0
2017-02-23 00:00:00	YM	Futures	22500.2	22511.1	22499.1	22510.0	471.0
2017-02-23 01:00:00	YM	Futures	22508.9	22511.1	22505.6	22510.0	364.0
2017-02-23 02:00:00	YM	Futures	22510.0	22511.1	22500.2	22507.8	885.0
2017-02-23 03:00:00	YM	Futures	22507.8	22518.7	22502.4	22503.5	2654.0

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

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