PREVIEW / stock_5min / 2009-04-06

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-06.parquet
  size:    4.4 MB
  rows:    306,428
  symbols: 3,303

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-04-06 07:05:00	AAPL	Stock	4.1768	4.1768	4.1768	4.1768	70000.0
2009-04-06 07:10:00	AAPL	Stock	4.1768	4.1768	4.1768	4.1768	28000.0
2009-04-06 07:15:00	AAPL	Stock	4.1768	4.1768	4.1768	4.1768	8400.0
2009-04-06 07:20:00	AAPL	Stock	4.1768	4.1768	4.1768	4.1768	31920.0
2009-04-06 07:30:00	AAPL	Stock	4.1607	4.1607	4.1532	4.1532	42000.0
2009-04-06 07:35:00	AAPL	Stock	4.1557	4.1557	4.1557	4.1557	16800.0
2009-04-06 07:40:00	AAPL	Stock	4.1454	4.1454	4.1454	4.1454	14000.0
2009-04-06 07:45:00	AAPL	Stock	4.1557	4.1557	4.1557	4.1557	2800.0
2009-04-06 07:55:00	AAPL	Stock	4.1454	4.1454	4.1454	4.1454	28000.0
2009-04-06 08:00:00	AAPL	Stock	4.1454	4.1482	4.1357	4.1357	77308.0
2009-04-06 08:05:00	AAPL	Stock	4.1339	4.1339	4.1321	4.1321	35000.0
2009-04-06 08:10:00	AAPL	Stock	4.1321	4.1339	4.1071	4.1304	137200.0
2009-04-06 08:15:00	AAPL	Stock	4.1218	4.1286	4.1218	4.1232	42000.0
2009-04-06 08:20:00	AAPL	Stock	4.1232	4.1232	4.1075	4.1139	207592.0
2009-04-06 08:25:00	AAPL	Stock	4.1143	4.1179	4.1071	4.1161	196812.0
2009-04-06 08:30:00	AAPL	Stock	4.1154	4.1154	4.1079	4.1129	88564.0
2009-04-06 08:35:00	AAPL	Stock	4.1107	4.1125	4.1082	4.1114	64932.0
2009-04-06 08:40:00	AAPL	Stock	4.1111	4.1111	4.1071	4.1071	158060.0
2009-04-06 08:45:00	AAPL	Stock	4.1068	4.1079	4.1068	4.1071	20160.0
2009-04-06 08:50:00	AAPL	Stock	4.1071	4.1071	4.1068	4.1071	53900.0
2009-04-06 08:55:00	AAPL	Stock	4.1096	4.1107	4.1089	4.1107	75908.0
2009-04-06 09:00:00	AAPL	Stock	4.1104	4.1143	4.1104	4.1107	57120.0
2009-04-06 09:05:00	AAPL	Stock	4.1111	4.1111	4.1071	4.1071	91028.0
2009-04-06 09:10:00	AAPL	Stock	4.1071	4.1071	4.1036	4.1039	54096.0
2009-04-06 09:15:00	AAPL	Stock	4.1025	4.1039	4.0975	4.0975	85932.0
2009-04-06 09:20:00	AAPL	Stock	4.1004	4.1018	4.1004	4.1018	16800.0
2009-04-06 09:25:00	AAPL	Stock	4.1029	4.1071	4.1004	4.105	182336.0
2009-04-06 09:30:00	AAPL	Stock	4.105	4.1157	4.1	4.1114	18810932.0
2009-04-06 09:35:00	AAPL	Stock	4.1114	4.1193	4.0857	4.0893	15089228.0
2009-04-06 09:40:00	AAPL	Stock	4.0886	4.0921	4.0718	4.0868	14025788.0
2009-04-06 09:45:00	AAPL	Stock	4.0868	4.0939	4.0732	4.0739	10263708.0
2009-04-06 09:50:00	AAPL	Stock	4.0746	4.0793	4.0643	4.075	11548124.0
2009-04-06 09:55:00	AAPL	Stock	4.0749	4.0843	4.0736	4.0754	10959788.0
2009-04-06 10:00:00	AAPL	Stock	4.0763	4.0979	4.0736	4.0975	9331168.0
2009-04-06 10:05:00	AAPL	Stock	4.0979	4.1029	4.09	4.0982	9944256.0
2009-04-06 10:10:00	AAPL	Stock	4.0975	4.0989	4.0696	4.0718	9928688.0
2009-04-06 10:15:00	AAPL	Stock	4.0725	4.0786	4.06	4.0746	10532228.0
2009-04-06 10:20:00	AAPL	Stock	4.0754	4.0771	4.0654	4.0711	6339648.0
2009-04-06 10:25:00	AAPL	Stock	4.0714	4.075	4.0525	4.0576	9576448.0
2009-04-06 10:30:00	AAPL	Stock	4.0579	4.0589	4.0504	4.0581	7111244.0
2009-04-06 10:35:00	AAPL	Stock	4.0582	4.0686	4.0546	4.0661	4050592.0
2009-04-06 10:40:00	AAPL	Stock	4.0654	4.0718	4.0629	4.0632	5246192.0
2009-04-06 10:45:00	AAPL	Stock	4.0636	4.0714	4.0564	4.0689	5589332.0
2009-04-06 10:50:00	AAPL	Stock	4.0693	4.0764	4.0679	4.0718	6354068.0
2009-04-06 10:55:00	AAPL	Stock	4.0718	4.0739	4.0582	4.06	5306672.0
2009-04-06 11:00:00	AAPL	Stock	4.0596	4.0629	4.0518	4.0561	5890808.0
2009-04-06 11:05:00	AAPL	Stock	4.0554	4.0589	4.0457	4.0579	5477500.0
2009-04-06 11:10:00	AAPL	Stock	4.0586	4.0646	4.0543	4.0629	3928988.0
2009-04-06 11:15:00	AAPL	Stock	4.0636	4.0746	4.0604	4.0664	4858392.0
2009-04-06 11:20:00	AAPL	Stock	4.0664	4.0664	4.0579	4.0596	3398444.0

> showing 50 of 306,428 rows — these rows as CSV

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