PREVIEW / futures_1hour / 2014-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-21.parquet
  size:    41 KB
  rows:    1,255

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-02-21 00:00:00	ES	Futures	1904.98	1907.05	1904.72	1906.02	9101.0
2014-02-21 01:00:00	ES	Futures	1905.76	1906.27	1904.72	1906.02	3906.0
2014-02-21 02:00:00	ES	Futures	1906.02	1906.53	1904.46	1906.02	8633.0
2014-02-21 03:00:00	ES	Futures	1905.76	1906.27	1901.62	1903.43	28245.0
2014-02-21 04:00:00	ES	Futures	1903.17	1904.46	1901.88	1903.95	12657.0
2014-02-21 05:00:00	ES	Futures	1903.95	1903.95	1901.88	1902.91	15808.0
2014-02-21 06:00:00	ES	Futures	1902.65	1904.21	1901.88	1903.95	14859.0
2014-02-21 07:00:00	ES	Futures	1903.95	1904.46	1902.91	1903.95	15128.0
2014-02-21 08:00:00	ES	Futures	1903.95	1904.21	1901.36	1901.88	25515.0
2014-02-21 09:00:00	ES	Futures	1901.88	1906.02	1899.81	1904.72	213359.0
2014-02-21 10:00:00	ES	Futures	1904.46	1906.79	1900.84	1905.76	229865.0
2014-02-21 11:00:00	ES	Futures	1906.02	1907.83	1903.69	1905.24	173836.0
2014-02-21 12:00:00	ES	Futures	1905.24	1906.27	1902.14	1903.95	76075.0
2014-02-21 13:00:00	ES	Futures	1903.95	1906.02	1902.14	1902.91	56122.0
2014-02-21 14:00:00	ES	Futures	1903.17	1903.69	1897.74	1899.81	128582.0
2014-02-21 15:00:00	ES	Futures	1900.07	1902.91	1896.19	1897.48	180446.0
2014-02-21 16:00:00	ES	Futures	1897.48	1898.52	1896.7	1897.22	85385.0
2014-02-21 17:00:00	ES	Futures	1897.22	1897.48	1896.7	1896.96	1469.0
2014-02-21 00:00:00	NQ	Futures	4279.75	4283.53	4279.46	4280.62	1095.0
2014-02-21 01:00:00	NQ	Futures	4280.91	4282.66	4278.59	4282.08	564.0
2014-02-21 02:00:00	NQ	Futures	4281.79	4283.53	4279.46	4281.2	542.0
2014-02-21 03:00:00	NQ	Futures	4281.2	4282.08	4271.03	4275.1	2695.0
2014-02-21 04:00:00	NQ	Futures	4275.39	4278.59	4272.48	4277.14	1061.0
2014-02-21 05:00:00	NQ	Futures	4276.84	4277.43	4273.07	4274.81	855.0
2014-02-21 06:00:00	NQ	Futures	4274.52	4277.72	4272.77	4277.14	923.0
2014-02-21 07:00:00	NQ	Futures	4276.84	4279.46	4274.81	4278.59	1562.0
2014-02-21 08:00:00	NQ	Futures	4278.88	4278.88	4272.48	4273.07	3695.0
2014-02-21 09:00:00	NQ	Futures	4273.36	4286.73	4272.48	4284.11	39779.0
2014-02-21 10:00:00	NQ	Futures	4284.11	4285.57	4273.36	4282.66	31440.0
2014-02-21 11:00:00	NQ	Futures	4282.95	4284.69	4277.72	4278.3	22726.0
2014-02-21 12:00:00	NQ	Futures	4278.3	4280.91	4268.41	4272.19	12780.0
2014-02-21 13:00:00	NQ	Futures	4271.9	4277.43	4269.29	4270.16	9364.0
2014-02-21 14:00:00	NQ	Futures	4270.16	4271.9	4259.69	4264.93	19910.0
2014-02-21 15:00:00	NQ	Futures	4265.22	4270.74	4256.5	4258.82	27430.0
2014-02-21 16:00:00	NQ	Futures	4258.82	4262.6	4258.24	4261.44	6174.0
2014-02-21 17:00:00	NQ	Futures	4261.15	4261.73	4259.98	4259.98	67.0
2014-02-21 00:00:00	YM	Futures	16557.2	16573.6	16555.1	16563.3	1288.0
2014-02-21 01:00:00	YM	Futures	16562.3	16569.5	16553.1	16565.4	415.0
2014-02-21 02:00:00	YM	Futures	16567.4	16572.6	16555.1	16562.3	514.0
2014-02-21 03:00:00	YM	Futures	16561.3	16568.5	16531.5	16545.9	3354.0
2014-02-21 04:00:00	YM	Futures	16545.9	16554.1	16532.6	16549.0	1493.0
2014-02-21 05:00:00	YM	Futures	16549.0	16551.0	16531.5	16538.7	1798.0
2014-02-21 06:00:00	YM	Futures	16536.7	16550.0	16533.6	16546.9	1247.0
2014-02-21 07:00:00	YM	Futures	16545.9	16546.9	16537.7	16541.8	1875.0
2014-02-21 08:00:00	YM	Futures	16542.8	16544.9	16522.3	16526.4	3253.0
2014-02-21 09:00:00	YM	Futures	16525.4	16567.4	16499.8	16560.3	20231.0
2014-02-21 10:00:00	YM	Futures	16559.2	16581.8	16519.2	16558.2	24895.0
2014-02-21 11:00:00	YM	Futures	16559.2	16575.6	16548.0	16556.2	16494.0
2014-02-21 12:00:00	YM	Futures	16557.2	16563.3	16522.3	16539.7	11620.0
2014-02-21 13:00:00	YM	Futures	16539.7	16556.2	16520.3	16524.4	6928.0

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

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