PREVIEW / futures_1hour / 2012-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-04.parquet
  size:    49 KB
  rows:    1,489

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-04-04 00:00:00	ES	Futures	1420.0	1421.27	1419.75	1420.0	3820.0
2012-04-04 01:00:00	ES	Futures	1420.25	1420.76	1419.24	1420.0	5412.0
2012-04-04 02:00:00	ES	Futures	1420.0	1421.01	1419.24	1420.76	7592.0
2012-04-04 03:00:00	ES	Futures	1420.76	1421.27	1417.22	1417.72	44532.0
2012-04-04 04:00:00	ES	Futures	1417.72	1418.99	1414.18	1414.94	53289.0
2012-04-04 05:00:00	ES	Futures	1414.69	1415.7	1413.42	1414.94	36025.0
2012-04-04 06:00:00	ES	Futures	1414.94	1416.21	1413.17	1414.18	33871.0
2012-04-04 07:00:00	ES	Futures	1414.18	1415.95	1412.16	1414.69	44294.0
2012-04-04 08:00:00	ES	Futures	1414.94	1416.21	1412.16	1413.17	80077.0
2012-04-04 09:00:00	ES	Futures	1413.42	1415.19	1411.91	1414.69	179157.0
2012-04-04 10:00:00	ES	Futures	1414.69	1414.69	1405.58	1405.83	429729.0
2012-04-04 11:00:00	ES	Futures	1405.83	1410.64	1405.83	1408.87	273942.0
2012-04-04 12:00:00	ES	Futures	1408.62	1410.39	1407.86	1408.62	82897.0
2012-04-04 13:00:00	ES	Futures	1408.36	1409.63	1405.08	1409.38	103833.0
2012-04-04 14:00:00	ES	Futures	1409.12	1411.91	1407.1	1410.64	113156.0
2012-04-04 15:00:00	ES	Futures	1410.89	1413.17	1409.88	1410.64	206944.0
2012-04-04 16:00:00	ES	Futures	1410.64	1411.15	1408.87	1409.38	99232.0
2012-04-04 17:00:00	ES	Futures	1409.12	1409.38	1407.6	1408.11	2813.0
2012-04-04 18:00:00	ES	Futures	1408.11	1410.13	1408.11	1409.63	5562.0
2012-04-04 19:00:00	ES	Futures	1409.63	1410.39	1409.38	1409.63	2547.0
2012-04-04 20:00:00	ES	Futures	1409.63	1410.89	1409.12	1410.64	7143.0
2012-04-04 21:00:00	ES	Futures	1410.64	1410.89	1407.35	1408.36	10948.0
2012-04-04 22:00:00	ES	Futures	1408.36	1411.15	1407.86	1410.39	6105.0
2012-04-04 23:00:00	ES	Futures	1410.39	1411.91	1410.39	1411.65	5240.0
2012-04-04 00:00:00	NQ	Futures	3203.76	3206.37	3202.03	3202.32	1258.0
2012-04-04 01:00:00	NQ	Futures	3202.61	3204.05	3202.03	3203.19	480.0
2012-04-04 02:00:00	NQ	Futures	3203.19	3205.79	3202.32	3204.34	385.0
2012-04-04 03:00:00	NQ	Futures	3204.63	3206.08	3196.53	3198.27	3657.0
2012-04-04 04:00:00	NQ	Futures	3198.27	3201.74	3191.33	3192.77	3310.0
2012-04-04 05:00:00	NQ	Futures	3192.77	3193.93	3189.01	3193.06	3139.0
2012-04-04 06:00:00	NQ	Futures	3192.2	3197.11	3188.44	3192.48	3989.0
2012-04-04 07:00:00	NQ	Futures	3192.2	3194.51	3186.41	3192.77	2766.0
2012-04-04 08:00:00	NQ	Futures	3192.77	3196.53	3188.73	3189.3	7447.0
2012-04-04 09:00:00	NQ	Futures	3189.3	3192.2	3182.36	3187.57	35056.0
2012-04-04 10:00:00	NQ	Futures	3186.99	3187.86	3158.07	3158.94	64116.0
2012-04-04 11:00:00	NQ	Futures	3158.65	3166.75	3158.36	3161.25	30839.0
2012-04-04 12:00:00	NQ	Futures	3161.25	3165.3	3158.65	3159.81	30472.0
2012-04-04 13:00:00	NQ	Futures	3159.81	3161.54	3152.0	3160.67	19713.0
2012-04-04 14:00:00	NQ	Futures	3160.67	3168.19	3157.2	3163.85	19741.0
2012-04-04 15:00:00	NQ	Futures	3163.85	3176.58	3161.83	3170.79	34182.0
2012-04-04 16:00:00	NQ	Futures	3170.51	3170.79	3165.3	3166.75	9786.0
2012-04-04 17:00:00	NQ	Futures	3166.17	3166.17	3162.99	3163.85	143.0
2012-04-04 18:00:00	NQ	Futures	3164.14	3168.48	3164.14	3167.61	163.0
2012-04-04 19:00:00	NQ	Futures	3167.61	3169.64	3167.04	3167.32	237.0
2012-04-04 20:00:00	NQ	Futures	3167.61	3169.64	3166.17	3168.77	509.0
2012-04-04 21:00:00	NQ	Futures	3169.06	3169.35	3162.12	3164.14	866.0
2012-04-04 22:00:00	NQ	Futures	3163.85	3171.08	3163.28	3169.06	659.0
2012-04-04 23:00:00	NQ	Futures	3169.35	3173.11	3169.35	3171.66	796.0
2012-04-04 00:00:00	YM	Futures	13040.6	13049.5	13039.6	13041.6	168.0
2012-04-04 01:00:00	YM	Futures	13041.6	13045.5	13036.6	13041.6	302.0

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

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