PREVIEW / futures_1hour / 2013-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-17.parquet
  size:    52 KB
  rows:    1,566

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-17 00:00:00	ES	Futures	1500.8	1502.34	1499.77	1502.08	7171.0
2013-01-17 01:00:00	ES	Futures	1502.08	1503.11	1502.08	1502.85	4012.0
2013-01-17 02:00:00	ES	Futures	1502.85	1503.88	1501.31	1502.34	7933.0
2013-01-17 03:00:00	ES	Futures	1502.08	1504.65	1502.08	1504.65	19862.0
2013-01-17 04:00:00	ES	Futures	1504.65	1505.68	1503.62	1504.14	18520.0
2013-01-17 05:00:00	ES	Futures	1504.14	1505.42	1503.62	1505.16	17165.0
2013-01-17 06:00:00	ES	Futures	1504.91	1506.7	1504.14	1506.45	20019.0
2013-01-17 07:00:00	ES	Futures	1506.45	1507.73	1505.93	1506.7	27343.0
2013-01-17 08:00:00	ES	Futures	1506.96	1514.91	1505.68	1512.6	143311.0
2013-01-17 09:00:00	ES	Futures	1512.6	1513.37	1509.27	1511.58	198198.0
2013-01-17 10:00:00	ES	Futures	1511.58	1513.63	1509.01	1511.58	287509.0
2013-01-17 11:00:00	ES	Futures	1511.32	1514.91	1511.32	1513.37	139869.0
2013-01-17 12:00:00	ES	Futures	1513.12	1516.71	1513.12	1515.43	189073.0
2013-01-17 13:00:00	ES	Futures	1515.68	1518.25	1514.91	1517.99	123742.0
2013-01-17 14:00:00	ES	Futures	1517.74	1519.53	1517.22	1517.74	144458.0
2013-01-17 15:00:00	ES	Futures	1517.74	1518.25	1514.4	1514.66	234990.0
2013-01-17 16:00:00	ES	Futures	1514.66	1515.94	1513.89	1513.89	100337.0
2013-01-17 17:00:00	ES	Futures	1513.89	1514.91	1513.89	1514.91	1477.0
2013-01-17 18:00:00	ES	Futures	1514.4	1514.4	1513.12	1513.37	6090.0
2013-01-17 19:00:00	ES	Futures	1513.37	1514.4	1513.12	1513.89	6462.0
2013-01-17 20:00:00	ES	Futures	1514.14	1514.91	1513.63	1514.91	5507.0
2013-01-17 21:00:00	ES	Futures	1514.91	1515.43	1513.37	1514.4	6180.0
2013-01-17 22:00:00	ES	Futures	1514.14	1515.43	1513.89	1514.4	3262.0
2013-01-17 23:00:00	ES	Futures	1514.4	1514.4	1513.12	1513.63	4372.0
2013-01-17 00:00:00	NQ	Futures	3166.54	3168.0	3162.76	3168.0	1578.0
2013-01-17 01:00:00	NQ	Futures	3168.29	3171.49	3168.0	3170.03	581.0
2013-01-17 02:00:00	NQ	Futures	3170.91	3172.94	3166.83	3170.03	1028.0
2013-01-17 03:00:00	NQ	Futures	3170.03	3177.02	3170.03	3175.85	4153.0
2013-01-17 04:00:00	NQ	Futures	3176.15	3178.47	3174.69	3176.44	2317.0
2013-01-17 05:00:00	NQ	Futures	3176.44	3179.93	3175.56	3177.6	2222.0
2013-01-17 06:00:00	NQ	Futures	3177.6	3180.51	3175.85	3180.22	1794.0
2013-01-17 07:00:00	NQ	Futures	3180.22	3183.42	3179.35	3182.84	2837.0
2013-01-17 08:00:00	NQ	Futures	3183.13	3194.48	3181.39	3191.28	12639.0
2013-01-17 09:00:00	NQ	Futures	3190.99	3193.32	3184.0	3189.83	25393.0
2013-01-17 10:00:00	NQ	Futures	3189.24	3197.39	3184.0	3186.62	41769.0
2013-01-17 11:00:00	NQ	Futures	3186.62	3195.07	3185.75	3189.53	18096.0
2013-01-17 12:00:00	NQ	Futures	3189.24	3195.94	3188.95	3193.61	15382.0
2013-01-17 13:00:00	NQ	Futures	3193.61	3201.18	3190.41	3200.01	17425.0
2013-01-17 14:00:00	NQ	Futures	3200.01	3204.09	3196.23	3197.68	18736.0
2013-01-17 15:00:00	NQ	Futures	3197.39	3198.27	3191.28	3191.86	31338.0
2013-01-17 16:00:00	NQ	Futures	3191.57	3193.61	3184.88	3185.75	8780.0
2013-01-17 17:00:00	NQ	Futures	3185.46	3187.21	3185.46	3186.92	314.0
2013-01-17 18:00:00	NQ	Futures	3184.88	3185.75	3183.13	3184.0	433.0
2013-01-17 19:00:00	NQ	Futures	3184.0	3186.62	3183.13	3186.33	471.0
2013-01-17 20:00:00	NQ	Futures	3186.33	3187.79	3185.17	3187.79	454.0
2013-01-17 21:00:00	NQ	Futures	3187.79	3188.37	3184.0	3186.04	529.0
2013-01-17 22:00:00	NQ	Futures	3186.04	3187.5	3184.88	3186.04	283.0
2013-01-17 23:00:00	NQ	Futures	3186.33	3186.33	3183.71	3184.88	391.0
2013-01-17 00:00:00	YM	Futures	13487.8	13497.8	13478.7	13496.8	604.0
2013-01-17 01:00:00	YM	Futures	13497.8	13505.9	13496.8	13503.9	349.0

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

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