PREVIEW / futures_30min / 2008-07-04

all futures 30-min files

  file:    by_date/futures_30min/2008/2008-07-04.parquet
  size:    34 KB
  rows:    1,100

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
2008-07-04 00:00:00	ES	Futures	1176.49	1176.95	1175.79	1176.72	162.0
2008-07-04 00:30:00	ES	Futures	1176.49	1176.72	1176.02	1176.72	274.0
2008-07-04 01:00:00	ES	Futures	1176.95	1177.65	1176.25	1177.65	680.0
2008-07-04 01:30:00	ES	Futures	1177.42	1177.65	1176.95	1176.95	271.0
2008-07-04 02:00:00	ES	Futures	1176.72	1177.42	1176.49	1176.95	367.0
2008-07-04 02:30:00	ES	Futures	1176.95	1179.97	1176.72	1178.81	1383.0
2008-07-04 03:00:00	ES	Futures	1178.81	1178.81	1173.7	1175.09	6118.0
2008-07-04 03:30:00	ES	Futures	1175.09	1176.25	1173.47	1173.7	1603.0
2008-07-04 04:00:00	ES	Futures	1173.47	1174.86	1172.54	1173.0	2241.0
2008-07-04 04:30:00	ES	Futures	1172.77	1175.32	1172.54	1175.09	2183.0
2008-07-04 05:00:00	ES	Futures	1175.09	1175.32	1173.47	1173.7	1931.0
2008-07-04 05:30:00	ES	Futures	1173.47	1175.79	1173.23	1175.32	1387.0
2008-07-04 06:00:00	ES	Futures	1175.09	1175.32	1173.47	1174.16	962.0
2008-07-04 06:30:00	ES	Futures	1173.93	1174.39	1173.0	1173.23	1095.0
2008-07-04 07:00:00	ES	Futures	1173.23	1173.47	1170.68	1171.61	4034.0
2008-07-04 07:30:00	ES	Futures	1171.84	1172.54	1171.14	1172.54	1061.0
2008-07-04 08:00:00	ES	Futures	1172.3	1172.54	1170.44	1171.14	1022.0
2008-07-04 08:30:00	ES	Futures	1170.91	1171.84	1169.98	1171.61	1989.0
2008-07-04 09:00:00	ES	Futures	1171.37	1172.77	1170.68	1171.84	1433.0
2008-07-04 09:30:00	ES	Futures	1171.84	1174.39	1171.84	1172.54	4018.0
2008-07-04 10:00:00	ES	Futures	1172.54	1172.77	1170.21	1170.21	2129.0
2008-07-04 10:30:00	ES	Futures	1170.21	1170.44	1169.05	1169.05	6153.0
2008-07-04 11:00:00	ES	Futures	1169.05	1170.21	1168.12	1168.35	6814.0
2008-07-04 00:30:00	NQ	Futures	2048.91	2048.91	2048.34	2048.91	7.0
2008-07-04 01:00:00	NQ	Futures	2051.16	2051.72	2048.91	2048.91	20.0
2008-07-04 01:30:00	NQ	Futures	2050.03	2050.6	2050.03	2050.6	5.0
2008-07-04 02:00:00	NQ	Futures	2050.03	2053.69	2048.34	2052.85	68.0
2008-07-04 02:30:00	NQ	Futures	2053.13	2057.35	2052.28	2057.06	86.0
2008-07-04 03:00:00	NQ	Futures	2055.38	2055.38	2048.06	2050.31	147.0
2008-07-04 03:30:00	NQ	Futures	2050.31	2052.28	2049.75	2052.0	233.0
2008-07-04 04:00:00	NQ	Futures	2051.16	2052.0	2046.09	2047.5	323.0
2008-07-04 04:30:00	NQ	Futures	2047.78	2052.85	2047.5	2052.28	139.0
2008-07-04 05:00:00	NQ	Futures	2051.72	2051.72	2049.47	2050.6	138.0
2008-07-04 05:30:00	NQ	Futures	2051.44	2053.69	2049.47	2051.72	111.0
2008-07-04 06:00:00	NQ	Futures	2052.0	2052.0	2050.03	2050.6	35.0
2008-07-04 06:30:00	NQ	Futures	2050.88	2050.88	2048.34	2048.91	18.0
2008-07-04 07:00:00	NQ	Futures	2048.91	2049.19	2042.16	2046.66	318.0
2008-07-04 07:30:00	NQ	Futures	2046.09	2049.47	2044.13	2048.63	208.0
2008-07-04 08:00:00	NQ	Futures	2047.78	2048.06	2043.84	2045.25	131.0
2008-07-04 08:30:00	NQ	Futures	2044.97	2044.97	2042.72	2044.97	169.0
2008-07-04 09:00:00	NQ	Futures	2045.53	2047.5	2043.28	2045.53	255.0
2008-07-04 09:30:00	NQ	Futures	2045.81	2050.6	2045.25	2047.78	578.0
2008-07-04 10:00:00	NQ	Futures	2046.94	2048.06	2043.0	2043.56	241.0
2008-07-04 10:30:00	NQ	Futures	2043.0	2043.56	2040.75	2041.59	478.0
2008-07-04 11:00:00	NQ	Futures	2041.03	2044.41	2041.03	2042.16	580.0
2008-07-04 00:00:00	YM	Futures	10256.6	10262.1	10253.9	10253.9	12.0
2008-07-04 00:30:00	YM	Futures	10253.9	10262.1	10252.1	10252.1	40.0
2008-07-04 01:00:00	YM	Futures	10253.0	10257.6	10251.2	10255.7	35.0
2008-07-04 01:30:00	YM	Futures	10255.7	10259.4	10253.9	10256.6	59.0
2008-07-04 02:00:00	YM	Futures	10256.6	10263.0	10255.7	10258.5	13.0

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

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