PREVIEW / futures_1hour / 2011-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-12.parquet
  size:    47 KB
  rows:    1,359

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-09-12 00:00:00	ES	Futures	1144.77	1146.02	1141.53	1142.53	1920.0
2011-09-12 01:00:00	ES	Futures	1143.03	1143.77	1141.03	1141.03	2620.0
2011-09-12 02:00:00	ES	Futures	1141.03	1143.27	1137.29	1138.54	15372.0
2011-09-12 03:00:00	ES	Futures	1138.54	1140.03	1132.05	1133.05	29013.0
2011-09-12 04:00:00	ES	Futures	1132.8	1140.53	1131.55	1137.04	21007.0
2011-09-12 05:00:00	ES	Futures	1137.29	1139.28	1133.55	1137.54	9914.0
2011-09-12 06:00:00	ES	Futures	1137.79	1138.54	1131.05	1131.55	11218.0
2011-09-12 07:00:00	ES	Futures	1131.8	1136.54	1129.56	1133.8	19878.0
2011-09-12 08:00:00	ES	Futures	1134.05	1137.29	1126.81	1136.79	26337.0
2011-09-12 09:00:00	ES	Futures	1136.79	1152.25	1134.8	1150.01	86393.0
2011-09-12 10:00:00	ES	Futures	1149.76	1154.0	1137.54	1137.79	69390.0
2011-09-12 11:00:00	ES	Futures	1137.79	1147.27	1137.54	1142.78	43915.0
2011-09-12 12:00:00	ES	Futures	1142.53	1144.77	1137.79	1141.03	21733.0
2011-09-12 13:00:00	ES	Futures	1141.28	1143.52	1134.05	1138.04	29694.0
2011-09-12 14:00:00	ES	Futures	1138.29	1146.77	1132.05	1138.79	49327.0
2011-09-12 15:00:00	ES	Futures	1139.04	1159.49	1136.04	1158.74	81494.0
2011-09-12 16:00:00	ES	Futures	1158.74	1164.47	1157.74	1161.23	17789.0
2011-09-12 17:00:00	ES	Futures	1161.23	1165.97	1160.73	1164.47	1782.0
2011-09-12 18:00:00	ES	Futures	1164.47	1168.96	1163.73	1165.72	2767.0
2011-09-12 19:00:00	ES	Futures	1165.47	1165.72	1162.48	1162.48	1497.0
2011-09-12 20:00:00	ES	Futures	1162.73	1166.22	1160.48	1164.23	3200.0
2011-09-12 21:00:00	ES	Futures	1163.98	1166.22	1162.23	1163.48	1813.0
2011-09-12 22:00:00	ES	Futures	1163.23	1163.23	1160.48	1162.48	1534.0
2011-09-12 23:00:00	ES	Futures	1162.48	1163.98	1161.98	1163.98	1154.0
2011-09-12 00:00:00	NQ	Futures	2483.41	2483.99	2475.64	2477.66	106.0
2011-09-12 01:00:00	NQ	Futures	2477.66	2480.25	2475.07	2475.07	171.0
2011-09-12 02:00:00	NQ	Futures	2475.93	2477.08	2465.57	2465.57	485.0
2011-09-12 03:00:00	NQ	Futures	2467.3	2470.18	2454.64	2456.36	1083.0
2011-09-12 04:00:00	NQ	Futures	2456.36	2469.6	2452.91	2462.7	888.0
2011-09-12 05:00:00	NQ	Futures	2463.56	2467.88	2457.23	2465.0	465.0
2011-09-12 06:00:00	NQ	Futures	2464.71	2465.57	2454.35	2454.35	615.0
2011-09-12 07:00:00	NQ	Futures	2454.64	2463.56	2451.76	2456.65	956.0
2011-09-12 08:00:00	NQ	Futures	2458.09	2462.41	2442.55	2461.54	1552.0
2011-09-12 09:00:00	NQ	Futures	2462.12	2503.27	2459.53	2498.09	7212.0
2011-09-12 10:00:00	NQ	Futures	2498.38	2510.18	2475.93	2476.22	10223.0
2011-09-12 11:00:00	NQ	Futures	2476.8	2501.54	2475.93	2490.32	5712.0
2011-09-12 12:00:00	NQ	Futures	2490.32	2494.93	2476.22	2482.26	5081.0
2011-09-12 13:00:00	NQ	Futures	2481.98	2488.02	2465.86	2473.92	4396.0
2011-09-12 14:00:00	NQ	Futures	2473.63	2498.38	2461.83	2481.4	10136.0
2011-09-12 15:00:00	NQ	Futures	2481.11	2523.7	2476.22	2523.7	12753.0
2011-09-12 16:00:00	NQ	Futures	2523.99	2533.49	2522.55	2528.88	1258.0
2011-09-12 17:00:00	NQ	Futures	2528.88	2535.5	2528.88	2534.35	26.0
2011-09-12 18:00:00	NQ	Futures	2534.06	2544.13	2533.49	2535.5	215.0
2011-09-12 19:00:00	NQ	Futures	2536.94	2538.67	2532.62	2533.77	112.0
2011-09-12 20:00:00	NQ	Futures	2533.2	2539.24	2528.88	2535.79	250.0
2011-09-12 21:00:00	NQ	Futures	2535.21	2539.82	2532.91	2534.64	203.0
2011-09-12 22:00:00	NQ	Futures	2533.77	2533.77	2529.17	2533.2	106.0
2011-09-12 23:00:00	NQ	Futures	2532.33	2535.79	2531.76	2535.79	80.0
2011-09-12 00:00:00	YM	Futures	10693.3	10698.2	10662.8	10669.7	210.0
2011-09-12 01:00:00	YM	Futures	10672.6	10681.5	10658.8	10658.8	526.0

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

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