PREVIEW / futures_1hour / 2016-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-13.parquet
  size:    53 KB
  rows:    1,619

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-13 00:00:00	ES	Futures	2325.42	2327.05	2324.07	2325.97	5228.0
2016-07-13 01:00:00	ES	Futures	2325.97	2325.97	2323.8	2324.34	4490.0
2016-07-13 02:00:00	ES	Futures	2324.61	2326.24	2323.8	2325.42	9234.0
2016-07-13 03:00:00	ES	Futures	2325.69	2328.95	2324.07	2326.24	37767.0
2016-07-13 04:00:00	ES	Futures	2326.24	2328.41	2324.88	2327.59	19814.0
2016-07-13 05:00:00	ES	Futures	2327.59	2330.03	2326.51	2329.22	17097.0
2016-07-13 06:00:00	ES	Futures	2329.49	2330.85	2328.41	2329.49	19511.0
2016-07-13 07:00:00	ES	Futures	2329.22	2329.76	2327.86	2329.22	14964.0
2016-07-13 08:00:00	ES	Futures	2329.22	2334.64	2329.22	2333.83	48680.0
2016-07-13 09:00:00	ES	Futures	2333.56	2334.1	2325.15	2326.51	239131.0
2016-07-13 10:00:00	ES	Futures	2326.51	2330.03	2325.42	2328.68	241869.0
2016-07-13 11:00:00	ES	Futures	2328.68	2330.03	2320.81	2323.25	233645.0
2016-07-13 12:00:00	ES	Futures	2322.98	2325.42	2322.71	2325.15	129374.0
2016-07-13 13:00:00	ES	Futures	2325.42	2327.59	2323.53	2324.88	145641.0
2016-07-13 14:00:00	ES	Futures	2324.88	2329.49	2323.53	2328.14	161449.0
2016-07-13 15:00:00	ES	Futures	2328.14	2329.76	2326.24	2327.05	191214.0
2016-07-13 16:00:00	ES	Futures	2327.05	2328.14	2326.78	2327.59	56196.0
2016-07-13 18:00:00	ES	Futures	2327.05	2327.32	2324.61	2325.69	5019.0
2016-07-13 19:00:00	ES	Futures	2325.69	2326.24	2325.42	2325.42	1445.0
2016-07-13 20:00:00	ES	Futures	2325.42	2326.24	2324.34	2324.88	4061.0
2016-07-13 21:00:00	ES	Futures	2324.88	2326.24	2324.61	2325.42	5443.0
2016-07-13 22:00:00	ES	Futures	2325.42	2327.05	2325.42	2326.78	4058.0
2016-07-13 23:00:00	ES	Futures	2326.78	2328.41	2326.51	2327.05	4963.0
2016-07-13 00:00:00	NQ	Futures	5442.42	5445.7	5438.84	5443.91	352.0
2016-07-13 01:00:00	NQ	Futures	5443.02	5443.61	5438.84	5440.04	527.0
2016-07-13 02:00:00	NQ	Futures	5440.63	5445.1	5438.25	5442.72	992.0
2016-07-13 03:00:00	NQ	Futures	5443.32	5452.85	5440.04	5446.3	2573.0
2016-07-13 04:00:00	NQ	Futures	5446.59	5451.96	5442.72	5450.47	1536.0
2016-07-13 05:00:00	NQ	Futures	5451.07	5457.03	5447.49	5455.83	1285.0
2016-07-13 06:00:00	NQ	Futures	5455.83	5460.01	5453.75	5457.03	1720.0
2016-07-13 07:00:00	NQ	Futures	5456.73	5457.62	5453.75	5456.13	1469.0
2016-07-13 08:00:00	NQ	Futures	5456.13	5465.67	5455.54	5464.18	5041.0
2016-07-13 09:00:00	NQ	Futures	5464.48	5464.78	5444.21	5453.15	39005.0
2016-07-13 10:00:00	NQ	Futures	5453.45	5464.48	5450.17	5460.6	28909.0
2016-07-13 11:00:00	NQ	Futures	5460.9	5463.29	5434.97	5443.02	26967.0
2016-07-13 12:00:00	NQ	Futures	5443.02	5447.49	5439.44	5445.7	12745.0
2016-07-13 13:00:00	NQ	Futures	5445.7	5451.07	5441.23	5442.42	14110.0
2016-07-13 14:00:00	NQ	Futures	5442.72	5451.96	5438.84	5445.1	18145.0
2016-07-13 15:00:00	NQ	Futures	5444.81	5450.77	5435.27	5435.27	21195.0
2016-07-13 16:00:00	NQ	Futures	5435.57	5438.84	5434.67	5437.65	3808.0
2016-07-13 18:00:00	NQ	Futures	5437.65	5437.65	5428.71	5430.5	939.0
2016-07-13 19:00:00	NQ	Futures	5430.5	5432.59	5430.5	5431.1	277.0
2016-07-13 20:00:00	NQ	Futures	5430.8	5434.08	5429.31	5431.99	514.0
2016-07-13 21:00:00	NQ	Futures	5431.1	5435.86	5430.5	5433.78	822.0
2016-07-13 22:00:00	NQ	Futures	5433.78	5438.25	5433.78	5437.35	587.0
2016-07-13 23:00:00	NQ	Futures	5437.65	5441.53	5436.46	5437.35	349.0
2016-07-13 00:00:00	YM	Futures	19634.3	19658.0	19622.4	19642.9	2572.0
2016-07-13 01:00:00	YM	Futures	19644.0	19644.0	19613.8	19626.8	3045.0
2016-07-13 02:00:00	YM	Futures	19625.7	19636.4	19610.6	19628.9	1225.0
2016-07-13 03:00:00	YM	Futures	19630.0	19658.0	19622.4	19637.5	3118.0

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

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