PREVIEW / futures_1hour / 2014-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-02.parquet
  size:    53 KB
  rows:    1,618

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
2014-10-02 00:00:00	ES	Futures	2035.22	2036.27	2034.96	2035.75	3365.0
2014-10-02 01:00:00	ES	Futures	2036.01	2036.8	2034.44	2034.96	5579.0
2014-10-02 02:00:00	ES	Futures	2034.96	2036.53	2033.65	2035.49	12362.0
2014-10-02 03:00:00	ES	Futures	2035.49	2035.75	2032.34	2033.91	29417.0
2014-10-02 04:00:00	ES	Futures	2033.91	2034.44	2028.68	2029.2	31465.0
2014-10-02 05:00:00	ES	Futures	2029.2	2032.87	2028.94	2032.6	22594.0
2014-10-02 06:00:00	ES	Futures	2032.6	2034.44	2031.03	2033.65	19094.0
2014-10-02 07:00:00	ES	Futures	2033.65	2037.32	2033.65	2035.22	41740.0
2014-10-02 08:00:00	ES	Futures	2035.22	2038.89	2029.99	2032.34	91358.0
2014-10-02 09:00:00	ES	Futures	2032.6	2035.49	2026.32	2032.34	321128.0
2014-10-02 10:00:00	ES	Futures	2032.08	2033.39	2020.29	2020.55	428350.0
2014-10-02 11:00:00	ES	Futures	2020.55	2023.7	2010.08	2016.1	484691.0
2014-10-02 12:00:00	ES	Futures	2016.36	2025.01	2015.32	2024.48	286483.0
2014-10-02 13:00:00	ES	Futures	2024.22	2031.56	2022.91	2028.41	278168.0
2014-10-02 14:00:00	ES	Futures	2028.41	2038.37	2028.15	2035.75	264774.0
2014-10-02 15:00:00	ES	Futures	2036.01	2036.27	2029.46	2031.56	268463.0
2014-10-02 16:00:00	ES	Futures	2031.3	2033.13	2030.25	2031.03	91492.0
2014-10-02 17:00:00	ES	Futures	2031.3	2031.82	2031.03	2031.3	1521.0
2014-10-02 18:00:00	ES	Futures	2031.3	2032.08	2029.46	2029.72	4568.0
2014-10-02 19:00:00	ES	Futures	2029.72	2032.6	2028.41	2032.34	5449.0
2014-10-02 20:00:00	ES	Futures	2032.34	2035.22	2032.08	2033.65	7166.0
2014-10-02 21:00:00	ES	Futures	2033.65	2035.49	2033.65	2034.96	4880.0
2014-10-02 22:00:00	ES	Futures	2035.22	2036.8	2034.96	2035.75	6091.0
2014-10-02 23:00:00	ES	Futures	2035.75	2036.01	2035.22	2035.22	1452.0
2014-10-02 00:00:00	NQ	Futures	4670.51	4672.86	4669.63	4671.1	547.0
2014-10-02 01:00:00	NQ	Futures	4671.39	4673.73	4667.58	4668.46	772.0
2014-10-02 02:00:00	NQ	Futures	4668.75	4671.68	4664.07	4668.75	2270.0
2014-10-02 03:00:00	NQ	Futures	4668.46	4669.63	4659.67	4664.36	4812.0
2014-10-02 04:00:00	NQ	Futures	4664.07	4664.94	4652.05	4653.81	5154.0
2014-10-02 05:00:00	NQ	Futures	4653.81	4664.36	4653.22	4663.48	3278.0
2014-10-02 06:00:00	NQ	Futures	4663.48	4668.46	4660.26	4667.0	3642.0
2014-10-02 07:00:00	NQ	Futures	4667.29	4675.49	4666.7	4671.68	6131.0
2014-10-02 08:00:00	NQ	Futures	4671.68	4682.23	4662.89	4667.0	19038.0
2014-10-02 09:00:00	NQ	Futures	4666.7	4672.86	4654.98	4662.89	54960.0
2014-10-02 10:00:00	NQ	Futures	4662.6	4667.0	4628.61	4629.2	75770.0
2014-10-02 11:00:00	NQ	Futures	4629.49	4639.45	4603.41	4621.29	69509.0
2014-10-02 12:00:00	NQ	Futures	4621.29	4651.17	4620.11	4650.29	42590.0
2014-10-02 13:00:00	NQ	Futures	4650.0	4666.7	4645.9	4657.33	48850.0
2014-10-02 14:00:00	NQ	Futures	4657.33	4677.25	4656.74	4671.68	46851.0
2014-10-02 15:00:00	NQ	Futures	4671.98	4673.15	4659.38	4662.01	40698.0
2014-10-02 16:00:00	NQ	Futures	4662.31	4669.63	4657.91	4658.79	10181.0
2014-10-02 17:00:00	NQ	Futures	4658.5	4660.55	4658.5	4659.67	66.0
2014-10-02 18:00:00	NQ	Futures	4658.2	4661.13	4655.27	4657.03	749.0
2014-10-02 19:00:00	NQ	Futures	4656.74	4664.07	4653.52	4663.77	1023.0
2014-10-02 20:00:00	NQ	Futures	4663.77	4671.39	4663.77	4667.0	1596.0
2014-10-02 21:00:00	NQ	Futures	4667.29	4671.68	4667.29	4670.51	799.0
2014-10-02 22:00:00	NQ	Futures	4670.8	4674.32	4670.22	4672.86	971.0
2014-10-02 23:00:00	NQ	Futures	4672.86	4674.03	4671.39	4672.56	386.0
2014-10-02 00:00:00	YM	Futures	17409.8	17419.2	17409.8	17417.1	478.0
2014-10-02 01:00:00	YM	Futures	17418.1	17423.3	17407.7	17411.9	731.0

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

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