PREVIEW / futures_1hour / 2013-11-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-11.parquet
  size:    46 KB
  rows:    1,472

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
2013-11-11 00:00:00	ES	Futures	1819.91	1821.72	1819.39	1821.72	4282.0
2013-11-11 01:00:00	ES	Futures	1821.72	1821.97	1820.94	1820.94	2059.0
2013-11-11 02:00:00	ES	Futures	1821.2	1823.01	1820.94	1821.72	7039.0
2013-11-11 03:00:00	ES	Futures	1821.46	1821.46	1819.39	1820.43	15525.0
2013-11-11 04:00:00	ES	Futures	1820.17	1822.23	1820.17	1821.97	11151.0
2013-11-11 05:00:00	ES	Futures	1821.72	1824.81	1821.72	1823.78	11507.0
2013-11-11 06:00:00	ES	Futures	1823.78	1824.3	1822.23	1822.75	9001.0
2013-11-11 07:00:00	ES	Futures	1822.75	1825.07	1822.23	1824.81	19890.0
2013-11-11 08:00:00	ES	Futures	1824.55	1824.81	1822.49	1823.01	22317.0
2013-11-11 09:00:00	ES	Futures	1823.01	1826.62	1820.17	1825.33	194474.0
2013-11-11 10:00:00	ES	Futures	1825.59	1826.36	1822.23	1825.33	167090.0
2013-11-11 11:00:00	ES	Futures	1825.33	1825.59	1822.23	1824.3	113635.0
2013-11-11 12:00:00	ES	Futures	1824.3	1824.3	1822.75	1824.04	69335.0
2013-11-11 13:00:00	ES	Futures	1823.78	1825.07	1823.26	1824.3	59320.0
2013-11-11 14:00:00	ES	Futures	1824.3	1824.55	1823.52	1824.3	66265.0
2013-11-11 15:00:00	ES	Futures	1824.3	1824.81	1823.52	1824.3	103768.0
2013-11-11 16:00:00	ES	Futures	1824.04	1824.55	1823.52	1823.78	41277.0
2013-11-11 17:00:00	ES	Futures	1824.04	1824.3	1823.78	1824.04	1173.0
2013-11-11 18:00:00	ES	Futures	1824.04	1824.55	1823.52	1824.04	2706.0
2013-11-11 19:00:00	ES	Futures	1824.04	1825.33	1823.78	1825.07	8558.0
2013-11-11 20:00:00	ES	Futures	1825.07	1825.33	1823.78	1824.55	16226.0
2013-11-11 21:00:00	ES	Futures	1824.55	1824.81	1823.52	1824.04	3461.0
2013-11-11 22:00:00	ES	Futures	1824.04	1824.81	1823.78	1824.3	3642.0
2013-11-11 23:00:00	ES	Futures	1824.04	1825.07	1823.78	1825.07	2833.0
2013-11-11 00:00:00	NQ	Futures	3897.31	3901.09	3896.73	3900.22	616.0
2013-11-11 01:00:00	NQ	Futures	3900.22	3900.8	3899.35	3899.64	150.0
2013-11-11 02:00:00	NQ	Futures	3899.93	3903.41	3899.64	3900.22	846.0
2013-11-11 03:00:00	NQ	Futures	3899.93	3899.93	3895.57	3897.89	1805.0
2013-11-11 04:00:00	NQ	Futures	3897.6	3901.67	3897.31	3899.93	1387.0
2013-11-11 05:00:00	NQ	Futures	3899.93	3906.03	3899.93	3903.12	1495.0
2013-11-11 06:00:00	NQ	Futures	3903.7	3904.57	3900.51	3901.38	1143.0
2013-11-11 07:00:00	NQ	Futures	3901.09	3906.9	3900.8	3906.61	2308.0
2013-11-11 08:00:00	NQ	Futures	3906.61	3906.61	3899.93	3901.09	4069.0
2013-11-11 09:00:00	NQ	Futures	3901.09	3909.8	3890.34	3907.19	39051.0
2013-11-11 10:00:00	NQ	Futures	3907.48	3908.35	3891.8	3898.48	33185.0
2013-11-11 11:00:00	NQ	Futures	3898.48	3902.83	3886.57	3901.67	20114.0
2013-11-11 12:00:00	NQ	Futures	3901.38	3903.7	3897.6	3903.12	11622.0
2013-11-11 13:00:00	NQ	Futures	3903.12	3906.32	3901.38	3903.7	6948.0
2013-11-11 14:00:00	NQ	Futures	3903.41	3905.16	3901.38	3902.83	7355.0
2013-11-11 15:00:00	NQ	Futures	3903.12	3906.03	3898.77	3899.93	22544.0
2013-11-11 16:00:00	NQ	Futures	3899.93	3899.93	3897.02	3897.02	5113.0
2013-11-11 17:00:00	NQ	Futures	3897.6	3898.19	3897.31	3897.89	87.0
2013-11-11 18:00:00	NQ	Futures	3897.31	3899.35	3897.02	3897.6	609.0
2013-11-11 19:00:00	NQ	Futures	3897.89	3899.93	3897.6	3899.06	1283.0
2013-11-11 20:00:00	NQ	Futures	3899.06	3899.06	3896.15	3897.31	1231.0
2013-11-11 21:00:00	NQ	Futures	3897.31	3898.19	3895.57	3896.44	880.0
2013-11-11 22:00:00	NQ	Futures	3896.15	3899.35	3896.15	3897.02	1620.0
2013-11-11 23:00:00	NQ	Futures	3897.31	3898.77	3896.15	3898.19	480.0
2013-11-11 00:00:00	YM	Futures	16020.3	16032.6	16017.2	16032.6	526.0
2013-11-11 01:00:00	YM	Futures	16032.6	16033.6	16026.4	16026.4	355.0

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

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