PREVIEW / futures_1hour / 2011-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-26.parquet
  size:    40 KB
  rows:    1,151

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
2011-08-26 00:00:00	ES	Futures	1159.74	1162.23	1159.49	1159.49	2202.0
2011-08-26 01:00:00	ES	Futures	1159.24	1161.73	1158.49	1161.48	2749.0
2011-08-26 02:00:00	ES	Futures	1161.23	1163.23	1159.24	1160.98	11988.0
2011-08-26 03:00:00	ES	Futures	1160.73	1161.98	1153.75	1154.25	56901.0
2011-08-26 04:00:00	ES	Futures	1154.0	1159.24	1153.75	1155.5	28743.0
2011-08-26 05:00:00	ES	Futures	1155.5	1158.99	1154.5	1155.0	12515.0
2011-08-26 06:00:00	ES	Futures	1154.75	1156.24	1154.0	1155.75	14837.0
2011-08-26 07:00:00	ES	Futures	1155.75	1155.99	1150.01	1152.75	41480.0
2011-08-26 08:00:00	ES	Futures	1152.75	1152.75	1143.77	1145.27	113978.0
2011-08-26 09:00:00	ES	Futures	1145.02	1151.01	1141.03	1146.27	324118.0
2011-08-26 10:00:00	ES	Futures	1146.52	1162.98	1130.06	1154.5	940623.0
2011-08-26 11:00:00	ES	Futures	1154.25	1168.46	1152.0	1165.72	381125.0
2011-08-26 12:00:00	ES	Futures	1165.72	1175.95	1165.47	1170.71	295014.0
2011-08-26 13:00:00	ES	Futures	1170.71	1176.94	1168.46	1175.45	144320.0
2011-08-26 14:00:00	ES	Futures	1175.45	1176.7	1167.47	1171.46	180644.0
2011-08-26 15:00:00	ES	Futures	1171.46	1172.21	1163.48	1171.21	342647.0
2011-08-26 16:00:00	ES	Futures	1171.21	1175.2	1170.71	1172.46	107982.0
2011-08-26 00:00:00	NQ	Futures	2441.4	2446.0	2441.11	2441.4	164.0
2011-08-26 01:00:00	NQ	Futures	2440.25	2445.43	2438.81	2445.14	274.0
2011-08-26 02:00:00	NQ	Futures	2444.85	2448.88	2439.96	2443.13	1400.0
2011-08-26 03:00:00	NQ	Futures	2443.42	2445.43	2428.16	2429.31	4754.0
2011-08-26 04:00:00	NQ	Futures	2429.6	2438.81	2428.74	2431.9	2023.0
2011-08-26 05:00:00	NQ	Futures	2431.62	2438.81	2429.89	2430.18	901.0
2011-08-26 06:00:00	NQ	Futures	2430.18	2435.65	2428.16	2433.34	1690.0
2011-08-26 07:00:00	NQ	Futures	2434.21	2434.21	2421.83	2426.44	2493.0
2011-08-26 08:00:00	NQ	Futures	2427.01	2427.59	2410.61	2413.49	8873.0
2011-08-26 09:00:00	NQ	Futures	2413.49	2430.18	2409.75	2419.53	39635.0
2011-08-26 10:00:00	NQ	Futures	2419.24	2471.62	2395.07	2452.05	107649.0
2011-08-26 11:00:00	NQ	Futures	2451.76	2480.54	2447.44	2473.63	45994.0
2011-08-26 12:00:00	NQ	Futures	2473.34	2490.61	2473.34	2482.26	33918.0
2011-08-26 13:00:00	NQ	Futures	2482.26	2495.5	2476.8	2493.77	18202.0
2011-08-26 14:00:00	NQ	Futures	2494.06	2496.65	2479.39	2488.59	19403.0
2011-08-26 15:00:00	NQ	Futures	2488.59	2489.17	2469.89	2486.87	40431.0
2011-08-26 16:00:00	NQ	Futures	2487.16	2496.08	2486.87	2492.62	10580.0
2011-08-26 00:00:00	YM	Futures	10823.8	10843.2	10819.0	10819.0	225.0
2011-08-26 01:00:00	YM	Futures	10819.0	10830.6	10811.2	10827.7	414.0
2011-08-26 02:00:00	YM	Futures	10829.6	10848.0	10811.2	10826.7	740.0
2011-08-26 03:00:00	YM	Futures	10826.7	10834.5	10772.5	10775.4	1852.0
2011-08-26 04:00:00	YM	Futures	10774.4	10814.1	10773.4	10784.1	1214.0
2011-08-26 05:00:00	YM	Futures	10783.1	10808.3	10773.4	10775.4	511.0
2011-08-26 06:00:00	YM	Futures	10775.4	10792.8	10774.4	10785.1	654.0
2011-08-26 07:00:00	YM	Futures	10788.0	10790.9	10739.5	10757.9	1246.0
2011-08-26 08:00:00	YM	Futures	10757.9	10767.6	10692.1	10702.8	3634.0
2011-08-26 09:00:00	YM	Futures	10701.8	10736.6	10659.2	10713.4	18027.0
2011-08-26 10:00:00	YM	Futures	10716.3	10825.7	10564.3	10757.9	49295.0
2011-08-26 11:00:00	YM	Futures	10757.9	10881.9	10742.5	10868.3	18990.0
2011-08-26 12:00:00	YM	Futures	10870.3	10949.7	10870.3	10914.8	14252.0
2011-08-26 13:00:00	YM	Futures	10914.8	10952.6	10897.4	10937.1	9265.0
2011-08-26 14:00:00	YM	Futures	10937.1	10947.8	10872.2	10904.2	10105.0
2011-08-26 15:00:00	YM	Futures	10904.2	10915.8	10840.3	10910.0	16210.0

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

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