PREVIEW / stock_5min / 2009-06-01

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-06-01.parquet
  size:    4.9 MB
  rows:    337,398
  symbols: 3,347

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-06-01 04:15:00	AAPL	Stock	4.8457	4.8457	4.8457	4.8457	4200.0
2009-06-01 04:40:00	AAPL	Stock	4.8643	4.8643	4.8643	4.8643	2800.0
2009-06-01 06:10:00	AAPL	Stock	4.9018	4.9018	4.9018	4.9018	2800.0
2009-06-01 07:00:00	AAPL	Stock	4.9107	4.9146	4.9107	4.9146	11200.0
2009-06-01 07:05:00	AAPL	Stock	4.9146	4.9146	4.9143	4.9143	7700.0
2009-06-01 07:10:00	AAPL	Stock	4.9107	4.9107	4.9107	4.9107	11200.0
2009-06-01 07:15:00	AAPL	Stock	4.9111	4.9143	4.9075	4.9143	16800.0
2009-06-01 07:20:00	AAPL	Stock	4.9107	4.9107	4.9107	4.9107	13720.0
2009-06-01 07:25:00	AAPL	Stock	4.9075	4.9107	4.9075	4.9075	14000.0
2009-06-01 07:30:00	AAPL	Stock	4.9075	4.9075	4.9071	4.9071	11200.0
2009-06-01 07:40:00	AAPL	Stock	4.8946	4.8946	4.8946	4.8946	2800.0
2009-06-01 07:45:00	AAPL	Stock	4.9	4.9	4.9	4.9	28000.0
2009-06-01 07:50:00	AAPL	Stock	4.8982	4.8982	4.8982	4.8982	14000.0
2009-06-01 07:55:00	AAPL	Stock	4.9036	4.9036	4.9036	4.9036	3360.0
2009-06-01 08:00:00	AAPL	Stock	4.8357	4.9075	4.8357	4.9075	185220.0
2009-06-01 08:05:00	AAPL	Stock	4.9054	4.9089	4.9036	4.9089	115080.0
2009-06-01 08:10:00	AAPL	Stock	4.9043	4.9125	4.9039	4.9061	114660.0
2009-06-01 08:15:00	AAPL	Stock	4.9068	4.9096	4.9068	4.9071	60200.0
2009-06-01 08:20:00	AAPL	Stock	4.9071	4.9107	4.9071	4.9107	101220.0
2009-06-01 08:25:00	AAPL	Stock	4.9104	4.9104	4.9071	4.9071	171696.0
2009-06-01 08:30:00	AAPL	Stock	4.9089	4.9107	4.9054	4.9089	159320.0
2009-06-01 08:35:00	AAPL	Stock	4.9071	4.9089	4.9036	4.9036	64120.0
2009-06-01 08:40:00	AAPL	Stock	4.905	4.9089	4.905	4.9089	113400.0
2009-06-01 08:45:00	AAPL	Stock	4.9089	4.9089	4.9018	4.9061	143220.0
2009-06-01 08:50:00	AAPL	Stock	4.9064	4.9089	4.9064	4.9082	75600.0
2009-06-01 08:55:00	AAPL	Stock	4.9089	4.9093	4.9089	4.9089	46116.0
2009-06-01 09:00:00	AAPL	Stock	4.9086	4.9086	4.9079	4.9079	66640.0
2009-06-01 09:05:00	AAPL	Stock	4.9086	4.9111	4.9071	4.9111	333536.0
2009-06-01 09:10:00	AAPL	Stock	4.9111	4.9111	4.8746	4.8757	663432.0
2009-06-01 09:15:00	AAPL	Stock	4.8707	4.8839	4.8536	4.8714	633416.0
2009-06-01 09:20:00	AAPL	Stock	4.8714	4.8854	4.8504	4.8818	3417064.0
2009-06-01 09:25:00	AAPL	Stock	4.8804	4.8818	4.8661	4.8743	208628.0
2009-06-01 09:30:00	AAPL	Stock	4.8739	4.8996	4.8571	4.8971	23585828.0
2009-06-01 09:35:00	AAPL	Stock	4.8975	4.9129	4.8929	4.9025	12789028.0
2009-06-01 09:40:00	AAPL	Stock	4.9021	4.94	4.9004	4.9329	16053520.0
2009-06-01 09:45:00	AAPL	Stock	4.9329	4.9346	4.9136	4.9182	9935828.0
2009-06-01 09:50:00	AAPL	Stock	4.9182	4.9286	4.9143	4.9207	10791256.0
2009-06-01 09:55:00	AAPL	Stock	4.9211	4.9286	4.9111	4.9243	8317400.0
2009-06-01 10:00:00	AAPL	Stock	4.9243	4.9446	4.9243	4.9407	12899348.0
2009-06-01 10:05:00	AAPL	Stock	4.9411	4.9425	4.9289	4.9339	5937400.0
2009-06-01 10:10:00	AAPL	Stock	4.9325	4.9407	4.9286	4.9407	4334988.0
2009-06-01 10:15:00	AAPL	Stock	4.9404	4.9514	4.9404	4.9496	6002920.0
2009-06-01 10:20:00	AAPL	Stock	4.9496	4.9529	4.9421	4.9475	5549348.0
2009-06-01 10:25:00	AAPL	Stock	4.9481	4.9571	4.9481	4.9511	7129584.0
2009-06-01 10:30:00	AAPL	Stock	4.9504	4.9546	4.9439	4.9454	6685028.0
2009-06-01 10:35:00	AAPL	Stock	4.9454	4.9607	4.9414	4.96	6977096.0
2009-06-01 10:40:00	AAPL	Stock	4.9604	4.9607	4.9507	4.9546	5128872.0
2009-06-01 10:45:00	AAPL	Stock	4.955	4.9596	4.9504	4.9529	5205956.0
2009-06-01 10:50:00	AAPL	Stock	4.9536	4.9604	4.9518	4.9532	3874500.0
2009-06-01 10:55:00	AAPL	Stock	4.9529	4.9596	4.9521	4.9568	3707088.0

> showing 50 of 337,398 rows — these rows as CSV

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