PREVIEW / futures_1hour / 2012-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-30.parquet
  size:    47 KB
  rows:    1,450

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-30 00:00:00	ES	Futures	1416.97	1417.47	1416.46	1416.97	1222.0
2012-04-30 01:00:00	ES	Futures	1416.71	1417.72	1416.46	1417.22	1252.0
2012-04-30 02:00:00	ES	Futures	1416.97	1419.24	1416.46	1418.74	5839.0
2012-04-30 03:00:00	ES	Futures	1418.48	1418.74	1414.94	1415.19	27325.0
2012-04-30 04:00:00	ES	Futures	1414.94	1416.46	1413.68	1415.19	26720.0
2012-04-30 05:00:00	ES	Futures	1415.45	1415.95	1413.42	1413.93	17564.0
2012-04-30 06:00:00	ES	Futures	1413.93	1414.44	1412.41	1413.93	14732.0
2012-04-30 07:00:00	ES	Futures	1414.18	1414.44	1411.15	1411.65	22621.0
2012-04-30 08:00:00	ES	Futures	1411.65	1413.17	1410.39	1412.66	57441.0
2012-04-30 09:00:00	ES	Futures	1412.92	1413.68	1408.11	1408.87	245601.0
2012-04-30 10:00:00	ES	Futures	1408.62	1412.16	1407.6	1408.62	267046.0
2012-04-30 11:00:00	ES	Futures	1408.87	1410.13	1407.86	1409.88	133863.0
2012-04-30 12:00:00	ES	Futures	1409.63	1410.39	1408.36	1409.38	63414.0
2012-04-30 13:00:00	ES	Futures	1409.12	1410.13	1407.86	1408.87	71169.0
2012-04-30 14:00:00	ES	Futures	1409.12	1409.38	1406.34	1407.86	90608.0
2012-04-30 15:00:00	ES	Futures	1408.11	1410.89	1407.6	1409.63	152094.0
2012-04-30 16:00:00	ES	Futures	1409.38	1412.16	1408.62	1411.91	104957.0
2012-04-30 17:00:00	ES	Futures	1411.91	1412.41	1411.15	1412.41	2480.0
2012-04-30 18:00:00	ES	Futures	1411.91	1412.41	1411.65	1411.91	1963.0
2012-04-30 19:00:00	ES	Futures	1411.91	1412.16	1411.65	1411.91	1604.0
2012-04-30 20:00:00	ES	Futures	1411.91	1412.16	1410.89	1411.15	4756.0
2012-04-30 21:00:00	ES	Futures	1411.15	1412.92	1410.64	1412.41	4645.0
2012-04-30 22:00:00	ES	Futures	1412.41	1412.66	1412.16	1412.16	1455.0
2012-04-30 23:00:00	ES	Futures	1412.16	1412.66	1411.65	1411.65	1510.0
2012-04-30 00:00:00	NQ	Futures	3170.79	3171.08	3169.93	3170.22	112.0
2012-04-30 01:00:00	NQ	Futures	3170.22	3171.66	3168.77	3169.64	316.0
2012-04-30 02:00:00	NQ	Futures	3169.35	3174.27	3169.35	3172.82	542.0
2012-04-30 03:00:00	NQ	Futures	3172.53	3173.11	3165.3	3165.59	2137.0
2012-04-30 04:00:00	NQ	Futures	3165.3	3168.19	3162.12	3166.17	1456.0
2012-04-30 05:00:00	NQ	Futures	3166.17	3167.04	3161.25	3163.85	1197.0
2012-04-30 06:00:00	NQ	Futures	3163.28	3165.01	3160.67	3163.85	1446.0
2012-04-30 07:00:00	NQ	Futures	3163.56	3165.3	3153.15	3153.44	4062.0
2012-04-30 08:00:00	NQ	Futures	3153.73	3158.94	3152.0	3158.36	6360.0
2012-04-30 09:00:00	NQ	Futures	3158.36	3162.99	3145.63	3147.66	50858.0
2012-04-30 10:00:00	NQ	Futures	3147.66	3153.15	3143.32	3149.97	41912.0
2012-04-30 11:00:00	NQ	Futures	3149.68	3154.31	3143.9	3154.02	17769.0
2012-04-30 12:00:00	NQ	Futures	3154.02	3154.31	3146.5	3149.1	14728.0
2012-04-30 13:00:00	NQ	Futures	3149.1	3151.13	3145.92	3150.84	7519.0
2012-04-30 14:00:00	NQ	Futures	3151.13	3151.71	3141.3	3144.19	17755.0
2012-04-30 15:00:00	NQ	Futures	3143.9	3148.53	3141.59	3144.48	21205.0
2012-04-30 16:00:00	NQ	Futures	3144.48	3147.66	3141.59	3146.79	7046.0
2012-04-30 17:00:00	NQ	Futures	3147.08	3147.37	3144.19	3147.37	345.0
2012-04-30 18:00:00	NQ	Futures	3146.79	3147.37	3146.21	3146.79	341.0
2012-04-30 19:00:00	NQ	Futures	3146.79	3147.66	3146.79	3147.08	232.0
2012-04-30 20:00:00	NQ	Futures	3147.08	3147.37	3144.19	3144.19	346.0
2012-04-30 21:00:00	NQ	Futures	3144.48	3148.53	3144.19	3147.66	310.0
2012-04-30 22:00:00	NQ	Futures	3147.37	3148.82	3147.08	3147.37	154.0
2012-04-30 23:00:00	NQ	Futures	3147.66	3148.53	3146.21	3146.79	142.0
2012-04-30 00:00:00	YM	Futures	13133.2	13136.2	13129.2	13133.2	102.0
2012-04-30 01:00:00	YM	Futures	13133.2	13138.2	13132.2	13134.2	72.0

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

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