PREVIEW / futures_1hour / 2016-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-26.parquet
  size:    54 KB
  rows:    1,635

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-26 00:00:00	ES	Futures	2321.92	2321.92	2321.11	2321.38	1745.0
2016-10-26 01:00:00	ES	Futures	2321.65	2322.74	2321.38	2322.47	2730.0
2016-10-26 02:00:00	ES	Futures	2322.47	2323.83	2321.92	2322.19	6001.0
2016-10-26 03:00:00	ES	Futures	2322.19	2323.01	2318.66	2319.47	24794.0
2016-10-26 04:00:00	ES	Futures	2319.75	2320.56	2315.94	2318.11	21115.0
2016-10-26 05:00:00	ES	Futures	2317.84	2318.11	2314.03	2316.75	21937.0
2016-10-26 06:00:00	ES	Futures	2316.75	2318.66	2316.21	2317.84	14554.0
2016-10-26 07:00:00	ES	Futures	2317.57	2318.93	2316.75	2318.93	16065.0
2016-10-26 08:00:00	ES	Futures	2318.93	2321.11	2317.84	2318.11	30330.0
2016-10-26 09:00:00	ES	Futures	2318.11	2318.66	2312.4	2314.85	254034.0
2016-10-26 10:00:00	ES	Futures	2315.12	2327.91	2313.49	2327.09	328112.0
2016-10-26 11:00:00	ES	Futures	2326.82	2329.0	2325.19	2325.46	224203.0
2016-10-26 12:00:00	ES	Futures	2325.46	2326.82	2324.37	2324.64	70411.0
2016-10-26 13:00:00	ES	Futures	2324.92	2325.73	2316.21	2317.84	144563.0
2016-10-26 14:00:00	ES	Futures	2317.84	2323.01	2315.12	2322.19	138800.0
2016-10-26 15:00:00	ES	Futures	2321.92	2324.37	2320.29	2321.65	152555.0
2016-10-26 16:00:00	ES	Futures	2321.65	2323.55	2321.38	2322.47	55467.0
2016-10-26 18:00:00	ES	Futures	2322.19	2322.74	2320.83	2321.65	3623.0
2016-10-26 19:00:00	ES	Futures	2321.65	2322.47	2321.11	2322.19	1214.0
2016-10-26 20:00:00	ES	Futures	2322.47	2323.01	2318.66	2318.93	6653.0
2016-10-26 21:00:00	ES	Futures	2319.2	2323.28	2318.93	2320.83	8953.0
2016-10-26 22:00:00	ES	Futures	2320.83	2321.11	2319.47	2319.47	5631.0
2016-10-26 23:00:00	ES	Futures	2319.47	2320.56	2319.2	2319.75	4324.0
2016-10-26 00:00:00	NQ	Futures	5813.65	5813.95	5812.16	5813.06	283.0
2016-10-26 01:00:00	NQ	Futures	5813.65	5817.53	5812.46	5817.53	453.0
2016-10-26 02:00:00	NQ	Futures	5817.53	5818.13	5814.25	5816.34	1090.0
2016-10-26 03:00:00	NQ	Futures	5815.44	5816.93	5804.4	5807.09	4511.0
2016-10-26 04:00:00	NQ	Futures	5807.09	5809.77	5796.05	5798.74	4792.0
2016-10-26 05:00:00	NQ	Futures	5798.74	5799.93	5791.28	5798.44	3627.0
2016-10-26 06:00:00	NQ	Futures	5798.14	5800.53	5796.05	5799.63	2205.0
2016-10-26 07:00:00	NQ	Futures	5799.93	5804.11	5799.03	5803.51	3037.0
2016-10-26 08:00:00	NQ	Futures	5804.11	5809.77	5802.32	5802.91	4426.0
2016-10-26 09:00:00	NQ	Futures	5802.91	5802.91	5777.55	5785.61	46377.0
2016-10-26 10:00:00	NQ	Futures	5785.61	5815.74	5780.84	5814.25	40736.0
2016-10-26 11:00:00	NQ	Futures	5814.25	5825.59	5807.98	5809.18	28653.0
2016-10-26 12:00:00	NQ	Futures	5809.18	5813.35	5805.6	5806.79	11229.0
2016-10-26 13:00:00	NQ	Futures	5806.79	5809.48	5779.64	5783.82	24264.0
2016-10-26 14:00:00	NQ	Futures	5784.12	5797.84	5775.17	5796.05	26141.0
2016-10-26 15:00:00	NQ	Futures	5795.75	5799.63	5790.08	5793.37	19394.0
2016-10-26 16:00:00	NQ	Futures	5792.77	5795.16	5788.59	5792.17	5891.0
2016-10-26 18:00:00	NQ	Futures	5790.08	5794.26	5789.79	5791.87	745.0
2016-10-26 19:00:00	NQ	Futures	5791.58	5793.66	5790.38	5793.37	284.0
2016-10-26 20:00:00	NQ	Futures	5793.66	5794.56	5785.31	5785.61	987.0
2016-10-26 21:00:00	NQ	Futures	5786.21	5795.75	5786.21	5788.29	1431.0
2016-10-26 22:00:00	NQ	Futures	5788.0	5788.29	5784.12	5784.12	971.0
2016-10-26 23:00:00	NQ	Futures	5784.42	5787.1	5783.52	5785.01	598.0
2016-10-26 00:00:00	YM	Futures	19520.7	19521.8	19516.4	19518.6	258.0
2016-10-26 01:00:00	YM	Futures	19518.6	19526.1	19515.3	19525.1	457.0
2016-10-26 02:00:00	YM	Futures	19525.1	19532.6	19518.6	19522.9	961.0
2016-10-26 03:00:00	YM	Futures	19520.7	19528.3	19490.5	19497.0	3626.0

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

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