PREVIEW / futures_1hour / 2011-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-05.parquet
  size:    33 KB
  rows:    908

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-05 00:00:00	ES	Futures	1160.98	1161.48	1158.24	1158.49	1814.0
2011-09-05 01:00:00	ES	Futures	1158.49	1159.99	1157.49	1158.74	6094.0
2011-09-05 02:00:00	ES	Futures	1158.74	1159.49	1155.25	1155.75	24056.0
2011-09-05 03:00:00	ES	Futures	1155.99	1159.74	1154.75	1158.24	35526.0
2011-09-05 04:00:00	ES	Futures	1158.24	1159.24	1154.0	1154.25	23151.0
2011-09-05 05:00:00	ES	Futures	1154.25	1155.75	1153.0	1153.25	22714.0
2011-09-05 06:00:00	ES	Futures	1153.5	1155.25	1150.51	1151.01	26087.0
2011-09-05 07:00:00	ES	Futures	1151.01	1151.75	1149.51	1150.76	14732.0
2011-09-05 08:00:00	ES	Futures	1150.76	1153.0	1149.51	1152.25	15404.0
2011-09-05 09:00:00	ES	Futures	1152.0	1152.75	1137.79	1139.04	66544.0
2011-09-05 10:00:00	ES	Futures	1138.79	1142.78	1135.54	1142.53	55645.0
2011-09-05 11:00:00	ES	Futures	1142.78	1145.27	1142.28	1142.78	27074.0
2011-09-05 18:00:00	ES	Futures	1140.28	1141.78	1133.55	1134.05	20397.0
2011-09-05 19:00:00	ES	Futures	1134.05	1137.04	1133.8	1136.29	5871.0
2011-09-05 20:00:00	ES	Futures	1136.29	1139.04	1135.04	1138.29	14214.0
2011-09-05 21:00:00	ES	Futures	1138.29	1141.78	1137.29	1140.53	11061.0
2011-09-05 22:00:00	ES	Futures	1140.53	1140.53	1137.29	1139.28	7074.0
2011-09-05 23:00:00	ES	Futures	1139.28	1141.78	1138.54	1140.03	4398.0
2011-09-05 00:00:00	NQ	Futures	2480.82	2481.4	2476.51	2476.8	84.0
2011-09-05 01:00:00	NQ	Futures	2477.08	2477.95	2471.04	2475.93	279.0
2011-09-05 02:00:00	NQ	Futures	2475.64	2476.51	2466.72	2470.18	2952.0
2011-09-05 03:00:00	NQ	Futures	2469.89	2474.78	2464.13	2471.62	3736.0
2011-09-05 04:00:00	NQ	Futures	2471.62	2475.36	2465.0	2466.44	1736.0
2011-09-05 05:00:00	NQ	Futures	2465.86	2466.72	2459.24	2459.82	1952.0
2011-09-05 06:00:00	NQ	Futures	2459.82	2462.7	2454.06	2455.79	1317.0
2011-09-05 07:00:00	NQ	Futures	2456.36	2456.36	2452.62	2454.35	1199.0
2011-09-05 08:00:00	NQ	Futures	2454.64	2457.52	2451.18	2456.65	1243.0
2011-09-05 09:00:00	NQ	Futures	2456.36	2458.09	2432.48	2437.08	5934.0
2011-09-05 10:00:00	NQ	Futures	2436.22	2445.43	2426.72	2445.43	5218.0
2011-09-05 11:00:00	NQ	Futures	2444.85	2455.5	2444.57	2450.61	3948.0
2011-09-05 18:00:00	NQ	Futures	2446.0	2446.29	2430.75	2431.04	1417.0
2011-09-05 19:00:00	NQ	Futures	2431.33	2438.24	2430.75	2435.65	422.0
2011-09-05 20:00:00	NQ	Futures	2436.8	2442.55	2433.92	2440.83	1023.0
2011-09-05 21:00:00	NQ	Futures	2440.54	2448.02	2438.81	2445.14	822.0
2011-09-05 22:00:00	NQ	Futures	2445.43	2445.72	2438.24	2443.13	431.0
2011-09-05 23:00:00	NQ	Futures	2443.7	2444.85	2440.54	2442.26	542.0
2011-09-05 00:00:00	YM	Futures	10806.4	10814.1	10788.9	10788.9	169.0
2011-09-05 01:00:00	YM	Futures	10789.9	10794.7	10773.4	10786.0	384.0
2011-09-05 02:00:00	YM	Futures	10784.1	10793.8	10760.9	10772.5	1165.0
2011-09-05 03:00:00	YM	Futures	10772.5	10796.7	10756.0	10785.1	2202.0
2011-09-05 04:00:00	YM	Futures	10785.1	10790.9	10755.0	10757.9	1052.0
2011-09-05 05:00:00	YM	Futures	10756.0	10763.8	10745.4	10748.3	588.0
2011-09-05 06:00:00	YM	Futures	10747.3	10759.9	10723.1	10723.1	941.0
2011-09-05 07:00:00	YM	Futures	10724.1	10729.9	10711.5	10720.2	483.0
2011-09-05 08:00:00	YM	Futures	10720.2	10741.5	10713.4	10734.7	663.0
2011-09-05 09:00:00	YM	Futures	10734.7	10739.5	10619.5	10627.2	3874.0
2011-09-05 10:00:00	YM	Futures	10627.2	10650.5	10604.0	10647.6	1940.0
2011-09-05 11:00:00	YM	Futures	10649.5	10684.4	10638.8	10652.4	1819.0
2011-09-05 18:00:00	YM	Futures	10640.8	10644.6	10573.0	10576.9	728.0
2011-09-05 19:00:00	YM	Futures	10577.8	10604.9	10577.8	10594.3	299.0

> showing 50 of 908 rows — these rows as CSV

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