PREVIEW / futures_1hour / 2011-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-22.parquet
  size:    53 KB
  rows:    1,521

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-22 00:00:00	ES	Futures	1152.23	1153.49	1150.23	1150.48	5246.0
2011-09-22 01:00:00	ES	Futures	1150.48	1155.24	1149.98	1152.99	10405.0
2011-09-22 02:00:00	ES	Futures	1152.99	1155.24	1147.22	1150.48	36434.0
2011-09-22 03:00:00	ES	Futures	1150.48	1153.24	1144.46	1145.46	79105.0
2011-09-22 04:00:00	ES	Futures	1145.46	1146.22	1139.95	1142.45	72842.0
2011-09-22 05:00:00	ES	Futures	1142.2	1142.45	1137.69	1139.44	63408.0
2011-09-22 06:00:00	ES	Futures	1139.7	1140.95	1130.17	1131.92	102565.0
2011-09-22 07:00:00	ES	Futures	1131.92	1135.18	1129.16	1134.68	99799.0
2011-09-22 08:00:00	ES	Futures	1134.68	1136.44	1123.65	1126.91	168663.0
2011-09-22 09:00:00	ES	Futures	1127.16	1136.18	1123.9	1124.65	532042.0
2011-09-22 10:00:00	ES	Futures	1124.65	1139.44	1124.15	1130.17	710386.0
2011-09-22 11:00:00	ES	Futures	1130.42	1132.67	1124.65	1124.9	451895.0
2011-09-22 12:00:00	ES	Futures	1124.65	1131.67	1120.89	1130.92	367657.0
2011-09-22 13:00:00	ES	Futures	1130.92	1131.42	1115.12	1115.37	380278.0
2011-09-22 14:00:00	ES	Futures	1115.37	1130.17	1113.62	1117.13	629253.0
2011-09-22 15:00:00	ES	Futures	1117.13	1131.17	1110.11	1126.15	809564.0
2011-09-22 16:00:00	ES	Futures	1126.15	1131.67	1124.9	1131.42	136136.0
2011-09-22 17:00:00	ES	Futures	1131.42	1133.93	1129.41	1131.92	5891.0
2011-09-22 18:00:00	ES	Futures	1132.17	1134.18	1130.42	1130.67	7357.0
2011-09-22 19:00:00	ES	Futures	1130.92	1134.93	1128.66	1133.43	9440.0
2011-09-22 20:00:00	ES	Futures	1133.43	1136.18	1132.67	1135.68	13269.0
2011-09-22 21:00:00	ES	Futures	1135.93	1136.44	1129.92	1131.17	17114.0
2011-09-22 22:00:00	ES	Futures	1131.17	1136.69	1127.91	1134.93	16192.0
2011-09-22 23:00:00	ES	Futures	1135.18	1141.2	1134.43	1137.94	16657.0
2011-09-22 00:00:00	NQ	Futures	2573.28	2577.03	2570.68	2571.84	575.0
2011-09-22 01:00:00	NQ	Futures	2572.41	2582.22	2570.68	2577.31	1069.0
2011-09-22 02:00:00	NQ	Futures	2577.89	2581.93	2566.65	2570.39	3275.0
2011-09-22 03:00:00	NQ	Futures	2570.97	2578.76	2560.59	2561.75	7633.0
2011-09-22 04:00:00	NQ	Futures	2562.03	2564.34	2551.65	2554.54	5880.0
2011-09-22 05:00:00	NQ	Futures	2554.54	2555.11	2544.73	2545.89	5428.0
2011-09-22 06:00:00	NQ	Futures	2546.46	2549.92	2522.53	2526.28	7094.0
2011-09-22 07:00:00	NQ	Futures	2526.57	2540.99	2521.38	2538.39	8849.0
2011-09-22 08:00:00	NQ	Futures	2538.68	2542.14	2519.94	2525.99	15588.0
2011-09-22 09:00:00	NQ	Futures	2526.28	2542.43	2508.69	2514.17	83087.0
2011-09-22 10:00:00	NQ	Futures	2514.17	2554.25	2513.31	2533.78	99330.0
2011-09-22 11:00:00	NQ	Futures	2533.49	2539.54	2520.52	2520.8	60050.0
2011-09-22 12:00:00	NQ	Futures	2521.09	2534.93	2508.98	2530.89	39617.0
2011-09-22 13:00:00	NQ	Futures	2531.18	2532.62	2485.92	2486.49	46091.0
2011-09-22 14:00:00	NQ	Futures	2486.49	2518.21	2482.46	2493.41	82929.0
2011-09-22 15:00:00	NQ	Futures	2492.84	2524.55	2473.23	2511.29	93818.0
2011-09-22 16:00:00	NQ	Futures	2511.29	2519.36	2505.81	2518.21	13741.0
2011-09-22 17:00:00	NQ	Futures	2518.5	2523.4	2514.75	2520.52	223.0
2011-09-22 18:00:00	NQ	Futures	2518.21	2523.11	2517.34	2517.63	1050.0
2011-09-22 19:00:00	NQ	Futures	2517.63	2525.99	2513.31	2522.82	911.0
2011-09-22 20:00:00	NQ	Futures	2523.4	2530.89	2521.67	2530.32	1676.0
2011-09-22 21:00:00	NQ	Futures	2530.03	2530.89	2517.34	2519.65	947.0
2011-09-22 22:00:00	NQ	Futures	2519.65	2529.74	2512.44	2526.28	1134.0
2011-09-22 23:00:00	NQ	Futures	2526.57	2538.68	2526.28	2532.91	1487.0
2011-09-22 00:00:00	YM	Futures	10780.9	10789.8	10763.2	10766.2	317.0
2011-09-22 01:00:00	YM	Futures	10768.1	10801.6	10761.2	10782.9	809.0

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

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