PREVIEW / stock_5min / 2011-04-27

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-27.parquet
  size:    4.8 MB
  rows:    325,260
  symbols: 3,553

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-04-27 04:00:00	AAPL	Stock	12.5039	12.5039	12.45	12.45	6860.0
2011-04-27 04:40:00	AAPL	Stock	12.4861	12.4861	12.4861	12.4861	2800.0
2011-04-27 04:50:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-04-27 05:25:00	AAPL	Stock	12.5	12.5	12.5	12.5	8400.0
2011-04-27 05:30:00	AAPL	Stock	12.5	12.5143	12.5	12.5143	8400.0
2011-04-27 05:40:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-27 05:45:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-27 05:55:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-27 06:45:00	AAPL	Stock	12.5139	12.5154	12.5139	12.5154	36400.0
2011-04-27 07:05:00	AAPL	Stock	12.5114	12.5114	12.5114	12.5114	2800.0
2011-04-27 07:10:00	AAPL	Stock	12.5107	12.5214	12.5107	12.5214	19600.0
2011-04-27 07:15:00	AAPL	Stock	12.5261	12.5268	12.5261	12.5268	14000.0
2011-04-27 07:20:00	AAPL	Stock	12.5179	12.5179	12.5179	12.5179	4032.0
2011-04-27 07:30:00	AAPL	Stock	12.5357	12.5357	12.5357	12.5357	5600.0
2011-04-27 07:35:00	AAPL	Stock	12.5357	12.5429	12.5357	12.5429	5600.0
2011-04-27 07:50:00	AAPL	Stock	12.5389	12.5389	12.5389	12.5389	2800.0
2011-04-27 08:00:00	AAPL	Stock	12.535	12.5357	12.5179	12.5193	102172.0
2011-04-27 08:05:00	AAPL	Stock	12.5193	12.5332	12.5179	12.5271	80360.0
2011-04-27 08:10:00	AAPL	Stock	12.5271	12.5393	12.5271	12.5393	134596.0
2011-04-27 08:15:00	AAPL	Stock	12.5429	12.5554	12.5429	12.5432	233408.0
2011-04-27 08:20:00	AAPL	Stock	12.5443	12.5443	12.5411	12.5411	91840.0
2011-04-27 08:25:00	AAPL	Stock	12.5357	12.5454	12.5357	12.5393	39088.0
2011-04-27 08:30:00	AAPL	Stock	12.5443	12.5561	12.5396	12.5518	450268.0
2011-04-27 08:35:00	AAPL	Stock	12.5514	12.5661	12.5514	12.5657	326760.0
2011-04-27 08:40:00	AAPL	Stock	12.565	12.5671	12.5596	12.5661	282800.0
2011-04-27 08:45:00	AAPL	Stock	12.5657	12.5689	12.5611	12.5621	165788.0
2011-04-27 08:50:00	AAPL	Stock	12.5696	12.5786	12.5646	12.5786	327180.0
2011-04-27 08:55:00	AAPL	Stock	12.5775	12.5775	12.5668	12.5689	77700.0
2011-04-27 09:00:00	AAPL	Stock	12.5668	12.575	12.5668	12.5714	71820.0
2011-04-27 09:05:00	AAPL	Stock	12.5689	12.5714	12.5671	12.5686	114800.0
2011-04-27 09:10:00	AAPL	Stock	12.5682	12.5711	12.5596	12.5643	92624.0
2011-04-27 09:15:00	AAPL	Stock	12.5664	12.5714	12.5639	12.5639	96264.0
2011-04-27 09:20:00	AAPL	Stock	12.5636	12.5711	12.5636	12.5689	39816.0
2011-04-27 09:25:00	AAPL	Stock	12.5679	12.5804	12.5589	12.5771	561204.0
2011-04-27 09:30:00	AAPL	Stock	12.5771	12.5839	12.5254	12.5361	10132724.0
2011-04-27 09:35:00	AAPL	Stock	12.5379	12.5443	12.515	12.5213	7764960.0
2011-04-27 09:40:00	AAPL	Stock	12.5214	12.5493	12.5107	12.5411	6896204.0
2011-04-27 09:45:00	AAPL	Stock	12.5393	12.5604	12.5329	12.5396	6747944.0
2011-04-27 09:50:00	AAPL	Stock	12.5396	12.5429	12.5207	12.5211	5404588.0
2011-04-27 09:55:00	AAPL	Stock	12.5205	12.5279	12.5021	12.5111	5650260.0
2011-04-27 10:00:00	AAPL	Stock	12.5104	12.5118	12.4754	12.4775	6211912.0
2011-04-27 10:05:00	AAPL	Stock	12.4777	12.4871	12.4661	12.4793	6435604.0
2011-04-27 10:10:00	AAPL	Stock	12.4789	12.4811	12.4207	12.4325	13364736.0
2011-04-27 10:15:00	AAPL	Stock	12.4325	12.4407	12.4071	12.4293	9489172.0
2011-04-27 10:20:00	AAPL	Stock	12.4304	12.455	12.425	12.4414	6916504.0
2011-04-27 10:25:00	AAPL	Stock	12.4425	12.4621	12.4382	12.4461	4312756.0
2011-04-27 10:30:00	AAPL	Stock	12.4475	12.45	12.4218	12.4243	5312328.0
2011-04-27 10:35:00	AAPL	Stock	12.4246	12.4339	12.4114	12.4254	5332040.0
2011-04-27 10:40:00	AAPL	Stock	12.4243	12.4243	12.3964	12.4104	7378420.0
2011-04-27 10:45:00	AAPL	Stock	12.4112	12.4167	12.4029	12.4164	3918320.0

> showing 50 of 325,260 rows — these rows as CSV

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