PREVIEW / futures_1hour / 2013-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-03.parquet
  size:    51 KB
  rows:    1,500

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-06-03 00:00:00	ES	Futures	1682.54	1682.54	1680.74	1681.0	3419.0
2013-06-03 01:00:00	ES	Futures	1681.0	1682.8	1680.74	1682.8	5295.0
2013-06-03 02:00:00	ES	Futures	1682.54	1682.8	1679.71	1681.77	15579.0
2013-06-03 03:00:00	ES	Futures	1681.77	1683.06	1677.39	1680.74	48601.0
2013-06-03 04:00:00	ES	Futures	1680.74	1680.74	1676.36	1678.93	27880.0
2013-06-03 05:00:00	ES	Futures	1678.93	1683.31	1678.16	1682.03	22350.0
2013-06-03 06:00:00	ES	Futures	1682.03	1686.15	1681.0	1686.15	31462.0
2013-06-03 07:00:00	ES	Futures	1686.15	1688.21	1685.12	1685.37	53223.0
2013-06-03 08:00:00	ES	Futures	1685.37	1686.15	1681.77	1683.57	49502.0
2013-06-03 09:00:00	ES	Futures	1683.31	1684.09	1676.1	1677.13	309854.0
2013-06-03 10:00:00	ES	Futures	1677.13	1685.89	1672.5	1677.65	593900.0
2013-06-03 11:00:00	ES	Futures	1677.39	1678.16	1669.92	1674.81	335456.0
2013-06-03 12:00:00	ES	Futures	1674.81	1677.65	1672.24	1676.36	180188.0
2013-06-03 13:00:00	ES	Futures	1676.36	1678.93	1674.3	1677.65	146581.0
2013-06-03 14:00:00	ES	Futures	1677.65	1683.31	1676.36	1681.25	196301.0
2013-06-03 15:00:00	ES	Futures	1681.25	1688.72	1679.97	1687.95	302271.0
2013-06-03 16:00:00	ES	Futures	1687.95	1687.95	1685.12	1686.15	93908.0
2013-06-03 17:00:00	ES	Futures	1686.15	1686.15	1684.86	1685.37	1793.0
2013-06-03 18:00:00	ES	Futures	1685.37	1685.89	1679.71	1681.77	15009.0
2013-06-03 19:00:00	ES	Futures	1681.77	1684.6	1681.77	1684.09	3417.0
2013-06-03 20:00:00	ES	Futures	1683.83	1684.86	1682.03	1682.8	6075.0
2013-06-03 21:00:00	ES	Futures	1682.8	1684.09	1681.77	1683.83	6524.0
2013-06-03 22:00:00	ES	Futures	1683.83	1684.09	1681.77	1682.03	4733.0
2013-06-03 23:00:00	ES	Futures	1682.03	1683.83	1681.51	1683.83	6553.0
2013-06-03 00:00:00	NQ	Futures	3484.85	3485.14	3482.52	3483.68	346.0
2013-06-03 01:00:00	NQ	Futures	3483.68	3486.02	3482.52	3485.72	494.0
2013-06-03 02:00:00	NQ	Futures	3485.72	3485.72	3481.06	3485.43	1398.0
2013-06-03 03:00:00	NQ	Futures	3485.14	3487.47	3473.77	3478.43	6775.0
2013-06-03 04:00:00	NQ	Futures	3478.43	3478.43	3468.52	3473.77	4129.0
2013-06-03 05:00:00	NQ	Futures	3473.77	3484.56	3472.31	3482.52	3645.0
2013-06-03 06:00:00	NQ	Futures	3482.81	3490.1	3479.31	3489.81	3440.0
2013-06-03 07:00:00	NQ	Futures	3489.81	3494.18	3488.64	3490.68	5229.0
2013-06-03 08:00:00	NQ	Futures	3490.39	3492.43	3481.93	3485.43	5745.0
2013-06-03 09:00:00	NQ	Futures	3485.14	3485.72	3464.43	3472.6	46523.0
2013-06-03 10:00:00	NQ	Futures	3472.89	3483.68	3458.02	3462.1	72056.0
2013-06-03 11:00:00	NQ	Futures	3462.39	3464.14	3441.68	3451.02	53239.0
2013-06-03 12:00:00	NQ	Futures	3451.02	3457.72	3443.72	3456.56	26243.0
2013-06-03 13:00:00	NQ	Futures	3456.85	3461.22	3453.06	3459.18	20195.0
2013-06-03 14:00:00	NQ	Futures	3458.89	3470.85	3457.14	3466.77	26734.0
2013-06-03 15:00:00	NQ	Futures	3466.77	3488.06	3466.77	3486.89	31321.0
2013-06-03 16:00:00	NQ	Futures	3486.6	3488.06	3483.39	3485.43	6285.0
2013-06-03 17:00:00	NQ	Futures	3485.43	3485.43	3484.27	3484.27	159.0
2013-06-03 18:00:00	NQ	Futures	3484.27	3485.14	3474.64	3477.85	1533.0
2013-06-03 19:00:00	NQ	Futures	3477.56	3483.97	3477.56	3483.39	703.0
2013-06-03 20:00:00	NQ	Futures	3483.1	3485.14	3478.72	3480.18	1425.0
2013-06-03 21:00:00	NQ	Futures	3479.89	3482.81	3478.43	3482.22	1103.0
2013-06-03 22:00:00	NQ	Futures	3481.93	3482.22	3479.02	3479.31	929.0
2013-06-03 23:00:00	NQ	Futures	3479.31	3483.1	3477.56	3481.64	768.0
2013-06-03 00:00:00	YM	Futures	15313.8	15313.8	15300.7	15303.7	381.0
2013-06-03 01:00:00	YM	Futures	15303.7	15313.8	15299.6	15312.8	491.0

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

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