PREVIEW / futures_1hour / 2012-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-26.parquet
  size:    48 KB
  rows:    1,432

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-26 00:00:00	ES	Futures	1413.68	1413.68	1411.4	1411.4	2337.0
2012-03-26 01:00:00	ES	Futures	1411.4	1412.41	1411.15	1411.65	3602.0
2012-03-26 02:00:00	ES	Futures	1411.65	1414.44	1411.4	1413.42	8142.0
2012-03-26 03:00:00	ES	Futures	1413.42	1414.18	1409.12	1410.13	36856.0
2012-03-26 04:00:00	ES	Futures	1410.39	1413.17	1409.12	1410.64	33771.0
2012-03-26 05:00:00	ES	Futures	1410.39	1413.17	1409.63	1412.92	18201.0
2012-03-26 06:00:00	ES	Futures	1412.92	1415.45	1412.16	1413.93	24680.0
2012-03-26 07:00:00	ES	Futures	1413.93	1416.46	1413.93	1414.69	32352.0
2012-03-26 08:00:00	ES	Futures	1414.69	1420.51	1414.44	1418.99	86856.0
2012-03-26 09:00:00	ES	Futures	1419.24	1420.51	1417.98	1420.0	153893.0
2012-03-26 10:00:00	ES	Futures	1420.0	1423.54	1419.24	1422.28	194228.0
2012-03-26 11:00:00	ES	Futures	1422.28	1422.53	1421.01	1421.52	148593.0
2012-03-26 12:00:00	ES	Futures	1421.52	1421.77	1420.0	1420.51	86764.0
2012-03-26 13:00:00	ES	Futures	1420.25	1422.78	1420.25	1422.28	41908.0
2012-03-26 14:00:00	ES	Futures	1422.28	1425.82	1422.03	1424.81	108038.0
2012-03-26 15:00:00	ES	Futures	1424.81	1428.1	1424.3	1428.1	284337.0
2012-03-26 16:00:00	ES	Futures	1428.1	1432.4	1427.84	1431.64	173324.0
2012-03-26 17:00:00	ES	Futures	1431.39	1432.9	1431.13	1432.4	6095.0
2012-03-26 18:00:00	ES	Futures	1431.89	1433.16	1431.64	1432.65	5735.0
2012-03-26 19:00:00	ES	Futures	1432.65	1433.16	1432.14	1432.4	3333.0
2012-03-26 20:00:00	ES	Futures	1432.4	1432.9	1431.64	1431.89	4752.0
2012-03-26 21:00:00	ES	Futures	1431.89	1432.9	1431.39	1432.4	4116.0
2012-03-26 22:00:00	ES	Futures	1432.14	1433.66	1431.89	1432.14	4267.0
2012-03-26 23:00:00	ES	Futures	1432.14	1432.4	1431.39	1431.89	3173.0
2012-03-26 00:00:00	NQ	Futures	3167.32	3167.32	3163.56	3164.14	361.0
2012-03-26 01:00:00	NQ	Futures	3163.85	3165.01	3162.41	3163.28	240.0
2012-03-26 02:00:00	NQ	Futures	3163.28	3168.77	3162.7	3167.04	798.0
2012-03-26 03:00:00	NQ	Futures	3167.04	3168.48	3159.52	3162.41	3635.0
2012-03-26 04:00:00	NQ	Futures	3162.41	3168.48	3159.52	3163.28	4401.0
2012-03-26 05:00:00	NQ	Futures	3163.28	3167.9	3160.67	3167.04	1642.0
2012-03-26 06:00:00	NQ	Futures	3167.04	3171.08	3165.59	3169.35	2778.0
2012-03-26 07:00:00	NQ	Futures	3169.06	3175.13	3168.77	3170.51	3079.0
2012-03-26 08:00:00	NQ	Futures	3170.51	3180.92	3169.93	3176.87	9730.0
2012-03-26 09:00:00	NQ	Futures	3177.16	3179.18	3172.53	3177.45	29797.0
2012-03-26 10:00:00	NQ	Futures	3177.74	3185.25	3175.42	3184.68	28962.0
2012-03-26 11:00:00	NQ	Futures	3184.39	3189.3	3182.36	3187.57	18916.0
2012-03-26 12:00:00	NQ	Futures	3187.28	3188.44	3184.1	3186.7	9644.0
2012-03-26 13:00:00	NQ	Futures	3186.99	3195.96	3185.83	3194.51	12866.0
2012-03-26 14:00:00	NQ	Futures	3194.51	3202.61	3193.93	3200.0	22121.0
2012-03-26 15:00:00	NQ	Futures	3200.0	3209.26	3198.56	3208.68	38143.0
2012-03-26 16:00:00	NQ	Futures	3208.68	3213.6	3208.39	3212.15	11942.0
2012-03-26 17:00:00	NQ	Futures	3211.86	3214.75	3211.57	3213.6	381.0
2012-03-26 18:00:00	NQ	Futures	3213.02	3215.33	3212.15	3214.75	447.0
2012-03-26 19:00:00	NQ	Futures	3214.46	3215.04	3213.31	3214.17	180.0
2012-03-26 20:00:00	NQ	Futures	3214.17	3215.04	3213.02	3213.6	428.0
2012-03-26 21:00:00	NQ	Futures	3213.6	3215.33	3213.31	3213.89	343.0
2012-03-26 22:00:00	NQ	Futures	3213.89	3217.65	3213.31	3214.17	458.0
2012-03-26 23:00:00	NQ	Futures	3214.17	3214.17	3212.15	3213.02	176.0
2012-03-26 00:00:00	YM	Futures	13008.7	13008.7	12989.8	12990.8	262.0
2012-03-26 01:00:00	YM	Futures	12990.8	12995.7	12988.8	12991.7	213.0

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

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