PREVIEW / futures_1hour / 2010-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-30.parquet
  size:    42 KB
  rows:    1,250

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
2010-08-30 00:00:00	ES	Futures	1048.51	1050.22	1048.02	1048.75	4106.0
2010-08-30 01:00:00	ES	Futures	1048.75	1049.24	1047.53	1048.75	4439.0
2010-08-30 02:00:00	ES	Futures	1048.75	1049.0	1047.28	1047.53	10521.0
2010-08-30 03:00:00	ES	Futures	1047.53	1047.77	1045.32	1046.79	18941.0
2010-08-30 04:00:00	ES	Futures	1047.03	1047.53	1045.56	1046.3	12871.0
2010-08-30 05:00:00	ES	Futures	1046.05	1047.03	1045.32	1046.05	8048.0
2010-08-30 06:00:00	ES	Futures	1045.81	1045.81	1043.11	1043.35	20729.0
2010-08-30 07:00:00	ES	Futures	1043.6	1044.83	1042.13	1043.35	26634.0
2010-08-30 08:00:00	ES	Futures	1043.35	1044.58	1040.41	1041.39	47939.0
2010-08-30 09:00:00	ES	Futures	1041.39	1043.84	1039.67	1043.6	172059.0
2010-08-30 10:00:00	ES	Futures	1043.35	1043.84	1037.71	1040.9	223055.0
2010-08-30 11:00:00	ES	Futures	1040.9	1041.39	1035.26	1036.48	181608.0
2010-08-30 12:00:00	ES	Futures	1036.73	1039.43	1035.75	1037.71	88770.0
2010-08-30 13:00:00	ES	Futures	1037.71	1038.69	1034.27	1035.01	112817.0
2010-08-30 14:00:00	ES	Futures	1035.01	1036.73	1032.56	1034.77	129265.0
2010-08-30 15:00:00	ES	Futures	1034.77	1035.5	1027.89	1028.39	243195.0
2010-08-30 16:00:00	ES	Futures	1028.39	1028.63	1025.2	1026.67	124483.0
2010-08-30 17:00:00	ES	Futures	1026.67	1026.67	1025.44	1025.93	2073.0
2010-08-30 18:00:00	ES	Futures	1025.93	1026.91	1025.69	1026.42	2434.0
2010-08-30 19:00:00	ES	Futures	1026.67	1028.39	1026.42	1027.4	5477.0
2010-08-30 20:00:00	ES	Futures	1027.4	1027.65	1024.7	1025.93	9299.0
2010-08-30 21:00:00	ES	Futures	1025.93	1027.16	1025.2	1025.44	5787.0
2010-08-30 22:00:00	ES	Futures	1025.44	1026.67	1025.2	1026.42	3931.0
2010-08-30 23:00:00	ES	Futures	1026.67	1026.67	1025.2	1025.2	3125.0
2010-08-30 00:00:00	NQ	Futures	2060.98	2062.99	2060.12	2061.56	288.0
2010-08-30 01:00:00	NQ	Futures	2060.41	2061.27	2058.69	2060.7	353.0
2010-08-30 02:00:00	NQ	Futures	2060.98	2060.98	2057.83	2058.98	705.0
2010-08-30 03:00:00	NQ	Futures	2058.69	2058.69	2054.96	2057.83	1687.0
2010-08-30 04:00:00	NQ	Futures	2058.12	2058.69	2054.96	2056.11	570.0
2010-08-30 05:00:00	NQ	Futures	2056.11	2057.83	2054.96	2055.54	389.0
2010-08-30 06:00:00	NQ	Futures	2055.54	2055.54	2048.37	2049.52	1566.0
2010-08-30 07:00:00	NQ	Futures	2049.52	2053.25	2047.8	2049.81	1500.0
2010-08-30 08:00:00	NQ	Futures	2049.23	2051.81	2042.36	2045.79	6738.0
2010-08-30 09:00:00	NQ	Futures	2045.51	2060.7	2042.93	2059.84	44852.0
2010-08-30 10:00:00	NQ	Futures	2059.55	2060.98	2047.8	2054.39	36583.0
2010-08-30 11:00:00	NQ	Futures	2054.39	2055.25	2042.36	2044.36	36282.0
2010-08-30 12:00:00	NQ	Futures	2044.65	2050.67	2043.22	2048.09	20199.0
2010-08-30 13:00:00	NQ	Futures	2047.8	2050.38	2041.21	2042.07	23331.0
2010-08-30 14:00:00	NQ	Futures	2042.07	2047.23	2038.63	2044.36	25000.0
2010-08-30 15:00:00	NQ	Futures	2044.08	2045.79	2030.89	2031.75	41595.0
2010-08-30 16:00:00	NQ	Futures	2031.75	2032.61	2026.88	2029.75	11264.0
2010-08-30 17:00:00	NQ	Futures	2029.75	2030.03	2027.45	2028.31	218.0
2010-08-30 18:00:00	NQ	Futures	2028.03	2030.32	2028.03	2028.89	247.0
2010-08-30 19:00:00	NQ	Futures	2029.75	2032.9	2029.75	2031.18	345.0
2010-08-30 20:00:00	NQ	Futures	2030.32	2031.18	2025.74	2027.17	546.0
2010-08-30 21:00:00	NQ	Futures	2028.03	2030.03	2026.02	2026.59	292.0
2010-08-30 22:00:00	NQ	Futures	2026.59	2029.17	2026.02	2028.6	143.0
2010-08-30 23:00:00	NQ	Futures	2028.6	2028.6	2026.02	2026.88	140.0
2010-08-30 00:00:00	YM	Futures	9629.8	9641.2	9627.0	9631.7	431.0
2010-08-30 01:00:00	YM	Futures	9628.9	9635.5	9623.2	9633.6	174.0

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

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