PREVIEW / stock_5min / 2011-03-18

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-03-18.parquet
  size:    5.0 MB
  rows:    336,762
  symbols: 3,514

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-03-18 04:00:00	AAPL	Stock	11.9643	11.9643	11.9643	11.9643	2800.0
2011-03-18 04:50:00	AAPL	Stock	12.0893	12.0893	12.0893	12.0893	2800.0
2011-03-18 05:25:00	AAPL	Stock	12.0496	12.0496	12.0357	12.0357	14000.0
2011-03-18 05:30:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	14000.0
2011-03-18 05:35:00	AAPL	Stock	12.0418	12.0418	12.0357	12.0357	25200.0
2011-03-18 05:40:00	AAPL	Stock	12.0243	12.0357	12.0232	12.0357	11200.0
2011-03-18 05:45:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	5600.0
2011-03-18 05:50:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	2800.0
2011-03-18 05:55:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	5600.0
2011-03-18 06:00:00	AAPL	Stock	12.0357	12.0357	12.0218	12.0218	16800.0
2011-03-18 06:05:00	AAPL	Stock	12.0039	12.0039	12.0039	12.0039	2800.0
2011-03-18 06:10:00	AAPL	Stock	12.0111	12.0111	12.0111	12.0111	2800.0
2011-03-18 06:35:00	AAPL	Stock	12.0054	12.0054	12.0054	12.0054	2800.0
2011-03-18 06:45:00	AAPL	Stock	12.0321	12.0321	12.0321	12.0321	2800.0
2011-03-18 06:50:00	AAPL	Stock	11.9893	11.9893	11.9643	11.9643	67200.0
2011-03-18 06:55:00	AAPL	Stock	11.9643	11.9857	11.9468	11.9821	64400.0
2011-03-18 07:00:00	AAPL	Stock	11.9821	12.0143	11.9821	12.0143	42000.0
2011-03-18 07:05:00	AAPL	Stock	12.0071	12.0071	11.9836	11.9925	28000.0
2011-03-18 07:10:00	AAPL	Stock	12.0071	12.0071	12.0	12.0071	29792.0
2011-03-18 07:15:00	AAPL	Stock	12.0	12.0107	12.0	12.0107	8400.0
2011-03-18 07:20:00	AAPL	Stock	12.0175	12.0514	12.0175	12.0357	235900.0
2011-03-18 07:25:00	AAPL	Stock	12.0414	12.0429	12.03	12.0354	200760.0
2011-03-18 07:30:00	AAPL	Stock	12.0343	12.0429	12.0343	12.0429	115976.0
2011-03-18 07:35:00	AAPL	Stock	12.0429	12.0429	12.03	12.03	30240.0
2011-03-18 07:40:00	AAPL	Stock	12.0307	12.0514	12.0304	12.0464	132720.0
2011-03-18 07:45:00	AAPL	Stock	12.0514	12.0596	12.0429	12.0471	134456.0
2011-03-18 07:50:00	AAPL	Stock	12.0539	12.0607	12.0539	12.0607	55132.0
2011-03-18 07:55:00	AAPL	Stock	12.0546	12.0554	12.0464	12.0464	51800.0
2011-03-18 08:00:00	AAPL	Stock	12.0464	12.0714	12.04	12.0464	1236116.0
2011-03-18 08:05:00	AAPL	Stock	12.0464	12.0486	12.0357	12.0404	351736.0
2011-03-18 08:10:00	AAPL	Stock	12.0404	12.0407	12.0261	12.0261	429632.0
2011-03-18 08:15:00	AAPL	Stock	12.0254	12.0404	12.0225	12.0404	227444.0
2011-03-18 08:20:00	AAPL	Stock	12.0404	12.0443	12.0357	12.0436	205212.0
2011-03-18 08:25:00	AAPL	Stock	12.0425	12.0479	12.0286	12.0343	561372.0
2011-03-18 08:30:00	AAPL	Stock	12.0293	12.0446	12.0293	12.0357	114604.0
2011-03-18 08:35:00	AAPL	Stock	12.0357	12.0532	12.0321	12.0532	438536.0
2011-03-18 08:40:00	AAPL	Stock	12.0536	12.0804	12.0536	12.0754	912324.0
2011-03-18 08:45:00	AAPL	Stock	12.075	12.0893	12.0714	12.0893	650496.0
2011-03-18 08:50:00	AAPL	Stock	12.0889	12.0929	12.0804	12.0821	382956.0
2011-03-18 08:55:00	AAPL	Stock	12.0804	12.0804	12.0632	12.0661	330036.0
2011-03-18 09:00:00	AAPL	Stock	12.0696	12.0696	12.0557	12.0589	302540.0
2011-03-18 09:05:00	AAPL	Stock	12.0586	12.0746	12.0586	12.0714	741692.0
2011-03-18 09:10:00	AAPL	Stock	12.0714	12.0864	12.0711	12.0857	644756.0
2011-03-18 09:15:00	AAPL	Stock	12.0879	12.0882	12.0754	12.0786	402976.0
2011-03-18 09:20:00	AAPL	Stock	12.0768	12.0868	12.0714	12.0821	1027068.0
2011-03-18 09:25:00	AAPL	Stock	12.085	12.1036	12.0432	12.0432	3218376.0
2011-03-18 09:30:00	AAPL	Stock	12.0468	12.0786	12.0168	12.0457	102367132.0
2011-03-18 09:35:00	AAPL	Stock	12.045	12.0486	11.9821	12.0097	22542968.0
2011-03-18 09:40:00	AAPL	Stock	12.0136	12.0279	11.9907	11.9926	13072640.0
2011-03-18 09:45:00	AAPL	Stock	11.9941	12.0218	11.97	11.9925	13136508.0

> showing 50 of 336,762 rows — these rows as CSV

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