PREVIEW / stock_1min / 2012-06-14

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-06-14.parquet
  size:    12.7 MB
  rows:    960,655
  symbols: 2,836

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-06-14 04:00:00	AAPL	Stock	20.4996	20.4996	20.4996	20.4996	2800.0
2012-06-14 04:52:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	5460.0
2012-06-14 05:01:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	5600.0
2012-06-14 06:11:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	3220.0
2012-06-14 06:21:00	AAPL	Stock	20.4454	20.4454	20.4454	20.4454	5600.0
2012-06-14 06:22:00	AAPL	Stock	20.4454	20.4454	20.4454	20.4454	5600.0
2012-06-14 07:02:00	AAPL	Stock	20.4643	20.4746	20.4643	20.4643	41776.0
2012-06-14 07:05:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	8540.0
2012-06-14 07:11:00	AAPL	Stock	20.4561	20.4561	20.4561	20.4561	8400.0
2012-06-14 07:12:00	AAPL	Stock	20.4486	20.4486	20.4429	20.4429	8400.0
2012-06-14 07:14:00	AAPL	Stock	20.4429	20.4429	20.4429	20.4429	19600.0
2012-06-14 07:15:00	AAPL	Stock	20.4432	20.4432	20.4429	20.4429	8400.0
2012-06-14 07:28:00	AAPL	Stock	20.4486	20.4486	20.4429	20.4429	25200.0
2012-06-14 07:29:00	AAPL	Stock	20.4429	20.4429	20.4429	20.4429	4200.0
2012-06-14 07:35:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	12600.0
2012-06-14 07:37:00	AAPL	Stock	20.4375	20.4375	20.4375	20.4375	3724.0
2012-06-14 07:39:00	AAPL	Stock	20.4339	20.4339	20.4339	20.4339	2800.0
2012-06-14 07:44:00	AAPL	Stock	20.4246	20.4246	20.4246	20.4246	2800.0
2012-06-14 07:45:00	AAPL	Stock	20.4143	20.4143	20.4143	20.4143	2800.0
2012-06-14 07:47:00	AAPL	Stock	20.4107	20.4107	20.4036	20.4036	13580.0
2012-06-14 07:50:00	AAPL	Stock	20.4107	20.4107	20.4107	20.4107	2800.0
2012-06-14 07:59:00	AAPL	Stock	20.4161	20.4161	20.4161	20.4161	22176.0
2012-06-14 08:00:00	AAPL	Stock	20.4289	20.4321	20.4243	20.4243	10360.0
2012-06-14 08:01:00	AAPL	Stock	20.4196	20.4196	20.4125	20.4125	5600.0
2012-06-14 08:02:00	AAPL	Stock	20.4089	20.4089	20.4089	20.4089	2800.0
2012-06-14 08:03:00	AAPL	Stock	20.4075	20.4075	20.4075	20.4075	2800.0
2012-06-14 08:05:00	AAPL	Stock	20.4107	20.4107	20.4107	20.4107	2800.0
2012-06-14 08:07:00	AAPL	Stock	20.4004	20.4004	20.4004	20.4004	12600.0
2012-06-14 08:08:00	AAPL	Stock	20.3964	20.4004	20.3964	20.4004	15652.0
2012-06-14 08:09:00	AAPL	Stock	20.3964	20.3968	20.3889	20.3889	50400.0
2012-06-14 08:10:00	AAPL	Stock	20.3793	20.3804	20.3793	20.3804	16800.0
2012-06-14 08:11:00	AAPL	Stock	20.3914	20.3914	20.3914	20.3914	2800.0
2012-06-14 08:13:00	AAPL	Stock	20.3861	20.3864	20.3839	20.3839	14000.0
2012-06-14 08:14:00	AAPL	Stock	20.375	20.3786	20.375	20.3786	16800.0
2012-06-14 08:15:00	AAPL	Stock	20.3761	20.3761	20.3761	20.3761	5600.0
2012-06-14 08:16:00	AAPL	Stock	20.3839	20.3861	20.3839	20.3861	6300.0
2012-06-14 08:17:00	AAPL	Stock	20.3764	20.3832	20.3764	20.3775	10780.0
2012-06-14 08:18:00	AAPL	Stock	20.3921	20.3925	20.3839	20.3925	27300.0
2012-06-14 08:19:00	AAPL	Stock	20.3914	20.3925	20.3911	20.3925	29260.0
2012-06-14 08:21:00	AAPL	Stock	20.3964	20.3964	20.3964	20.3964	10192.0
2012-06-14 08:22:00	AAPL	Stock	20.3989	20.3989	20.3989	20.3989	11900.0
2012-06-14 08:23:00	AAPL	Stock	20.4054	20.4107	20.4054	20.4068	22540.0
2012-06-14 08:24:00	AAPL	Stock	20.4139	20.4175	20.4139	20.4175	8400.0
2012-06-14 08:26:00	AAPL	Stock	20.4171	20.4214	20.4171	20.4214	8400.0
2012-06-14 08:27:00	AAPL	Stock	20.4289	20.4325	20.4286	20.4286	32536.0
2012-06-14 08:29:00	AAPL	Stock	20.4132	20.4132	20.4107	20.4107	7420.0
2012-06-14 08:30:00	AAPL	Stock	20.4054	20.4286	20.3929	20.4121	143612.0
2012-06-14 08:31:00	AAPL	Stock	20.41	20.41	20.4025	20.4025	16800.0
2012-06-14 08:32:00	AAPL	Stock	20.4018	20.4018	20.375	20.375	72800.0
2012-06-14 08:33:00	AAPL	Stock	20.3886	20.3889	20.3871	20.3889	30800.0

> showing 50 of 960,655 rows — these rows as CSV

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