PREVIEW / stock_1min / 2011-01-05

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-01-05.parquet
  size:    13.4 MB
  rows:    999,752
  symbols: 2,858

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-01-05 04:00:00	AAPL	Stock	11.5714	11.5714	11.5714	11.5714	2800.0
2011-01-05 04:05:00	AAPL	Stock	11.8161	11.8161	11.8161	11.8161	2800.0
2011-01-05 04:27:00	AAPL	Stock	11.8125	11.8125	11.8125	11.8125	2800.0
2011-01-05 05:27:00	AAPL	Stock	11.7886	11.7886	11.7886	11.7886	2800.0
2011-01-05 05:38:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	2800.0
2011-01-05 05:39:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	8400.0
2011-01-05 05:40:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	14000.0
2011-01-05 05:44:00	AAPL	Stock	11.8	11.8	11.8	11.8	5600.0
2011-01-05 06:00:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	8400.0
2011-01-05 06:02:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	5600.0
2011-01-05 06:11:00	AAPL	Stock	11.7929	11.7929	11.7929	11.7929	2800.0
2011-01-05 06:12:00	AAPL	Stock	11.7907	11.7907	11.7907	11.7907	2800.0
2011-01-05 06:32:00	AAPL	Stock	11.7746	11.7746	11.7746	11.7746	2800.0
2011-01-05 06:58:00	AAPL	Stock	11.7839	11.7839	11.7839	11.7839	2800.0
2011-01-05 07:03:00	AAPL	Stock	11.7618	11.7618	11.7618	11.7618	5600.0
2011-01-05 07:15:00	AAPL	Stock	11.7679	11.7679	11.7671	11.7671	13160.0
2011-01-05 07:17:00	AAPL	Stock	11.7757	11.7757	11.7757	11.7757	5600.0
2011-01-05 07:18:00	AAPL	Stock	11.7757	11.7757	11.7757	11.7757	2800.0
2011-01-05 07:25:00	AAPL	Stock	11.7682	11.7682	11.7682	11.7682	2800.0
2011-01-05 07:27:00	AAPL	Stock	11.7682	11.7682	11.7679	11.7679	39200.0
2011-01-05 07:28:00	AAPL	Stock	11.7636	11.7636	11.7543	11.7543	33040.0
2011-01-05 07:30:00	AAPL	Stock	11.7543	11.7543	11.7543	11.7543	5600.0
2011-01-05 07:43:00	AAPL	Stock	11.7546	11.7546	11.7543	11.7543	8400.0
2011-01-05 07:44:00	AAPL	Stock	11.7564	11.7643	11.7546	11.7546	8400.0
2011-01-05 07:45:00	AAPL	Stock	11.7546	11.7546	11.7543	11.7543	14560.0
2011-01-05 07:46:00	AAPL	Stock	11.7571	11.7571	11.7571	11.7571	2800.0
2011-01-05 07:49:00	AAPL	Stock	11.7636	11.7639	11.7636	11.7639	5600.0
2011-01-05 07:50:00	AAPL	Stock	11.7621	11.7621	11.7621	11.7621	2800.0
2011-01-05 07:51:00	AAPL	Stock	11.75	11.75	11.75	11.75	5600.0
2011-01-05 07:52:00	AAPL	Stock	11.75	11.75	11.75	11.75	5320.0
2011-01-05 07:54:00	AAPL	Stock	11.7536	11.7625	11.7536	11.7625	11200.0
2011-01-05 07:56:00	AAPL	Stock	11.7532	11.7532	11.7532	11.7532	2800.0
2011-01-05 07:59:00	AAPL	Stock	11.7625	11.7639	11.7625	11.7625	36120.0
2011-01-05 08:00:00	AAPL	Stock	11.7536	11.7782	11.7532	11.7593	152488.0
2011-01-05 08:02:00	AAPL	Stock	11.7632	11.7632	11.7589	11.7589	43736.0
2011-01-05 08:03:00	AAPL	Stock	11.7618	11.7661	11.7618	11.7661	25032.0
2011-01-05 08:04:00	AAPL	Stock	11.7604	11.7682	11.7604	11.7679	22008.0
2011-01-05 08:05:00	AAPL	Stock	11.7661	11.7679	11.7661	11.7679	9800.0
2011-01-05 08:06:00	AAPL	Stock	11.7643	11.7661	11.7643	11.7661	15960.0
2011-01-05 08:07:00	AAPL	Stock	11.7679	11.7693	11.7679	11.7693	16968.0
2011-01-05 08:08:00	AAPL	Stock	11.7693	11.7704	11.7693	11.7704	28000.0
2011-01-05 08:09:00	AAPL	Stock	11.7725	11.7725	11.7714	11.7725	14000.0
2011-01-05 08:10:00	AAPL	Stock	11.7764	11.7768	11.7732	11.7768	132160.0
2011-01-05 08:11:00	AAPL	Stock	11.7768	11.7768	11.7768	11.7768	11200.0
2011-01-05 08:12:00	AAPL	Stock	11.7768	11.7768	11.7714	11.7714	8400.0
2011-01-05 08:13:00	AAPL	Stock	11.7704	11.775	11.7693	11.7718	140504.0
2011-01-05 08:14:00	AAPL	Stock	11.7718	11.7821	11.7718	11.7786	61600.0
2011-01-05 08:15:00	AAPL	Stock	11.7825	11.79	11.775	11.79	250208.0
2011-01-05 08:16:00	AAPL	Stock	11.7893	11.7946	11.7864	11.7921	33600.0
2011-01-05 08:17:00	AAPL	Stock	11.7893	11.7943	11.7857	11.7893	76300.0

> showing 50 of 999,752 rows — these rows as CSV

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