PREVIEW / stock_5min / 2013-05-23

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-05-23.parquet
  size:    5.1 MB
  rows:    339,505
  symbols: 3,531

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
2013-05-23 04:00:00	AAPL	Stock	15.7857	15.7857	15.5714	15.6071	19600.0
2013-05-23 04:05:00	AAPL	Stock	15.5786	15.5786	15.5786	15.5786	2800.0
2013-05-23 04:10:00	AAPL	Stock	15.595	15.595	15.5789	15.5789	12600.0
2013-05-23 04:20:00	AAPL	Stock	15.5786	15.5786	15.5714	15.5718	25200.0
2013-05-23 04:30:00	AAPL	Stock	15.5718	15.5718	15.5714	15.5714	17416.0
2013-05-23 04:45:00	AAPL	Stock	15.5696	15.57	15.5696	15.57	8400.0
2013-05-23 05:05:00	AAPL	Stock	15.5539	15.5539	15.5539	15.5539	15960.0
2013-05-23 05:10:00	AAPL	Stock	15.5464	15.5464	15.5464	15.5464	6496.0
2013-05-23 05:15:00	AAPL	Stock	15.5436	15.5436	15.5429	15.5429	28000.0
2013-05-23 05:20:00	AAPL	Stock	15.5429	15.5429	15.5282	15.5357	77448.0
2013-05-23 05:25:00	AAPL	Stock	15.5518	15.5518	15.5518	15.5518	2800.0
2013-05-23 05:30:00	AAPL	Stock	15.5518	15.5518	15.5518	15.5518	2800.0
2013-05-23 05:35:00	AAPL	Stock	15.5361	15.5361	15.5036	15.5357	84952.0
2013-05-23 05:40:00	AAPL	Stock	15.5036	15.5179	15.5	15.5179	25424.0
2013-05-23 06:05:00	AAPL	Stock	15.5036	15.5036	15.5036	15.5036	14000.0
2013-05-23 06:20:00	AAPL	Stock	15.5357	15.5357	15.5357	15.5357	6132.0
2013-05-23 06:40:00	AAPL	Stock	15.5482	15.5482	15.5396	15.5396	8400.0
2013-05-23 06:45:00	AAPL	Stock	15.5625	15.5775	15.5607	15.5607	62944.0
2013-05-23 06:50:00	AAPL	Stock	15.5714	15.5821	15.5714	15.5821	18788.0
2013-05-23 06:55:00	AAPL	Stock	15.5904	15.5904	15.575	15.575	16800.0
2013-05-23 07:00:00	AAPL	Stock	15.5671	15.5671	15.5671	15.5671	2800.0
2013-05-23 07:05:00	AAPL	Stock	15.5957	15.6429	15.5957	15.6429	74172.0
2013-05-23 07:10:00	AAPL	Stock	15.6371	15.6421	15.6321	15.6321	31276.0
2013-05-23 07:15:00	AAPL	Stock	15.6346	15.6364	15.6293	15.6293	54040.0
2013-05-23 07:20:00	AAPL	Stock	15.62	15.62	15.6121	15.6121	45696.0
2013-05-23 07:25:00	AAPL	Stock	15.6107	15.6107	15.6107	15.6107	7000.0
2013-05-23 07:30:00	AAPL	Stock	15.6114	15.6114	15.6071	15.6071	70000.0
2013-05-23 07:35:00	AAPL	Stock	15.5911	15.5911	15.5857	15.5857	22400.0
2013-05-23 07:40:00	AAPL	Stock	15.5971	15.5979	15.5893	15.5979	28000.0
2013-05-23 07:45:00	AAPL	Stock	15.6004	15.6071	15.6004	15.6071	74256.0
2013-05-23 07:50:00	AAPL	Stock	15.6125	15.6125	15.5939	15.6107	98000.0
2013-05-23 07:55:00	AAPL	Stock	15.6071	15.6079	15.5943	15.5943	44800.0
2013-05-23 08:00:00	AAPL	Stock	15.6029	15.7143	15.5714	15.6004	581056.0
2013-05-23 08:05:00	AAPL	Stock	15.6036	15.6054	15.5825	15.5839	133084.0
2013-05-23 08:10:00	AAPL	Stock	15.59	15.5968	15.5893	15.5904	79044.0
2013-05-23 08:15:00	AAPL	Stock	15.5932	15.6046	15.5911	15.5982	109984.0
2013-05-23 08:20:00	AAPL	Stock	15.5982	15.6246	15.5946	15.6071	638484.0
2013-05-23 08:25:00	AAPL	Stock	15.6139	15.6429	15.6139	15.625	173572.0
2013-05-23 08:30:00	AAPL	Stock	15.625	15.635	15.6179	15.6254	228256.0
2013-05-23 08:35:00	AAPL	Stock	15.6311	15.6389	15.6254	15.6339	180740.0
2013-05-23 08:40:00	AAPL	Stock	15.6321	15.6321	15.6118	15.6179	154616.0
2013-05-23 08:45:00	AAPL	Stock	15.6111	15.6421	15.6093	15.625	167552.0
2013-05-23 08:50:00	AAPL	Stock	15.6339	15.6482	15.6339	15.6432	773360.0
2013-05-23 08:55:00	AAPL	Stock	15.645	15.6482	15.6104	15.6118	165088.0
2013-05-23 09:00:00	AAPL	Stock	15.6132	15.6304	15.6079	15.6079	395136.0
2013-05-23 09:05:00	AAPL	Stock	15.6079	15.6079	15.5918	15.5929	256452.0
2013-05-23 09:10:00	AAPL	Stock	15.5964	15.6064	15.5932	15.6018	78316.0
2013-05-23 09:15:00	AAPL	Stock	15.5961	15.5961	15.5821	15.5857	356664.0
2013-05-23 09:20:00	AAPL	Stock	15.5864	15.6	15.5821	15.5893	311612.0
2013-05-23 09:25:00	AAPL	Stock	15.5907	15.5907	15.5607	15.5704	641816.0

> showing 50 of 339,505 rows — these rows as CSV

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