PREVIEW / futures_1hour / 2019-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-16.parquet
  size:    58 KB
  rows:    1,831

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
2019-09-16 00:00:00	ES	Futures	3251.97	3252.24	3246.53	3248.71	4151.0
2019-09-16 01:00:00	ES	Futures	3248.71	3253.6	3248.16	3252.78	5717.0
2019-09-16 02:00:00	ES	Futures	3252.51	3255.77	3251.97	3254.68	13363.0
2019-09-16 03:00:00	ES	Futures	3254.68	3259.03	3251.69	3254.68	19464.0
2019-09-16 04:00:00	ES	Futures	3254.68	3259.03	3253.32	3255.5	17162.0
2019-09-16 05:00:00	ES	Futures	3255.23	3257.67	3250.06	3254.95	23933.0
2019-09-16 06:00:00	ES	Futures	3254.68	3257.13	3253.05	3256.04	13106.0
2019-09-16 07:00:00	ES	Futures	3256.04	3259.03	3252.51	3258.21	27175.0
2019-09-16 08:00:00	ES	Futures	3258.49	3260.39	3257.13	3257.4	21243.0
2019-09-16 09:00:00	ES	Futures	3257.4	3264.46	3254.95	3263.65	152589.0
2019-09-16 10:00:00	ES	Futures	3263.92	3265.28	3256.04	3258.49	121577.0
2019-09-16 11:00:00	ES	Futures	3258.49	3264.46	3252.24	3253.32	113461.0
2019-09-16 12:00:00	ES	Futures	3253.05	3258.49	3252.51	3256.86	77238.0
2019-09-16 13:00:00	ES	Futures	3256.86	3261.47	3256.04	3260.93	41223.0
2019-09-16 14:00:00	ES	Futures	3261.2	3262.29	3258.49	3260.93	47554.0
2019-09-16 15:00:00	ES	Futures	3260.93	3263.1	3257.94	3259.84	108661.0
2019-09-16 16:00:00	ES	Futures	3260.11	3264.73	3259.84	3264.46	38312.0
2019-09-16 18:00:00	ES	Futures	3264.19	3267.18	3262.83	3264.73	7709.0
2019-09-16 19:00:00	ES	Futures	3264.73	3266.63	3263.37	3263.37	6583.0
2019-09-16 20:00:00	ES	Futures	3263.65	3264.73	3260.11	3264.19	15366.0
2019-09-16 21:00:00	ES	Futures	3264.19	3264.19	3256.04	3256.04	16806.0
2019-09-16 22:00:00	ES	Futures	3256.31	3259.57	3256.04	3259.3	6507.0
2019-09-16 23:00:00	ES	Futures	3259.3	3260.11	3257.94	3259.57	7718.0
2019-09-16 00:00:00	NQ	Futures	9105.19	9106.64	9094.44	9101.41	1811.0
2019-09-16 01:00:00	NQ	Futures	9101.7	9119.13	9098.8	9113.91	2293.0
2019-09-16 02:00:00	NQ	Futures	9113.32	9127.85	9113.32	9123.49	3799.0
2019-09-16 03:00:00	NQ	Futures	9123.78	9141.21	9113.62	9123.78	5481.0
2019-09-16 04:00:00	NQ	Futures	9124.07	9138.02	9117.39	9123.78	4913.0
2019-09-16 05:00:00	NQ	Futures	9124.07	9134.24	9107.22	9125.53	6121.0
2019-09-16 06:00:00	NQ	Futures	9124.94	9136.27	9121.17	9134.82	2954.0
2019-09-16 07:00:00	NQ	Futures	9134.53	9141.5	9117.39	9137.44	5644.0
2019-09-16 08:00:00	NQ	Futures	9137.73	9148.47	9131.34	9132.21	7161.0
2019-09-16 09:00:00	NQ	Futures	9132.21	9172.29	9127.85	9169.68	45662.0
2019-09-16 10:00:00	NQ	Futures	9169.68	9173.75	9134.53	9144.12	40816.0
2019-09-16 11:00:00	NQ	Futures	9144.12	9167.94	9127.27	9129.01	30009.0
2019-09-16 12:00:00	NQ	Futures	9128.72	9144.12	9127.27	9136.27	20800.0
2019-09-16 13:00:00	NQ	Futures	9136.27	9156.32	9131.63	9153.7	12704.0
2019-09-16 14:00:00	NQ	Futures	9153.41	9158.93	9142.95	9152.25	12781.0
2019-09-16 15:00:00	NQ	Futures	9151.96	9161.55	9144.7	9153.41	24896.0
2019-09-16 16:00:00	NQ	Futures	9153.41	9167.36	9153.12	9165.32	6652.0
2019-09-16 18:00:00	NQ	Futures	9164.45	9177.81	9159.22	9168.81	3371.0
2019-09-16 19:00:00	NQ	Futures	9168.52	9174.62	9162.42	9163.0	1921.0
2019-09-16 20:00:00	NQ	Futures	9163.0	9167.94	9150.22	9164.74	5700.0
2019-09-16 21:00:00	NQ	Futures	9164.45	9164.45	9133.95	9135.4	5851.0
2019-09-16 22:00:00	NQ	Futures	9135.69	9151.96	9134.53	9150.51	2900.0
2019-09-16 23:00:00	NQ	Futures	9150.22	9152.83	9138.31	9144.41	3029.0
2019-09-16 00:00:00	YM	Futures	29483.5	29486.7	29442.1	29454.1	1051.0
2019-09-16 01:00:00	YM	Futures	29455.2	29494.3	29451.9	29481.3	1150.0
2019-09-16 02:00:00	YM	Futures	29481.3	29513.9	29472.6	29496.5	2854.0
2019-09-16 03:00:00	YM	Futures	29495.4	29546.6	29485.6	29511.8	3550.0

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

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