PREVIEW / futures_1hour / 2008-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-03-27.parquet
  size:    42 KB
  rows:    1,202

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-03-27 00:00:00	ES	Futures	1243.62	1245.25	1243.15	1244.78	2042.0
2008-03-27 01:00:00	ES	Futures	1244.78	1245.25	1243.15	1243.62	1458.0
2008-03-27 02:00:00	ES	Futures	1243.85	1244.78	1243.39	1244.78	570.0
2008-03-27 03:00:00	ES	Futures	1244.78	1246.65	1244.32	1246.18	4489.0
2008-03-27 04:00:00	ES	Futures	1246.18	1249.9	1245.95	1249.9	26717.0
2008-03-27 05:00:00	ES	Futures	1249.9	1252.47	1249.44	1250.14	18553.0
2008-03-27 06:00:00	ES	Futures	1250.14	1252.93	1249.21	1251.53	13554.0
2008-03-27 07:00:00	ES	Futures	1251.77	1252.0	1246.65	1248.97	26980.0
2008-03-27 08:00:00	ES	Futures	1248.74	1255.49	1246.65	1254.56	86062.0
2008-03-27 09:00:00	ES	Futures	1254.33	1254.56	1248.97	1251.77	184370.0
2008-03-27 10:00:00	ES	Futures	1251.77	1252.47	1239.19	1243.85	394907.0
2008-03-27 11:00:00	ES	Futures	1243.62	1250.37	1241.76	1248.04	218458.0
2008-03-27 12:00:00	ES	Futures	1248.04	1255.49	1246.88	1251.07	189792.0
2008-03-27 13:00:00	ES	Futures	1251.3	1254.1	1242.45	1244.55	190491.0
2008-03-27 14:00:00	ES	Futures	1244.55	1251.07	1241.29	1245.95	240388.0
2008-03-27 15:00:00	ES	Futures	1245.95	1247.58	1235.47	1236.4	322995.0
2008-03-27 16:00:00	ES	Futures	1236.17	1241.06	1236.17	1240.36	74430.0
2008-03-27 17:00:00	ES	Futures	1240.36	1240.36	1239.19	1239.19	1096.0
2008-03-27 18:00:00	ES	Futures	1238.96	1240.13	1238.5	1239.43	1786.0
2008-03-27 19:00:00	ES	Futures	1239.66	1240.36	1238.03	1240.13	972.0
2008-03-27 20:00:00	ES	Futures	1240.13	1240.82	1239.89	1240.82	1854.0
2008-03-27 21:00:00	ES	Futures	1240.82	1242.45	1240.59	1242.22	2037.0
2008-03-27 22:00:00	ES	Futures	1242.22	1243.39	1241.99	1242.92	2785.0
2008-03-27 23:00:00	ES	Futures	1242.92	1246.41	1242.69	1246.18	4632.0
2008-03-27 00:00:00	NQ	Futures	2046.55	2049.09	2045.98	2048.53	125.0
2008-03-27 01:00:00	NQ	Futures	2048.24	2049.09	2045.13	2046.55	113.0
2008-03-27 02:00:00	NQ	Futures	2046.55	2048.81	2045.42	2048.81	32.0
2008-03-27 03:00:00	NQ	Futures	2048.24	2053.62	2047.11	2053.05	561.0
2008-03-27 04:00:00	NQ	Futures	2053.34	2058.14	2052.2	2057.01	1619.0
2008-03-27 05:00:00	NQ	Futures	2057.01	2062.95	2057.01	2057.86	1159.0
2008-03-27 06:00:00	NQ	Futures	2057.86	2060.97	2056.73	2057.86	1127.0
2008-03-27 07:00:00	NQ	Futures	2058.14	2058.43	2045.13	2045.7	4900.0
2008-03-27 08:00:00	NQ	Futures	2045.98	2057.01	2043.15	2055.03	9778.0
2008-03-27 09:00:00	NQ	Futures	2054.75	2055.03	2042.59	2049.38	47750.0
2008-03-27 10:00:00	NQ	Futures	2049.66	2050.79	2029.01	2035.52	66966.0
2008-03-27 11:00:00	NQ	Futures	2035.52	2050.51	2031.56	2045.13	38994.0
2008-03-27 12:00:00	NQ	Futures	2044.85	2055.03	2042.59	2045.98	34325.0
2008-03-27 13:00:00	NQ	Futures	2046.27	2050.79	2032.97	2037.21	32132.0
2008-03-27 14:00:00	NQ	Futures	2036.93	2042.87	2029.58	2036.37	46436.0
2008-03-27 15:00:00	NQ	Futures	2036.08	2039.76	2017.13	2018.27	72260.0
2008-03-27 16:00:00	NQ	Futures	2018.27	2030.14	2016.85	2028.73	15575.0
2008-03-27 17:00:00	NQ	Futures	2029.58	2029.58	2026.75	2027.32	101.0
2008-03-27 18:00:00	NQ	Futures	2027.32	2029.01	2025.34	2027.32	278.0
2008-03-27 19:00:00	NQ	Futures	2028.16	2028.45	2025.05	2027.88	62.0
2008-03-27 20:00:00	NQ	Futures	2028.45	2030.14	2027.88	2028.45	42.0
2008-03-27 21:00:00	NQ	Futures	2029.3	2031.28	2029.01	2029.86	34.0
2008-03-27 22:00:00	NQ	Futures	2030.99	2031.28	2029.86	2030.71	51.0
2008-03-27 23:00:00	NQ	Futures	2030.43	2037.5	2030.43	2037.5	198.0
2008-03-27 00:00:00	YM	Futures	11245.5	11261.8	11245.5	11259.1	154.0
2008-03-27 01:00:00	YM	Futures	11258.2	11260.0	11249.1	11250.0	123.0

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

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