PREVIEW / futures_1hour / 2013-01-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	1523.38	1525.18	1522.87	1524.41	4699.0
2013-01-24 01:00:00	ES	Futures	1524.66	1525.95	1523.89	1525.69	3760.0
2013-01-24 02:00:00	ES	Futures	1525.69	1526.2	1523.12	1523.89	9227.0
2013-01-24 03:00:00	ES	Futures	1523.64	1526.72	1522.35	1525.18	37728.0
2013-01-24 04:00:00	ES	Futures	1525.18	1527.49	1525.18	1526.2	20878.0
2013-01-24 05:00:00	ES	Futures	1525.95	1527.49	1525.43	1526.72	15081.0
2013-01-24 06:00:00	ES	Futures	1526.72	1526.97	1525.43	1526.2	16704.0
2013-01-24 07:00:00	ES	Futures	1526.2	1527.74	1525.69	1526.46	26635.0
2013-01-24 08:00:00	ES	Futures	1526.46	1529.03	1525.69	1528.77	66086.0
2013-01-24 09:00:00	ES	Futures	1528.77	1533.39	1526.46	1533.13	260611.0
2013-01-24 10:00:00	ES	Futures	1532.88	1536.21	1532.62	1534.16	283688.0
2013-01-24 11:00:00	ES	Futures	1533.9	1537.24	1533.9	1534.93	193750.0
2013-01-24 12:00:00	ES	Futures	1534.93	1535.7	1528.77	1529.28	212134.0
2013-01-24 13:00:00	ES	Futures	1529.03	1530.31	1525.43	1526.72	154463.0
2013-01-24 14:00:00	ES	Futures	1526.97	1530.05	1525.69	1529.28	131242.0
2013-01-24 15:00:00	ES	Futures	1529.28	1533.13	1528.51	1529.54	237100.0
2013-01-24 16:00:00	ES	Futures	1529.54	1531.85	1527.74	1528.0	92618.0
2013-01-24 17:00:00	ES	Futures	1528.26	1528.51	1527.23	1527.49	2609.0
2013-01-24 18:00:00	ES	Futures	1526.97	1528.51	1526.97	1527.74	5264.0
2013-01-24 19:00:00	ES	Futures	1527.74	1528.26	1525.95	1528.26	10011.0
2013-01-24 20:00:00	ES	Futures	1528.26	1529.03	1526.2	1526.46	7325.0
2013-01-24 21:00:00	ES	Futures	1526.46	1527.49	1525.95	1527.23	3673.0
2013-01-24 22:00:00	ES	Futures	1527.23	1527.23	1525.95	1526.46	3694.0
2013-01-24 23:00:00	ES	Futures	1526.46	1526.97	1525.95	1526.72	3205.0
2013-01-24 00:00:00	NQ	Futures	3161.59	3164.79	3161.3	3163.05	567.0
2013-01-24 01:00:00	NQ	Futures	3163.05	3165.38	3162.47	3165.38	588.0
2013-01-24 02:00:00	NQ	Futures	3165.09	3168.29	3164.21	3165.38	1452.0
2013-01-24 03:00:00	NQ	Futures	3165.38	3174.11	3162.76	3170.03	5852.0
2013-01-24 04:00:00	NQ	Futures	3170.03	3171.49	3168.58	3170.91	2868.0
2013-01-24 05:00:00	NQ	Futures	3170.62	3173.24	3169.45	3170.91	1800.0
2013-01-24 06:00:00	NQ	Futures	3170.91	3172.94	3167.7	3167.7	2616.0
2013-01-24 07:00:00	NQ	Futures	3168.29	3173.24	3167.7	3171.78	2757.0
2013-01-24 08:00:00	NQ	Futures	3172.07	3172.36	3163.05	3166.83	10601.0
2013-01-24 09:00:00	NQ	Futures	3166.83	3185.17	3161.88	3183.13	49479.0
2013-01-24 10:00:00	NQ	Futures	3183.13	3192.45	3180.51	3186.04	42777.0
2013-01-24 11:00:00	NQ	Futures	3186.04	3193.61	3185.46	3189.24	21199.0
2013-01-24 12:00:00	NQ	Futures	3189.24	3189.53	3170.91	3171.78	27562.0
2013-01-24 13:00:00	NQ	Futures	3171.49	3174.11	3159.85	3161.88	30974.0
2013-01-24 14:00:00	NQ	Futures	3162.17	3169.16	3159.26	3167.12	24253.0
2013-01-24 15:00:00	NQ	Futures	3166.83	3175.27	3163.05	3163.92	37132.0
2013-01-24 16:00:00	NQ	Futures	3163.92	3170.91	3158.39	3158.68	13466.0
2013-01-24 17:00:00	NQ	Futures	3158.68	3159.85	3158.1	3158.97	283.0
2013-01-24 18:00:00	NQ	Futures	3160.14	3162.17	3157.23	3160.72	552.0
2013-01-24 19:00:00	NQ	Futures	3160.72	3162.17	3158.39	3161.88	656.0
2013-01-24 20:00:00	NQ	Futures	3161.88	3164.21	3158.68	3158.97	1141.0
2013-01-24 21:00:00	NQ	Futures	3159.26	3161.01	3158.39	3160.14	548.0
2013-01-24 22:00:00	NQ	Futures	3160.14	3160.43	3158.39	3160.14	599.0
2013-01-24 23:00:00	NQ	Futures	3160.72	3160.72	3158.97	3160.43	522.0
2013-01-24 00:00:00	YM	Futures	13790.6	13802.7	13789.6	13797.6	455.0
2013-01-24 01:00:00	YM	Futures	13797.6	13804.7	13793.6	13804.7	327.0

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

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