PREVIEW / stock_5min / 2013-07-23

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-23.parquet
  size:    5.1 MB
  rows:    339,884
  symbols: 3,504

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
2013-07-23 04:00:00	AAPL	Stock	15.2607	15.2607	15.2607	15.2607	5600.0
2013-07-23 06:35:00	AAPL	Stock	15.2493	15.2529	15.2493	15.2529	14028.0
2013-07-23 07:05:00	AAPL	Stock	15.2554	15.2554	15.2443	15.2443	47600.0
2013-07-23 07:20:00	AAPL	Stock	15.2482	15.2482	15.2482	15.2482	30800.0
2013-07-23 07:30:00	AAPL	Stock	15.2679	15.2679	15.2679	15.2679	5600.0
2013-07-23 07:50:00	AAPL	Stock	15.2639	15.3036	15.2639	15.3036	68880.0
2013-07-23 07:55:00	AAPL	Stock	15.3186	15.3221	15.3171	15.3221	70952.0
2013-07-23 08:00:00	AAPL	Stock	15.3214	15.3389	15.1964	15.2857	377300.0
2013-07-23 08:05:00	AAPL	Stock	15.27	15.2857	15.2696	15.2857	26600.0
2013-07-23 08:10:00	AAPL	Stock	15.2857	15.2857	15.2496	15.25	105840.0
2013-07-23 08:15:00	AAPL	Stock	15.2514	15.2679	15.2464	15.2557	47908.0
2013-07-23 08:20:00	AAPL	Stock	15.2554	15.2654	15.2554	15.2593	14000.0
2013-07-23 08:25:00	AAPL	Stock	15.2589	15.2607	15.2589	15.2607	11200.0
2013-07-23 08:30:00	AAPL	Stock	15.2607	15.2664	15.2607	15.2664	23800.0
2013-07-23 08:35:00	AAPL	Stock	15.2664	15.2686	15.2664	15.2679	19600.0
2013-07-23 08:40:00	AAPL	Stock	15.2711	15.2711	15.2711	15.2711	8400.0
2013-07-23 08:45:00	AAPL	Stock	15.2714	15.2768	15.2714	15.2739	92260.0
2013-07-23 08:50:00	AAPL	Stock	15.2779	15.2779	15.2696	15.2696	5600.0
2013-07-23 08:55:00	AAPL	Stock	15.2743	15.2743	15.2696	15.2696	25200.0
2013-07-23 09:00:00	AAPL	Stock	15.2679	15.2743	15.2679	15.2679	41076.0
2013-07-23 09:05:00	AAPL	Stock	15.2568	15.2568	15.2568	15.2568	8400.0
2013-07-23 09:10:00	AAPL	Stock	15.2564	15.2564	15.2554	15.2554	12040.0
2013-07-23 09:15:00	AAPL	Stock	15.2579	15.2714	15.2579	15.2714	40628.0
2013-07-23 09:20:00	AAPL	Stock	15.2671	15.2721	15.2671	15.2721	20272.0
2013-07-23 09:25:00	AAPL	Stock	15.2786	15.2786	15.2143	15.225	306040.0
2013-07-23 09:30:00	AAPL	Stock	15.2171	15.2486	15.1732	15.1903	10833144.0
2013-07-23 09:35:00	AAPL	Stock	15.1887	15.1929	15.1621	15.1732	4915792.0
2013-07-23 09:40:00	AAPL	Stock	15.1732	15.1775	15.0989	15.1354	9151996.0
2013-07-23 09:45:00	AAPL	Stock	15.1304	15.1621	15.1254	15.1621	3584840.0
2013-07-23 09:50:00	AAPL	Stock	15.1575	15.1725	15.1362	15.1514	4452140.0
2013-07-23 09:55:00	AAPL	Stock	15.1532	15.1607	15.1125	15.1164	2926056.0
2013-07-23 10:00:00	AAPL	Stock	15.1196	15.1339	15.0575	15.07	7820316.0
2013-07-23 10:05:00	AAPL	Stock	15.0675	15.0909	15.0643	15.0814	5409152.0
2013-07-23 10:10:00	AAPL	Stock	15.0814	15.1036	15.0679	15.095	4144588.0
2013-07-23 10:15:00	AAPL	Stock	15.1023	15.1157	15.0957	15.1004	2933504.0
2013-07-23 10:20:00	AAPL	Stock	15.0993	15.1304	15.0896	15.1093	3714424.0
2013-07-23 10:25:00	AAPL	Stock	15.1107	15.1268	15.0961	15.1054	2475172.0
2013-07-23 10:30:00	AAPL	Stock	15.1078	15.1094	15.0861	15.0991	2967524.0
2013-07-23 10:35:00	AAPL	Stock	15.1031	15.1031	15.0629	15.0826	4125240.0
2013-07-23 10:40:00	AAPL	Stock	15.0793	15.1071	15.0789	15.105	3078628.0
2013-07-23 10:45:00	AAPL	Stock	15.105	15.1071	15.075	15.0843	2471504.0
2013-07-23 10:50:00	AAPL	Stock	15.0832	15.1071	15.0714	15.1071	2809100.0
2013-07-23 10:55:00	AAPL	Stock	15.1071	15.1121	15.0946	15.0984	2030392.0
2013-07-23 11:00:00	AAPL	Stock	15.0982	15.1081	15.0796	15.1071	2301992.0
2013-07-23 11:05:00	AAPL	Stock	15.105	15.1289	15.1036	15.1179	4137700.0
2013-07-23 11:10:00	AAPL	Stock	15.1217	15.1346	15.1146	15.1346	2246888.0
2013-07-23 11:15:00	AAPL	Stock	15.135	15.1586	15.1293	15.1486	4888744.0
2013-07-23 11:20:00	AAPL	Stock	15.1489	15.155	15.1329	15.1391	1858220.0
2013-07-23 11:25:00	AAPL	Stock	15.1425	15.1496	15.1314	15.1407	1781668.0
2013-07-23 11:30:00	AAPL	Stock	15.1407	15.1535	15.1354	15.1486	1934464.0

> showing 50 of 339,884 rows — these rows as CSV

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