PREVIEW / stock_5min / 2009-01-16

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-01-16.parquet
  size:    4.4 MB
  rows:    303,955
  symbols: 3,309

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
2009-01-16 05:05:00	AAPL	Stock	3.0336	3.0336	3.0336	3.0336	2800.0
2009-01-16 06:50:00	AAPL	Stock	3.0318	3.0336	3.0318	3.0336	11200.0
2009-01-16 07:00:00	AAPL	Stock	3.0246	3.0246	3.0143	3.0143	18200.0
2009-01-16 07:20:00	AAPL	Stock	3.0171	3.0171	3.0171	3.0171	2800.0
2009-01-16 07:25:00	AAPL	Stock	3.0179	3.0275	3.0179	3.0179	13328.0
2009-01-16 07:30:00	AAPL	Stock	3.0214	3.025	3.0143	3.0143	21000.0
2009-01-16 07:35:00	AAPL	Stock	3.0114	3.0114	3.0114	3.0114	8400.0
2009-01-16 07:45:00	AAPL	Stock	3.005	3.0139	2.9993	3.0139	127400.0
2009-01-16 07:55:00	AAPL	Stock	3.0004	3.0004	3.0	3.0	5600.0
2009-01-16 08:00:00	AAPL	Stock	3.0	3.01	3.0	3.0	176120.0
2009-01-16 08:05:00	AAPL	Stock	3.0	3.0	2.9939	2.9964	90468.0
2009-01-16 08:10:00	AAPL	Stock	2.9964	2.9964	2.9939	2.9954	103600.0
2009-01-16 08:15:00	AAPL	Stock	2.9929	2.9964	2.9929	2.9946	76888.0
2009-01-16 08:20:00	AAPL	Stock	2.9964	2.9964	2.9929	2.9957	40880.0
2009-01-16 08:25:00	AAPL	Stock	2.9964	2.9982	2.9961	2.9979	201628.0
2009-01-16 08:30:00	AAPL	Stock	2.9996	3.0036	2.9979	3.0011	140756.0
2009-01-16 08:35:00	AAPL	Stock	3.0	3.0	2.9929	2.9929	326928.0
2009-01-16 08:40:00	AAPL	Stock	2.9914	2.9979	2.9911	2.9957	111580.0
2009-01-16 08:45:00	AAPL	Stock	2.9964	3.0	2.9921	2.9964	277648.0
2009-01-16 08:50:00	AAPL	Stock	2.9964	3.0011	2.9954	2.9964	204400.0
2009-01-16 08:55:00	AAPL	Stock	2.9943	2.9964	2.9929	2.9961	115108.0
2009-01-16 09:00:00	AAPL	Stock	2.9961	3.0011	2.9961	3.0011	160944.0
2009-01-16 09:05:00	AAPL	Stock	3.0018	3.0036	3.0011	3.0025	128520.0
2009-01-16 09:10:00	AAPL	Stock	3.0036	3.0096	3.0036	3.0075	208656.0
2009-01-16 09:15:00	AAPL	Stock	3.005	3.0107	3.0014	3.0071	242200.0
2009-01-16 09:20:00	AAPL	Stock	3.0071	3.0071	3.0046	3.0054	48440.0
2009-01-16 09:25:00	AAPL	Stock	3.0046	3.0107	3.0004	3.01	332472.0
2009-01-16 09:30:00	AAPL	Stock	3.0104	3.0136	2.9429	2.9446	51763432.0
2009-01-16 09:35:00	AAPL	Stock	2.9446	2.9496	2.9289	2.9396	33568584.0
2009-01-16 09:40:00	AAPL	Stock	2.94	2.9546	2.9314	2.9468	19637744.0
2009-01-16 09:45:00	AAPL	Stock	2.9468	2.9571	2.9329	2.9343	20923056.0
2009-01-16 09:50:00	AAPL	Stock	2.9339	2.9414	2.925	2.9321	18558708.0
2009-01-16 09:55:00	AAPL	Stock	2.9318	2.9354	2.9161	2.9175	17018792.0
2009-01-16 10:00:00	AAPL	Stock	2.9175	2.9264	2.9125	2.9211	15064392.0
2009-01-16 10:05:00	AAPL	Stock	2.9225	2.9282	2.9021	2.9025	15789900.0
2009-01-16 10:10:00	AAPL	Stock	2.9025	2.9043	2.8868	2.9	26734372.0
2009-01-16 10:15:00	AAPL	Stock	2.9	2.9004	2.8839	2.8879	19868884.0
2009-01-16 10:20:00	AAPL	Stock	2.8882	2.8932	2.8771	2.8914	17339224.0
2009-01-16 10:25:00	AAPL	Stock	2.8911	2.9021	2.8825	2.8957	17469732.0
2009-01-16 10:30:00	AAPL	Stock	2.8954	2.9093	2.8907	2.9021	14662116.0
2009-01-16 10:35:00	AAPL	Stock	2.9014	2.9107	2.8943	2.9043	14741916.0
2009-01-16 10:40:00	AAPL	Stock	2.9046	2.9046	2.895	2.8989	8342852.0
2009-01-16 10:45:00	AAPL	Stock	2.8993	2.9089	2.895	2.8975	12777352.0
2009-01-16 10:50:00	AAPL	Stock	2.8971	2.9071	2.89	2.8996	13422444.0
2009-01-16 10:55:00	AAPL	Stock	2.9004	2.9032	2.8861	2.8918	9081072.0
2009-01-16 11:00:00	AAPL	Stock	2.8921	2.8921	2.8811	2.8843	9547076.0
2009-01-16 11:05:00	AAPL	Stock	2.8846	2.8864	2.8736	2.8814	13063736.0
2009-01-16 11:10:00	AAPL	Stock	2.8811	2.8857	2.8714	2.8804	11807488.0
2009-01-16 11:15:00	AAPL	Stock	2.88	2.8889	2.8725	2.8864	8950676.0
2009-01-16 11:20:00	AAPL	Stock	2.885	2.9	2.8848	2.9	11434192.0

> showing 50 of 303,955 rows — these rows as CSV

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