PREVIEW / futures_1hour / 2012-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-27.parquet
  size:    41 KB
  rows:    1,200

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
2012-01-27 00:00:00	ES	Futures	1321.68	1322.94	1321.68	1321.68	3272.0
2012-01-27 01:00:00	ES	Futures	1321.68	1324.45	1321.17	1324.2	4227.0
2012-01-27 02:00:00	ES	Futures	1324.2	1324.7	1321.17	1322.18	9284.0
2012-01-27 03:00:00	ES	Futures	1322.18	1326.21	1321.43	1325.2	33135.0
2012-01-27 04:00:00	ES	Futures	1325.2	1327.72	1324.45	1326.97	24290.0
2012-01-27 05:00:00	ES	Futures	1326.97	1329.74	1326.97	1329.49	25862.0
2012-01-27 06:00:00	ES	Futures	1329.49	1329.49	1326.21	1326.72	19871.0
2012-01-27 07:00:00	ES	Futures	1326.46	1327.98	1325.71	1327.47	23495.0
2012-01-27 08:00:00	ES	Futures	1327.72	1327.98	1317.39	1318.4	129700.0
2012-01-27 09:00:00	ES	Futures	1318.15	1324.7	1317.65	1323.44	214907.0
2012-01-27 10:00:00	ES	Futures	1323.69	1324.2	1318.65	1321.17	289936.0
2012-01-27 11:00:00	ES	Futures	1321.43	1323.19	1318.4	1320.67	232084.0
2012-01-27 12:00:00	ES	Futures	1320.42	1322.18	1317.39	1318.15	163635.0
2012-01-27 13:00:00	ES	Futures	1318.4	1322.69	1317.65	1322.18	121007.0
2012-01-27 14:00:00	ES	Futures	1322.43	1324.2	1320.42	1323.44	102322.0
2012-01-27 15:00:00	ES	Futures	1323.19	1326.72	1322.94	1323.19	203773.0
2012-01-27 16:00:00	ES	Futures	1323.19	1327.72	1322.43	1323.19	89338.0
2012-01-27 00:00:00	NQ	Futures	2828.2	2830.51	2827.91	2828.49	194.0
2012-01-27 01:00:00	NQ	Futures	2828.49	2834.27	2827.91	2833.98	353.0
2012-01-27 02:00:00	NQ	Futures	2833.69	2834.27	2828.2	2830.22	690.0
2012-01-27 03:00:00	NQ	Futures	2829.94	2840.04	2827.91	2836.29	2901.0
2012-01-27 04:00:00	NQ	Futures	2836.58	2841.78	2835.42	2840.62	1190.0
2012-01-27 05:00:00	NQ	Futures	2841.2	2846.4	2840.91	2846.11	1622.0
2012-01-27 06:00:00	NQ	Futures	2845.82	2846.11	2839.47	2840.04	1749.0
2012-01-27 07:00:00	NQ	Futures	2840.33	2843.8	2838.6	2842.93	1491.0
2012-01-27 08:00:00	NQ	Futures	2842.64	2842.93	2824.16	2825.89	12937.0
2012-01-27 09:00:00	NQ	Futures	2825.6	2840.91	2825.03	2838.31	26854.0
2012-01-27 10:00:00	NQ	Futures	2838.89	2840.62	2829.07	2834.56	31548.0
2012-01-27 11:00:00	NQ	Futures	2834.84	2840.04	2830.51	2833.98	18943.0
2012-01-27 12:00:00	NQ	Futures	2833.98	2837.15	2829.65	2830.8	13841.0
2012-01-27 13:00:00	NQ	Futures	2830.8	2839.47	2829.65	2837.73	11092.0
2012-01-27 14:00:00	NQ	Futures	2837.73	2839.75	2833.4	2838.6	11457.0
2012-01-27 15:00:00	NQ	Futures	2838.6	2846.97	2838.31	2840.62	22583.0
2012-01-27 16:00:00	NQ	Futures	2840.33	2844.37	2835.42	2836.58	8192.0
2012-01-27 00:00:00	YM	Futures	12542.8	12547.8	12540.8	12540.8	238.0
2012-01-27 01:00:00	YM	Futures	12541.8	12562.6	12535.9	12559.7	240.0
2012-01-27 02:00:00	YM	Futures	12559.7	12563.6	12537.9	12545.8	526.0
2012-01-27 03:00:00	YM	Futures	12544.8	12578.5	12539.8	12567.6	1634.0
2012-01-27 04:00:00	YM	Futures	12568.6	12591.4	12563.6	12588.4	1480.0
2012-01-27 05:00:00	YM	Futures	12587.4	12607.2	12587.4	12606.3	1345.0
2012-01-27 06:00:00	YM	Futures	12606.3	12606.3	12579.5	12584.4	1124.0
2012-01-27 07:00:00	YM	Futures	12583.5	12595.3	12578.5	12593.4	1671.0
2012-01-27 08:00:00	YM	Futures	12593.4	12594.4	12505.2	12514.1	6547.0
2012-01-27 09:00:00	YM	Futures	12512.1	12539.8	12496.2	12529.9	14116.0
2012-01-27 10:00:00	YM	Futures	12529.9	12533.9	12485.3	12506.1	19826.0
2012-01-27 11:00:00	YM	Futures	12507.1	12520.0	12471.5	12490.3	12911.0
2012-01-27 12:00:00	YM	Futures	12490.3	12503.2	12464.5	12470.5	7711.0
2012-01-27 13:00:00	YM	Futures	12471.5	12507.1	12465.5	12502.2	6554.0
2012-01-27 14:00:00	YM	Futures	12502.2	12511.1	12487.3	12503.2	4859.0
2012-01-27 15:00:00	YM	Futures	12503.2	12534.9	12500.2	12504.2	10973.0

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

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