PREVIEW / futures_1hour / 2014-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-30.parquet
  size:    52 KB
  rows:    1,591

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-30 00:00:00	ES	Futures	1836.18	1836.18	1834.11	1835.14	4775.0
2014-01-30 01:00:00	ES	Futures	1835.14	1836.7	1834.37	1836.44	4122.0
2014-01-30 02:00:00	ES	Futures	1836.44	1838.51	1836.18	1836.96	9151.0
2014-01-30 03:00:00	ES	Futures	1836.96	1837.73	1833.59	1833.85	32322.0
2014-01-30 04:00:00	ES	Futures	1833.85	1837.21	1832.04	1834.63	32658.0
2014-01-30 05:00:00	ES	Futures	1834.89	1837.99	1834.63	1836.7	16688.0
2014-01-30 06:00:00	ES	Futures	1836.96	1840.58	1835.4	1838.51	32212.0
2014-01-30 07:00:00	ES	Futures	1838.51	1839.02	1836.44	1838.25	26177.0
2014-01-30 08:00:00	ES	Futures	1838.25	1842.65	1834.63	1842.39	72063.0
2014-01-30 09:00:00	ES	Futures	1842.39	1847.3	1841.87	1842.65	288923.0
2014-01-30 10:00:00	ES	Futures	1842.39	1846.78	1839.54	1844.97	281080.0
2014-01-30 11:00:00	ES	Futures	1844.97	1854.03	1843.42	1852.73	255913.0
2014-01-30 12:00:00	ES	Futures	1852.99	1855.84	1851.44	1854.54	127915.0
2014-01-30 13:00:00	ES	Futures	1854.54	1854.8	1850.92	1851.44	101400.0
2014-01-30 14:00:00	ES	Futures	1851.44	1852.99	1848.34	1851.44	114508.0
2014-01-30 15:00:00	ES	Futures	1851.18	1854.8	1849.63	1850.66	215959.0
2014-01-30 16:00:00	ES	Futures	1850.66	1850.92	1842.39	1846.01	142211.0
2014-01-30 17:00:00	ES	Futures	1846.01	1847.04	1845.23	1845.49	3469.0
2014-01-30 18:00:00	ES	Futures	1845.23	1846.27	1843.94	1845.23	7990.0
2014-01-30 19:00:00	ES	Futures	1845.49	1846.27	1843.68	1846.01	4777.0
2014-01-30 20:00:00	ES	Futures	1846.27	1846.53	1844.72	1845.49	2299.0
2014-01-30 21:00:00	ES	Futures	1845.49	1845.75	1844.46	1845.75	1765.0
2014-01-30 22:00:00	ES	Futures	1845.75	1846.01	1843.16	1843.42	4664.0
2014-01-30 23:00:00	ES	Futures	1843.42	1843.42	1838.51	1838.77	15718.0
2014-01-30 00:00:00	NQ	Futures	4051.85	4052.15	4047.2	4049.53	695.0
2014-01-30 01:00:00	NQ	Futures	4049.53	4052.73	4048.08	4052.15	498.0
2014-01-30 02:00:00	NQ	Futures	4052.15	4057.96	4050.98	4053.6	1385.0
2014-01-30 03:00:00	NQ	Futures	4053.89	4054.47	4041.97	4042.55	5381.0
2014-01-30 04:00:00	NQ	Futures	4042.55	4049.53	4038.48	4044.3	5182.0
2014-01-30 05:00:00	NQ	Futures	4044.01	4053.89	4044.01	4050.69	2803.0
2014-01-30 06:00:00	NQ	Futures	4050.98	4059.12	4048.37	4055.05	4757.0
2014-01-30 07:00:00	NQ	Futures	4055.05	4060.28	4053.02	4057.96	5817.0
2014-01-30 08:00:00	NQ	Futures	4057.96	4066.97	4052.15	4066.39	10676.0
2014-01-30 09:00:00	NQ	Futures	4066.39	4085.86	4065.81	4074.82	58188.0
2014-01-30 10:00:00	NQ	Futures	4074.24	4090.81	4069.88	4086.45	45314.0
2014-01-30 11:00:00	NQ	Futures	4086.74	4109.7	4081.21	4106.21	40985.0
2014-01-30 12:00:00	NQ	Futures	4106.5	4112.9	4103.31	4109.99	19285.0
2014-01-30 13:00:00	NQ	Futures	4109.99	4110.57	4102.14	4103.89	14954.0
2014-01-30 14:00:00	NQ	Futures	4104.18	4109.41	4096.62	4106.79	20909.0
2014-01-30 15:00:00	NQ	Futures	4106.79	4112.9	4097.2	4097.78	40831.0
2014-01-30 16:00:00	NQ	Futures	4097.78	4101.27	4064.94	4081.8	24284.0
2014-01-30 17:00:00	NQ	Futures	4081.8	4091.39	4079.18	4086.45	1509.0
2014-01-30 18:00:00	NQ	Futures	4092.84	4094.59	4089.35	4091.1	1680.0
2014-01-30 19:00:00	NQ	Futures	4090.81	4093.13	4088.19	4092.55	693.0
2014-01-30 20:00:00	NQ	Futures	4093.13	4094.29	4090.52	4092.84	335.0
2014-01-30 21:00:00	NQ	Futures	4092.55	4092.84	4089.64	4092.26	521.0
2014-01-30 22:00:00	NQ	Futures	4091.97	4092.55	4086.45	4088.48	697.0
2014-01-30 23:00:00	NQ	Futures	4088.19	4088.19	4079.18	4080.34	1783.0
2014-01-30 00:00:00	YM	Futures	16119.3	16119.3	16104.0	16111.1	473.0
2014-01-30 01:00:00	YM	Futures	16111.1	16123.4	16106.0	16121.4	662.0

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

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