PREVIEW / futures_1hour / 2014-01-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-29.parquet
  size:    54 KB
  rows:    1,596

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-01-29 00:00:00	ES	Futures	1859.98	1860.49	1858.42	1859.2	4137.0
2014-01-29 01:00:00	ES	Futures	1859.2	1860.49	1858.94	1859.2	3530.0
2014-01-29 02:00:00	ES	Futures	1859.2	1860.49	1857.39	1857.91	12693.0
2014-01-29 03:00:00	ES	Futures	1858.17	1862.04	1857.65	1858.68	41958.0
2014-01-29 04:00:00	ES	Futures	1858.42	1858.94	1851.44	1855.06	43109.0
2014-01-29 05:00:00	ES	Futures	1854.8	1855.58	1849.89	1851.44	24233.0
2014-01-29 06:00:00	ES	Futures	1851.18	1851.44	1845.49	1849.37	47432.0
2014-01-29 07:00:00	ES	Futures	1849.11	1852.99	1840.58	1844.46	82611.0
2014-01-29 08:00:00	ES	Futures	1844.2	1847.04	1833.59	1836.96	158124.0
2014-01-29 09:00:00	ES	Futures	1836.96	1839.28	1829.71	1836.7	417810.0
2014-01-29 10:00:00	ES	Futures	1836.44	1840.84	1832.56	1837.73	332360.0
2014-01-29 11:00:00	ES	Futures	1837.99	1842.65	1837.99	1842.13	201738.0
2014-01-29 12:00:00	ES	Futures	1841.87	1842.65	1834.63	1837.47	106438.0
2014-01-29 13:00:00	ES	Futures	1837.21	1837.73	1833.33	1836.7	133912.0
2014-01-29 14:00:00	ES	Futures	1836.96	1842.65	1825.06	1829.2	573625.0
2014-01-29 15:00:00	ES	Futures	1829.2	1833.85	1825.83	1829.97	372307.0
2014-01-29 16:00:00	ES	Futures	1829.97	1835.66	1829.2	1831.01	103893.0
2014-01-29 17:00:00	ES	Futures	1831.27	1832.82	1830.75	1831.52	3783.0
2014-01-29 18:00:00	ES	Futures	1831.27	1837.47	1831.27	1836.7	14100.0
2014-01-29 19:00:00	ES	Futures	1836.7	1836.96	1833.33	1835.66	8798.0
2014-01-29 20:00:00	ES	Futures	1835.66	1836.7	1829.45	1831.78	12268.0
2014-01-29 21:00:00	ES	Futures	1831.78	1832.82	1828.94	1830.75	7729.0
2014-01-29 22:00:00	ES	Futures	1831.01	1836.18	1830.75	1835.92	8171.0
2014-01-29 23:00:00	ES	Futures	1835.66	1837.47	1835.4	1836.18	5206.0
2014-01-29 00:00:00	NQ	Futures	4093.42	4094.59	4090.52	4093.13	646.0
2014-01-29 01:00:00	NQ	Futures	4092.55	4095.46	4091.68	4092.26	716.0
2014-01-29 02:00:00	NQ	Futures	4092.26	4094.59	4088.77	4090.22	1138.0
2014-01-29 03:00:00	NQ	Futures	4090.52	4103.31	4089.35	4095.17	5731.0
2014-01-29 04:00:00	NQ	Futures	4095.17	4096.04	4080.05	4087.9	6313.0
2014-01-29 05:00:00	NQ	Futures	4088.48	4090.52	4075.98	4081.21	3991.0
2014-01-29 06:00:00	NQ	Futures	4080.63	4081.21	4067.26	4076.85	5726.0
2014-01-29 07:00:00	NQ	Futures	4076.56	4082.67	4049.24	4057.67	14369.0
2014-01-29 08:00:00	NQ	Futures	4057.38	4064.35	4031.8	4039.94	20885.0
2014-01-29 09:00:00	NQ	Futures	4040.23	4050.98	4022.2	4045.17	63890.0
2014-01-29 10:00:00	NQ	Futures	4044.88	4052.15	4030.63	4042.26	41953.0
2014-01-29 11:00:00	NQ	Futures	4042.84	4060.28	4042.84	4060.28	31528.0
2014-01-29 12:00:00	NQ	Futures	4060.58	4063.48	4039.65	4045.46	20204.0
2014-01-29 13:00:00	NQ	Futures	4046.04	4047.2	4038.19	4043.72	20107.0
2014-01-29 14:00:00	NQ	Futures	4043.13	4053.31	4017.55	4023.08	88178.0
2014-01-29 15:00:00	NQ	Futures	4022.79	4033.25	4016.39	4024.82	52467.0
2014-01-29 16:00:00	NQ	Futures	4024.53	4045.75	4023.95	4041.68	11765.0
2014-01-29 17:00:00	NQ	Futures	4041.68	4044.01	4041.1	4043.13	268.0
2014-01-29 18:00:00	NQ	Futures	4046.33	4057.67	4046.33	4056.8	2486.0
2014-01-29 19:00:00	NQ	Futures	4056.51	4056.8	4047.2	4051.27	2099.0
2014-01-29 20:00:00	NQ	Futures	4051.56	4054.47	4037.61	4042.55	2980.0
2014-01-29 21:00:00	NQ	Futures	4042.84	4044.3	4035.87	4040.23	1859.0
2014-01-29 22:00:00	NQ	Futures	4040.52	4051.27	4039.94	4050.98	1437.0
2014-01-29 23:00:00	NQ	Futures	4050.4	4054.76	4049.82	4051.56	961.0
2014-01-29 00:00:00	YM	Futures	16355.2	16359.3	16344.9	16352.1	343.0
2014-01-29 01:00:00	YM	Futures	16350.0	16362.4	16350.0	16353.1	468.0

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

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