PREVIEW / futures_1hour / 2011-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-16.parquet
  size:    49 KB
  rows:    1,487

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
2011-06-16 00:00:00	ES	Futures	1260.25	1261.24	1257.75	1258.0	7314.0
2011-06-16 01:00:00	ES	Futures	1258.0	1259.0	1255.26	1256.75	11943.0
2011-06-16 02:00:00	ES	Futures	1256.51	1257.5	1254.51	1257.5	20562.0
2011-06-16 03:00:00	ES	Futures	1257.25	1259.0	1254.51	1258.75	37200.0
2011-06-16 04:00:00	ES	Futures	1258.75	1261.24	1257.75	1258.75	35720.0
2011-06-16 05:00:00	ES	Futures	1258.75	1259.25	1253.26	1256.01	48638.0
2011-06-16 06:00:00	ES	Futures	1255.76	1257.0	1253.51	1256.26	41082.0
2011-06-16 07:00:00	ES	Futures	1256.26	1257.5	1250.77	1251.02	57930.0
2011-06-16 08:00:00	ES	Futures	1251.02	1258.5	1250.52	1258.0	137996.0
2011-06-16 09:00:00	ES	Futures	1258.0	1261.49	1255.26	1258.75	336736.0
2011-06-16 10:00:00	ES	Futures	1258.75	1264.98	1252.76	1262.74	558371.0
2011-06-16 11:00:00	ES	Futures	1262.74	1265.98	1259.0	1262.24	399292.0
2011-06-16 12:00:00	ES	Futures	1262.24	1264.74	1261.74	1261.74	152292.0
2011-06-16 13:00:00	ES	Futures	1261.74	1263.24	1254.76	1254.76	251333.0
2011-06-16 14:00:00	ES	Futures	1254.76	1256.51	1249.27	1253.51	334618.0
2011-06-16 15:00:00	ES	Futures	1253.26	1260.25	1252.76	1259.0	432485.0
2011-06-16 16:00:00	ES	Futures	1259.25	1262.49	1258.5	1261.74	110853.0
2011-06-16 17:00:00	ES	Futures	1261.99	1262.24	1260.99	1261.24	4496.0
2011-06-16 18:00:00	ES	Futures	1261.49	1264.24	1261.24	1263.74	6644.0
2011-06-16 19:00:00	ES	Futures	1263.99	1265.23	1263.49	1264.49	5119.0
2011-06-16 20:00:00	ES	Futures	1264.74	1265.23	1263.24	1263.74	6328.0
2011-06-16 21:00:00	ES	Futures	1263.74	1264.74	1262.24	1263.24	4243.0
2011-06-16 22:00:00	ES	Futures	1262.99	1263.24	1261.24	1262.49	4639.0
2011-06-16 23:00:00	ES	Futures	1262.24	1262.99	1261.74	1261.99	3146.0
2011-06-16 00:00:00	NQ	Futures	2545.57	2548.45	2539.24	2539.53	1827.0
2011-06-16 01:00:00	NQ	Futures	2539.82	2541.54	2531.76	2535.21	2148.0
2011-06-16 02:00:00	NQ	Futures	2535.21	2537.23	2531.76	2536.65	1301.0
2011-06-16 03:00:00	NQ	Futures	2536.65	2540.68	2531.47	2540.68	2919.0
2011-06-16 04:00:00	NQ	Futures	2540.39	2544.42	2538.67	2540.1	2847.0
2011-06-16 05:00:00	NQ	Futures	2540.1	2540.39	2529.17	2535.21	4409.0
2011-06-16 06:00:00	NQ	Futures	2534.92	2537.23	2530.9	2536.36	3604.0
2011-06-16 07:00:00	NQ	Futures	2536.08	2537.8	2527.44	2528.31	3270.0
2011-06-16 08:00:00	NQ	Futures	2528.02	2541.83	2526.87	2540.68	8257.0
2011-06-16 09:00:00	NQ	Futures	2540.39	2542.98	2533.77	2538.95	38537.0
2011-06-16 10:00:00	NQ	Futures	2539.53	2547.3	2530.03	2542.12	60640.0
2011-06-16 11:00:00	NQ	Futures	2542.41	2547.3	2536.36	2540.39	33810.0
2011-06-16 12:00:00	NQ	Futures	2540.1	2543.56	2539.53	2540.39	17997.0
2011-06-16 13:00:00	NQ	Futures	2540.39	2541.83	2527.44	2527.44	30263.0
2011-06-16 14:00:00	NQ	Futures	2527.44	2529.74	2505.28	2514.49	56295.0
2011-06-16 15:00:00	NQ	Futures	2514.49	2529.74	2513.34	2527.44	51121.0
2011-06-16 16:00:00	NQ	Futures	2527.44	2530.32	2525.14	2529.17	9841.0
2011-06-16 17:00:00	NQ	Futures	2529.46	2530.61	2528.31	2528.88	462.0
2011-06-16 18:00:00	NQ	Futures	2529.17	2534.06	2529.17	2533.49	475.0
2011-06-16 19:00:00	NQ	Futures	2533.49	2536.65	2532.33	2535.21	572.0
2011-06-16 20:00:00	NQ	Futures	2534.92	2536.08	2532.91	2533.49	599.0
2011-06-16 21:00:00	NQ	Futures	2533.77	2535.79	2530.9	2532.33	226.0
2011-06-16 22:00:00	NQ	Futures	2532.62	2533.2	2529.17	2531.76	390.0
2011-06-16 23:00:00	NQ	Futures	2531.18	2532.91	2530.9	2531.18	228.0
2011-06-16 00:00:00	YM	Futures	11475.5	11479.4	11451.3	11454.2	560.0
2011-06-16 01:00:00	YM	Futures	11454.2	11463.9	11430.0	11445.5	826.0

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

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