PREVIEW / futures_1hour / 2014-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-27.parquet
  size:    40 KB
  rows:    1,244

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-06-27 00:00:00	ES	Futures	2026.27	2028.1	2025.49	2027.84	6012.0
2014-06-27 01:00:00	ES	Futures	2028.1	2028.36	2026.53	2028.1	3395.0
2014-06-27 02:00:00	ES	Futures	2028.36	2029.92	2027.32	2027.32	10513.0
2014-06-27 03:00:00	ES	Futures	2027.58	2030.7	2026.53	2029.66	24467.0
2014-06-27 04:00:00	ES	Futures	2029.92	2030.7	2028.36	2030.44	9818.0
2014-06-27 05:00:00	ES	Futures	2030.44	2030.44	2027.32	2027.58	15470.0
2014-06-27 06:00:00	ES	Futures	2027.32	2027.84	2025.49	2026.53	15541.0
2014-06-27 07:00:00	ES	Futures	2026.79	2027.58	2026.01	2027.58	15230.0
2014-06-27 08:00:00	ES	Futures	2027.58	2028.36	2026.01	2026.79	20119.0
2014-06-27 09:00:00	ES	Futures	2026.53	2031.49	2025.23	2029.92	178764.0
2014-06-27 10:00:00	ES	Futures	2030.18	2032.27	2027.58	2030.96	168130.0
2014-06-27 11:00:00	ES	Futures	2031.23	2032.79	2030.18	2031.75	97128.0
2014-06-27 12:00:00	ES	Futures	2032.01	2032.27	2029.66	2030.44	47594.0
2014-06-27 13:00:00	ES	Futures	2030.7	2030.7	2026.27	2029.14	111188.0
2014-06-27 14:00:00	ES	Futures	2028.88	2031.75	2028.36	2028.36	74222.0
2014-06-27 15:00:00	ES	Futures	2028.62	2036.96	2028.36	2036.18	239002.0
2014-06-27 16:00:00	ES	Futures	2036.18	2036.7	2033.57	2034.35	110930.0
2014-06-27 17:00:00	ES	Futures	2034.35	2035.13	2034.35	2035.13	1163.0
2014-06-27 00:00:00	NQ	Futures	4449.14	4453.81	4447.97	4453.52	673.0
2014-06-27 01:00:00	NQ	Futures	4453.52	4454.39	4450.3	4454.39	492.0
2014-06-27 02:00:00	NQ	Futures	4454.39	4457.31	4452.06	4452.06	765.0
2014-06-27 03:00:00	NQ	Futures	4452.06	4459.65	4449.72	4457.31	3144.0
2014-06-27 04:00:00	NQ	Futures	4457.31	4459.06	4453.81	4458.19	1774.0
2014-06-27 05:00:00	NQ	Futures	4458.48	4458.48	4451.76	4451.76	1878.0
2014-06-27 06:00:00	NQ	Futures	4451.76	4454.39	4448.55	4452.35	3177.0
2014-06-27 07:00:00	NQ	Futures	4452.06	4454.39	4449.72	4454.1	1981.0
2014-06-27 08:00:00	NQ	Futures	4454.1	4455.56	4449.72	4452.93	4140.0
2014-06-27 09:00:00	NQ	Futures	4452.93	4467.24	4450.01	4461.98	34569.0
2014-06-27 10:00:00	NQ	Futures	4461.69	4465.78	4454.98	4461.69	28489.0
2014-06-27 11:00:00	NQ	Futures	4461.69	4468.99	4461.69	4467.82	16016.0
2014-06-27 12:00:00	NQ	Futures	4468.12	4468.41	4464.32	4467.53	6371.0
2014-06-27 13:00:00	NQ	Futures	4467.53	4467.82	4455.56	4464.32	18913.0
2014-06-27 14:00:00	NQ	Futures	4464.03	4473.37	4463.44	4466.36	15974.0
2014-06-27 15:00:00	NQ	Futures	4466.07	4481.55	4465.78	4479.21	31348.0
2014-06-27 16:00:00	NQ	Futures	4478.92	4482.72	4474.83	4476.59	9018.0
2014-06-27 17:00:00	NQ	Futures	4476.29	4477.17	4475.71	4475.71	122.0
2014-06-27 00:00:00	YM	Futures	17304.2	17320.7	17301.1	17313.5	1277.0
2014-06-27 01:00:00	YM	Futures	17312.5	17318.7	17302.1	17318.7	947.0
2014-06-27 02:00:00	YM	Futures	17319.7	17330.0	17312.5	17312.5	598.0
2014-06-27 03:00:00	YM	Futures	17313.5	17337.3	17304.2	17332.1	3072.0
2014-06-27 04:00:00	YM	Futures	17332.1	17340.4	17320.7	17336.3	1427.0
2014-06-27 05:00:00	YM	Futures	17336.3	17337.3	17315.6	17316.6	1794.0
2014-06-27 06:00:00	YM	Futures	17315.6	17319.7	17302.1	17311.4	2356.0
2014-06-27 07:00:00	YM	Futures	17310.4	17317.6	17305.2	17315.6	1705.0
2014-06-27 08:00:00	YM	Futures	17315.6	17320.7	17302.1	17308.3	1702.0
2014-06-27 09:00:00	YM	Futures	17308.3	17336.3	17290.7	17316.6	18045.0
2014-06-27 10:00:00	YM	Futures	17316.6	17330.0	17286.6	17318.7	15064.0
2014-06-27 11:00:00	YM	Futures	17319.7	17329.0	17308.3	17315.6	7584.0
2014-06-27 12:00:00	YM	Futures	17316.6	17319.7	17302.1	17306.3	4240.0
2014-06-27 13:00:00	YM	Futures	17305.2	17305.2	17262.8	17280.4	14075.0

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

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