PREVIEW / futures_1hour / 2011-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-25.parquet
  size:    47 KB
  rows:    1,410

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
2011-08-25 00:00:00	ES	Futures	1167.47	1168.71	1165.72	1165.72	2346.0
2011-08-25 01:00:00	ES	Futures	1165.47	1166.47	1163.73	1163.98	4998.0
2011-08-25 02:00:00	ES	Futures	1164.23	1170.21	1163.98	1169.71	18766.0
2011-08-25 03:00:00	ES	Futures	1169.46	1173.45	1168.96	1169.96	56340.0
2011-08-25 04:00:00	ES	Futures	1169.96	1173.45	1169.96	1170.96	24886.0
2011-08-25 05:00:00	ES	Futures	1171.21	1171.46	1165.72	1166.22	29168.0
2011-08-25 06:00:00	ES	Futures	1166.22	1172.7	1165.97	1170.96	28415.0
2011-08-25 07:00:00	ES	Futures	1170.71	1173.2	1169.46	1172.7	27250.0
2011-08-25 08:00:00	ES	Futures	1172.46	1174.2	1168.22	1168.96	91568.0
2011-08-25 09:00:00	ES	Futures	1168.71	1185.67	1167.22	1172.21	596035.0
2011-08-25 10:00:00	ES	Futures	1172.46	1172.95	1154.0	1160.48	734619.0
2011-08-25 11:00:00	ES	Futures	1160.23	1164.72	1156.99	1161.48	349934.0
2011-08-25 12:00:00	ES	Futures	1161.73	1162.98	1150.51	1155.0	232596.0
2011-08-25 13:00:00	ES	Futures	1155.25	1161.73	1154.0	1160.48	204530.0
2011-08-25 14:00:00	ES	Futures	1160.73	1162.73	1155.0	1155.0	177622.0
2011-08-25 15:00:00	ES	Futures	1155.25	1162.23	1150.26	1155.0	458535.0
2011-08-25 16:00:00	ES	Futures	1155.0	1156.99	1151.51	1153.0	98138.0
2011-08-25 17:00:00	ES	Futures	1153.0	1154.0	1152.75	1153.5	2242.0
2011-08-25 18:00:00	ES	Futures	1153.25	1155.5	1152.5	1154.75	4133.0
2011-08-25 19:00:00	ES	Futures	1154.75	1158.74	1154.5	1158.49	5096.0
2011-08-25 20:00:00	ES	Futures	1158.49	1163.98	1157.99	1163.73	14488.0
2011-08-25 21:00:00	ES	Futures	1163.73	1163.73	1157.99	1160.73	8061.0
2011-08-25 22:00:00	ES	Futures	1160.73	1162.23	1158.49	1158.99	3593.0
2011-08-25 23:00:00	ES	Futures	1158.74	1161.23	1157.99	1159.74	2611.0
2011-08-25 00:00:00	NQ	Futures	2442.55	2444.57	2438.52	2439.1	228.0
2011-08-25 01:00:00	NQ	Futures	2438.24	2441.11	2435.93	2437.37	410.0
2011-08-25 02:00:00	NQ	Futures	2437.95	2453.77	2437.66	2451.47	2290.0
2011-08-25 03:00:00	NQ	Futures	2451.47	2457.8	2449.75	2451.47	4082.0
2011-08-25 04:00:00	NQ	Futures	2452.05	2458.38	2449.75	2450.03	2494.0
2011-08-25 05:00:00	NQ	Futures	2450.32	2451.47	2441.69	2443.42	2138.0
2011-08-25 06:00:00	NQ	Futures	2443.42	2455.79	2442.55	2451.76	1397.0
2011-08-25 07:00:00	NQ	Futures	2452.05	2460.11	2449.46	2459.24	2437.0
2011-08-25 08:00:00	NQ	Futures	2459.24	2461.54	2449.75	2450.61	7585.0
2011-08-25 09:00:00	NQ	Futures	2450.61	2477.08	2448.31	2459.82	61499.0
2011-08-25 10:00:00	NQ	Futures	2460.39	2461.83	2430.18	2431.62	66291.0
2011-08-25 11:00:00	NQ	Futures	2431.62	2452.34	2431.04	2446.58	27920.0
2011-08-25 12:00:00	NQ	Futures	2446.87	2449.46	2422.41	2430.47	22691.0
2011-08-25 13:00:00	NQ	Futures	2430.75	2441.11	2427.88	2439.1	21596.0
2011-08-25 14:00:00	NQ	Futures	2439.1	2442.26	2425.0	2425.0	21078.0
2011-08-25 15:00:00	NQ	Futures	2425.0	2440.83	2418.38	2428.16	43698.0
2011-08-25 16:00:00	NQ	Futures	2428.16	2434.49	2425.57	2427.59	10382.0
2011-08-25 17:00:00	NQ	Futures	2427.88	2430.47	2427.59	2428.74	163.0
2011-08-25 18:00:00	NQ	Futures	2428.74	2431.62	2427.01	2431.04	262.0
2011-08-25 19:00:00	NQ	Futures	2430.75	2438.24	2430.75	2437.95	387.0
2011-08-25 20:00:00	NQ	Futures	2437.95	2449.46	2437.95	2448.59	1777.0
2011-08-25 21:00:00	NQ	Futures	2448.02	2448.02	2437.08	2442.55	1035.0
2011-08-25 22:00:00	NQ	Futures	2442.84	2446.0	2439.39	2439.39	570.0
2011-08-25 23:00:00	NQ	Futures	2439.1	2443.99	2438.24	2441.11	377.0
2011-08-25 00:00:00	YM	Futures	10907.1	10914.8	10890.6	10890.6	167.0
2011-08-25 01:00:00	YM	Futures	10890.6	10897.4	10876.1	10880.0	269.0

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

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