PREVIEW / stock_1min / 2012-04-20

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-04-20.parquet
  size:    12.7 MB
  rows:    948,954
  symbols: 2,840

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:07:00	AAPL	Stock	21.0614	21.0614	21.0614	21.0614	11200.0
2012-04-20 04:08:00	AAPL	Stock	21.0614	21.0614	21.0607	21.0607	16660.0
2012-04-20 04:20:00	AAPL	Stock	21.0568	21.0568	21.0568	21.0568	2800.0
2012-04-20 04:21:00	AAPL	Stock	21.0414	21.0546	21.0414	21.0546	5600.0
2012-04-20 04:35:00	AAPL	Stock	21.0518	21.0518	21.0518	21.0518	2800.0
2012-04-20 04:44:00	AAPL	Stock	21.02	21.02	21.02	21.02	5600.0
2012-04-20 04:51:00	AAPL	Stock	21.0132	21.0132	21.0125	21.0125	19600.0
2012-04-20 04:52:00	AAPL	Stock	21.0043	21.0043	21.0	21.0	22372.0
2012-04-20 04:53:00	AAPL	Stock	21.0039	21.0039	21.0039	21.0039	5600.0
2012-04-20 05:01:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	2800.0
2012-04-20 05:03:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	5600.0
2012-04-20 05:04:00	AAPL	Stock	20.9782	20.9782	20.9768	20.9768	8400.0
2012-04-20 05:07: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:54:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	2800.0
2012-04-20 06:16:00	AAPL	Stock	21.0189	21.0189	21.0189	21.0189	2800.0
2012-04-20 06:22:00	AAPL	Stock	21.0357	21.0357	21.0357	21.0357	27720.0
2012-04-20 06:27:00	AAPL	Stock	21.0393	21.0393	21.0393	21.0393	2800.0
2012-04-20 06:39: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.0714	21.0714	14000.0
2012-04-20 06:54:00	AAPL	Stock	21.0536	21.0536	21.0536	21.0536	2800.0
2012-04-20 06:55:00	AAPL	Stock	21.0482	21.0714	21.0482	21.0714	26600.0
2012-04-20 06:59:00	AAPL	Stock	21.0714	21.0714	21.0714	21.0714	2800.0
2012-04-20 07:00:00	AAPL	Stock	21.0714	21.0714	21.0643	21.0643	11200.0
2012-04-20 07:01:00	AAPL	Stock	21.0711	21.0718	21.0625	21.0625	102900.0
2012-04-20 07:02:00	AAPL	Stock	21.0482	21.0482	21.0482	21.0482	2800.0
2012-04-20 07:03:00	AAPL	Stock	21.0536	21.0536	21.0482	21.0489	14000.0
2012-04-20 07:04:00	AAPL	Stock	21.0482	21.0536	21.0482	21.0536	14000.0
2012-04-20 07:05:00	AAPL	Stock	21.0536	21.0536	21.0414	21.0414	20748.0
2012-04-20 07:06:00	AAPL	Stock	21.0418	21.0482	21.0418	21.0482	44800.0
2012-04-20 07:07:00	AAPL	Stock	21.0532	21.0532	21.0411	21.0411	15960.0
2012-04-20 07:08:00	AAPL	Stock	21.0382	21.0386	21.0375	21.0386	11200.0
2012-04-20 07:09:00	AAPL	Stock	21.0468	21.0468	21.0357	21.0357	14000.0
2012-04-20 07:10:00	AAPL	Stock	21.0464	21.0464	21.0464	21.0464	2800.0
2012-04-20 07:11:00	AAPL	Stock	21.0446	21.0446	21.0446	21.0446	2800.0
2012-04-20 07:15:00	AAPL	Stock	21.05	21.05	21.05	21.05	5348.0
2012-04-20 07:16:00	AAPL	Stock	21.0429	21.0429	21.0357	21.0429	17920.0
2012-04-20 07:17:00	AAPL	Stock	21.0364	21.0364	21.0357	21.0357	16800.0
2012-04-20 07:18:00	AAPL	Stock	21.0429	21.0429	21.0429	21.0429	2800.0
2012-04-20 07:19:00	AAPL	Stock	21.0368	21.0368	21.0214	21.0214	22400.0
2012-04-20 07:20:00	AAPL	Stock	21.0232	21.0271	21.0232	21.0271	12600.0
2012-04-20 07:21:00	AAPL	Stock	21.0357	21.0493	21.0214	21.0429	22456.0
2012-04-20 07:22:00	AAPL	Stock	21.0357	21.0357	21.0357	21.0357	14000.0
2012-04-20 07:23:00	AAPL	Stock	21.0321	21.0321	21.0321	21.0321	2800.0
2012-04-20 07:24:00	AAPL	Stock	21.0318	21.0357	21.0318	21.0321	112000.0
2012-04-20 07:25:00	AAPL	Stock	21.0286	21.0286	21.0179	21.0179	30800.0
2012-04-20 07:26:00	AAPL	Stock	21.0018	21.0018	21.0018	21.0018	4200.0
2012-04-20 07:27:00	AAPL	Stock	21.0179	21.0214	21.0179	21.0214	15708.0
2012-04-20 07:28:00	AAPL	Stock	21.0179	21.0179	21.0179	21.0179	8400.0

> showing 50 of 948,954 rows — these rows as CSV

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