PREVIEW / stock_5min / 2012-04-20

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-20.parquet
  size:    4.8 MB
  rows:    322,928
  symbols: 3,515

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
2012-04-20 04:00:00	AAPL	Stock	21.0	21.0	21.0	21.0	9828.0
2012-04-20 04:05:00	AAPL	Stock	21.0614	21.0614	21.0607	21.0607	27860.0
2012-04-20 04:20:00	AAPL	Stock	21.0568	21.0568	21.0414	21.0546	8400.0
2012-04-20 04:35:00	AAPL	Stock	21.0518	21.0518	21.0518	21.0518	2800.0
2012-04-20 04:40:00	AAPL	Stock	21.02	21.02	21.02	21.02	5600.0
2012-04-20 04:50:00	AAPL	Stock	21.0132	21.0132	21.0	21.0039	47572.0
2012-04-20 05:00:00	AAPL	Stock	20.9821	20.9821	20.9768	20.9768	16800.0
2012-04-20 05:05:00	AAPL	Stock	20.9686	20.9686	20.9643	20.9643	11200.0
2012-04-20 05:15:00	AAPL	Stock	20.9786	20.9786	20.9786	20.9786	2800.0
2012-04-20 05:50:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	2800.0
2012-04-20 06:15:00	AAPL	Stock	21.0189	21.0189	21.0189	21.0189	2800.0
2012-04-20 06:20:00	AAPL	Stock	21.0357	21.0357	21.0357	21.0357	27720.0
2012-04-20 06:25:00	AAPL	Stock	21.0393	21.0393	21.0393	21.0393	2800.0
2012-04-20 06:35:00	AAPL	Stock	21.0664	21.0664	21.0664	21.0664	2800.0
2012-04-20 06:50:00	AAPL	Stock	21.0714	21.0714	21.0536	21.0536	16800.0
2012-04-20 06:55:00	AAPL	Stock	21.0482	21.0714	21.0482	21.0714	29400.0
2012-04-20 07:00:00	AAPL	Stock	21.0714	21.0718	21.0482	21.0536	144900.0
2012-04-20 07:05:00	AAPL	Stock	21.0536	21.0536	21.0357	21.0357	106708.0
2012-04-20 07:10:00	AAPL	Stock	21.0464	21.0464	21.0446	21.0446	5600.0
2012-04-20 07:15:00	AAPL	Stock	21.05	21.05	21.0214	21.0214	65268.0
2012-04-20 07:20:00	AAPL	Stock	21.0232	21.0493	21.0214	21.0321	163856.0
2012-04-20 07:25:00	AAPL	Stock	21.0286	21.0286	21.0018	21.0171	73108.0
2012-04-20 07:30:00	AAPL	Stock	21.0171	21.0171	21.0	21.0	140840.0
2012-04-20 07:35:00	AAPL	Stock	20.9921	20.9929	20.9464	20.9636	100240.0
2012-04-20 07:40:00	AAPL	Stock	20.9614	20.9614	20.9018	20.9425	336392.0
2012-04-20 07:45:00	AAPL	Stock	20.925	20.9375	20.9071	20.9286	87332.0
2012-04-20 07:50:00	AAPL	Stock	20.9243	20.9486	20.9154	20.9461	199024.0
2012-04-20 07:55:00	AAPL	Stock	20.9461	20.9461	20.9293	20.9361	60424.0
2012-04-20 08:00:00	AAPL	Stock	20.9432	21.0711	20.9289	20.98	721056.0
2012-04-20 08:05:00	AAPL	Stock	20.9757	21.0536	20.9704	20.9957	750344.0
2012-04-20 08:10:00	AAPL	Stock	20.9957	21.0314	20.9793	20.9971	490588.0
2012-04-20 08:15:00	AAPL	Stock	20.9929	21.0	20.9689	20.9689	380828.0
2012-04-20 08:20:00	AAPL	Stock	20.9782	21.005	20.9782	20.9879	132300.0
2012-04-20 08:25:00	AAPL	Stock	20.9954	20.9957	20.9661	20.9664	259196.0
2012-04-20 08:30:00	AAPL	Stock	20.9689	20.9821	20.9364	20.9382	490252.0
2012-04-20 08:35:00	AAPL	Stock	20.9525	20.9525	20.9168	20.9196	571144.0
2012-04-20 08:40:00	AAPL	Stock	20.925	20.9432	20.92	20.9225	379876.0
2012-04-20 08:45:00	AAPL	Stock	20.9275	20.9618	20.9257	20.9554	168980.0
2012-04-20 08:50:00	AAPL	Stock	20.9564	20.9946	20.9482	20.9946	547876.0
2012-04-20 08:55:00	AAPL	Stock	20.9936	21.0536	20.9936	21.0536	908460.0
2012-04-20 09:00:00	AAPL	Stock	21.0507	21.1154	21.0507	21.1039	1501528.0
2012-04-20 09:05:00	AAPL	Stock	21.1046	21.1282	21.09	21.1075	1115212.0
2012-04-20 09:10:00	AAPL	Stock	21.1136	21.1407	21.0954	21.1239	618380.0
2012-04-20 09:15:00	AAPL	Stock	21.1225	21.135	21.0875	21.125	743288.0
2012-04-20 09:20:00	AAPL	Stock	21.1111	21.1111	21.075	21.0786	458136.0
2012-04-20 09:25:00	AAPL	Stock	21.0804	21.1425	21.0782	21.1339	1623580.0
2012-04-20 09:30:00	AAPL	Stock	21.1321	21.14	20.9554	21.0	26967892.0
2012-04-20 09:35:00	AAPL	Stock	21.0125	21.0125	20.7989	20.8371	30850148.0
2012-04-20 09:40:00	AAPL	Stock	20.8352	20.9689	20.8075	20.8286	25212488.0
2012-04-20 09:45:00	AAPL	Stock	20.8225	20.9143	20.79	20.8864	16495836.0

> showing 50 of 322,928 rows — these rows as CSV

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