PREVIEW / stock_5min / 2012-03-14

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-03-14.parquet
  size:    4.9 MB
  rows:    326,317
  symbols: 3,533

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-03-14 04:00:00	AAPL	Stock	20.3371	20.3396	20.3371	20.3382	19600.0
2012-03-14 04:05:00	AAPL	Stock	20.3461	20.3593	20.3411	20.3593	31640.0
2012-03-14 04:10:00	AAPL	Stock	20.3889	20.3889	20.3889	20.3889	2800.0
2012-03-14 04:15:00	AAPL	Stock	20.3914	20.3914	20.3611	20.3611	6160.0
2012-03-14 04:20:00	AAPL	Stock	20.3825	20.3825	20.3825	20.3825	14000.0
2012-03-14 04:25:00	AAPL	Stock	20.3829	20.3929	20.3825	20.3825	30800.0
2012-03-14 04:30:00	AAPL	Stock	20.3825	20.3825	20.3825	20.3825	8260.0
2012-03-14 04:35:00	AAPL	Stock	20.4025	20.4036	20.4025	20.4036	5600.0
2012-03-14 04:40:00	AAPL	Stock	20.4339	20.4339	20.4339	20.4339	2800.0
2012-03-14 04:50:00	AAPL	Stock	20.4464	20.4607	20.4321	20.4321	53200.0
2012-03-14 04:55:00	AAPL	Stock	20.4329	20.4329	20.4325	20.4325	12992.0
2012-03-14 05:00:00	AAPL	Stock	20.4604	20.4643	20.4604	20.4643	42056.0
2012-03-14 05:05:00	AAPL	Stock	20.5118	20.5118	20.4821	20.4821	27300.0
2012-03-14 05:10:00	AAPL	Stock	20.4993	20.4993	20.4989	20.4993	8400.0
2012-03-14 05:20:00	AAPL	Stock	20.4946	20.5286	20.4929	20.5179	59416.0
2012-03-14 05:25:00	AAPL	Stock	20.5304	20.5357	20.5107	20.5107	33292.0
2012-03-14 05:30:00	AAPL	Stock	20.5107	20.5107	20.4982	20.5	61600.0
2012-03-14 05:35:00	AAPL	Stock	20.4964	20.5061	20.4914	20.4914	16800.0
2012-03-14 05:40:00	AAPL	Stock	20.5	20.5143	20.4914	20.4914	31444.0
2012-03-14 05:45:00	AAPL	Stock	20.5	20.5	20.4821	20.4821	100128.0
2012-03-14 05:55:00	AAPL	Stock	20.4821	20.4821	20.4821	20.4821	8400.0
2012-03-14 06:00:00	AAPL	Stock	20.4821	20.4821	20.4821	20.4821	14000.0
2012-03-14 06:05:00	AAPL	Stock	20.4821	20.4821	20.4821	20.4821	10360.0
2012-03-14 06:10:00	AAPL	Stock	20.4821	20.5	20.4821	20.5	53200.0
2012-03-14 06:15:00	AAPL	Stock	20.5	20.5	20.5	20.5	73360.0
2012-03-14 06:20:00	AAPL	Stock	20.4964	20.4964	20.4964	20.4964	8400.0
2012-03-14 06:25:00	AAPL	Stock	20.5	20.5	20.5	20.5	11200.0
2012-03-14 06:30:00	AAPL	Stock	20.5089	20.5132	20.5089	20.5089	18200.0
2012-03-14 06:35:00	AAPL	Stock	20.5071	20.5071	20.5071	20.5071	2800.0
2012-03-14 06:40:00	AAPL	Stock	20.5339	20.5536	20.5339	20.5429	95200.0
2012-03-14 06:45:00	AAPL	Stock	20.5396	20.5429	20.5243	20.5243	48664.0
2012-03-14 06:50:00	AAPL	Stock	20.5429	20.5429	20.5404	20.5429	60200.0
2012-03-14 06:55:00	AAPL	Stock	20.5432	20.5536	20.5432	20.5432	53480.0
2012-03-14 07:00:00	AAPL	Stock	20.5464	20.5675	20.5268	20.5675	166824.0
2012-03-14 07:05:00	AAPL	Stock	20.5532	20.5536	20.5304	20.5357	164472.0
2012-03-14 07:10:00	AAPL	Stock	20.5357	20.5425	20.5236	20.5271	207480.0
2012-03-14 07:15:00	AAPL	Stock	20.5357	20.5464	20.5282	20.5282	175224.0
2012-03-14 07:20:00	AAPL	Stock	20.5304	20.5371	20.5179	20.5179	173488.0
2012-03-14 07:25:00	AAPL	Stock	20.5179	20.5179	20.4979	20.4982	189532.0
2012-03-14 07:30:00	AAPL	Stock	20.5004	20.5086	20.4839	20.5086	264264.0
2012-03-14 07:35:00	AAPL	Stock	20.5021	20.5082	20.49	20.4996	469308.0
2012-03-14 07:40:00	AAPL	Stock	20.495	20.495	20.4436	20.4536	561176.0
2012-03-14 07:45:00	AAPL	Stock	20.4518	20.4643	20.4486	20.4564	381220.0
2012-03-14 07:50:00	AAPL	Stock	20.4614	20.4821	20.4507	20.4732	275492.0
2012-03-14 07:55:00	AAPL	Stock	20.4782	20.4921	20.4579	20.4629	199556.0
2012-03-14 08:00:00	AAPL	Stock	20.4643	20.5536	20.45	20.4893	1211336.0
2012-03-14 08:05:00	AAPL	Stock	20.4893	20.5154	20.4893	20.5125	971236.0
2012-03-14 08:10:00	AAPL	Stock	20.5139	20.5239	20.5071	20.5086	648060.0
2012-03-14 08:15:00	AAPL	Stock	20.5104	20.5304	20.5086	20.5268	786268.0
2012-03-14 08:20:00	AAPL	Stock	20.5275	20.5393	20.5179	20.5382	831376.0

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

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