PREVIEW / futures_1hour / 2016-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-25.parquet
  size:    52 KB
  rows:    1,637

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-10-25 00:00:00	ES	Futures	2337.16	2337.43	2336.34	2336.89	2399.0
2016-10-25 01:00:00	ES	Futures	2337.16	2338.25	2336.61	2337.97	4207.0
2016-10-25 02:00:00	ES	Futures	2337.97	2338.25	2335.8	2335.8	4263.0
2016-10-25 03:00:00	ES	Futures	2335.8	2337.43	2335.53	2336.89	15465.0
2016-10-25 04:00:00	ES	Futures	2337.16	2339.34	2336.61	2339.34	9936.0
2016-10-25 05:00:00	ES	Futures	2339.06	2339.61	2335.8	2336.07	9075.0
2016-10-25 06:00:00	ES	Futures	2336.07	2337.97	2333.89	2334.44	11513.0
2016-10-25 07:00:00	ES	Futures	2334.44	2336.34	2333.35	2335.53	14515.0
2016-10-25 08:00:00	ES	Futures	2335.25	2336.89	2334.98	2335.8	19676.0
2016-10-25 09:00:00	ES	Futures	2336.07	2336.34	2329.0	2333.08	170894.0
2016-10-25 10:00:00	ES	Futures	2333.08	2335.25	2324.92	2327.09	266607.0
2016-10-25 11:00:00	ES	Futures	2327.36	2329.81	2326.0	2327.09	135554.0
2016-10-25 12:00:00	ES	Futures	2326.82	2328.18	2323.83	2327.36	116430.0
2016-10-25 13:00:00	ES	Futures	2327.36	2329.81	2326.0	2328.72	74920.0
2016-10-25 14:00:00	ES	Futures	2328.72	2329.81	2324.92	2325.46	87611.0
2016-10-25 15:00:00	ES	Futures	2325.73	2327.09	2324.64	2326.55	161373.0
2016-10-25 16:00:00	ES	Futures	2326.28	2328.18	2323.83	2325.46	70749.0
2016-10-25 18:00:00	ES	Futures	2323.83	2324.37	2320.83	2322.74	5536.0
2016-10-25 19:00:00	ES	Futures	2322.74	2323.55	2322.47	2322.74	1935.0
2016-10-25 20:00:00	ES	Futures	2322.74	2322.74	2320.02	2321.92	8565.0
2016-10-25 21:00:00	ES	Futures	2321.92	2322.47	2320.56	2321.11	4799.0
2016-10-25 22:00:00	ES	Futures	2321.11	2322.74	2320.83	2322.74	3283.0
2016-10-25 23:00:00	ES	Futures	2322.47	2323.01	2321.11	2321.65	4100.0
2016-10-25 00:00:00	NQ	Futures	5864.37	5866.16	5861.98	5862.58	713.0
2016-10-25 01:00:00	NQ	Futures	5862.88	5865.86	5861.98	5865.86	583.0
2016-10-25 02:00:00	NQ	Futures	5865.56	5866.16	5860.49	5861.39	959.0
2016-10-25 03:00:00	NQ	Futures	5861.09	5864.97	5860.79	5864.07	2071.0
2016-10-25 04:00:00	NQ	Futures	5863.77	5870.04	5862.88	5869.44	1811.0
2016-10-25 05:00:00	NQ	Futures	5869.74	5870.63	5862.88	5862.88	1625.0
2016-10-25 06:00:00	NQ	Futures	5862.58	5867.95	5857.51	5858.1	2326.0
2016-10-25 07:00:00	NQ	Futures	5857.81	5860.49	5855.12	5858.1	2356.0
2016-10-25 08:00:00	NQ	Futures	5858.4	5862.88	5856.91	5860.79	3170.0
2016-10-25 09:00:00	NQ	Futures	5860.79	5861.39	5843.78	5852.14	27838.0
2016-10-25 10:00:00	NQ	Futures	5851.84	5856.31	5833.34	5840.5	36914.0
2016-10-25 11:00:00	NQ	Futures	5840.2	5844.38	5834.24	5834.24	20019.0
2016-10-25 12:00:00	NQ	Futures	5834.54	5836.33	5826.78	5833.94	18498.0
2016-10-25 13:00:00	NQ	Futures	5833.64	5840.5	5829.76	5837.82	10817.0
2016-10-25 14:00:00	NQ	Futures	5838.12	5840.2	5825.88	5827.38	11794.0
2016-10-25 15:00:00	NQ	Futures	5827.67	5831.85	5824.09	5831.55	19782.0
2016-10-25 16:00:00	NQ	Futures	5831.55	5850.94	5815.74	5822.9	15756.0
2016-10-25 18:00:00	NQ	Futures	5816.34	5816.93	5812.16	5815.44	1570.0
2016-10-25 19:00:00	NQ	Futures	5815.44	5818.13	5814.55	5815.44	756.0
2016-10-25 20:00:00	NQ	Futures	5815.44	5815.74	5810.07	5813.06	1298.0
2016-10-25 21:00:00	NQ	Futures	5813.35	5814.85	5810.07	5811.56	905.0
2016-10-25 22:00:00	NQ	Futures	5811.56	5818.13	5810.97	5816.93	1035.0
2016-10-25 23:00:00	NQ	Futures	5817.23	5817.83	5811.86	5813.35	762.0
2016-10-25 00:00:00	YM	Futures	19624.5	19626.7	19618.0	19621.2	549.0
2016-10-25 01:00:00	YM	Futures	19621.2	19631.0	19616.9	19627.7	811.0
2016-10-25 02:00:00	YM	Futures	19629.9	19629.9	19607.2	19608.3	1033.0
2016-10-25 03:00:00	YM	Futures	19607.2	19624.5	19607.2	19620.2	2150.0

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

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