PREVIEW / stock_5min / 2010-04-27

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-04-27.parquet
  size:    5.1 MB
  rows:    340,362
  symbols: 3,505

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-04-27 04:30:00	AAPL	Stock	9.5807	9.5807	9.5807	9.5807	2800.0
2010-04-27 05:05:00	AAPL	Stock	9.5786	9.5786	9.5786	9.5786	2800.0
2010-04-27 05:20:00	AAPL	Stock	9.5911	9.5911	9.5786	9.5786	8400.0
2010-04-27 05:30:00	AAPL	Stock	9.5786	9.5786	9.5554	9.5554	8400.0
2010-04-27 05:45:00	AAPL	Stock	9.5539	9.5539	9.5539	9.5539	5600.0
2010-04-27 05:50:00	AAPL	Stock	9.5521	9.5521	9.5521	9.5521	2800.0
2010-04-27 05:55:00	AAPL	Stock	9.5446	9.5446	9.5446	9.5446	2800.0
2010-04-27 06:05:00	AAPL	Stock	9.5379	9.5379	9.5	9.5	25200.0
2010-04-27 06:15:00	AAPL	Stock	9.5125	9.5136	9.5125	9.5136	8400.0
2010-04-27 06:20:00	AAPL	Stock	9.4932	9.4932	9.4932	9.4932	9520.0
2010-04-27 06:25:00	AAPL	Stock	9.5175	9.5175	9.4932	9.4932	8400.0
2010-04-27 06:30:00	AAPL	Stock	9.5261	9.5268	9.5257	9.5268	67200.0
2010-04-27 06:35:00	AAPL	Stock	9.5268	9.5268	9.5268	9.5268	11200.0
2010-04-27 06:40:00	AAPL	Stock	9.5179	9.5204	9.5179	9.5179	11200.0
2010-04-27 06:45:00	AAPL	Stock	9.5179	9.5179	9.5179	9.5179	2800.0
2010-04-27 06:55:00	AAPL	Stock	9.5179	9.5179	9.5114	9.5114	11116.0
2010-04-27 07:00:00	AAPL	Stock	9.525	9.5286	9.5146	9.5286	20160.0
2010-04-27 07:05:00	AAPL	Stock	9.5375	9.5375	9.5375	9.5375	2800.0
2010-04-27 07:15:00	AAPL	Stock	9.5425	9.5425	9.5411	9.5411	5600.0
2010-04-27 07:20:00	AAPL	Stock	9.5425	9.5536	9.5425	9.55	111160.0
2010-04-27 07:35:00	AAPL	Stock	9.5479	9.5561	9.5464	9.5464	37800.0
2010-04-27 07:40:00	AAPL	Stock	9.5464	9.5464	9.5464	9.5464	30800.0
2010-04-27 07:45:00	AAPL	Stock	9.5432	9.55	9.5357	9.55	111300.0
2010-04-27 07:50:00	AAPL	Stock	9.55	9.55	9.5429	9.5429	16800.0
2010-04-27 07:55:00	AAPL	Stock	9.5429	9.5571	9.5429	9.5571	18200.0
2010-04-27 08:00:00	AAPL	Stock	9.5479	9.5661	9.5446	9.5589	309456.0
2010-04-27 08:05:00	AAPL	Stock	9.5643	9.5643	9.5607	9.5611	95648.0
2010-04-27 08:10:00	AAPL	Stock	9.5639	9.5639	9.5536	9.5536	102732.0
2010-04-27 08:15:00	AAPL	Stock	9.5489	9.5575	9.5489	9.5575	81200.0
2010-04-27 08:20:00	AAPL	Stock	9.5568	9.5568	9.5536	9.5536	45164.0
2010-04-27 08:25:00	AAPL	Stock	9.5536	9.5604	9.5536	9.5589	14000.0
2010-04-27 08:30:00	AAPL	Stock	9.5607	9.5657	9.5593	9.5657	114380.0
2010-04-27 08:35:00	AAPL	Stock	9.5611	9.5611	9.5554	9.5571	53200.0
2010-04-27 08:40:00	AAPL	Stock	9.555	9.5589	9.555	9.5554	50400.0
2010-04-27 08:45:00	AAPL	Stock	9.5539	9.555	9.5482	9.5518	216832.0
2010-04-27 08:50:00	AAPL	Stock	9.5518	9.5568	9.5514	9.555	49840.0
2010-04-27 08:55:00	AAPL	Stock	9.5568	9.5654	9.5568	9.5614	124600.0
2010-04-27 09:00:00	AAPL	Stock	9.5607	9.5632	9.5589	9.5607	42000.0
2010-04-27 09:05:00	AAPL	Stock	9.5604	9.5604	9.545	9.5489	165956.0
2010-04-27 09:10:00	AAPL	Stock	9.5468	9.5536	9.5468	9.552	63700.0
2010-04-27 09:15:00	AAPL	Stock	9.5514	9.5514	9.547	9.5504	71680.0
2010-04-27 09:20:00	AAPL	Stock	9.5468	9.5489	9.5452	9.5452	39592.0
2010-04-27 09:25:00	AAPL	Stock	9.55	9.5568	9.5432	9.5443	328216.0
2010-04-27 09:30:00	AAPL	Stock	9.5454	9.5496	9.5239	9.535	18898180.0
2010-04-27 09:35:00	AAPL	Stock	9.535	9.5366	9.5093	9.5164	13610296.0
2010-04-27 09:40:00	AAPL	Stock	9.5164	9.549	9.5118	9.5379	14773136.0
2010-04-27 09:45:00	AAPL	Stock	9.5379	9.5461	9.5243	9.5318	11498340.0
2010-04-27 09:50:00	AAPL	Stock	9.5314	9.5318	9.4982	9.5187	14589288.0
2010-04-27 09:55:00	AAPL	Stock	9.5189	9.5368	9.5098	9.5354	9727956.0
2010-04-27 10:00:00	AAPL	Stock	9.5357	9.5539	9.5146	9.5229	11454464.0

> showing 50 of 340,362 rows — these rows as CSV

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