PREVIEW / stock_5min / 2012-01-11

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-01-11.parquet
  size:    4.7 MB
  rows:    320,047
  symbols: 3,561

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-01-11 04:00:00	AAPL	Stock	15.1071	15.1071	15.1071	15.1071	2800.0
2012-01-11 06:30:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	2800.0
2012-01-11 07:00:00	AAPL	Stock	15.0557	15.0714	15.0557	15.0714	16632.0
2012-01-11 07:05:00	AAPL	Stock	15.0589	15.0625	15.0589	15.0625	5600.0
2012-01-11 07:15:00	AAPL	Stock	15.0679	15.0679	15.0679	15.0679	14000.0
2012-01-11 07:20:00	AAPL	Stock	15.0625	15.0714	15.0589	15.0714	14000.0
2012-01-11 07:25:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	2800.0
2012-01-11 07:30:00	AAPL	Stock	15.0718	15.0718	15.0714	15.0714	56000.0
2012-01-11 07:45:00	AAPL	Stock	15.0925	15.0946	15.0925	15.0946	8400.0
2012-01-11 07:55:00	AAPL	Stock	15.1029	15.1421	15.1029	15.1071	47600.0
2012-01-11 08:00:00	AAPL	Stock	15.1071	15.1086	15.0768	15.0893	151872.0
2012-01-11 08:05:00	AAPL	Stock	15.0957	15.0957	15.0957	15.0957	140000.0
2012-01-11 08:10:00	AAPL	Stock	15.0911	15.0929	15.0893	15.0896	25200.0
2012-01-11 08:15:00	AAPL	Stock	15.0896	15.1036	15.0896	15.0982	70756.0
2012-01-11 08:20:00	AAPL	Stock	15.09	15.09	15.0643	15.0643	89516.0
2012-01-11 08:25:00	AAPL	Stock	15.0675	15.0675	15.0536	15.0621	50960.0
2012-01-11 08:30:00	AAPL	Stock	15.0682	15.0693	15.0604	15.0604	25200.0
2012-01-11 08:35:00	AAPL	Stock	15.0657	15.0789	15.0657	15.0707	150052.0
2012-01-11 08:40:00	AAPL	Stock	15.0657	15.0821	15.0657	15.08	198324.0
2012-01-11 08:45:00	AAPL	Stock	15.0814	15.0861	15.08	15.0861	30940.0
2012-01-11 08:50:00	AAPL	Stock	15.0804	15.0854	15.0714	15.0854	87360.0
2012-01-11 08:55:00	AAPL	Stock	15.0861	15.0861	15.0786	15.0786	21000.0
2012-01-11 09:00:00	AAPL	Stock	15.0846	15.0857	15.0804	15.0804	61600.0
2012-01-11 09:05:00	AAPL	Stock	15.0796	15.0829	15.0779	15.0814	27440.0
2012-01-11 09:10:00	AAPL	Stock	15.0814	15.0979	15.0814	15.0857	151200.0
2012-01-11 09:15:00	AAPL	Stock	15.0857	15.0886	15.08	15.0861	61600.0
2012-01-11 09:20:00	AAPL	Stock	15.0857	15.0857	15.0768	15.0768	68152.0
2012-01-11 09:25:00	AAPL	Stock	15.0718	15.095	15.0718	15.0821	64092.0
2012-01-11 09:30:00	AAPL	Stock	15.0957	15.0975	15.0146	15.0471	10895752.0
2012-01-11 09:35:00	AAPL	Stock	15.0471	15.0521	14.9893	15.0107	11720660.0
2012-01-11 09:40:00	AAPL	Stock	15.0096	15.0471	14.9957	15.0384	8024184.0
2012-01-11 09:45:00	AAPL	Stock	15.0382	15.0607	15.0375	15.0415	6203344.0
2012-01-11 09:50:00	AAPL	Stock	15.0414	15.0439	15.02	15.0227	3607408.0
2012-01-11 09:55:00	AAPL	Stock	15.0225	15.0304	15.0004	15.0014	3845240.0
2012-01-11 10:00:00	AAPL	Stock	15.002	15.0039	14.9754	14.9975	9311036.0
2012-01-11 10:05:00	AAPL	Stock	14.995	15.0089	14.9893	15.0029	4714276.0
2012-01-11 10:10:00	AAPL	Stock	15.0061	15.0139	14.9914	15.0	2842056.0
2012-01-11 10:15:00	AAPL	Stock	14.9993	15.0179	14.9982	15.01	2179548.0
2012-01-11 10:20:00	AAPL	Stock	15.0125	15.0282	15.0075	15.0232	2538256.0
2012-01-11 10:25:00	AAPL	Stock	15.0232	15.0607	15.0232	15.0418	6072108.0
2012-01-11 10:30:00	AAPL	Stock	15.0404	15.0511	15.03	15.0464	2290680.0
2012-01-11 10:35:00	AAPL	Stock	15.045	15.0614	15.045	15.0596	2526552.0
2012-01-11 10:40:00	AAPL	Stock	15.0611	15.0804	15.0575	15.0589	6097952.0
2012-01-11 10:45:00	AAPL	Stock	15.0589	15.0745	15.0536	15.0543	2647428.0
2012-01-11 10:50:00	AAPL	Stock	15.0543	15.06	15.0429	15.0539	1766856.0
2012-01-11 10:55:00	AAPL	Stock	15.0514	15.0532	15.0368	15.0409	2949716.0
2012-01-11 11:00:00	AAPL	Stock	15.04	15.04	15.0286	15.0293	2506448.0
2012-01-11 11:05:00	AAPL	Stock	15.0307	15.0393	15.0182	15.0207	2958704.0
2012-01-11 11:10:00	AAPL	Stock	15.0189	15.0318	15.0182	15.0264	1764840.0
2012-01-11 11:15:00	AAPL	Stock	15.0264	15.0379	15.0221	15.0321	1162784.0

> showing 50 of 320,047 rows — these rows as CSV

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