PREVIEW / futures_1hour / 2013-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-19.parquet
  size:    41 KB
  rows:    1,223

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-07-19 00:00:00	ES	Futures	1733.72	1733.98	1733.21	1733.72	1568.0
2013-07-19 01:00:00	ES	Futures	1733.72	1734.24	1732.43	1733.98	3424.0
2013-07-19 02:00:00	ES	Futures	1733.98	1735.28	1733.72	1735.28	5827.0
2013-07-19 03:00:00	ES	Futures	1735.02	1736.57	1734.24	1735.28	19865.0
2013-07-19 04:00:00	ES	Futures	1735.02	1736.05	1734.24	1734.76	8764.0
2013-07-19 05:00:00	ES	Futures	1734.76	1736.57	1733.98	1736.31	13093.0
2013-07-19 06:00:00	ES	Futures	1736.05	1736.83	1735.53	1736.05	10636.0
2013-07-19 07:00:00	ES	Futures	1736.05	1739.41	1735.79	1737.86	31593.0
2013-07-19 08:00:00	ES	Futures	1738.12	1738.38	1735.53	1736.05	38092.0
2013-07-19 09:00:00	ES	Futures	1736.31	1739.41	1733.98	1737.34	237477.0
2013-07-19 10:00:00	ES	Futures	1737.34	1740.96	1736.31	1740.19	163060.0
2013-07-19 11:00:00	ES	Futures	1739.93	1742.0	1738.64	1739.67	138984.0
2013-07-19 12:00:00	ES	Futures	1739.93	1740.96	1738.89	1740.19	60439.0
2013-07-19 13:00:00	ES	Futures	1740.19	1741.48	1739.15	1741.22	56740.0
2013-07-19 14:00:00	ES	Futures	1740.96	1743.55	1740.7	1742.0	83197.0
2013-07-19 15:00:00	ES	Futures	1742.26	1744.84	1741.74	1744.84	144581.0
2013-07-19 16:00:00	ES	Futures	1744.84	1747.94	1744.58	1747.17	83696.0
2013-07-19 17:00:00	ES	Futures	1747.17	1747.68	1747.17	1747.17	2740.0
2013-07-19 00:00:00	NQ	Futures	3560.89	3561.77	3559.43	3560.02	381.0
2013-07-19 01:00:00	NQ	Futures	3560.02	3560.89	3556.51	3558.26	928.0
2013-07-19 02:00:00	NQ	Futures	3558.26	3560.89	3557.97	3559.14	1443.0
2013-07-19 03:00:00	NQ	Futures	3559.14	3560.02	3555.05	3555.63	5676.0
2013-07-19 04:00:00	NQ	Futures	3555.63	3559.43	3554.17	3554.76	2695.0
2013-07-19 05:00:00	NQ	Futures	3554.46	3555.93	3552.13	3555.05	3739.0
2013-07-19 06:00:00	NQ	Futures	3555.05	3556.22	3553.59	3555.34	1975.0
2013-07-19 07:00:00	NQ	Futures	3555.34	3562.36	3555.05	3560.89	3923.0
2013-07-19 08:00:00	NQ	Futures	3560.6	3561.77	3557.68	3559.14	5039.0
2013-07-19 09:00:00	NQ	Futures	3559.14	3560.02	3547.74	3551.54	53852.0
2013-07-19 10:00:00	NQ	Futures	3551.54	3555.63	3545.41	3551.25	26056.0
2013-07-19 11:00:00	NQ	Futures	3551.25	3556.22	3543.65	3545.99	22821.0
2013-07-19 12:00:00	NQ	Futures	3546.28	3549.79	3543.36	3546.87	10823.0
2013-07-19 13:00:00	NQ	Futures	3546.87	3548.62	3542.48	3547.74	9430.0
2013-07-19 14:00:00	NQ	Futures	3547.74	3553.3	3545.99	3546.87	12371.0
2013-07-19 15:00:00	NQ	Futures	3547.16	3553.59	3543.65	3553.59	29895.0
2013-07-19 16:00:00	NQ	Futures	3553.59	3558.85	3552.71	3557.68	5756.0
2013-07-19 17:00:00	NQ	Futures	3557.97	3559.73	3557.68	3559.43	132.0
2013-07-19 00:00:00	YM	Futures	15682.1	15686.2	15678.1	15680.1	328.0
2013-07-19 01:00:00	YM	Futures	15680.1	15700.4	15670.9	15688.2	1366.0
2013-07-19 02:00:00	YM	Futures	15690.2	15701.4	15689.2	15700.4	816.0
2013-07-19 03:00:00	YM	Futures	15699.4	15704.5	15688.2	15695.3	1972.0
2013-07-19 04:00:00	YM	Futures	15695.3	15699.4	15688.2	15690.2	736.0
2013-07-19 05:00:00	YM	Futures	15690.2	15703.4	15684.2	15701.4	1340.0
2013-07-19 06:00:00	YM	Futures	15699.4	15705.5	15696.3	15699.4	940.0
2013-07-19 07:00:00	YM	Futures	15698.4	15720.7	15695.3	15711.6	2619.0
2013-07-19 08:00:00	YM	Futures	15709.5	15712.6	15692.3	15695.3	2445.0
2013-07-19 09:00:00	YM	Futures	15694.3	15712.6	15677.0	15689.2	18733.0
2013-07-19 10:00:00	YM	Futures	15689.2	15718.7	15686.2	15710.6	15241.0
2013-07-19 11:00:00	YM	Futures	15710.6	15718.7	15691.3	15700.4	9242.0
2013-07-19 12:00:00	YM	Futures	15700.4	15707.5	15694.3	15705.5	4124.0
2013-07-19 13:00:00	YM	Futures	15705.5	15713.6	15696.3	15710.6	4632.0

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

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