PREVIEW / futures_1hour / 2013-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-19.parquet
  size:    52 KB
  rows:    1,552

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-19 00:00:00	ES	Futures	1698.05	1699.09	1697.54	1698.05	4450.0
2013-06-19 01:00:00	ES	Futures	1698.05	1701.93	1698.05	1701.93	4476.0
2013-06-19 02:00:00	ES	Futures	1701.93	1704.77	1701.67	1704.0	9727.0
2013-06-19 03:00:00	ES	Futures	1704.0	1704.26	1697.02	1699.86	35137.0
2013-06-19 04:00:00	ES	Futures	1699.6	1704.26	1697.79	1702.71	21480.0
2013-06-19 05:00:00	ES	Futures	1702.71	1705.03	1702.19	1704.26	15028.0
2013-06-19 06:00:00	ES	Futures	1704.51	1704.51	1701.67	1702.19	11443.0
2013-06-19 07:00:00	ES	Futures	1702.19	1702.71	1699.34	1700.38	26993.0
2013-06-19 08:00:00	ES	Futures	1700.64	1702.71	1699.34	1700.64	32653.0
2013-06-19 09:00:00	ES	Futures	1700.9	1702.71	1696.5	1698.31	149758.0
2013-06-19 10:00:00	ES	Futures	1698.31	1702.45	1697.02	1699.86	152207.0
2013-06-19 11:00:00	ES	Futures	1700.12	1701.67	1698.57	1698.83	113769.0
2013-06-19 12:00:00	ES	Futures	1698.83	1700.64	1697.54	1699.09	102452.0
2013-06-19 13:00:00	ES	Futures	1699.09	1702.19	1698.57	1701.93	68672.0
2013-06-19 14:00:00	ES	Futures	1701.93	1703.48	1681.77	1683.58	618449.0
2013-06-19 15:00:00	ES	Futures	1683.32	1691.07	1677.11	1678.15	481590.0
2013-06-19 16:00:00	ES	Futures	1678.15	1682.28	1675.56	1677.11	119178.0
2013-06-19 17:00:00	ES	Futures	1677.11	1677.37	1675.3	1675.56	3343.0
2013-06-19 18:00:00	ES	Futures	1675.82	1678.15	1675.82	1677.63	7182.0
2013-06-19 19:00:00	ES	Futures	1677.63	1677.63	1675.82	1676.34	3127.0
2013-06-19 20:00:00	ES	Futures	1676.6	1677.37	1671.43	1674.79	19279.0
2013-06-19 21:00:00	ES	Futures	1674.79	1675.3	1667.55	1668.84	21709.0
2013-06-19 22:00:00	ES	Futures	1669.1	1672.46	1668.07	1671.43	12434.0
2013-06-19 23:00:00	ES	Futures	1671.43	1672.2	1669.36	1670.13	5480.0
2013-06-19 00:00:00	NQ	Futures	3492.51	3494.26	3491.63	3493.1	367.0
2013-06-19 01:00:00	NQ	Futures	3493.1	3498.94	3492.8	3498.94	303.0
2013-06-19 02:00:00	NQ	Futures	3498.94	3504.49	3498.65	3503.32	933.0
2013-06-19 03:00:00	NQ	Futures	3503.03	3503.32	3490.76	3496.31	4542.0
2013-06-19 04:00:00	NQ	Futures	3495.73	3505.37	3491.93	3502.74	2955.0
2013-06-19 05:00:00	NQ	Futures	3503.03	3505.66	3499.52	3504.49	1953.0
2013-06-19 06:00:00	NQ	Futures	3504.2	3505.08	3500.4	3500.69	1786.0
2013-06-19 07:00:00	NQ	Futures	3500.69	3501.86	3494.56	3497.19	4791.0
2013-06-19 08:00:00	NQ	Futures	3497.19	3501.57	3495.73	3498.06	3803.0
2013-06-19 09:00:00	NQ	Futures	3498.06	3501.86	3489.88	3493.68	20882.0
2013-06-19 10:00:00	NQ	Futures	3493.39	3501.28	3491.05	3495.73	22534.0
2013-06-19 11:00:00	NQ	Futures	3495.73	3499.52	3491.05	3491.34	16725.0
2013-06-19 12:00:00	NQ	Futures	3491.34	3493.68	3488.71	3489.88	14141.0
2013-06-19 13:00:00	NQ	Futures	3489.88	3492.51	3488.71	3491.34	7279.0
2013-06-19 14:00:00	NQ	Futures	3491.34	3498.65	3459.78	3462.7	90646.0
2013-06-19 15:00:00	NQ	Futures	3462.99	3479.07	3453.06	3455.4	56672.0
2013-06-19 16:00:00	NQ	Futures	3455.69	3462.99	3451.89	3453.94	8076.0
2013-06-19 17:00:00	NQ	Futures	3453.94	3454.23	3451.6	3452.18	241.0
2013-06-19 18:00:00	NQ	Futures	3453.94	3455.98	3452.47	3455.1	378.0
2013-06-19 19:00:00	NQ	Futures	3455.1	3455.1	3452.18	3452.47	313.0
2013-06-19 20:00:00	NQ	Futures	3452.77	3454.81	3443.42	3447.8	2269.0
2013-06-19 21:00:00	NQ	Futures	3448.09	3448.68	3435.23	3436.69	2852.0
2013-06-19 22:00:00	NQ	Futures	3436.4	3444.29	3436.4	3441.95	1285.0
2013-06-19 23:00:00	NQ	Futures	3441.95	3443.42	3438.45	3440.2	651.0
2013-06-19 00:00:00	YM	Futures	15463.7	15472.9	15460.7	15465.8	477.0
2013-06-19 01:00:00	YM	Futures	15466.8	15493.2	15466.8	15493.2	572.0

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

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