PREVIEW / futures_1hour / 2012-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-28.parquet
  size:    42 KB
  rows:    1,207

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-09-28 00:00:00	ES	Futures	1473.0	1474.03	1473.0	1473.51	1324.0
2012-09-28 01:00:00	ES	Futures	1473.77	1474.79	1472.49	1474.54	4117.0
2012-09-28 02:00:00	ES	Futures	1474.54	1474.54	1473.26	1473.26	6299.0
2012-09-28 03:00:00	ES	Futures	1473.26	1474.28	1471.73	1472.75	24637.0
2012-09-28 04:00:00	ES	Futures	1472.49	1473.26	1471.98	1473.26	16350.0
2012-09-28 05:00:00	ES	Futures	1473.26	1474.03	1470.96	1471.22	16844.0
2012-09-28 06:00:00	ES	Futures	1471.22	1471.47	1466.87	1467.64	40543.0
2012-09-28 07:00:00	ES	Futures	1467.38	1468.15	1466.62	1467.64	34366.0
2012-09-28 08:00:00	ES	Futures	1467.89	1467.89	1463.3	1465.85	94589.0
2012-09-28 09:00:00	ES	Futures	1466.11	1467.38	1461.0	1462.53	270011.0
2012-09-28 10:00:00	ES	Futures	1462.27	1465.08	1460.23	1463.3	293431.0
2012-09-28 11:00:00	ES	Futures	1463.3	1464.57	1460.49	1463.81	224032.0
2012-09-28 12:00:00	ES	Futures	1464.06	1468.92	1463.3	1466.87	202848.0
2012-09-28 13:00:00	ES	Futures	1466.87	1471.47	1464.57	1469.68	141335.0
2012-09-28 14:00:00	ES	Futures	1469.68	1470.7	1465.34	1466.62	129561.0
2012-09-28 15:00:00	ES	Futures	1466.87	1468.92	1462.79	1464.83	417987.0
2012-09-28 16:00:00	ES	Futures	1464.83	1467.89	1464.57	1465.6	137306.0
2012-09-28 00:00:00	NQ	Futures	3270.15	3271.89	3269.57	3271.31	214.0
2012-09-28 01:00:00	NQ	Futures	3271.6	3273.92	3269.27	3273.34	558.0
2012-09-28 02:00:00	NQ	Futures	3273.34	3273.92	3271.6	3271.6	892.0
2012-09-28 03:00:00	NQ	Futures	3271.89	3276.83	3269.57	3272.18	3449.0
2012-09-28 04:00:00	NQ	Futures	3272.18	3276.25	3271.02	3276.25	2139.0
2012-09-28 05:00:00	NQ	Futures	3276.25	3276.83	3268.69	3269.27	1624.0
2012-09-28 06:00:00	NQ	Futures	3268.98	3269.86	3260.85	3262.01	3423.0
2012-09-28 07:00:00	NQ	Futures	3261.72	3264.04	3260.56	3263.17	2378.0
2012-09-28 08:00:00	NQ	Futures	3263.46	3263.46	3255.62	3261.43	8272.0
2012-09-28 09:00:00	NQ	Futures	3261.14	3270.44	3249.52	3253.0	40125.0
2012-09-28 10:00:00	NQ	Futures	3253.0	3262.3	3242.54	3251.55	43810.0
2012-09-28 11:00:00	NQ	Futures	3251.55	3254.16	3241.38	3250.97	28155.0
2012-09-28 12:00:00	NQ	Futures	3250.97	3262.59	3248.93	3257.36	21645.0
2012-09-28 13:00:00	NQ	Futures	3257.36	3267.24	3251.26	3261.14	18328.0
2012-09-28 14:00:00	NQ	Futures	3261.14	3264.34	3247.77	3253.87	17603.0
2012-09-28 15:00:00	NQ	Futures	3253.87	3257.07	3242.54	3245.16	36213.0
2012-09-28 16:00:00	NQ	Futures	3244.87	3248.35	3243.7	3244.29	9567.0
2012-09-28 00:00:00	YM	Futures	13421.9	13428.9	13418.9	13424.9	227.0
2012-09-28 01:00:00	YM	Futures	13425.9	13431.9	13417.9	13430.9	403.0
2012-09-28 02:00:00	YM	Futures	13430.9	13430.9	13419.9	13419.9	350.0
2012-09-28 03:00:00	YM	Futures	13420.9	13430.9	13410.9	13417.9	1814.0
2012-09-28 04:00:00	YM	Futures	13417.9	13425.9	13413.9	13424.9	1533.0
2012-09-28 05:00:00	YM	Futures	13424.9	13428.9	13404.9	13407.9	1480.0
2012-09-28 06:00:00	YM	Futures	13406.9	13407.9	13366.9	13371.9	3106.0
2012-09-28 07:00:00	YM	Futures	13370.9	13375.9	13362.9	13368.9	3166.0
2012-09-28 08:00:00	YM	Futures	13368.9	13368.9	13334.9	13358.9	8134.0
2012-09-28 09:00:00	YM	Futures	13358.9	13365.9	13302.8	13311.9	21987.0
2012-09-28 10:00:00	YM	Futures	13310.9	13339.9	13299.8	13329.9	24522.0
2012-09-28 11:00:00	YM	Futures	13329.9	13353.9	13313.9	13349.9	15083.0
2012-09-28 12:00:00	YM	Futures	13349.9	13391.9	13345.9	13368.9	15300.0
2012-09-28 13:00:00	YM	Futures	13368.9	13412.9	13351.9	13391.9	10945.0
2012-09-28 14:00:00	YM	Futures	13391.9	13400.9	13361.9	13371.9	8845.0
2012-09-28 15:00:00	YM	Futures	13371.9	13392.9	13332.9	13368.9	22377.0

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

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