PREVIEW / futures_1hour / 2012-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-10.parquet
  size:    48 KB
  rows:    1,478

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-10-10 00:00:00	ES	Futures	1467.13	1467.64	1466.11	1467.38	4020.0
2012-10-10 01:00:00	ES	Futures	1467.38	1467.89	1465.85	1466.36	6022.0
2012-10-10 02:00:00	ES	Futures	1466.11	1467.38	1465.85	1466.62	8176.0
2012-10-10 03:00:00	ES	Futures	1466.62	1469.17	1466.11	1468.15	28459.0
2012-10-10 04:00:00	ES	Futures	1468.15	1468.92	1466.36	1467.38	19232.0
2012-10-10 05:00:00	ES	Futures	1467.38	1467.64	1464.06	1464.57	21110.0
2012-10-10 06:00:00	ES	Futures	1464.57	1466.87	1464.57	1466.62	12667.0
2012-10-10 07:00:00	ES	Futures	1466.62	1468.66	1465.85	1468.15	25250.0
2012-10-10 08:00:00	ES	Futures	1468.41	1468.92	1465.85	1467.13	35583.0
2012-10-10 09:00:00	ES	Futures	1467.13	1468.41	1463.3	1465.08	180625.0
2012-10-10 10:00:00	ES	Futures	1464.83	1468.92	1464.57	1466.11	236760.0
2012-10-10 11:00:00	ES	Futures	1466.11	1466.87	1460.49	1462.02	236083.0
2012-10-10 12:00:00	ES	Futures	1462.02	1463.81	1456.91	1457.42	180791.0
2012-10-10 13:00:00	ES	Futures	1457.42	1460.49	1456.4	1457.93	161099.0
2012-10-10 14:00:00	ES	Futures	1457.93	1461.25	1457.16	1457.93	126174.0
2012-10-10 15:00:00	ES	Futures	1457.93	1460.49	1456.14	1458.7	258809.0
2012-10-10 16:00:00	ES	Futures	1458.95	1458.95	1452.31	1455.12	108838.0
2012-10-10 17:00:00	ES	Futures	1455.12	1455.12	1453.08	1453.59	6767.0
2012-10-10 18:00:00	ES	Futures	1453.84	1453.84	1452.31	1453.59	10222.0
2012-10-10 19:00:00	ES	Futures	1453.59	1454.61	1453.33	1453.84	4456.0
2012-10-10 20:00:00	ES	Futures	1453.84	1457.16	1453.84	1456.65	14458.0
2012-10-10 21:00:00	ES	Futures	1456.65	1457.16	1455.12	1456.4	7861.0
2012-10-10 22:00:00	ES	Futures	1456.14	1457.68	1456.14	1457.68	6247.0
2012-10-10 23:00:00	ES	Futures	1457.42	1459.21	1457.42	1458.44	5753.0
2012-10-10 00:00:00	NQ	Futures	3181.23	3181.23	3179.2	3181.23	686.0
2012-10-10 01:00:00	NQ	Futures	3181.52	3181.81	3176.87	3178.03	715.0
2012-10-10 02:00:00	NQ	Futures	3178.32	3179.49	3175.42	3176.58	1544.0
2012-10-10 03:00:00	NQ	Futures	3176.58	3181.52	3174.84	3178.03	2365.0
2012-10-10 04:00:00	NQ	Futures	3178.32	3180.07	3173.38	3176.0	1976.0
2012-10-10 05:00:00	NQ	Futures	3176.0	3176.0	3167.86	3169.61	2852.0
2012-10-10 06:00:00	NQ	Futures	3169.61	3175.13	3169.32	3173.97	1803.0
2012-10-10 07:00:00	NQ	Futures	3174.26	3180.94	3173.09	3180.07	3514.0
2012-10-10 08:00:00	NQ	Futures	3179.78	3183.26	3176.29	3180.07	4821.0
2012-10-10 09:00:00	NQ	Futures	3180.07	3185.59	3170.19	3179.2	37860.0
2012-10-10 10:00:00	NQ	Futures	3179.2	3189.08	3176.87	3178.91	48641.0
2012-10-10 11:00:00	NQ	Futures	3178.91	3180.94	3168.44	3171.93	29442.0
2012-10-10 12:00:00	NQ	Futures	3171.93	3177.45	3161.76	3162.34	31038.0
2012-10-10 13:00:00	NQ	Futures	3162.34	3166.41	3159.73	3163.51	24402.0
2012-10-10 14:00:00	NQ	Futures	3163.8	3170.48	3160.31	3163.51	22830.0
2012-10-10 15:00:00	NQ	Futures	3163.21	3167.28	3158.27	3164.09	30674.0
2012-10-10 16:00:00	NQ	Futures	3164.09	3166.12	3155.08	3160.31	9785.0
2012-10-10 17:00:00	NQ	Futures	3160.89	3161.18	3157.4	3157.4	265.0
2012-10-10 18:00:00	NQ	Futures	3157.4	3159.15	3155.66	3158.86	744.0
2012-10-10 19:00:00	NQ	Futures	3158.86	3160.31	3157.98	3159.73	749.0
2012-10-10 20:00:00	NQ	Futures	3159.73	3165.83	3159.44	3165.25	1239.0
2012-10-10 21:00:00	NQ	Futures	3165.25	3166.12	3162.63	3164.96	2285.0
2012-10-10 22:00:00	NQ	Futures	3165.25	3168.15	3164.96	3167.86	678.0
2012-10-10 23:00:00	NQ	Futures	3167.86	3171.35	3167.28	3170.19	663.0
2012-10-10 00:00:00	YM	Futures	13402.9	13404.9	13397.9	13404.9	482.0
2012-10-10 01:00:00	YM	Futures	13404.9	13407.9	13392.9	13395.9	568.0

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

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