PREVIEW / stock_5min / 2014-05-12

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-05-12.parquet
  size:    5.4 MB
  rows:    364,938
  symbols: 3,553

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
2014-05-12 04:00:00	AAPL	Stock	20.9525	20.9643	20.9525	20.9643	11200.0
2014-05-12 04:10:00	AAPL	Stock	20.9286	20.9286	20.9214	20.9214	14000.0
2014-05-12 04:25:00	AAPL	Stock	20.9521	20.9521	20.9521	20.9521	5600.0
2014-05-12 05:10:00	AAPL	Stock	20.9464	20.9464	20.9464	20.9464	2800.0
2014-05-12 05:20:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	2800.0
2014-05-12 05:35:00	AAPL	Stock	20.9625	20.9643	20.9625	20.9643	8400.0
2014-05-12 06:30:00	AAPL	Stock	20.9632	20.9664	20.9632	20.9664	5600.0
2014-05-12 06:35:00	AAPL	Stock	20.9775	20.9946	20.9775	20.9946	14000.0
2014-05-12 06:45:00	AAPL	Stock	20.975	20.975	20.975	20.975	2800.0
2014-05-12 07:00:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	15400.0
2014-05-12 07:05:00	AAPL	Stock	20.9911	20.9946	20.9911	20.9946	15120.0
2014-05-12 07:10:00	AAPL	Stock	20.9961	21.0089	20.9961	21.0089	31976.0
2014-05-12 07:15:00	AAPL	Stock	21.0321	21.0321	21.0321	21.0321	7924.0
2014-05-12 07:20:00	AAPL	Stock	21.0089	21.0089	21.0089	21.0089	2800.0
2014-05-12 07:30:00	AAPL	Stock	21.0204	21.0204	21.0204	21.0204	21504.0
2014-05-12 07:35:00	AAPL	Stock	21.0179	21.0179	21.0179	21.0179	8400.0
2014-05-12 07:45:00	AAPL	Stock	21.0107	21.0107	21.0	21.0061	38248.0
2014-05-12 07:50:00	AAPL	Stock	21.0157	21.0179	21.0157	21.0168	14000.0
2014-05-12 07:55:00	AAPL	Stock	21.0054	21.0204	21.0014	21.0143	36400.0
2014-05-12 08:00:00	AAPL	Stock	21.0004	21.0304	20.9821	20.9993	142100.0
2014-05-12 08:05:00	AAPL	Stock	20.9964	21.0086	20.9821	20.9821	185024.0
2014-05-12 08:10:00	AAPL	Stock	20.9825	20.9943	20.9643	20.9657	80080.0
2014-05-12 08:15:00	AAPL	Stock	20.9643	20.9643	20.9507	20.9507	30800.0
2014-05-12 08:20:00	AAPL	Stock	20.9536	20.9536	20.9368	20.9464	90328.0
2014-05-12 08:25:00	AAPL	Stock	20.9464	20.9464	20.9357	20.9357	64820.0
2014-05-12 08:30:00	AAPL	Stock	20.9357	20.9379	20.9286	20.9375	58800.0
2014-05-12 08:35:00	AAPL	Stock	20.9332	20.9464	20.9332	20.9464	71904.0
2014-05-12 08:40:00	AAPL	Stock	20.9457	20.9464	20.9457	20.9464	14000.0
2014-05-12 08:45:00	AAPL	Stock	20.9607	20.9821	20.9607	20.9771	192780.0
2014-05-12 08:50:00	AAPL	Stock	20.9918	20.9918	20.9829	20.9871	18200.0
2014-05-12 08:55:00	AAPL	Stock	20.9821	20.9836	20.9125	20.9125	5271224.0
2014-05-12 09:00:00	AAPL	Stock	20.9861	20.9929	20.9861	20.9882	31360.0
2014-05-12 09:05:00	AAPL	Stock	20.9868	20.9882	20.9754	20.9754	38500.0
2014-05-12 09:10:00	AAPL	Stock	20.9736	20.9868	20.9729	20.9864	54600.0
2014-05-12 09:15:00	AAPL	Stock	20.985	20.985	20.9825	20.9839	40600.0
2014-05-12 09:20:00	AAPL	Stock	20.9814	20.9839	20.9786	20.9818	64400.0
2014-05-12 09:25:00	AAPL	Stock	20.9818	20.9839	20.9679	20.9714	180852.0
2014-05-12 09:30:00	AAPL	Stock	20.98	21.0471	20.9786	21.0375	10597748.0
2014-05-12 09:35:00	AAPL	Stock	21.0418	21.0607	21.0254	21.0518	6902924.0
2014-05-12 09:40:00	AAPL	Stock	21.0532	21.0657	21.0418	21.0646	4743424.0
2014-05-12 09:45:00	AAPL	Stock	21.0646	21.0875	21.0639	21.0786	5459552.0
2014-05-12 09:50:00	AAPL	Stock	21.0789	21.0939	21.0607	21.0782	3770872.0
2014-05-12 09:55:00	AAPL	Stock	21.0775	21.0975	21.0714	21.095	3964380.0
2014-05-12 10:00:00	AAPL	Stock	21.095	21.0982	21.0539	21.0743	2994824.0
2014-05-12 10:05:00	AAPL	Stock	21.0764	21.0854	21.0586	21.0621	1769600.0
2014-05-12 10:10:00	AAPL	Stock	21.0629	21.0907	21.0629	21.087	2464476.0
2014-05-12 10:15:00	AAPL	Stock	21.0821	21.1264	21.0814	21.1205	4127256.0
2014-05-12 10:20:00	AAPL	Stock	21.1227	21.1321	21.0986	21.115	2385824.0
2014-05-12 10:25:00	AAPL	Stock	21.1154	21.1239	21.095	21.1068	1353800.0
2014-05-12 10:30:00	AAPL	Stock	21.0996	21.1089	21.0907	21.0992	1450456.0

> showing 50 of 364,938 rows — these rows as CSV

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