PREVIEW / futures_1hour / 2010-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-27.parquet
  size:    39 KB
  rows:    1,104

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-27 00:00:00	ES	Futures	1026.67	1028.88	1025.93	1028.88	7000.0
2010-08-27 01:00:00	ES	Futures	1028.63	1030.59	1028.63	1029.86	10866.0
2010-08-27 02:00:00	ES	Futures	1029.86	1030.35	1028.88	1029.12	10669.0
2010-08-27 03:00:00	ES	Futures	1029.12	1030.35	1025.93	1026.42	39301.0
2010-08-27 04:00:00	ES	Futures	1026.42	1027.89	1024.7	1025.69	24491.0
2010-08-27 05:00:00	ES	Futures	1025.69	1028.39	1025.2	1028.14	13380.0
2010-08-27 06:00:00	ES	Futures	1028.14	1029.86	1026.67	1029.12	18883.0
2010-08-27 07:00:00	ES	Futures	1029.37	1029.86	1028.14	1028.39	20345.0
2010-08-27 08:00:00	ES	Futures	1028.39	1035.01	1027.65	1033.05	123298.0
2010-08-27 09:00:00	ES	Futures	1033.29	1034.77	1024.95	1025.44	294424.0
2010-08-27 10:00:00	ES	Futures	1025.44	1034.27	1018.08	1031.08	717453.0
2010-08-27 11:00:00	ES	Futures	1031.08	1039.67	1030.59	1037.22	299381.0
2010-08-27 12:00:00	ES	Futures	1036.97	1040.16	1034.77	1035.5	143293.0
2010-08-27 13:00:00	ES	Futures	1035.75	1041.39	1034.77	1041.15	164576.0
2010-08-27 14:00:00	ES	Futures	1041.15	1043.35	1038.2	1041.15	180528.0
2010-08-27 15:00:00	ES	Futures	1041.15	1044.58	1039.43	1043.6	304899.0
2010-08-27 16:00:00	ES	Futures	1043.6	1044.83	1043.11	1044.34	122359.0
2010-08-27 00:00:00	NQ	Futures	2026.59	2030.61	2025.16	2030.32	260.0
2010-08-27 01:00:00	NQ	Futures	2030.61	2033.76	2030.61	2032.33	576.0
2010-08-27 02:00:00	NQ	Futures	2032.33	2033.76	2031.18	2031.47	689.0
2010-08-27 03:00:00	NQ	Futures	2031.47	2034.05	2026.02	2027.45	1931.0
2010-08-27 04:00:00	NQ	Futures	2026.59	2030.03	2023.73	2026.31	1318.0
2010-08-27 05:00:00	NQ	Futures	2026.02	2033.19	2025.74	2032.61	1405.0
2010-08-27 06:00:00	NQ	Futures	2032.61	2035.48	2029.75	2034.33	1228.0
2010-08-27 07:00:00	NQ	Futures	2034.05	2036.05	2032.61	2032.61	1794.0
2010-08-27 08:00:00	NQ	Futures	2032.61	2046.94	2031.18	2042.93	10251.0
2010-08-27 09:00:00	NQ	Futures	2042.93	2045.79	2016.28	2017.71	46896.0
2010-08-27 10:00:00	NQ	Futures	2017.71	2039.49	1999.08	2028.03	136469.0
2010-08-27 11:00:00	NQ	Futures	2028.31	2049.23	2028.03	2042.07	44782.0
2010-08-27 12:00:00	NQ	Futures	2042.07	2049.81	2037.77	2039.49	26639.0
2010-08-27 13:00:00	NQ	Futures	2039.78	2051.81	2038.06	2051.81	29207.0
2010-08-27 14:00:00	NQ	Futures	2051.81	2056.97	2046.08	2052.1	31955.0
2010-08-27 15:00:00	NQ	Futures	2052.1	2056.4	2048.37	2053.25	44357.0
2010-08-27 16:00:00	NQ	Futures	2053.82	2055.82	2051.81	2052.1	9783.0
2010-08-27 00:00:00	YM	Futures	9442.4	9459.4	9436.7	9458.5	573.0
2010-08-27 01:00:00	YM	Futures	9458.5	9474.6	9457.5	9467.0	474.0
2010-08-27 02:00:00	YM	Futures	9466.1	9470.8	9457.5	9459.4	867.0
2010-08-27 03:00:00	YM	Futures	9459.4	9471.7	9437.7	9441.5	2038.0
2010-08-27 04:00:00	YM	Futures	9440.5	9450.0	9425.4	9435.8	1449.0
2010-08-27 05:00:00	YM	Futures	9433.9	9455.7	9430.1	9452.8	825.0
2010-08-27 06:00:00	YM	Futures	9453.8	9467.0	9443.3	9462.3	759.0
2010-08-27 07:00:00	YM	Futures	9462.3	9469.9	9454.7	9455.7	944.0
2010-08-27 08:00:00	YM	Futures	9456.6	9512.4	9449.0	9494.5	7247.0
2010-08-27 09:00:00	YM	Futures	9494.5	9514.3	9437.7	9440.5	20686.0
2010-08-27 10:00:00	YM	Futures	9441.5	9511.5	9390.3	9485.0	45230.0
2010-08-27 11:00:00	YM	Futures	9485.0	9566.4	9484.1	9539.0	20501.0
2010-08-27 12:00:00	YM	Futures	9539.0	9563.6	9523.8	9529.5	8688.0
2010-08-27 13:00:00	YM	Futures	9529.5	9574.0	9523.8	9574.0	10688.0
2010-08-27 14:00:00	YM	Futures	9574.0	9591.0	9549.4	9574.9	13183.0
2010-08-27 15:00:00	YM	Futures	9575.9	9602.4	9560.7	9598.6	19122.0

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

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