PREVIEW / futures_1hour / 2013-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-18.parquet
  size:    41 KB
  rows:    1,248

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-10-18 00:00:00	ES	Futures	1784.83	1786.63	1784.57	1786.38	2523.0
2013-10-18 01:00:00	ES	Futures	1786.38	1788.18	1786.12	1786.89	4891.0
2013-10-18 02:00:00	ES	Futures	1787.15	1788.44	1786.12	1786.38	7738.0
2013-10-18 03:00:00	ES	Futures	1786.38	1787.15	1784.83	1785.34	18539.0
2013-10-18 04:00:00	ES	Futures	1785.6	1786.38	1784.57	1784.57	13593.0
2013-10-18 05:00:00	ES	Futures	1784.83	1785.86	1783.8	1785.34	14616.0
2013-10-18 06:00:00	ES	Futures	1785.34	1786.12	1783.8	1784.05	19160.0
2013-10-18 07:00:00	ES	Futures	1784.05	1787.41	1784.05	1787.41	21024.0
2013-10-18 08:00:00	ES	Futures	1787.15	1788.7	1786.63	1787.67	37799.0
2013-10-18 09:00:00	ES	Futures	1787.92	1791.02	1785.34	1790.5	280435.0
2013-10-18 10:00:00	ES	Futures	1790.25	1791.54	1785.34	1787.67	255164.0
2013-10-18 11:00:00	ES	Futures	1787.92	1790.76	1786.89	1788.7	126922.0
2013-10-18 12:00:00	ES	Futures	1788.7	1791.54	1787.67	1790.5	113020.0
2013-10-18 13:00:00	ES	Futures	1790.5	1794.89	1790.25	1794.89	117191.0
2013-10-18 14:00:00	ES	Futures	1794.89	1795.66	1792.82	1794.11	149106.0
2013-10-18 15:00:00	ES	Futures	1794.11	1794.63	1791.79	1794.11	204394.0
2013-10-18 16:00:00	ES	Futures	1794.11	1794.37	1791.54	1792.82	96531.0
2013-10-18 17:00:00	ES	Futures	1793.08	1793.6	1791.79	1792.31	2713.0
2013-10-18 00:00:00	NQ	Futures	3847.65	3853.75	3847.36	3852.88	587.0
2013-10-18 01:00:00	NQ	Futures	3853.17	3856.94	3852.59	3856.07	1024.0
2013-10-18 02:00:00	NQ	Futures	3856.07	3856.94	3851.14	3851.43	1712.0
2013-10-18 03:00:00	NQ	Futures	3851.43	3853.46	3846.49	3848.52	2868.0
2013-10-18 04:00:00	NQ	Futures	3848.81	3852.59	3847.36	3849.97	2019.0
2013-10-18 05:00:00	NQ	Futures	3850.26	3852.88	3847.94	3851.43	1548.0
2013-10-18 06:00:00	NQ	Futures	3851.72	3853.17	3848.23	3849.1	1752.0
2013-10-18 07:00:00	NQ	Futures	3849.1	3854.91	3849.1	3854.62	2820.0
2013-10-18 08:00:00	NQ	Futures	3854.62	3858.4	3852.01	3854.33	5011.0
2013-10-18 09:00:00	NQ	Futures	3854.33	3868.56	3849.68	3866.82	46432.0
2013-10-18 10:00:00	NQ	Futures	3866.53	3873.79	3861.88	3867.69	45903.0
2013-10-18 11:00:00	NQ	Futures	3867.4	3871.47	3863.62	3865.37	19071.0
2013-10-18 12:00:00	NQ	Futures	3865.37	3875.82	3863.91	3873.79	16121.0
2013-10-18 13:00:00	NQ	Futures	3874.08	3885.99	3873.79	3884.53	20838.0
2013-10-18 14:00:00	NQ	Futures	3884.53	3889.47	3879.31	3886.86	20795.0
2013-10-18 15:00:00	NQ	Futures	3886.86	3888.31	3879.6	3887.73	33347.0
2013-10-18 16:00:00	NQ	Futures	3887.73	3888.02	3883.66	3886.86	9186.0
2013-10-18 17:00:00	NQ	Futures	3886.86	3888.02	3885.7	3885.7	258.0
2013-10-18 00:00:00	YM	Futures	15645.5	15660.8	15643.5	15657.8	495.0
2013-10-18 01:00:00	YM	Futures	15656.7	15663.9	15651.6	15655.7	967.0
2013-10-18 02:00:00	YM	Futures	15655.7	15667.0	15650.6	15652.7	843.0
2013-10-18 03:00:00	YM	Futures	15652.7	15657.8	15635.3	15639.4	1946.0
2013-10-18 04:00:00	YM	Futures	15639.4	15653.7	15634.3	15637.3	1278.0
2013-10-18 05:00:00	YM	Futures	15639.4	15649.6	15630.2	15643.5	1009.0
2013-10-18 06:00:00	YM	Futures	15643.5	15647.5	15631.2	15635.3	1262.0
2013-10-18 07:00:00	YM	Futures	15635.3	15649.6	15633.3	15649.6	1647.0
2013-10-18 08:00:00	YM	Futures	15648.6	15661.8	15646.5	15653.7	2354.0
2013-10-18 09:00:00	YM	Futures	15653.7	15667.0	15584.2	15639.4	27749.0
2013-10-18 10:00:00	YM	Futures	15639.4	15649.6	15589.3	15614.9	21021.0
2013-10-18 11:00:00	YM	Futures	15615.9	15641.4	15606.7	15611.8	11787.0
2013-10-18 12:00:00	YM	Futures	15611.8	15646.5	15602.6	15637.3	10318.0
2013-10-18 13:00:00	YM	Futures	15638.4	15664.9	15637.3	15662.9	9468.0

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

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