PREVIEW / futures_1hour / 2013-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-15.parquet
  size:    51 KB
  rows:    1,579

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-01-15 00:00:00	ES	Futures	1500.54	1500.8	1499.77	1500.29	2807.0
2013-01-15 01:00:00	ES	Futures	1500.29	1500.8	1499.52	1500.03	3387.0
2013-01-15 02:00:00	ES	Futures	1499.77	1500.54	1498.75	1499.26	7509.0
2013-01-15 03:00:00	ES	Futures	1499.52	1501.57	1499.01	1501.31	22829.0
2013-01-15 04:00:00	ES	Futures	1501.06	1502.6	1500.03	1502.34	14564.0
2013-01-15 05:00:00	ES	Futures	1502.34	1502.6	1500.03	1501.06	11250.0
2013-01-15 06:00:00	ES	Futures	1501.06	1501.31	1498.75	1499.52	24242.0
2013-01-15 07:00:00	ES	Futures	1499.26	1499.52	1495.67	1496.95	58879.0
2013-01-15 08:00:00	ES	Futures	1496.95	1498.24	1494.9	1497.21	71870.0
2013-01-15 09:00:00	ES	Futures	1496.95	1499.77	1496.7	1499.26	210766.0
2013-01-15 10:00:00	ES	Futures	1499.26	1501.57	1498.24	1500.8	189018.0
2013-01-15 11:00:00	ES	Futures	1501.06	1502.34	1499.52	1501.06	141741.0
2013-01-15 12:00:00	ES	Futures	1501.06	1504.14	1501.06	1502.85	102501.0
2013-01-15 13:00:00	ES	Futures	1502.85	1504.14	1500.54	1501.06	92972.0
2013-01-15 14:00:00	ES	Futures	1501.31	1504.39	1500.8	1504.14	87615.0
2013-01-15 15:00:00	ES	Futures	1504.39	1506.96	1504.14	1504.91	180691.0
2013-01-15 16:00:00	ES	Futures	1505.16	1505.68	1503.62	1505.16	69310.0
2013-01-15 17:00:00	ES	Futures	1505.16	1505.93	1504.91	1505.93	2003.0
2013-01-15 18:00:00	ES	Futures	1505.68	1506.19	1504.91	1505.68	4042.0
2013-01-15 19:00:00	ES	Futures	1505.93	1505.93	1505.16	1505.68	4006.0
2013-01-15 20:00:00	ES	Futures	1505.68	1505.93	1503.62	1504.39	11445.0
2013-01-15 21:00:00	ES	Futures	1504.39	1505.16	1504.14	1504.65	3804.0
2013-01-15 22:00:00	ES	Futures	1504.39	1504.65	1503.11	1503.88	4631.0
2013-01-15 23:00:00	ES	Futures	1503.88	1504.91	1503.11	1503.88	4064.0
2013-01-15 00:00:00	NQ	Futures	3173.82	3174.4	3172.36	3173.53	237.0
2013-01-15 01:00:00	NQ	Futures	3173.24	3174.4	3171.2	3171.49	249.0
2013-01-15 02:00:00	NQ	Futures	3171.49	3173.82	3169.16	3171.2	603.0
2013-01-15 03:00:00	NQ	Futures	3170.91	3175.27	3169.74	3174.98	3042.0
2013-01-15 04:00:00	NQ	Futures	3174.69	3178.47	3172.07	3178.47	1588.0
2013-01-15 05:00:00	NQ	Futures	3178.18	3178.77	3172.94	3174.11	1113.0
2013-01-15 06:00:00	NQ	Futures	3174.4	3174.4	3170.62	3171.49	2270.0
2013-01-15 07:00:00	NQ	Futures	3171.49	3171.49	3164.5	3167.7	3811.0
2013-01-15 08:00:00	NQ	Futures	3167.7	3169.74	3164.21	3165.67	7801.0
2013-01-15 09:00:00	NQ	Futures	3165.38	3168.58	3149.66	3154.9	45521.0
2013-01-15 10:00:00	NQ	Futures	3154.32	3158.39	3151.4	3156.94	31500.0
2013-01-15 11:00:00	NQ	Futures	3157.23	3161.01	3154.61	3155.48	21568.0
2013-01-15 12:00:00	NQ	Futures	3155.77	3168.29	3155.48	3163.34	18438.0
2013-01-15 13:00:00	NQ	Futures	3163.34	3168.0	3156.64	3158.39	18894.0
2013-01-15 14:00:00	NQ	Futures	3158.39	3162.47	3153.44	3162.47	16270.0
2013-01-15 15:00:00	NQ	Futures	3162.47	3166.54	3160.72	3163.63	29948.0
2013-01-15 16:00:00	NQ	Futures	3163.63	3165.09	3161.3	3164.21	4699.0
2013-01-15 17:00:00	NQ	Futures	3164.21	3166.54	3164.21	3165.96	296.0
2013-01-15 18:00:00	NQ	Futures	3167.7	3168.58	3165.38	3168.0	674.0
2013-01-15 19:00:00	NQ	Futures	3167.7	3168.0	3166.25	3168.0	391.0
2013-01-15 20:00:00	NQ	Futures	3167.7	3168.0	3163.92	3165.09	788.0
2013-01-15 21:00:00	NQ	Futures	3165.09	3167.12	3165.09	3166.54	350.0
2013-01-15 22:00:00	NQ	Futures	3166.54	3166.54	3163.34	3164.79	633.0
2013-01-15 23:00:00	NQ	Futures	3164.5	3166.83	3163.63	3165.96	947.0
2013-01-15 00:00:00	YM	Futures	13500.9	13501.9	13495.8	13497.8	224.0
2013-01-15 01:00:00	YM	Futures	13494.8	13501.9	13491.8	13493.8	398.0

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

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