PREVIEW / futures_1hour / 2017-02-14

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-14.parquet
  size:    53 KB
  rows:    1,642

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-14 00:00:00	ES	Futures	2536.75	2536.75	2535.11	2535.93	4456.0
2017-02-14 01:00:00	ES	Futures	2535.66	2536.75	2534.84	2535.66	3482.0
2017-02-14 02:00:00	ES	Futures	2535.93	2536.48	2535.39	2535.66	3768.0
2017-02-14 03:00:00	ES	Futures	2535.93	2537.57	2534.84	2537.02	13649.0
2017-02-14 04:00:00	ES	Futures	2537.02	2537.02	2535.39	2535.93	7993.0
2017-02-14 05:00:00	ES	Futures	2535.66	2537.57	2535.39	2537.3	7198.0
2017-02-14 06:00:00	ES	Futures	2537.57	2538.11	2535.93	2537.84	8583.0
2017-02-14 07:00:00	ES	Futures	2537.57	2538.39	2537.02	2537.84	8593.0
2017-02-14 08:00:00	ES	Futures	2537.84	2539.48	2536.48	2537.02	25184.0
2017-02-14 09:00:00	ES	Futures	2537.02	2538.11	2533.75	2534.57	177775.0
2017-02-14 10:00:00	ES	Futures	2534.3	2536.75	2531.02	2534.57	217669.0
2017-02-14 11:00:00	ES	Futures	2534.57	2538.39	2531.02	2537.84	164995.0
2017-02-14 12:00:00	ES	Futures	2537.84	2543.02	2537.02	2542.21	136699.0
2017-02-14 13:00:00	ES	Futures	2542.48	2546.3	2541.66	2545.48	136321.0
2017-02-14 14:00:00	ES	Futures	2545.48	2547.93	2543.57	2544.39	111220.0
2017-02-14 15:00:00	ES	Futures	2544.39	2548.48	2544.12	2548.21	225965.0
2017-02-14 16:00:00	ES	Futures	2547.93	2550.66	2547.39	2548.48	99823.0
2017-02-14 18:00:00	ES	Futures	2548.21	2548.75	2547.12	2547.66	4779.0
2017-02-14 19:00:00	ES	Futures	2547.66	2548.48	2547.12	2547.93	3941.0
2017-02-14 20:00:00	ES	Futures	2547.66	2549.3	2546.84	2549.03	3939.0
2017-02-14 21:00:00	ES	Futures	2549.03	2549.3	2548.21	2548.75	2421.0
2017-02-14 22:00:00	ES	Futures	2548.48	2549.3	2548.48	2548.75	1973.0
2017-02-14 23:00:00	ES	Futures	2548.48	2548.75	2547.66	2548.48	2189.0
2017-02-14 00:00:00	NQ	Futures	6272.17	6272.47	6267.4	6268.89	1251.0
2017-02-14 01:00:00	NQ	Futures	6269.49	6270.98	6267.7	6269.19	830.0
2017-02-14 02:00:00	NQ	Futures	6269.49	6272.47	6268.59	6270.98	1022.0
2017-02-14 03:00:00	NQ	Futures	6270.98	6274.26	6268.0	6272.77	2029.0
2017-02-14 04:00:00	NQ	Futures	6272.47	6272.47	6269.19	6270.68	1371.0
2017-02-14 05:00:00	NQ	Futures	6270.38	6276.05	6270.09	6275.75	1643.0
2017-02-14 06:00:00	NQ	Futures	6275.75	6276.95	6272.77	6276.05	1277.0
2017-02-14 07:00:00	NQ	Futures	6275.75	6276.05	6273.37	6274.26	1200.0
2017-02-14 08:00:00	NQ	Futures	6274.26	6276.65	6270.38	6272.77	3604.0
2017-02-14 09:00:00	NQ	Futures	6272.47	6272.77	6263.82	6269.49	23559.0
2017-02-14 10:00:00	NQ	Futures	6268.89	6272.17	6252.49	6261.14	35841.0
2017-02-14 11:00:00	NQ	Futures	6260.84	6274.56	6254.28	6272.77	19740.0
2017-02-14 12:00:00	NQ	Futures	6273.07	6283.21	6271.58	6282.02	15557.0
2017-02-14 13:00:00	NQ	Futures	6282.02	6288.88	6280.53	6287.39	14860.0
2017-02-14 14:00:00	NQ	Futures	6287.09	6291.27	6280.83	6282.91	14243.0
2017-02-14 15:00:00	NQ	Futures	6282.91	6291.86	6281.12	6291.57	18718.0
2017-02-14 16:00:00	NQ	Futures	6291.27	6298.13	6289.18	6294.85	4965.0
2017-02-14 18:00:00	NQ	Futures	6293.95	6295.44	6290.97	6291.86	985.0
2017-02-14 19:00:00	NQ	Futures	6291.86	6293.36	6290.07	6291.86	1023.0
2017-02-14 20:00:00	NQ	Futures	6291.86	6297.53	6290.37	6296.64	1203.0
2017-02-14 21:00:00	NQ	Futures	6296.93	6298.72	6296.04	6297.23	731.0
2017-02-14 22:00:00	NQ	Futures	6297.23	6299.02	6296.34	6296.34	802.0
2017-02-14 23:00:00	NQ	Futures	6296.34	6296.34	6294.55	6296.04	585.0
2017-02-14 00:00:00	YM	Futures	22097.8	22098.9	22082.6	22089.1	1291.0
2017-02-14 01:00:00	YM	Futures	22089.1	22095.6	22084.7	22090.2	1145.0
2017-02-14 02:00:00	YM	Futures	22091.3	22101.0	22088.0	22095.6	1345.0
2017-02-14 03:00:00	YM	Futures	22096.7	22110.8	22086.9	22106.4	2167.0

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

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