PREVIEW / stock_1min / 2012-01-27

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-01-27.parquet
  size:    12.6 MB
  rows:    938,057
  symbols: 2,842

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-01-27 04:00:00	AAPL	Stock	15.9039	15.9039	15.9039	15.9039	2800.0
2012-01-27 04:12:00	AAPL	Stock	15.9104	15.9104	15.9104	15.9104	2800.0
2012-01-27 04:19:00	AAPL	Stock	15.925	15.925	15.925	15.925	2800.0
2012-01-27 04:20:00	AAPL	Stock	15.9396	15.9396	15.9396	15.9396	2800.0
2012-01-27 04:24:00	AAPL	Stock	15.9429	15.9429	15.9429	15.9429	2800.0
2012-01-27 04:48:00	AAPL	Stock	15.9446	15.9446	15.9446	15.9446	2800.0
2012-01-27 04:49:00	AAPL	Stock	15.9464	15.9464	15.9464	15.9464	5600.0
2012-01-27 04:51:00	AAPL	Stock	15.9464	15.9464	15.9464	15.9464	8400.0
2012-01-27 05:05:00	AAPL	Stock	15.9639	15.9639	15.9639	15.9639	5600.0
2012-01-27 05:06:00	AAPL	Stock	15.9607	15.9607	15.9607	15.9607	2800.0
2012-01-27 05:07:00	AAPL	Stock	15.96	15.9611	15.96	15.9611	8400.0
2012-01-27 05:08:00	AAPL	Stock	15.9596	15.9596	15.9596	15.9596	5600.0
2012-01-27 05:12:00	AAPL	Stock	15.9636	15.9636	15.9636	15.9636	2800.0
2012-01-27 05:13:00	AAPL	Stock	15.9639	15.9639	15.9639	15.9639	2800.0
2012-01-27 05:19:00	AAPL	Stock	15.9732	15.9732	15.9732	15.9732	5600.0
2012-01-27 05:20:00	AAPL	Stock	15.9732	15.9732	15.9732	15.9732	2800.0
2012-01-27 05:33:00	AAPL	Stock	15.975	15.975	15.975	15.975	2800.0
2012-01-27 05:34:00	AAPL	Stock	15.9754	15.9754	15.9754	15.9754	2800.0
2012-01-27 05:43:00	AAPL	Stock	15.9754	15.9754	15.9754	15.9754	2800.0
2012-01-27 06:13:00	AAPL	Stock	15.9718	15.9718	15.9718	15.9718	5600.0
2012-01-27 06:14:00	AAPL	Stock	15.9825	15.9825	15.9825	15.9825	5600.0
2012-01-27 06:15:00	AAPL	Stock	15.9686	15.9686	15.9686	15.9686	2800.0
2012-01-27 06:18:00	AAPL	Stock	15.9686	15.9686	15.9686	15.9686	5600.0
2012-01-27 06:29:00	AAPL	Stock	15.9614	15.9614	15.9586	15.9586	11200.0
2012-01-27 06:31:00	AAPL	Stock	15.9643	15.9643	15.9643	15.9643	14000.0
2012-01-27 06:38:00	AAPL	Stock	15.9643	15.9643	15.9643	15.9643	2800.0
2012-01-27 06:44:00	AAPL	Stock	15.9607	15.9607	15.9607	15.9607	5600.0
2012-01-27 07:02:00	AAPL	Stock	15.9464	15.9464	15.9464	15.9464	19320.0
2012-01-27 07:03:00	AAPL	Stock	15.9429	15.9429	15.9429	15.9429	2800.0
2012-01-27 07:08:00	AAPL	Stock	15.9304	15.9332	15.9293	15.9293	98000.0
2012-01-27 07:09:00	AAPL	Stock	15.9279	15.9286	15.9279	15.9282	19600.0
2012-01-27 07:10:00	AAPL	Stock	15.9286	15.9286	15.9286	15.9286	14252.0
2012-01-27 07:21:00	AAPL	Stock	15.9286	15.9286	15.9286	15.9286	2800.0
2012-01-27 07:22:00	AAPL	Stock	15.9286	15.9286	15.9286	15.9286	5600.0
2012-01-27 07:23:00	AAPL	Stock	15.9286	15.9286	15.9286	15.9286	2800.0
2012-01-27 07:26:00	AAPL	Stock	15.9293	15.9293	15.9293	15.9293	14000.0
2012-01-27 07:27:00	AAPL	Stock	15.9357	15.9357	15.9357	15.9357	2800.0
2012-01-27 07:31:00	AAPL	Stock	15.9293	15.9293	15.9293	15.9293	39200.0
2012-01-27 07:33:00	AAPL	Stock	15.9357	15.9357	15.9357	15.9357	2800.0
2012-01-27 07:44:00	AAPL	Stock	15.9421	15.9421	15.9421	15.9421	9100.0
2012-01-27 07:48:00	AAPL	Stock	15.9293	15.9293	15.9293	15.9293	5460.0
2012-01-27 07:49:00	AAPL	Stock	15.9375	15.9375	15.9375	15.9375	5600.0
2012-01-27 07:51:00	AAPL	Stock	15.9375	15.9375	15.9375	15.9375	2800.0
2012-01-27 07:54:00	AAPL	Stock	15.9286	15.9286	15.9225	15.9225	19460.0
2012-01-27 07:56:00	AAPL	Stock	15.9182	15.9182	15.9182	15.9182	5600.0
2012-01-27 07:57:00	AAPL	Stock	15.9179	15.9179	15.9036	15.9039	44800.0
2012-01-27 07:59:00	AAPL	Stock	15.9096	15.9096	15.9096	15.9096	16800.0
2012-01-27 08:00:00	AAPL	Stock	15.9071	15.9268	15.9071	15.9071	49196.0
2012-01-27 08:02:00	AAPL	Stock	15.9164	15.925	15.9136	15.9136	29960.0
2012-01-27 08:03:00	AAPL	Stock	15.9132	15.9132	15.9032	15.9071	56000.0

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

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