PREVIEW / futures_1hour / 2011-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-30.parquet
  size:    43 KB
  rows:    1,195

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-30 00:00:00	ES	Futures	1152.23	1155.24	1150.48	1153.49	5994.0
2011-09-30 01:00:00	ES	Futures	1153.49	1158.5	1153.49	1157.0	9478.0
2011-09-30 02:00:00	ES	Futures	1156.75	1157.0	1150.73	1151.98	16957.0
2011-09-30 03:00:00	ES	Futures	1151.98	1156.25	1148.22	1150.98	47513.0
2011-09-30 04:00:00	ES	Futures	1150.98	1152.73	1148.47	1151.73	25882.0
2011-09-30 05:00:00	ES	Futures	1151.98	1152.48	1144.46	1145.71	37640.0
2011-09-30 06:00:00	ES	Futures	1145.71	1147.97	1142.45	1146.22	69109.0
2011-09-30 07:00:00	ES	Futures	1146.22	1148.47	1143.96	1144.71	51483.0
2011-09-30 08:00:00	ES	Futures	1144.71	1149.73	1143.96	1144.21	57484.0
2011-09-30 09:00:00	ES	Futures	1144.46	1148.72	1138.19	1138.69	441366.0
2011-09-30 10:00:00	ES	Futures	1138.69	1150.98	1137.69	1141.2	440714.0
2011-09-30 11:00:00	ES	Futures	1140.95	1152.23	1140.7	1148.72	303569.0
2011-09-30 12:00:00	ES	Futures	1148.72	1150.48	1143.71	1143.71	135806.0
2011-09-30 13:00:00	ES	Futures	1143.71	1148.72	1141.7	1145.46	130874.0
2011-09-30 14:00:00	ES	Futures	1145.46	1146.97	1135.18	1140.7	304054.0
2011-09-30 15:00:00	ES	Futures	1140.95	1144.21	1127.66	1129.16	618314.0
2011-09-30 16:00:00	ES	Futures	1129.16	1130.42	1124.9	1125.65	218789.0
2011-09-30 00:00:00	NQ	Futures	2511.58	2518.5	2509.56	2516.48	365.0
2011-09-30 01:00:00	NQ	Futures	2516.48	2526.86	2516.48	2523.69	825.0
2011-09-30 02:00:00	NQ	Futures	2523.69	2523.69	2512.73	2515.9	1693.0
2011-09-30 03:00:00	NQ	Futures	2515.9	2524.84	2508.69	2513.02	3433.0
2011-09-30 04:00:00	NQ	Futures	2513.31	2516.48	2507.54	2514.17	1927.0
2011-09-30 05:00:00	NQ	Futures	2514.46	2515.33	2498.89	2501.49	3436.0
2011-09-30 06:00:00	NQ	Futures	2501.77	2505.23	2494.28	2502.64	4115.0
2011-09-30 07:00:00	NQ	Futures	2502.93	2507.25	2496.87	2497.74	4154.0
2011-09-30 08:00:00	NQ	Futures	2498.03	2508.12	2496.3	2496.3	5724.0
2011-09-30 09:00:00	NQ	Futures	2496.87	2497.74	2476.4	2480.73	66111.0
2011-09-30 10:00:00	NQ	Futures	2480.44	2511.58	2477.84	2486.78	56410.0
2011-09-30 11:00:00	NQ	Futures	2486.78	2513.02	2486.49	2503.5	41951.0
2011-09-30 12:00:00	NQ	Futures	2503.5	2507.83	2491.68	2492.26	21269.0
2011-09-30 13:00:00	NQ	Futures	2491.97	2501.49	2486.78	2494.85	20624.0
2011-09-30 14:00:00	NQ	Futures	2494.85	2496.87	2473.52	2485.34	47387.0
2011-09-30 15:00:00	NQ	Futures	2484.76	2491.68	2459.1	2460.83	75711.0
2011-09-30 16:00:00	NQ	Futures	2460.54	2462.27	2447.57	2449.01	23988.0
2011-09-30 00:00:00	YM	Futures	10858.7	10882.3	10846.9	10875.5	692.0
2011-09-30 01:00:00	YM	Futures	10877.4	10915.8	10877.4	10902.0	688.0
2011-09-30 02:00:00	YM	Futures	10901.1	10901.1	10851.8	10863.6	795.0
2011-09-30 03:00:00	YM	Futures	10861.7	10903.0	10832.1	10853.8	2786.0
2011-09-30 04:00:00	YM	Futures	10854.8	10867.6	10832.1	10858.7	1229.0
2011-09-30 05:00:00	YM	Futures	10861.7	10866.6	10799.6	10811.5	1715.0
2011-09-30 06:00:00	YM	Futures	10807.5	10827.2	10785.9	10810.5	3358.0
2011-09-30 07:00:00	YM	Futures	10809.5	10830.2	10792.7	10798.7	2494.0
2011-09-30 08:00:00	YM	Futures	10799.6	10839.0	10788.8	10790.8	2660.0
2011-09-30 09:00:00	YM	Futures	10792.7	10845.9	10748.4	10775.0	24872.0
2011-09-30 10:00:00	YM	Futures	10775.0	10877.4	10765.2	10790.8	20750.0
2011-09-30 11:00:00	YM	Futures	10790.8	10893.2	10788.8	10861.7	15684.0
2011-09-30 12:00:00	YM	Futures	10861.7	10879.4	10811.5	10812.4	7470.0
2011-09-30 13:00:00	YM	Futures	10811.5	10851.8	10796.7	10822.3	7468.0
2011-09-30 14:00:00	YM	Futures	10820.3	10833.1	10716.0	10769.1	16374.0
2011-09-30 15:00:00	YM	Futures	10768.1	10799.6	10667.7	10673.6	26766.0

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

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