PREVIEW / futures_1hour / 2009-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-04.parquet
  size:    45 KB
  rows:    1,282

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
2009-03-04 00:00:00	ES	Futures	659.85	661.98	659.38	661.27	6219.0
2009-03-04 01:00:00	ES	Futures	661.27	662.46	660.8	661.75	4284.0
2009-03-04 02:00:00	ES	Futures	661.75	665.78	661.27	665.07	17228.0
2009-03-04 03:00:00	ES	Futures	665.07	666.02	662.93	663.88	27939.0
2009-03-04 04:00:00	ES	Futures	663.88	669.34	663.64	668.15	28400.0
2009-03-04 05:00:00	ES	Futures	667.91	668.63	665.3	666.97	16406.0
2009-03-04 06:00:00	ES	Futures	666.97	667.2	664.83	667.2	13263.0
2009-03-04 07:00:00	ES	Futures	666.97	667.2	662.93	663.64	40493.0
2009-03-04 08:00:00	ES	Futures	663.64	671.0	661.75	670.52	92835.0
2009-03-04 09:00:00	ES	Futures	670.52	674.08	666.97	667.68	371210.0
2009-03-04 10:00:00	ES	Futures	667.91	673.13	663.17	670.52	493821.0
2009-03-04 11:00:00	ES	Futures	670.76	677.88	670.52	676.45	337032.0
2009-03-04 12:00:00	ES	Futures	676.45	677.4	669.1	671.0	260009.0
2009-03-04 13:00:00	ES	Futures	671.0	675.03	668.15	671.95	244561.0
2009-03-04 14:00:00	ES	Futures	671.95	682.86	670.76	682.15	392802.0
2009-03-04 15:00:00	ES	Futures	682.15	686.65	674.56	675.98	590988.0
2009-03-04 16:00:00	ES	Futures	675.74	675.98	670.52	673.37	157766.0
2009-03-04 17:00:00	ES	Futures	673.37	674.08	672.89	673.61	3322.0
2009-03-04 18:00:00	ES	Futures	673.61	674.08	671.71	672.18	9150.0
2009-03-04 19:00:00	ES	Futures	672.18	675.27	671.23	672.66	6685.0
2009-03-04 20:00:00	ES	Futures	672.66	675.27	672.18	673.61	4732.0
2009-03-04 21:00:00	ES	Futures	673.37	673.37	666.49	666.97	11108.0
2009-03-04 22:00:00	ES	Futures	666.97	668.63	666.25	666.49	7616.0
2009-03-04 23:00:00	ES	Futures	666.25	668.86	666.02	668.39	4016.0
2009-03-04 00:00:00	NQ	Futures	1217.91	1223.56	1217.91	1222.71	518.0
2009-03-04 01:00:00	NQ	Futures	1222.71	1225.53	1222.71	1224.4	453.0
2009-03-04 02:00:00	NQ	Futures	1224.4	1229.2	1224.4	1228.92	719.0
2009-03-04 03:00:00	NQ	Futures	1228.07	1230.33	1224.12	1226.38	1386.0
2009-03-04 04:00:00	NQ	Futures	1226.38	1233.44	1225.53	1232.59	1592.0
2009-03-04 05:00:00	NQ	Futures	1232.59	1232.87	1227.23	1230.61	888.0
2009-03-04 06:00:00	NQ	Futures	1230.05	1230.33	1226.38	1228.92	925.0
2009-03-04 07:00:00	NQ	Futures	1228.92	1230.05	1221.58	1225.25	3587.0
2009-03-04 08:00:00	NQ	Futures	1225.25	1238.8	1223.27	1237.67	7946.0
2009-03-04 09:00:00	NQ	Futures	1237.67	1247.56	1233.72	1240.22	58479.0
2009-03-04 10:00:00	NQ	Futures	1240.22	1253.77	1236.83	1250.38	62266.0
2009-03-04 11:00:00	NQ	Futures	1250.38	1261.68	1250.38	1258.85	51044.0
2009-03-04 12:00:00	NQ	Futures	1259.14	1260.83	1248.97	1251.23	38875.0
2009-03-04 13:00:00	NQ	Futures	1250.95	1258.85	1245.58	1253.21	36692.0
2009-03-04 14:00:00	NQ	Futures	1253.21	1267.89	1252.08	1266.48	60094.0
2009-03-04 15:00:00	NQ	Futures	1266.19	1270.71	1250.66	1252.36	78174.0
2009-03-04 16:00:00	NQ	Futures	1252.36	1267.61	1243.32	1248.69	18445.0
2009-03-04 17:00:00	NQ	Futures	1248.69	1250.1	1248.12	1248.69	166.0
2009-03-04 18:00:00	NQ	Futures	1247.84	1250.66	1246.43	1247.28	238.0
2009-03-04 19:00:00	NQ	Futures	1246.99	1251.79	1245.02	1248.69	206.0
2009-03-04 20:00:00	NQ	Futures	1248.12	1252.64	1248.12	1248.12	112.0
2009-03-04 21:00:00	NQ	Futures	1248.4	1248.97	1237.11	1238.24	612.0
2009-03-04 22:00:00	NQ	Futures	1237.96	1241.63	1237.11	1237.39	305.0
2009-03-04 23:00:00	NQ	Futures	1237.11	1242.47	1236.83	1241.35	127.0
2009-03-04 00:00:00	YM	Futures	6120.1	6137.4	6120.1	6133.8	366.0
2009-03-04 01:00:00	YM	Futures	6133.8	6144.7	6130.1	6140.2	367.0

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

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