PREVIEW / stock_5min / 2010-09-27

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-09-27.parquet
  size:    4.6 MB
  rows:    317,330
  symbols: 3,490

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
2010-09-27 04:20:00	AAPL	Stock	10.4679	10.4679	10.4679	10.4679	2800.0
2010-09-27 05:45:00	AAPL	Stock	10.4757	10.4982	10.4757	10.4982	5600.0
2010-09-27 05:55:00	AAPL	Stock	10.4911	10.4911	10.4911	10.4911	8400.0
2010-09-27 06:10:00	AAPL	Stock	10.4911	10.4911	10.4911	10.4911	2800.0
2010-09-27 06:30:00	AAPL	Stock	10.4814	10.4814	10.47	10.47	25200.0
2010-09-27 06:50:00	AAPL	Stock	10.4643	10.4643	10.4643	10.4643	2800.0
2010-09-27 07:00:00	AAPL	Stock	10.4761	10.4761	10.4761	10.4761	5600.0
2010-09-27 07:10:00	AAPL	Stock	10.4786	10.4818	10.4786	10.4818	20440.0
2010-09-27 07:15:00	AAPL	Stock	10.4821	10.4821	10.4704	10.4707	8400.0
2010-09-27 07:20:00	AAPL	Stock	10.4821	10.4836	10.4732	10.4732	100940.0
2010-09-27 07:25:00	AAPL	Stock	10.4718	10.475	10.4711	10.4714	86800.0
2010-09-27 07:30:00	AAPL	Stock	10.4714	10.4714	10.4643	10.4643	58800.0
2010-09-27 07:35:00	AAPL	Stock	10.4643	10.4679	10.4643	10.4679	42000.0
2010-09-27 07:40:00	AAPL	Stock	10.4696	10.4696	10.4696	10.4696	15400.0
2010-09-27 07:50:00	AAPL	Stock	10.4729	10.4786	10.4643	10.4786	61600.0
2010-09-27 07:55:00	AAPL	Stock	10.4732	10.4757	10.4714	10.4757	22400.0
2010-09-27 08:00:00	AAPL	Stock	10.4786	10.4921	10.4657	10.4893	889252.0
2010-09-27 08:05:00	AAPL	Stock	10.4893	10.51	10.4893	10.5071	472388.0
2010-09-27 08:10:00	AAPL	Stock	10.5064	10.5214	10.5054	10.5214	450772.0
2010-09-27 08:15:00	AAPL	Stock	10.5214	10.5346	10.5211	10.5321	665672.0
2010-09-27 08:20:00	AAPL	Stock	10.5289	10.5339	10.5268	10.5339	434448.0
2010-09-27 08:25:00	AAPL	Stock	10.5321	10.5321	10.5239	10.5257	311220.0
2010-09-27 08:30:00	AAPL	Stock	10.5261	10.5282	10.5232	10.5257	604044.0
2010-09-27 08:35:00	AAPL	Stock	10.525	10.5286	10.5179	10.5179	257180.0
2010-09-27 08:40:00	AAPL	Stock	10.5221	10.525	10.5193	10.5207	258020.0
2010-09-27 08:45:00	AAPL	Stock	10.5229	10.5286	10.5214	10.5286	441476.0
2010-09-27 08:50:00	AAPL	Stock	10.5304	10.5304	10.5264	10.5286	360500.0
2010-09-27 08:55:00	AAPL	Stock	10.5286	10.5307	10.5286	10.5289	138236.0
2010-09-27 09:00:00	AAPL	Stock	10.5289	10.5321	10.5236	10.5236	310856.0
2010-09-27 09:05:00	AAPL	Stock	10.5236	10.5271	10.5179	10.52	336532.0
2010-09-27 09:10:00	AAPL	Stock	10.5239	10.5239	10.5118	10.5125	435540.0
2010-09-27 09:15:00	AAPL	Stock	10.5107	10.5132	10.5089	10.5093	278012.0
2010-09-27 09:20:00	AAPL	Stock	10.5093	10.5107	10.5089	10.5093	86828.0
2010-09-27 09:25:00	AAPL	Stock	10.5082	10.5082	10.485	10.4964	396116.0
2010-09-27 09:30:00	AAPL	Stock	10.4991	10.5004	10.4561	10.4761	19618284.0
2010-09-27 09:35:00	AAPL	Stock	10.4761	10.5261	10.4757	10.485	21100688.0
2010-09-27 09:40:00	AAPL	Stock	10.4843	10.5089	10.4604	10.49	16397024.0
2010-09-27 09:45:00	AAPL	Stock	10.4882	10.5043	10.4779	10.4836	11373292.0
2010-09-27 09:50:00	AAPL	Stock	10.4861	10.5125	10.4793	10.5125	11733456.0
2010-09-27 09:55:00	AAPL	Stock	10.5118	10.5132	10.4625	10.4764	15982820.0
2010-09-27 10:00:00	AAPL	Stock	10.4761	10.4804	10.4654	10.48	6357484.0
2010-09-27 10:05:00	AAPL	Stock	10.4804	10.4921	10.4718	10.4748	6206760.0
2010-09-27 10:10:00	AAPL	Stock	10.4732	10.475	10.4414	10.445	13718628.0
2010-09-27 10:15:00	AAPL	Stock	10.4432	10.4607	10.4325	10.4564	9690632.0
2010-09-27 10:20:00	AAPL	Stock	10.4546	10.4802	10.4438	10.4761	7213052.0
2010-09-27 10:25:00	AAPL	Stock	10.4761	10.4796	10.4592	10.4746	6136676.0
2010-09-27 10:30:00	AAPL	Stock	10.4746	10.4768	10.4589	10.4746	6000568.0
2010-09-27 10:35:00	AAPL	Stock	10.475	10.4857	10.4607	10.4714	6757884.0
2010-09-27 10:40:00	AAPL	Stock	10.4718	10.5029	10.4661	10.5029	10260460.0
2010-09-27 10:45:00	AAPL	Stock	10.5029	10.525	10.4846	10.485	11540788.0

> showing 50 of 317,330 rows — these rows as CSV

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