PREVIEW / futures_1hour / 2012-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-23.parquet
  size:    41 KB
  rows:    1,190

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
2012-03-23 00:00:00	ES	Futures	1408.11	1408.36	1407.35	1407.6	2097.0
2012-03-23 01:00:00	ES	Futures	1407.6	1408.11	1406.34	1406.34	2607.0
2012-03-23 02:00:00	ES	Futures	1406.59	1406.59	1405.83	1406.34	3007.0
2012-03-23 03:00:00	ES	Futures	1406.09	1409.88	1406.09	1408.62	12513.0
2012-03-23 04:00:00	ES	Futures	1408.87	1411.91	1407.6	1410.89	41238.0
2012-03-23 05:00:00	ES	Futures	1410.89	1411.65	1405.08	1406.59	39287.0
2012-03-23 06:00:00	ES	Futures	1406.59	1407.1	1404.57	1405.58	25449.0
2012-03-23 07:00:00	ES	Futures	1405.58	1406.85	1402.55	1402.55	37899.0
2012-03-23 08:00:00	ES	Futures	1402.55	1405.83	1402.04	1405.33	49181.0
2012-03-23 09:00:00	ES	Futures	1405.33	1405.58	1401.28	1402.8	169264.0
2012-03-23 10:00:00	ES	Futures	1402.8	1404.06	1396.98	1403.3	345487.0
2012-03-23 11:00:00	ES	Futures	1403.3	1407.86	1402.29	1407.1	220113.0
2012-03-23 12:00:00	ES	Futures	1407.1	1408.62	1405.08	1407.86	151214.0
2012-03-23 13:00:00	ES	Futures	1407.6	1409.63	1406.85	1407.35	104940.0
2012-03-23 14:00:00	ES	Futures	1407.1	1409.88	1406.85	1408.87	62494.0
2012-03-23 15:00:00	ES	Futures	1408.87	1409.63	1407.35	1408.62	183764.0
2012-03-23 16:00:00	ES	Futures	1408.62	1411.15	1408.36	1410.89	77088.0
2012-03-23 00:00:00	NQ	Futures	3166.46	3166.46	3164.43	3165.3	419.0
2012-03-23 01:00:00	NQ	Futures	3165.01	3165.01	3162.7	3162.7	326.0
2012-03-23 02:00:00	NQ	Futures	3162.7	3163.56	3161.83	3163.28	439.0
2012-03-23 03:00:00	NQ	Futures	3163.28	3171.95	3163.28	3170.22	2413.0
2012-03-23 04:00:00	NQ	Futures	3170.51	3177.16	3167.9	3175.42	3803.0
2012-03-23 05:00:00	NQ	Futures	3175.71	3176.58	3163.85	3166.17	4007.0
2012-03-23 06:00:00	NQ	Futures	3166.17	3167.04	3162.12	3164.43	2610.0
2012-03-23 07:00:00	NQ	Futures	3164.43	3166.75	3157.78	3157.78	4435.0
2012-03-23 08:00:00	NQ	Futures	3157.78	3163.28	3157.2	3162.7	5777.0
2012-03-23 09:00:00	NQ	Futures	3162.7	3162.99	3147.66	3149.39	29976.0
2012-03-23 10:00:00	NQ	Futures	3149.1	3149.1	3135.8	3146.5	46808.0
2012-03-23 11:00:00	NQ	Futures	3146.5	3154.31	3142.16	3152.0	28482.0
2012-03-23 12:00:00	NQ	Futures	3151.71	3152.29	3144.77	3148.53	16077.0
2012-03-23 13:00:00	NQ	Futures	3148.53	3152.0	3145.92	3149.39	13356.0
2012-03-23 14:00:00	NQ	Futures	3149.39	3158.07	3148.82	3154.31	11181.0
2012-03-23 15:00:00	NQ	Futures	3154.31	3155.18	3150.84	3153.73	18293.0
2012-03-23 16:00:00	NQ	Futures	3154.02	3158.94	3153.73	3158.94	6144.0
2012-03-23 00:00:00	YM	Futures	12966.8	12966.8	12961.9	12963.9	145.0
2012-03-23 01:00:00	YM	Futures	12962.9	12964.8	12955.9	12955.9	169.0
2012-03-23 02:00:00	YM	Futures	12955.9	12955.9	12945.9	12949.9	1342.0
2012-03-23 03:00:00	YM	Futures	12950.9	12976.8	12950.9	12967.8	607.0
2012-03-23 04:00:00	YM	Futures	12968.8	12992.7	12959.9	12984.8	3246.0
2012-03-23 05:00:00	YM	Futures	12984.8	12990.8	12939.9	12949.9	2133.0
2012-03-23 06:00:00	YM	Futures	12950.9	12955.9	12934.0	12944.9	1249.0
2012-03-23 07:00:00	YM	Futures	12943.9	12950.9	12918.0	12918.0	2380.0
2012-03-23 08:00:00	YM	Futures	12918.0	12941.9	12915.0	12938.9	2224.0
2012-03-23 09:00:00	YM	Futures	12939.9	12942.9	12907.1	12926.0	11888.0
2012-03-23 10:00:00	YM	Futures	12925.0	12936.0	12884.1	12933.0	18331.0
2012-03-23 11:00:00	YM	Futures	12932.0	12974.8	12925.0	12968.8	11634.0
2012-03-23 12:00:00	YM	Futures	12969.8	12977.8	12949.9	12971.8	8210.0
2012-03-23 13:00:00	YM	Futures	12971.8	12982.8	12962.9	12964.8	6073.0
2012-03-23 14:00:00	YM	Futures	12964.8	12984.8	12962.9	12974.8	4111.0
2012-03-23 15:00:00	YM	Futures	12975.8	12979.8	12959.9	12970.8	7672.0

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

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