PREVIEW / futures_1hour / 2016-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-12.parquet
  size:    55 KB
  rows:    1,629

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
2016-07-12 00:00:00	ES	Futures	2311.59	2313.49	2311.32	2311.59	3427.0
2016-07-12 01:00:00	ES	Futures	2311.59	2312.68	2310.24	2311.32	5828.0
2016-07-12 02:00:00	ES	Futures	2311.32	2315.93	2311.05	2315.66	11879.0
2016-07-12 03:00:00	ES	Futures	2315.39	2319.46	2314.3	2315.39	45857.0
2016-07-12 04:00:00	ES	Futures	2315.66	2322.98	2314.85	2321.36	41212.0
2016-07-12 05:00:00	ES	Futures	2321.08	2322.44	2320.27	2320.81	24901.0
2016-07-12 06:00:00	ES	Futures	2321.08	2323.25	2320.27	2321.9	22313.0
2016-07-12 07:00:00	ES	Futures	2321.63	2322.44	2320.81	2321.63	23140.0
2016-07-12 08:00:00	ES	Futures	2321.9	2322.98	2320.27	2322.17	37393.0
2016-07-12 09:00:00	ES	Futures	2322.44	2327.05	2321.63	2323.8	282320.0
2016-07-12 10:00:00	ES	Futures	2323.53	2324.61	2319.46	2323.8	276126.0
2016-07-12 11:00:00	ES	Futures	2323.53	2329.22	2322.71	2328.68	197929.0
2016-07-12 12:00:00	ES	Futures	2328.68	2331.12	2328.14	2329.22	142316.0
2016-07-12 13:00:00	ES	Futures	2329.22	2331.12	2327.32	2327.86	116623.0
2016-07-12 14:00:00	ES	Futures	2327.59	2331.39	2327.59	2328.41	128320.0
2016-07-12 15:00:00	ES	Futures	2328.41	2330.03	2326.24	2327.32	223603.0
2016-07-12 16:00:00	ES	Futures	2327.05	2328.14	2325.69	2327.86	75533.0
2016-07-12 18:00:00	ES	Futures	2327.59	2328.14	2325.97	2326.51	4272.0
2016-07-12 19:00:00	ES	Futures	2326.78	2327.86	2326.51	2327.05	2194.0
2016-07-12 20:00:00	ES	Futures	2326.78	2327.59	2325.42	2327.05	6846.0
2016-07-12 21:00:00	ES	Futures	2327.32	2327.32	2325.15	2325.69	8260.0
2016-07-12 22:00:00	ES	Futures	2325.69	2326.51	2323.53	2325.15	8051.0
2016-07-12 23:00:00	ES	Futures	2324.88	2325.69	2324.07	2325.15	3596.0
2016-07-12 00:00:00	NQ	Futures	5427.82	5430.8	5426.62	5427.82	325.0
2016-07-12 01:00:00	NQ	Futures	5427.82	5429.31	5424.54	5426.62	476.0
2016-07-12 02:00:00	NQ	Futures	5427.82	5437.95	5426.62	5436.76	1264.0
2016-07-12 03:00:00	NQ	Futures	5436.76	5448.38	5434.08	5439.74	4136.0
2016-07-12 04:00:00	NQ	Futures	5440.34	5459.11	5438.55	5454.64	4539.0
2016-07-12 05:00:00	NQ	Futures	5454.64	5456.73	5451.36	5453.15	2200.0
2016-07-12 06:00:00	NQ	Futures	5453.45	5456.13	5449.87	5451.07	2343.0
2016-07-12 07:00:00	NQ	Futures	5451.36	5454.05	5449.87	5453.45	2306.0
2016-07-12 08:00:00	NQ	Futures	5453.15	5456.43	5450.17	5454.64	3829.0
2016-07-12 09:00:00	NQ	Futures	5454.64	5462.69	5450.47	5454.05	33504.0
2016-07-12 10:00:00	NQ	Futures	5453.75	5457.03	5441.23	5448.98	32868.0
2016-07-12 11:00:00	NQ	Futures	5448.68	5458.81	5446.3	5456.13	19692.0
2016-07-12 12:00:00	NQ	Futures	5455.83	5460.9	5451.07	5451.96	15491.0
2016-07-12 13:00:00	NQ	Futures	5451.66	5458.81	5442.72	5443.91	14377.0
2016-07-12 14:00:00	NQ	Futures	5443.91	5456.13	5443.91	5447.19	19168.0
2016-07-12 15:00:00	NQ	Futures	5447.19	5454.64	5443.91	5448.98	22694.0
2016-07-12 16:00:00	NQ	Futures	5448.98	5450.17	5444.81	5448.38	4468.0
2016-07-12 18:00:00	NQ	Futures	5450.47	5450.47	5444.81	5446.3	431.0
2016-07-12 19:00:00	NQ	Futures	5446.3	5449.57	5446.3	5447.19	367.0
2016-07-12 20:00:00	NQ	Futures	5447.79	5448.08	5442.72	5447.49	599.0
2016-07-12 21:00:00	NQ	Futures	5446.89	5447.79	5441.53	5443.91	635.0
2016-07-12 22:00:00	NQ	Futures	5443.91	5445.7	5436.16	5440.93	1023.0
2016-07-12 23:00:00	NQ	Futures	5440.93	5444.21	5438.55	5442.72	432.0
2016-07-12 00:00:00	YM	Futures	19538.5	19550.3	19537.4	19541.7	499.0
2016-07-12 01:00:00	YM	Futures	19540.7	19546.0	19526.7	19534.2	971.0
2016-07-12 02:00:00	YM	Futures	19534.2	19572.9	19533.1	19571.9	1390.0
2016-07-12 03:00:00	YM	Futures	19570.8	19603.1	19563.3	19571.9	5740.0

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

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