PREVIEW / futures_1hour / 2013-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-30.parquet
  size:    50 KB
  rows:    1,555

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-04-30 00:00:00	ES	Futures	1635.66	1635.92	1635.4	1635.4	1141.0
2013-04-30 01:00:00	ES	Futures	1635.66	1636.95	1635.15	1636.95	4675.0
2013-04-30 02:00:00	ES	Futures	1636.69	1637.72	1635.66	1636.95	8138.0
2013-04-30 03:00:00	ES	Futures	1636.69	1638.24	1634.89	1635.15	22026.0
2013-04-30 04:00:00	ES	Futures	1635.15	1635.92	1634.37	1634.37	14577.0
2013-04-30 05:00:00	ES	Futures	1634.37	1636.69	1634.37	1635.66	24630.0
2013-04-30 06:00:00	ES	Futures	1635.4	1635.66	1633.34	1634.37	20218.0
2013-04-30 07:00:00	ES	Futures	1634.37	1635.15	1634.12	1634.37	14930.0
2013-04-30 08:00:00	ES	Futures	1634.37	1636.43	1633.86	1636.18	28631.0
2013-04-30 09:00:00	ES	Futures	1636.18	1637.21	1631.02	1631.54	226002.0
2013-04-30 10:00:00	ES	Futures	1631.54	1635.66	1629.22	1635.15	313707.0
2013-04-30 11:00:00	ES	Futures	1634.89	1639.01	1634.37	1637.98	171257.0
2013-04-30 12:00:00	ES	Futures	1638.24	1640.04	1636.43	1639.78	108553.0
2013-04-30 13:00:00	ES	Futures	1640.04	1640.55	1638.49	1640.3	86599.0
2013-04-30 14:00:00	ES	Futures	1640.04	1640.3	1636.69	1639.78	124719.0
2013-04-30 15:00:00	ES	Futures	1639.78	1640.81	1636.95	1640.55	231397.0
2013-04-30 16:00:00	ES	Futures	1640.55	1642.1	1639.27	1641.84	127483.0
2013-04-30 17:00:00	ES	Futures	1641.84	1642.62	1641.33	1642.36	5239.0
2013-04-30 18:00:00	ES	Futures	1642.1	1642.1	1640.81	1641.07	6873.0
2013-04-30 19:00:00	ES	Futures	1640.81	1642.1	1640.81	1641.33	2664.0
2013-04-30 20:00:00	ES	Futures	1641.07	1641.33	1640.04	1640.55	4603.0
2013-04-30 21:00:00	ES	Futures	1640.3	1640.55	1639.78	1639.78	1420.0
2013-04-30 22:00:00	ES	Futures	1639.78	1640.55	1639.78	1640.55	1385.0
2013-04-30 23:00:00	ES	Futures	1640.3	1640.55	1640.04	1640.04	1321.0
2013-04-30 00:00:00	NQ	Futures	3336.1	3336.68	3336.1	3336.1	58.0
2013-04-30 01:00:00	NQ	Futures	3336.1	3339.6	3336.1	3339.6	460.0
2013-04-30 02:00:00	NQ	Futures	3339.6	3340.47	3337.27	3339.89	648.0
2013-04-30 03:00:00	NQ	Futures	3339.89	3342.52	3336.97	3337.85	2136.0
2013-04-30 04:00:00	NQ	Futures	3337.27	3338.72	3334.93	3335.22	1794.0
2013-04-30 05:00:00	NQ	Futures	3334.93	3339.31	3334.64	3335.81	2188.0
2013-04-30 06:00:00	NQ	Futures	3335.52	3335.81	3331.72	3334.06	1731.0
2013-04-30 07:00:00	NQ	Futures	3333.77	3336.68	3332.89	3334.64	1708.0
2013-04-30 08:00:00	NQ	Futures	3334.64	3338.14	3332.89	3337.85	2791.0
2013-04-30 09:00:00	NQ	Futures	3337.85	3342.81	3330.85	3333.18	33090.0
2013-04-30 10:00:00	NQ	Futures	3333.18	3347.18	3328.81	3344.56	41852.0
2013-04-30 11:00:00	NQ	Futures	3344.27	3353.31	3342.52	3350.68	21408.0
2013-04-30 12:00:00	NQ	Futures	3350.97	3360.6	3347.77	3359.72	14768.0
2013-04-30 13:00:00	NQ	Futures	3359.72	3362.64	3357.1	3360.02	13365.0
2013-04-30 14:00:00	NQ	Futures	3360.02	3361.77	3353.02	3361.77	16559.0
2013-04-30 15:00:00	NQ	Futures	3361.47	3361.77	3354.18	3361.77	26963.0
2013-04-30 16:00:00	NQ	Futures	3361.77	3364.1	3360.31	3364.1	6133.0
2013-04-30 17:00:00	NQ	Futures	3363.22	3364.97	3362.64	3364.97	209.0
2013-04-30 18:00:00	NQ	Futures	3364.68	3364.68	3362.35	3362.93	251.0
2013-04-30 19:00:00	NQ	Futures	3362.93	3364.68	3362.64	3363.81	310.0
2013-04-30 20:00:00	NQ	Futures	3363.81	3364.39	3360.31	3360.89	1063.0
2013-04-30 21:00:00	NQ	Futures	3360.89	3361.47	3360.6	3360.89	160.0
2013-04-30 22:00:00	NQ	Futures	3360.89	3362.35	3360.89	3362.06	125.0
2013-04-30 23:00:00	NQ	Futures	3362.06	3362.35	3360.89	3361.77	171.0
2013-04-30 00:00:00	YM	Futures	14913.5	14917.5	14913.5	14913.5	209.0
2013-04-30 01:00:00	YM	Futures	14913.5	14927.6	14911.4	14925.6	548.0

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

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