PREVIEW / futures_1hour / 2013-04-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-11.parquet
  size:    49 KB
  rows:    1,527

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-11 00:00:00	ES	Futures	1629.74	1630.25	1628.96	1630.25	2526.0
2013-04-11 01:00:00	ES	Futures	1630.51	1631.02	1629.99	1631.02	3625.0
2013-04-11 02:00:00	ES	Futures	1630.77	1631.28	1629.74	1630.51	8793.0
2013-04-11 03:00:00	ES	Futures	1630.51	1631.28	1629.74	1629.99	25432.0
2013-04-11 04:00:00	ES	Futures	1630.25	1633.6	1629.99	1633.34	29886.0
2013-04-11 05:00:00	ES	Futures	1633.08	1633.86	1631.8	1631.8	17729.0
2013-04-11 06:00:00	ES	Futures	1631.8	1632.57	1631.02	1631.54	14401.0
2013-04-11 07:00:00	ES	Futures	1631.54	1632.57	1630.77	1630.77	16075.0
2013-04-11 08:00:00	ES	Futures	1631.02	1632.83	1629.99	1631.8	55348.0
2013-04-11 09:00:00	ES	Futures	1631.8	1633.6	1628.96	1631.8	200263.0
2013-04-11 10:00:00	ES	Futures	1632.05	1639.01	1631.8	1638.75	327162.0
2013-04-11 11:00:00	ES	Futures	1638.75	1641.33	1636.43	1637.98	289632.0
2013-04-11 12:00:00	ES	Futures	1637.98	1639.01	1635.66	1639.01	131274.0
2013-04-11 13:00:00	ES	Futures	1639.01	1640.55	1636.43	1636.69	129701.0
2013-04-11 14:00:00	ES	Futures	1636.43	1638.75	1634.63	1638.49	141506.0
2013-04-11 15:00:00	ES	Futures	1638.49	1639.52	1634.12	1636.18	224218.0
2013-04-11 16:00:00	ES	Futures	1635.92	1636.95	1635.4	1636.18	73184.0
2013-04-11 17:00:00	ES	Futures	1636.43	1636.95	1636.18	1636.69	1842.0
2013-04-11 18:00:00	ES	Futures	1636.43	1637.72	1635.66	1637.21	3784.0
2013-04-11 19:00:00	ES	Futures	1637.21	1637.98	1635.92	1636.18	3576.0
2013-04-11 20:00:00	ES	Futures	1635.92	1636.43	1634.63	1635.92	6484.0
2013-04-11 21:00:00	ES	Futures	1635.92	1636.43	1634.37	1634.89	6094.0
2013-04-11 22:00:00	ES	Futures	1635.15	1635.15	1631.54	1632.05	12574.0
2013-04-11 23:00:00	ES	Futures	1632.31	1633.86	1631.8	1633.08	3963.0
2013-04-11 00:00:00	NQ	Futures	3322.39	3324.14	3322.1	3323.85	325.0
2013-04-11 01:00:00	NQ	Futures	3324.14	3325.6	3323.85	3325.6	336.0
2013-04-11 02:00:00	NQ	Futures	3325.31	3326.18	3323.56	3324.14	1238.0
2013-04-11 03:00:00	NQ	Futures	3324.14	3325.31	3321.81	3322.97	2474.0
2013-04-11 04:00:00	NQ	Futures	3323.27	3329.39	3322.68	3328.81	2770.0
2013-04-11 05:00:00	NQ	Futures	3329.1	3329.97	3326.47	3326.47	1684.0
2013-04-11 06:00:00	NQ	Futures	3326.77	3327.06	3323.27	3324.72	1668.0
2013-04-11 07:00:00	NQ	Futures	3325.02	3326.18	3320.64	3321.22	2721.0
2013-04-11 08:00:00	NQ	Futures	3320.93	3324.14	3318.89	3321.81	6600.0
2013-04-11 09:00:00	NQ	Futures	3321.81	3325.02	3317.14	3319.18	33200.0
2013-04-11 10:00:00	NQ	Futures	3319.18	3330.27	3318.6	3330.27	35241.0
2013-04-11 11:00:00	NQ	Futures	3330.27	3334.93	3323.27	3326.47	26492.0
2013-04-11 12:00:00	NQ	Futures	3326.47	3328.81	3322.97	3328.22	12895.0
2013-04-11 13:00:00	NQ	Futures	3328.52	3332.02	3324.43	3324.72	16338.0
2013-04-11 14:00:00	NQ	Futures	3324.72	3330.27	3320.06	3329.97	17255.0
2013-04-11 15:00:00	NQ	Futures	3329.97	3333.47	3321.81	3327.35	27743.0
2013-04-11 16:00:00	NQ	Futures	3327.06	3331.43	3326.18	3330.27	6039.0
2013-04-11 17:00:00	NQ	Futures	3330.27	3331.43	3330.27	3330.56	255.0
2013-04-11 18:00:00	NQ	Futures	3329.39	3332.02	3329.1	3331.14	260.0
2013-04-11 19:00:00	NQ	Futures	3331.14	3332.31	3329.1	3329.1	320.0
2013-04-11 20:00:00	NQ	Futures	3329.39	3330.27	3327.06	3329.1	768.0
2013-04-11 21:00:00	NQ	Futures	3328.81	3330.56	3327.35	3327.93	868.0
2013-04-11 22:00:00	NQ	Futures	3327.93	3328.22	3321.52	3321.81	1389.0
2013-04-11 23:00:00	NQ	Futures	3321.81	3325.02	3321.81	3323.56	523.0
2013-04-11 00:00:00	YM	Futures	14893.2	14899.3	14890.2	14898.3	470.0
2013-04-11 01:00:00	YM	Futures	14898.3	14903.4	14897.3	14902.3	474.0

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

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