PREVIEW / futures_1hour / 2012-10-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-15.parquet
  size:    47 KB
  rows:    1,479

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-15 00:00:00	ES	Futures	1451.54	1453.08	1451.29	1452.31	4240.0
2012-10-15 01:00:00	ES	Futures	1452.31	1453.59	1451.8	1453.33	4377.0
2012-10-15 02:00:00	ES	Futures	1453.59	1455.38	1452.06	1454.61	8421.0
2012-10-15 03:00:00	ES	Futures	1454.35	1459.72	1454.1	1458.19	43796.0
2012-10-15 04:00:00	ES	Futures	1458.44	1459.46	1457.68	1458.44	18251.0
2012-10-15 05:00:00	ES	Futures	1458.7	1460.23	1457.93	1459.21	15631.0
2012-10-15 06:00:00	ES	Futures	1459.46	1459.72	1457.93	1459.21	13276.0
2012-10-15 07:00:00	ES	Futures	1459.46	1459.98	1458.7	1459.98	18465.0
2012-10-15 08:00:00	ES	Futures	1459.72	1461.51	1457.68	1458.44	53394.0
2012-10-15 09:00:00	ES	Futures	1458.44	1459.46	1454.87	1456.4	165075.0
2012-10-15 10:00:00	ES	Futures	1456.4	1458.19	1453.08	1455.63	231346.0
2012-10-15 11:00:00	ES	Futures	1455.38	1462.53	1454.61	1460.74	255922.0
2012-10-15 12:00:00	ES	Futures	1460.49	1465.34	1459.98	1463.81	168702.0
2012-10-15 13:00:00	ES	Futures	1463.81	1465.6	1462.53	1463.55	64790.0
2012-10-15 14:00:00	ES	Futures	1463.81	1464.83	1460.49	1461.76	90335.0
2012-10-15 15:00:00	ES	Futures	1461.76	1467.89	1461.25	1466.36	236228.0
2012-10-15 16:00:00	ES	Futures	1466.36	1467.89	1465.85	1467.13	81408.0
2012-10-15 17:00:00	ES	Futures	1467.13	1467.64	1466.62	1467.13	998.0
2012-10-15 18:00:00	ES	Futures	1466.87	1468.66	1466.36	1468.41	5424.0
2012-10-15 19:00:00	ES	Futures	1468.15	1469.43	1467.64	1469.43	5489.0
2012-10-15 20:00:00	ES	Futures	1468.92	1469.43	1467.13	1467.38	6057.0
2012-10-15 21:00:00	ES	Futures	1467.13	1467.64	1465.85	1467.13	5706.0
2012-10-15 22:00:00	ES	Futures	1467.13	1468.41	1466.62	1468.41	2699.0
2012-10-15 23:00:00	ES	Futures	1468.41	1469.17	1468.15	1469.17	3264.0
2012-10-15 00:00:00	NQ	Futures	3151.59	3155.08	3151.3	3152.75	642.0
2012-10-15 01:00:00	NQ	Futures	3152.75	3155.37	3151.88	3155.08	347.0
2012-10-15 02:00:00	NQ	Futures	3155.37	3159.15	3151.88	3157.69	836.0
2012-10-15 03:00:00	NQ	Futures	3157.69	3170.77	3157.69	3168.15	4159.0
2012-10-15 04:00:00	NQ	Futures	3167.86	3170.48	3166.7	3168.15	1448.0
2012-10-15 05:00:00	NQ	Futures	3167.57	3172.8	3166.99	3170.48	1259.0
2012-10-15 06:00:00	NQ	Futures	3170.48	3171.06	3167.28	3169.32	1254.0
2012-10-15 07:00:00	NQ	Futures	3169.9	3171.64	3168.44	3170.19	1797.0
2012-10-15 08:00:00	NQ	Futures	3170.48	3172.8	3166.12	3166.12	6511.0
2012-10-15 09:00:00	NQ	Futures	3166.12	3171.06	3156.82	3160.6	29818.0
2012-10-15 10:00:00	NQ	Futures	3160.6	3163.51	3146.07	3150.14	36932.0
2012-10-15 11:00:00	NQ	Futures	3149.85	3169.9	3147.23	3163.21	33880.0
2012-10-15 12:00:00	NQ	Futures	3162.92	3172.22	3160.02	3167.57	21562.0
2012-10-15 13:00:00	NQ	Futures	3167.57	3171.93	3161.47	3164.09	14091.0
2012-10-15 14:00:00	NQ	Futures	3163.8	3168.44	3158.27	3162.63	14407.0
2012-10-15 15:00:00	NQ	Futures	3162.63	3180.36	3161.18	3176.29	33108.0
2012-10-15 16:00:00	NQ	Futures	3176.0	3177.16	3173.68	3175.42	9294.0
2012-10-15 17:00:00	NQ	Futures	3175.71	3176.0	3174.55	3175.13	105.0
2012-10-15 18:00:00	NQ	Futures	3175.71	3177.45	3173.97	3177.16	647.0
2012-10-15 19:00:00	NQ	Futures	3177.16	3180.94	3175.42	3180.36	799.0
2012-10-15 20:00:00	NQ	Futures	3180.07	3180.65	3176.0	3176.58	956.0
2012-10-15 21:00:00	NQ	Futures	3176.58	3177.45	3172.8	3175.13	641.0
2012-10-15 22:00:00	NQ	Futures	3174.84	3178.91	3174.26	3178.32	267.0
2012-10-15 23:00:00	NQ	Futures	3178.03	3180.07	3178.03	3179.49	502.0
2012-10-15 00:00:00	YM	Futures	13243.8	13254.8	13242.8	13248.8	618.0
2012-10-15 01:00:00	YM	Futures	13250.8	13256.8	13245.8	13254.8	374.0

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

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