PREVIEW / futures_1hour / 2011-09-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	1137.94	1138.69	1134.68	1136.18	7924.0
2011-09-23 01:00:00	ES	Futures	1136.44	1137.44	1130.92	1132.67	9686.0
2011-09-23 02:00:00	ES	Futures	1132.67	1140.95	1128.41	1140.7	28929.0
2011-09-23 03:00:00	ES	Futures	1140.95	1141.95	1132.42	1133.43	75845.0
2011-09-23 04:00:00	ES	Futures	1133.43	1140.45	1133.18	1135.43	37461.0
2011-09-23 05:00:00	ES	Futures	1135.18	1136.69	1127.16	1128.91	42864.0
2011-09-23 06:00:00	ES	Futures	1128.91	1129.41	1114.37	1118.38	101072.0
2011-09-23 07:00:00	ES	Futures	1118.38	1120.64	1108.6	1110.11	103494.0
2011-09-23 08:00:00	ES	Futures	1110.36	1119.89	1105.34	1114.62	205401.0
2011-09-23 09:00:00	ES	Futures	1114.62	1131.92	1113.87	1127.91	546140.0
2011-09-23 10:00:00	ES	Futures	1127.91	1133.93	1119.63	1132.17	510581.0
2011-09-23 11:00:00	ES	Futures	1132.42	1137.69	1128.16	1131.67	358108.0
2011-09-23 12:00:00	ES	Futures	1131.67	1135.18	1125.9	1128.16	264050.0
2011-09-23 13:00:00	ES	Futures	1128.41	1137.44	1124.9	1136.94	259624.0
2011-09-23 14:00:00	ES	Futures	1136.94	1138.94	1125.65	1126.41	212094.0
2011-09-23 15:00:00	ES	Futures	1126.66	1135.68	1126.41	1131.67	385080.0
2011-09-23 16:00:00	ES	Futures	1131.67	1134.68	1129.16	1134.18	102283.0
2011-09-23 00:00:00	NQ	Futures	2532.05	2533.2	2524.84	2528.88	543.0
2011-09-23 01:00:00	NQ	Futures	2528.88	2530.03	2517.92	2520.52	545.0
2011-09-23 02:00:00	NQ	Futures	2520.8	2537.53	2513.02	2537.24	2483.0
2011-09-23 03:00:00	NQ	Futures	2537.24	2539.26	2516.77	2519.07	4870.0
2011-09-23 04:00:00	NQ	Futures	2519.94	2534.93	2519.07	2523.97	3837.0
2011-09-23 05:00:00	NQ	Futures	2523.97	2526.57	2507.83	2511.29	2632.0
2011-09-23 06:00:00	NQ	Futures	2511.29	2513.02	2478.42	2487.07	12208.0
2011-09-23 07:00:00	NQ	Futures	2487.07	2491.68	2466.6	2469.19	6020.0
2011-09-23 08:00:00	NQ	Futures	2469.77	2492.84	2461.12	2481.88	17767.0
2011-09-23 09:00:00	NQ	Futures	2481.88	2523.4	2480.73	2514.75	74086.0
2011-09-23 10:00:00	NQ	Futures	2514.75	2531.47	2502.64	2528.59	66475.0
2011-09-23 11:00:00	NQ	Futures	2528.59	2543.58	2521.38	2530.03	43768.0
2011-09-23 12:00:00	NQ	Futures	2530.32	2537.24	2516.19	2522.24	32636.0
2011-09-23 13:00:00	NQ	Futures	2522.24	2545.89	2517.06	2544.45	38908.0
2011-09-23 14:00:00	NQ	Futures	2544.45	2549.06	2523.69	2525.13	27237.0
2011-09-23 15:00:00	NQ	Futures	2525.13	2543.87	2524.55	2536.95	45942.0
2011-09-23 16:00:00	NQ	Futures	2536.95	2542.14	2528.01	2541.27	10138.0
2011-09-23 00:00:00	YM	Futures	10579.1	10586.0	10552.5	10562.4	548.0
2011-09-23 01:00:00	YM	Futures	10567.3	10571.2	10518.1	10530.9	645.0
2011-09-23 02:00:00	YM	Futures	10528.9	10603.7	10503.3	10601.7	1412.0
2011-09-23 03:00:00	YM	Futures	10603.7	10608.6	10529.9	10535.8	2280.0
2011-09-23 04:00:00	YM	Futures	10538.7	10594.9	10536.8	10557.4	1378.0
2011-09-23 05:00:00	YM	Futures	10553.5	10563.3	10484.6	10500.3	1194.0
2011-09-23 06:00:00	YM	Futures	10500.3	10503.3	10382.2	10416.6	4493.0
2011-09-23 07:00:00	YM	Futures	10413.7	10431.4	10339.9	10347.7	3300.0
2011-09-23 08:00:00	YM	Futures	10350.7	10424.5	10307.4	10381.2	6166.0
2011-09-23 09:00:00	YM	Futures	10383.2	10504.3	10378.2	10473.8	32361.0
2011-09-23 10:00:00	YM	Futures	10475.7	10516.1	10387.1	10498.4	30208.0
2011-09-23 11:00:00	YM	Futures	10500.3	10538.7	10463.9	10493.4	17148.0
2011-09-23 12:00:00	YM	Futures	10494.4	10518.1	10442.2	10463.9	13297.0
2011-09-23 13:00:00	YM	Futures	10466.9	10548.6	10433.4	10541.7	14007.0
2011-09-23 14:00:00	YM	Futures	10542.7	10559.4	10442.2	10449.1	11427.0
2011-09-23 15:00:00	YM	Futures	10451.1	10541.7	10451.1	10516.1	17736.0

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

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