PREVIEW / futures_1hour / 2017-02-24

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-24.parquet
  size:    46 KB
  rows:    1,352

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
2017-02-24 00:00:00	ES	Futures	2575.48	2575.76	2574.94	2575.48	1868.0
2017-02-24 01:00:00	ES	Futures	2575.48	2575.48	2574.39	2574.39	2183.0
2017-02-24 02:00:00	ES	Futures	2574.39	2574.67	2573.57	2574.12	5271.0
2017-02-24 03:00:00	ES	Futures	2574.12	2575.21	2573.85	2574.39	10891.0
2017-02-24 04:00:00	ES	Futures	2574.67	2576.03	2573.3	2574.39	17373.0
2017-02-24 05:00:00	ES	Futures	2574.67	2575.21	2570.03	2571.67	19005.0
2017-02-24 06:00:00	ES	Futures	2571.94	2571.94	2565.39	2565.39	40068.0
2017-02-24 07:00:00	ES	Futures	2565.66	2568.67	2564.85	2565.66	38762.0
2017-02-24 08:00:00	ES	Futures	2565.94	2567.3	2564.57	2565.39	62034.0
2017-02-24 09:00:00	ES	Futures	2565.39	2572.21	2563.48	2571.94	239212.0
2017-02-24 10:00:00	ES	Futures	2571.94	2574.67	2568.12	2572.48	267896.0
2017-02-24 11:00:00	ES	Futures	2572.21	2575.21	2570.03	2570.3	157189.0
2017-02-24 12:00:00	ES	Futures	2570.3	2574.94	2570.3	2573.3	116218.0
2017-02-24 13:00:00	ES	Futures	2573.3	2573.85	2570.3	2573.3	99283.0
2017-02-24 14:00:00	ES	Futures	2573.03	2573.85	2571.67	2571.94	72056.0
2017-02-24 15:00:00	ES	Futures	2572.21	2581.21	2571.12	2580.67	253763.0
2017-02-24 16:00:00	ES	Futures	2580.67	2580.94	2578.21	2579.85	103755.0
2017-02-24 00:00:00	NQ	Futures	6350.93	6353.32	6349.14	6351.83	1139.0
2017-02-24 01:00:00	NQ	Futures	6352.12	6352.42	6348.84	6349.74	594.0
2017-02-24 02:00:00	NQ	Futures	6349.74	6352.12	6348.25	6350.33	1232.0
2017-02-24 03:00:00	NQ	Futures	6350.33	6353.32	6347.65	6350.33	2327.0
2017-02-24 04:00:00	NQ	Futures	6350.33	6354.21	6347.95	6350.93	1998.0
2017-02-24 05:00:00	NQ	Futures	6350.93	6351.83	6337.21	6341.09	4334.0
2017-02-24 06:00:00	NQ	Futures	6341.09	6341.09	6324.98	6325.87	6122.0
2017-02-24 07:00:00	NQ	Futures	6326.17	6333.33	6325.57	6327.36	4108.0
2017-02-24 08:00:00	NQ	Futures	6327.66	6328.86	6323.19	6324.98	7285.0
2017-02-24 09:00:00	NQ	Futures	6324.98	6350.04	6323.49	6348.84	44384.0
2017-02-24 10:00:00	NQ	Futures	6349.14	6353.62	6334.52	6348.84	38662.0
2017-02-24 11:00:00	NQ	Futures	6348.84	6356.6	6342.88	6343.47	23987.0
2017-02-24 12:00:00	NQ	Futures	6343.47	6356.0	6342.58	6353.62	14293.0
2017-02-24 13:00:00	NQ	Futures	6353.32	6354.51	6347.05	6353.02	10318.0
2017-02-24 14:00:00	NQ	Futures	6353.32	6359.28	6351.53	6355.7	11224.0
2017-02-24 15:00:00	NQ	Futures	6356.0	6375.39	6353.02	6375.39	27362.0
2017-02-24 16:00:00	NQ	Futures	6375.09	6377.48	6371.22	6375.39	6446.0
2017-02-24 00:00:00	YM	Futures	22543.6	22544.7	22537.1	22543.6	607.0
2017-02-24 01:00:00	YM	Futures	22542.5	22543.6	22532.8	22532.8	605.0
2017-02-24 02:00:00	YM	Futures	22533.8	22537.1	22529.5	22531.7	824.0
2017-02-24 03:00:00	YM	Futures	22531.7	22541.4	22529.5	22534.9	2320.0
2017-02-24 04:00:00	YM	Futures	22534.9	22545.8	22527.3	22533.8	2145.0
2017-02-24 05:00:00	YM	Futures	22534.9	22537.1	22494.8	22508.9	2908.0
2017-02-24 06:00:00	YM	Futures	22508.9	22510.0	22460.1	22462.2	6287.0
2017-02-24 07:00:00	YM	Futures	22463.3	22485.0	22453.6	22460.1	4325.0
2017-02-24 08:00:00	YM	Futures	22461.2	22481.8	22456.8	22464.4	6646.0
2017-02-24 09:00:00	YM	Futures	22464.4	22529.5	22449.2	22526.2	25393.0
2017-02-24 10:00:00	YM	Futures	22527.3	22539.3	22479.6	22508.9	24929.0
2017-02-24 11:00:00	YM	Futures	22508.9	22525.2	22483.9	22485.0	11896.0
2017-02-24 12:00:00	YM	Futures	22483.9	22523.0	22482.9	22508.9	8309.0
2017-02-24 13:00:00	YM	Futures	22507.8	22513.2	22488.3	22505.6	7415.0
2017-02-24 14:00:00	YM	Futures	22505.6	22506.7	22485.0	22490.5	7792.0
2017-02-24 15:00:00	YM	Futures	22490.5	22562.0	22485.0	22559.9	16048.0

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

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