PREVIEW / futures_1hour / 2009-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-30.parquet
  size:    37 KB
  rows:    1,041

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-01-30 00:00:00	ES	Futures	804.06	804.77	803.82	804.77	2597.0
2009-01-30 01:00:00	ES	Futures	804.77	805.48	804.06	804.77	3250.0
2009-01-30 02:00:00	ES	Futures	804.77	805.24	801.92	803.11	10451.0
2009-01-30 03:00:00	ES	Futures	803.35	804.53	798.6	804.06	25737.0
2009-01-30 04:00:00	ES	Futures	804.06	805.01	801.69	802.16	10085.0
2009-01-30 05:00:00	ES	Futures	802.4	803.35	798.84	802.64	10451.0
2009-01-30 06:00:00	ES	Futures	802.87	803.11	797.89	798.37	10037.0
2009-01-30 07:00:00	ES	Futures	798.37	798.37	790.3	791.01	37193.0
2009-01-30 08:00:00	ES	Futures	791.25	803.11	791.01	801.45	131120.0
2009-01-30 09:00:00	ES	Futures	801.45	804.77	795.05	795.28	215548.0
2009-01-30 10:00:00	ES	Futures	795.05	796.23	786.03	788.88	364070.0
2009-01-30 11:00:00	ES	Futures	788.88	791.49	782.95	786.98	273531.0
2009-01-30 12:00:00	ES	Futures	787.22	791.49	784.85	791.01	158307.0
2009-01-30 13:00:00	ES	Futures	790.78	794.81	781.05	785.8	311450.0
2009-01-30 14:00:00	ES	Futures	786.03	789.83	782.47	784.61	216261.0
2009-01-30 15:00:00	ES	Futures	784.37	786.98	775.6	780.34	517516.0
2009-01-30 16:00:00	ES	Futures	780.34	784.37	779.63	783.42	136191.0
2009-01-30 00:00:00	NQ	Futures	1365.31	1366.16	1364.75	1366.16	66.0
2009-01-30 01:00:00	NQ	Futures	1366.16	1367.0	1365.59	1365.88	69.0
2009-01-30 02:00:00	NQ	Futures	1366.72	1367.57	1364.46	1366.16	408.0
2009-01-30 03:00:00	NQ	Futures	1366.72	1368.13	1358.25	1367.0	1664.0
2009-01-30 04:00:00	NQ	Futures	1367.29	1371.24	1365.31	1367.0	1520.0
2009-01-30 05:00:00	NQ	Futures	1367.0	1368.13	1361.36	1367.0	639.0
2009-01-30 06:00:00	NQ	Futures	1366.16	1367.29	1359.95	1360.23	444.0
2009-01-30 07:00:00	NQ	Futures	1360.51	1360.51	1348.09	1349.5	2188.0
2009-01-30 08:00:00	NQ	Futures	1349.78	1369.26	1348.37	1366.72	9881.0
2009-01-30 09:00:00	NQ	Futures	1366.72	1371.52	1352.89	1353.17	30818.0
2009-01-30 10:00:00	NQ	Futures	1353.45	1355.14	1337.35	1343.85	60762.0
2009-01-30 11:00:00	NQ	Futures	1343.85	1348.37	1331.99	1337.35	40041.0
2009-01-30 12:00:00	NQ	Futures	1337.07	1345.54	1333.4	1344.7	21743.0
2009-01-30 13:00:00	NQ	Futures	1344.41	1354.86	1335.1	1342.72	37503.0
2009-01-30 14:00:00	NQ	Futures	1342.72	1349.21	1336.79	1338.48	22571.0
2009-01-30 15:00:00	NQ	Futures	1338.77	1343.28	1325.78	1330.58	51665.0
2009-01-30 16:00:00	NQ	Futures	1330.86	1336.23	1330.3	1334.25	12396.0
2009-01-30 00:00:00	YM	Futures	7420.5	7423.2	7415.9	7422.3	139.0
2009-01-30 01:00:00	YM	Futures	7420.5	7426.0	7416.9	7424.1	83.0
2009-01-30 02:00:00	YM	Futures	7422.3	7425.1	7404.1	7416.9	609.0
2009-01-30 03:00:00	YM	Futures	7417.8	7437.8	7383.1	7423.2	2306.0
2009-01-30 04:00:00	YM	Futures	7427.8	7438.7	7410.5	7414.1	719.0
2009-01-30 05:00:00	YM	Futures	7410.5	7421.4	7385.9	7408.7	1086.0
2009-01-30 06:00:00	YM	Futures	7409.6	7410.5	7376.8	7383.1	1029.0
2009-01-30 07:00:00	YM	Futures	7382.2	7382.2	7320.3	7323.0	2460.0
2009-01-30 08:00:00	YM	Futures	7325.7	7425.1	7325.7	7409.6	6818.0
2009-01-30 09:00:00	YM	Futures	7407.7	7424.1	7351.2	7353.1	15888.0
2009-01-30 10:00:00	YM	Futures	7352.2	7358.5	7279.3	7303.9	29667.0
2009-01-30 11:00:00	YM	Futures	7302.9	7321.2	7251.0	7282.9	23586.0
2009-01-30 12:00:00	YM	Futures	7284.7	7316.6	7264.7	7311.2	13563.0
2009-01-30 13:00:00	YM	Futures	7310.2	7344.9	7246.4	7281.1	24724.0
2009-01-30 14:00:00	YM	Futures	7280.2	7314.8	7260.1	7276.5	19600.0
2009-01-30 15:00:00	YM	Futures	7276.5	7300.2	7207.3	7247.4	41793.0

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

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